Free IFTA Mileage Calculator for Excel

An Excel worksheet that fills in your truck miles per state automatically — plus a one-formula summary of every jurisdiction you drove.

IFTA reporting comes down to one tedious number: how many miles you drove in each state or province. Measuring that by hand, trip by trip, is the worst part of the quarter. This free Excel worksheet does it for you — type each trip's start and end address and the miles in every jurisdiction fill in, ready for your quarterly fuel-tax return.

Q3 2026 (Jul 1 – Sep 30) is due October 31, 2026. Quarterly IFTA due dates: Q1 → Apr 30, Q2 → Jul 31, Q3 → Oct 31, Q4 → Jan 31.

Download the free IFTA worksheet (.xlsx)

No email required. Works in Excel for Windows, Mac, and the web. Auto-fill needs the free RouteMetrics add-in.

A walkthrough of the worksheet and the formulas that fill it in.

What the worksheet does

• Trip Log — one row per trip; a column per state returns the truck miles driven there, plus the lane's toll cost and whether your truck can legally run it.
• Fuel Purchases — one row per fuel ticket. These are the tax-paid gallons that get credited against what you owe.
• Cross-check — beside the trip table, a single formula lists every jurisdiction your trips crossed and tells you outright if one of them has no column: "ADD COLUMNS — no column above for: KY, TN." Missing a state is the easiest way to under-report a quarter and the hardest to spot yourself. The return is built from that table, not from your columns, so a missing column costs you visibility — never accuracy.
• Tax Calculation — laid out like IFTA-101 itself: Items A–E across the top and columns F–Q below, using the form's own names in the form's own order, so you transcribe rather than translate. All 58 jurisdictions, with average fleet MPG, taxable gallons, tax-paid gallons, net, tax due, interest and the IN / KY / VA surcharge lines wired up.
• Empty miles — the trip log has a Loaded / Empty column, because IFTA taxes deadhead exactly like loaded freight and leaving it out is a common audit finding.

Tax rates are the one thing the worksheet does not ship. They change every quarter, and a stale rate baked into a file would quietly produce a wrong return — so the column is there, everything downstream of it is calculated, and the sheet links you to the current IFTA, Inc. rate matrix.

The formulas that do the work

RouteMetrics adds real truck routing to Excel formulas. Four of them are built for IFTA, per-state mileage and lane costing:

Routes planned for your truck

Travel mode “truck” keeps you off roads closed to trucks outright. It cannot check a low bridge or a posted weight limit on its own, because those depend on the vehicle. Set your gross weight, height, axle count and any hazmat class once in the RouteMetrics task pane — it saves into the workbook and every truck formula in the file uses it.

Multi-stop lanes work too: pass a load's pickups and drops in order and the miles are counted through them, which matters for IFTA because a detour puts the truck in states the direct route never enters.

Get RouteMetrics on Microsoft AppSource See pricing

How to calculate IFTA miles in Excel, step by step

1. List your trips — one row each, with the From and To address for the quarter.
2. Name your states — put a column for each jurisdiction you run (OH, PA, IN…).
3. Fill the miles: =ROUTE.STATEMILES(from, to, "OH", "truck") in each state column, copied down.
4. Total each column with =SUM(...) — that's your per-jurisdiction mileage.
5. Double-check with =ROUTE.IFTA(...) to list any state you forgot a column for.
6. Log your fuel — every tax-paid ticket, by jurisdiction. Those gallons are your credit.
7. Enter this quarter's rates and the worksheet computes taxable gallons, net gallons and tax due per jurisdiction.

The downloadable worksheet already has all of this wired up across four tabs: Trip Log, Fuel Purchases, Tax Calculation, and How to use. The Tax Calculation tab mirrors IFTA-101 column for column, and three live cross-checks under the totals flag the mistakes that actually get caught on audit — a state you never logged a column for, tax-paid gallons that exceed your total volume, and fuel tickets sitting on the wrong fuel type's schedule.

No API key, and no macros to enable

Most Excel IFTA and distance tools are macro-enabled workbooks that call Google Maps from your machine — which means creating a Google Cloud project, generating an API key and putting a card on file before you can calculate a single mile, then paying the mapping provider per lookup on top of whatever the workbook cost.

RouteMetrics does the routing on its own servers. There is no key to manage, no second bill, and nothing asking you to click “Enable Content” — it is a sandboxed Office add-in from Microsoft AppSource, so it also runs in Excel for the web, where macro workbooks cannot run at all. Start with 100 free searches that never expire, then pick a monthly plan or a one-time credit pack — the right shape when your filing is quarterly. More on why that matters →

Frequently asked questions

How do I calculate IFTA miles by state in Excel?

List each trip's From and To address, then use ROUTE.STATEMILES in a column per state to return the truck miles in that jurisdiction, and sum each column. ROUTE.IFTA can spill every jurisdiction across all trips in one formula.

Does this use truck routing?

Yes — miles come from HERE truck-legal routing, not car directions. They're estimates for planning and IFTA prep; verify against your records.

Does it calculate the tax, or only the miles?

Both. Add your fuel tickets and this quarter's tax rates and the Tax Calculation tab works out fleet MPG, taxable gallons, tax-paid gallons, net gallons and tax due for all 58 jurisdictions, including the Indiana, Kentucky and Virginia surcharges. Rates are not shipped in the file because they change every quarter — you copy them from the IFTA, Inc. matrix.

Does it include tolls?

Yes — ROUTE.TOLLS returns the toll cost for a lane, priced against your truck profile. Toll prices are best-effort and vary by payment method and vehicle class; when a lane can't be priced, the cell says so rather than returning zero.

Do I have to log empty miles?

Yes. IFTA taxes deadhead and repositioning exactly like loaded miles, and omitting them is one of the most common audit findings. The trip log has a Loaded / Empty column so you can track both.

Why is there no “Diesel” column in the IFTA tax rate matrix?

Because Special Diesel is the diesel column. The name is statutory rather than descriptive: state motor-fuel laws split fuels into gasoline and “special fuels” — everything else used to propel a highway vehicle — and diesel fell into the second bucket. If you run ordinary undyed on-road diesel, Special Diesel is the rate you copy. Gasoline, Propane, LNG and CNG match by name; diesel is the only one the matrix calls something else. Dyed off-road diesel appears nowhere on the matrix because it carries no highway tax — and for the same reason its gallons must never go in your tax-paid column, since there is no tax paid to credit back.

Is the IFTA worksheet free?

Yes — download it above. Filling the miles automatically needs the free RouteMetrics add-in.

When are IFTA quarterly returns due?

The last day of the month after the quarter ends: Q1 (Jan–Mar) is due April 30, Q2 (Apr–Jun) is due July 31, Q3 (Jul–Sep) is due October 31, and Q4 (Oct–Dec) is due January 31. When the date falls on a weekend or holiday, the deadline moves to the next business day.

Related: Mileage log template · Mileage reimbursement calculator · All Excel templates & guides

This guide is general information, not tax or compliance advice. Truck miles are routing estimates and are not a certified mileage source; IFTA rules, rates, and accepted mileage standards vary by jurisdiction. Confirm current requirements with your base jurisdiction or a professional.