This tool asks you to review a prior period such as last week, fortnight, month, quarter or year. For the purposes of the tool, we call these periods your “focus periods”. 

Our tool is split into two sections. The first section takes your opening bank balance at the start of your focus period, adds any income from sales, deducts your operating costs and deducts the required minimum bank balance (that amount you know you need to leave in the bank for running costs). The result provided is the balance available for spending or saving as at the end of the focus period i.e. how much you have at your disposal TODAY. The second section in the spreadsheet takes today’s available balance as above, then adds back any future income and deducts future bill or liability payments. The final result is called your “true cash flow figure“, and is a more accurate representation of your financial position.

Don’t get me wrong, knowing your available spending balance as of today is still necessary, however, in order to understand your true cash position, it is important to include all future spending/income. Doing this will ensure that you don’t inadvertently spend dollars that really should be saved for the long term.

Now that you can see your “true cash flow figure” you will be able to make a more informed decision about how much is really available for spending (or saving) today. Of course, if your figure is low or even negative, then perhaps you need to review your situation and work out why this is happening. Whatever the outcome, this tool will provide you with a snapshot of your overall financial position. One important aspect to note is that for this tool to work properly, your accounts need to be up to date. As a minimum, ensure that your bank accounts are reconciled up to the end of your focus period prior to using this tool.