Syntha Lab RU

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.

The 13-week cash plan For whom: Finance directors, accountants and owners ahead of a payment peak, a buy or a season.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Cash at the start of week 1₽12,000,000The balance on accounts and in the till. An overdraft goes in as a negative number.
Minimum balance₽4,000,000How 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,000Optional. 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%10By 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 receiptsweeks1By 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

StepFormula
Week balanceprevious balance + receipts − all payments of the week
Stresscustomer receipts of week i = plan of week (i − delay) × (1 − shortfall)
Gapminimum 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.
Cash balance at the end of the week: plan and stress
Line chart: Plan: 10.9m → 25.2m; Stress: 4.9m → 10.4m−10m010m20m30mWeek 1Week 4Week 7Week 10Week 13minimum balancePlan, Week 1: 10.9mPlan, Week 2: 10.1mPlan, Week 3: 10.8mPlan, Week 4: 10.5mPlan, Week 5: 6mPlan, Week 6: 2.3mPlan, Week 7: 7.5mPlan, Week 8: 2.5mPlan, Week 9: 9.2mPlan, Week 10: 9.8mPlan, Week 11: 12.8mPlan, Week 12: 18.5mPlan, Week 13: 25.2mStress, Week 1: 4.9mStress, Week 2: 4mStress, Week 3: 4.65mStress, Week 4: 2.35mStress, Week 5: −2.3mStress, Week 6: −5.6mStress, Week 7: −1.4mStress, Week 8: −7.95mStress, Week 9: −2.4mStress, Week 10: −3.5mStress, Week 11: −1.8mStress, Week 12: 2.55mStress, Week 13: 10.4m₽Week
  • Plan
  • Stress
Data as a table
WeekPlanStress
Week 110.9m4.9m
Week 210.1m4m
Week 310.8m4.65m
Week 410.5m2.35m
Week 56m−2.3m
Week 62.3m−5.6m
Week 77.5m−1.4m
Week 82.5m−7.95m
Week 99.2m−2.4m
Week 109.8m−3.5m
Week 1112.8m−1.8m
Week 1218.5m2.55m
Week 1325.2m10.4m

Weeks: balance in the plan and in the stress

WeekReceiptsPaymentsNet of the weekBalance, planBalance, stressStatus in the stress
Week 16 m ₽7.1 m ₽−1.1 m ₽10.9 m ₽4.9 m ₽ok
Week 25.5 m ₽6.3 m ₽−800,000 ₽10.1 m ₽4 m ₽ok
Week 35 m ₽4.3 m ₽700,000 ₽10.8 m ₽4.65 m ₽ok
Week 46.5 m ₽6.8 m ₽−300,000 ₽10.5 m ₽2.35 m ₽below minimum
Week 56 m ₽10.5 m ₽−4.5 m ₽6 m ₽−2.3 m ₽negative
Week 65.5 m ₽9.2 m ₽−3.7 m ₽2.3 m ₽−5.6 m ₽negative
Week 75.5 m ₽300,000 ₽5.2 m ₽7.5 m ₽−1.4 m ₽negative
Week 86.5 m ₽11.5 m ₽−5 m ₽2.5 m ₽−7.95 m ₽negative
Week 97 m ₽300,000 ₽6.7 m ₽9.2 m ₽−2.4 m ₽negative
Week 108 m ₽7.4 m ₽600,000 ₽9.8 m ₽−3.5 m ₽negative
Week 118.5 m ₽5.5 m ₽3 m ₽12.8 m ₽−1.8 m ₽negative
Week 129 m ₽3.3 m ₽5.7 m ₽18.5 m ₽2.55 m ₽below minimum
Week 137 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.

Terms used

Calculate on your data →