IFTA Mileage and Fuel Tracking Spreadsheet for Owner-Operators (Quarterly Filing Made Simple)

There’s a specific kind of dread that hits around the 25th of the month after a quarter ends. It’s the moment you open the truck console, look at the wad of fuel receipts, and realize you’re about to spend a weekend reconstructing which state you were in on April 14th.

IFTA isn’t difficult. It’s just unforgiving about records you didn’t keep at the time. Every hour of that reconstruction weekend is an hour spent recovering information that took ten seconds to capture at the pump.

What IFTA Actually Asks For

The International Fuel Tax Agreement exists because fuel taxes fund the roads of the state you drive through, not the state where you happened to buy fuel. If you buy 200 gallons in a low-tax state and burn most of it in a high-tax state, IFTA settles up the difference.

The mechanics come down to four inputs per jurisdiction:

1. Miles traveled in that state
2. Gallons purchased in that state
3. Your fleet MPG for the quarter (total miles ÷ total gallons, across all states)
4. That state’s tax rate per gallon

From those, the calculation is:

Do that for every state you touched, sum the net column, and that’s your return.

The arithmetic is trivial. The record-keeping is the entire job.

The Records That Actually Get Audited

IFTA requires distance records to show trip date, origin and destination, route of travel, and beginning and ending odometer readings — with miles broken out by jurisdiction. Fuel records need the purchase date, the seller’s name and location, gallons, price per gallon, and which vehicle it fueled.

Both categories must be retained for four years from the due date or filing date, whichever is later.

The reason auditors care so much about the distance side is that it’s the side operators fudge. Fuel receipts exist whether you organize them or not — the pump printed them. State-by-state mileage exists only if somebody wrote it down. An ELD helps, but ELD state-line data still has to get into the return, and “my ELD has it somewhere” is not the same as a distance record you can produce.

If your mileage-by-state numbers are estimates, an audit tends to find that out. Estimated distance records are among the most common grounds for an assessment.

The Two-Minute Habit That Replaces the Reconstruction Weekend

Here’s the entire operational change: log the fuel stop when you’re standing at the pump, not in October.

One row, six fields:

Fuel cost and MPG calculate themselves. Quarter assignment calculates itself from the date. That’s it — that’s the whole ongoing commitment, and it’s a phone-in-hand task at the fuel island while the tank fills.

Then, when the quarter closes, a summary tab that already has your state tax rates stored does the four-step math above for every jurisdiction at once, using SUMIFS to pull miles and gallons by state and a rate lookup to price them. You’re not calculating anything in October. You’re reading a number off a sheet and typing it into the state’s filing portal.

The Trucking Owner-Operator Bookkeeping & IFTA Tracker from ReadySheetGo is set up this way — a Fuel & IFTA log with per-state entry and automatic MPG, a Settings tab where you store each state’s fuel tax rate once, and an IFTA Quarterly Summary that computes taxable gallons, tax due, tax paid at the pump, and net owed per jurisdiction.

Where the Fleet MPG Number Bites People

Fleet MPG is the multiplier that turns miles into taxable gallons, which means an error there propagates through every state on your return.

Two things distort it:

Missing fuel purchases. A stop you didn’t log makes total gallons look lower, which makes fleet MPG look higher, which makes taxable gallons look lower in every state — understating your liability across the board. That’s the kind of error an audit finds and assesses on.

Reefer fuel. Fuel burned by a refrigeration unit is not propulsion fuel and generally isn’t reported as IFTA taxable fuel. If you’re pumping reefer fuel into your IFTA gallons, your MPG is wrong and your return is wrong. Track it as a separate line.

The practical safeguard: your fleet MPG should look like a plausible number for your equipment. If a loaded Class 8 tractor is showing 9.4 MPG for the quarter, something’s missing from the gallons column. A spreadsheet that surfaces MPG per stop and fleet MPG for the quarter makes an implausible number visible before you file, rather than after.

The Quarterly Deadlines

Four dates, unchanging:

Late filing generally triggers a penalty of $50 or 10% of the net tax due, whichever is greater, plus interest accruing monthly at rates set by each jurisdiction. Continued non-filing can get your IFTA license suspended — which, practically, means you cannot legally run interstate.

The late-filing penalty and the late-payment consequences are separate. If you owe more than you can pay by the deadline, file anyway. You’ll owe interest on the balance, but you won’t stack a filing penalty on top of it.

What Else the Same Data Gives You

The useful thing about state-by-state fuel logging is that IFTA isn’t the only thing it answers.

The same rows tell you your actual MPG by truck, which is how you catch a unit developing a problem before the check-engine light does. They tell you your fuel cost per mile, which feeds directly into cost-per-mile. They tell you where you’re buying fuel too expensively relative to the states you’re running — the whole basis of fuel-optimization routing.

And because fuel is your largest deductible expense, the same log feeds your Schedule C without a second data entry pass.

You’re logging the data anyway, under duress, once a quarter, from receipts. Logging it at the pump costs the same total effort spread across the quarter and gives you four useful outputs instead of one grudging one.

Featured on ReadySheetGo

Trucking Owner-Operator Bookkeeping & IFTA Tracker — 9 tabs built for one truck or a small fleet. Fuel & IFTA log with state-by-state miles, gallons and automatic MPG; a Settings tab storing each jurisdiction’s fuel tax rate; an IFTA Quarterly Summary calculating taxable gallons, tax due, tax paid at pump and net owed per state; load/trip log with automatic rate-per-mile; expense log mapped to Schedule C categories; preventive maintenance schedule with next-due odometer alerts; and a dashboard with cost per mile and profit per mile. Pre-filled with sample data. Works in Excel and Google Sheets, no macros. Instant digital download — $19.99.

This article is general information, not tax advice. IFTA rules, rates, and penalty schedules vary by jurisdiction — confirm specifics with your base jurisdiction or a tax professional.