Skip to main content
Early accessBeta, invite only since 1 Nov 2026. A person reads every application.Apply for an invite
Demystify OS

How do I build a 13-week cash flow forecast for my small business in India?

List thirteen weeks across a sheet, put the opening cash in week one, add expected receipts by the week customers will really pay, subtract payments by the week they fall due, and show the closing balance. Update it every week, replacing the oldest week with real numbers and adding a new one.

Who asks this: A founder or finance head of a small Indian business who profits on paper but runs short of cash in odd weeks, and wants to see a shortfall two months ahead instead of two days ahead.

The steps

  1. 1. Set up thirteen weekly columns

    Open a sheet with one column per week, starting with the current week, and rows for cash in, cash out and the closing balance. Thirteen weeks is a quarter, long enough to see a dip coming and short enough to stay believable. The owner or the accounts lead builds it once and keeps the same layout every week.

  2. 2. Start with the real opening cash

    Put the cleared bank and cash balance of today in week one. Do not use the book balance if it includes uncleared cheques or gateway money in transit. Everything else in the sheet builds on this number, so check it against the statement.

  3. 3. Fill the money coming in by when it will arrive

    Go through the open invoices and place each in the week the customer is likely to pay, based on how that customer actually behaves, not on the due date. Add cash sales you expect each week, using last quarter as a guide. Leave out any sale you have not yet made.

  4. 4. Fill the money going out by when it must leave

    Add salaries, rent, supplier bills by due date, loan instalments, insurance, and tax payment dates your accountant confirms. Add festival-season stock purchases in the weeks they usually happen. Include the owner's own drawings, because they are real outflows.

  5. 5. Calculate the closing balance and mark the floor

    Each week, closing cash equals opening cash plus money in minus money out, and it becomes next week's opening cash. Choose a floor, such as the fixed outflows of two weeks, and shade each week where the closing balance dips below it.

  6. 6. Decide what to do about the shaded weeks

    For each shaded week, write one action: ask a customer to pay earlier, delay a discretionary purchase, split a supplier payment or arrange a short credit line. Do this weeks ahead, when options exist. Share the sheet with your accountant and ask for their view on the tax lines.

  7. 7. Roll it forward every week

    On the same day each week, replace the past week's estimates with actuals, note where you were wrong and why, and add a new week thirteen. After a month you will know which customers pay late and which costs you forget.

A worked example

illustrative

A packaged-food maker in Indore starts with four lakh twenty thousand rupees cleared and a floor of one lakh fifty thousand. Collections: two lakh in week one, one lakh fifty thousand in week two, three lakh in week four. Payments: salaries of two lakh eighty thousand in week two, rent of ninety thousand in week three, festival raw material of six lakh twenty thousand in week five. Closing cash: week one six lakh twenty thousand; week two four lakh ninety thousand; week three four lakh; week four seven lakh; week five eighty thousand. Week five is under the floor, so he splits the purchase over weeks five and seven.

What goes wrong

  • Receipts are placed on the invoice due date, while customers pay weeks later, so every shortfall arrives as a surprise.
  • Tax payments and the owner's drawings are left out because they are irregular.
  • The forecast is built once and never rolled forward, so it is wrong within a month.
  • Every line is a guess and nothing is compared with actuals, so the sheet never improves.
  • The sheet mixes profit and cash, counting sales that are not yet paid as money in hand.
  • Festival-season stock buying is forgotten, and the biggest outflow of the year is missing.

How Demystify OS helps

  • Weekly summaryEarly access

    A weekly summary of notes, results and open items gives the owner a fixed point each Friday to roll the forecast forward.

  • Hand the CA the month-end reportsAvailable

    Shows that receivable and payable ageing come from the same books, which are the two lists a thirteen-week sheet is filled from.

  • Mysty WorkersEarly access

    Mysty Workers can be set up with you to roll the sheet forward each week from the open invoices, bills and payroll dates you confirm, flag weeks below your floor and ask you for assumptions it cannot know. A forecast routine is not yet a standard catalogue entry.

What it does not do. Demystify OS does not predict your sales, guess when a customer will pay or arrange credit for you; it works from the dates and amounts you confirm, and the owner makes every decision.

Questions people ask

Why thirteen weeks and not twelve months?

Thirteen weeks is one quarter, close enough that your estimates are reasonable and far enough to give you time to act. A twelve-month plan is a different tool for budgeting. A rolling thirteen-week view is the one that tells you when cash will actually run short.

Is there a simple version for a very small business?

Yes, six lines are enough: opening cash, collections, salaries and rent, supplier payments, other payments and closing cash. Fill them for thirteen weeks. Add detail only when a line is large enough to cause a surprise.

How accurate does the forecast need to be?

Accuracy to the rupee is not the aim. The aim is to see the week when cash is thin, with enough warning to do something about it. Compare each week with actuals and track the gap. If a gap is big enough to cross your floor, stop and check the plan before you spend.

What should I do when a week is below the floor?

Pick an action early: ask a customer to pay sooner, split a supplier payment, delay a purchase that can wait, or arrange a short credit line with your bank. Early requests are accepted more readily than last-minute ones.

Who should update the forecast?

One named person, the same day every week, with the owner reading it. If it is passed between several people it goes stale. Ask your accountant to review the tax and statutory lines each quarter so the sheet stays realistic.

Apply for the beta.

Demystify OS is invite only, and a person reads every application.

Apply for the beta