Calculator form
Use multiple invoice lines, custom aging cutoffs, payment offsets, and promise dates.
Example data table
This sample illustrates how balances move into buckets after payments and credits. Use your own dates and cutoffs for live results.
| Invoice | Customer | Issue date | Due date | Gross | Payments | Credits | Outstanding | Days past due | Bucket |
|---|---|---|---|---|---|---|---|---|---|
| INV-2101 | Atlas Contract File | 2026-01-05 | 2026-02-04 | $4,000.00 | $1,000.00 | $0.00 | $3,000.00 | 43 | 31-60 |
| INV-2102 | Blue Harbor Terms | 2026-02-20 | 2026-03-22 | $1,500.00 | $0.00 | $100.00 | $1,400.00 | -4 | Current |
| INV-2103 | Crown Legal Appendix | 2025-10-10 | 2025-11-09 | $6,800.00 | $800.00 | $0.00 | $6,000.00 | 129 | 121+ |
Formula used
Outstanding balance = Invoice Amount − Payments Received − Credits Applied
Days past due = As-of Date − Due Date
Current balance is any outstanding amount with days past due less than or equal to zero.
Overdue percentage = Overdue Outstanding ÷ Total Outstanding × 100
Weighted late days = Σ(Outstanding × Positive Days Past Due) ÷ Total Overdue Outstanding
Risk index blends overdue share, older buckets, disputed balances, and promise dates already missed.
How to use this calculator
- Set the as-of date used for the aging snapshot.
- Adjust bucket limits if your team uses nonstandard terms.
- Enter each invoice line with gross amount and dates.
- Add payments, credits, and optional promise dates.
- Select the current collection status for each item.
- Submit the form to see results above it.
- Review charts, bucket tables, and customer concentration.
- Export the detailed output to CSV or PDF.
Frequently asked questions
1. What does a receivables aging tool measure?
It groups open invoices by how late they are relative to the due date. This helps you spot current balances, overdue exposure, disputed items, and customers needing faster collection attention.
2. Why use an as-of date instead of today only?
An as-of date lets you reproduce month-end, quarter-end, audit, or legal reporting snapshots. It is useful when reviewing historical contract performance or preparing documentation packs.
3. Are credits handled before aging is assigned?
Yes. The tool subtracts payments and credits from the gross invoice first. The remaining outstanding balance is what gets placed into the aging bucket.
4. What happens if an invoice is not due yet?
If the balance is still open but the due date has not passed, the item stays in the Current bucket. Negative days past due simply mean the due date is still ahead.
5. Why track promised payment dates?
Promise dates add collection intelligence. If a promised date passed before the as-of date and the invoice is still open, the tool flags that exposure inside the risk score.
6. Can I use custom bucket limits?
Yes. Enter your own cutoffs for bucket ranges. Teams often change these to match internal policy, sector conventions, or document terms written into service agreements.
7. What is weighted late days?
It is the average lateness of overdue balances after weighting each invoice by its open amount. Large unpaid invoices influence the result more than very small invoices.
8. Does the export include detailed invoice rows?
Yes. The CSV and PDF exports include summary data, bucket totals, customer exposure, and the detailed invoice aging table currently shown in the results section.