Payment calendar
One row per payment: date, payee, basis, type, priority, amount, status and how many days it can be deferred.
What the template is for
Daily payment management and finding a cash gap.
- What one row is
- one row = a payment
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Payment date | date | Date | yes | date YYYY-MM-DD |
| Payee (code) | payee | Text | yes | a value from the counterparty reference |
| Basis (invoice, payroll sheet) | basis | Text | yes | not empty |
| Type | type | List value | yes | supplier, payroll, tax, rent, loan or customs |
| Priority | priority | Integer | yes | 1 mandatory, 2 important, 3 can be deferred |
| Amount | amount | Number | yes | a number not below 0 |
| Currency | cur | List value | yes | an ISO 4217 currency code |
| Status | status | List value | yes | planned, approved or paid |
| Days it can be deferred | flex | Integer | yes | an integer not below 0; 0 for taxes, payroll and loans |
Example rows
| Payment date | Payee (code) | Basis (invoice, payroll sheet) | Type | Priority | Amount | Currency | Status | Days it can be deferred |
|---|---|---|---|---|---|---|---|---|
| 2027-03-05 | S01 | PO-1042 | supplier | 2 | 1,850,000 | RUB | approved | 5 |
| 2027-03-05 | STAFF | PAY-0305 | payroll | 1 | 3,900,000 | RUB | planned | 0 |
| 2027-03-10 | TAX | VAT-Q4 | tax | 1 | 1,260,000 | RUB | planned | 0 |
| 2027-03-15 | LL01 | RENT-03 | rent | 2 | 1,600,000 | RUB | planned | 3 |
| 2027-03-20 | BANK01 | LOAN-77 | loan | 1 | 800,000 | RUB | planned | 0 |
The example data is illustrative: an exercise, replace it with your own.
Note
Take tax and contribution dates from the tax calendar for the year; the example does not set them. In a gap, first move priority 3 payments with a positive deferral. The example data is illustrative: an exercise, not a norm or an industry benchmark.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- The 13-week cash plan: balance, gap and stress
- Cost of payment terms, deductions and factoring
- A payment to a foreign supplier: full cost, timing and exchange-rate risk
- Covenant check: headroom to breach and EBITDA −X%
- Customer credit limit and wholesale receivables aging
- Profit versus cash: where the difference went
- Early-payment discount: annual rate
- Overdraft, factoring or inventory loan: which is cheaper
Documents that need this data
- Payment calendar: priorities and cash gap
- Treasury: credit lines, overdraft, factoring, letters of credit, covenants
- Commercial terms: payment terms, retro bonuses, MDF and listing fees, SLA penalties, chargebacks
- The “72 hours” crisis route: money, sales, stock, suppliers, team
- The unified tax account and the tax calendar: the unified payment, notifications, balance, penalties, the payment calendar of a brand and a retailer
- Financial mathematics: time value, NPV, IRR, MIRR, annuity, leasing and currency
- The platform sales report and reconciliation of deductions: how to read the report, reconcile with brand records and file claims
- Scenarios and risk: tornado, season Monte Carlo, cash gap probability, VaR-lite, stress tests