The 13-week cash plan: balance, gap and stress
Week by week calculates the cash balance from receipts and payments, finds the first week below the minimum balance and the size of the gap, then repeats the calculation with delayed and short customer receipts.
At a glance
- What question does it answer?
- In which week cash falls below the minimum, by how much and whether a credit line will do if customers pay late.
- What data is needed?
- Cash at the start, your minimum balance and the available credit line.
- How to read the result?
- Default data: 12,000,000 at the start, a minimum balance of 4,000,000. In the plan the balance falls to 2,300,000 in week 6: 1,700,000 short of the minimum. In the stress (shortfall 10%, delay 1 week) the balance goes negative in week 5 and reaches −7,950,000 in week 8; the gap to the minimum is 11,950,000 and a line of 3,000,000 does not cover it: 8,950,000 is short. So supplier payments of weeks 5–8 must be shifted or a line agreed in advance. Example on the default values: Cash at the end of the horizon (plan): RUB 25.2 million; Lowest balance (plan): RUB 2.3 million · Week 6; First week below the minimum balance (plan): Week 6; Gap to the minimum balance (plan): RUB 1.7 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A profitable business can go bankrupt through a cash gap: money arrives later than it must be paid. Profit says whether you earned, a cash plan says when money will be in the account. Thirteen weeks is a horizon where something can still be changed. Balance of the week = previous week’s balance + receipts − all payments of the week (suppliers, rent, taxes, other). In the example the opening is 12 million, the minimum balance 4 million. In week 6 the balance drops to 2.3 million: 1.7 million short of the minimum, and it is better to learn this five weeks ahead. The stress mode shifts customer receipts by one week (delay) and cuts them by 10% (shortfall): receipts of week i = plan of week (i − delay) × (1 − shortfall). Supplier payments, taxes and payroll do not change. Result: the balance goes negative (−7.95 million), the gap to the minimum is 11.95 million, a credit limit of 3 million does not cover everything.
When to use it
Use it weekly, updating actuals and shifting the horizon, and especially before big purchases and tax payments. It suits a brand and a retailer of any size. It does not replace the annual budget and the profit calculation. Assumptions: receipts and payments are entered by the dates of actual payments, not shipment dates; in stress only customer receipts shift; customers’ money for weeks before the horizon start is not accounted for in stress; check peaks of receipts and payments against contracts.
How to read the result
First “lowest balance (plan)” and the week it occurs: this is the date by which a decision must be made. If the balance is below the minimum you have four levers: postpone supplier payments, speed up receipts (early-payment discount), agree a limit, cut purchasing. Then stress: if it goes negative it is a cash gap, not just lower stock, and the credit limit should be compared with its size (−8.95 million in the example). Do not let it come to urgently searching for money in stress: negotiate in advance. Update the plan every week: a forecast goes stale quickly.
Common mistakes
Entering receipts by shipment date rather than payment date: the money arrives later. Forgetting taxes and contributions, rent, loan payments and holiday pay: they lie in spots across the weeks. Setting the minimum balance at zero: a small delay turns it into a gap. Assuming the credit limit is always available: a bank may cut it at a difficult moment.
What data is needed?
- Cash at the start, your minimum balance and the available credit line.
- By week: customer receipts, other receipts, suppliers, payroll, rent, taxes in the week of the due date, other payments.
- The shortfall and delay of receipts for the stress.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Cash at the start of week 1 | ₽ | 12,000,000 | The balance on accounts and in the till. An overdraft goes in as a negative number. |
| Minimum balance | ₽ | 4,000,000 | How much cash you always keep for delays: your own level, for example a week of compulsory payments. There is no single standard. |
| Available credit line | ₽ | 3,000,000 | Optional. An unused overdraft or credit line under the bank contract: shows whether it covers the gap. The example value is illustrative. |
| Shortfall of customer receipts | % | 10 | By how many percent customer receipts are below plan in the stress. Your own spread from past weeks: there is no single standard. |
| Delay of customer receipts | weeks | 1 | By how many weeks customer money shifts. Money for the last weeks falls outside the horizon, the first weeks are left without it. |
How it is calculated
| Step | Formula |
|---|---|
| Week balance | previous balance + receipts − all payments of the week |
| Stress | customer receipts of week i = plan of week (i − delay) × (1 − shortfall) |
| Gap | minimum balance − the lowest balance (if above zero) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Cash at the end of the horizon (plan)
- 25.2 m ₽
- Lowest balance (plan)
- 2.3 m ₽ · Week 6
- First week below the minimum balance (plan)
- Week 6
- Gap to the minimum balance (plan)
- 1.7 m ₽The minimum balance less the lowest balance: how much to raise, defer or save.
- Lowest balance in the stress
- −7.95 m ₽ · Week 8
- Gap to the minimum balance in the stress
- 12 m ₽
- First week with a negative balance in the stress
- Week 5
- Credit line against the gap in the stress
- −8.95 m ₽Plus: the line is enough. Minus: this amount is short.
- Plan
- Stress
Data as a table
| Week | Plan | Stress |
|---|---|---|
| Week 1 | 10.9m | 4.9m |
| Week 2 | 10.1m | 4m |
| Week 3 | 10.8m | 4.65m |
| Week 4 | 10.5m | 2.35m |
| Week 5 | 6m | −2.3m |
| Week 6 | 2.3m | −5.6m |
| Week 7 | 7.5m | −1.4m |
| Week 8 | 2.5m | −7.95m |
| Week 9 | 9.2m | −2.4m |
| Week 10 | 9.8m | −3.5m |
| Week 11 | 12.8m | −1.8m |
| Week 12 | 18.5m | 2.55m |
| Week 13 | 25.2m | 10.4m |
Weeks: balance in the plan and in the stress
| Week | Receipts | Payments | Net of the week | Balance, plan | Balance, stress | Status in the stress |
|---|---|---|---|---|---|---|
| Week 1 | 6 m ₽ | 7.1 m ₽ | −1.1 m ₽ | 10.9 m ₽ | 4.9 m ₽ | ok |
| Week 2 | 5.5 m ₽ | 6.3 m ₽ | −800,000 ₽ | 10.1 m ₽ | 4 m ₽ | ok |
| Week 3 | 5 m ₽ | 4.3 m ₽ | 700,000 ₽ | 10.8 m ₽ | 4.65 m ₽ | ok |
| Week 4 | 6.5 m ₽ | 6.8 m ₽ | −300,000 ₽ | 10.5 m ₽ | 2.35 m ₽ | below minimum |
| Week 5 | 6 m ₽ | 10.5 m ₽ | −4.5 m ₽ | 6 m ₽ | −2.3 m ₽ | negative |
| Week 6 | 5.5 m ₽ | 9.2 m ₽ | −3.7 m ₽ | 2.3 m ₽ | −5.6 m ₽ | negative |
| Week 7 | 5.5 m ₽ | 300,000 ₽ | 5.2 m ₽ | 7.5 m ₽ | −1.4 m ₽ | negative |
| Week 8 | 6.5 m ₽ | 11.5 m ₽ | −5 m ₽ | 2.5 m ₽ | −7.95 m ₽ | negative |
| Week 9 | 7 m ₽ | 300,000 ₽ | 6.7 m ₽ | 9.2 m ₽ | −2.4 m ₽ | negative |
| Week 10 | 8 m ₽ | 7.4 m ₽ | 600,000 ₽ | 9.8 m ₽ | −3.5 m ₽ | negative |
| Week 11 | 8.5 m ₽ | 5.5 m ₽ | 3 m ₽ | 12.8 m ₽ | −1.8 m ₽ | negative |
| Week 12 | 9 m ₽ | 3.3 m ₽ | 5.7 m ₽ | 18.5 m ₽ | 2.55 m ₽ | below minimum |
| Week 13 | 7 m ₽ | 300,000 ₽ | 6.7 m ₽ | 25.2 m ₽ | 10.4 m ₽ | ok |
In the plan the balance falls to 2.3 m ₽ (Week 6): 1.7 m ₽ short of the minimum balance. Decide before that week: defer part of supplier payments, speed up receipts, agree a credit line.
In the stress the balance goes negative in the week “Week 5”: that is a cash gap, not just a lower reserve.
The stress shifts only customer receipts; supplier payments, taxes and payroll do not change. Customer money for the weeks before the horizon is not counted in the stress. Put the peaks of receipts and returns in the IS sale, before it BS and after it AS into your own weeks (BS, IS, AS and SO: before the sale, in the sale, after it and the final sell-out (your company may name them differently)).
Norms (a guide as of 13.11.2026, check against the act text): Tax Code, part two. Check with an accountant and a lawyer.
Nuances and limits
- Put payments in the week the money really passes through the bank, not in the week of the document.
- Put taxes in the week of the due date: most taxes and contributions are paid by the 28th through the unified tax account; check amounts and dates with an accountant.
- The stress shifts only customer money, while suppliers also have shifts.
- Update the plan once a week against actuals.