Accounting

What is Accounts Receivable Aging?

Accounts receivable aging is a report categorizing unpaid client invoices by how long they've been outstanding.

Accounts receivable aging is a report that categorizes your outstanding invoices by how long they have been unpaid. Instead of showing a single total of money owed to you, an aging report breaks down receivables into time buckets -- typically current (not yet due), 1-30 days past due, 31-60 days past due, 61-90 days past due, and over 90 days past due. This snapshot reveals not just how much you are owed, but how old that debt is and therefore how risky it is to collect. An invoice that is 5 days overdue is very different from one that is 95 days overdue -- the older it is, the less likely it is to be paid in full. For freelancers and small business owners, the accounts receivable aging report is one of the most useful financial management tools available. It tells you exactly which clients are paying late, how severely, and how much of your receivables are at risk. Without this visibility, you might not notice that a significant portion of your revenue is tied up in invoices that may never be collected, creating a false sense of financial security.

An aging report is generated from your invoice records, typically by your accounting or invoicing software. For each outstanding invoice, the system calculates the number of days since the invoice date (or due date, depending on the configuration) and sorts it into the appropriate time bucket. The report shows each client's name, the invoice number, the invoice amount, and the aging category. Totals at the bottom show how much is outstanding in each time bucket across all clients. Reviewing this report weekly or monthly gives you a structured view of your collections situation. You can see at a glance that 80 percent of your receivables are current and 20 percent are over 60 days past due -- a split that tells you which clients need immediate follow-up. The report also helps you calculate your bad debt reserve: the percentage of older receivables that historical experience suggests will never be collected. This reserve is a standard accounting adjustment that prevents you from overstating your income.

For a freelancer managing ten to twenty active clients, an aging report is essential for staying on top of who owes what. Without it, late invoices can slip through the cracks -- especially when you are focused on delivering new work. An aging report puts every overdue invoice in front of you in priority order so you know exactly who to call first. For example, a freelance consultant who runs an aging report might discover that three clients account for 70 percent of their overdue receivables, while the other seven clients are current. That insight allows focused follow-up rather than generic reminders to everyone. Small business owners with employees or contractors need aging reports even more urgently -- if receivables are aging while payroll is due, a cash flow crisis is imminent. Reviewing the aging report before the end of each month and taking action on overdue accounts is one of the simplest and most effective cash flow management habits a small business can adopt.

The accounts receivable aging report and the cash flow statement are related but answer different questions. The aging report shows who owes you money and how overdue it is -- it is a snapshot of receivables at a point in time. The cash flow statement shows how money actually moved in and out of your business over a period -- it reflects payments received, not amounts invoiced. A business can have a healthy-looking cash flow statement in a given month while actually having serious aging problems -- for example, if it collected a large overdue payment that month but is still sitting on significant new overdue invoices. Conversely, a business with strong current invoices might show poor cash flow if those invoices have not yet been paid. Using both reports together gives you a complete picture: the cash flow statement tells you what happened, and the aging report tells you what is about to happen to your cash position based on what is outstanding.

Review your aging report on a weekly basis, or at minimum before each billing cycle. Start with the oldest bucket -- any invoices over 90 days past due need immediate attention, whether that is a direct phone call, a formal demand letter, or a decision to write off the debt and move on. Then address the 61-90 day bucket with firm follow-up emails. For 31-60 day overdue invoices, send a second reminder with a clear call to action. For current and lightly overdue invoices, automated email reminders are usually sufficient. Use the report to set collections priorities and script your outreach. Track which clients repeatedly appear in older buckets -- those are clients whose payment terms may need to be renegotiated or who should be required to pay a deposit on future work. Your aging report is also essential data for your accountant at tax time, as it informs estimates of bad debt deductions.

Eonebill automatically tracks the status and age of every outstanding invoice so you always know exactly where your receivables stand. The platform's dashboard shows you overdue invoices at a glance, and you can sort by age to quickly identify your highest-priority collections. Automated payment reminders go out based on configurable schedules -- before due dates, on due dates, and after -- reducing the number of invoices that age into overdue status in the first place. Try the [free invoice generator](/free-tools/invoice-generator) to start creating invoices that are tracked from day one. For businesses that want full aging analytics and automated collections workflows, [Eonebill pricing](/pricing) includes reporting tools that give you a real-time view of your receivables by age and client.

1. Only reviewing aging reports when cash is already tight -- by the time you notice a crisis, invoices may be 90 days overdue and nearly uncollectible; review the report proactively every week. 2. Treating all overdue invoices the same -- a client who is 5 days late needs a gentle reminder; a client who is 75 days late needs a serious conversation or escalation. 3. Failing to follow up consistently -- sporadic follow-up sends the message that you are not serious about collecting; create a systematic schedule and stick to it. 4. Not adjusting for known issues -- if you know an invoice is disputed, exclude it from aging calculations until resolved so it does not distort your collection priorities. 5. Ignoring small overdue balances -- small amounts seem insignificant but accumulate over time; a freelancer with twenty clients each owing a small overdue amount may have a material total exposure that is being overlooked.

[Accounts Receivable](/glossary/accounts-receivable) -- the total outstanding invoices that the aging report analyzes. [Bad Debt](/glossary/bad-debt) -- receivables that are ultimately determined to be uncollectible, often identified through aging analysis. [Payment Terms](/glossary/payment-terms) -- the due date rules that determine when an invoice becomes overdue in an aging report. [Collections Policy](/glossary/collections-policy) -- the formal process for following up on aged receivables.

FAQ

Frequently Asked Questions

How often should I run an accounts receivable aging report?

Run your aging report at least weekly if you have an active client base. Monthly is the minimum for smaller operations. The more frequently you review it, the faster you can catch overdue invoices before they age into the difficult-to-collect ranges above 60 or 90 days.

What is a healthy aging report for a freelancer?

A healthy aging report shows the majority of your receivables in the current or 1-30 day bucket, with very little in the 60 or 90-plus day categories. If more than 20 percent of your outstanding receivables are over 60 days past due, your collections process likely needs tightening.

Can I use aging reports to estimate bad debt?

Yes. A common method is to apply a percentage reserve to each aging bucket based on historical collection rates -- for example, assuming 5 percent of 31-60 day invoices and 30 percent of 90-plus day invoices will never be collected. This reserve estimate helps you plan for bad debt deductions at tax time.

What should I do with invoices over 90 days past due?

Escalate immediately. Contact the client directly by phone, not just email. If there is a genuine dispute, work to resolve it. If the client is unresponsive, consider sending a formal demand letter, engaging a collections agency, or writing the invoice off as a bad debt. Consult with an attorney for significant amounts.

Does aging reporting help me decide who to extend credit to?

Yes. If a client repeatedly appears in your 60 or 90-day aging buckets, that is a signal to require upfront deposits or stricter terms for future work. Aging history is informal credit data that helps you make smarter decisions about how much financial risk to accept from each client.

Track expenses with AI →