Monthly cash flow and cash gap
From monthly receipts and payments calculates the cash balance, the tightest month and the shortfall against a safe minimum.
At a glance
- What question does it answer?
- In which month cash falls below the safe minimum and how much must be raised or deferred.
- What data is needed?
- Opening cash and a safe minimum.
- How to read the result?
- Look at the lowest balance and the month it occurs. Red bars are balances below the safe minimum. “Shortfall” shows the size of a credit line or deferral. Example on the default values: Opening cash is RUB 15m and the safe minimum RUB 5m. In month 2 the balance falls to −RUB 7m and RUB 12m is missing to reach the safe minimum; the balance is negative in two months and ends the period at RUB 10.4m. If the gap falls in a month when customers’ money is about to arrive, first move supplier payments and only then discuss a limit with the bank. Next: “End-to-end cash gap” and “Overdraft, factoring or inventory loan: which is cheaper”.
Why and how to reason
A profitable business can run out of cash: goods were bought in April, but revenue arrives in June. So cash is calculated separately from profit, on a calendar: when it comes in, when it goes out. Month balance = previous balance + receipts - all payments (purchases, fixed costs, taxes). The balance carries from month to month, so one month’s trough is visible later too.
The key figure is not the end of the period but the lowest point. That is where you pay bills from your own or borrowed money. The safe minimum is a cushion for delayed receipts. Shortfall = minimum - lowest balance.
Example. Start RUB 15 m. Month 1: 15 + 16 - 22 - 7 - 2.5 = -RUB 0.5 m. Month 2: -0.5 + 21 - 18 - 7 - 2.5 = -RUB 7 m. Month 3: +RUB 0.8 m. By month six RUB 10.4 m. The end looks fine, but the bottom is -RUB 7 m against a cushion of RUB 5 m: RUB 12 m is missing.
When to use it
It fits when planning purchases and before a season, when you need to know how much cash to raise and when. Suitable for horizons from three to twelve months. It does not replace the profit budget: it shows only the movement of cash. Assumption: you set payment and receipt dates correctly. For wholesale with credit terms check which month the payment, not the shipment, falls in.
How to read the result
Look at the lowest balance and the number of months with a negative balance. A negative bottom is a cash gap: it must be closed with a loan, supplier credit, buyer prepayment or a postponed purchase. A shortfall of RUB 12 m shows the size of financing needed including the cushion. Decision: define which months need funding and for how long. Then check which payments can be shifted and recalculate. A positive end does not cancel the problem inside the period. Check whether the trough deepens if buyers delay payments by two weeks: shift receipts and recalculate. If the bottom falls below the safe minimum, you need a financing reserve, not just hope.
Common mistakes
Typical trap: recording revenue in the month of shipment rather than payment; forgetting tax payments and VAT; ignoring the prepayment to the factory; setting the safe minimum to zero. Also: looking at the end of the period and not at the minimum. Also: not including loan interest and owner payouts.
What data is needed?
- Opening cash and a safe minimum.
- By month: receipts, supplier payments, rent and payroll, taxes and loans.
- Where to take it: opening cash from bank statements and the till; receipts from the customer payment schedule and the sales plan with the real delay; supplier payments from orders and the payment schedule; rent, payroll, taxes and loans from accounting’s payment calendar. Start with known payments, then add the receipts forecast.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Opening cash | ₽ | 15,000,000 | The balance on accounts on day one of the first month; can be negative with an overdraft. |
| Safe minimum balance | ₽ | 5,000,000 | How much cash you want to keep at all times in case of delayed payments. |
How it is calculated
| Step | Formula |
|---|---|
| Balance | Previous balance + receipts − all payments |
| Shortfall | Safe minimum − lowest balance |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Cash at the end
- 10.4 m ₽
- Lowest balance
- −7 m ₽ · Month 2
- Shortfall to the safe minimum
- 12 m ₽How much to raise or defer to stay above the minimum.
- Months with a negative balance
- 2
Cash movement
| Month | Receipts | Payments | Net of the month | Balance |
|---|---|---|---|---|
| Month 1 | 16 m ₽ | 31.5 m ₽ | −15.5 m ₽ | −500,000 ₽ |
| Month 2 | 21 m ₽ | 27.5 m ₽ | −6.5 m ₽ | −7 m ₽ |
| Month 3 | 30 m ₽ | 22.2 m ₽ | 7.8 m ₽ | 800,000 ₽ |
| Month 4 | 36 m ₽ | 19.7 m ₽ | 16.3 m ₽ | 17.1 m ₽ |
| Month 5 | 26 m ₽ | 25.2 m ₽ | 800,000 ₽ | 17.9 m ₽ |
| Month 6 | 19 m ₽ | 26.5 m ₽ | −7.5 m ₽ | 10.4 m ₽ |
In Month 2 the balance is −7 m ₽: 12 m ₽ short of the safe minimum. Options: defer part of supplier payments, speed up receipts, agree a credit line in advance.
Nuances and limits
- Plan receipts by the real payment delay, not by contract.
- Enter taxes and seasonal payments in the month they actually go out.
- Enter amounts by actual payment date, not document date: the calculation works by the month cash moves.