Audit & Recordkeeping · Excel & CSV
IFTA Mileage & Fuel Tax Worksheet
A quarterly IFTA worksheet that organizes miles and fuel by jurisdiction — the per-state data you need to calculate and file your fuel tax return.
Built and reviewed by the FleetOpsClub research team. Print the preview free, or get the editable file by email.
What's included
- Per-jurisdiction rows for miles traveled and fuel purchased
- Columns for taxable miles, taxable gallons, and net tax due/credit
- A fleet MPG calculation that drives the gallons attribution
- Quarter and vehicle identification fields
- Editable spreadsheet aligned to how IFTA returns are computed
How to use it
- 1
Pull total miles and total gallons for the quarter from your trip sheets and fuel logs.
- 2
Calculate fleet MPG: total miles divided by total gallons.
- 3
Enter miles traveled in each jurisdiction; the worksheet derives taxable gallons (jurisdiction miles ÷ fleet MPG).
- 4
Enter gallons purchased in each jurisdiction (from fuel receipts).
- 5
Net taxable gallons against purchased gallons by jurisdiction to find tax due or credit, then file with your base jurisdiction.
Preview the template
This is the full template. Use the button to print it or save it as a PDF — no email required — or grab the editable spreadsheet below.
Printable preview
IFTA Mileage & Fuel Tax Worksheet
IFTA tax rates change quarterly by jurisdiction — apply the current rate table when computing tax. This worksheet organizes the data; it is not tax advice.
| Jurisdiction | Miles Traveled | Taxable Gallons (miles ÷ MPG) | Gallons Purchased | Net Gallons | Tax Rate | Tax Due / (Credit) |
|---|---|---|---|---|---|---|
| NJ | 1,200 | 190.5 | 210.0 | -19.5 | 0.418 | (8.15) |
| PA | 2,400 | 381.0 | 330.0 | 51.0 | 0.741 | 37.79 |
| OH | 1,800 | 285.7 | 300.0 | -14.3 | 0.470 | (6.72) |
Get the editable Excel version
Enter your email and we'll unlock a ready-to-edit CSV of this template — open it in Excel, Google Sheets, or Numbers and customize it for your fleet.
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
IFTA applies to qualified motor vehicles operating across member jurisdictions — generally heavier commercial vehicles crossing state/provincial lines. Confirm whether your vehicles qualify; the thresholds are defined by the agreement.
Taxable gallons in a jurisdiction equal the miles you drove there divided by your fleet's average MPG for the quarter. You then net that against gallons actually purchased in that jurisdiction.
Mileage records (trip sheets/odometer or GPS) showing per-jurisdiction miles, and fuel receipts showing gallons and where purchased. Keep them for the retention period your base jurisdiction requires.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.