LoadSteward

Fuel and IFTA

IFTA mileage and fuel log, with a free IFTA tracking spreadsheet

Log each trip leg by state with odometer readings and each fill-up with its receipt details. The log totals miles and gallons by state, works out your fleet mpg and the quarter's IFTA net, and flags what an auditor would ask about.

Updated October 2026 · Free, no sign-up · Your numbers stay in your browser

Loading the calculator...
Download the blank IFTA spreadsheet (CSV)40 trip rows, 40 fuel rows, totals and fleet mpg as formulas. Opens in Excel, Google Sheets or Numbers.

How the IFTA mileage log works

IFTA tax is settled by the miles you drive in each state, not by where you buy fuel. So the log has two parts, and the return needs both.

Trip legs. One row for every state on a trip. Write the odometer reading when you cross into a state and when you leave it; the difference is the miles there. Each row also carries the trip dates, origin, destination, route and unit number. Those are the trip elements listed in the IFTA Procedures Manual (P540.100), so a log kept this way is the kind of record an auditor expects.

Fuel purchases. One row per fill-up with the date, seller and address, state, gallons and amount. The receipt or fuel card statement behind each row is what earns the tax-paid credit.

From the two tables the log works out:

  • Miles by state = the sum of the leg miles for that state.
  • Gallons by state = the gallons bought there.
  • Fleet mpg = total miles ÷ total gallons.
  • Taxable gallons by state = that state's miles ÷ fleet mpg.
  • Net by state = (taxable gallons − gallons bought there) × that state's rate for the quarter. Positive is owed, negative is a credit.

Source: IFTA, Inc., IFTA Procedures Manual (effective Aug 26, 2026), P510 · checked Oct 2026

Rates come from the IFTA, Inc. matrix for 4Q 2026, the special diesel rate plus any surcharge the matrix lists separately. For every line of the return worked out in full, use the IFTA fuel tax calculator.

The example trip, on a receipt

UNIT 101 · DALLAS TO MEMPHIS

EXAMPLE

TX leg 412,100 → 412,282182 mi
AR leg 412,282 → 412,566284 mi
TN leg 412,566 → 412,57812 mi
Trip miles478 mi
Fuel: TX 45 gal + AR 30 gal75 gal
Fleet mpg (478 ÷ 75)6.37

Made-up trip and odometer readings. One trip is too short for a real mpg; over a quarter the averages settle.

What the flags mean

The panel next to the result lists what an auditor would ask about:

  • Missing fields. A trip row without a route or unit, or a fuel row without the seller, is a weaker record. Fill them in while you still remember.
  • Fuel bought in a state with no miles logged. Usually a trip leg is missing. It can also mean fuel went into something other than the truck, which doesn't earn credit.
  • Fleet mpg outside 4 to 10. A loaded tractor rarely lands outside that range over a quarter; see semi truck mpg. The IFTA manual lets an auditor cut an inadequately documented fleet's mpg to 4.00, which is why this one matters. More in IFTA audits.
  • A reversed odometer. The end reading must be higher than the start; that row counts zero miles until fixed.

A good log vs a weak one

A good log is filled in weekly, has a row for every state line, matches the ELD's miles within a few percent, and has a receipt for every fuel row. Its mpg looks like the truck.

A weak log is rebuilt at quarter end from memory, rounds miles to the nearest hundred, and has fuel rows without receipts. It gets you through filing and fails the first audit question.

If typing legs every week is the step you'd skip, an ELD with IFTA reports or a trucking program can collect the miles for you; compare options in IFTA reporting software and apps. Fuel tax by state also changes where it pays to fill up; the where-to-fuel calculator compares states on a route, and IFTA fuel tax rates history shows how rates move.

Who needs an IFTA log

Any carrier with an IFTA license: trucks with two axles over 26,000 lb, three or more axles, or a combination over 26,000 lb, running in two or more member jurisdictions. A two-axle 26 ft box truck rated at 26,000 lb or less doesn't qualify, though a mileage log still helps with cost per mile and taxes. The full rules are in what is IFTA in trucking, and every due date is on IFTA filing dates.

Miles are also the denominator in your cost per mile: the same log feeds dispatch fee cost per mile and the trucking cost per mile calculator. If you'd rather spend the hours driving, our dispatch for owner-operators sends a weekly report with every load's lane and miles. Send an application and a dispatcher calls you back.

General information, not tax advice. Rules and rates change every year and depend on your situation: confirm with a tax professional before you file. We are not a tax preparer or accountant.

IFTA mileage and fuel log: your questions

How do I track IFTA miles?

Break every trip at each state line and record the odometer reading where you cross. The difference is the miles in that state. Note the trip dates, origin, destination, route and unit number, which the IFTA Procedures Manual lists as the elements of an adequate trip record. An ELD that logs jurisdiction crossings can do it for you.

Is a spreadsheet good enough for IFTA records?

Yes, if it holds the elements the IFTA Procedures Manual asks for and you keep the fuel receipts behind it. The manual says records may be kept in any format the base jurisdiction can audit. Keep them four years from each return's due or filing date.

What fuel details does an IFTA log need?

For each purchase: the date, the seller's name and address, the gallons, the fuel type, the price, the truck it went into and the purchaser's name (P550.300). A fuel card statement line or the receipt itself is the proof; the log is your index to them.

Does this log file my IFTA return?

No. It totals your miles and gallons by state and estimates the net with the current quarter's rates, so you can check the numbers before you file on your base jurisdiction's portal. You file the return yourself or through a filing service.

Where is my log saved?

In your browser on this device only. Nothing is sent to us. Download the CSV at least monthly so a cleared browser doesn't take your quarter with it.

Written by

Richard Bailey is a truck dispatcher with 8 years of experience in trucking. A dispatcher's day is rate cons, broker calls and the cost-per-mile math behind every load, and that is the work these guides come from. He writes and checks the money guides, calculators and term pages on this site.

Updated October 2026. Every rate and date on this page has its source and the date we checked it. How we research

Loads with the miles already logged

Our weekly report lists every load's lane and miles, which is the trip side of your IFTA log. Every load is offered to you first, and you confirm it.

No setup fee. No contract. You confirm every load.

IFTA quarters: next four due dates

Weekend due dates roll to the next business day