Trucking Invoice Template

Setup takes about 20 minutes for your first load. Download the .xlsx file and open it in Excel or Google Sheets — no macros required. Start with the Freight Invoice sheet: enter your carrier information (company name, MC number, DOT number, address) in the header section — this saves as a template you'll reuse for every invoice. Review the accessorial charge rows and adjust the labels to match the charges you typically see in your lanes. Set your default payment terms in the footer (most carriers use Net 30 or Quick Pay terms with their broker).

For each new load, open the Freight Invoice sheet and fill in the load details: BOL number, load number, broker or shipper name, origin, destination, commodity, and delivery date. Enter the linehaul rate from your rate confirmation. Go to the Fuel Surcharge Calculator, input the current DOE diesel price, and pull the calculated surcharge amount back to the invoice. Add any accessorial charges that applied to the load — detention if you waited more than two hours, liftgate if required, lumper fees if the receiving dock charged for unloading. Save the invoice as a PDF and send it with your signed POD.

After sending each invoice, log it in the Load Log with an Outstanding status. Update the status to Paid when payment clears — or 'In Factoring' if you've submitted it to your factoring company. Check the Revenue & Cost Summary monthly to see your revenue per mile, cost per mile, and operating ratio. Truckers who track these numbers consistently spot which lanes and freight types are actually profitable versus which ones look like good rates until you factor in empty miles, fuel, and accessorials. Most owner-operators who use this consistently find one or two lanes per quarter that aren't worth running.

Most owner-operators invoice on a rate confirmation and a signed POD — which works fine until a broker disputes a charge, a payment goes 45 days past due, or you try to figure out why last month wasn't profitable. The problem isn't the load; it's that a basic freight invoice doesn't capture the information you need to manage your business. A proper trucking invoice documents the BOL number, load number, PRO number, fuel surcharge method, and each accessorial charge as a separate line item. That documentation is what protects you in a dispute and what factoring companies require before advancing cash.

Fuel surcharges are one of the most misunderstood line items in trucking. Most brokers apply a fuel surcharge as a percentage of the linehaul rate, tied to the DOE weekly diesel index — but the rates vary by broker and the table changes weekly. When fuel represents 21% of your total operating costs and you're running on 3–8% net margins, an incorrectly applied fuel surcharge can flip a profitable load to a losing one. Tracking the surcharge calculation per load, rather than accepting whatever shows up on the rate confirmation, is the difference between knowing your cost structure and guessing at it.

The biggest cash flow problem in trucking isn't slow rates — it's the gap between delivering a load and getting paid. Standard payment terms run Net 30, but brokers routinely stretch to Net 45 or Net 60 in practice. Factoring solves the immediate cash flow problem at a 2–4% fee, but factoring companies require clean, documented invoices with the BOL and POD attached. The Load Log in this template tracks exactly where each invoice stands — outstanding, in factoring, or paid — so you're not calling brokers to ask for payment status on loads you delivered three weeks ago. For owner-operators managing cash flow without a dedicated bookkeeper, that visibility is worth more than the $29 cost of the template.