Cash flow statement template (Excel)
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
Excel (.xlsx), 12 months, example data in euros
Free, no sign-up, no email address.
How to use the template
The template has one sheet for the statement and one with notes. The blue cells are inputs, everything else is a formula. Replace the example figures with your own, month by month, and leave the formula cells alone.
Start at the top with profit after tax for each month, from your profit and loss account. Then add back depreciation, because it is a cost that does not cost cash. Next come the changes in working capital: receivables, stock, payables and other short-term debts such as VAT and payroll taxes.
The signs follow the cash. When receivables go up, customers owe you more and that cash is not in the bank yet, so an increase is a negative number. When payables go up, you have not paid suppliers yet, so an increase is a positive number. The notes sheet lists every line with its sign.
Investing and financing
Investments in equipment, software or a vehicle go under investing activities as a negative amount, sales of assets as a positive one. Financing covers new loans and repayments, capital paid in by shareholders and dividends paid out.
The template adds the three parts to the net cash flow of the month. Opening cash plus net cash flow is closing cash, and each month opens with the previous month's closing balance. Check the closing balance against your bank statements at the end of every month. When they differ, a line is missing or has the wrong sign.
Reading the result
A profitable month can still cost cash. The most common reasons are customers paying later, stock building up and a large investment paid in one go. The statement shows which one it is, so you can act on the cause and not only on the bank balance.
Use the statement for the months behind you. To look ahead, use the 13-week cash flow forecast template, which works from expected receipts and payments.
Frequently asked questions
What is the difference between the direct and the indirect method?
The direct method lists actual receipts and payments. The indirect method starts from profit and corrects for everything that is not cash, such as depreciation and changes in working capital. Annual accounts usually use the indirect method, which is what this template does.
Why is an increase in receivables negative?
Because the revenue is in your profit, but the cash is not in the bank yet. The statement corrects your profit for cash that has not arrived.
Does the template work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The formulas and formats carry over.
Is the template free?
Yes. No sign-up and no email address. Download it and use it as you like.
More free tools
- Month-end close checklist
- DSO calculator
- Dutch statutory interest and collection costs calculator
- Liquidity and solvency ratio calculator
- UK late payment interest calculator
- 13-week cash flow forecast template (Excel)
- Management report template (Excel)
- Month-end close checklist (Excel template)
- UK management accounts template (Excel)
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.
