How to turn Xero’s aged receivables report into a recovery shortlist
Key facts
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Open the invoices behind one customer’s total
Click an overdue amount on the customer’s row to open the outstanding transactions in the detail report. Clicking the contact name opens the Receivable Invoice Summary, where you can also see paid transactions. In the detail view, check the date and filters before you export. To review every period for one customer, run the detail report with a Contact filter for that customer and the same report date. Click Export and choose Microsoft Excel or Google Sheets. Xero’s report drilldown, contact filter guidance and export instructions.
The customer total can include outstanding invoices, credit notes and overpayments. With multicurrency, Xero shows amounts in your organisation’s base currency in the aging summary. Keep that report figure for reconciliation. Open each candidate invoice to verify what remains due in the invoice currency. If you need to show source and base currency in a report, Xero documents foreign exchange columns in Receivable Invoice Summary. Xero’s aged receivables summary and source-currency reporting options.
Check the exceptions before you follow up
| What you find | What to record | Who acts |
|---|---|---|
| Part-paid invoice | Original amount, payments and credits applied, and today’s remaining balance in invoice currency | AR verifies the allocations and requests the remainder. |
| Open credit or overpayment | Reference, amount and currency, plus the invoice it may apply to | Cash application verifies the allocation. Hold any affected amount until the balance is confirmed. |
| Invoice settled after the report date | Receipt reference, date and current balance | AR closes the follow-up at zero and retains the amount on the historical snapshot. |
| Customer queries part of an invoice | Disputed amount and reason, acknowledged amount, evidence needed and action date | The dispute owner checks the charge. AR follows up on any separately confirmed amount. |
| Invoice already with a collector | Case reference and the person responsible for the case | The existing case owner checks for updates and handles the next communication. |
Record the Xero organisation and contact, the debtor’s legal name and country, each invoice number and due date, and the verified amount and currency. Include the source invoice, agreement or order, evidence of delivery or service and recent correspondence for any invoice you shortlist.
Example of a UK supplier reviewing a German customer
A UK supplier opens the detail report for a German customer as of 16 November. Its report displays the customer in GBP, and the three invoices were issued in EUR. Before the weekly call, the team checks each transaction in Xero and adds its own exception status and owner. Amounts and references are fictional.
| Transaction | Verified remaining amount | Exception status | Owner and next action |
|---|---|---|---|
| X-701 | EUR 4,200 | EUR 5,000 billed, EUR 800 allocated. The customer acknowledged the remainder and missed the 13 November promise. | AR lead checks supporting records and reviews for collection. |
| X-702 | EUR 2,400 | The buyer queries EUR 400 for installation. EUR 2,000 is acknowledged. | Service manager checks sign-off. AR follows up on the acknowledged EUR 2,000. |
| X-703 | EUR 0 | EUR 900 outstanding on the report date. Paid on 17 November. | Cash application records the allocation. AR removes the invoice from active follow-up. |
The current open invoice total is EUR 6,600. Only X-701, at EUR 4,200, goes on the recovery shortlist. Before any handoff, run a final balance and case-reference check.
Move a verified invoice to the next step
Once you have a documented, overdue balance that remains unpaid after follow-up, review what the collection provider needs. Debitura’s Xero debt collection guide explains the Zapier and CSV routes. Its case information checklist lists the debtor and invoice details to have ready.


.webp)