Trucking cash flow forecaster: see your low point before it hits
Enter today's cash, weekly gross, how long brokers take to pay, and weekly expenses. The trucking cash flow forecaster draws the next 8 weeks and marks the week your balance is lowest.
Trucking cash flow forecaster, 8 weeks
EXAMPLE VALUES, REPLACE WITH YOURS8-WEEK CASH
- W1
- W2
- W3
- W4
- W5
- W6
- W7
- W8
In Out Balance Balance below zero
-$11,000
low point, week 5
-$7,100
after 8 weeks
With 30-day terms, the first payment lands in week 6.
Your cash dips to -$11,000 in week 5. Faster pay helps, and so do steady loads every week.
By Edwin Horton · Updated
How the cash flow forecaster works
Profit and cash are different things. A load you haul this week earns money this week, but the cash may not arrive for a month, while fuel, payroll and payments go out every week. The forecaster shows that timing gap.
- Weeks until the first payment = days to pay ÷ 7, rounded up
- Cash in each week = weekly gross once that lag has passed (or gross minus the quick pay fee from week one)
- Cash out each week = weekly expenses
- Balance = last week's balance + cash in − cash out
- Low point = the week with the lowest balance
EXAMPLE A two-truck fleet has $15,000 in the bank, bills $6,500 a week and spends $5,200 a week. Brokers pay in 30 days, so the first payment lands in week 6. The balance falls $5,200 a week for five weeks and bottoms at -$11,000 in week 5, then climbs $1,300 a week once payments arrive. Switch on quick pay at 3% and cash arrives every week at $6,305: the balance never dips, but the fee costs $195 a week.
Each week shows three bars: cash in (green), cash out (red) and the balance (dark, or amber when below zero).
Reading the low point
Low point below zero: you need cash from somewhere before that week: a reserve, a line of credit, quick pay, or factoring. Find it now, not when the card is declined at the pump.
Low point above zero but thin: one repair or one slow-paying broker breaks it. Treat the low point as the minimum reserve you should hold, then add a repair.
Growing fleets: a new truck makes the gap bigger before it makes it smaller, because its expenses start on day one and its revenue arrives a month later. Run the forecaster with the new truck's numbers before you buy it. For the full monthly picture, pair it with the trucking profit calculator, or the box truck business profit calculator if you run box trucks.
Plan with it
Lenders and investors want to see this in a truck business plan. If you're paying a trucking consultant to build your projections, ask them to show the weekly cash gap, not only monthly profit. Faster pay, through broker quick pay or factoring, narrows the gap, and steady weekly loads are the other half of the answer: see how small fleet dispatch plans every unit's week.
Revisit the forecast every week for the first months of a new truck or a new customer. Real payments rarely land exactly on schedule, and the first late payer is the one that tests your reserve. Updating the starting cash and the pay terms each Monday keeps the low point honest.
Start from today's bank balance
- Start with the cash in the bank today
- Use your real average days to pay, not the terms on paper
- Include payroll taxes and insurance in weekly expenses
- Run it again before adding a truck or customer
Cash flow questions
01Why do profitable trucking companies run out of cash?
Because expenses are paid weekly and brokers often pay in 30 days or more. A new truck or a fast-growing fleet can be profitable on paper and still short of cash for the first month or two, while invoices wait to be paid.
02How long do brokers take to pay carriers?
It depends on the broker and the terms on the rate confirmation. Many pay in 30 days; some faster, some slower, and many offer quick pay for a fee. Put your real average in the days-to-pay field.
03Should I use quick pay or factoring?
They trade a percentage of each invoice for cash now. That can be worth it while you build a reserve or add a truck. Toggle quick pay in the forecaster to see how much the low point improves and what it costs you.
04How much cash reserve should a small fleet keep?
Enough to cover the gap between paying expenses and getting paid, plus a repair. The forecaster's low point shows the gap; add a major repair on top and you have a starting number.
05What expenses should go in the weekly number?
Fuel, driver pay and payroll taxes, truck and trailer payments, insurance, and an average for repairs, tolls and overhead. Monthly bills can be divided by 4.33 to get a weekly figure.
Steady loads make steady cash
A dispatcher brings you loads every week. You approve each one; the rate con comes straight to you.
4% for 2+ trucks, 5% for one, 7% while your MC is new