A 13-Week Rolling Cash Flow Forecasting Model for Contractors
Quick Answer
A 13-week cash flow forecast for contractors gives you 91 days of forward cash visibility, updated every 7 days as actual collections and payments replace estimates. Instead of asking whether the company is profitable this month, the model shows whether enough cash will be available for payroll, materials, subcontractors, equipment payments, taxes, and overhead in each individual week. The value is not predicting the exact bank balance 13 weeks from now; it is identifying the weeks where liquidity starts tightening early enough to make an operating decision.
Contractor Pain Point: The Bank Balance Looks Fine Until It Suddenly Does Not
Consider a contractor with $220,000 sitting in operating cash.
There is plenty of work.
Several customer invoices are outstanding.
The backlog looks healthy.
Nothing about the business feels distressed.
Then the next five weeks stack up:
Weekly payroll continues regardless of customer payment timing.
A large material package has to be paid before the next progress draw.
Two subcontractor invoices come due.
A customer payment expected this month slips into the following month.
Retainage is sitting in receivables but cannot be used to fund current operations.
Equipment and insurance payments hit on schedule.
The contractor did not suddenly become unprofitable.
The timing changed.
That distinction is covered in more detail in Cash Flow Management for Contractors: Why Profit Doesn’t Equal Cash.
A 13-week rolling forecast turns that timing problem into a visible weekly schedule.
Before relying on the forecast, the starting numbers need to be dependable. The free Contractor Month-End Close Checklist helps verify the cash, receivables, payables, payroll, and job-cost information feeding the model.
Core Explanation: A Cash Forecast Is Not a Profit Forecast
Construction forecasting often gets treated as one process.
It is not.
A project forecast asks questions such as:
What will this job cost at completion?
Is labor tracking ahead or behind budget?
Has projected gross margin changed?
How much cost remains to finish the work?
That is a job-performance forecast. The mechanics are demonstrated in Construction Forecast Example: How Contractors Stop Margin Fade Mid-Project.
A 13-week cash flow forecast asks a different question:
When will actual dollars enter and leave the bank?
A profitable $500,000 project can still create a cash shortage if the contractor spends $200,000 on labor, materials, and subcontractors before the customer pays the first major draw.
That is why the model should be built around cash dates, not accounting dates.
Revenue recognition does not fund payroll.
An approved invoice does not fund payroll.
Retainage receivable does not fund payroll.
Cash that has cleared the bank does.
The basic model is:
Ending Cash = Opening Cash + Cash Receipts − Cash Disbursements
Then add one operating-control calculation:
Cash Buffer or Shortfall = Ending Cash − Minimum Operating Cash Floor
That second number turns the spreadsheet from a projection into a management tool.
Step-by-Step Breakdown: Build the 13-Week Contractor Cash Forecast
1. Start With Available Operating Cash
What to do
Enter the actual available operating cash at the beginning of Week 1.
Separate cash that cannot reasonably be used for normal operations, such as:
Restricted funds
Dedicated tax accounts
Customer deposits subject to specific contractual restrictions
Other cash management accounts not available for normal spending
Do not automatically combine unused line-of-credit availability with operating cash. Track available borrowing separately so management can see the difference between company cash and borrowed liquidity.
Why it matters
Every later week rolls forward from this number.
If the opening cash balance is wrong by $40,000, every forecasted ending balance is wrong by $40,000.
What goes wrong if skipped
The spreadsheet can look sophisticated while the starting point does not match the bank.
That makes the entire 13-week forecast unreliable before Week 1 begins.
2. Put Customer Collections Into the Week Cash Is Expected
What to do
Build expected receipts from the actual receivable and billing schedule.
For each significant collection, identify:
Customer
Job
Invoice or pay application
Amount collectible
Contractual due date
Expected payment date
Approval status
Any known documentation issue
Place the receipt in the week you reasonably expect the money to clear.
Do not automatically place an invoice in the forecast based on the date it was sent.
A $90,000 invoice issued this Friday does not create $90,000 of cash this Friday.
A disciplined AR process makes these dates far more useful. See Accounts Receivable & Collections for Contractors for the billing and collections controls behind the forecast.
Why it matters
Receivables usually represent the largest near-term cash source for an active contractor.
Moving one large payment by two weeks can change the entire liquidity picture.
What goes wrong if skipped
Contractors forecast based on billed revenue instead of likely collections.
Future cash becomes overstated, and the shortage only becomes visible when the expected payment fails to arrive.
3. Separate Retainage From Normal Expected Collections
What to do
Keep retainage on its own forecast line.
Only place it into a week when there is a defensible expected release date based on:
Project completion
Closeout requirements
Lien releases
Owner or GC approval
Contract terms
Historical payment behavior
If there is no reliable release date, keep the amount visible outside normal forecasted cash receipts rather than forcing it into Week 8 or Week 12 because the spreadsheet needs a number.
For the accounting and reporting side, see Why Retainage Makes Profitable Construction Jobs Feel Unprofitable.
Why it matters
Retainage may appear on the balance sheet as a receivable while remaining unavailable for months.
What goes wrong if skipped
The forecast treats $75,000 of retainage like $75,000 of normal AR.
Management thinks the future cash balance is stronger than it really is.
4. Forecast Payroll by Actual Pay Date
What to do
Enter payroll in every week it will clear the bank.
Include the full cash requirement appropriate to the forecast, such as:
Field wages
Office payroll
Employer payroll taxes
Benefits or deductions paid separately
Payroll service withdrawals
If the workforce changes materially based on scheduled jobs, adjust later weeks using the best current staffing information.
Why it matters
Payroll is one of the most predictable and least optional contractor cash requirements.
A customer can pay late.
Payroll generally cannot.
What goes wrong if skipped
A contractor spreads payroll evenly by month while the bank experiences actual weekly or biweekly withdrawals.
The monthly total can be right while the weekly cash forecast is completely wrong.
5. Schedule Material, Vendor, and Subcontractor Payments
What to do
Start with AP aging, then add known commitments that have not reached AP yet.
The forecast may need to capture:
Entered vendor bills
Subcontractor pay applications
Purchase orders
Large material deposits
Equipment rentals
Fuel
Permits
Upcoming committed purchases
For every material cash requirement, forecast the date the contractor expects to release payment.
Why it matters
AP only shows bills that have reached accounting.
The field may already know about a $60,000 material package that is not yet represented on the AP aging report.
What goes wrong if skipped
Management forecasts from historical accounting data while known future commitments remain invisible.
The spreadsheet says cash is available.
Operations has already committed it.
6. Add Overhead, Debt, Taxes, and Other Fixed Cash Requirements
What to do
Create separate lines for recurring and scheduled non-job cash payments, including:
Rent
Insurance
Software
Vehicle payments
Equipment debt
Credit card payments
Loan payments
Tax payments
Professional fees
Owner distributions when applicable
Use actual payment timing rather than dividing annual expenses by 52 unless no better information exists.
Why it matters
A $30,000 insurance payment does not leave the bank at $577 per week.
Cash forecasting needs to show the $30,000 withdrawal in the week it actually happens.
What goes wrong if skipped
Large scheduled payments disappear inside smooth monthly averages, hiding the exact weeks where cash pressure occurs.
7. Calculate Ending Cash and the Minimum Cash Floor
What to do
For every week, calculate:
Opening Cash + Total Cash In − Total Cash Out = Ending Cash
Then compare ending cash with a management-defined minimum operating cash balance.
For example, assume a contractor chooses a $125,000 internal cash floor based on payroll exposure, fixed obligations, and the amount of operating cushion management wants available.
That $125,000 is an internal management threshold in this example, not a universal construction benchmark.
Example 13-Week Contractor Cash Forecast
| Week | Opening Cash | Cash Receipts | Payroll | Materials + Subs | Overhead + Other | Ending Cash | Buffer vs. $125k Floor |
|---|---|---|---|---|---|---|---|
| 1 | $220 | $105 | $45 | $50 | $18 | $212 | $87 |
| 2 | $212 | $70 | $45 | $35 | $15 | $187 | $62 |
| 3 | $187 | $165 | $45 | $80 | $20 | $207 | $82 |
| 4 | $207 | $65 | $45 | $55 | $15 | $157 | $32 |
| 5 | $157 | $90 | $45 | $40 | $18 | $144 | $19 |
| 6 | $144 | $190 | $45 | $95 | $25 | $169 | $44 |
| 7 | $169 | $75 | $45 | $35 | $15 | $149 | $24 |
| 8 | $149 | $85 | $45 | $60 | $15 | $114 | ($11) |
| 9 | $114 | $175 | $45 | $75 | $20 | $149 | $24 |
| 10 | $149 | $80 | $45 | $45 | $15 | $124 | ($1) |
| 11 | $124 | $120 | $45 | $50 | $18 | $131 | $6 |
| 12 | $131 | $155 | $45 | $70 | $30 | $141 | $16 |
| 13 | $141 | $95 | $45 | $40 | $15 | $136 | $11 |
The contractor never reaches a negative bank balance.
That does not mean the forecast is healthy.
Week 8 falls $11,000 below management's minimum operating cash floor, and Week 10 nearly does it again.
Without a weekly forecast, the contractor may not recognize that pressure until Week 7.
With the model, the problem is visible in Week 1.
That creates time to investigate:
Whether Week 8 collections are realistic
Whether billing documentation can be completed earlier
Whether a material purchase can be scheduled differently without disrupting production
Whether a subcontractor payment date is correct
Whether an upcoming job is consuming cash earlier than expected
Whether sufficient liquidity exists before approving additional commitments
The forecast does not make the decision.
It identifies when a decision will be required.
8. Roll the Forecast Forward Every Week
What to do
At the end of each week:
Replace Week 1 estimates with actual cash activity.
Reconcile the ending cash balance to the bank.
Remove the completed week.
Move Weeks 2–13 forward.
Add a new Week 13.
Update collection dates.
Update payroll and staffing assumptions.
Update vendor, subcontractor, and material commitments.
Review changes from the prior forecast.
The result should always be another 13-week—or 91-day—forward view.
A strong monthly close makes those weekly updates more reliable. Use the freeContractor Month-End Close Checklist to keep the accounting records feeding the forecast from drifting away from reality.
Why it matters
A forecast created once becomes obsolete quickly.
Construction schedules move.
Invoices get approved.
Customers pay early or late.
Material releases change.
Payroll shifts.
Change orders move.
A rolling model absorbs those changes continuously.
What goes wrong if skipped
The company creates a forecast for a lender meeting or planning session, saves it, and never updates it.
Within a few weeks, it becomes another historical spreadsheet.
Insider Notes / Contractor Gotchas
Do Not Count Unapproved Change Orders as Cash
Potential revenue is not cash.
If a change order has not reached the point where the contractor can reasonably expect to bill and collect it, keep it outside primary forecasted receipts.
You can track the exposure separately.
Do not use uncertain future approval to cover a known payroll obligation.
Do Not Forecast Directly From the P&L
The P&L tells you when income and expenses are recognized.
The cash forecast tells you when money moves.
Those timelines are not interchangeable.
Do Not Assume Every Current Receivable Pays Next Week
An AR aging report is an input.
It is not a cash forecast.
A $150,000 current receivable may not become cash for another 30 days depending on contract terms, pay-application approval, customer processing, and documentation.
Do Not Ignore Costs That Have Not Reached Accounting
A vendor invoice does not need to be sitting in QuickBooks before it becomes a future cash requirement.
Purchase orders, subcontractor progress, material releases, field commitments, and scheduled equipment purchases can create real future cash demands before AP shows them.
Do Not Treat a Line of Credit as Operating Cash
Available borrowing is valuable liquidity.
It should still be visible separately.
Otherwise, management loses the distinction between:
Cash generated by operations
Cash already in the bank
Borrowed capacity available if required
Do Not Obsess Over Week 13 Precision
Weeks 1–4 should be relatively detailed.
Weeks 5–8 will contain more assumptions.
Weeks 9–13 will naturally be less precise.
That is acceptable.
The model should become more accurate as each week gets closer and new information replaces estimates.
The purpose is not perfect prediction.
The purpose is early warning.
Real-World Impact: What the 13-Week Model Changes
Visibility
Instead of seeing one bank balance, the owner sees a sequence:
Current cash → expected collections → required payments → weekly ending cash → minimum cash buffer
The contractor can see that Week 8 is a problem even while Week 1 looks comfortable.
Control
Cash conversations become specific.
Instead of:
“Cash feels tight next month.”
Management can ask:
“Our projected cash drops $11,000 below our operating floor in Week 8. Which $85,000 of expected receipts are confirmed, and which vendor commitments can move if those collections slip?”
That is an actionable management question.
Profit Protection
Cash shortages create expensive reactions:
Delaying vendors unexpectedly
Leaning harder on credit
Passing on material discounts
Moving money between jobs
Delaying equipment maintenance
Taking unnecessary owner capital actions
Accepting unfavorable work solely to generate short-term cash
A 13-week forecast does not guarantee those situations disappear.
It gives management enough warning to avoid making the decision under pressure.
Summary Framing: Forecast the Timing, Not Just the Profit
A 13-week cash flow forecast for contractors should not be another accounting report.
It is a weekly operating model connecting:
Bank cash → collections → billing → retainage → payroll → vendors → subcontractors → overhead → future cash
The rolling structure matters because construction cash timing changes constantly.
Each week, actual information replaces estimates and another week is added to the end.
That keeps 91 days of cash visibility in front of management.
The strongest forecast is not the spreadsheet with the most rows.
It is the forecast where every major expected collection and payment has a defensible amount, date, and source.
If those inputs cannot be trusted, fix the accounting control underneath them first. The free Contractor Month-End Close Checklist provides a practical starting point for making sure cash, AR, AP, payroll, and job-cost balances are complete enough to forecast from.
Frequently Asked Questions
1. Why use a 13-week cash flow forecast instead of a monthly cash budget?
Thirteen weeks provides a 91-day view while keeping the forecast granular enough to see weekly payroll, customer collections, subcontractor payments, material releases, and other contractor-specific cash events. A monthly budget can show that the month works overall while hiding a serious shortage in the second week.
2. Should retainage be included in a contractor cash flow forecast?
Yes, but retainage should be tracked separately from normal receivables and only included as forecasted cash when there is a reasonable expected collection date. Retainage without a defensible release date should not be used to cover known near-term obligations.
3. What should I do with customer payments when I do not know exactly when they will arrive?
Use the best supportable collection date based on contract terms, invoice status, customer history, approval status, and current communication. If a receipt is highly uncertain, keep that uncertainty visible rather than placing it aggressively into an early week just to make the forecast balance.
4. Should a line of credit be included in the 13-week model?
Track available credit, but keep it separate from operating cash and operating cash flow. That allows management to see when the business generates sufficient liquidity on its own and when it would need to rely on borrowed funds.
5. How often should contractors update a 13-week cash flow forecast?
Update it at least weekly. Replace the completed week with actual activity, reconcile ending cash, revise expected collection and payment dates, and add a new Week 13. Contractors with unusually large or volatile cash movements may need to update the near-term weeks more frequently.
Related Contractor Resources
Put the Forecast Into the Weekly Operating Rhythm
If building the 13-week forecast reveals that no one can confidently place customer collections, payroll, subcontractor obligations, retainage, and material commitments into specific weeks, the spreadsheet is showing an upstream system problem.
Tighten the inputs first. Once accounting, billing, AP, payroll, and project information move through a consistent process, the forecast becomes a management control instead of another spreadsheet that has to be rebuilt every time cash gets tight.
Disclaimer:This content is for general educational purposes only and does not constitute tax, legal, or accounting advice. Individual circumstances vary, and tax and reporting requirements can change. Always consult a qualified CPA, tax professional, or legal advisor for guidance specific to your business.
- Contractor Pain Point: The Bank Balance Looks Fine Until It Suddenly Does Not
- Core Explanation: A Cash Forecast Is Not a Profit Forecast
- Step-by-Step Breakdown: Build the 13-Week Contractor Cash Forecast
- Insider Notes / Contractor Gotchas
- Real-World Impact: What the 13-Week Model Changes
- Summary Framing: Forecast the Timing, Not Just the Profit
- Frequently Asked Questions
