Accounts Payable Invoices report (older version)

Access the Accounts Payable Invoices report, the older version of the Aged Payables Detail report. You'll need to use this older version of the report if you'd like to see foreign currency conversion details.

Only some users can run or view this report.
Reports and budget role comparison

Aged Payables Invoices report showing the transactions for a cleaning company.

Help on this page:

Elsewhere in Help Center:

How to generate the report

Access an Accounts Payable Invoices report from:

Choose options by which to re-run the report:

Generate the report using the 'From', 'To', 'Show by' and 'As at' boxes.

From

The date you want the report to start from.

To

The date you want to run the report until.

Show by

Choose either Date or Due date to retrieve unpaid invoices or unallocated credit notes based on the month they were raised (Date) or in the month they were due (Due Date). 

As at

Show payments as at a certain date (defaults to the current date).

Update

rep - button - update.png

When the details of the report you want to run are entered or updated, click Update to re-generate the report.

If you are viewing a report produced by someone with the Advisor user role, you may see notes or a summary on the report. You may be able to export, archive or edit the report, depending on your user role.
Reports and budget role comparison

View transactions

Invoice transactions

The report shows each bill, credit note, overpayment or prepayment within the relevant period. It will show how long any bills have been overdue (if any) along with the totals on each, less any credits and payments, and the amount you currently owe.

The report displayed will be different depending on how you got there:

  • If you got here by clicking on a bill amount outstanding for a month on the Aged Payables report, the report will display all unpaid bills, credit notes, prepayments or overpayments for that supplier for that month.
  • If you clicked on the contact name on the Aged Payables report, the report will display all bills, credit notes, prepayments or overpayments for that supplier for all time.
  • If you have come from the Contact entry for the organization, the report will display all bills, credit notes, prepayments or overpayments for that organization.

You can narrow down the report to a particular time frame using the From and To date fields at the top of the report.

Note: only approved invoices and credit notes are recorded in your chart of accounts and this is where the report draws its data from i.e. items that have been approved and are on the Accounts Payable Awaiting Payment tab or Accounts Payable Paid tab.

If you are using multi-currency the report footnotes show the figures that were converted into your base currency for the purpose of reporting in one currency and at what rate the conversion rate occurred. They also show where the rate was taken from (i.e. whether it was an XE rate or a rate entered by a user). Find out more on how multi-currency reports in Xero work.

Select individual transactions

Click on a link on the report (e.g. a bill date) to view the original bill, credit note, overpayment or prepayment

Click on link to view invoice details.

Invoice details.

Back to Aged Payables

rep - inv - ap back.png

If the 'Back to Aged Payables' link displays it will take you back to the previously generated Aged Payables report.

Export your report

To export the report:

  1. Click Export, then select your preferred export option:

    • Excel
    • PDF (printable format)
    • Google Sheets
  2. Open, save or print the file as you need.