Payment calendar: priorities and cash gap
A weekly schedule of payments and receipts that shows in advance on which day cash will fall short and which payments can move. It drives decisions on who is paid today and who next week, what can wait without penalties, and when to ask the bank for an overdraft or a deferral.
Why this document
A cash gap does not happen on average over a year but on one particular Tuesday, when payroll, tax and a factory payment coincide. The calendar shows that day in advance, so there is time to agree terms with a supplier or the bank instead of borrowing in panic. The treasurer sets priorities: tax and payroll first, supplier deferrals last. The owner sees what the safety cushion costs. Without a calendar a business that is profitable on paper misses payments.
At a glance
- What is this document and why is it needed?
- A weekly schedule of payments and receipts that shows in advance on which day cash will fall short and which payments can move. It drives decisions on who is paid today and who next week, what can wait without penalties, and when to ask the bank for an overdraft or a deferral.
- Who owns the document and how often is it rebuilt?
- The treasurer or finance director; updated daily or weekly, a horizon of 4 to 13 weeks; agreed with the commercial director (suppliers) and the owner (priorities, deferrals).
- What mistakes are the most common?
- The calendar is built on accruals, not on payment dates → the gap is invisible → use payment and settlement dates. Receipts are taken from the contract → overestimated → use the customer actual payment term. No priorities → whoever shouts loudest is paid → approve an order in advance and agree it with the owner.
For whom
- Brand
- A brand builds the calendar around prepayments to factories, payments for fabric and customs: amounts are large and terms tight, while wholesale receipts come with a deferral. In Model B in the second quarter receipts are 60,504, payments 59,399, capex and loan 10,880: closing cash -3,500, a gap of 3,500. Moving priority 4 payments closes 3,500 of it.
- Retail
- A retailer builds the calendar around payments to brands and rent: receipts are daily (till, acquiring), payments follow a schedule. In Model R in the third quarter receipts are 155,758, payments 151,240, capex 9,150: balance -15,898, a gap of 15,898. After moving capex 6,748 remains: this is 8 days of supplier deferral or an overdraft.
What it consists of
Calendar contents
- Scale: days or weeks 4 to 13 weeks ahead; rows: opening cash, receipts, payments by priority, closing cash, cash gap.
- The payment register: every request with date, amount, counterparty, contract, priority, status (approved, paid, moved) and the date up to which it can be moved without penalty.
- Brand: The register of expected receipts: wholesale shipments with payment terms, settlements with platforms and acquiring, supplier refunds.
Payment priorities
- Priority 1 (not moved): payroll and taxes, contributions, loan interest and covenants. A delay brings fines, account blocking and criminal risks for taxes and payroll.
- Priority 2: critical suppliers (goods for the season, factories on prepayment, carriers, customs), rent of key stores; decided by the commercial director.
- Priority 3: marketing, IT, other contractors: can be moved by weeks but lower the season effect.
- Priority 4: capex, dividends, early repayment: moved first.
Cash gap
- A gap is not a loss but the moment when the balance is negative. It is closed in this order: moving priority 4, shifting priority 3, agreeing a supplier deferral, accelerating receivables, and only then an overdraft, factoring or a line.
- Then decide by cost of money: compare the price of deferral, overdraft and factoring (the “Treasury” document).
Payment register and the weekly schedule
- Payment register columns: payment date, counterparty, line, contract, amount including VAT, priority (1 payroll and taxes, 2 rent and mandatory items, 3 goods suppliers, 4 capex and loan), status (planned, approved, paid), owner, the date to which it can be moved, penalty for moving. The register is the source of the calendar: a calendar without a register is not updated.
- The weekly schedule is built from the register: priority rows, week columns; week balance = previous balance + receipts − payments by priority from the top. The quarterly example above shows the priority logic, while the weekly schedule is needed because a gap lives for 1 to 2 weeks and a quarterly total hides it.
- Tax payment date rule: if the due date falls on a day off, the payment moves to the next business day (a Tax Code rule, not checked against the text), but in the calendar put the payment on the last business day before the due date so as not to depend on the bank and on days off.
Brand and retailer: what is computed differently
- Brand: the largest payments are the factory prepayment and customs 3 to 9 months before the sale, while receipts come with wholesale deferral and platform reports; the calendar is built from the date the factory order is paid.
- Retailer: the main payments are rent, store payroll and payment to brands with a deferral; receipts are almost daily (till and acquiring), so the weeks before the season and the rent date are critical.
Brand: how the document differs and what to add
- Brand: the brand calendar is built around payments to factories: an advance at order, the balance before shipment or after acceptance, foreign-currency payments on specific dates.
- Brand: wholesale receipts are planned from the shipment schedule and partner payment terms (45 days in the model): a customer slipping a week slips the calendar.
- Brand: marketplace payouts arrive on the platform reporting cycle: the calendar is tied to the payout date, not the sale date.
- Brand: import: duties, import VAT, broker and freight are paid before the goods are released; they are placed in the calendar by arrival date, not supplier payment date.
- Brand: first-priority payments (payroll, taxes, interest) are protected: the factory is paid from what remains, but the date is moved only by agreement with the supplier.
- Brand: the calendar includes advertising and blogger payments by campaign schedule: at the season launch they leave before revenue.
- Brand: export receipts in foreign currency and currency control requirements are tracked in a separate line: crediting dates can be later than shipment dates.
- Brand: loan payments and dividends are placed in the calendar only after checking the minimum balance in the next two quarters.
Retailer: how the document differs and what to add
- Retailer: the retailer calendar is built around rent (by contract dates), payroll (advance and final pay) and supplier deferrals (60 days in the model).
- Retailer: receipts are daily: tills and acquiring on the next banking day, marketplace payments once a period; therefore the calendar is weekly.
- Retailer: supplier payments are grouped by week taking the deferral into account; weekly peaks on the payment days of large suppliers are smoothed by negotiation.
- Retailer: rent payments grow with indexation and the turnover part: the percentage is computed from the sales report and paid with a lag.
- Retailer: at the seasonal peak refit payments are set after the peak, and the balance before the season is left for deliveries.
- Retailer: tax payments (VAT, corporate income tax, property) follow deadlines and form a large monthly hump; the tax calendar is updated every quarter.
- Retailer: loyalty program and gift card payments are planned from past usage intensity, not the issued nominal.
- Retailer: the retailer credit schedule and overdraft include seasonal repayment early in the year: interest is higher and the payment larger just in the weakest months.
How to read the result and which decisions follow
- The balance is below the buffer in any of the next 13 weeks: there are three options in order of cost: a payment shift by agreement, a supplier deferral, a credit line; the loan is sized to the need at the peak (brand 8,000, retailer RUB 29 million), not to the current gap.
- First-priority payments exceed the week’s receipts: the finance director decides on the day of preparation, not the treasurer after the fact; underpaying tax and payroll is not used as a source.
- Actual receipts lag the forecast by more than a week twice in a row: revisit assumptions about customer terms and shipment limits, not only the calendar.
Control checks
- The calendar by quarter gives the same closing cash as the cash flow (brand 14,351, retailer RUB 1.766 million). The gap to zero (3,500 and 15,898) and the shortfall to the buffer (7,617 and 28,259) are different quantities: the peak need of 8,000 and 29,000 is the shortfall to the buffer at the weakest balance, rounded up to a thousand.
- The payment register holds only approved payments with a date and priority; an undated payment is not in the total but is visible in the risk list.
- Typical traps: payment VAT counted now with, now without tax, one payment in two weeks, a foreign-currency contract payment without a rate, a customer refund treated as a supplier expense.
Where the data comes from
| Data source | Fields |
|---|---|
| Bank statements, account balances, overdraft limits | balance, available limit, restrictions |
| Purchase orders register and payment schedules | delivery date, amount, prepayment, deferral |
| Shipment plan and wholesale receivables | shipment date, payment term, customer limit, overdue |
| Calendar of taxes, payroll and rent | dates and amounts of mandatory payments |
| Weekly sales forecast | revenue by channel, card and cash share, settlement days |
How to build it step by step
- Step 1: Set the horizon (13 weeks) and the step (a week; a day in tough periods).
- Step 2: Take the balance on accounts and overdraft limits today; exclude restricted cash.
- Step 3: Build receipts: retail from the sales forecast and settlement days; wholesale from shipments and payment terms adjusted for historical delays.
- Step 4: Enter mandatory priority 1 payments on their dates.
- Step 5: Enter supplier payments under contracts and orders, stating the “latest date without penalty”.
- Step 6: Add priority 3 and 4 expenses and capex.
- Step 7: Compute the closing balance for each week and find the first negative week.
- Step 8: Close the gap in order: moving, deferral, faster collection, external funding; record the decision and date.
- Step 9: Every week compare actuals and forecast and shift the window: the horizon is always 13 weeks.
- Step 10: Report to the owner: the minimum balance, date, size of the gap, the decision; agree cancellation of dividends if there is a threat.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Closing balance | Balance_t = Balance_(t−1) + Receipts_t − Payments_t | Payments sum over all priorities; take taxes with VAT and on their due dates. |
| Cash gap (to zero) | Gap_t = max(0; −Balance_t) | How much cash is missing so that the balance does not fall below zero: this is the line closed by moving payments; in the example the brand has 3,500 and the retailer 15,898. |
| Shortfall to the buffer | Shortfall_t = max(0; Buffer − Balance_t) | A buffer, for example 30 days of fixed costs; zero gives risk after a small slip. The size of the line is taken from the shortfall to the buffer at the weakest balance (7,617 for the brand, rounded up to a thousand it gives a need of 8,000), not from the gap to zero. |
| Supplier deferral equivalent | Days = Gap ÷ (Supplier payments in the period ÷ Days in the period) | Shows by how many days to move payment of all suppliers or which part of the large ones. |
| Expected wholesale receipt | Receipt = Amount × (1 − Overdue share) on the due date + Overdue with a lag | Take the lag and share from customer history, not from the contract. |
| Weekly balance | Balance_w = Balance_(w−1) + Receipts_w − Σ Payments_w (priorities 1…4 in order); minimum = min(Balance_w) | The actual of the week replaces the plan in the next week; funding need = Buffer − minimum. |
Formulas in notation
- Period balance
Close_t = Open_t + Rec_t − Pay_t
Open_t is the opening balance, Rec_t is receipts, Pay_t is payments of period t.- Receipt lag
Rec_t = Σ_k Sales_(t−l_k) · w_k
Sales of channel k arrive with lag l_k (weeks of wholesale deferral, days of acquiring) and share w_k.- Buffer
Buf = (Payroll + Rent + G&A) / 12
Fixed costs for 30 days: the minimum cash below which the calendar is considered breached.- Funding need
Need = ⌈(Buf − min_t Close_t) / 1000⌉ · 1000
min_t Close_t is the minimum balance in the calendar; the result is rounded up to a thousand to choose the line size.
Worked example
Payment calendar by priority in the weakest quarter: the second for the brand, the third for the retailer, RUB thousand
| Step | Brand, Q2 | Retailer, Q3 |
|---|---|---|
| Opening cash of the quarter | 6,275 | −11,266 |
| + Receipts from customers | 60,504 | 155,758 |
| Priority 1: payroll, taxes, interest | −14,347 | −32,389 |
| Cash after priority 1 | 52,432 | 112,103 |
| Priority 2: goods and material suppliers | −30,707 | −82,722 |
| Cash after priority 2 | 21,725 | 29,381 |
| Priority 3: rent, marketing, logistics, other | −14,345 | −36,129 |
| Cash after priority 3 | 7,380 | −6,748 |
| Priority 4: capex, loan repayment, dividends | −10,880 | −9,150 |
| Closing cash of the quarter | −3,500 | −15,898 |
| Cash gap to zero: max(0; −balance) | 3,500 | 15,898 |
| Shortfall to the 30-day buffer: max(0; buffer − balance) | 7,617 | 28,259 |
| Can be moved out of priority 4 | 3,500 | 9,150 |
| Shortfall after moving | 0 | 6,748 |
| Supplier deferral needed, days (for the remaining shortfall) | 0 | 8 |
Payments are made from the top down by priority while cash lasts. For the brand the balance turns negative only at priority 4 (capex and loan), so moving them is enough; for the retailer the balance after priority 2 is still positive, the minus appears after priority 3 (rent, marketing, logistics) and priority 4 deepens it into the gap, because cash went in earlier quarters into pre-season purchases: 6,748 remains after moving, which is 8 days of supplier deferral or an overdraft. A quarterly calendar is coarser than a weekly one: in practice it is broken down by weeks and matched against payment dates.
Figures
- Priority 1: payroll, taxes, interest
- Goods suppliers
- Other operating
- Investing and financing
Data as a table
| Measure | Priority 1: payroll, taxes, interest | Goods suppliers | Other operating | Investing and financing |
|---|---|---|---|---|
| Q1 | 14,347 | 33,069 | 13,771 | 0 |
| Q2 | 14,347 | 30,707 | 14,345 | 10,880 |
| Q3 | 14,347 | 28,344 | 14,345 | 0 |
| Q4 | 14,345 | 25,982 | 14,918 | 6,000 |
Brand payments by priority and quarter. First-priority payments (payroll, taxes, interest) run evenly while suppliers, expenses and investments create the seasonal hump.
- Brand
- Retailer
Data as a table
| Measure | Brand | Retailer |
|---|---|---|
| Buffer: 30 days of fixed costs | 4,117 | 12,361 |
| In-year minimum balance | −3,500 | −15,898 |
| Need at the peak | 8,000 | 29,000 |
Buffer, minimum balance and funding need. A minimum balance below the fixed-cost buffer sets the need: the line is opened before the peak, not at the moment of the gap.
Specifics by category
- Apparel
- Apparel: two payment peaks (pre-season purchases, customs) and a receipts peak after the season starts; the calendar is built backwards from the collection launch date.
- Footwear
- Footwear: prepayment to the factory is larger and earlier (tooling, lasts), production takes longer; the payment peak moves 1 to 2 months earlier than apparel.
- Accessories
- Accessories: smaller, steadier payments, part of purchases in small batches; the calendar is simpler.
- Kids
- Kids: payment peaks before school and winter; certification and labeling come before shipment and fall into priority 2.
- Men
- Menswear: steady payments, fewer seasonal spikes; you can plan beyond 13 weeks.
- Women
- Womenswear: frequent re-supplies and drops give many small payments and unpredictable peaks; daily control is needed in season.
Common mistakes
- The calendar is built on accruals, not on payment dates → the gap is invisible → use payment and settlement dates.
- Receipts are taken from the contract → overestimated → use the customer actual payment term.
- No priorities → whoever shouts loudest is paid → approve an order in advance and agree it with the owner.
- Taxes and payroll enter the calendar late → fines and blocking → enter them first.
- The balance is computed without a buffer → any delay gives a gap → include a buffer.
- One person keeps the calendar in a spreadsheet → no versions or accountability → a single request register and owners.
Russian specifics
- Tax and contribution due dates and the consequences of delay are set by the Tax Code; in the calendar priority 1 always goes to them. VAT is paid after the quarter in parts; check the exact procedure in the current edition. Rule: Tax Code Art. 171: Tax Code, Art. 171 (VAT deductions) (rule check not completed).
- For late payment under a supply contract a penalty and interest apply under the Civil Code; fix the terms in the contract, and when moving a payment arrange an additional agreement. Rule: Civil Code part 1: Civil Code, part one (including Arts. 330, 424) (rule check not completed).
- Wages are paid at least every half month (Art. 136 of the Labor Code); liability for delay and indexation should be checked with a lawyer. This norm is not in the register: not verified.