What it is
The Fuel & IFTA Tracking Template is a quarterly IFTA worksheet paired with a fuel-economy and fuel-spend tracker. You log miles and gallons by jurisdiction, and the workbook computes your fleet MPG, allocates taxable gallons to each state and province, calculates net tax due or credit by jurisdiction, and trends your fuel cost per mile. It turns the most error-prone administrative task in interstate trucking — the IFTA quarterly return — into a calculation driven by your real operating data.
The model is built on the actual IFTA math. Fleet MPG (total miles divided by total gallons) is the single allocation basis: taxable gallons in a jurisdiction equal the miles driven there divided by fleet MPG, tax due equals taxable gallons times that jurisdiction's rate, and the net position in each jurisdiction is tax due minus the tax already paid at the pump there. A jurisdiction shows a credit when you fueled more there than you drove, and the consolidated net is what you remit or reclaim on the return.
Alongside the tax engine, a fuel-economy log tracks each fill-up's MPG and cost per mile so you can spot a unit or driver whose economy is slipping — the early warning for under-inflation, excessive idle, a clogged air filter or an emerging fault code. The spreadsheet works as a standalone IFTA tool or as a check against the IFTA reports your telematics platform produces.
What it's used for
Fleets use this template to file accurate IFTA returns without spreadsheet panic at quarter-end, and to keep fuel — usually the single largest operating cost — under active management. It is essential for any carrier operating across state or provincial lines.
- ✓ Preparing the quarterly IFTA return by computing taxable gallons, tax due and net position for every jurisdiction.
- ✓ Calculating accurate fleet MPG from total miles and gallons as the allocation basis for the whole return.
- ✓ Reconciling jurisdiction miles against the fleet total and purchased gallons against fuel-card records before filing.
- ✓ Tracking fuel cost per mile as a trend so fuel spend is managed, not just paid.
- ✓ Logging per-fill-up MPG to catch a vehicle or driver whose economy is drifting below the fleet average.
- ✓ Diagnosing the causes of poor economy — tire pressure, idle, air filters, engine fault codes — from the fuel log.
- ✓ Documenting the mileage-and-fuel records a DOT or IFTA auditor expects to see together.
Who uses it
The template is used by the people who file the taxes and the people who manage the fuel bill, which in many fleets are different roles. Its transparent math makes the IFTA return auditable and the fuel trend actionable.
Context & good to know
IFTA exists to spare interstate carriers from filing fuel tax separately in every state and province they touch. Instead, a carrier files one quarterly return with its base jurisdiction, which redistributes the tax. The mechanism is simple in concept and fiddly in practice: you owe each jurisdiction tax on the fuel you consumed there (its miles divided by fleet MPG), and you get credit for the fuel you bought there at the pump. Getting fleet MPG right is everything, because it scales every jurisdiction's taxable gallons at once.
This is data that modern telematics produces automatically, which is why the workbook doubles as a check on software output. Geotab, Samsara and GPS Insight capture jurisdiction-by-jurisdiction mileage from the vehicle and generate IFTA mileage reports, removing the manual trip-sheet step that historically caused most filing errors. Reconciling those automated reports against fuel-card gallons in this spreadsheet is good practice — the software gives you the miles, the fuel card gives you the gallons, and the return needs both to agree.
Fuel is typically the largest controllable line in a fleet's operating cost, which is why the workbook tracks economy as well as tax. A fleet MPG that drifts downward doesn't just raise fuel spend; because it is the IFTA allocation basis, a lower fleet MPG raises taxable gallons in every jurisdiction and increases your tax exposure too. Managing MPG is therefore a double win, and the per-fill-up log is where you catch the unit dragging the average down.
The most common IFTA mistakes are reconciliation failures — total jurisdiction miles that don't match the odometer-derived fleet total, or purchased gallons that don't match the fuel-card statement. Auditors look for exactly these discrepancies. The workbook's totals row and reconciliation notes are there to force that check before filing, because catching a mismatch yourself is far cheaper than having an auditor find it.