Skip to content
Haul Math

Reference

IFTA Mileage Log Sheet and Tax Example

Last updated: . Haul Math (haulmath.co) is a free set of trucking calculators by Hive Asset Group, LLC.

Short answer

To calculate IFTA tax, divide your total miles by your total gallons to get fleet MPG, then work out the gallons you used in each state (state miles / fleet MPG). Subtract the gallons you bought in that state to get net taxable gallons, and multiply by that state's rate.

Q3 2026 IFTA return: due Nov 2, 2026 (Oct 31 falls on a Saturday, so the next business day applies). Check your base jurisdiction's instructions for your own date.

The mileage log sheet: columns to copy into your spreadsheet

Haul Math does not offer a free spreadsheet file for this. The paid workbook (linked at the bottom) includes an IFTA mileage and fuel log, but you can also build the sheet yourself in Excel or Google Sheets with one row per state crossing or fuel stop. Use these columns:

ColumnWhat goes in it
DateDate of the crossing or the fuel stop
Truck unit #Your unit number (needed if you run more than one truck)
State or provinceTwo-letter code, for example TX
Odometer inReading when you entered the state
Odometer outReading when you left the state
Miles in stateOdometer out minus odometer in
Fuel seller and locationStation name and city
Fuel typeDiesel, gasoline, etc.
Gallons purchased in stateFrom the receipt
Price per gallonFrom the receipt
Fuel receipt #So you can find the paper copy
NotesDetours, toll roads, off-route miles

At the bottom, add totals for miles in state and gallons purchased in state, one line per state for the quarter, plus the grand totals. Those are the numbers you need for the return. Keep the receipts. Your base jurisdiction says how long to keep records and what it accepts, so check its instructions.

If you would rather not build it, the trip sheet generator takes the same inputs (odometer readings at each state line, fuel stops with gallons, price and fuel type) and shows miles by state, gallons by state, fuel cost and your MPG for the trip. Its PDF export is the printable trip sheet. Read how to fill out a trip sheet for IFTA for the step-by-step.

How to calculate IFTA tax

  • Fleet MPG = total miles / total gallons (all states, whole quarter)
  • Taxable gallons for a state = miles in that state / fleet MPG
  • Net taxable gallons = taxable gallons minus gallons you purchased in that state
  • Tax for that state = net taxable gallons x that state's rate

A positive result means you owe that state. A negative result means a credit from that state. Add them up for the quarter. Rates change each quarter, so use the state rate tables for the quarter you are filing (or see all states and fixed costs), and read the four-step IFTA guide for more.

Example: 3 states, one quarter

The miles, gallons and rates below are made up for this Example. Do not file with them. For real rates, use the rate tables.

Example rates per gallon: Texas $0.20, Oklahoma $0.19, Arkansas $0.285.

StateMilesGallons boughtTaxable gallonsNet taxable gallonsExample rateTax or credit
Texas1,500180250+70$0.20$14.00 owed
Oklahoma600120100-20$0.19-$3.80 credit
Arkansas900200150-50$0.285-$14.25 credit
Total3,0005005000-$4.05 (net credit)

Step by step:

  1. Total miles 3,000 / total gallons 500 = fleet MPG of 6.0.
  2. Texas: 1,500 / 6.0 = 250 taxable gallons. Oklahoma: 600 / 6.0 = 100. Arkansas: 900 / 6.0 = 150.
  3. Net gallons: Texas 250 - 180 = +70. Oklahoma 100 - 120 = -20. Arkansas 150 - 200 = -50.
  4. Tax: 70 x $0.20 = $14.00. -20 x $0.19 = -$3.80. -50 x $0.285 = -$14.25.
  5. Sum: $14.00 - $3.80 - $14.25 = -$4.05.

In this Example you bought more fuel in Oklahoma and Arkansas than you burned there, so those states show credits, and Texas shows tax owed. The net total is a small credit. Your own numbers will differ. How your base jurisdiction handles a net credit (refund or carry forward) is in its instructions.

To run your own numbers, enter them in the IFTA calculator. It uses the same formulas and gives planning estimates only. Confirm with your tax pro or your base jurisdiction's IFTA office before filing.

When is the return due?

IFTA returns are due quarterly. The Articles of Agreement say the return and payment are due on the last day of the month after the reporting period closes, and that if that day is a Saturday, Sunday or legal holiday, the next business day is the due date. For Q3 (July to September), that is October 31. In 2026 October 31 is a Saturday, so the due date is Monday, November 2. Other quarters: April 30, July 31 and January 31. Your base jurisdiction's own instructions and calendar rule, so check them. All eight dates through 2027 are on the IFTA due dates page. For filing steps, see how to file IFTA quarterly.

FAQ

Is there an IFTA calculator in Excel?

Haul Math does not have a free Excel file for IFTA. You can copy the column layout above into any spreadsheet, or use the free IFTA calculator on the site. The paid workbook has an IFTA mileage and fuel log that records miles and gallons by state but does no tax math.

What goes on an IFTA mileage log sheet?

For each state: the date, odometer in and out, miles in the state, and the gallons you bought there, with the fuel receipt details. Totals by state for the quarter feed your return.

How do I calculate net taxable gallons?

Divide the state's miles by your fleet MPG to get taxable gallons, then subtract the gallons you bought in that state. In the Example, Texas is 250 minus 180, so 70 net gallons.

When is the Q3 2026 IFTA return due?

Oct 31 is a Saturday, so under the Articles of Agreement the next business day, Monday, Nov 2, 2026, is the due date. Check your base jurisdiction's instructions to be sure.

Sources

Get the workbook

The $19 workbook. An Excel file (.xlsx) with working formulas, plus a printable PDF. It includes an IFTA mileage and fuel log with miles and gallons by state, by quarter, and average MPG. That log is a record only and does no tax math, so use the IFTA calculator for the tax. Get the workbook

Free, no signup

Know your number before you take the load

26 free calculators, no signup. Want your loads and numbers saved? Try Pro free for 14 days, no card.

Get the free cost-per-mile sheetStart the free Pro trial