This basic spreadsheet demonstrates the figures and information you need to gather to analyse your cash flow. You can then apply that knowledge to whatever software or digital option you are using.
(Select image to view all sections of the cash flow canvas)
(Select image to view all sections of the cash flow canvas)
The information in this spreadsheet shows your cash flow position at any specific point in time and helps you plan towards improving it.
It can be used regularly and in many different ways such as providing a current snapshot of your cash flow; planning out your future cash flow position; testing whether changes you want to make to your business will improve your cash flow; and it can also be used to track whether you are meeting your cash flow targets.
The information recorded in this spreadsheet provides answers to the 4 key cash flow questions.
- What is my cash position?
- How much do I need to pay in tax and super commitments?
- How much does my business have available to spend? (Does my business have enough to spend on myself and others?)
- Has my business improved?
When the spreadsheet is completed you will have the figures you need to analyse your own business cash flow.
To really make the most of the information in this tool, or any cash flow software you have, gather your figures regularly, ideally as you do your regular record keeping. For example, a retail business may gather their figures at the end of each day, and do their record keeping daily and weekly. Contractors may gather their figures and do their record keeping weekly, fortnightly or monthly.
