A 13-week cash flow forecast shows how much cash your business expects to receive, pay, and retain each week over the next quarter. It starts with cash available today, adds realistic collections, subtracts scheduled payments, and reveals the lowest expected cash balance before it becomes an emergency.
For a business owner, its value is not the spreadsheet. Its value is time: time to chase an invoice, move a purchase, negotiate a payment plan, revise a hiring date, or arrange funding while options are still available.
What is a 13-week cash flow forecast?
A 13-week cash flow forecast is a rolling, short-term liquidity plan organized by week. It usually uses the direct method, which means forecasting actual cash receipts and cash payments instead of starting with accounting profit.
The basic calculation for each week is:
Opening cash + cash received − cash paid = closing cash
The closing balance becomes the following week’s opening balance. After each week ends, replace the forecast with actual results, investigate material differences, and add a new week to the end. The view therefore remains 13 weeks long.
Why 13 weeks? It covers roughly one quarter while retaining enough weekly detail to expose payroll dates, supplier obligations, tax payments, loan installments, and customer-payment delays. Recent practitioner guidance from Intuit and BDO similarly describes the model as a way to maintain short-term liquidity visibility and identify operational cash needs.
Why your P&L cannot answer the same question
Your profit and loss statement and cash forecast serve different purposes.
Profit measures revenue earned minus expenses recognized during a period. Cash forecasting focuses on when money is actually expected to enter or leave the business. A sale can contribute to profit before the customer pays. An annual insurance premium can consume cash immediately even though the expense is recognized over time.
The distinction is embedded in professional accounting. IAS 7 requires cash flows to be presented as operating, investing, or financing activities and focuses on changes in cash and cash equivalents. A practical 13-week forecast is not a replacement for that formal statement. It is an operating view of the near future.
| Question | P&L or budget | 13-week cash forecast |
|---|---|---|
| Did the business generate accounting profit? | Yes | No |
| Can we make payroll in four weeks? | Not reliably | Yes |
| When will a customer invoice become usable cash? | Often not explicit | Explicit |
| What happens if a supplier is paid two weeks later? | May not change expense | Changes weekly liquidity |
| Where is the lowest projected cash point? | Not designed to show it | Core output |
What should the forecast include?
Keep the first version simple enough to update every week. Use categories that correspond to real decisions.
Opening cash
Start with available bank cash, not the balance from an old report. Exclude restricted funds or amounts that cannot be used for normal operations. If you operate several accounts or currencies, document which balances are included and how transfers are treated.
Cash receipts
Separate receipts by confidence and source:
- Customer invoices already issued, adjusted for realistic payment dates
- Recurring payments or contracted revenue
- Cash sales and payment-platform settlements
- Tax refunds or grants that have been approved
- Financing proceeds with a confirmed date
- Asset-sale proceeds where completion is sufficiently certain
Do not place the full sales pipeline into expected cash. A proposal is not an invoice, and an invoice is not cash. Maintain a separate upside line for opportunities that are possible but not yet dependable.
Operating payments
Include payroll, contractors, rent, subscriptions, utilities, inventory, logistics, marketing, insurance, professional fees, tax, and other recurring obligations. Use actual due dates where available.
Investing and financing payments
Add equipment purchases, deposits, loan principal, interest, owner distributions, and other financing flows. These items may not appear in the same way on the P&L, but they still change the bank balance.
Minimum cash threshold
Set an internal floor below which management must act. This is not simply zero. A business needs room for timing errors, unexpected costs, and essential payments.
One practical approach is:
Minimum cash threshold = essential payments during the response period + contingency allowance
If it takes four weeks to reduce costs or arrange funding, the threshold should reflect essential cash needs across that response period. The appropriate amount depends on volatility, access to credit, customer concentration, and the consequences of missing a payment.
How to build a 13-week cash flow forecast
Step 1: Choose the weekly cutoff
Pick one consistent week-ending day, such as Friday. Assign every expected receipt and payment to a week. Consistency matters more than choosing a theoretically perfect calendar.
Step 2: Confirm available opening cash
Reconcile the starting balance with bank records. Remove uncleared or restricted amounts that could create a false sense of liquidity.
Step 3: Forecast customer collections invoice by invoice
For the nearest four to six weeks, forecast important receipts at invoice or customer level. Use customers’ demonstrated payment behavior rather than contractual due dates alone.
If a customer is usually 12 days late, reflect that pattern. If a payment is disputed, move it to a separate risk line until someone owns the resolution.
Step 4: Map every committed payment
Begin with obligations that are difficult to change: payroll, tax, rent, debt service, contracted suppliers, and critical software or infrastructure. Add discretionary payments afterwards so they remain visible as decision levers.
Step 5: Calculate weekly closing cash and the cash floor
Calculate the closing balance for all 13 weeks. Then identify:
- The lowest projected cash balance
- The week in which it occurs
- The amount below your internal threshold
- The receipts or payments driving that result
The lowest point is more useful than an average. A business can look healthy over a quarter and still be unable to meet obligations in week six.
Step 6: Build three scenarios
Keep the base forecast as the most likely outcome. Then test a limited number of operational changes:
- Collection delay: What if the two largest invoices arrive 14 days late?
- Revenue downside: What if cash sales are 15% below plan?
- Cost event: What if a critical repair or inventory purchase occurs?
- Management action: What if hiring moves by one month or a discretionary project pauses?
A scenario should lead to a decision. If it does not change an action, it may not deserve a separate model.
Step 7: Replace forecasts with actuals every week
At week-end:
- Record actual receipts and payments.
- Compare actuals with the forecast.
- Explain the largest variances.
- Update future assumptions.
- Add week 14 so the view remains rolling.
Forecast accuracy improves through this feedback loop—not through pretending the first version will be perfect.
Worked example: Northstar Studio
Northstar Studio starts week one with $80,000. It expects two customer payments, regular payroll, contractor bills, rent, and a quarterly tax payment.
| Week | Opening cash | Expected receipts | Expected payments | Closing cash |
|---|---|---|---|---|
| 1 | $80,000 | $24,000 | $18,000 | $86,000 |
| 2 | $86,000 | $8,000 | $31,000 | $63,000 |
| 3 | $63,000 | $35,000 | $20,000 | $78,000 |
| 4 | $78,000 | $6,000 | $39,000 | $45,000 |
| 5 | $45,000 | $18,000 | $17,000 | $46,000 |
Its internal minimum is $50,000. The forecast therefore generates a warning in week four even though cash never becomes negative.
The owner can now ask useful questions:
- Can the $35,000 week-three receipt be confirmed?
- Can part of the week-four supplier payment move within agreed terms?
- Should a planned equipment deposit wait until week five?
- What happens if the week-three customer pays two weeks late?
Under that delay scenario, week-four closing cash falls from $45,000 to $10,000. That is a different operating decision from the base case and deserves action now.
Common forecasting mistakes
Using invoice dates as collection dates
Contractual terms are a starting point. Actual customer behavior is usually more informative for short-term cash planning.
Forecasting revenue instead of cash receipts
A signed order can support a sales forecast without supporting this week’s bank balance. Translate sales events into realistic billing and collection dates.
Omitting irregular obligations
Tax, annual insurance, bonuses, deposits, debt repayments, and equipment purchases often create the most important cash troughs.
Hiding uncertainty inside one number
Use confidence notes or separate committed, likely, and upside receipts. False precision makes the forecast harder to trust.
Building a model no one can maintain
The most sophisticated model has no value if it becomes stale. Begin with decision-relevant categories and add detail only when it improves an action.
Treating the forecast as accounting truth
This is a management estimate, not a formal financial statement. Reconcile it with reliable source data and keep accounting records under the appropriate professional process.
What to do this week
- Choose a weekly cutoff date.
- Confirm unrestricted cash available today.
- List customer invoices expected to be collected in the next four weeks.
- List payroll, tax, rent, debt, and supplier payments by due date.
- Calculate closing cash for the next 13 weeks.
- Mark the lowest balance and compare it with your internal threshold.
- Test one delayed-collection scenario.
- Assign an owner to every material uncertainty.
- Schedule a 30-minute weekly update.
Frequently asked questions
How often should a 13-week cash flow forecast be updated?
Update it weekly. Replace the completed week with actual results, revise future assumptions, and add a new week to keep the forecast rolling. Businesses with very tight liquidity may monitor critical receipts and payments more frequently.
Is 13 weeks suitable for every business?
It is particularly useful when payment timing, payroll, inventory, or supplier commitments create short-term liquidity risk. Highly seasonal businesses may also maintain a longer monthly forecast alongside the detailed 13-week view.
Should the forecast use cash or accrual accounting?
Use expected cash receipts and payments for the 13-week operating forecast. Keep accrual-based budgets and formal financial statements for their proper accounting and performance-management purposes.
How accurate should the forecast be?
Near-term weeks should be more precise than later weeks. The goal is not perfect prediction; it is early visibility, clear assumptions, and timely action. Track forecast-versus-actual differences to improve the model.
Can a business owner build this without a finance team?
Yes. Start with bank balances, invoice collections, payroll, supplier due dates, tax, and major commitments. An accountant or finance professional should review the structure when the business has multiple entities, complex tax obligations, financing covenants, or material uncertainty.
Turn the forecast into an operating habit
A spreadsheet can establish the discipline, but maintaining invoice dates, payment commitments, budgets, scenarios, and actual cash movements manually becomes time-consuming as the business grows.
CashCatalyst helps business owners and non-finance teams forecast cash, test what-if scenarios, plan accounts receivable, accounts payable, and budgets, and reduce repetitive cash work with AI-assisted analysis. It is designed to create a more predictable view of the business while complementing established accounting practices and professional finance tools.
Sources and editorial note
- IFRS Foundation: IAS 7 Statement of Cash Flows
- British Business Bank: How to create a cash flow forecast in four steps
- Business.gov.au: Set up a cash flow statement
- BDO: 13-Week Cashflow Forecast Guide
This article provides general educational information, not accounting, tax, legal, or financial advice. Payment obligations and appropriate cash thresholds vary by business and jurisdiction. Have a qualified professional review decisions that could materially affect your business.