What it is
Trucking audits turn on revenue cutoff for loads in transit, the claims reserve for accidents and cargo, and a fleet whose useful lives and salvage values are estimates. Fuel and fuel tax add a recurring reconciliation.
The workbook sets out procedures for revenue and cutoff, fuel and taxes, equipment and leases, and insurance, claims and settlements, with a risk assessment, sign-off columns and a tie-out tab.
When to use it
- Auditing a for-hire carrier, dedicated fleet or brokerage business.
- Testing revenue in transit and the claims reserve at year end.
- Preparing lender or surety support for fleet and claims balances.
What’s inside
- Dispatch-to-invoice, in-transit and brokerage gross or net procedures
- Fuel purchase, surcharge and fuel tax program tests
- Fleet listing, depreciation, salvage value and disposal tests
- Claims reserve, owner-operator escrow and driver pay procedures
Standard cited
This template follows ASC 606 / ASC 360. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
How is revenue in transit recognized?
Many carriers recognize freight revenue over the transit period. The program recomputes the amount using the entity’s policy and tests loads around year end.
Does it cover fuel tax?
Yes. It points to the fuel tax reconciliation workbook in this library for the jurisdiction recomputation.
What about driver classification?
The program includes steps on owner-operator agreements and payments and the disclosure of claims on classification.
Related templates
- Trucking IFTA Fuel Tax Reconciliation
- Fixed Asset Rollforward (Excel)
- Cutoff Testing Workpaper (Sales, Purchases, Inventory)
- Search for Unrecorded Liabilities Workpaper
Last updated 11/05/2026. All free templates.