AuditFunAll testsGet the audit kit

Aging analyzer

Load an open-items list from any ERP and get a full aging in seconds: buckets by customer or vendor, overdue balances, red flags and an expected credit loss estimate. Export everything to Excel.

Your files are read inside this page only. Nothing is uploaded.
1

Load your open items

Excel (.xlsx, .xls) or CSV. One row per open invoice, credit note or payment.

Export not matching? Fill our Excel template and upload it instead. ⬇ Receivables template⬇ قالب عربي⬇ Payables template⬇ قالب عربي

Open receivables list

Needs at least a customer, a date and an outstanding amount. A due date is used if you have one.

or drop it here

No file to hand? to see how it works.

2

Set the aging rules

Saved in this browser for next time.

Usually the period end, for example 31 December.
If an item has no due date, the invoice date plus the payment terms below is used.
Used when your file has no due date or terms column.
Comma-separated, for example 30, 60, 90, 180, 365.
Only matters for dates like 03/04/2026.
Enter the control account balance to check the list agrees to the books.

Auditing receivables?
Get the full Revenue and Receivables Audit Kit: step-by-step plan, Excel workbook and fillable PDF in English and Arabic.

Get the kit free
Get updates by email · WhatsApp channel