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.
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
- 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 balances
Kentucky$19.94 due
Tennessee$7.29 credit
Quarter reconciliation ledger
Show all mileage, fuel and tax lines
| Jurisdiction | Total miles | Taxable miles | Taxable gal | Tax-paid gal | Net gal | Base rate | Surcharge rate | Base due or credit | Surcharge | Net |
|---|---|---|---|---|---|---|---|---|---|---|
| Kentucky | 1,200 | 1,100 | 183 | 180 | 3 | 0.2400 | 0.1050 | $0.72 | $19.22 | $19.94 |
| Tennessee | 800 | 800 | 133 | 160 | -27 | 0.2700 | 0.0000 | -$7.29 | $0.00 | -$7.29 |
Show selectable CSV
How to use this calculator
- 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.
- 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.
- 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.
- 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
Fuel Cost Calculator
Calculate the fuel cost and consumption for any road trip or daily commute.
Commute Cost Monthly Calculator
Estimate monthly commuting cost from distance, workdays, fuel economy, and gas price.
Mileage Reimbursement Calculator & Business Trip Ledger
Compare company mileage reimbursement with 2025 and 2026 IRS business benchmarks. Track the July 2026 change, parking, tolls and excluded trips.
