Mileage Reimbursement Calculator & Business Trip Ledger
Enter dated trips, business miles, parking and tolls to estimate reimbursement at your company's rate. Compare the mileage portion with the U.S. IRS business rate in effect for each supported trip date, including the July 1, 2026 change. The trip ledger records which miles were excluded, which fees the entered policy covers and which dates lack a benchmark.
Mileage reimbursement worksheet
Compare your company’s policy with the IRS mileage rate on each covered trip date.
Company policy
IRS business rates cover trip dates in 2025 and 2026. Enter your own policy rate for all other dates.
Mileage reimbursement estimate
Estimated company reimbursement $79.38.
105.0 business mi · 12.5 excluded mi
Company mileage is $6.02 below the IRS benchmark on covered trips.
Mileage pay by rate period
Mileage amounts in USD. Parking and tolls are shown separately.
202525.0 mi
- Company mileage
- $16.88
- IRS mileage benchmark
- $17.50
Jan–Jun 202640.0 mi
- Company mileage
- $27.00
- IRS mileage benchmark
- $29.00
Jul–Dec 202640.0 mi
- Company mileage
- $27.00
- IRS mileage benchmark
- $30.40
Edit trip records
Business trip ledger
Company amounts include only fees your policy covers. Excluded trips stay visible for your records.
| Trip and date | Miles | Company mileage | Company fees | Company total | IRS rate (¢/mi) | IRS mileage |
|---|---|---|---|---|---|---|
Vendor pickup 2025-12-18 · Business | 25.0 | $16.88 | $3.50 | $20.38 | 70.0 | $17.50 |
Client workshop 2026-06-30 · Business | 40.0 | $27.00 | $0.00 | $27.00 | 72.5 | $29.00 |
Site inspection 2026-07-01 · Business | 40.0 | $27.00 | $5.00 | $32.00 | 76.0 | $30.40 |
Regular commute 2026-07-02 · Excluded | 12.5 | $0.00 | $0.00 | $0.00 | — | — |
| Business total | 105.0 | $70.88 | $8.50 | $79.38 | $76.90 |
Show selectable CSV
How to use this calculator
- Enter your company's rate in cents per mile. Indicate whether the policy reimburses the entered parking and tolls.
- Enter each trip's date, label, distance and parking or tolls. Mark trips outside the claim as excluded.
- Check the company estimate and the mileage-only comparison for covered dates. Use the period chart to see where the rate changes.
- Open the trip ledger to check individual amounts and export the CSV for your records.
The Formula
The mathematical logic powering this calculation is:
Company mileage for each included trip equals miles × company cents per mile ÷ 100. Round that amount to cents, with half-cents rounding up. Add entered parking and tolls to the company estimate when the policy reimburses them. Excluded trips stay in the ledger and contribute no reimbursement.
The mileage-only IRS benchmark uses 70.0¢/mi for 2025, 72.5¢/mi from January through June 2026, and 76.0¢/mi from July through December 2026. Round each modeled benchmark trip to cents. The benchmark difference compares the mileage portion on the same covered business trips. Company payments for trips on all supported input dates still appear in the total, even when the IRS comparison is unavailable for some trips.
This worksheet covers one U.S. company rate throughout the entered dates and 1–31 trips. It takes trip dates from 2000–2099, distance from 0.1–100,000 miles to one decimal, rates from 0–500 cents per mile to one decimal, and parking and tolls from $0–$100,000 to the cent. Enter zero fees where none apply. The company rate is editable and comes from your policy. The IRS comparison is a dated business-rate benchmark. Tax treatment and requirements for an individual reimbursement depend on facts beyond this worksheet.Worked Example
If you input:
- Company rate (¢/mi): 67.5
- Reimburse parking and tolls: Yes
- Business trips: 25.0 mi on Dec 18, 2025 and 40.0 mi on each of Jun 30 and Jul 1, 2026
- Business parking and tolls: $3.50, $0.00 and $5.00
- Excluded trip: 12.5 mi with $2.00 fees on Jul 2, 2026
Result:
The company estimate is $79.38, consisting of $70.88 mileage and $8.50 parking and tolls. The dated IRS mileage benchmark is $76.90 on 105.0 business miles, so the comparable company mileage is $6.02 lower.
Frequently Asked Questions
What business mileage rate applies in 2026?
The IRS standard business rate is 72.5 cents per mile from January 1 through June 30 and 76 cents per mile from July 1 through December 31. The calculator compares each included trip using its entered date.
Is the IRS mileage rate the amount my employer will pay?
Use the company rate from your written reimbursement policy to model payment. The IRS business rate provides a separate dated benchmark.
How are parking and tolls treated?
The company estimate includes these fees on included trips when you enable the policy option. The comparison with the IRS rate uses mileage amounts only.
Can I enter miles outside 2025 and 2026?
Yes. The company amount still uses your entered rate, and the ledger marks the IRS benchmark as unavailable for those trips. A partial comparison uses only covered mileage.
Why might my spreadsheet differ by a cent?
This worksheet rounds mileage amounts for each trip to cents and then sums them. A policy that rounds the miles or totals once for a full claim can produce a different amount.
Does the CSV establish tax eligibility?
The CSV keeps the entered dates, purposes and amounts with the results. Check trip eligibility, substantiation and reporting rules separately when preparing a claim or return.
Similar Calculators
Lease Mileage & Allowance Planner
Forecast lease mileage from odometer readings, weekly driving and trips. Compare excess charges and quoted mileage packages with monthly charts, budgets and CSV.
Fuel Cost Calculator
Calculate the fuel cost and consumption for any road trip or daily commute.
Commute Cost Monthly Calculator
Estimate monthly commuting cost from distance, workdays, fuel economy, and gas price.
Invoice Tax & Rounding Reconciliation
Reverse tax-inclusive prices, add tax to net prices, and reconcile invoice discounts and credits. Compare line and group rounding with exact audit ledgers.
