AB Consulting, a Business Consultant Company

A 13-week cash flow forecast shows when cash will enter and leave your business, week by week. It helps you identify the lowest projected balance, test payment delays, and agree actions before a shortfall reaches the bank account.

Your sales pipeline looks healthy. Your accounts show a profit. Yet next month’s payroll feels uncertain. The problem may be timing: customers pay after suppliers, wages, and loan repayments fall due. An annual budget can hide that weekly gap.

This guide turns forecasting into a management routine: establish reliable opening cash, map receipts and payments, test a downside case, then assign actions. Use it alongside your longer-term financial plan. AB Consulting’s financial and accounting management services support this wider planning work.

1. What a 13-week cash flow forecast should tell leaders

Thirteen weeks provides roughly one quarter of visibility. A weekly view can reveal pressure that a monthly total smooths away. However, extend the horizon when your operating cycle is longer. For construction, seasonal hospitality, or slow-moving inventory, thirteen weeks alone may miss important commitments.

A useful forecast answers three questions: What is our lowest cash balance? When does it occur? Who will act before it happens? The forecast is a decision tool, not a promise that every customer will pay on time.

Keep profit and cash separate. Revenue can appear in your accounts before payment arrives. Meanwhile, repaying loan principal consumes cash without being an operating expense. The British Business Bank explains this distinction in its guide to reforecasting.

For the wider financial picture, explore AB Consulting’s cash management guide. This article focuses specifically on the weekly operating process.

2. Build your 13-week cash flow forecast in five steps

Step 1: Establish cash you can actually use

Reconcile the opening balance to your bank accounts at a fixed cut-off. Identify restricted deposits and funds unavailable for operations. Record uncleared transactions consistently so you do not count a payment twice.

For multiple entities, forecast each entity before preparing a group view. Cash in one company may not be transferable to another when needed. Record intercompany transfers on both sides and eliminate them in the consolidated total. Keep currencies separate until you apply explicit exchange-rate assumptions.

Step 2: Map receipts to expected payment dates

Start with outstanding customer invoices, confirmed orders, deposits, and other evidenced receipts. Use expected bank settlement dates rather than invoice dates. Ask sales and collections teams to identify disputed invoices, customer acceptance conditions, and likely delays.

Separate confirmed receipts from uncertain pipeline. An unsigned contract should not carry the same confidence as an agreed payment. For material amounts, record the evidence, expected date, confidence level, and responsible person. Put uncertain sales into a separate scenario.

Step 3: Schedule payments from real commitments

Use supplier invoices, purchase orders, payroll schedules, leases, debt schedules, and approved investment plans. Include principal, interest, fees, and relevant taxes on their actual expected payment dates. Confirm local filing and payment obligations with your accountant.

For cash planning, use amounts that will actually pass through the bank, including indirect taxes where applicable. Record any later recovery separately. Remove depreciation and other non-cash entries. Also check that an invoice already included in payables has not been added again from a purchase-order list.

Step 4: Calculate closing cash and a buffer

Closing cash = opening cash + receipts − payments. Carry each week’s closing cash into the next week’s opening cash. Keep facility availability separate from bank cash. A facility is useful only when it is committed, drawable, and permitted under its conditions.

Choose a minimum cash buffer based on your own commitments and uncertainty. It could reflect the next payroll, critical suppliers, and a delay allowance. There is no universal percentage that fits every company. Show headroom against the buffer in every week.

Step 5: Stress-test timing and assign actions

Duplicate the forecast and delay one large customer receipt by two weeks. Then test an unexpected essential payment. Keep the original assumptions visible. A downside case should explain exactly what changed, rather than simply reducing every receipt by an arbitrary percentage.

Link each shortfall to an owner and deadline. Options might include resolving a billing dispute, collecting a deposit under agreed terms, rescheduling discretionary capital spending, or discussing financing early. Do not assume a supplier accepts later payment until agreement exists.

3. Worked example: profitable sales, tight weekly liquidity

Illustrative example only; these figures are not an AB Consulting client case. All amounts are EUR thousands. A distributor starts with €80,000 of usable cash and selects a €40,000 operating buffer. The first four weeks of its thirteen-week model look like this:

Week 2 closes at €65,000 + €35,000 − €75,000 = €25,000. The business remains cash-positive, but it falls €15,000 below its chosen buffer. That is a warning to act, even though Week 3 looks stronger.

Now delay a €30,000 receipt from Week 3 to Week 5. Week 3 closes at €40,000 instead of €70,000. Week 4 then closes at €35,000 instead of €65,000. Both scenarios require attention: the original Week 2 pressure and the later customer delay.

A practical response could bring forward a confirmed €20,000 collection from Week 3 to Week 2, with the customer’s agreement. Week 2 would close at €45,000. Week 3’s opening balance rises by €20,000, while its receipts fall by the same amount, so its closing balance stays at €70,000. This fixes timing; it does not create new revenue or extra total cash.

Track proposals separately from approved actions. Otherwise, the forecast can look healthy because it assumes decisions that nobody has executed. AB Consulting’s reporting and decision-making services can help connect financial visibility with management accountability.

4. Keep the forecast useful every week

Choose a fixed weekly cut-off and a named forecast owner. Replace the completed week with actual bank movements, reconcile the difference, and add a new Week 13. Save the previous version so managers can see which assumptions changed.

Hold a short review with finance, sales, and operations. Focus on material receipt delays, unexpected payments, the lowest projected cash point, and overdue actions. If your cash position changes daily, add a daily view for the nearest weeks.

Measure accuracy by comparing actual receipts and payments with forecast amounts. Explain the difference as timing, amount, omission, or duplication. An invoice paid one week late needs a different response from an invoice that will not be paid at all.

Weekly review checklist

• Opening cash agrees to reconciled usable bank balances.
• Large receipts have evidence, dates, and an accountable owner.
• Payroll, debt, taxes, and critical suppliers are included.
• Restricted cash and undrawable facilities are excluded from usable funds.
• The lowest balance and buffer gap are visible in both scenarios.
• Each action has an owner, deadline, and confirmed status.
• The model extends beyond thirteen weeks if the operating cycle requires it.

Common questions

Can we start in a spreadsheet? Yes. A controlled spreadsheet can work when inputs are manageable. Protect formulas, identify input cells, keep version history, and reconcile totals. Consider integration when manual updates create delays or conflicting data.

How is this different from a cash flow statement? A statement describes historical cash movements. This forecast estimates future receipts and payments so management can act before a shortfall.

Does a negative week mean the business is insolvent? A forecast shortfall is a liquidity warning. It is not, by itself, a legal insolvency conclusion. Assess obligations, available funding, and applicable local law with qualified advisers.

For a second explanation of the fundamentals, see the British Business Bank’s cash flow forecasting guide.

Turn cash visibility into a management decision

Need help building a reliable weekly model or translating forecast gaps into an action plan? Contact AB Consulting to discuss a strategy session or operational deep-dive. Tell us your sector, country, number of entities, and main cash timing challenge so we can scope the support you need.

Prepared by AB Consulting. Examples and the weekly checklist are original editorial illustrations. Reference guidance checked in October 2026.