What is the difference between "Actual" and "Plan"?

Actual means completed transactions; plan means future payments and receipts. In the settings, choose what to show: actual, plan, or actual together with plan.

It is a month that ends with a negative cash balance. The spreadsheet highlights such months in red.

Do I need to enter transfers between accounts?

No. They do not change the total balance and are not entered in the report.

Does the spreadsheet replace accounting?

No. It is a management report: it helps you see how money moves but does not replace formal accounting statements.

No. The file works in Excel 2007 and later and in LibreOffice, and all calculations use ordinary formulas.

← All templates

Cash Flow Tracker and Cash Flow Statement — Excel Template

A log of money movements by account and category, a monthly cash flow statement, account balances, actual vs plan and cash gap highlighting.

≈ $6.09

490 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Profit on paper does not guarantee that there will be money in the account. A cash flow statement shows where money comes from and where it goes each month, and the plan helps you spot a cash gap in advance. You enter the transactions, and the spreadsheet builds the cash flow statement and balances for you.

What is inside

"Reference Data": accounts with opening balances for the year, receipt and payment categories, report year and mode.
"Transactions": up to 2500 transactions: date, account, kind, category, counterparty, amount, type "Actual" or "Plan".
"Cash Flow": receipts and payments by category and month, net cash flow, opening and closing balance, charts.
"Accounts": the balance of each account as of today.

Who it is for

Small businesses, sole traders, managers and finance managers, agencies and studios that need management-level cash tracking and a balance forecast without expensive software.

What you get

The download includes a blank template and a filled-in sample with fictitious data, so you can see how the formulas and checks work. It is an Excel spreadsheet with ordinary formulas, not an accounting program. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. The calculation is approximate and meant for management purposes.

📘 How to Create a Cash Flow Statement in Excel

Questions and answers

What is the difference between "Actual" and "Plan"?: Actual means completed transactions; plan means future payments and receipts. In the settings, choose what to show: actual, plan, or actual together with plan.
What is a cash gap?: It is a month that ends with a negative cash balance. The spreadsheet highlights such months in red.
Do I need to enter transfers between accounts?: No. They do not change the total balance and are not entered in the report.
Does the spreadsheet replace accounting?: No. It is a management report: it helps you see how money moves but does not replace formal accounting statements.
Do I need macros?: No. The file works in Excel 2007 and later and in LibreOffice, and all calculations use ordinary formulas.