Skip to content
Home › Guides › Your IFTA spreadsheet, without the formulas

Your IFTA spreadsheet, without the formulas

Keep tracking miles and fuel in Excel. Haulfile reads the sheets, applies the quarter's official rates and surcharges, rounds the way the return does, and checks receipts and MPG.

🔒 Nothing uploaded🚛 Any number of trucks⛽ Official quarterly rates🆓 Free, no signup

What a home-made IFTA spreadsheet usually misses

  • New rates every quarter. Rates change each quarter, and Kentucky and Virginia add a surcharge with no tax-paid credit.
  • Rounding. MPG is rounded to 2 decimals before the per-jurisdiction gallons are worked out, and gallons are whole numbers.
  • Non-IFTA miles. Alaska, DC or Mexico miles belong in total miles and MPG, with no tax line.
  • Receipt problems. Duplicate card lines, receipts dated outside the quarter, bulk fuel and fuel bought where you logged no miles.

Haulfile handles these and keeps your spreadsheet as the record. Use the Excel template or your own columns.

Try it free above See Pro pricing

FAQ

What is the IFTA quarterly return?

Carriers that run qualified motor vehicles (two axles over 26,000 lb, three or more axles, or a combination over 26,000 lb) in more than one IFTA jurisdiction report all their miles and fuel to their base jurisdiction every quarter. The return works out the fuel used in each state and province from your average MPG, credits the tax-paid fuel bought there, and nets the tax due or credit for each one.

Is my data uploaded?

No. Your files are read by JavaScript in your browser tab and never sent to us or anyone else. Miles and receipts aren't stored, so closing the tab clears them. With Pro you can save carrier details (name, IFTA license, base jurisdiction, units, signer) in this browser. Miles and fuel are never saved.

Which files can I use?

CSV, tab-separated or Excel. For miles: the state or jurisdiction mileage report from your ELD, or trip sheets, with one row per unit, trip or day and jurisdiction. For fuel: a fuel-card or receipt export with one row per purchase. Column names like Unit, State, Miles, Gallons, Litres, Vendor and Tax Paid are recognised. Download the templates to see the layout.

What's free?

Importing and checking any quarter for any number of trucks, fleet and per-truck MPG, the total tax due and the due date, and the full calculation for 3 jurisdiction lines, on screen and in print with a small footer. Pro shows and prints every line without the footer, and adds the CSV, the Excel workbook, the monthly summary by truck and saved carriers.

Which quarters and rates are included?

IFTA's final rate matrices for Q4 2025 to Q3 2026 are built in, covering all 58 member jurisdictions with surcharges. For a later quarter, download the matrix XML from IFTA's tax-matrix page and drop it in with your files.

Does it file the return?

No. Haulfile prepares a worksheet with every figure. You enter them in your base jurisdiction's IFTA system or on its form and pay there. Haulfile isn't affiliated with IFTA, Inc. or any jurisdiction, and isn't tax advice.