Accounts receivable aging audit
An accounts receivable aging report shows what customers owe and how long invoices have been overdue. An audit turns that list into work: decide which invoices need a reminder, which need a correction or a dispute owner, and which are ready for collection review.
Start with an invoice-level aging detail report. Pick one snapshot date and age invoices from their payment due dates. Then reconcile the open balances and give each overdue invoice an owner and a next action. Microsoft Dynamics customer aging report · Oracle NetSuite aging detail
1. Start with the right columns
Keep one row for each unpaid invoice. Include the selling entity, customer reference, invoice number, due date, open amount, currency and debtor country. Keep partial payments and credit notes with the invoice they affect. Add the latest contact date, any promised payment date, and the amount the buyer disputes if you have those records.
Use the open amount from the ledger on your snapshot date. Check duplicate references across selling entities, unusually early due dates and credits you cannot allocate. Put rows with a missing due date, unknown currency or an unclear balance in a review list. Keep totals by currency so a €5,000 balance and a $5,000 balance stay distinct.
2. Group the invoices by age and decide what to do
For an overdue invoice, subtract the due date from the snapshot date. Use consistent groups such as current, 1–30, 31–60, 61–90 and 91+ days overdue. The groups help you organise the queue. Give the payment history, dispute and documents their own fields.
| What you find | Next action |
|---|---|
| The customer has approved the invoice and missed the payment date | Confirm the payment date or ask for remittance. Give the follow-up a date and an owner. |
| The invoice lacks a purchase order reference | Add the reference and resend the invoice to the billing contact. |
| The invoice names a different company from the signed order | Confirm which company contracted with you and resolve the mismatch before escalating. |
| The customer disputes a shipment or service | Record what it disputes, attach its correspondence and assign a person to resolve it. Show any undisputed balance separately. |
| A payment promise was missed and the business still owes a documented balance | Review the invoice for escalation, together with your latest reminders and evidence of delivery or service. |
| The customer may be in formal insolvency | Check the official case notice before choosing the next step. Insolvency registers and claim deadlines |
3. Build this week's list
Use 18 November as the snapshot date in this example.
| Invoice | Due date | Open balance | Days overdue | What happened | This week's action |
|---|---|---|---|---|---|
| NL-104 | 8 October | €4,800 | 41 | The customer missed its promised date. Delivery is signed. | Recheck the ledger and prepare the evidence for collection review. |
| GB-221 | 8 November | £7,200 | 10 | The customer disputes the installation sign-off | Assign the dispute to the delivery team and agree when it will respond. |
| US-082 | 24 August | $2,100 | 86 | A recent payment has arrived without a remittance reference | Reconcile the payment before contacting the customer again. |
Start with the rows that can move this week. For each, record the owner, next action and review date. If a deadline may be approaching, check the contract and applicable rules separately. Commercial debt limitation periods
Prepare an invoice for collection
Gather the invoice, contract or purchase order, delivery or service evidence, reminders and a reconciliation of the outstanding amount. Identify the company that owes the money and show who accepted the goods or work. Use the original invoice currency and attach any remittance.
Start a collection case for a documented overdue business invoice. Debitura applies a success fee to money recovered on eligible standard pre-legal cases. Pricing and collection fees
For the wider process, see accounts receivable management and what to do about unpaid business invoices.