IFTA Quarterly Fuel Tax Calculator Worksheet (Free)

Updated 2026-09-07 · FleetClear

The International Fuel Tax Agreement (IFTA) lets you file one quarterly fuel-tax return with your base jurisdiction instead of one with every state and province you drove through. The return is simple arithmetic — but it has to be done per jurisdiction, from records that will survive an audit. This worksheet walks the calculation step by step, gives you a fill-in table for each quarter, and lists the records you must be able to produce. Free printable Word version below — just tell us where to send it.

⬇ Download the IFTA calculator worksheet (Word)

Do you need an IFTA licence?

Quarterly due dates

QuarterPeriod coveredReturn and payment due
Q1January – MarchApril 30
Q2April – JuneJuly 31
Q3July – SeptemberOctober 31
Q4October – DecemberJanuary 31

If the due date falls on a weekend or holiday, most jurisdictions accept the next business day — check yours. A return is due every quarter you hold a licence, even a quarter with zero travel (file a "no operations" return).

The calculation, step by step

  1. Total miles for the quarter, all qualified vehicles, all jurisdictions (including non-IFTA miles such as trip-permit or exempt miles, which are tracked separately but count in the MPG).
  2. Total gallons of fuel placed in the qualified vehicles during the quarter (from receipts, all jurisdictions).
  3. Fleet average MPG = total miles ÷ total gallons. Round per your jurisdiction's instructions (commonly two decimal places).
  4. For each jurisdiction: taxable miles driven there ÷ fleet MPG = taxable gallons consumed there.
  5. For each jurisdiction: taxable gallons − tax-paid gallons purchased there = net taxable gallons (negative means you over-purchased there and earn a credit).
  6. Net taxable gallons × that jurisdiction's current quarter tax rate (published on iftach.org each quarter; rates change) = tax due or credit.
  7. Sum every jurisdiction's tax due / credit. Credits offset amounts owed elsewhere; the net is what you pay your base jurisdiction (or receive as refund/credit).
  8. Add any surcharge lines — a few jurisdictions levy a surcharge on taxable gallons that is not offset by tax-paid purchases.

Per-jurisdiction worksheet (one row per state/province driven)

JurisdictionTotal milesTaxable milesTaxable gal (miles ÷ MPG)Tax-paid gal boughtNet galRateTax due / (credit)
Totals

Fleet summary for the quarter

Quarter / year 
Total miles (all jurisdictions) 
Total gallons purchased 
Fleet MPG (miles ÷ gallons) 
Sum of tax due 
Sum of credits 
Net payable / (refund) 

Records an auditor will ask for (keep four years)

IFTA requires distance and fuel records to be kept for four years from the return due date or filing date, whichever is later.

⚠️ The two errors that produce audit assessments: unsupported miles (odometer gaps or missing trip sheets — auditors may reduce your MPG to a default and bill the difference) and claiming tax-paid gallons without a receipt that ties to a vehicle. If a receipt is lost, do not claim the gallons.
Free: Want your real deadlines, not a generic list? Run the free USDOT compliance check — your MCS-150, UCR and IFTA dates straight from the FMCSA registry. Then track them: your first compliance item is free →

Never let a deadline take a truck off the road

Enter your dates once — FleetClear computes every DOT/FMCSA deadline, alerts you at 60/30/7 days, and drafts the renewal notice. Your first compliance item is free.

Start free — no card required
General guidance for motor carriers, not legal advice. FMCSA rules, fees and state procedures change — verify current requirements with FMCSA (fmcsa.dot.gov) and your state agencies before relying on any item here. FleetClear is not affiliated with the FMCSA or any government agency.