Log every open invoice — customer, dates, status, amount. We compute days-overdue, bucket each line into Current / 1-30 / 31-60 / 61-90 / 90+, and roll up totals by customer with DSO and collection-rate metrics on top.
01 — What you create
Days-overdue per invoice, five ageing buckets, customer rollups, and a most-overdue-first sort — your collections team chases the right customer first.
Sonchoy Studio Ltd.
As of 18 Jun 2026
Receivable
68,800.00
Overdue
46,400.00
DSO
48d
Collection
3.4%
Ageing
Current
22,400
1–30
12,600
31–60
12,600
61–90
0
90+
21,200
| Customer | Days | Status | Amount |
|---|---|---|---|
| Wayne Enterprises | 95d | SENT | 3,200.00 |
| Stark Industries | 80d | DISPUTED | 18,000.00 |
| Globex Corp. | 45d | SENT | 12,600.00 |
| Northwind Books Ltd. | 5d | VIEWED | 8,400.00 |
| Acme Publishing Co. | 0d | SENT | 4,200.00 |
| Dunder Mifflin | +10d | PARTIAL | 5,400.00 |
| Initech | +18d | SENT | 9,200.00 |
| Pied Piper | +25d | SENT | 7,800.00 |
Scanned invoices, multi-page batches, multi-currency stacks, and direct push into your accounting system. Free for 30 days, no card required.
Try Premium FreeFree 30 days · no credit card · cancel anytime
02 — How it works
The "As of" date is the integrity anchor — every days-overdue, ageing bucket, customer rollup, and DSO is computed against it. Roll the date forward, watch buckets re-stratify automatically.
Customer, invoice number, dates, status, amount. Paid + written-off invoices can stay in the dataset — they're excluded from receivable totals automatically.
Each invoice's days-overdue is computed from your "As of" date. Invoices fall into Current / 1-30 / 31-60 / 61-90 / 90+ buckets.
PDF sorted most-overdue-first with ageing strip, customer rollups, DSO + collection-rate metrics — plus a 2-sheet XLSX (Invoices + Summary).
03 — Built for collections teams
Computed live from your "As of" date — negative means not-yet-due, positive means overdue and ageing.
Current, 1-30, 31-60, 61-90, 90+ days — colour-coded for at-a-glance scanning in the PDF.
Draft, Sent, Viewed, Partial pay, Disputed, Paid, Written off — paid and written-off auto-excluded from receivable.
Days Sales Outstanding (overdue average) and Collection Rate (paid ÷ total issued) printed at the top.
Top customers by amount owed — chase the biggest balances first and concentrate collections effort.
Written-off invoices are tracked in the XLSX Summary sheet so you can quantify bad-debt expense for the period.
Bulk OCR, batch invoicing, multi-party e-signing, redaction, audit logs — pdfFiller picks up where Sonchoy ends. Free for 30 days, no credit card.
Run 100+ invoices, statements, or conversions in one go.
Turn paper invoices into searchable, exportable data.
Multi-party signatures with full audit trails.
Mask sensitive ledger lines before sending to auditors.
04 — Common questions
Accounts Receivable (AR) is what customers owe you — money flowing in. Accounts Payable (AP) is what you owe vendors — money flowing out. This tool tracks AR. For AP (chasing vendor bills), see the Accounts Payable Report tool.
DSO = average days-overdue across overdue invoices only. It's a quick health check for collection speed — under 30d is healthy, 30-60d is concerning, 60d+ usually means systematic collections issues.
Paid ÷ (Paid + Outstanding + Written off). It tells you what % of all invoices ever issued have been collected. 80%+ is good, below 60% usually means you have credit-control problems.
The point of an AR report is what you're still owed and likely to collect. Paid invoices are done; written-off invoices are unrecoverable bad debt. Both stay in the .xlsx detail sheet for context but never count toward Receivable, Overdue, or ageing totals.
Set status to Disputed. The invoice still counts toward receivable (until written off or paid) but the status flags it so collections teams know there's a problem to resolve before chasing payment.
PDF (collections-sorted, with ageing strip, DSO/collection metrics, top customers, signature line) and .xlsx (two sheets: Invoices with full detail, Summary with all KPIs and breakdowns).
05 — Related tools