Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

MYOB Essentials’ Business reports is an excellent resource for summarising and analysing your sales and purchases data.

The Business reports, located under Reports > All reports, vary in function and use. For details on each report, see the list below.

Getting an error when running reports? Try using a different web browser like Google Chrome or Mozilla Firefox

UI Text Box
sizemedium
typenote

Dealing with month-end tasks? While you’re running reports, you may also want to have a look at our suggested month-end tasks.

UI Expand
titleBudget Management

Budget Management

New to Essentials, Budget Management is where you can build, edit and view your business's budgets. For more information on budgets, see Prepare a budget.

Or, if you're looking for information on importing CSV files into your budget, see Working with CSV budget files

UI Expand
titleTrial Balance

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.

  1. Go to the Business reports section of the Reports page.
  2. Click Trial Balance. The Trial Balance page appears, where you can customise and produce the report.
  3. Select a Month from the list.
  4. Enter a year in the Financial Year Ending field.
  5. Select the Show whole dollars option if you want to display amounts on the report rounded to the nearest dollar.
  6. Click Generate report. The report appears as a PDF in an Adobe Reader window, ready for you to review, save or print.
UI Expand
titleProfit & Loss

Profit & Loss

Paired with your budget, Profit & 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.

For more information, see Analyse your profit or loss

UI Expand
titleCash flow

Cash flow

The Cash flow report shows the movement of your money over specified period of time. 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 flow report is found with your other Business reports (Reports > All reports > Cash flow).

Since the cash flow report tracks your income and expenses over time, you need to select a From and To date. Or, you can choose from a list of default time frames, such as This Month or This Financial Year, from the Period dropdown menu.

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

After something more visual? Choose to display your cash flow report as a bar or line graph, and compare totals from different categories.

When you're ready to take your report on the go, you can export it as an Excel file or PDF.

UI Expand
titleBalance sheet

Balance sheet

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. 

UI Text Box
sizemedium
typenote

What about cash basis?

MYOB Essentials can't produce a cash-based Balance Sheet. All balance sheets are typically accrual-based and MYOB Essentials caters for this.

If you need to find the balance of one or more accounts as at a set date on a cash basis, run the General ledger details report (Reports > All reports > General ledger details), click Report options and choose the Cash option.

 The Balance Sheet report is found by clicking Balance Sheet in the Reports dropdown list.

If you want to show your balance sheet as at a different date, select a new date in the As at field.

You can also choose display options by clicking Report options and selecting your required options

  • Show amounts in whole dollars or in cents.
  • Show or hide account numbers

If you want to see all transactions that make up an account’s balance, click the amount next to that account. A list of transactions appears in a Detail view.

If you want, you can click the link in the Ref 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 Balance Sheet report. Otherwise, click the Balance Sheet link at the top of the page to return to the Balance Sheet report. The report will be automatically updated with any changes you’ve made.

Exporting

You can export a Balance Sheet report as an Excel spreadsheet or PDF from the Export dropdown list.

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.

UI Expand
titleGST report for Activity Statement (Australia only)

GST report for Activity Statement (Australia only)

Use GST report for Activity Statement to help you manually complete your Business Activity Statement (BAS) at the end of each period. Choose the dates your BAS needs to include, then copy the values from the report into the BAS form you send to the ATO.

  1. In the Business reports section of the Reports page, click GST report for Activity Statement. The GST Report page appears in a new window, where you can customise and produce the report.
  2. Choose the period to produce the report for in the Dated and To fields.
  3. If you want the values on the report to be calculated as at the dates that money was received, select the Cash basis option. If you want values calculated as at the dates that invoices or bills were issued (that is, on an accrual basis), deselect this option.
  4. Click Generate report. The report appears as a PDF in an Adobe Reader window, ready for you to review, save or print.

    UI Text Box
    sizemedium
    typenote

     Only transactions which incur GST will be listed.

UI Expand
titleGST detailed report

GST detailed report

The GST detailed report displays detailed information that you can use to prepare your BAS or GST return. 

  1. In the Business reports section of the Reports page, click GST detailed report. The GST detailed report page appears, displaying the report.
  2. If you want to change the range of dates included in the report, select your new dates in the From and To fields, then click Update. The report is updated on-screen.
  3. Click the Report options link at the top of the page to set your report options.
    1. Choose whether to include transactions in this report as at the dates that money was received or paid (cash basis) or as at the dates that invoices or bills were issued (accrual basis). To change the basis, click change.
    2. Choose whether to sort the report by Date or Account.
  4. If you want to view or edit the details of a particular transaction, click on its reference number to open the original transaction. When you save your changes, you’ll be returned to the GST detailed report. Or, when you’re done viewing the transaction, you can click the GST Report link at the top of the page to return to the GST detailed report.
  5. If you want to export the report as an Excel spreadsheet, click the XLS icon. A window appears, allowing you to save or open the file. Note that you might need to enable editing of the spreadsheet from within Excel before you can view it properly. If editing is disabled, the spreadsheet may not display the totals calculated in the report.
  6. To print the report, click the PDF icon. The report appears as a PDF in a new window, where you can save or print it.

    UI Text Box
    sizemedium
    typenote

     Only transactions which incur GST will be listed.

UI Expand
titleGST report (New Zealand only)

GST report (New Zealand only)

The New Zealand-only GST report displays a summary or detailed information that you can use to prepare your GST return.

  1. In the Business reports section of the Reports page, click GST Report. The GST Reports page appears in a new window, where you can customise and produce the report.
  2. Choose a GST report type from the Choose Report list:
    • GST Report (Summary)
    • GST Return (IRD form)
    UI Text Box
    sizemedium
    typenote
    Don't send this report to the IRD. Instead, copy the amounts from this report onto the GST return form supplied by the IRD.
  3. (Optional) If you report GST on a cash basis, select the Cash basis option.

  4. Follow the steps for the report type you selected:

    For this report...Do this...

    GST Report (Detailed)

    or

    GST Report (Summary)

    Select the appropriate GST reporting period in the Dated and To fields.
    GST Return (IRD Form)
    1. Select the appropriate GST Reporting Period from the list.
    2. Select the appropriate Report End Date from the list.
  5. Click Generate report.

    The report appears as a PDF in an Adobe Reader window, ready for you to review, save or print.

    Only transactions which incur GST will be listed.

UI Expand
titleGST & provisional tax filing (New Zealand only)

GST & provisional tax filing (New Zealand only)

GST & provisional tax filing makes it easy to lodge your GST return online from within MYOB Essentials.

Essentials will automatically complete your GST return for you, using the data you've entered throughout the period. You'll be able to check it, and make changes if you need to. Once you're happy with the figures, you can lodge the return with Inland Revenue.

See Lodge your GST return online (New Zealand) for more information.

UI Expand
titleJournals

Journals

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

  1. Go to the Business reports section of the Reports page.
  2. Click Journals. The Journal Report page appears, where you can customise and produce the report.
  3. Enter a Transaction Date range in the From and To fields.
  4. Click Generate report. The report appears as a PDF in an Adobe Reader window, ready for you to review, save or print.
UI Expand
titleAccounts

Accounts

Accounts lists all or selected accounts, along with their balances as at a specific date. 

  1. Go to the Business reports section of the Reports page.
  2. Click Accounts. The Account List Report page appears, where you can customise and produce the report.
  3. If you want to report account balances from a different date to the one displayed, enter a new date in the Balance As At field, using the standard date format.

    UI Text Box
    sizemedium
    typenote

    If you make an error, MYOB Essentials will display a warning message describing the error and suggesting how to correct it.

  4. Select any or all of the following options to display them on the report.
    • Inactive Accounts
    • Show $0.00 Balances
  5. Click Generate report. The report appears as a PDF in an Adobe Reader window, ready for you to review, save or print.
UI Expand
titleContacts

Contacts

Contacts lists all or selected contacts, along with their phone and email details. 

  1. Go to the Business reports section of the Reports page.
  2. Click Contacts. The Contact List Report page appears, where you can customise and produce the report.
  3. Select a Contact Type from the list (or, to include all contacts, select All).
  4. Select the Inactive Contacts option if you want to include inactive contacts in the report.
  5. Click Generate report. The report appears as a PDF in an Adobe Reader window, ready for you to review, save or print.
UI Expand
titleGeneral Ledger Details

General Ledger Details

General Ledger details lists all the transactions that have been applied to an account for a specified period. 

  1. Go to the Business reports section of the Reports page.
  2. Click General Ledger Details. The General ledger details report page appears, displaying the report details.
  3. If you want, filter the report to show the information you need:
    • change the date range in the From and To fields to filter the report by date.
    • click Select Accounts and choose which accounts you want to include in the report. This selection will be retained when you next open this report. Update the report with your selections by clicking Hide Accounts.
  4. This report can be shown on an Accruals basis or a Cash basis. You can see which basis is currently being used in the Showing field at the top right of the page. You can change the basis by clicking change. Choose Cash to calculate the values on the report as at the dates that money was received or paid. Choose Accruals to calculate values as at the dates that invoices or bills were issued.
  5. If you want, click on a transaction to view the original transaction, including individual line items in split transactions. You can only view transactions that have a link in the Ref No column. When you’re done, you can click the GL link at the top of the page to return to the General Ledger Details report.
  6. If you want to export the report as an Excel spreadsheet, click the XLS icon. A window appears, allowing you to save or open the file. 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.
  7. To print the report, click the PDF icon. The report appears as a PDF in a new window, where you can save or print it.
UI Expand
titleTaxable payments annual report (Australia only)

Taxable payments annual report (Australia only)

UI Text Box
sizemedium
typenote

 This report is only available if you have selected the Taxable payments reporting option on the My business details page.

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

  1. Go to the Business reports section of the Reports page.
  2. Click Taxable payments annual report. The Taxable payments annual report page appears, displaying all reportable transactions for each supplier, along with the total for each supplier.
  3. Click Next and complete the details on the next page to produce an electronic version of the report you can lodge online with the ATO.

For more details about producing this report, see Producing the Taxable payments annual report.

UI Text Box
sizemedium
typenote

Looking for a report that isn't in Essentials? MYOB Essentials is made for smaller businesses with simple reporting needs, although we'll be adding more reporting. To see what reports others are asking for, including those under consideration for development, check out the community forum Ideas Exchange.

HTML
<p>
<a href="http://myob.com.au/business/training-events/training-courses-pricing/course-details/get-going-with-myob-essentials-1410160685961" alt="Book MYOB training now" target="_blank"><img src="http://help.myob.com.au/images/trainingad/classroom2.png" width="50%" height="auto"></a>
</a></p> 
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namemagenta
titleRelated topics
HTML Wrap
classsidebarlinks

Reports

Lodge your GST return online (New Zealand)

Banking reports

Payroll reports

Sales reports

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=business+reports&filter=labels%2Clocation&location=forum-board%3AEssentialsAccounting&search_type=thread

HTML Wrap
classmorelinks
More »