Driver pay sheet template

A printable weekly pay sheet for a 1099 driver paid by the mile, and the same layout as a spreadsheet. No email needed.

Company
Driver
Week ending
Per-mile rate
Per live load / stop-off
Detention, per hour
Load #From → ToMilesRateLive loadsStop-offsDetention (h)Extras $Pay
         
         
         
         
         
         
         
         
Miles pay
Extras (live loads, stop-offs, detention)
Bonus
Paid back (receipts)
Cash advance (−)
Net pay
Paid on (date, how)
Signed

How to fill it in

  1. The top. Your company, the driver, the Sunday the week ends, and the driver’s rates so anyone reading it later can check the arithmetic.
  2. One row per load. The carrier’s load number, where it ran, the calculated miles from the dispatch or the settlement, and the rate. Count the live loads, stop-offs and detention hours on that load, put their dollars in “Extras $”, and the load’s total in “Pay”.
  3. The week. Add the Pay column for miles and extras (or keep them apart, as the lines do), add a bonus if there was one and any receipts you’re paying back, take off any cash advance, and the net is what goes to the bank.
  4. Two copies. One for the driver, one for the file. In January the file is the year’s 1099 total.

The rules behind each column are in the glossary: a plain pickup pays no extra, a live load and each stop-off pay a flat amount, and empty miles are your call.

Questions

What should a truck driver pay sheet show?

Each load with its number, where it ran, the miles and the rate; the extras on the load — live loads, stop-offs, detention — as their own figures; then the week: miles pay, extras, bonus, receipts paid back, any cash advance taken off, and the net. The driver should be able to check every line against their own notes.

Is this a settlement sheet?

No. A settlement is what the carrier pays the owner-operator for a load. This is what the owner pays the driver. Some carriers call their statement a “driver settlement”, which is why the two get confused.

Can I use this in Excel or Google Sheets?

Yes. “Take it as a spreadsheet” gives you a .csv with the same columns, which Excel, Numbers and Google Sheets all open. Add a formula for Miles × Rate in the Pay column and it adds itself up.

Do I need to give an email address?

No. The print button and the spreadsheet link work as they are.