Ageing Analyzer

Drop a receivables ageing. Every customer's buckets re-added — and the overdue truth surfaces.

Every customer row re-addedOverdue concentration surfacedCorrected-report request auto-drafted

Try it now — right here

100%

of customer rows re-added, one by one

>90d

overdue concentration computed

1-click

corrected-report request copied

📥 What to drop

📇

Receivables ageing reportsParticulars / Pending Bills / day buckets — Tally Group Outstandings and similar

🧾

Excel with letterheadscompany headers above the table are fine — the bucket header is found automatically

<30 / 30–90 / 90–180 / >180Any ≥2 bucket columnsGrand Total cross-checkRed-flagged mismatch rowsLetterheads skipped

🔍 What you'll see

0–3084,200

31–9041,900

90–18022,300

>18055,750

✓ every customer's buckets sum to their outstanding total

⚠ 27% of receivables are older than 90 days

Per-customer arithmetic: buckets must sum to that customer's outstanding total — failures in red
The printed Grand Total row compared against computed column sums
Overdue concentration: how much of the book is older than 90 days
A bucket-by-bucket spreadsheet view and XLSX export with the verification trail

⚡ Try it now

The real analyzer, on this page. Drop your document below — results, checks, spreadsheets and downloads appear right here. An access code from your Alya contact is required while the suite is in preview.

Access code

🤝 Straight answers

The analyzer verifies the report's own arithmetic — a left-out invoice needs the ledger check and statements
Collectability is a judgement; concentration is reported as a fact, not a verdict