See who owes you, and how long you wait to get paid
Drop in a list of your invoices. You get an aging report by customer, your days to get paid (DSO), and a drafted reminder for each late customer. It is free, there is no sign-up, and your file never leaves this page: your browser does the arithmetic.
Drop your invoice export here
A CSV or Excel file with a row of headings. The Open Invoices or A/R Aging Detail report from QuickBooks works as it comes, and so does Aged Receivables Detail from Xero.
What stays private
- The file is opened by your browser and is not uploaded or stored anywhere.
- The page counts visits and nothing more. It does not record your screen or what is in your file.
- Close the tab and the numbers are gone.
How to get the file
QuickBooks: open Reports, run Open Invoices or A/R Aging Detail, then use the export button to save it as Excel or CSV.
Xero: run Aged Receivables Detail and export it.
Anything else: any spreadsheet with a customer, an invoice date, a due date and the amount still owed.
Aging report by customer
Choose a customer to see the invoices behind the total.
Who to call first
Columns used
If a number looks wrong, check that each item points at the right column in your file.
How it is worked out
Each unpaid invoice is placed by how many days it is past its due date. Days to get paid is what you are owed, divided by what you invoiced in the last 90 days, times 90. These are plain calculations on your file. No AI is involved, and nothing is estimated.
Made with the free aging report at handledbymorning.com/aging-report
Want this in your inbox every morning?
I connect your books read-only, check the numbers against your own totals, and send one page before you start work: who paid, who is late, and what changed. A free 30-minute look shows what your systems could answer today.
What an aging report tells you
An accounts receivable aging report lists the money customers owe you, grouped by how late it is: not due yet, 1 to 30 days late, 31 to 60, 61 to 90, and over 90. The further right an amount sits, the less likely it is to be paid in full, so the right-hand columns are where to spend your time.
Read it by customer, not by invoice. One customer with three old invoices is one phone call.
How days to get paid is calculated
Days sales outstanding, or DSO, is the average number of days between sending an invoice and being paid. The usual formula is:
money owed to you ÷ sales in the period × days in the period
If you are owed $120,000 and invoiced $240,000 in the last 90 days, your DSO is 45 days. Compare it with your payment terms. A DSO of 45 on 30-day terms means customers pay about two weeks late on average.
When your file lists paid invoices as well as unpaid ones, the tool adds up the last 90 days of sales for you. When it holds only unpaid invoices, type your sales for the last 90 days and it does the rest.
Questions
Is my file uploaded?
No. The page reads the file inside your browser and never sends it anywhere. You can disconnect from the internet after the page loads and it still works for CSV files.
Which files work?
CSV and Excel files with a heading row. QuickBooks and Xero reports work as exported, including the QuickBooks layout where each customer is a heading above its invoices.
What is a good DSO?
It depends on the terms you give. On 30-day terms, a DSO near 30 means customers pay on time and a DSO of 45 means they pay about two weeks late. The most useful comparison is with your own terms and your own last quarter.
Why does one customer's share matter?
If a single customer holds a large part of what you are owed, one late payment can leave you short of cash. The tool marks the biggest customer's share when it passes a quarter of the total.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This tool is a small, free piece of that work.