How to Build a 13-Week Cash Flow Forecast

A cash flow forecast helps you see when money is expected to enter and leave your business. A 13-week view is useful because it gives owners and finance teams a practical, week-by-week picture of near-term liquidity. It is not a universal forecasting horizon: choose a period that suits your business, obligations and planning needs, and extend or shorten it where appropriate.

Use the direct cash method: opening cash + receipts − payments = closing cash. Each week’s closing cash becomes the following week’s opening cash. This makes the forecast a schedule of expected cash movements, not a restatement of profit.

Set up a rolling weekly schedule

Create 13 columns, one for each week, with a clear start and end date. Add rows for opening cash, receipts, payments and closing cash. A rolling forecast is refreshed regularly: after a week ends, enter its actual results, remove that completed week from the forward view and add a new week at the end. Weekly updates help keep the forecast relevant as collection dates, supplier terms and business plans change.

Start with available cash that has been reconciled to the bank. Identify restricted or otherwise unavailable cash separately; do not treat it as available to meet ordinary payments. If bank accounts have different currencies or entities, make the scope and any conversion assumptions clear.

Build receipts and payments from evidence

Gather information from operational schedules and people responsible for the underlying activity. Useful sources include:

• Aged receivables, customer payment terms and expected collection dates.
• Aged payables, supplier due dates and known payment arrangements.
• Payroll calendars, including the expected dates and amounts of wages and related cash payments.
• Tax and other payment schedules, using dates and amounts confirmed for the business.
• Committed capital expenditure and loan schedules, including relevant payment dates.
• Other material cash movements, such as rent, insurance, subscriptions or planned owner transactions.

Forecast when cash is likely to move, rather than when an item is recognised in the accounts. A sale recorded as revenue this month may not be collected until a later week. Likewise, an expense recorded in one accounting period may be paid on a different date. Use expected receipt and payment dates, supported by the best available evidence, and revise them when new information arrives.

Avoid double counting. For example, if a customer invoice is already included in an opening aged-receivables schedule, do not add it again as a separate sales receipt. Check that transfers between the business’s own accounts are treated consistently: they move cash between accounts but are not external receipts or payments for a consolidated forecast.

Calculate the weekly cash position

For each week, add expected receipts to opening cash and subtract expected payments. Carry the resulting closing balance into the next week. Apply the same structure throughout the forecast so that each week reconciles visibly to the one before it.

Here is a fictional illustration in AED. If opening cash is AED 100,000, receipts are AED 60,000 and payments are AED 75,000, closing cash is AED 85,000. If AED 20,000 of those receipts is delayed to the following week, this week’s receipts become AED 40,000 and closing cash becomes AED 65,000. Move the delayed receipt into the week it is now expected; do not erase it from the forecast. The example illustrates timing, not a prediction or recommendation.

Use scenarios as planning tools

Prepare a base case using current evidence and reasonable assumptions. Add a plausible downside case to test how the cash position could change if, for example, a significant customer pays later than expected or a planned outflow is higher. Explain which assumptions differ between cases and why. Scenarios are planning tools, not predictions, and should not imply that additional funding or an overdraft will be available.

If a scenario shows pressure on cash, use it as an early prompt to review information, options and commitments with the appropriate people. Do not assume that contractual payment commitments can be ignored or changed unilaterally.

Review actuals, investigate variances and validate

Each week, compare actual receipts and payments with the previous forecast. Look beyond the total variance: identify which item differed, whether the cause was timing or amount, and whether the assumption should change in future weeks. Record the explanation so that repeated misses become visible. Then enter actual cash, update the remaining weeks and add a new week to restore the rolling 13-week view.

Practical spreadsheet checks can catch common errors:

• Confirm each week’s closing cash equals opening cash plus receipts less payments.
• Confirm each week’s opening cash matches the previous week’s closing cash.
• Check that dates are in sequence and that each movement appears in the intended week.
• Look for duplicate invoices, missing scheduled payments and unexplained manual entries.
• Reconcile the first opening balance to the bank and label restricted cash separately.
• Use clear signs, consistent units and visible scenario labels; investigate unexpected negative balances or formula errors.

A forecast is most useful when it is understandable, evidence-based and regularly refreshed. For further reading, see BDC’s guidance on cash flow projections: https://www.bdc.ca/en/articles-tools/money-finance/manage-finances/making-projection-coming-year and British Business Bank’s guidance on reforecasting in uncertain times: https://www.british-business-bank.co.uk/business-guidance/guidance-articles/finance/reforecasting-in-uncertain-times.