Skip to content

Business reports

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.

Watch this video to see the features of some key 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, go to My Account to upgrade your plan (click your business name > My Account > Manage my product).

Budget management

AddAdd

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 sheet

AddAdd

The Balance sheet displays a snapshot of your asset, liability and equity account balances on a particular date. Regardless of whether you are on a cash or accrual basis the balance sheet will show the account 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 account levels to show to display totals based on your accounts hierarchy.

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 account’s balance, click the amount next to that account.

If you've upgraded from MYOB Essentials, you may notice fewer transactions making up account balances. This is because in the new MYOB, account balances in the Balance sheet are only made up of reconciled transactions, or transactions that have been entered manually, whereas the report in MYOB Essentials included unreconciled transactions. This change is to ensure that account balances are based on transactions that have been checked for accuracy.  

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

AddAdd

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.

  1. Click the Trial balance report from the Reports page.

  2. Choose the period to report on.

  3. Click Report options for additional filters.

Profit & Loss

AddAdd

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

AddAdd

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. account 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.

GST report

AddAdd

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.

  1. In the Business reports section of the Reports page, click GST report report.

  2. 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

  3. Click Report options for additional filters.

  4. 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

AddAdd

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.

  1. In the Business reports section of the Reports page, click GST return report.

  2. 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)

  3. 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.

General ledger

AddAdd

The General ledger report lists all the transactions that have been applied to an account for a specified period. 

  1. Go to the Reporting menu and choose Reports .

  2. Click to open the General ledger report.

  3. Filter the report as required:

    • Set a period to view

    • Choose the accounts to include

  4. 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.

  5. Click Report options for additional filters.

  6. View details of a journal.

    1. Click the dropdown  arrow for a displayed account to view its transactions.

    2. Click a transaction's Balance amount to see its details in a new browser tab.

Journal entries

AddAdd

The Journals report displays a list of all your transactions as journal entries. 

  1. Go to the Reporting menu and choose Reports .

  2. Click to open the Journals report.

  3. Filter the report as required:

    • Set a date range

    • Choose the accounts and/or source transactions to include

  4. Click Report options for additional filters.

  5. View details of a journal.

    • Click the dropdown  arrow to view the affected accounts.

    • Click an amount to view details of the transaction in a new browser tab.

Accounts list

AddAdd

The Accounts list report shows all or selected accounts, along with their balances as at a specific date. 

  1. Go to the Reporting menu and choose Reports .

  2. Click to open the Accounts list report.

  3. Filter the report as required:

    • Set a period to view

    • Choose the account levels to show

    • Choose the tax codes and/or accounts to include

  4. Click Report options for additional filters.

  5. View details of a journal.

    • Click the balance of an account to view its transactions.

    • Click a transaction's reference number to see its details in a new browser tab.

Account transactions

AddAdd

This report displays all transactions assigned to the selected accounts during the specified period.

  1. Go to the Reporting menu and choose Reports .

  2. Click to open the Account transactions report.

  3. Filter the report as required:

    • Set a period to view

    • Choose the accounting method

  4. Click Report options for additional filters.

  5. View details of a journal.

    • Click the dropdown arrow for an account to view its transactions.

    • Click a transaction's reference number to see its details in a new browser tab.

Contacts

AddAdd

The Contacts report lists all or selected contacts, along with their contact details and current balance. 

  1. Go to the Reporting menu and choose Reports .

  2. Click to open the Contacts report.

  3. Filter the report as required:

    • Choose one or more contacts to view.

    • Choose the type of contact you want to view

  4. Click Report options for additional filters.

Journal security audit

AddAdd

This report displays the changes made to transactions in a selected session. You can see what was added, edited and deleted.

  1. Go to the Reporting menu and choose Reports .

  2. Click to open the Journal security audit report.

  3. Filter the report as required:

    • Choose the session period to view.

    • Choose the transaction period you want to view

  4. Click Report options for additional filters.

  5. 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 annual report (Australia only)

AddAdd

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.