U.S. Bank research found that 82% of small business failures are caused by cash flow problems — not lack of customers, not bad products, just money arriving too late to cover expenses. This Cash Flow shows you exactly when money comes in and when it goes out.

What’s inside this Cash Flow template

• Weekly cash in and cash out — see the real movement of money, not just profit on paper
• 30, 60, and 90-day forward forecast — know what your bank balance will be before it happens
• Accounts receivable tracker — outstanding invoices listed by due date so nothing is forgotten
• Accounts payable tracker — upcoming supplier payments planned against available cash

How to use this Cash Flow template

1. Click above to get your free cash flow template.
2. Save a copy via File → Make a copy.
3. Enter your current bank balance as the opening position.
4. Add all expected income for the next 90 days — invoices due, recurring revenue, one-offs.
5. Add all expected outgoings — supplier payments, wages, rent, subscriptions — by due date.
6. Review the forward forecast each Friday and update any changes to expected dates or amounts.

Why Google Sheets for Cash Flow?

For businesses turning over under €1M, the complexity of dedicated cash flow software rarely justifies the cost. This template covers 95% of what those tools do, for free, with the added benefit that you understand every formula because you can see it.

Frequently asked questions

What is the difference between cash flow and profit?

Profit is revenue minus costs on paper. Cash flow is the actual money in your account. A business can be profitable but cash-flow negative if customers pay late — this template tracks the cash, not the paper profit.

How accurate will my forecast be?

As accurate as the assumptions you put in. The template includes a variance column so you can compare forecast to actual each week and improve the accuracy of future predictions over time.

Can I track multiple bank accounts?

Yes. Add a row per account and a consolidation row that sums them. The total cash position row reflects all accounts combined.