Cash flow summary — free Excel template
A free cash flow summary: one row per period per account, with the opening balance, everything that came in, everything that went out, the net change and the closing balance. Download it, or parse a run of bank statements and let the totals fill themselves.
What’s inside the cash flow summary
The template is a single ready-to-use sheet with a frozen header row and one column per field. Its columns are:
- Period
- Account
- Opening balance
- Money in
- Money out
- Net change
- Closing balance
How to use this template
Two ways. Fill it in by hand as a plain spreadsheet — or, to skip the typing, upload your bank statements to ParseForMe, pick this template as your export format, and the parsed data lands in these columns automatically. Map the fields once and every future document reuses the layout.
Who it’s for
Owners and bookkeepers who want to see money in against money out month by month, without building a full statement of cash flows.
Frequently asked questions
Is the cash flow summary template free?
Yes — download the .xlsx and use it however you like. No signup is required just to download the template.
How do I fill it in automatically?
Upload your bank statements to ParseForMe, then choose this template as your export format. The fields ParseForMe extracts land in their matching columns, so you only type what the documents don’t say.
Can I change the columns?
Yes. Edit the spreadsheet freely. If you re-upload your edited version as your export template, ParseForMe maps the parsed fields to your columns.
Try it on your own document
Drop a document to see the structured data come back.