🔍
Trucking settlement report automation: a sample earnings statement with a breakdown of loads and driver's share, plus one-click buttons that create the PDF, email it to the driver and archive the payment.
Earnings statement for a sample driver: final pay for the period is calculated from your entries, with an earnings breakdown by trip that is easy to update for each driver, and other additions and deductions.
Earnings statement drop-down list: choose any driver's name and their information fills in.
Earnings statement: enter the driver's percentage, and each load's pay is calculated from the load revenue.
Earnings statement: the other additions and deductions section, such as trip expense reimbursements and cash advances.
The earnings statement updates automatically as data is entered: final pay, each load's pay, deductions and the pay amount.
A completed trucking earnings statement with loads, driver's share, other additions and deductions, and a detachable pay section.
When the earnings statement is ready, choose Generate and Send Statement from the menu to open the Send Pay Statement window.
A PDF preview of the pay statement is created to review, print or send by email.
The approved PDF is attached to the email automatically; an example of the email the driver receives.
After the email is sent, the earnings statement data is archived to another tab with date sent, period, stub and check numbers, final pay and recipient email.
This is a digital product; no physical item is sent. One PDF with download instructions is provided after payment. Works with Google Sheets only.
  1. Trucking settlement report automation: a sample earnings statement with a breakdown of loads and driver's share, plus one-click buttons that create the PDF, email it to the driver and archive the payment.
  2. Earnings statement for a sample driver: final pay for the period is calculated from your entries, with an earnings breakdown by trip that is easy to update for each driver, and other additions and deductions.
  3. Earnings statement drop-down list: choose any driver's name and their information fills in.
  4. Earnings statement: enter the driver's percentage, and each load's pay is calculated from the load revenue.
  5. Earnings statement: the other additions and deductions section, such as trip expense reimbursements and cash advances.
  6. The earnings statement updates automatically as data is entered: final pay, each load's pay, deductions and the pay amount.
  7. A completed trucking earnings statement with loads, driver's share, other additions and deductions, and a detachable pay section.
  8. When the earnings statement is ready, choose Generate and Send Statement from the menu to open the Send Pay Statement window.
  9. A PDF preview of the pay statement is created to review, print or send by email.
  10. The approved PDF is attached to the email automatically; an example of the email the driver receives.
  11. After the email is sent, the earnings statement data is archived to another tab with date sent, period, stub and check numbers, final pay and recipient email.
  12. This is a digital product; no physical item is sent. One PDF with download instructions is provided after payment. Works with Google Sheets only.

Trucking Business

Truck Driver Settlement Report System (Google Sheets)

$24.99

Digital Download
  • Instant download after payment
  • No sales tax, no hidden fees
  • Excel and/or Google Sheets files
How does it work?

Check out the Youtube video on how to use it below.

What will I get?

You will receive 1 PDF instruction guide on how to save the file and enable Google Scripts. This template is exclusively compatible with Google Sheets ONLY and requires users to enable 1 Google Sheets script for full functionality

How will I get the files?

Once your payment is successfully processed, you will receive instant access to download links for your digital product. A confirmation email will also be sent with downloadable links.

Returns & Exchanges?

These are digital products and sales are final. If a template does not work as described, you may report the issue within 7 days of purchase and may be eligible for a refund under the Terms of Service.

About this template

This truck driver settlement report works in Google Sheets. It is the Truck Driver Settlement Report System (Google Sheets), designed by a licensed CPA.

What is in the truck driver settlement report

The template includes a sample earnings statement with a breakdown of loads and driver’s share, plus one-click buttons that create the PDF, email it to the driver and archive the payment.

Who uses it

Owner-operators and trucking companies that pay drivers by the load, by the mile or by a percentage. See all driver settlement templates.

What you receive

One PDF guide with the link to the Google Sheets file and the steps to save it to your Google Drive and turn on its scripts. It works in Google Sheets only.

How does it work?

Check out the Youtube video on how to use it here:

Reviews

Reviews

There are no reviews yet.

Be the first to review “Truck Driver Settlement Report System (Google Sheets)”

Your email address will not be published. Required fields are marked *