IFTA Filing Guide + Tracking Spreadsheet: Plain-English Guide & Auto-Calculating Excel Workbook
IFTA doesn't have to be the headache everyone makes it out to be. This bundle includes a 16-page plain-English guide that explains exactly how IFTA works, plus a 6-tab Excel spreadsheet with 321 built-in formulas that does all the math for you.
The Guide (PDF — 16 pages):
9 chapters covering everything from "What is IFTA?" to "What to do if you get audited." No accounting jargon. Written specifically for owner-operators filing IFTA for the first time or tired of doing it wrong.
Chapters include how IFTA works, how to get your IFTA license, what to track, how the calculation works with a real 5-state example, step-by-step filing instructions, common mistakes that trigger audits, audit prep guidance, and how to use the included spreadsheet.
The Spreadsheet (Excel — 6 tabs, 321 formulas):
Tab 1: State Mileage Tracker — All 48 IFTA states. Enter miles per quarter, annual totals calculate automatically.
Tab 2: Fuel Purchase Tracker — Gallons and cost per state per quarter. Totals calculate automatically.
Tab 3: IFTA Calculation — This is the main tab. It pulls your total miles and gallons from the other tabs, calculates your fleet MPG, then computes gallons consumed, net gallons, and tax owed or credited for each state. The bottom line shows your net IFTA payment.
Tab 4: Deadline Calendar — All four quarterly filing deadlines with penalty info and status tracking.
Tab 5: Audit Prep Checklist — 17-item checklist across 4 categories so you always have your records organized.
Tab 6: Instructions — Step-by-step guide to using the spreadsheet with color coding explanation.
Who this is for:
- New carriers filing IFTA for the first time
- Owner-operators who want their quarterly filing to take minutes instead of hours
- Anyone who's been doing IFTA by hand or paying someone else to do simple math
Works in Microsoft Excel, Google Sheets, and most spreadsheet apps. Q1 filing deadline is April 30 — start tracking now.
