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.

Business travel

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.

Company estimate
$79.38
$70.88 mileage · $8.50 fees
IRS mileage benchmark
$76.90
105.0 covered business miles

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

Trip 1
Trip 2
Trip 3
Trip 4

Business trip ledger

Company amounts include only fees your policy covers. Excluded trips stay visible for your records.

Trip distances, reimbursement and dated benchmarks
Trip and dateMilesCompany mileageCompany feesCompany totalIRS rate (¢/mi)IRS mileage

Vendor pickup

2025-12-18 · Business

25.0$16.88$3.50$20.3870.0$17.50

Client workshop

2026-06-30 · Business

40.0$27.00$0.00$27.0072.5$29.00

Site inspection

2026-07-01 · Business

40.0$27.00$5.00$32.0076.0$30.40

Regular commute

2026-07-02 · Excluded

12.5$0.00$0.00$0.00——
Business total105.0$70.88$8.50$79.38$76.90

Show selectable CSV

How to use this calculator

  1. Enter your company's rate in cents per mile. Indicate whether the policy reimburses the entered parking and tolls.
  2. Enter each trip's date, label, distance and parking or tolls. Mark trips outside the claim as excluded.
  3. Check the company estimate and the mileage-only comparison for covered dates. Use the period chart to see where the rate changes.
  4. 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