How do I print a Cash Flow Statement?

The accounts detailed below are based on the MYOB Standard Chart of Accounts. The report and accompanying note have been prepared on a GST-inclusive basis. The Cash Flow Statement (report 400) and related note (2020 CASHFLOW) are included in the following templates:

• 10 Sole Trader (Livestock)

• 10 Sole Trader Template

• 12 Partnership (Livestock)

• 12 Partnership Template

• 15 Small Co. (Livestock)

• 15 Small Co. Template

• 18 Trust Template

• 18 Trust Template (Livestock)

• 23 Large Company

To generate the correct figures, you must have values for the previous years' closing balance. For example, if you create a new ledger and enter opening balances for the current year (for example, 2007), you need to ensure that:

• you have entered the closing balances for the previous year (2006)

• previous year (2006) opening balances correspond to the closing balances for the year before (2005).

Reconciliation of Cash Flow from Operating Activities with Profit from Ordinary Activities after Income Tax

1. To separate the GST collected on asset sales from GST collected on other sales, enter the following journal:

   Account	Description	DR	CR
   993/99	Cash Flow Stmt clearing account	XXXX
   993/24	GST Output adjustments		XXXX

2. To separate the GST paid on asset purchases from GST paid on other purchases, enter the following journal:

   Account	Description	DR	CR
   993/23	GST Input adjustments	XXXX
   993/99	Cash Flow Stmt clearing account		XXXX

3. To re-allocate dividends received from Operating to Investing, enter the following journal:
   

   Account	Description	DR	CR
   993/34	Dividends Received - Operating adjustment	XXXX
   993/52	Dividends Received - Investing		XXXX

4. To re-allocate interest received from Operating to Investing, enter the following journal:

   Account	Description	DR	CR
   993/32	Interest Received - Operating adjustment	XXXX
   993/51	Interest Received - Investing		XXXX

5. To re-allocate finance costs paid from Operating to Investing or Financing, enter the following journal:

   Account	Description	DR	CR
   993/53	Finance Costs - Investing	XXXX
   993/79	Finance Costs - Financing	XXXX
   993/33	Finance Costs - Operating adjustment		XXXX

6. To record the proceeds of sale of assets, enter the following journal:

   Account	Description	DR	CR
   993/99	Cash Flow Stmt clearing account	XXXX
   993/43	Proceeds from sale of property		XXXX
   993/44	Proceeds of sale of plant & equipment		XXXX
   993/45	Proceeds from sale of investments		XXXX
   993/46	Proceeds from sale of goodwill		XXXX
   993/47	Proceeds from sale of patents & trademarks		XXXX

7. To record the payments for the acquisition of assets, enter the following journal:

   Account	Description	DR	CR
   993/56	Payments for property	XXXX
   993/57	Payments for plant & equipment	XXXX
   993/58	Payments for investments	XXXX
   993/59	Payments for goodwill	XXXX
   993/60	Payments for patents & trademarks	XXXX
   993/99	Cash Flow Stmt clearing account		XXXX

8. To record the loans made to and payments received from related parties, enter the following journal:

   Account	Description	DR	CR
   993/66	Loans to related parties - payments made	XXXX
   993/67	Loans to related parties - proceeds from repayments		XXXX
   993/99	Cash Flow Stmt clearing account	XXXX

9. To record the proceeds from issue of shares, enter the following journal:

   Account	Description	DR	CR
   993/99	Cash Flow Stmt clearing account	XXXX
   993/71	Proceeds from issue of shares		XXXX

10. To record the receipts from borrowings and payments made, enter the following journal:

    Account	Description	DR	CR
    993/75	Repayments of Borrowings	XXXX
    993/74	Proceeds from Borrowings		XXXX
    993/99	Cash Flow Stmt clearing account	XXXX

11. To record the amount of dividends paid, enter the following journal:

    Account	Description	DR	CR
    993/85	Dividends paid	XXXX
    993/99	Cash Flow Stmt clearing account		XXXX

12. To record Net Cash Flow from Operating Activities, enter the following journal:

    Account	Description	DR	CR
    993/85	Dividends paid	XXXX
    993/99	Cash Flow Stmt clearing account		XXXX