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, select your Organisation in the main menu and open "Line item reports" under Reports section:


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, Workflow Manager and Auditor role.
Learn more about how you can assign a new role to users here.

    • Related Articles

    • Line Item Accrual reports

      What are Accrual reports? Accrual accounting records revenues and expenses when they are incurred, regardless of when the respective cash transactions are made. This approach offers a more accurate representation of a company’s financial performance ...

    • Accrual report .CSV file for Xero Manual Journal entry (header level, limited version)

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

    • Why does the item code not show in the Purchase Order PDF?

      If you use ApprovalMax for Purchase Order creation, approval, and dispatch to the supplier, you'll probably want to see the item code in the corresponding PDF file. However, there is no Item Code field in the default PDF template. To add it, open the ...

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

    • How to create a Line Item Accrual report and export it to a Manual Journal

      Creating Accruals* in ApprovalMax is a straightforward process that helps maintaining accurate financial data. * Accruals in ApprovalMax on Line Item level provide a comprehensive solution that allows you to create Accrual reports, generate journals ...