MYOB's business reports are an excellent resource for summarising and analysing your sales and purchases data.
You can access the business reports via the Reporting menu > Reports > Business reports.
The reports and their functions are listed below.
Available reports are based on your plan
If there's a report listed below that you need, sign into My Account > Manage my product to upgrade your plan.
Business performance
Profit & Loss
Paired with your budget, Profit and loss gives you the ability to compare your performance against your budget targets or last year's totals. You can even analyse your data in a bar or line graph.
If you have more than one MYOB business, you can produce a consolidated Profit and loss. Just click Consolidate , choose the businesses to consolidate then click Consolidate .
For more information, see Analyse your profit or loss.
Cash movement
The Cash movement report shows the movement of your money over a specified period. It's a useful tool for monitoring how your cash position has changed over time. How much profit did you earn? And where was your cash spent?
The Cash movement report is found with your other Business reports (Reporting > Reports).
Since the cash movement report tracks your income and expenses over time, you need to select a period.
Once choosing your period, you have heaps of customisation options at your disposal, including:
Choosing what level of detail (i.e. category header level) to display.
Comparing earnings to last year's total or to your budget.
Choosing your accounting method, whether you want to show figures as whole dollars or cents, how you want to display negative values, and more.
If you have more than one MYOB business, you can produce a consolidated Cash movement. Just click Consolidate, choose the businesses to consolidate then click Consolidate.
After something more visual? Choose to display your cash movement report as a bar or line graph, and compare totals from different categories.
Budget management
Use budgets to plan, set goals, make decisions and monitor the health of your business. A budget can identify the areas in your business that are going better or worse than expected. Preparing a budget is critical to cash flow planning and keeping an eye on expenditure.
For all the details see Working with budgets.
Balance sheets
Balance sheet
The Balance sheet displays a snapshot of your asset, liability and equity category balances on a particular date. Regardless of whether you are on a cash or accrual basis the balance sheet will show the category balances as of the specified date.
If you want to show your balance sheet as at a different date, select a new date range.
Choose the category levels to show to display totals based on the hierarchy of your categories.
If you'd like to see how your business is going compared to last year, select the Compare to last year option. This compares the period you've chosen in the date range to the corresponding period in the last financial year.
You can also choose other display options by clicking Report options and selecting your required options
If you want to see all transactions that make up an category’s balance, click the amount next to that category.
If you want, you can click the link in the Reference no column for a transaction to view or edit the original transaction. When you’re done making changes to the transaction, click Save to take you back to the report which will be updated with any changes you’ve made.
If you have more than one MYOB business, you can produce a consolidated balance sheet report. Just click Consolidate, choose the businesses to consolidate then click Consolidate.
Trial balance
The Trial Balance displays the activity of each account in the form of debits and credits for a specified month, and also for the period from the beginning of the financial year up to that month.
Click the Trial balance report from the Reports page.
Choose the period to report on.
Click Report options for additional filters.
GST
GST report
The GST report displays detailed information about your business's GST liability (how much GST you've collected and paid). This information is used when you lodge your BAS or GST Return.
In the Business reports section of the Reports page, click GST report report.
Filter the report as required:
Set a date range
Choose the tax codes and/or contacts to include in the report
Choose the accounting method
Click Report options for additional filters.
If you want to view or edit the details of a particular transaction, click on its reference number to open the original transaction in a new browser tab.
GST return
Use the GST return report to help you manually complete your Business Activity Statement (BAS) at the end of each period (Australia) or the GST Return (New Zealand). Choose the dates you need to include, then copy the values from the report into the BAS form you send to the ATO or GST Return you file with the IRD.
Only transactions which incur GST will be listed.
The GST return report contains summary information - for detailed information about the GST collected and paid for each of your GST codes, refer to the GST report.
In the Business reports section of the Reports page, click GST return report.
Filter the report as required:
Set a date range
Choose the accounting method
(Australia only) select whether to calculate the Monthly PAYG Withholding (W1 and W2 fields)
Click Report options for additional filters.
The report automatically refreshes based on whatever filter or report options you choose. The Total column indicates if you might need to record a payment to the ATO or IRD or receive a refund from them, based on the report settings.
Transactions
General ledger
The General ledger report lists all the transactions that have been applied to a category for a specified period.
Go to the Reporting menu and choose Reports .
Click to open the General ledger report.
Filter the report as required:
Set a period to view
Choose the categories to include
Select an Accounting method:
Cash to calculate the values on the report as at the dates that money was received or paid
Accrual to calculate values as at the dates that invoices or bills were issued.
Click Report options for additional filters.
View details of a journal.
Click the dropdown arrow for a displayed category to view its transactions.
Click a transaction's Balance amount to see its details in a new browser tab.
Journal entries
The Journals report displays a list of all your transactions as journal entries.
Go to the Reporting menu and choose Reports .
Click to open the Journals report.
Filter the report as required:
Set a date range
Choose the categories and/or source transactions to include
Click Report options for additional filters.
View details of a journal.
Click the dropdown arrow to view the affected categories.
Click an amount to view details of the transaction in a new browser tab.
Categories (Chart of accounts)
Categories list
The Categories list report shows all or selected accounts, along with their balances as at a specific date.
Go to the Reporting menu and choose Reports .
Click to open the Categories list report.
Filter the report as required:
Set a period to view
Choose the category levels to show
Choose the tax codes and/or categories to include
Click Report options for additional filters.
View details of a journal.
Click the balance of a category to view its transactions.
Click a transaction's reference number to see its details in a new browser tab.
Categories transactions
This report displays all transactions assigned to the selected categories during the specified period.
Go to the Reporting menu and choose Reports.
Click to open the Categories transactions report.
Filter the report as required:
Set a period to view
Choose the accounting method
Click Report options for additional filters.
View details of a journal.
Click the dropdown arrow for a category to view its transactions.
Click a transaction's reference number to see its details in a new browser tab.
Contact details and balances
Contacts report
The Contacts report lists your customers, suppliers and personal contacts, along with their contact details and current balance.
Go to the Reporting menu and choose Reports .
Click to open the Contacts report.
Filter the report as required:
Choose one or more contacts to view.
Choose the type of contact you want to view
Click Report options for additional filters.
Security
Journal security audit
This report displays the changes made to transactions in a selected session. You can see what was added, edited and deleted.
Go to the Reporting menu and choose Reports .
Click to open the Journal security audit report.
Filter the report as required:
Choose the session period to view.
Choose the transaction period you want to view
Click Report options for additional filters.
View details of a journal.
Click the dropdown arrow next to each row to see a detailed journal entry describing the change.
Click an ID No to see its details in a new browser tab.
Taxable payments
Taxable payments annual report (Australia only)
Use the Taxable payments annual report to find the information required when reporting your taxable payments to the ATO. For more information about reporting payments and which payments you need to report, see Reportable contractor payments.
Exporting, saving and printing
You can export your report as an Excel spreadsheet or PDF by clicking Export. Note that you must enable editing of the spreadsheet from within Excel. If editing is disabled, the spreadsheet will not display the totals calculated in the report.
When exporting PDFs, you can also choose which style template you want to use. When the PDF displays, you can save it.
When viewing a report, click View and print to display the report as a PDF in a new browser tab, where you can save or print it.