/
Sales invoice reporting (UK only)

Sales invoice reporting (UK only)

This guide has been reviewed against our global client base and classed as relevant to UK only

This article outlines how to run a salesĀ invoicing report, including how to export the report to Excel

1. Access the sales invoice report criteria screen

From the main menu

  • ClickĀ Reports, clickĀ MI AnalysisĀ and selectĀ Invoice Reports
    The Sales Invoice Reporting screen is displayed

  • At the top of the screen, ensure the correct Report Criteria option is chosen - Live Properties is automatically selected

  • Use the links toĀ specify criteria for your report, such as:

    • Beside Dates, click Date Range to select dates to report on
      Defaults to report on the invoice date, click Invoice drop down menu for options to report on invoice Due or Created dates

    • Beside Status, click Select one or more status to report on invoice status (e.g. Raised)

    • Beside Property Office, click Select one or more office to narrow down by office

  • As well as invoices, you can also report on credit notes, payments and/or returned payments, beside Type, click Invoice and select required items to report on

  • When your criteria is set up, clickĀ Run Report

2. Invoice list

The invoices included in the report are shown in a grid

  • Select an entry in the grid to display more details of the offer in the panels below

  • Click a grid column heading to sort the data by that column or click to the right of the heading to group or filter the list

  • Right-click an entry for further options, see above

  • Double-click an entry to show details of the invoice in a non-editable window

3. Export to Excel

The invoices report can be exported to Excel in various formats

From the screen shown above:

Related articles



Related content

Sales invoicing (UK only)
Sales invoicing (UK only)
Read with this
Sales invoice report available in Sage compatible format (UK only)
Sales invoice report available in Sage compatible format (UK only)
More like this
Knowledge Base index
Knowledge Base index
Read with this
Updates to works order reporting & grids to allow reporting on supplier invoices - configuration option
Updates to works order reporting & grids to allow reporting on supplier invoices - configuration option
More like this
Accounts
Read with this
Mark works orders as 'invoice not required'
Mark works orders as 'invoice not required'
More like this