While MYOB can produce one cash basis report as shown below, it does not provide the ability to produce a true cash (from Cash Disbursements and Cash Receipts) by excluding non-cash transactions from general journals and sales journals.
What can be done ?
ExcelReportLink GL Pivot Solutionprovides the ability to create Profit and Loss and Balance Sheet reports on a true cash basis (Cash CR DR). Not only this, but it also allows you to filter that data by many dimensions.
How does it work ?
During the get data process, ExcelReportLink GL Pivot Solution downloads your accounting data (MYOB, QuickBooks, Reckon Accounts, Xero) to databases and analyses it. This data is then included in Excel using it’s inbuilt Pivot Tables to produce all manner of transaction reports.
The Cash Cr Dr versions is available for:
- MYOB AccountRight Classic (MYOB Accounting, Accounting Plus and Premier);
This feature is included in ExcelReportLink GL Pivot Pro Edition