Miles-per-state calculator: allocate jurisdictional mileage from odometer checkpoints and fuel receipts

Divide your total miles by total gallons purchased to get fleet average MPG, then multiply each state's miles by that MPG to determine how many gallons you consumed in that jurisdiction—the only method state auditors accept without odometer and fuel-receipt reconciliation.

The three-step formula: total MPG → state miles → state fuel allocation

IFTA allocates fuel tax by jurisdiction based on miles driven, not fuel purchased. This creates the core calculation you need to file correctly.

Step 1: Fleet Average MPG equals Total Miles divided by Total Gallons, rounded to exactly 2 decimal places. A variance of 0.01 in your MPG compounds across all four states, so precision here matters.

Step 2: State Miles times Fleet Average MPG equals Gallons Consumed in That State. This is where your odometer readings and fuel receipts earn their weight in an audit.

Step 3: Compare consumed gallons to purchased gallons for each state. If you consumed more gallons in a state than you actually bought there, you owe fuel tax on the difference. If you bought more than you consumed, you claim a credit.

Worked example: Q2 2026 multi-state run with odometer checkpoints and fuel receipts

An owner-operator runs 6,200 total miles in Q2 2026 across Texas, Oklahoma, Missouri, and Kansas. Odometer readings at state borders show: Texas 1,800 miles, Oklahoma 1,400 miles, Missouri 2,000 miles, Kansas 1,000 miles.

Fuel receipts document 920 gallons purchased across the quarter: 350 gallons in Texas (June 3, 12, 20 receipts), 200 gallons in Oklahoma (June 5, 18), 270 gallons in Missouri (June 8, 22, 27), and 100 gallons in Kansas (June 10).

Fleet average MPG = 6,200 miles ÷ 920 gallons = 6.74 MPG

Now apply that 6.74 MPG to each state's odometer miles:

In Texas, you purchased 83 more gallons than your miles required—you claim a credit against Texas fuel tax. In Oklahoma, Missouri, and Kansas, your mileage exceeded your fuel purchases, creating tax liabilities. The net effect depends on each state's fuel-tax rate, but this allocation is what auditors accept as your jurisdictional apportionment.

Odometer readings at state borders are your audit defense, not GPS trace

State Department of Revenue auditors compare three documents: trip sheets with odometer entry and exit readings at state lines, actual fuel receipts by date and location, and your quarterly IFTA return filing. GPS logs alone do not satisfy this requirement.

GPS shows your route but not your fuel responsibility. A 2–5% variance between GPS miles and odometer readings is normal and acceptable to auditors. However, if your odometer-based allocation matches fuel purchases within tolerance, auditors ignore GPS discrepancies. The reverse is not true: if your GPS and odometer mileages diverge but your odometer-to-fuel reconciliation is clean, you keep your filing intact.

Record odometer at every state-line crossing. If you use ELD data, reconcile the totals to your actual odometer readings. Round mileage to the nearest whole mile. Missing odometer readings force auditors to reject your state allocation entirely and reconstruct using their own MPG assumptions—typically 5.5 MPG, which inflates your liability significantly.

A driver in this example who recorded 1,800 miles in Texas (odometer 45,200 to 47,000) but whose GPS showed 1,750 miles faces no audit risk if fuel receipts corroborate the odometer total. Auditors care that your allocation method is verifiable and repeatable, not that it matches GPS to the mile.

Fuel receipts must show date, seller, gallons, and vehicle ID—not credit card statements alone

A valid fuel receipt includes: date of purchase, seller name and address, gallons purchased, fuel type, VIN or unit number, and purchaser name. Credit card statements alone do not satisfy IFTA audit requirements; auditors need the actual itemized receipt to verify gallons and location.

Scan or photograph every fuel receipt at the pump and store indexed by date and state. Four-year retention is required by law.

Trip sheets created at the time of travel—not reconstructed after the quarter—showing origin, destination, odometer start and end, and miles per state strengthen your audit position immensely. A trip sheet dated June 12 showing "departed Houston 45,500 mi, arrived Oklahoma City 45,750 mi, purchased 250 gal in TX at truck stop receipt #1547" is auditor gold. A spreadsheet built in August claiming "I drove about 250 miles in Texas in June" is auditor red flag.

Common audit trigger: round-number fuel entries (exactly 500 gallons per month for three months straight, or exactly 250 gallons per fill-up every time). This pattern signals reconstruction, not actual logging. Variance of ±5–10 gallons per fill-up is realistic; identical round numbers across a quarter are not.

When consumed gallons exceed purchased: you owe tax on the difference; when you buy more than you consume: you claim a credit

In the worked example, Texas consumed 267 gallons but you purchased 350 gallons there. You purchased 83 more gallons in Texas than your miles required. You claim an 83-gallon credit against Texas fuel tax.

Inverse scenario: Missouri consumed 297 gallons but you only purchased 270 gallons there. You owe fuel tax on 27 gallons of "phantom consumption" in Missouri—an IFTA debit to your account, increasing your net tax liability.

This mismatch arises from variation in fuel efficiency across routes, loading, and season. Auditors expect small variances—typically within 3–5% of total gallons—but flag patterns. A driver showing consistent over-consumption in one state across three quarters suggests odometer gaming or route misalignment and triggers investigation.

Your quarterly return lists state-by-state credits and debits. Net refund or net payment is determined by the sum across all jurisdictions. If Texas credit of 83 gallons exceeds the combined Missouri, Oklahoma, and Kansas liabilities, you receive a refund. If liabilities exceed credits, you owe.

Rounding and precision rules: MPG to 2 decimals, mileage to whole miles, quarters rounded before state allocation

Calculate total MPG to exactly 2 decimal places. 6.734 rounds to 6.73, not 6.74 (standard rounding rules apply). A 0.01 error in MPG compounds across all states and can flip a small refund into a small liability.

Round all individual state mileage entries to whole miles before applying MPG. 1,799.6 miles rounds to 1,800. Do not round intermediate calculation steps; calculate consumed gallons per state as (state miles × fleet MPG) and round the final gallon figures to whole gallons for tax purposes.

Some auditors tolerate ±1 gallon rounding error per state due to decimal precision. Errors of 5 or more gallons per state trigger variance investigation. If your Missouri calculation shows 297.3 gallons consumed and 270 purchased, that is a 27-gallon variance. If your rounding methodology created a 32-gallon variance, auditors request explanation.

Tax-exempt miles must be logged separately but still count toward total mileage for IFTA filing

Some jurisdictions allow exemptions for miles on private property, ferry crossings, or specific cargo types. You must report total miles—including exempt—and then separately deduct exempt miles from taxable miles for that state.

Example: if you drove 50 tax-exempt miles in Missouri (private-property dead-head to a warehouse), your total Missouri mileage is still 2,000 for the worked example above. Your taxable mileage becomes 1,950 for Missouri fuel-tax calculation purposes. Your fleet MPG (6.74) still applies to the full 2,000 miles to determine your MPG baseline, but the tax bill applies only to the 1,950 taxable miles.

Audit risk: incorrectly excluding exempt miles from total mileage inflates your MPG and reduces your liability in all states. Auditors cross-check state-by-state totals and flag inconsistencies. Keep documentation—permits, receipts, route logs—proving exempt status for each claim.

Most common calculator errors that trigger audits: inconsistent MPG figures, round-number entries, and missing fuel receipts

Fleet average MPG below 4.0 or above 9.0 for a Class 8 diesel raises immediate red flag. Typical range is 5.5–7.5 MPG. If your Q2 return shows 4.2 MPG, auditors request maintenance logs and fuel-efficiency benchmarks. Extremely high MPG (8.5+) suggests odometer under-reporting; extremely low MPG suggests fuel-purchase reconstruction.

Round-number mileage (exactly 1,000 miles per state, every month) signals reconstruction, not actual logging. Real odometer checkpoints produce variance: 1,847 miles one month, 1,652 the next, 1,701 the third. Use the actual readings from your trip sheets.

Round-number fuel purchases (exactly 200 gallons per fill-up, every time) suggest averaging or estimation. Auditors demand actual receipt dates and gallonages. Real fueling shows 247 gallons on one date, 189 on another, 224 on a third.

Missing fuel receipts for even one state disable your entire allocation for that state. If you lost receipts for June purchases in Kansas, an auditor reconstructs using standardized assumptions—typically assuming you burned fuel at the state's average fleet MPG (often 5.5), not your actual 6.74. This inflates your liability.

Large refund claims (over 10% of total tax paid) invite automatic audit. Most accurate returns claiming small refunds or net payments escape scrutiny because they show realistic fuel variability. A claim for a $3,000 refund on a $4,000 quarterly liability draws eyes.

Keep your calculations tight, your receipts complete, and your odometer entries real. The three-step formula is bulletproof if your inputs are auditable.