Trucking Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Per-Mile Cost Analysis sheet — enter your fixed monthly costs per truck (equipment payment, insurance, base driver pay, permits) and your variable costs per mile (average fuel cost, maintenance reserve, tire allocation). This establishes your CPM baseline and tells you the minimum RPM you need to cover costs on any given load. Once your cost structure is in, move to the Freight Invoice Tracker and enter your current outstanding invoices with their expected payment dates. This gives you your receivables position, which is the single most important input for the 13-week projection in a trucking business where you may be owed $50,000–$150,000 in freight that hasn't been paid yet.

Update the 13-week projection weekly. At the start of each week, enter confirmed loads you've booked (or dispatched) for the next three weeks, their linehaul and FSC revenue, and the expected payment dates based on each broker or shipper's payment terms. Adjust your fuel expense estimate using the current diesel price and planned miles. Flag any invoices in the Freight Invoice Tracker that are past due so you know whether to chase payment directly, offer a quick-pay discount, or factor the invoice. The 13-week ending cash balance row shows you whether you'll have enough cash to cover equipment payments and driver settlements in the coming weeks — the two expense categories that can't be deferred.

Reconcile the Monthly Cash Flow sheet against your bank and factoring account statements at month-end. If you use factoring, confirm that the factoring advance amounts and fees are entered correctly so the cash flow picture reflects actual bank deposits rather than invoice face value. After several months of data, the Annual Summary will show your operating ratio trend and fuel cost percentage. Trucking operations with an operating ratio above 95% need to either raise rates, cut deadhead miles, or reduce a specific cost category — and the annual view by expense line makes it clear which category is pulling the OR in the wrong direction.

Trucking is one of the few industries where a profitable business can run out of cash. A carrier billing $100,000 per month can have $150,000 in outstanding freight invoices at any time if broker payment terms average 45 days — meaning the business has earned the money but cannot spend it until the checks arrive. Driver settlements and equipment payments don't wait for brokers to process invoices. Fuel purchases happen every day. That gap between earned revenue and collected cash is the defining cash flow challenge in trucking, and it's why carriers use invoice factoring more than almost any other industry: selling receivables for immediate cash at a 2–4% fee is often the only way to keep fuel in the tanks and drivers paid while waiting for brokers to clear invoices.

The financial metrics that matter in trucking are different from most businesses. Operating ratio — total operating expenses divided by total revenue — is the benchmark lenders, investors, and acquirers use to evaluate a carrier. An OR of 85% means the operation earns $0.15 of operating profit for every dollar of revenue, which is considered efficient in an industry with gross margins of 12–20% and net margins of 2.5–8%. Cost per mile is the operational measure: a carrier running $1.85 CPM against $2.20 RPM is generating $0.35 per mile of margin, roughly 16%, which covers fixed overhead and leaves room for a modest profit. Fuel cost as a percentage of revenue typically runs 25–35% for diesel-powered operations, and a single $0.50 move in diesel prices can shift CPM by $0.08–$0.10 — which erases margin on spot loads priced before the fuel spike.

The workflow that keeps trucking cash flow manageable is: price loads against your CPM target before accepting them, invoice the same day the load delivers, follow up on any invoice unpaid past 35 days, and update the 13-week projection every Monday before dispatching the week's trucks. Carriers who build this habit catch cash shortfalls before they become payroll emergencies, know exactly which customers are chronically slow to pay (and can factor only those invoices), and have the numbers to negotiate better payment terms with brokers once they can demonstrate a track record of on-time delivery. The difference between a trucking company that grinds through cash crises and one that runs cleanly almost always comes down to whether the owner is projecting receivables timing — not whether they have enough loads.