Esc

↑↓ move↵ openIndex · Pagefind

How to build a 13-week cash flow forecast for a construction company

A 13-week cash forecast lists every receipt and payment the company expects, week by week, starting from the cash actually in the bank. Date receipts by when each owner really pays, date payments by payroll, terms and pay-when-paid, set a minimum balance, and roll it forward every week against what happened. Here is each step and a worked 13-week example with a low week.

Charley Forey7 min readCash flowAccountingFinance
On this page
  1. Step 1: Start from cash you can see
  2. Step 2: Forecast receipts by when each owner actually pays
  3. Step 3: Forecast payroll on its pay dates
  4. Step 4: Forecast subcontractors, suppliers and the rest
  5. Step 5: Run the weekly totals and set a floor
  6. Step 6: Roll it forward every week
  7. Step 7: Use it to act
  8. Worked example: a 13-week forecast with one low week
  9. Common mistakes
  10. How os.construction handles it
  11. 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

Illustrative numbersA made-up company, in thousands of dollars. Terms, amounts and the floor are examples, not benchmarks.

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

Ending cash by week against a 150,000 dollar floorEnding cash starts at 643,000 dollars in week 1, falls to 43,000 in week 6, below the 150,000 floor, recovers to 366,000 in week 7 when the owner payment arrives and ends week 13 at 184,000.FLOOR $150K$643KWK 6 $43K$366K$184KWK 1WK 7WK 13
Ending cash by week. Week 6 is the problem, and the forecast shows it five weeks early. Illustrative.

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

Written by

Charley Forey

Founder of os.construction. We're building the operating system for construction. Project Financials follows job money, and company Accounting covers the books and controls. AI agents remain planned. We write about how money and data actually move on a job, and we build in public.

Apply to the founding program →Start a free trial →
Open file