13-Week Cash Flow Forecasting: The Simple System Every Trade Business Needs
Why profitable contractors run out of cash, and how a 90-day rolling view prevents Friday payroll panic.
- ✓Most small contracting and service businesses don't fail from lack of work; they fail because their cash collection cycle is slower than their payroll cycle.
- ✓An accrual P&L statement tells you what you billed last month; a 13-week cash forecast tells you whether your bank account will clear payroll on Friday the 24th.
- ✓Spending 15 minutes every Monday morning updating your starting cash balance and projected collections gives you 6 to 8 weeks of warning before cash pinches happen.
1. The Net-60 Commercial Job That Almost Broke You
Here is the story that plays out every day in the trades: You land a great $45,000 commercial job. You buy $14,000 in materials on your supplier line of credit, your crew puts in 120 hours of labor over two weeks, and you send a polished invoice on Friday afternoon.
Your accountant looks at your QuickBooks P&L and says, 'Great month! You showed a $16,000 profit.'
Meanwhile, the commercial GC operates on Net-60 payment terms. That check won't arrive for two months. In the meantime, your supplier invoice is due in 30 days, payroll clears every single Friday, and you have two new jobs starting next week that require material deposits.
This is the cash conversion gap. You are wildly profitable on paper, but flat broke at the bank.
Why 13 Weeks is the Magic Horizon
13 weeks equals exactly 90 days (one financial quarter). It's close enough that your receivables and labor estimates are realistic, yet far enough out that you have time to delay equipment purchases, follow up on overdue invoices, or draw on a credit line before an emergency hits.
2. The 3-Bucket Cash Flow Framework
To get total clarity, stop over-complicating your books with 50 expense categories. Group your weekly cash outflows into three non-negotiable buckets:
1. Payroll & Subcontractor Labor (must be funded 100% on time every week).
2. Mandatory Overhead (facility rent, vehicle leases, insurance, debt service).
3. Variable Job Costs & Materials (tied directly to active client deposits).
When you review this in a clean 13-week spreadsheet every Monday morning with your morning coffee, you immediately spot any week where your projected cash dips below your safety buffer. That gives you weeks of runway to act, rather than finding out at 4:00 PM on Thursday when payroll direct deposits submit.
Side Hustle Income Expense Tracker
Pro-grade Excel toolkit for serious operators.
Common questions on this blueprint
How long does it take to maintain this forecast each week?
About 15 to 20 minutes every Monday morning. You enter your actual starting bank balance, check off payments received, and roll the 13-week view forward.
Do I need an accounting degree to use this template?
Not at all. The spreadsheet is built with clear, pre-wired formulas. You enter simple numbers (cash in and cash out) and the running balances calculate automatically.
Over 15 years running commercial contracting jobs and advising trade business owners on cash flow architecture and field operations.