Excess Mileage Cost Calculator for Shipping & Logistics

Calculator Inputs

Shipment ID

Contracted Miles

Actual Miles

Included Grace Miles

Base Rate per Mile

Excess Rate per Mile

Fuel Surcharge %

Tolls

Other Accessorial Fees

Discount %

Tax %

Number of Loads

Currency

Reset

Example Data Table

This sample table shows how different transport loads can create higher or lower overage exposure under common shipping and logistics pricing rules.

Shipment	Contracted Miles	Actual Miles	Grace Miles	Billable Excess Miles	Excess Cost	Total Cost
TRK-201	420.00	463.00	10.00	33.00	$100.65	$1,193.99
TRK-202	610.00	655.00	20.00	25.00	$80.00	$1,799.39
TRK-203	300.00	298.00	12.00	0.00	$0.00	$710.37
TRK-204	750.00	824.00	25.00	49.00	$166.60	$2,456.35
Total	2,080.00	2,240.00	—	107.00	$347.25	$6,160.11

Formula Used

Billable Excess Miles
Billable Excess Miles = max(Actual Miles − Contracted Miles − Included Grace Miles, 0)

Base Trip Cost
Base Trip Cost = Contracted Miles × Base Rate per Mile

Excess Mileage Cost
Excess Cost = Billable Excess Miles × Excess Rate per Mile

Fuel Surcharge
Fuel Surcharge = (Base Trip Cost + Excess Cost) × Fuel Surcharge %

Total Cost Per Load
Total = [(Base Trip Cost + Excess Cost + Fuel Surcharge + Tolls + Accessorial Fees) − Discount] + Tax

This structure is useful when quoted route miles, actual route miles, and overage penalties must be reviewed together before billing customers or reconciling carrier invoices.

How to Use This Calculator

Enter the shipment reference for your route or billing record.
Fill in contracted miles from the quote, tender, or transport agreement.
Enter actual miles from telematics, dispatch records, or driver logs.
Add any included grace miles that should not trigger overage billing.
Enter the base mileage rate and the higher excess mileage rate.
Add fuel surcharge, tolls, and any extra accessorial fees.
Apply discount and tax percentages if your billing workflow needs them.
Set the number of loads to convert one shipment cost into a fleet total.
Press the calculate button to show results above the form.
Use the CSV or PDF buttons to export the calculated summary.

FAQs

1. What counts as excess mileage?

Excess mileage is any distance above contracted miles after subtracting grace miles. The calculator multiplies that billable overage by your excess rate to estimate added transport cost.

2. Should tolls and extra fees be included?

Yes. Tolls, detention, accessorial fees, and similar charges often sit outside mileage pricing. Adding them creates a more realistic landed shipment cost.

3. Why use separate base and excess rates?

They represent different pricing rules. The base rate covers the agreed route, while the excess rate prices unplanned or unauthorized distance.

4. What are grace miles used for?

Grace miles absorb minor route variance, dispatch changes, or driver detours without immediately triggering overage fees. They are helpful for flexible contracts.

5. Is fuel surcharge added before tax?

This template applies fuel surcharge before discount and tax, which matches many carrier models. If your contract differs, adjust the formula section in the code.

6. Can I estimate costs for multiple loads?

Yes. Use the loads field to multiply per-load cost into a fleet or batch total, useful for weekly or monthly billing reviews.

7. What if actual miles are lower than contracted miles?

No excess charge is created. Base trip cost still uses contracted miles unless your agreement bills strictly on actual miles.

8. Can this work for lease or freight contracts?

For lease billing, treat contracted miles as included mileage. For freight billing, treat them as quoted route miles and adjust rates to match your agreement.