1. Your invoices
Needs a Customer (or Client), an Invoice Date and an Amount (or Total), plus at least one of a Paid Date, a Balance (or Amount Due) or a Status (paid, open, overdue, void …). Used when present: Due Date (otherwise invoice date plus the terms below) and an Invoice Number. Void, draft and written-off invoices are left out. Comma, tab and semicolon files, quoted fields, US and day-first dates and UTF-16 exports are read. Rows that cannot be read are listed with a line number and reason.
Choose a file or paste the text, then click Analyze.
Result
Aging of what you are owed
| Bucket | Invoices | Balance | Share |
|---|
Expected arrival, from each client's own history
| When | Balance |
|---|
By client
| Client | Invoices | Billed | Owes now | Overdue | Paid | Median days to pay | Paid late | Avg days late | Trend, days |
|---|
Chase list
Overdue invoices ranked by balance times days late. “Usually pays in” is that client's median once they have three paid invoices, otherwise your whole book's. “Chance paid in 30 days” is estimated from your own payment history (see below the table); “At risk” is the balance times the chance it is not paid.
| Client | Invoice | Balance | Days late | Age, days | Usually pays in | Chance paid in 30 days | At risk |
|---|
The model, and what it leaves out
- Open means an invoice with a balance: a paid date wins, then a Balance column, then the Status. Partly paid invoices count for the balance that is left. Void, draft and written-off invoices are excluded from every figure.
- Days late is the as-of date (or the paid date) minus the due date. With no Due Date column the due date is the invoice date plus the terms you type.
- Aging puts each open balance in a bucket by days past due. Reconciles. The buckets add up to the open total, and the forecast rows add up to it too.
- DSO is the open balance divided by what was invoiced in the last 90 days, times 90.
- Days to pay is paid date minus invoice date, for invoices that have a paid date. Clients need at least three paid invoices to be called habitual late payers or to have their own forecast.
- Chance paid in 30 days is a Kaplan-Meier estimate on the days-past-due clock: paid invoices are events, open invoices are censored at their current lateness. It is shrunk toward a 30% prior by three invoices' worth of belief and blended with the client's own history by how much of it was still at risk. It is tested on your own paid invoices (leave-one-out, Brier score against a constant guess) and the page says when it is no better than a constant. It estimates what happens without action, not the effect of chasing.
- Forecast expects each open invoice on the client's median days to pay. It is a projection from history, not a promise. An invoice already older than that is shown as past due by the client's own pattern, not forecast.
- Cost of waiting is dollar-days past the due date times the yearly rate you typed. The default of 10% is a placeholder, not a measurement; use your own borrowing or opportunity cost. The late fee line is an illustration: whether you may charge or collect a fee depends on your contract and the law where you work.
- Not modelled: partial payment dates, credit notes, currency, disputes, collection costs, interest you actually charged, and anything not in the file.
Common questions
How do I see which invoices are overdue and how late?
Export your invoice list from QuickBooks, FreshBooks, Wave, Xero, Stripe or your own sheet with a customer, an invoice date, a total and either a paid date, a balance or a status, then drop it here. The tool ages every unpaid balance from its due date into not yet due, 1–30, 31–60, 61–90 and over 90 days late, and lists the invoices to chase first. Nothing is uploaded; the file is read in your browser.
What is days sales outstanding (DSO)?
Days sales outstanding is how many days of billing are sitting unpaid. Here it is the open balance divided by what you billed in the last 90 days, times 90. If your terms are net 30 and your DSO is 62, invoices are typically taking about twice as long to be paid as they should, and you are financing your clients.
How does the tool predict when I will be paid?
For each open invoice it uses the median number of days that client has taken to pay their past invoices, once they have at least three paid ones, and the median for your whole book otherwise. An invoice already older than that is not forecast, because it is an exception to the client's own pattern. It is a projection from history, not a promise that anyone will pay.
What does late payment cost?
The tool adds up dollar-days past the due date across paid and open invoices and prices them at a yearly cost of money you type, such as your credit line or card rate. It also shows what a monthly late fee would have come to on the same days. Both are illustrations. Whether you may charge a late fee depends on your contract and the law where you work.
Which columns does the file need?
A customer or client, an invoice date and an amount, plus at least one of a paid date, a balance or a status. A due date is used when present, otherwise invoice date plus the payment terms you set. An invoice number is used when present. Column names are matched by alias; if a row cannot be read the page lists it with its line number and reason.
Is this financial or legal advice?
No. It applies arithmetic to the file you supply and two assumptions you type. It is independent of every accounting product named on this page and is not affiliated with or endorsed by any of them. How to pursue an unpaid invoice is a decision for you and, where needed, a qualified professional.