IFTA Distance Calculator
Stop manually counting miles per state. This Excel-based calculator breaks down every trip by state automatically — so your quarterly IFTA report is done before you know it.
How it works
Enter the route. Get miles by state. Done before the quarter closes.
You enter your trip route into IFTA Distance Calculator — no manual splitting, no highlighting state lines on a map. You click the button, and the built-in formulas break the trip down mile by mile, state by state, and drop the totals into your spreadsheet. Add as many trips as you need in the same file, all quarter long. No macros to write, no software subscriptions, no manual math. Your data stays in your file, ready for your IFTA filing.
See it in action
Three steps. Under a minute. Real screen recordings from the tool.
Enter your trip route
Drop your route — origin, stops, and destination — into the spreadsheet. No manual state-by-state splitting required.
Run the calculator
One click runs the pre-built formulas against every trip in your list. Nothing to configure, nothing to reset between quarters.
Get your miles-by-state breakdown
Every trip is split into exact mileage per state, filled directly into your spreadsheet — ready to hand to your IFTA report.
Who it's for
Built for anyone who has to answer the question “how many miles did we drive in each state this quarter?” — without doing it by hand.
Owner-operators
Running your own rig and handling your own books? This tool keeps your state mileage organized without any extra software subscriptions.
Fleet managers
Managing multiple trucks and drivers across state lines? Track every vehicle's miles per state from a single, centralized spreadsheet.
Trucking company accountants
Whether you run a small carrier or a growing fleet, keep IFTA compliance clean, accurate, and audit-ready every single quarter.
What's inside
Everything you need to keep IFTA mileage clean and audit-ready — nothing you'll never use.
What you get
- The IFTA Distance Calculator workbook (.xlsm)
- Written setup guide (PDF)
- Video walkthrough of a full IFTA quarter
- Free 1-on-1 Zoom call to set up your Google API key
- Email support from the builder
- Every future update to the IFTA Calculator
Requirements
- Microsoft Excel 365 (Windows or Mac)
- A free Google Cloud account with Maps APIs enabled
- An internet connection while calculating
Ready to stop tabbing between Google Maps and Excel?
One-time · Instant download · Free setup call included
Frequently asked questions
Real answers to the questions people ask before they buy.
How does it split mileage by state?
You enter your trip route and the pre-built formulas calculate exactly how many miles fall within each state boundary, filling the breakdown directly into your spreadsheet.
Is there a limit on how many trips I can enter?
No. Add as many trips as you need within the same spreadsheet — there's no cap, so it works for a single truck or a full quarter of high-volume routes.
Do I still need to file my IFTA report separately?
Yes — this tool prepares the accurate mileage-by-state breakdown you need. You still submit that data through your normal IFTA filing process.
Does it work on Mac?
Yes — the spreadsheet works on Excel for Windows and Excel for Mac. You just need macros enabled.
Is this a subscription?
No. One-time purchase. You own the file — no monthly fees, no renewals, no seat charges.
Can multiple people on my team use it?
Buy the Multi-User license ($187) — everyone on your team can install and use it. Single-User ($97) is for one workstation.
What customers say
Real customers using this tool in the field. Read more on our Google Business profile.
158+ Google reviews for ExcelDistanceCalculators.com — from customers across trucking, courier, real estate, construction, and public safety.
“I came across Vinnie's YouTube video and option to purchase his workbook. Vinnie reached out directly via Zoom to assist me with the API setup in order to begin calculating over 15,000 distances. Impressed with his work and, more so, his level of service during a time-sensitive project. Would highly recommend and will keep Vinnie's contact on hand for future projects.”
“We needed a quick and easy way to calculate distances for our construction crews from their home to their jobsites — 100+ people on a weekly basis. It was important to find something cost effective that wouldn't take hours each week. This tool has been amazing. Setup was super simple, our weekly reporting takes only a few minutes, and we have all the information we need.”
“Vinnie went above and beyond to help me set up the Google API for an Excel program so that I could get out a Mileage Report for the Center Hill Fire Protection District firefighters for their annual reports. Will gladly recommend his service to anyone that asks.”
You might also like
Other Excel tools our customers reach for.
