The 13-week cash flow forecast for contractors
Short answer: a 13-week forecast is your bank balance, week by week, for the next quarter. For a contractor the hard lines are progress billings, retainage, change orders and weekly payroll. Put each on the week the cash moves, not the week it is billed or earned.
Your 13 weeks, rebuilt every morning.
TreasuryFlow builds the forecast from your bank every morning. $299/mo per company.
Why weekly, not monthly
Payroll goes out every week. Owners pay draws when they approve them. Retainage comes back at closeout. A month hides the week you come up short.
The lines a contractor's forecast needs
| Line | Put it on the week |
|---|---|
| Progress billings and draws | the owner usually pays, after approval |
| Retainage | the job is likely to close out and the paperwork clear |
| Approved change orders | the customer pays them. Unapproved ones stay out. |
| Deposits on new work | the customer pays the deposit |
| Service and maintenance billings | the customer pays |
| Payroll and payroll taxes | each pay date |
| Subcontractors | their pay terms say, including pay-when-paid |
| Materials and supply houses | the statement or due date |
| Equipment and truck loans, insurance, bonds, rent | each due date |
Four weeks, worked
| Week | Cash in | Cash out | Closing cash |
|---|---|---|---|
| Week 1 | +$48,000 | −$86,000 | $172,000 |
| Week 2 | +$156,000 | −$87,000 | $241,000 |
| Week 3 | +$22,000 | −$95,000 | $168,000 |
| Week 4 | +$131,000 | −$84,000 | $215,000 |
If that draw is paid three weeks late, week 2 closes at $101,000 and week 3 at $28,000, less than one week of costs. That is the week to see now.
Count retainage late
Retainage is earned, but it comes back when the job closes out and the paperwork clears. Put it on the week you realistically expect it, and move it when the job slips.
Keep retention you hold for subs, and cash held in a separate account, out of spendable cash.
Underbilling is cash you have not asked for
Work done but not invoiced shows as underbilling on a WIP schedule. It never reaches the forecast until it is billed, so bill it first.
Update it every Monday
- Replace last week's forecast with what actually happened.
- Add week 13.
- Move every draw and retainage release that slipped.
- Look at the lowest week, not the last one.
Spreadsheet or software
A spreadsheet works if someone updates it every Monday. The free Monday Cash Close is a 13-week cash board in Excel to start from.
TreasuryFlow builds the 13-week forecast from your bank every morning. Retention held in a separate account, once tagged, stays out of spendable cash.
Frequently asked questions
What is a 13-week cash flow forecast?
A week-by-week view of cash in, cash out and the bank balance for the next 13 weeks. Each Monday you drop the week that ended and add a new week 13.
How should a contractor forecast retainage?
As its own line, on the week the job is likely to close out and the paperwork clear, not the contract date. Move it when the job slips.
Should unapproved change orders go in the forecast?
No. Add a change order when it is approved and billed. Until then it is not cash.
Is there a free 13-week template?
Yes. The Monday Cash Close is a free 13-week cash board in Excel.