On this page
- Step 1: Start from cash you can see
- Step 2: Forecast receipts by when each owner actually pays
- Step 3: Forecast payroll on its pay dates
- Step 4: Forecast subcontractors, suppliers and the rest
- Step 5: Run the weekly totals and set a floor
- Step 6: Roll it forward every week
- Step 7: Use it to act
- Worked example: a 13-week forecast with one low week
- Common mistakes
- How os.construction handles it
- FAQ
To build a 13-week cash flow forecast, start from the cash in the bank, then list every receipt and payment you expect in each of the next 13 weeks: owner receipts on the date each owner really pays, payroll on pay dates, subcontractors and suppliers on their terms, and overhead and debt on their due dates. Carry each week’s ending balance forward, compare it with a minimum balance you set, and update it every week against what actually happened.
A cash flow projection for one job tells you how much cash that job will tie up and when. A 13-week forecast answers a different question: will the company have enough cash in the bank every week this quarter, after payroll, subcontractors, suppliers, rent, insurance and debt? It’s a direct, receipts-and-payments view, so it doesn’t use earned revenue or the WIP schedule. A profitable quarter can still have a week where cash runs short.
Step 1: Start from cash you can see
Use the balance in your operating accounts as reconciled, not a rough number from the bank app. If the most recent bank reconciliation shows outstanding checks, they either come out of the opening balance or appear as payments in week 1, not both. Keep any line of credit outside the opening balance and show it separately as available, so the forecast shows when you’d need to draw.
Step 2: Forecast receipts by when each owner actually pays
Start with open receivables from the AR aging report. For each invoice, estimate the week the money arrives based on that owner’s payment history and the contract’s approval and payment periods. An owner who pays in 45 days on 30-day terms should be forecast at 45.
Then add pay applications you’ll submit during the 13 weeks. For each one, the receipt date is roughly:
receipt week = submission date + owner review and approval period + payment period
Forecast the net amount after retainage. Keep retainage releases on their own line, and include one only when the closeout steps that release it, such as substantial completion, punch list and the required waivers, have dates you believe. How to read construction contract payment terms shows where the periods are written.
Step 3: Forecast payroll on its pay dates
Payroll is the payment you can least afford to move. List each pay date in the window with net pay, and the tax deposits and benefit or union remittances on the dates they are due. Use the crew size the schedule needs, not last quarter’s average.
Step 4: Forecast subcontractors, suppliers and the rest
Date each payment by the terms that apply to it:
- Subcontractors. Approved pay apps on your payment terms. If the subcontract is pay-when-paid, the payment follows the related owner receipt, so link the two in the forecast and move them together. Pay-when-paid vs pay-if-paid explains the difference, and enforceability varies by state.
- Suppliers. Open AP from the aging on its due dates, plus purchases you know are coming, such as a large equipment order.
- Retainage payable. Releases owed to subcontractors when their work is accepted, usually tied to your own retainage release.
- Overhead. Rent, insurance premiums, vehicle and equipment payments, software, utilities.
- Debt and taxes. Loan payments, line of credit interest, estimated tax payments and any owner distributions.
Step 5: Run the weekly totals and set a floor
For each week:
ending cash = opening cash + receipts − payments
The ending balance becomes next week’s opening balance. Then pick a minimum balance, a floor you don’t want to go below. A common starting point is at least one payroll plus the payments you can’t move, but the right floor depends on your business, so agree it with your bank, CPA or surety. Every week below the floor is a decision you need to make now, while you still have options.
Step 6: Roll it forward every week
Once a week, replace the week just ended with actual receipts and payments, explain any difference larger than a threshold you choose, move late receipts to realistic dates and add a new week 13. The variance review is what makes the forecast trustworthy. If a particular owner’s receipts are late every week, change that owner’s payment pattern rather than hoping.
Step 7: Use it to act
When a week falls below the floor, the levers are usually:
- Bill faster. Submit pay applications on the first allowed day, with complete backup so they aren’t returned.
- Collect specific receivables. The forecast tells you which owner payment matters most in which week.
- Time discretionary payments. Equipment purchases, distributions and prepayments can often move.
- Arrange credit early. A planned draw on a line of credit costs less than an emergency.
Paying subcontractors or suppliers late beyond their terms isn’t a lever. It may breach the subcontract, run into prompt payment laws and damage the relationships you need. Ask counsel if you aren’t sure what your contracts and state law allow.
Worked example: a 13-week forecast with one low week
The company starts with $420,000 of reconciled cash. Payroll is $45,000 a week, base overhead $12,000 a week, and monthly items such as rent, insurance and equipment loans add $30,000 in weeks 1, 5 and 9. The owner has set a floor of $150,000.
| Week | Receipts | Payroll | Subs and suppliers | Overhead and debt | Net | Ending cash |
|---|---|---|---|---|---|---|
| 1 | 310 | 45 | 0 | 42 | +223 | 643 |
| 2 | 0 | 45 | 240 | 12 | −297 | 346 |
| 3 | 85 | 45 | 40 | 12 | −12 | 334 |
| 4 | 0 | 45 | 30 | 12 | −87 | 247 |
| 5 | 0 | 45 | 0 | 42 | −87 | 160 |
| 6 | 0 | 45 | 60 | 12 | −117 | 43 |
| 7 | 380 | 45 | 0 | 12 | +323 | 366 |
| 8 | 120 | 45 | 180 | 12 | −117 | 249 |
| 9 | 0 | 45 | 0 | 42 | −87 | 162 |
| 10 | 140 | 45 | 40 | 12 | +43 | 205 |
| 11 | 60 | 45 | 30 | 12 | −27 | 178 |
| 12 | 330 | 45 | 210 | 12 | +63 | 241 |
| 13 | 0 | 45 | 0 | 12 | −57 | 184 |
| Total | 1,425 | 585 | 830 | 246 | −236 |
check: $420,000 + $1,425,000 − ($585,000 + $830,000 + $246,000) = $184,000
What the forecast shows. Cash falls to $43,000 in week 6, $107,000 below the floor. The cause is timing, not profit: a $380,000 owner payment on Job A’s pay application is forecast for week 7, because that owner approves in about two weeks and then pays 30 days later, while $60,000 of supplier payments fall due in week 6.
The sensitivity that matters. If that owner payment slips one more week, week 7 ends at $43,000 + $0 − $57,000 = −$14,000. One late receipt turns a tight week into an overdraft.
The decisions, made in week 1. The controller confirms with the owner’s representative that the pay app was approved on time and asks whether the payment can be released in week 6. The project manager makes sure next month’s pay app goes in on the first allowed day. The CFO arranges a short draw on the line of credit for weeks 6 and 7 as a backstop, and holds off on a planned equipment purchase until the forecast clears. The subcontractor and supplier payments stay on their terms.
Common mistakes
- Forecasting receipts on invoice due dates instead of each owner’s real payment pattern.
- Counting retainage releases before closeout is dated.
- Leaving out tax deposits, benefit remittances or annual insurance premiums.
- Starting from an unreconciled balance, or counting outstanding checks twice.
- Never comparing forecast to actual, so the same optimistic assumptions repeat every week.
- Building it once for the bank and not using it to make decisions.
- Treating subcontractor terms as a cushion when the forecast is short.
How os.construction handles it
In the Accounting module’s Financial Reports, the cash forecast covers 13 weeks or 12 months from the book balance of your bank accounts. Inflows come from open AR timed by each customer’s days to pay, retainage released after job completion and unbilled contract value; outflows from open AP, commitments, payroll, debt and leases; and manual lines need a reason. Each line names its source and how its date and amount were derived, and stored snapshots can be compared with what actually happened. Remaining contract and commitment value is spread evenly to completion rather than from a cost-loaded schedule, so review those lines against your project managers’ expectations. Banking also has a weekly cash forecast. For the month-end side, see close readiness and the weekly cash forecast, and for one job, use the free cash flow projection template or the cash flow calculator. The getting paid in construction explainer shows where the timing gaps come from, and construction accounting software covers the ledger behind it.
FAQ
What is a 13-week cash flow forecast?
A week-by-week list of the cash a company expects to receive and pay over the next quarter, starting from its current bank balance. Each week's ending balance becomes the next week's opening balance, so the forecast shows which weeks run low before they arrive.
How is a 13-week forecast different from a job cash flow projection?
A job cash flow projection follows one contract by month over its whole duration, usually to find its peak cash need. A 13-week forecast covers the whole company by week, including overhead, debt payments and every job, and is updated every week from actual receipts and payments.
How do you forecast receipts from owners?
Date each open invoice and each pay application you expect to submit by when that owner actually pays, based on its payment history and the contract's approval and payment periods, not just the invoice due date. Keep retainage releases separate and include them only when the closeout steps that release them are dated.
How often should a 13-week cash forecast be updated?
Weekly. Replace the week just ended with actual receipts and payments, explain the larger differences, move late items to realistic dates and add a new week 13.
What minimum cash balance should a contractor keep?
There is no single right number. It depends on payroll size, the timing of large payments, available credit and lender or surety expectations. Many companies set a floor of at least one payroll plus the payments they cannot move, then agree it with their bank, CPA or surety.
Share this article