Entering values in MAS to produce a Cash Flow Statement

This support note applies to:

AE Reporter (AU)

Article ID: 36550

In MYOB Accountants Enterprise (AE) Management Accounting System (MAS) you enter values to record the transactions and the change in value of accounts in regard to the business. Using MYOB AE Reporter you can then produce a Cash Flow Report to show the relevant balances and movement in relation to cash transactions.

For the transactions from the MAS ledger to correctly show in the Cash Flow Statement, you need to enter them as cash transactions. Only transactions entered as Bank Statements, Payments, Receipts or Cash Journals appear on the Cash Flow Statement.

Transactions entered as Journals and not indicated as Cash Journals do not appear on the Cash Flow Statement report in AE Reporter.

To include the Cash Flow Statement in your report you also need to set the required Non-Transaction Data item/s in #EntityDetails.ReportingExtraDetails.

If you have used Non-Cash Journals for your transactions, to show the correct values on the Cash Flow Statement, enter the required values in Non-Transaction Data and specify the source of the Cash Flow data to be the Database.

To include the Cash Flow Statement

Open the MAS ledger and follow the menu path: Reports > Reporter > Generate Reports. The Reporter window opens.
Click Non-transaction data. The Non-transaction data appears in the right-hand pane.
Navigate to #EntityDetails.ReportingExtraDetails. The fields appear in the right-hand pane.
Click the drop-down arrow on CashFlowReport and select Yes. The CashFlowReport is selected to be included and the focus moves to the CashFlowDatabase field.

To specify the Cash Flow Statement source

Click the drop-down arrow on CashFlowDatabase and select the required option:
Yes - Source of transactions is the MAS ledger. Cash transactions only.
No - Source of transactions is the Non-Transaction data CashFlow folder. The option is selected.
Click Apply. The Non-Transaction data is saved.

To enter Cash Flow Non-Transaction data

Expand the CashFlow folder in the left-hand pane. The CashFlow tables appear.
Click the required CashFlow table. The table fields appear in the right-hand pane.
Enter the required values against the fields in each table and click Apply. The Non-Transaction data is saved.
Note: To show the data from the Non-transaction data in the Cash Flow Statement, set the #EntityDetails.ReportingExtraDetails.CashFlowDatabase to Yes.