About this template
A weekly driver pay settlement workbook for small fleet owners that calculates per mile and percentage pay and prints a signable statement.
What you get
- 05-Driver-Pay-Settlement-Sheet-Per-Mile-and-Percentage.xlsx (Excel workbook) with four parts: Setup, Loads (a 40-load log), Adjustments, and a one-page Settlement statement.
- 05-Driver-Pay-Settlement-Sheet-Per-Mile-and-Percentage.pdf (print-ready PDF) on US Letter paper.
If you settle driver pay by hand every week, this sheet does the math for you and gives you a clean statement to sign.
File types
- Excel workbook (.xlsx): works in Excel 2013 or newer, Google Sheets and LibreOffice.
- PDF: prints on US Letter paper.
- Instant digital download. Nothing is mailed. Download links appear after purchase.
How to use
1. Open the Setup tab and enter your pay rules once.
2. Log each load on the Loads tab (room for 40 loads).
3. Add any advances or reimbursements on the Adjustments tab.
4. Open the Settlement sheet, review the totals, and print it for signing.
5. Check your written driver agreement and your state's rules for allowed deductions before you finalize anything.
Who it is for
- Small fleet owners and owner-operators who pay drivers by the mile or by a percentage of the load.
- Dispatchers or office staff who prepare weekly driver settlements in a spreadsheet.
- Anyone who wants a simple, printable record of what was paid and why.
What it is NOT
- It is not tax, legal or financial advice. Check rules and rates with the official source or a qualified professional.
- It is not accounting software or payroll software. It is a template you fill in.
- It is not a source of market rates. Every number shown in the example is a placeholder, not a market rate, tax rate or legal requirement.
- It is not one-size-fits-all. Adapt it to your own situation, driver agreement and state rules.
- It is a digital file only. No physical item is shipped.
Created with AI assistance and checked with automated tests.
Questions
What file types do I get?
You get an Excel workbook (.xlsx) and a print-ready PDF for US Letter paper. The workbook works in Excel 2013 or newer, Google Sheets and LibreOffice. It is an instant digital download and nothing is mailed.
Can I edit the formulas?
The workbook is a template you fill in and adapt to your own driver agreement and state rules. It contains 184 formulas across 5 sheets. Enter your pay rules once on the Setup tab.
Does it replace an accountant or tell me what deductions are allowed?
No. It is a planning tool and not tax, legal or financial advice, and it is not payroll software. Check your written driver agreement, your state's rules and a qualified professional before you finalize anything.
