Paste or upload your open invoices and get an aging report by customer: current, 1–30, 31–60, 61–90, and 90+ days past due. Works with exports from QuickBooks, NetSuite, or any spreadsheet. No signup.
Accounts receivable aging
| Customer | Current | 1–30 | 31–60 | 61–90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Harbor Foods | $7,300 | – | – | – | $18,900 | $26,200 |
| Acme Industrial Supply | – | – | $4,150 | $6,420 | – | $10,570 |
| Cascade Logistics | $11,200 | – | $2,940 | – | – | $14,140 |
| Northwind Manufacturing | $9,800 | $12,500 | – | – | – | $22,300 |
| Summit Electrical | $5,600 | $3,275 | – | – | – | $8,875 |
| Total | $33,900 | $15,775 | $7,090 | $6,420 | $18,900 | $82,085 |
| Share of total | 41.3% | 19.2% | 8.6% | 7.8% | 23% | 100% |
10 invoices across 5 customers, aged from the due date.
An accounts receivable aging report groups everything customers owe you by how long it has been outstanding. Each row is a customer, and each column is an aging bucket. The total of the report equals your receivables balance.
This report ages invoices from the due date, so the buckets show how late customers are paying. An invoice due tomorrow is current. An invoice due 45 days ago sits in 31–60.
An aging summary shows one line per customer with a total in each bucket, like the report above. An aging detail lists every open invoice with its due date and days past due. Use the summary to see where the money is, and the detail to work through it invoice by invoice.
Subtotal rows such as “Total Acme” and rows with no balance are skipped automatically. Credits with a negative balance reduce the bucket they fall in.
The total of this report is the receivables figure in the DSO formula. Divide it by your credit sales for the period and multiply by the days in the period, or use the DSO calculator to see how far past terms your customers pay. For the oldest balances, our payment reminder and collections email templates cover the most common reasons an invoice is stuck.
An accounts receivable aging report lists the money customers owe you, grouped by how long each invoice has been outstanding. Balances are usually split into current, 1–30, 31–60, 61–90, and over 90 days past due, by customer, so you can see who is paying late and how much of your receivables is at risk.
Either, as long as you are consistent. Aging from the due date shows how late customers are paying, which is what collections needs. Aging from the invoice date shows how old the receivable is regardless of terms. This tool ages from the due date, and uses the invoice date plus your default terms when a due date is missing.
Current (not yet due), 1–30 days past due, 31–60, 61–90, and over 90 days. Some teams add a 91–120 bucket or split over 120, especially when they reserve for bad debt by bucket.
Weekly for collections work, and at every month end for the close. Comparing the same report month over month shows whether balances are moving into older buckets.
In QuickBooks Online, run the A/R Aging Detail report and export it to Excel or CSV. In NetSuite, run the A/R Aging Detail report under Reports > Customers/Receivables and export it as CSV. Paste the rows here. The tool looks for columns such as customer, invoice number, due date, and open balance.
No. The report is calculated entirely in your browser. Nothing you paste or upload is sent to Alder or stored.
Alder goes through your aging ledger invoice by invoice, finds out why each one is late, and drafts the right follow-up for your approval. See how collections works.
Book a demo