IFTA Fuel Tax Calculator & Quarterly Diesel Worksheet

Reconcile diesel fuel use and tax-paid purchases for one International Fuel Tax Agreement reporting quarter. Enter member-jurisdiction miles, all fleet gallons and any nonmember miles to calculate a single fleet MPG. See where the truck fleet owes ordinary tax, earns a base credit or incurs a separate surcharge.

Fleet reporting

Reconcile a diesel IFTA quarter

See where fuel tax is due, where you earned a credit, and how much separate surcharges add.

Quarter and fleet totals

Use one diesel quarter, whole U.S. gallons and one rate pair per jurisdiction. Get final USD rates from the official IFTA quarter matrix. Handle split rates, temporary relief and filing adjustments in your base jurisdiction’s return.

Examples use illustrative rates. Changing the quarter leaves entered rates available to review and edit.

Miles traveled outside member jurisdictions. These contribute to fleet MPG.

Reportable diesel put into all qualified vehicle tanks, regardless of where purchased or whether tax was paid.

Q3 2026 estimated balance: $12.65 due before adjustments.

Fleet and tax summary

Fleet MPG
6.00
3,000 total miles · 500 US gal
Estimated quarter balance
$12.65 due
Ordinary base tax and per-gallon surcharges
Positive base amounts
$0.72
Base credits
-$7.29
Surcharges
$19.22
Member miles
2,000
Taxable miles
1,900
Fleet gallons without credit (US gal)
160

Member jurisdiction rows

Include all member travel and supported purchases. Enter 0 for fields with no amount, including a surcharge that does not apply.

Jurisdiction 1

Include all reportable miles for this member jurisdiction.

Subtract only the exclusions your filing rules allow.

Use supported tax-paid gallons by purchase jurisdiction. Enter 0 if none.

Use the quarter’s official diesel rate, including 0 for a zero-rate jurisdiction.

Use the quarter’s separate surcharge rate on taxable gallons. Enter 0 if none.

Jurisdiction 2

Include all reportable miles for this member jurisdiction.

Subtract only the exclusions your filing rules allow.

Use supported tax-paid gallons by purchase jurisdiction. Enter 0 if none.

Use the quarter’s official diesel rate, including 0 for a zero-rate jurisdiction.

Use the quarter’s separate surcharge rate on taxable gallons. Enter 0 if none.

Jurisdiction balances

Net base tax and surcharge for each entered jurisdiction. Both sides use the same USD scale.
  • Kentucky$19.94 due

  • Tennessee$7.29 credit

Quarter reconciliation ledger

Show all mileage, fuel and tax lines
Gallons are U.S. gallons. Rates are USD per U.S. gallon. Negative amounts are credits.
JurisdictionTotal milesTaxable milesTaxable galTax-paid galNet galBase rateSurcharge rateBase due or creditSurchargeNet
Kentucky1,2001,10018318030.24000.1050$0.72$19.22$19.94
Tennessee800800133160-270.27000.0000-$7.29$0.00-$7.29
Download IFTA worksheet CSV
Show selectable CSV

How to use this calculator

  1. Choose the reporting year and quarter. Collect total diesel fuel placed into the qualified fleet’s tanks across all jurisdictions, including fuel with no eligible tax-paid credit.
  2. Enter nonmember miles once. Add one row per IFTA member jurisdiction with mileage or eligible tax-paid gallons, using the purchase jurisdiction for the gallons.
  3. Enter total and taxable miles, eligible tax-paid gallons, the quarter’s base diesel rate and any separate per-gallon surcharge. Enter zero where a figure does not apply.
  4. Compare the signed jurisdiction chart with the detailed reconciliation. Export the CSV for a cross-check against your base jurisdiction’s filing system.

The Formula

The mathematical logic powering this calculation is:

Total fleet miles = member-jurisdiction total miles + nonmember miles. Fleet MPG = total fleet miles ÷ total diesel gallons for the fleet. Include all reportable fuel placed in qualified vehicles, whether tax-paid or not. Enter whole miles and whole U.S. gallons. Round fleet MPG to two decimals before dividing each member jurisdiction’s taxable miles by MPG. Round that result to whole taxable gallons.

Base due or credit = (taxable gallons − eligible tax-paid gallons) × base rate. Surcharge = taxable gallons × the separate per-gallon surcharge rate. Round each base and surcharge amount to cents, with half cents away from zero. Add the signed base amounts and positive surcharges to find the quarter’s estimated pre-adjustment balance.

This worksheet uses USD, miles and U.S. gallons for one diesel fuel type and one pair of rates per jurisdiction. Choose the matching quarter and use its final USD-per-U.S.-gallon rates, including for Canadian lines already expressed in these units. Refer to your filing jurisdiction for eligibility, conversions, split rates, temporary relief, other fuels, interest, penalties and prior credits. Examples use illustrative rates. A credit is an estimate of the balance before adjustments.

Worked Example

If you input:

  • Reporting year and quarter: Q3 2026 with illustrative rates
  • Nonmember miles: 1,000 miles
  • Total fleet diesel (US gal): 500 gallons
  • Kentucky row: 1,200 total and 1,100 taxable miles, 180 tax-paid gallons, $0.2400 base and $0.1050 surcharge
  • Tennessee row: 800 total and taxable miles, 160 tax-paid gallons, $0.2700 base and no surcharge

Result:

3,000 total miles and 500 gallons give 6.00 MPG. Kentucky reports 183 taxable gallons, $0.72 base due and $19.22 surcharge. Tennessee reports 133 taxable gallons and a $7.29 base credit. The estimated net balance is $12.65 due.

Frequently Asked Questions

Why do I enter both total and taxable miles?

All reportable miles contribute to fleet MPG. Only taxable miles for the selected member jurisdiction determine taxable gallons there. Follow that jurisdiction’s instructions before excluding any miles.

Which gallons count toward fleet MPG and tax-paid credits?

Total fleet gallons reflect all reportable diesel placed into eligible propulsion supply tanks. Jurisdiction tax-paid gallons are only the gallons with an eligible, documented tax paid in that purchase jurisdiction.

Do tax-paid gallons reduce the surcharge?

The modeled per-gallon surcharge uses taxable gallons before deducting eligible tax-paid gallons. Enter any applicable separate surcharge from the official matrix.

Can I report a zero-rate jurisdiction or fuel only?

Enter a zero base rate where the matching official rate is zero. A member jurisdiction with eligible fuel purchases and no reportable miles can have a zero-mile row.

What if a rate changed during the quarter?

Use your base jurisdiction’s split-rate or relief procedure. This worksheet calculates a single base rate and a single surcharge rate per member jurisdiction.

Can I use these numbers to file?

Use the CSV as a reconciliation worksheet alongside your base jurisdiction’s return. The worksheet estimates one diesel quarter before prior credits, penalties and interest. It does not submit a return or determine whether miles or purchases qualify.

Similar Calculators