Audit & Recordkeeping · Excel template
Free 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. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- 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
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
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 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
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.