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 daily cash position report for my small business?

Each morning, write down the balance in every account, the money you expect today, the payments due this week and the balance you would be left with. Set a minimum floor, and mark any day when you would fall below it. Ten honest minutes beats a perfect report that nobody builds.

Who asks this: A small-business owner in India who checks the bank app a few times a day, is surprised by salary day or a supplier due date, and wants to see at a glance whether the week is safe.

The steps

  1. 1. List every place money sits

    Write down each bank account, the cash in hand, the balance with each payment gateway that has not yet been settled, and any fixed deposit you could break in an emergency. Keep the list short and stable. The owner or the accounts person reviews it once a quarter, so a forgotten account does not make the report wrong.

  2. 2. Take the opening balance from the statement

    Use the latest figure from the bank statement or the app, not from memory. Note the time you read it. UPI credits show quickly, but cheque deposits can take days, so write the cleared balance and the uncleared cheques as two lines.

  3. 3. List the money you expect today and this week

    From your open invoices, mark the amounts that customers have promised for today and the next few days. Use the date they promised, not the invoice due date, because the two often differ. If you have a shop, add an average of the cash and UPI takings for the day.

  4. 4. List the payments you must make this week

    Add supplier payments due, rent, salary day, loan instalments and any tax payment date. Salary day is usually the biggest single outflow, so show it as its own line. Anything that can be delayed without a penalty goes in a second column, so you know what you can move.

  5. 5. Work out the balance after each day

    For the next seven days, take yesterday's closing balance, add today's receipts and subtract today's payments; for instance one lakh plus fifty thousand less thirty thousand leaves one lakh twenty thousand. Show the result as one row of seven numbers. The point is not accuracy to the rupee but seeing the day the balance is thinnest.

  6. 6. Set a floor and mark the days below it

    Pick a minimum balance below which you would feel unsafe, such as the cost of a week of salaries and rent. Highlight any day in the next seven where the balance falls under it. Then decide: ask a customer to pay earlier, move a supplier date, or arrange a short credit line before the day arrives.

A worked example

illustrative

A retailer in Surat starts Monday with three lakh ten thousand rupees cleared in the bank; a forty thousand rupee cheque is not cleared, so it is left out. Customers promise ninety thousand on Tuesday and one lakh twenty thousand on Thursday. Payments are one lakh fifty thousand on Wednesday, sixty thousand on Friday and two lakh forty thousand on Saturday. Her floor is one lakh. Closing balances: Tuesday four lakh; Wednesday two lakh fifty thousand; Thursday three lakh seventy thousand; Friday three lakh ten thousand; Saturday seventy thousand. Saturday is thirty thousand under the floor, so she asks a trade customer to pay fifty thousand on Friday.

What goes wrong

  • The report uses the invoice due date for incoming money, and customers who always pay a week late make it too cheerful.
  • Cheques that have not cleared are counted as available cash.
  • A gateway balance that is yet to be settled is treated as money in the bank.
  • The report is built once a month, when the question is a daily one.
  • Salary day and quarterly payments are left off, and the week looks safe until the day they hit.
  • The floor is never written down, so every low balance is a fresh argument.

How Demystify OS helps

  • Owner brief, morningEarly access

    The owner brief is one message each morning built from the overnight rollups and what needs a decision, which is the place a cash position line belongs.

  • emailEarly access

    Email is a notify channel through Mysty Desk, so the morning brief can reach the owner's inbox from a verified sending domain.

  • Mysty WorkersEarly access

    Mysty Workers can be set up with you to read the latest statement or export you provide, list the receipts and payments due this week and warn when the balance would fall below your floor. It is only as fresh as the last file you give it, and a cash-position routine is not yet a standard catalogue entry.

What it does not do. Demystify OS does not connect to your bank to see live balances, move money or predict what customers will pay; the report is only as current as the statement or export you share.

Questions people ask

How often should a small business check its cash position?

Daily is ideal and takes about ten minutes once the sheet exists. If that feels heavy, do it on the three days when most money moves, such as Monday, the day before salary and the day before a large supplier payment. A fixed rhythm matters more than the frequency.

What is a good minimum cash floor?

There is no universal number. Many owners use the cost of one to two weeks of fixed outflows, such as salaries, rent and loan instalments. Pick a figure that lets you sleep, write it at the top of the sheet and review it every quarter with your accountant.

Should I include money that customers have promised?

Yes, but on the date they promised, and in a separate line from cleared balance. If a customer has missed a promise twice, move it a week out. A cautious receipts line makes the report more useful than an optimistic one.

How is this different from a cash flow forecast?

A daily position looks at the next seven days with real figures and is for steering this week. A forecast looks thirteen weeks out with assumptions and is for spotting a gap early. Many owners use both, one feeding the other.

Can I do this without accounting software?

Yes. A sheet with the balance, the receipts, the payments and a running total works fine for a small business. The discipline of updating it every morning matters more than the tool.

Apply for the beta.

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

Apply for the beta