Transparent method
How to use this calculator
Start by choosing a single time period and definition for every input. Replace the sample values with figures from your own records. Confirm whether a field means paid miles, all miles, gross revenue, taxable cash, reimbursement, deduction, or business cost before entering it. The tool recalculates locally as a planning aid.
Use it to reconcile trip sheets, ELD or GPS mileage, odometer records, and fuel totals for the reporting period. Save more than one scenario when uncertainty matters: a conservative case, an expected case, and a strong case. Keep units and periods consistent, and write down where each assumption came from so the comparison can be repeated.
Formula and calculation sequence
Odometer miles equal ending minus beginning odometer. Fleet MPG equals reported qualified miles divided by total gallons. Variance compares entered jurisdiction mileage with odometer movement after an entered non-IFTA adjustment.
The result set includes Odometer movement, Adjusted comparison miles, Mileage variance, Absolute variance, Fleet MPG, Gallons per 100 miles. Intermediate outputs are shown when they help detect a missing cost or a mismatched unit. Zero-value and zero-denominator cases return a warning instead of displaying infinity or presenting an unsupported decision.
Worked planning example
If jurisdiction records total 24,800 miles, odometers show 25,000 miles, and 150 miles are documented as non-IFTA, the remaining 50-mile difference deserves review.
The default is only a demonstration of the interface. It is not a current market average, recommended rate, quote, tax position, carrier promise, lender term, or expected outcome. Change every default before relying on the estimate for comparison.
What this result includes—and what it does not
The tool includes only the visible fields and applies the formula described above. It cannot discover missing deductions, fuel purchases, empty miles, downtime, maintenance, contract chargebacks, tax facts, permits, exchange rates, or other items that were not entered. A mathematically correct result can still be incomplete when the source records are incomplete.
Use the estimate as a checkpoint. Compare it with the controlling contract, settlement, return, payroll system, loan disclosure, or official filing portal. Investigate a difference instead of altering inputs merely to force agreement.
- Treat the result as a planning estimate, not a payroll statement, tax return, rate confirmation, settlement, financing offer, or guarantee.
- Use contract terms, pay statements, fuel receipts, ELD records, lender disclosures, and current official guidance when they differ from an example.
- Do not use an estimate to exceed equipment ratings, hours-of-service limits, insurance requirements, or any legal or safety obligation.
Verification checklist
- Confirm that miles, gallons, hours, revenue, and costs cover the same period.
- Check units, decimal placement, and whether percentages were entered as percentages.
- Separate reimbursement, deduction, expense, tax reserve, revenue, and profit.
- Recalculate when a rate, route, contract, quarter, or source document changes.
- Retain the source documents needed for the actual business, payroll, tax, or compliance process.
Frequently asked questions
Is this result guaranteed?
No. IFTA Fleet MPG and Mileage Reconciliation Calculator produces a planning estimate from the values entered. Actual outcomes can change with documents, policy, timing, tax treatment, downtime, missing costs, and rules.
Where should the inputs come from?
Use pay statements, contracts, rate confirmations, fuel receipts, ELD or trip records, lender disclosures, accounting records, and current official sources. Replace every example default.
Does Driver Pay Calc save my values?
Calculation happens in the browser. A scenario is stored only when you choose Save on this device. Shared links contain values in the URL hash, and local downloads contain the estimate you create.
Can I use the estimate for a filing or settlement?
Use it to prepare and reconcile, not as the controlling document. A filed return, payroll statement, signed contract, carrier settlement, lender disclosure, or official system controls.
How should I compare two scenarios?
Keep definitions and periods consistent. Change one assumption at a time, save each scenario locally, and compare the decision metric described on this page rather than only the headline rate.