Line item reports (Xero)

Line item reports (Xero)

You can generate reports with line item details and also schedule the report generation and delivery to selected email addresses.

Line item reports allow you to look deeper into your accounts payable and accounts receivable to understand what exactly your expenses are for.  For example, you’re now shown details of the items you ordered from a specific supplier and to which accounts they relate.

To access the line-item reporting feature, navigate to the main menu    in the upper left-hand corner and select "Line item reports" under your Organisation:


You can create your own report for any type of document in any status with filters that reflect your particular needs.

This is how you set up your own Xero line item report:

  1. Click on the button "NEW REPORT" on the "Line item reports" page:


  2. In step 1, select the request type for which you want to create a report and click on "NEXT":

  3. In step 2, specify the required report filters and then click on "NEXT":

  4. In step 3, activate the checkbox next to each column you want to be visible in the report and then click on "NEXT":



  5. In the last step, name your report by filling in the field "Report name":

    When finished, click on "CREATE".

The following options are available:

  • Rename the report
  • Export the report to a CSV file 
  • Print the report 
  • Schedule the report 
  • Remove the report
  • Copy the report (i.e., save it as a new report)
  • Edit the report
  • Sort the information in the columns (hover over the respective column and click on the arrow):

  • Move columns (via drag and drop):

To apply the choices you made for the report, click on the "SAVE" button.

Important note: reports are only available to users with the Administrator or Auditor role.
Learn more about how you can assign a new role to users here.

    • Related Articles

    • Line item reports (QuickBooks Online)

      You can generate reports with line item details and also schedule the report generation and delivery to selected email addresses. Line item reports allow you to look deeper into your accounts payable and accounts receivable to understand what exactly ...
    • Accrual report .CSV file for Xero Manual Journal entry

      In ApprovalMax, the Bill accrual feature allows users to generate collections of open Bills using the ApprovalMax filtering and reporting capability. The resulting .CSV file will be transferred to Xero via its capability for importing manual journal ...
    • Auto-selection of Taxes in ApprovalMax for Xero

      In Xero, you can set default Taxes for: Contacts Inventory items        Accounts in the chart of Accounts     ApprovalMax follows the same logic as Xero and applies your default Taxes for Bills, Invoices and AP/AR Credit Notes in the following order ...
    • Why are audit reports sometimes not attached to the Xero document?

      Xero does limit the amount of attached files — there can be no more than 10. If a Bill or Purchase Order that was created in Xero already has the allowed 10 attachments, ApprovalMax cannot add the audit report because this would exceed the stipulated ...
    • Are audit reports sent to the customer with the Sales Invoice?

      Xero has 2 types of attachments for Sales Invoices: Those to be sent with the Invoice Those not to be sent with the Invoice ApprovalMax attaches PDF audit reports as "Those not to be sent with the Invoice". So you will not send an audit report by ...