A driver pay per mile spreadsheet helps carriers organize trip mileage, driver rates, extra compensation, reimbursements, deductions, and pay status. This free Excel template provides a structured pay log for U.S. dollars and miles, with separate Dashboard, Pay Log, Driver Summary, and Settings sheets.
Users enter trip and pay details in designated cells. Formula cells calculate Paid Miles, rates, Mileage Pay, gross earnings, and total payable. The supplied file contains populated sample records as well as blank operating rows. These figures are pay estimates and should be checked against source documents and company pay policies before payment.
In practice
What this workbook helps you do
- ✓Combines loaded and empty miles to calculate paid miles for each trip or load.
- ✓Uses driver default rates while allowing a different per-mile rate for an individual row.
- ✓Keeps mileage pay, detention pay, stop pay, other pay, reimbursements, and deductions separate.
- ✓Summarizes trips, miles, earnings, payable amounts, statuses, and check flags by pay period.
Instructions
How to use the file
Configure company and driver pay settings
Begin on Settings. Enter the company name, pay period length, currency, and distance unit. The supplied settings use USD and miles. Add each unique Driver ID, Driver Name, Active value, Default Rate/Mile, Stop Rate, and Detention Rate/Hour in rows 10 through 109. Enter available pay period end dates in J3:J102. The current status options are Open, Approved, and Paid.
Replace sample trips and enter operating records
On Pay Log, edit only the yellow cells. User-entry columns include Pay Period End, Trip Date, Driver ID, Trip/Load #, Origin, Destination, Loaded Miles, Empty Miles, Rate Override, Detention Hours, Extra Stops, Other Pay, Reimbursements, Deductions, Status, and Notes. Pay Period End, Trip Date, Driver ID, and Trip/Load # are required by the row check.
The log has 1,000 formula-prepared data rows from row 5 through row 1004. Rows 5 and 6 shown in the manifest contain sample trips and are not blank operating rows. Replace or clear sample input values without overwriting calculated cells, then use the remaining blank prepared rows for operating records.
Review rates, earnings, and row checks
Blue-gray cells are calculated. Driver Name and default rates come from Settings. Paid Miles equals Loaded Miles plus Empty Miles. Effective Rate/Mile uses Rate Override when entered; otherwise, it uses the driver's default. Mileage Pay equals Paid Miles times the effective rate. Detention Pay and Stop Pay use their corresponding quantities and rates.
Gross Earnings adds mileage, detention, stop, and other pay. Total Payable adds reimbursements and subtracts deductions. Review the Check column for missing required inputs, an unknown driver, a duplicate Trip/Load #, a trip after the period end, a trip outside the configured period, or miles requiring review.
Select the reporting period and driver
On the Dashboard, choose a pay period end in B3 and either All Drivers or a Driver ID in E3. The calculated panels show trips, paid miles, mileage pay, gross earnings, reimbursements, deductions, total payable, average mileage rate, pending payable, check flags, and status totals. Driver Summary follows the same selected period and provides one calculated row per configured driver.
Inside the file
Included features
Calculate driver mileage pay by trip or load
Each Pay Log row keeps the pay period, trip date, driver, load number, route, and mileage together. Loaded Miles and Empty Miles are entered separately, while Paid Miles is their calculated sum. Mileage Pay then applies the effective per-mile rate. This structure lets dispatch or payroll staff trace a pay estimate back to a specific trip or load rather than relying only on a period total.
Handle default rates and trip-specific exceptions
Default Rate/Mile, Stop Rate, and Detention Rate/Hour are looked up by Driver ID from Settings. A blank Rate Override leaves the driver's default mileage rate in use. Entering an override changes the effective rate for that Pay Log row only. Because changing a default rate affects log rows without overrides, review existing estimates when driver rate settings are revised.
Reconcile pay-period totals by driver and status
Driver Summary reports trips, loaded miles, empty miles, paid miles, each pay category, reimbursements, deductions, average mileage rate, and check flags for the Dashboard's selected period. Its Total Payable column represents gross earnings plus reimbursements minus deductions. Row 105 provides totals, and the filter covers driver rows 5 through 104.
The Dashboard also separates Open, Approved, and Paid trip counts and payable amounts. Pending Payable includes rows whose status is not Paid.
Use workbook controls without overstating their scope
Validation is configured for practical entry ranges, including 0 to 5,000 miles, per-mile overrides from $0 to $5, detention from 0 to 100 hours, 0 to 20 extra stops, and $0 to $10,000 for other pay, reimbursements, and deductions. Pay period length accepts 1 to 31 days.
These controls and formulas support pay estimates; they do not verify source records or company policy. The file does not replace accounting, legal, tax, DOT/FMCSA, safety, or compliance advice.
Common questions
About this workbook
Settings provides 100 driver rows from 10 through 109. Pay Log provides 1,000 formula-prepared rows from 5 through 1004. The pay-period list has 100 date cells from J3 through J102. Some initial rows contain sample data, while the remaining unused rows are blank operating rows.
No such exclusion is confirmed by the formulas. Driver lookups and Driver Summary rows reference the Settings driver table by Driver ID without an Active criterion. Do not assume that changing Active to No removes the driver from selections or calculated summaries.
Status does not change the row's pay formulas. It groups trip counts and total payable on the Dashboard. Pending Payable includes any selected-period row with a status other than Paid, while the status section separately reports Open, Approved, and Paid amounts.
No. The single chart references Driver Summary names in B5:B9 and total payable values in N5:N9. That limits its source to the first five Driver Summary data rows, even though the summary itself provides rows for up to 100 drivers.
The pay calculations and the row check are separate formulas. A row may still calculate from the available values while the Check column identifies a missing required field, duplicate load number, driver lookup problem, date issue, or mileage issue. Review flagged rows before relying on period totals.
No. It estimates driver compensation from entered mileage, rates, extra pay, reimbursements, and deductions. It does not replace payroll processing, accounting records, legal or tax guidance, DOT/FMCSA requirements, safety procedures, or company compliance review.
Editorial team
Prepared and checked with care
Casey Morgan
Fleet operations editorCasey turns dispatch, driver, vehicle, and delivery workflows into clear workbook guides.
About the editorial identities
Jordan Lee
Workbook quality editorJordan documents the automated formula, recalculation, download, and usability checks applied before publication.
About the editorial identities