Syntha Lab RU

Cash flow by month (direct method)

One row per month: opening cash, receipts, payments by line and closing cash.

Layouts for documents 11 columns 3 example rows

Download CSV ↓

What the template is for

Plan and actual cash movement, preparation for a cash gap.

What one row is
one row = a month

Columns

ColumnCodeTypeRequiredValidation rule
MonthmonthTextyesmonth as YYYY-MM
Opening cash, thousandopenNumberyesa number not below 0
Receipts from customers, thousandinCustNumberyesa number not below 0
Other receipts, thousandinOtherNumberyesa number not below 0
Payments to suppliers, thousandoutSuppNumberyesa number not below 0
Payroll and contributions, thousandoutPayNumberyesa number not below 0
Taxes, thousandoutTaxNumberyesa number not below 0
Rent and other operating, thousandoutOtherNumberyesa number not below 0
Investment (CAPEX), thousandoutCapexNumberyesa number not below 0
Loan and interest repayment, thousandoutDebtNumberyesa number not below 0
Closing cash, thousandcloseNumberyescalculated: opening + receipts − all payments

Example rows

MonthOpening cash, thousandReceipts from customers, thousandOther receipts, thousandPayments to suppliers, thousandPayroll and contributions, thousandTaxes, thousandRent and other operating, thousandInvestment (CAPEX), thousandLoan and interest repayment, thousandClosing cash, thousand
2027-014,20021,5003009,8003,9002,1001,60070007,900
2027-027,90018,900012,4003,9001,5001,60008006,600
2027-036,60024,70015015,2003,9003,3001,6002,4008004,250

The example data is illustrative: an exercise, replace it with your own.

Note

The opening cash of a month equals the closing cash of the previous one. If closing cash goes below zero it is a cash gap: show it on a separate line with the source of cover and do not understate payments. 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 →