🔍
Trucking bundle: Ultimate Trucking Accounting and the Google Sheets trucking dispatch scheduler for up to 15 trucks a day.
Important information: this tool is designed by a licensed CPA as a general organizational tool. It is not personalized professional advice, creates no CPA-client relationship, the user verifies all information, and it is sold as-is.
Trucking dispatch scheduler for up to 15 trucks a day in Google Sheets: counts of available, urgent, booked, pending and out-of-service loads, revenue, and a daily schedule of drivers, trucks and loads.
Trucking dispatcher with the auto miles calculator: pick the week to schedule from drop-down lists; load status counts and revenue are shown, and 7 scheduling tables appear, one for each day of the week.
For owner-operators and independent dispatchers: the auto miles dispatcher calculates the week's revenue and a percentage of revenue for each load dispatched.
Truck status at a glance: each truck's status is color-coded, and a selected truck turns green to show it is available for booking.
Automated distance calculator: Google API scripts calculate the miles between two locations from the city and state, including empty and loaded miles based on the truck's location and the load's origin and destination.
Status calendar in the auto miles dispatcher: choose a status to see the trucks with that status for each day of the week, with loads per day counted automatically.
Dispatch data is archived with one button, and cleared with another.
Ultimate Trucking Accounting: a collage of its sheets, including the financial overview dashboard, load search, profit and loss, comparative profit and loss, weekly overview, and miles and fuel summary.
The difference between the two sets: the IFTA set requires state-by-state travel entries for IFTA reporting; the non-IFTA profit and loss trackers do not. Feature tables compare the Ultimate, Elite, Advanced, Pro and Standard editions and the P&L, V2 and V3 trackers.
Features of the Ultimate, Elite, Advanced, Pro and Standard trucking accounting editions compared, with Ultimate highlighted: Ultimate includes every feature, including load search and all dashboards.
Dynamic financial overview dashboard: pick any month, quarter or year to date to see net cash flow, net profit, income, fixed, variable and reimbursable expenses, and mileage and fuel figures.
Trucking daily and weekly overview: pick the start day, week and month to see quick financial results for the week, each day's operation and financial data, and the highest and lowest variable and fixed expenses for each day.
Trucking profit and loss with notes: data is organized by month, quarter and year to date; all descriptions can be edited, with pay types, fixed and variable costs, profit per mile and cash flow after all costs and reimbursements.
Month-over-month and quarter-over-quarter comparative financials: pick the current and prior period from drop-down lists to compare operation information, trucking income and operating expenses with dollar and percent change.
Trucking profit and loss analysis with a start month and year selector: data is pulled from the income, expense and miles and fuel logs to create monthly, quarterly and annual statements.
Miles and fuel summary by state, an aid for IFTA reporting: pick any month, quarter or year to date to see miles, gallons and fuel rates by state, pulled from the miles and fuel log.
Load search: type a load number to see its operational, financial and load data, including expected versus actual performance, fuel usage and states traveled.
Income and expense description setup: edit the descriptions in the yellow cells and they update throughout the spreadsheet.
Load setup to track all loads, and a miles and fuel log to track fuel and miles by state; states with weight-mile tax are highlighted yellow.
Income and expense logs: pick the load each income or expense entry belongs to from a drop-down list, to keep a record of each load's revenue and expenses.
This is a digital product; no physical item is sent. Ultimate Trucking Accounting: 1 Excel file and 1 PDF with a Google Sheets link, Excel 2021 or later. Trucking Dispatcher: 1 PDF with a Google Sheets link, Google Sheets only.
  1. Trucking bundle: Ultimate Trucking Accounting and the Google Sheets trucking dispatch scheduler for up to 15 trucks a day.
  2. Important information: this tool is designed by a licensed CPA as a general organizational tool. It is not personalized professional advice, creates no CPA-client relationship, the user verifies all information, and it is sold as-is.
  3. Trucking dispatch scheduler for up to 15 trucks a day in Google Sheets: counts of available, urgent, booked, pending and out-of-service loads, revenue, and a daily schedule of drivers, trucks and loads.
  4. Trucking dispatcher with the auto miles calculator: pick the week to schedule from drop-down lists; load status counts and revenue are shown, and 7 scheduling tables appear, one for each day of the week.
  5. For owner-operators and independent dispatchers: the auto miles dispatcher calculates the week's revenue and a percentage of revenue for each load dispatched.
  6. Truck status at a glance: each truck's status is color-coded, and a selected truck turns green to show it is available for booking.
  7. Automated distance calculator: Google API scripts calculate the miles between two locations from the city and state, including empty and loaded miles based on the truck's location and the load's origin and destination.
  8. Status calendar in the auto miles dispatcher: choose a status to see the trucks with that status for each day of the week, with loads per day counted automatically.
  9. Dispatch data is archived with one button, and cleared with another.
  10. Ultimate Trucking Accounting: a collage of its sheets, including the financial overview dashboard, load search, profit and loss, comparative profit and loss, weekly overview, and miles and fuel summary.
  11. The difference between the two sets: the IFTA set requires state-by-state travel entries for IFTA reporting; the non-IFTA profit and loss trackers do not. Feature tables compare the Ultimate, Elite, Advanced, Pro and Standard editions and the P&L, V2 and V3 trackers.
  12. Features of the Ultimate, Elite, Advanced, Pro and Standard trucking accounting editions compared, with Ultimate highlighted: Ultimate includes every feature, including load search and all dashboards.
  13. Dynamic financial overview dashboard: pick any month, quarter or year to date to see net cash flow, net profit, income, fixed, variable and reimbursable expenses, and mileage and fuel figures.
  14. Trucking daily and weekly overview: pick the start day, week and month to see quick financial results for the week, each day's operation and financial data, and the highest and lowest variable and fixed expenses for each day.
  15. Trucking profit and loss with notes: data is organized by month, quarter and year to date; all descriptions can be edited, with pay types, fixed and variable costs, profit per mile and cash flow after all costs and reimbursements.
  16. Month-over-month and quarter-over-quarter comparative financials: pick the current and prior period from drop-down lists to compare operation information, trucking income and operating expenses with dollar and percent change.
  17. Trucking profit and loss analysis with a start month and year selector: data is pulled from the income, expense and miles and fuel logs to create monthly, quarterly and annual statements.
  18. Miles and fuel summary by state, an aid for IFTA reporting: pick any month, quarter or year to date to see miles, gallons and fuel rates by state, pulled from the miles and fuel log.
  19. Load search: type a load number to see its operational, financial and load data, including expected versus actual performance, fuel usage and states traveled.
  20. Income and expense description setup: edit the descriptions in the yellow cells and they update throughout the spreadsheet.
  21. Load setup to track all loads, and a miles and fuel log to track fuel and miles by state; states with weight-mile tax are highlighted yellow.
  22. Income and expense logs: pick the load each income or expense entry belongs to from a drop-down list, to keep a record of each load's revenue and expenses.
  23. This is a digital product; no physical item is sent. Ultimate Trucking Accounting: 1 Excel file and 1 PDF with a Google Sheets link, Excel 2021 or later. Trucking Dispatcher: 1 PDF with a Google Sheets link, Google Sheets only.

Trucking Business

Trucking Bundle – Ultimate Accounting & Google Sheets Dispatcher

$47.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 Excel file (compatible with Excel 2021 and later)
  • 2 PDFs with a link to a Google Sheet, allowing you to easily make a copy to your Google Drive

⚠ Important: The dispatcher Google Sheets template requires enabling three scripts 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 trucking bookkeeping and dispatch bundle works in Excel and Google Sheets. It is the Trucking Bundle – Ultimate Accounting & Google Sheets Dispatcher, designed by a licensed CPA.

What is in the trucking bookkeeping and dispatch bundle

The template includes ultimate Trucking Accounting and the Google Sheets trucking dispatch scheduler for up to 15 trucks a day.

Who uses it

Owner-operators and small fleets that want bookkeeping and dispatch in one purchase. See all trucking bundles.

What you receive

One Excel file (Excel 2021 or later) and a PDF with a link to the Google Sheets version.

How does it work?

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

Ultimate Trucking Accounting

Dispatcher

Reviews

Reviews

There are no reviews yet.

Be the first to review “Trucking Bundle – Ultimate Accounting & Google Sheets Dispatcher”

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