Cash flow by month (direct method)
One row per month: opening cash, receipts, payments by line and closing cash.
What the template is for
Plan and actual cash movement, preparation for a cash gap.
- What one row is
- one row = a month
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Month | month | Text | yes | month as YYYY-MM |
| Opening cash, thousand | open | Number | yes | a number not below 0 |
| Receipts from customers, thousand | inCust | Number | yes | a number not below 0 |
| Other receipts, thousand | inOther | Number | yes | a number not below 0 |
| Payments to suppliers, thousand | outSupp | Number | yes | a number not below 0 |
| Payroll and contributions, thousand | outPay | Number | yes | a number not below 0 |
| Taxes, thousand | outTax | Number | yes | a number not below 0 |
| Rent and other operating, thousand | outOther | Number | yes | a number not below 0 |
| Investment (CAPEX), thousand | outCapex | Number | yes | a number not below 0 |
| Loan and interest repayment, thousand | outDebt | Number | yes | a number not below 0 |
| Closing cash, thousand | close | Number | yes | calculated: opening + receipts − all payments |
Example rows
| Month | Opening cash, thousand | Receipts from customers, thousand | Other receipts, thousand | Payments to suppliers, thousand | Payroll and contributions, thousand | Taxes, thousand | Rent and other operating, thousand | Investment (CAPEX), thousand | Loan and interest repayment, thousand | Closing cash, thousand |
|---|---|---|---|---|---|---|---|---|---|---|
| 2027-01 | 4,200 | 21,500 | 300 | 9,800 | 3,900 | 2,100 | 1,600 | 700 | 0 | 7,900 |
| 2027-02 | 7,900 | 18,900 | 0 | 12,400 | 3,900 | 1,500 | 1,600 | 0 | 800 | 6,600 |
| 2027-03 | 6,600 | 24,700 | 150 | 15,200 | 3,900 | 3,300 | 1,600 | 2,400 | 800 | 4,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
- Monthly cash flow and cash gap
- The 13-week cash plan: balance, gap and stress
- Profit versus cash: where the difference went
- Covenant check: headroom to breach and EBITDA −X%
- Runway: how many months the cash lasts
- Plan scenarios: base, optimistic, pessimistic
- Overdraft, factoring or inventory loan: which is cheaper
- Loan: payment schedule, overpayment and the effective rate
Documents that need this data
- Cash flow statement: direct and indirect method
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Treasury: credit lines, overdraft, factoring, letters of credit, covenants
- Business lending: bank products, a pledge of goods in circulation, a limit and an overdraft, what the bank looks at and how to prepare an application
- Capital: WACC, ROIC, dividends and reinvestment
- The 365-day strategy and the hypothesis register: prioritization, a plan by area and defense before the owner and the bank
- 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 financial audit of a brand: P&L, profit bridge, loss map and checklist
- Financial model (FinModel): sheets, links, checks, scenarios
- Label launch: from an idea to the first sales — stages, documents, calculations in order and readiness criteria