IFTA spreadsheet template that catches surcharge states your current template misses

Your IFTA spreadsheet is missing surcharge states if it doesn't have a separate calculation row for Kentucky (2.0¢/gal), Virginia (6.5¢/gal), New York (0.95¢/gal), and New Mexico (1.0¢/gal). These four states calculate surcharges on total taxable gallons with zero tax-paid credit, meaning they're always owed and never generate a refund.

Five columns every IFTA template must have (and why most miss the surcharge trap)

A standard IFTA template has the basics: Jurisdiction, Miles Driven, Gallons Purchased, Fleet MPG, Taxable Gallons, Base Tax Rate, Base Tax Owed. But that's where most people stop. The missing piece is a Surcharge Flag column that triggers a separate surcharge calculation line.

This matters because Kentucky drivers see a 2.0¢ surcharge on every gallon consumed in KY—not on net taxable gallons after you subtract tax-paid credit. Miss this column and your KY liability is understated by 20–40 gallons × $0.02 per quarter. Virginia's surcharge alone ($0.065/gal) adds $11–$15 per 200 gallons driven.

Over a year, that's $44–$60 of unaccounted tax per state. Over an audit period, it's a penalty.

The surcharge flag doesn't add complexity; it forces you to build two rows per surcharge state instead of trying to squeeze base and surcharge into one line. That separation stops the underreporting.

Template structure: How to lay out rows so surcharge calculations don't bleed into base tax

Each state gets two rows: one for base tax, one for surcharge (if applicable).

Base tax row: (Miles in state ÷ Fleet MPG) × Base Rate − Tax Paid Credit = Net Tax Due

Surcharge row (KY/VA/NY/NM only): (Miles in state ÷ Fleet MPG) × Surcharge Rate = Surcharge Due (no credit allowed)

Indiana is a special case. As of Q2 2026, Indiana's historical surcharge ($0.55/gal) is rolled into the base diesel rate ($0.6300/gal all-in); use only the base row, do not create a separate surcharge row for IN. Older templates with a hard-coded Indiana surcharge line will now double-count by adding $0.55 to $0.63, overstating Indiana liability by roughly $0.55/gal × taxable gallons—typically $100–$250 per quarter.

The two-row structure prevents $80–$150+ quarterly errors because it forces you to acknowledge that surcharge and base tax have different credit rules.

Worked example: A four-state quarter with Virginia surcharge

Driver runs 5,400 total miles in Q2 2026 with 800 gallons purchased (fleet MPG = 6.75). Breakdown: 1,200 miles in VA (200 gal bought), 1,800 miles in TX (300 gal bought), 1,400 miles in NC (180 gal bought), 1,000 miles in KY (120 gal bought).

The driver gets a $2.66 refund from base tax (tax paid exceeds base tax owed), but owes $14.52 in combined surcharges (Virginia + Kentucky). Net result: $11.86 owed to the states.

If you don't separate the surcharge row, Virginia's total rate ($0.249/gal = $0.184 + $0.065) gets confused with tax-paid credit logic. You might apply the credit to the combined rate instead of just the base, or forget the surcharge entirely. Result: $60–$90 underreported per surcharge state per quarter.

How to populate your template each quarter

IFTA Inc. publishes the official tax rate matrix before each quarter begins. Use rates in effect during the quarter you're filing, not current rates. Q2 2026 rates lock on April 1; if you file on July 15, you still use Q2 rates, not Q3 rates.

Download the rate table, create a reference tab in your spreadsheet, and use VLOOKUP to pull rates by state code. This cuts transcription errors by ~95%. The official IFTA Inc. tax rate matrix covers all 10 Canadian provinces and 48 US states quarterly.

Surcharge rates are published in the same matrix. Flag KY, VA, NY, NM, and verify Indiana is no longer separate. Check every quarter because state surcharge changes happen without warning.

Why Indiana's Q2 2026 rate change broke older templates

Indiana historically had a separate diesel surcharge (~$0.55/gal) listed as a line item. As of Q2 2026, that surcharge is rolled into the base diesel rate of $0.6300/gal all-in, making Indiana's effective rate the highest in the country.

Older templates with a hard-coded Indiana surcharge row will now double-count by adding $0.55 to $0.63, overstating Indiana liability by $0.55/gal × taxable gallons (typically $100–$250 per quarter). Delete the separate Indiana surcharge row and use only the base rate row ($0.6300/gal).

Check your IFTA rate source quarterly. Consolidations like Indiana's happen without warning and will break your template if you don't catch them.

The audit trap: Forgetting that surcharges are calculated on consumed gallons

Base tax follows this formula:

(State Miles ÷ Fleet MPG) × Rate − Tax Paid = Net Due

Surcharge follows this:

(State Miles ÷ Fleet MPG) × Surcharge Rate = Amount Due (tax paid is NOT a credit; surcharge is always owed)

The common error is treating Virginia's 6.5¢ surcharge as if it's subject to the tax-paid credit. It's not. If you drove 1,200 miles in Virginia and consumed 178 gallons (at 6.75 MPG), you owe Virginia 178 × $0.065 = $11.57 in surcharge, period. It doesn't matter how much diesel you bought in Virginia.

Missing surcharge on even one state triggers a 10–25% penalty on the deficiency plus interest. That's $50–$150+ per surcharge state per quarter over a multi-year audit period.

Template columns in order

• Column A: Jurisdiction (TX, VA, KY, etc.)
• Column B: Total Miles Driven (IFTA-qualified miles only)
• Column C: Gallons Purchased in State (from fuel receipts)
• Column D: Fleet MPG (single value for all states: total miles ÷ total gallons)
• Column E: Taxable Gallons Consumed (Column B ÷ Column D)
• Column F: Base Tax Rate (pull from current-quarter IFTA Inc. rate matrix)
• Column G: Base Tax Owed (Column E × Column F)
• Column H: Surcharge Flag (Y/N or leave blank)
• Column I: Surcharge Rate (only if Column H = Y)
• Column J: Surcharge Owed (Column E × Column I; no credit allowed)
• Column K: Tax Paid at Pump (from fuel receipts or credit card statement)
• Column L: Net Taxable Gallons (Column E − Column K)
• Column M: Tax Credit Applied (Column L × Column F)
• Column N: State Result (Column G − Column M + Column J = final due or refund)

Save this as a template and use it every quarter. The two-row structure will catch what your old template missed.