A business can have healthy sales and still face a cash shortage next Friday. Customer receipts arrive late, suppliers expect payment, salaries fall due and tax obligations cannot be postponed simply because invoices remain unpaid. A 13-week cash flow forecast makes those timing pressures visible before they become emergencies.

It is a short-term, rolling estimate of cash expected to enter and leave the business over the next 13 weeks. It complements, rather than replaces, a monthly or annual budget.

How is a 13-week forecast different from a P&L?

A P&L recognises income and expenses according to accounting policies. A cash forecast tracks the expected date of money movement. For example, revenue invoiced today on 45-day credit may improve this month's P&L but create no immediate bank receipt.

A 13-week forecast normally follows direct cash movement: opening available cash + expected receipts − expected payments = forecast closing cash. Categories and timing must reflect actual bank and operational information.

Step 1: Start with the correct opening cash

Use reconciled opening bank balances and any cash balances genuinely available for payments. Separate restricted funds or accounts that cannot freely fund operations. Do not treat unused borrowing limits or uncleared cheques as money already in the bank.

Step 2: Forecast collections by realistic dates

Begin with open customer invoices, contractual milestones, subscription collections and expected new sales receipts. A due date is not always a collection date. Use payment history and customer-specific evidence when estimating timing. Distinguish confirmed receivables from optimistic pipeline assumptions.

Step 3: List unavoidable payments

Include salaries, rent, supplier commitments, taxes, loan instalments, interest, utilities, planned purchases and approved capital expenditure. Large one-off payments should appear in the week they are expected to leave the bank.

Step 4: Calculate each week's closing balance

Here is a hypothetical four-week excerpt from a 13-week model, in ₹ lakh. It is a teaching example, not a PROFINZO client's forecast.

WeekOpening cashReceiptsPaymentsClosing cash
15.03.04.04.0
24.02.04.51.5
31.55.03.03.5
43.51.04.00.5

The issue is visible immediately: by week 4, only ₹0.5 lakh is forecast to remain. Management should investigate the assumptions and funding options before the low-cash week arrives. The same method continues through weeks 5–13.

Step 5: Stress-test the assumptions

Create a base case and at least one downside case. What happens if the largest customer pays two weeks late? What if a raw-material order must be prepaid? What if an expected loan disbursement slips? Calculate the cash impact and identify the earliest week requiring action.

Forecasting is most useful when it informs decisions. Possible responses include accelerating documented collections, rescheduling discretionary spending, negotiating supplier terms or arranging funding discussions. Any decision must account for commercial relationships, contractual obligations and financing costs.

Step 6: Update the forecast with actuals

At each agreed refresh, replace elapsed forecast weeks with actual movements, compare expected versus actual cash, investigate material differences and add the next week at the end. Keep earlier forecast versions so management can learn whether errors came from customer timing, expenditure assumptions or incomplete inputs.

Common mistakes that make a forecast unreliable

  • Using invoice value as immediate cash: credit sales and collections are not interchangeable.
  • Ignoring GST, TDS and other payment commitments: tax-related cash movements need to appear when payable.
  • Counting probable financing as confirmed: display uncertain loans or capital injections as scenarios until sufficiently committed.
  • Forgetting supplier advances or seasonal purchases: these may be much larger than average weekly expenses.
  • Treating the forecast as a guarantee: all forward-looking estimates depend on assumptions that can change.

Which businesses benefit most?

A 13-week view is particularly useful for businesses with uneven collections, lumpy purchases, short cash runways, high working-capital needs or rapid growth. A stable business may still benefit, but the level of detail should reflect how frequently management needs to act.

How PROFINZO supports cash-flow planning

PROFINZO's Virtual CFO engagement is intended to convert reliable closed books into cash forecasts, budgets, management KPIs and financial decisions. Its current published service includes a rolling 12-month cash view and a 13-week near-term forecast, with the update rhythm defined in the agreed scope. Ordinary bookkeeping is a separate engagement.

Frequently asked questions

Why 13 weeks? It provides roughly a quarter's weekly cash visibility, capturing near-term payment timing more precisely than a simple monthly plan.

Is a 13-week forecast only for distressed businesses? No. Growing businesses can use it to plan inventory, hiring and upcoming commitments as well.

Should sales forecasts be included? Yes, but distinguish reasonably evidenced receipts from speculative sales opportunities.

Who is responsible for payments? Business management makes and authorises payments. A finance adviser can model and recommend; advisory support does not transfer bank-signatory authority.

Next step: Request a cash-flow planning discussion.

Educational information. Examples are illustrative, not client results. Your service scope and business circumstances should be assessed separately.
← All insights