Use Google Sheets to Build an IFTA State Mileage Tracker

What This Does

Google Sheets lets you build a simple IFTA mileage log that automatically calculates miles per state each quarter. When you enter each trip, Sheets AI can suggest formulas to total everything automatically — turning 3 hours of IFTA quarter-end math into a 15-minute review.

Before You Start

• You have a free Google account (Gmail)
• You have Google Sheets open on your phone or computer
• Time needed: 15 minutes to set up the tracker; 2 minutes per trip to enter data
• Cost: Free (Google Sheets is free with any Google account)

Steps

1. Open Google Sheets and Create a New Sheet

Go to sheets.google.com or tap the Sheets app on your phone. Tap the + button to create a new blank spreadsheet. Name it "IFTA Tracker 2025" or similar.

What you should see: A blank spreadsheet grid.

2. Set Up Your Column Headers

In row 1, type these headers in cells A1 through G1:

• A1: Date
• B1: Origin
• C1: Destination
• D1: Total Miles
• E1: States Driven
• F1: Miles per State (breakdown)
• G1: Notes/Load #

Tip: Make row 1 bold by selecting it and pressing Ctrl+B (or Cmd+B on Mac).

3. Enter a Sample Trip and Use Smart Fill

In row 2, enter a trip. For example: 3/15/2025, Dallas TX, Memphis TN, 470 miles, TX-AR-TN.

In the "Miles per State" column, type your breakdown: TX: 210, AR: 140, TN: 120. Google Sheets will start to recognize the pattern and may auto-suggest the format as you type more rows.

What you should see: As you type similar entries in later rows, Sheets may offer an autocomplete suggestion you can accept with the Tab key.

4. Create State Total Formulas Using Sheets AI

Click on an empty cell below your data (say, row 30). Type "=" and then ask the AI: In the formula bar or using the "Help me write a formula" feature, ask: "Sum all miles in column F where the state is TX."

Alternatively, create a simple summary table at the bottom of the sheet with state names and SUMIF formulas. If you're not sure how, type your question in a free chatbot: "Write a Google Sheets SUMIF formula to add up all miles for Texas from column F where column E contains 'TX'."

What you should see: A formula that auto-totals your Texas miles from all trips.

5. Duplicate for Each Quarter

At the end of Q1, make a copy of the sheet (right-click the tab at the bottom, "Duplicate") and clear the data rows. Now you have a clean Q2 tracker with all your formulas intact.

Real Example

Scenario: You ran Dallas→Memphis→Nashville→Atlanta→Charlotte over a week.

What you enter: 5 rows, one per day with origin, destination, and state mile breakdowns.

What you get: A running total showing TX: 210 miles, AR: 140 miles, TN: 280 miles, GA: 260 miles, NC: 190 miles — ready to enter directly into your IFTA quarterly filing.

Tips

• Log every trip the same day using your phone — it takes 90 seconds while you're parked
• Your ELD (Motive, Samsara) may have an IFTA report export — cross-check it against your sheet monthly
• Keep the sheet open on your phone home screen for quick access
• Share the sheet with your accountant at the end of each quarter so they can pull numbers directly

Tool interfaces change — if the Smart Fill suggestion doesn't appear, you can get the same formulas by asking ChatGPT or Claude to write them for you.