How to turn Xero’s aged receivables report into a recovery shortlist

Open Reporting → All reports in Xero and look for Aged Receivables Summary. In a US organisation, search for Accounts Receivable Aging Summary. Select a report date, age the report by Due Date, and click Update. The result shows what was outstanding on that date.
Upload a case

Key facts

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.