Syntha Lab RU

Payment calendar

One row per payment: date, payee, basis, type, priority, amount, status and how many days it can be deferred.

Layouts for documents 9 columns 5 example rows

Download CSV ↓

What the template is for

Daily payment management and finding a cash gap.

What one row is
one row = a payment

Columns

ColumnCodeTypeRequiredValidation rule
Payment datedateDateyesdate YYYY-MM-DD
Payee (code)payeeTextyesa value from the counterparty reference
Basis (invoice, payroll sheet)basisTextyesnot empty
TypetypeList valueyessupplier, payroll, tax, rent, loan or customs
PrioritypriorityIntegeryes1 mandatory, 2 important, 3 can be deferred
AmountamountNumberyesa number not below 0
CurrencycurList valueyesan ISO 4217 currency code
StatusstatusList valueyesplanned, approved or paid
Days it can be deferredflexIntegeryesan integer not below 0; 0 for taxes, payroll and loans

Example rows

Payment datePayee (code)Basis (invoice, payroll sheet)TypePriorityAmountCurrencyStatusDays it can be deferred
2027-03-05S01PO-1042supplier21,850,000RUBapproved5
2027-03-05STAFFPAY-0305payroll13,900,000RUBplanned0
2027-03-10TAXVAT-Q4tax11,260,000RUBplanned0
2027-03-15LL01RENT-03rent21,600,000RUBplanned3
2027-03-20BANK01LOAN-77loan1800,000RUBplanned0

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

Documents that need this data

Download CSV ↓ Open interactively →