Page tree

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's sales reports help you keep track of your sales information, including what you've sold and who you've sold to.

You can access the sales reports via the Reporting menu > Reports > Sales reports. The reports and their functions are listed below. 

  • Unpaid invoices—displays the payments due from each customer, within a range of dates by which they are due.
  • Customer sales —displays a list of invoices for a certain period and shows the amount, amount due and status for each.
  • Customer sales (detail)—displays a detailed list of sales transactions, organised by customer.
  • Customer transactions—displays a detailed list of sales transactions, organised by customer.
  • Deposit transactions (orders)—AccountRight browser users only—displays a list of sales orders and purchase orders for which a deposit payment has been made.
  • Item sales—displays sales data for each of your items.
  • Items—displays a list of all the items you sell, along with price and the relevant account.

All of these reports are available in the Sales reports section of the Reports page (Go to Reporting > Reports tab > Sales reports).

Image Added

UI Text Box
sizemedium
typenote

Available reports are based on your plan If there's a report listed here that you need, go to My Account to upgrade your plan (click your business name > My Account > Manage my product).

UI Expand
titleTo run an unpaid invoices report

To run an unpaid invoices report

  1. Go to the Reporting menu and choose Reports.
  2. Click to open the Unpaid invoices report. The Unpaid Invoices report appears, where you can customise and produce the report.
  3. Choose:
    • the Period you want the report to cover (you can also change the As at date to narrow the report period)
    • the Ageing method to display invoice ageing based on either the date the invoice was issued or the days invoices are overdue (based on invoice terms)
    • Customer from the list, or leave it as All to include all customers.
  4. If you want to customise the report further, click Report options or Customise for filtering and sorting options. For general information about customising reports, see Customising reports.

Exporting

You can export the report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use.

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
expandedtrue
titleTo run a customer sales report

To run a

customer

sales report

  1. Go to the Reporting menu  menu and choose Reports.
  2. Click to open the Customer sales report. The Customer sales report appears, where you can customise and produce the report.
  3. Choose:
    • the Period you want the report to cover (you can also change the From and to date range to narrow the report period)
    • the Sale status, such as whether to show only open invoices
    • Customer from the list, or leave it as All to include all customers
    • any Employees to show salespersons associated with sales.
  4. If you want to customise the report further, click Report options or Customise for filtering and sorting options. For general information about customising reports, see Customising reports.

Exporting

You can export the report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use.

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
titleTo run a customer sales (detail) report

To run a customer sales (detail) report

  1. Go to the Reporting menu and choose Reports.
  2. Click to open the Customer sales (detail) report. The Customer sales report page appears, where you can customise and produce the report.
  3. Choose:
    • the Period you want the report to cover (you can also change the From and to date range to narrow the report period)
    • the Sale status, such as whether to show only open invoices
    • Customer from the list, or leave it as All to include all customers
    • any Employees to show salespersons associated with sales.
  4. If you want to customise the report further, click Report options or Customise for filtering and sorting options. For general information about customising reports, see Customising reports.

Exporting

You can export the report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use.

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
titleTo run a deposit transactions (orders) report

To run a deposit transactions (orders) report

This report is currently only available if you're accessing AccountRight in a web browser.

  1. Go to the Reporting menu and choose Reports.
  2. Click to open the Deposit transactions (orders) report. The Deposit transactions (orders) report appears, where you can customise and produce the report.
  3. Choose the Period you want the report to cover (you can also change the From and to date range to narrow the report period).
  4. If you want to customise the report further, click Report options or Customise for filtering and sorting options. For general information about customising reports, see Customising reports.

Exporting

You can export the report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use.

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
titleTo run an item sales report

To run an item sales report

  1. Go to the Reporting menu and choose Reports.
  2. Click to open the Items sales report. The Item sales report appears, where you can customise and produce the report.
  3. Choose the Period you want the report to cover (you can also change the From and to date range to narrow the report period).
  4. Choose other filtering options, such as:
    • the Sale status, such as whether to show only open invoices
    • any Employees to show salespersons associated with sales
    • details of Transactions, such as transaction numbers or amounts
    •  a customer from the Customers list, or leave it as All to include all customers
    • any or all of your Items.
  5. the Sales tab.
  6. Click a report to run it.
  7. Choose your report filters and Report options across the top—these might vary depending on the report you're running.
    As you change these filters, the report will update automatically.
  8. If you want to customise the report further, click Report options or Customise for more filtering and sorting options. For general information about customising reports, see Customising reports.

Exporting

You can export the report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use.

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
titleTo run an items report

To run an items report

  1. Go to the Reporting menu and choose Reports.
  2. Click to open the Items report. The Items report appears, where you can customise and produce the report.
  3. Select a Customer from the list, or leave it as All to include all customers.
  4. If you want to report on data for a range of dates, enter the range in the Date Issued and To fields.
  5. If you want to customise the report further, click Report options or Customise for more filtering and sorting options

    for example to select and reorder columns, click Customise. For general information about customising reports, see Customising reports.

Exporting

You can export the report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use.

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.

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

Reporting

Sales

Customising reports