
Annual Report
Docs + Word6 pages
FeaturedFree
This cash flow statement is for owners and managers who need to know where the money went, not just what profit was booked. The Opening tab holds the bank balance at the start of the period. The Cash movements tab logs each payment with its date, description, section and an amount that is positive for money in and negative for money out.
The Dashboard shows the opening balance, net cash from operations, investing and financing, and the cash at the end. A column chart compares money in and money out for each section. The sample period covers the first two weeks of November 2026 for a small food business, so overwrite them with your actual bank activity.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Opening tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Profit counts sales and costs when they are recorded, while cash flow counts money when it moves. A customer who owes you money adds to profit but not yet to cash. A loan received adds cash but is not profit. This sheet tracks the cash side.
The principal part of a repayment is financing, and the interest is usually operating. Splitting them takes a little care, so use the figures from your loan statement. Keeping them on separate rows makes the split easy to see.
It should, if every payment that cleared the bank is logged and the opening balance is correct. Compare the two figures at the end of each period. Any gap usually means a payment is missing or was logged on the wrong date.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free