Search
Close this search box.

Cash flow

Simple Cash Flow Tool

In this blog, I am going to share a cash flow spreadsheet that I use in my business. This is my very “simple cash flow tool”. It’s not a forecast per se (but could be made into one), rather, it’s a reality check tool for your business, that tells you exactly how much you have to spend, as opposed to how much you think you have to spend!

We’ve all looked at our bank balance when it’s healthy and started having visions of new clothes, holidays and nights out etc. However, as business owners, we also know that we have business (and personal) costs that must be paid for before any of those enticing dollars can find their way into our pockets. Below is a list of those costs included in the spreadsheet. You may have different costs or extra ones – feel free to amend the list to suit your needs.

  • General expenses (operating costs)
  • Wages, superannuation and PAYG withholding
  • GST
  • PAYG income tax and/or previous years’ income tax repayments
  • Loans and credit card payments
  • Previous’ month/quarter BAS
  • Your own sundry spending (your drawings or director loan amounts)

How does the spreadsheet/tool work?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”. Before you begin using the tool, it is a good idea to choose your focus period. Of course, you can change the period type later as needed, but to begin the process, just choose one period of interest.

In summary, the spreadsheet 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. Here is an example of what section one looks like – the cells highlighted in green show your available balance:

You could decide to transfer some funds to savings, pay down debt, buy something special, give employees a bonus, buy new equipment – the choice is yours. While this information about available funds is extremely useful, our tool goes a step further!

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. Note the difference between the result in section one and that of section two in our example above! The true cash flow figure is less than half of the available funds as at the end of the focus period. This is often the case because section two takes all future cash transactions into account, whereas the figure in section one only looks at the here and now. 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.

I suggest running this cash flow tool on a regular basis to assist you in controlling and understanding your business finances. If you need assistance to use this tool or would like us to prepare it for you, please get in touch to discuss.

Getting started with the cash flow tool

Open the spreadsheet which is shared below. There are 3 tabs in the spreadsheet. The first tab of the spreadsheet is an example of how the tool works and includes notes and instructions. The second tab is a single-period cash flow to look at one focus period only e.g. one week, one month etc. The third tab is a multi-period tool that allows you to look at several periods at once. Follow the instructions provided in the first tab and then enter the figures as required into either the single or multi-period tab.

I hope you find this spreadsheet tool useful. Let me know if you have any questions about it or have some suggestions about how to improve it, by leaving your comments below.


Like it? Share it!

Simple Cash Flow Tool Read More »

The “Boosting Cash Flow for Employers” payment (PAYGW Boost Credit)

As part of the economic stimulus triggered by the Corona Virus pandemic, the Federal Government has introduced the “Boosting Cash flow for Employers” measure or as we like to call it, the PAYGW Boost Credit. This measure promises to “refund” the PAYG withholding reported on the BAS or IAS by employers back into their integrated client accounts (ICA) as an offset against any existing BAS/IAS debt. To be clear, this is not a supply of cash to employers into their banks. This is simply crediting PAYGW back into the ICA to effectively reduce BAS/IAS debt. The only time an employer will see any cash is when a refund is created because the PAYGW credit is more than the whole activity statement debt. So who gets these payments, how much do they get and how do they get it? Read on to find out!


WHO IS ELIGIBLE?

Businesses will be eligible for this stimulus measure if they:

  • Held an ABN on 12 March 2020 and continue to be active
  • Are a small or medium business including NFP, sole trader, partnership, company and trust entities.
  • Have an aggregated turnover under $50M
  • Have made payments from which they have been required to withhold (even if this a zero amount). Such payments may include salary and wages, director’s fees, eligible termination payments, compensation payments and withholding from contractor fees.
  • Have made GST taxable, GST free or input taxed sales in a previous tax period since 1 July 2018 and lodged a relevant BAS on or before 12 March 2020.

HOW MUCH IS PAID?

PAYG withholding amounts will be credited back to the integrated client account (ICA) of between $20K and $50K. These credits are not income and as such will not be taxed. The do not have to be repaid ever. The good thing is that the PAYG withholding you report on your BAS will still be tax deductible. Note, if you have a tax debt on your ICA, the credit boost amount will simply pay down that debt.


HOW IS IT PAID?

These credits will be applied in two stages to integrated client accounts after 28th April 2020 and after the March 2020 quarter or monthly BAS is lodged. You do not have to apply for this measure, AND you do not receive any actual cash – this is credit only, not cash paid to your bank. The second stage credit will be applied in quarter 1 of 2020-21.


HOW DO THE PAYMENTS WORK?

Put simply, there are 2 payment stages for this measure. The first stage is a payment of up to $50K based on the amount of PAYGW reported on the March 2020 BAS. Examples below:

Quarterly Lodgers

If your March 2020 BAS shows a PAYGW amount of $12,000, this amount will be credited back to your ICA. In your June 2020 BAS, if a $14,000 PAYGW is reported, then this will also be sent back to the ICA. So far, a total of $26,000 has been credited. This is the first stage amount. The second stage amount will be the same as the first one i.e. $26,000 and will be credited to your ICA split evenly across June to September 2020.

Monthly Lodgers

If your March 2020 BAS shows a PAYGW amount of $12,000, this amount is multiplied by 3 (to take up amounts for January and February 2020) to give you a credit of $36,000. April, May and June 2020 BAS’s will continue to be lodged which may or may not total more than $50K. For this example, let’s say April was $10,000, May was $8,000 and June was $6,000. This will be a total PAYGW of $60,000. As the first stage payable can be no more than $50K, then $50K is all that will be credited to your ICA. The second stage payment will also be $50K.

What if my PAYGW is less than $10K or zero in my March 2020 BAS?

In this case, you will be credited $10K in the first stage of credits and another $10K in the second stage for a total of $20K.

PAYGW Boost Credit Calculator

Here is a great calculator to assist you to work out how much your PAYGW boost credit might be: https://digit.business/payg-cashflow-boost-calculator-advanced


Like it? Share it!

The “Boosting Cash Flow for Employers” payment (PAYGW Boost Credit) Read More »

The bookkeeping behind an asset purchase via a Chattel Mortgage

It is very common for businesses to purchase major assets such as motor vehicles via a loan. They can use a commercial bank loan but often finance is “purchased” by way of either Hire Purchase or a Chattel Mortgage. In this week’s blog we will look at a purchase via Chattel Mortgage agreement and how to post it to the accounts.

Chattel Mortgage

A Chattel Mortgage is a type of loan typically used to purchase motor vehicles or other major business equipment. It is called a “mortgage” because the financier retains the title of the item purchased until the final payment is received. There are several financial benefits of a Chattel Mortgage including:

Like it? Share it!

The bookkeeping behind an asset purchase via a Chattel Mortgage Read More »

5 ways to improve your cash flow

The number one things that kills most businesses is poor cash flow. Lack of money basically means that your business will struggle to function and if this continues, may even mean you have to close the doors. Luckily there are ways to improve cash flow issues. Read on to find out about 5 ways you can improve your cash flow.

Like it? Share it!

5 ways to improve your cash flow Read More »

Scroll to Top