Invoice Aging Report: What It Is and How to Use It
An invoice that is 60 days overdue has less than a 40% chance of being paid in full. An invoice aging report tells you this before you find out the hard way.
01. What Is Invoice Aging?
Invoice aging is the practice of grouping unpaid invoices by how long they have been outstanding. It is a standard accounts receivable management technique that transforms a flat list of unpaid invoices into a prioritized collection view organized by risk level. The fundamental insight: collection probability declines sharply with age. An invoice that is 15 days past due has a fundamentally different recovery probability than one that is 75 days past due. Treating both the same — a weekly follow-up email — misallocates collection effort. The aging report tells you which invoices need which level of response.
"The older an invoice, the lower the probability of full collection. Most agencies learn this the first time a 90-day invoice goes to zero."
02. The Three Standard Aging Buckets
The three time-based categories that most invoice aging systems use:
- 0-30 Days (Current): Collection probability 85-95%. These invoices are typically in administrative processing — the client's accounts payable has received the invoice and it is moving through their approval process. Appropriate action
- 31-60 Days (Elevated Risk): Collection probability drops to 60-75%. At this stage, an administrative delay has become a problem. Something is wrong — the invoice may be disputed, the contact may have changed, or the client may be experiencing cash flow difficulties. Appropriate action
- 60+ Days (Critical): Collection probability below 40%. Invoices here represent real collection risk. Appropriate action
03. How to Read an Aging Report
An aging report has two dimensions that reveal different information: Column totals show the total outstanding balance in each aging bucket across all clients. This is your risk exposure by time period. High totals in the 60+ day column indicate a systemic collection problem — either poor follow-up processes or client-base credit quality issues. Row totals show each individual client's total outstanding balance and how it distributes across buckets. A client with $6,000 outstanding is different depending on the breakdown: $6,000 in the 0-30 day bucket is current; $2,000 in 0-30 and $4,000 in 60+ indicates a chronic late payer with an escalating problem. Prioritize by row total in the highest aging bucket: the client with the largest balance in the 60+ day column deserves the most immediate attention, regardless of their total outstanding.
04. The Cash Flow Impact of Invoice Aging
For agencies operating on thin margins, unpaid invoices represent extended interest-free credit — money the agency has earned but not yet collected, funding a client's operations at no cost to them. The business impact compounds: a $30,000/month revenue agency carrying 25% of invoices in the 60+ day bucket has approximately $7,500 in high-risk receivables. At the 40% collection probability for 60+ day invoices, that is a potential $4,500 loss — not from project scope but from payment failure on work already delivered. The compounding problem: agencies that allow chronic late payers to continue receiving work without resolving overdue invoices accumulate risk at each project cycle. By the time the relationship is clearly untenable, the outstanding balance may represent several months of engagement.
05. Collection Strategies by Bucket
Each aging bucket requires a different collection approach, calibrated to the urgency and relationship implications of that stage: **0-30 Days:** Automated reminders with neutral tone. 'This is a friendly reminder that invoice #1042 for $3,500 is due on [date]. Please let us know if you have any questions.' No pressure language. Preserve the working relationship. **31-60 Days:** Direct phone call using problem-solving framing. Skip the payment-demand script. Try: 'I wanted to make sure there are no issues with invoice #1042 — sometimes invoices get lost in routing and I want to confirm it reached the right person.' Goal: understand the specific obstacle and create a clear path to resolution. **60+ Days:** Formal written demand to a senior contact. Not the day-to-day project contact, who may have no authority over payment. Addressed to the CFO, COO, or owner. Specifies exact payment amount, specifies an exact payment date (not a range), and states the consequences of non-payment clearly and professionally.
06. Tracking Client Payment Patterns Over Time
A single aging report is a snapshot. Comparing aging reports over several months reveals client payment patterns that inform risk management decisions: Consistently current clients: invoices reliably appear in the 0-30 day bucket and clear before 30 days. These clients warrant extended payment terms and relationship investment. Consistently slow clients: invoices consistently move into the 31-60 day bucket before clearing. These clients are predictably slow but do eventually pay. Adjust cash flow planning to account for the delay. Escalating problems: clients whose invoices move progressively deeper into the aging report — starting in 0-30, then appearing in 31-60, then 60+. This pattern indicates a deteriorating financial situation or declining commitment to the relationship. Address the payment pattern before starting new projects.
07. How to Generate an Aging Report
Three approaches for generating invoice aging reports, in order of sophistication:
- Manual spreadsheet: Export your unpaid invoices, calculate days outstanding with a date formula, use IF statements to categorize by bucket. Works for under 10 clients; becomes error-prone and time-consuming as volume grows. The accuracy depends on the freshness of the export — a spreadsheet last updated three days ago already shows stale data.
- Native accounting software: QuickBooks, Xero, and FreshBooks all generate aging reports from their invoice data. More reliable than spreadsheets. The limitation
- CRM with integrated invoicing: Invoice aging calculated within the client record, alongside communication history, health score, and project status. When you see a client in the 60+ day bucket, you can immediately see the last contact date, the account manager responsible, and the current health score — without switching tools.
08. Invoice Aging in Melororium
Melororium connects invoice aging to client relationship context. Each client record in the CRM shows outstanding invoices organized by aging bucket alongside the client health score, last contact date, and active project status. The practical benefit: the right response to a 60+ day invoice depends on the relationship context. An otherwise-healthy client with strong communication who suddenly has an overdue invoice probably has an administrative problem. A client whose health score is also low, with no recent contact and no active projects, likely has a relationship problem that the invoice reflects. The same invoice aging status requires a different response in each case. The billing dashboard aggregates aging across all clients: total current outstanding, elevated risk total, and critical bucket total with revenue at risk. For agencies reviewing their receivables position at the start of the week, this view answers 'where are my collection risks?' in under 30 seconds.
Invoice aging in the same view as client health, communication history, and project status.
Melororium connects your billing data to your client relationships — without a separate accounting subscription.
