← IFTA Quarterly Fuel Tax Calculator
This calculator vs. a spreadsheet
An IFTA return is arithmetic, and a spreadsheet can do arithmetic. What a hand-built worksheet usually gets wrong is not the arithmetic but two specific rules the return applies: fleet-wide MPG, and a surcharge that no fuel credit ever reduces.
Where a hand-built worksheet usually goes wrong
| Rule | Common spreadsheet shortcut | What this calculator does |
|---|---|---|
| Fleet MPG | Divides each jurisdiction's own miles by its own gallons, producing a different MPG per row. | Divides total fleet miles by total fleet gallons once, and applies that single MPG to every jurisdiction's taxable miles. |
| The surcharge | Applies the surcharge rate to each jurisdiction's net taxable gallons, so a fuel credit there quietly reduces it. | Applies the surcharge rate to gross taxable gallons burned in that jurisdiction, with no credit for fuel bought there, exactly as the return requires. |
| Plausibility checks | None, unless someone remembers to add one -- a wrong MPG or a zero-rate jurisdiction looks like any other number in a cell. | Flags an average MPG outside the 3–12 realistic band, fuel bought with no recorded miles, taxable miles at a zero rate, and a return in net credit that still owes interest. |
| Does anything I type get uploaded anywhere? | N/A | No. The return runs entirely in your browser; nothing you enter is sent to a server. |
What the two mistakes cost, on the calculator's own worked example
The quarter this calculator opens with runs 29,320 miles on 3,890 gallons across five jurisdictions, for a fleet-wide average of 7.54 MPG. Indiana's 6,150 miles become 815.65 taxable gallons at that rate, owing $653.82 in tax and surcharge together. A worksheet that instead divides Indiana's own 6,150 miles by the 380 gallons bought there gets 16.18 MPG — outside the 3–12 MPG band a qualified vehicle realistically returns — and reports Indiana's taxable gallons as just 380.1, for a total of $235.69. That single jurisdiction alone is understated by $418.13.
Across all five jurisdictions, the tax line nets to a credit of $91.53, and the Indiana/Kentucky surcharge adds $570.90 that no fuel credit reduces, so the return owes $479.37. A worksheet that instead applies each surcharge rate to that jurisdiction's own net taxable gallons — letting a credit in Kentucky quietly reduce the surcharge owed there — totals $150.95: a $328.42 understatement from one modeling choice, on a return that nets to a fraction of what is actually owed.
This tool needs no account and no sign-in: it is a static page, the arithmetic runs in your browser, and once it has loaded it keeps working with the connection off.
Open the IFTA Quarterly Fuel Tax Calculator to work your own quarter, or see how this compares to a paid preparation service like ExpressIFTA.
Common questions
Isn't an IFTA return just arithmetic I can do in a spreadsheet?
Yes -- it is arithmetic, and a spreadsheet can do arithmetic. What trips up a hand-built worksheet is not the arithmetic itself but two specific rules the return applies that a spreadsheet has to be told to apply: fleet MPG is one number computed fleet-wide, not per jurisdiction, and a surcharge is charged on every taxable gallon burned in that jurisdiction with no credit for fuel bought there, however the tax line nets out. Skip either rule and the numbers still look reasonable -- they just do not reconcile to what an audit finds.
How much does computing MPG per jurisdiction actually cost me?
On the worked example this calculator opens with, the fleet ran 29,320 miles on 3,890 gallons for a fleet-wide average of 7.54 MPG, and Indiana's 6,150 miles become 815.65 taxable gallons at that rate, owing $653.82 in tax and surcharge combined. A worksheet that instead divides Indiana's own 6,150 miles by the 380 gallons bought there gets 16.18 MPG -- outside the 3-12 MPG band a qualified vehicle realistically returns -- and reports Indiana's taxable gallons as just 380.1, a debit of three cents in tax plus the surcharge on that smaller gallon figure, $235.69 in total. That single jurisdiction alone is understated by $418.13 in one quarter.
How much does netting the surcharge against a credit cost me?
On the same worked example, the tax line across all five jurisdictions nets to a credit of $91.53, and the surcharge (Indiana and Kentucky both charge one) adds $570.90 that no fuel credit reduces, for a return that owes $479.37. A worksheet that instead applies each surcharge rate to that jurisdiction's own net taxable gallons -- so a credit in Kentucky quietly reduces the surcharge owed there -- totals $150.95: a $328.42 understatement from one modeling choice.
So why not just build the fleet-wide MPG and surcharge rules into my own spreadsheet?
You can, and a correctly built one gets the same answer this calculator does -- it is the same arithmetic either way. What a spreadsheet will not do on its own is flag the mistakes that produce a plausible-looking wrong answer: an average MPG outside the realistic band, fuel bought in a jurisdiction with no recorded miles, taxable miles sitting at a zero rate, or a credit-in-total return that still owes interest. This calculator runs those checks on every submission; a spreadsheet only runs the checks someone remembered to add.