Cash Flow Analysis

The Cash Flow Analysis page, sometimes referred to as Cashflow Waterfall, gives you a visual representation of where cash is going within a business. You can see the money coming in, and where each part of this is used, contributing to the closing balance as of your chosen date.

Please note that this page is only available for individual entity reports - it is not available for consolidated reports.

Note: When importing data from MYOB or Sage 50 Accounts, please be aware that due to a limitation in the Cash data available from these accounting systems the 'Cash' option may show incorrect values. It's recommended that you use the 'Accrual' option for these data sources.

To add the Cash Flow Analysis page

The page is included in most standard templates, but if it doesn’t appear in yours, you can easily add it.

  1. From the Customise Layout tab, click Add Page.
  2. From the Page Type screen, choose Cash Flow Analysis.
  3. If required, in the Page Name box, enter a new name to use for the page.
  4. From the Insert After drop-down list, choose the page after which you want to place the new one.
  5. To add the page, click Save.

To edit the Cash Flow Analysis page

  1. From the Customise Layout tab, locate the Cash Flow Analysis page and click Customise.
  2. From the Data section, choose if you want your report to be based on Accrual or Cash data.
  3. If required, to show rows where there is no data in the selected period, select the Show zero value rows check box.
  4. In the Period section, select the date range you want to use. By default, this page shows all values for the current financial year, up to and including the report date.
  5. To apply your changes, click Update.

Information included in the Cash Flow Analysis

Revenue

Formula: Trading Revenue

Report codes used: REV.TRA

The trading revenue for the months included in the date range.

Cost of Sales

Formula: Cost of Sales

Report codes used: EXP.COS

The cost of sales for the months included in the date range.

Overheads

Formula: Expenses - Cost of Sales - Amortisation - Depreciation - Tax

Report codes used: EXP, EXP.COS, EXP.AMO, EXP.DEP, EXP.TAX

Expenses for the months included in the date range, excluding amortisation, depreciation, tax and dividends.

Other Income

Formula: Other Revenue + Investment Revenue

Report codes used: REV.OTH, REV.INV

Any income recorded as other revenue or investment revenue for the months included in the date range.

Change in Accounts Receivable

Formula: (Accounts Receivable last month - Prepayments last month) - (Accounts Receivable current month - Prepayments current month)

Report codes used: ASS.CUR.REC, ASS.CUR.REC.PRE

The movement in Accounts Receivable over the period for which you run the report.  For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Change in Inventory

Formula: Inventory last month - Inventory this month

Report codes used: ASS.CUR.INY

The movement in inventory over the period for which you run the report. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Change in Other Current Assets

Formula: (Current Assets last month - Bank last month - Inventory last month - (Accounts Receivable last month - Prepayments last month) - (Current Assets this month - Bank this month - Inventory this month - (Accounts Receivable this month - Prepayments this month)

Report codes used: ASS.CUR, ASS.CUR.BAN, ASS.CUR.INY, ASS.CUR.REC, ASS.CUR.REC.PRE

The movement in current assets over the period for which you run the report, excluding bank, inventory and accounts receivable. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Changes in Accounts Payable

Formula: (Accounts Payable last month - Employee entitlements last month) - (Accounts Payable current month - Employee entitlements current month)

Report codes used: LIA.CUR.PAY, LIA.CUR.PAY.EMP

The movement in Accounts Payable over the period for which you run the report, excluding employee entitlements.  For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Changes in Taxes

Formula: Tax liability this month - Tax liability last month - Tax expense over the period

Report codes used: LIA.CUR.TAX, EXP.TAX

Any movement in tax liability or expenses over the period for which you run the report.

Changes in Other Current Liabilities

Formula: (Current liabilities this month - Accounts payable this month - Employee entitlements this month - Tax liability this month) - (Current liabilities last month - Accounts Payable last month - Employee entitlements last month - Tax liability last month)

Report codes used: LIA.CUR, LIA.CUR.PAY, LIA.CUR.PAY.EMP, LIA.CUR.TAX

Any movement in current liabilities over the period for which you run the report, excluding accounts payable, employee entitlements and tax liability. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Operating Cashflow

The total of the previous rows.

Changes in Fixed Assets

Formula: Fixed assets last month - Fixed assets this month - Depreciation

Report codes used: ASS.NCA.FIX, EXP.DEP

Any movement in fixed assets over the period for which you run the report, minus any depreciation expense. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Changes in Other Non-Current Assets

Formula: (Non-current assets last month - Fixed Assets last month) - (Non-current assets this month - Fixed assets this month)

Report codes used: ASS.NCA, ASS.NCA.FIX

Any movement in non-current assets over the period for which you run the report, excluding fixed assets. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Changes in Non-Current Liabilities

Formula: Non-current liabilities this month - Non-current liabilities last month.

Report codes used: LIA.NCL

Any movement in non-current liabilities over the period for which you run the report. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Dividends

Formula: Dividends paid this month - Dividends paid last month

Report codes used: EQU.RET.DIV

Any movement in dividends paid over the period for which you run the report. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Change in Equity

Formula: (Equity this month - Retained Earnings this month) - (Equity last month - Retained Earnings last month)

Report codes used: EQU, EQU.RET

Any movement in equity over the period for which you run the report. For the purposes of this calculation 'last month' is the month before the 'From Date' used and 'current month' is the 'To Date' used.

Net Cash Flow

The total of the previous rows.


Still need help?
Get in touch!