Aged Receivables report (older version)

Access the Aged Receivables, the old version of the Aged Receivables Details report. You'll need to use this older version of the report if you'd like to see foreign currency conversion details.

The Aged Receivables report shows the sales invoices that were awaiting payment during a selected month and several months prior.

Your user role determines if you can run or view this report.

Aged Receivables main

This report is also available as part of the management reports which you can access if you have the Adviser user role.

Generate the Aged Receivables report

To access the Aged Receivables report:

  1. On the Reports menu, click All Reports.
  2. Under Sales, click Aged Receivables.

The current month will show by default.

Select filters

Aged Receivables fields


Select a month. The report will show unpaid invoices due or issued as at that month and before it. The 'Ageing by' option determines whether you see invoices due that month or issued that month.

Show by

Choose either Month name or Month number to display the columns as months or number of months ago.

'Month name' shows 'Current', 'March' etc.

'Month number' shows 'Current', 'One month', 'Two months' etc.

Ageing by


  • Date to show invoices and credit notes in the month you raised them
  • Due date to show unpaid invoices in the month they were due (note this won't include credit notes as they don't have due dates). 
Show invoices

Check this option to get details of receivable invoices for each contact on the report.


Click Update to show the new report each time you change filters.

If you're viewing a report produced by someone with the Adviser 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

Show Aged Receivables chart

Click the Show Aged Receivables Char button to show amounts owing each month, chunked by contact. Hold your mouse over each coloured block in the stack to see how much that person or company owes you.

The chart shows amounts as net and in the month the invoice was raised or due (depending on the 'Ageing by' option chosen). If a customer is in credit for a month, the bar will display below the graph.

To hide the chart, click the X button above the chart to hide it.

When you export the report as a PDF, the chart will only display if it's showing on your screen in Xero.

rep - aged rec - rec chart button

View transactions

Transactions list on Aged Receivables report.

  • The list of 'Receivables' are all the contacts whose invoices were unpaid in the month they were raised or due (depending on the ‘Ageing by’ option chosen).
  • Credit notes entered for customers and entered but not yet allocated to invoices are also shown.
  • The Total (%) figure shows the portion of the total amount outstanding for each month.
  • If you have chosen to show invoices, each outstanding invoice for that Contact will be listed under each Contact name.

Viewing transactions in the 'show invoices' view provides details of invoices under each contact.

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

Only approved invoices, bills and credit notes are recorded in your chart of accounts, and this is where the report draws its data from (items that have been approved and are awaiting payment).

Drill down for more detail

If you have not checked the 'Show invoices' box, you can drill into the report for more detail.

Click the monthly receivable amount due to view all the invoices and credit notes.

Click on amount to view list of invoices.

Click a contact name to view a report showing the invoices and credit notes you have issued them, with the total amount they currently owe.

'Show invoices' view

If you checked the 'Show invoices' box, each relevant invoice will be shown under each contact's name.

Click the invoice details to view the original invoice.

Select inv

View AR invoice

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.

You might also be interested in