Invoice tracker
- Days sales outstanding
- 30
- Computed on this page from the inputs below
- Average invoice outstanding
- $1,500
- Computed on this page from the inputs below
- Overdue as a share of outstanding, percent
- 25
- Computed on this page from the inputs below
Every figure on this page is computed from the inputs entered, by the method stated below it. ReceivableLedger publishes no tax rate, no payment term, no late fee and no benchmark: the defaults are a worked example to replace with your own figures.
Email me this result
We will send you these figures and a link back to them. One email, nothing else unless you tick the box.
The figures above start from a worked example (30). Change any input and the answer updates as you type.
Download the Invoice tracker worked example (CSV)
This is an invoice tracker that reads what is owed from a business's own figures. The total outstanding over the invoices outstanding is the average invoice; the part past its due date over the total is the overdue share; and receivables over sales on account, times the days in the period, is days sales outstanding.
The average invoice, so the total means something
Twelve invoices totalling $18,000 average $1,500 each, and that figure says whether the outstanding total is a few large customers or many small ones, which decides who to call first. The tracker shows it before the percentages, because a total on its own is not a plan.
The overdue share, the part that needs chasing
The amount past its due date over the total outstanding is the overdue share, 25% on the worked example, and it is the figure that separates a healthy ledger from a slow one at the same total. The paid plan reads it from the invoices' due dates and sends the reminders for the part that is late.
Days sales outstanding, read every period
Receivables over the period's sales on account, times the days in the period, is days sales outstanding: $18,000 over $54,000 across 90 days is 30. Compared with your payment terms it says how late you are being paid on average, and compared with last period it says which way it is going. The paid plan keeps every period so the trend is a column.
Invoice tracker: common questions
Is this a free invoice tracker?
Yes. Enter the invoices outstanding, the total, the overdue part, the sales on account for the period and the days in it, and it works out the average invoice, the overdue share and the days sales outstanding on the page with no account and no card. Print it as it stands. ReceivableLedger Pro keeps every invoice and reads the same figures live from them.
How is days sales outstanding calculated?
Accounts receivable divided by sales on account for the period, multiplied by the days in the period. Use credit sales, not cash sales, and the same period on both sides; the worked example uses 90 days. The tracker publishes no target, because the right figure is your own payment terms and the direction it is moving.
What counts as overdue?
Any invoice past the due date on its own terms, whether that is 30 days, 14 or on receipt. Enter the amount past due as your terms define it; the paid plan reads it from each invoice's due date and flags the invoice the day it passes.
Where the figures in this tool come from
IRS Publication 583, starting a business and keeping records.