Unpaid Invoices: How to Find, Investigate, and Recover Outstanding Business Revenue

The Problem with Unpaid Invoices

An unpaid invoice is revenue you have earned but not collected. It sits on your books as accounts receivable, and every day it remains unpaid, it becomes less likely to be collected at all. Unpaid invoices are one of the most common and most measurable forms of revenue leakage.

For many businesses, unpaid invoices are treated as a normal cost of doing business. A certain percentage of customers will not pay on time; a smaller percentage will not pay at all. But treating unpaid invoices as inevitable is a mistake. Many unpaid invoices can be collected—or prevented in the first place—with a more effective process.

This guide explains how to investigate unpaid invoices, read an aging report, improve your collection process, and distinguish between invoices that are temporarily delayed and those that represent genuine revenue leakage.

Understanding the Accounts Receivable Aging Report

The accounts receivable aging report is the primary tool for investigating unpaid invoices. It organizes outstanding receivables by how long they have been unpaid, typically in 30-day buckets:

• Current (0-30 days): Invoices that are not yet due or are recently due.
• 1-30 days past due: Invoices that are slightly overdue.
• 31-60 days past due: Invoices that are significantly overdue.
• 61-90 days past due: Invoices that are seriously overdue.
• 90+ days past due: Invoices that are unlikely to be collected.

The aging report tells you two things: how much is outstanding in total, and how the outstanding amount is distributed across time. A healthy AR portfolio has most of its balance in the current bucket. An unhealthy one has a growing percentage in the older buckets.

How to Read an Aging Report

Look at the distribution, not just the total. If your total AR is $100,000 and 80% is current, your collection process is working. If your total AR is $100,000 and 40% is over 60 days past due, you have a collection problem.

Calculate the percentage in each bucket:

• Current: ideally 70-80% or more
• 1-30 days: ideally 10-15%
• 31-60 days: ideally 5-10%
• 61-90 days: ideally less than 5%
• 90+ days: ideally less than 3%

If any bucket exceeds these guidelines, investigate why. Are the unpaid invoices concentrated in certain customers? Certain products? Certain time periods? Patterns in the aging report point to the root cause.

Why Invoices Go Unpaid

Invoices go unpaid for many reasons, and not all of them indicate a problem:

1. Customer Cash Flow Issues

The customer may be experiencing their own cash flow problems and is delaying payment to manage their own liquidity. This is common in B2B relationships where payment terms are 30 or 60 days. The customer intends to pay but is prioritizing other obligations.

2. Invoice Errors

The customer may not have paid because the invoice contains an error—wrong amount, wrong billing address, missing purchase order number, or incorrect line items. In many cases, the customer does not notify you of the error; they simply set the invoice aside. This is a process failure on your side, not a customer payment problem.

3. Disputed Charges

The customer may dispute the charges—either the amount, the scope of work, or the quality of delivery. Disputed invoices often go unpaid until the dispute is resolved. If your business does not have a process for identifying and resolving disputes quickly, disputed invoices can sit unpaid for months.

4. Lost or Overlooked Invoices

The customer may have simply lost the invoice or overlooked it in their email inbox. This is common with email-delivered invoices. If you do not follow up with a reminder, the invoice may remain unpaid indefinitely.

5. Payment Method Failures

For recurring billing, the payment method on file may have expired, been cancelled, or been declined. The invoice is generated but the payment fails. Without an effective retry and notification process, the invoice goes unpaid and the customer may not even realize it.

6. Intentional Non-Payment

A small percentage of customers may intentionally avoid payment. This is the most difficult category to collect, and it may require escalation to a collection agency or legal action. However, it is important not to assume all unpaid invoices fall into this category—most do not.

How to Investigate Unpaid Invoices

Step 1: Pull the Aging Report

Start with the full aging report. Sort by oldest first—the invoices in the 90+ day bucket deserve immediate attention. They are the most likely to become permanent losses.

Step 2: Categorize by Reason

For each invoice in the 60+ day buckets, determine the reason it is unpaid. Contact the customer if necessary. Categorize each as:

• Customer cash flow delay
• Invoice error (your fault)
• Disputed charge (needs resolution)
• Lost/overlooked (needs follow-up)
• Payment method failure (needs update)
• Intentional non-payment (needs escalation)

Step 3: Prioritize by Amount and Age

Not all unpaid invoices deserve the same effort. Prioritize by a combination of amount and age. A $50,000 invoice that is 45 days past due is more urgent than a $500 invoice that is 120 days past due. But a $500 invoice that is 120 days past due is more likely to be a permanent loss.

Step 4: Take Action by Category

• Customer cash flow delay: Negotiate a payment plan. Partial payment is better than no payment.
• Invoice error: Correct the invoice immediately and resend. Follow up to confirm receipt.
• Disputed charge: Engage the customer to understand the dispute. Resolve it quickly or escalate internally.
• Lost/overlooked: Resend the invoice with a personal note. Follow up by phone if it is a large amount.
• Payment method failure: Contact the customer to update their payment method. For recurring billing, automate this process.
• Intentional non-payment: Send a final demand letter. If no response, escalate to a collection agency or legal action.

Step 5: Calculate the Expected Loss

For each invoice in the 90+ day bucket, estimate the probability of collection. A common rule of thumb:

• 90-120 days: 50% probability of collection
• 120-180 days: 25% probability
• 180+ days: 10% probability

Multiply the outstanding amount by the probability to estimate the expected loss. This gives you a realistic picture of how much of your AR is genuinely collectible.

Improving the Collection Process

Investigating unpaid invoices is reactive. Preventing them is proactive. The following practices can reduce the volume of unpaid invoices over time:

1. Invoice Accurately and Promptly

The most common reason invoices go unpaid is that they contain errors or are sent late. Review your invoicing process for accuracy. Send invoices immediately after delivery, not at the end of the month.

2. Send Reminders Before the Due Date

Do not wait until an invoice is past due to follow up. Send a friendly reminder 3-5 days before the due date. This catches lost or overlooked invoices before they become past due.

3. Offer Multiple Payment Methods

Make it easy for customers to pay. Accept credit cards, ACH, and online payment portals. The fewer steps between receiving the invoice and making the payment, the faster you will collect.

4. Track Days Sales Outstanding (DSO)

DSO measures the average time it takes to collect an invoice. Track it monthly. An increasing DSO is an early warning sign that your collection process is weakening.

5. Establish a Collections Cadence

Define a standard sequence of follow-up actions:

• 3 days before due: friendly reminder
• 1 day after due: payment confirmation request
• 7 days after due: follow-up email with invoice attached
• 15 days after due: phone call
• 30 days after due: final demand letter
• 60 days after due: escalate to collection agency

6. Require Credit Checks for Large Orders

For large orders or new customers, require a credit check before extending payment terms. This reduces the risk of non-payment from customers who are already in financial difficulty.

Key Formulas

Days Sales Outstanding (DSO) = (Accounts Receivable ÷ Total Credit Sales) × Number of Days in Period

Bad Debt Ratio = Bad Debt Write-Offs ÷ Total Credit Sales × 100

Collection Effectiveness Index (CEI) = (Beginning AR + Credit Sales − Ending AR) ÷ (Beginning AR + Credit Sales − Ending Current AR) × 100

The CEI measures how effective your collection process is at collecting receivables that are actually collectible. A CEI above 80% is generally considered good.

Distinguishing Delays from Losses

Not all unpaid invoices are losses. Some are simply delayed. The key is to distinguish between:

• Temporary delays: The customer intends to pay but has not yet. These are not losses—they are timing differences.
• Disputes: The customer has a legitimate objection to the charge. These need resolution, not collection.
• Permanent losses: The customer cannot or will not pay. These should be written off and removed from AR.

Only permanent losses represent revenue leakage. But temporary delays become permanent losses if they are not followed up. The longer an invoice goes unpaid, the higher the probability it will never be collected. This is why a consistent collection cadence is essential.

When Software May Help

For businesses with a large number of invoices or customers, manual collection follow-up may be impractical. Accounts receivable automation software can:

• Automatically send reminders on a defined schedule
• Track DSO and aging in real time
• Flag high-risk accounts for personal follow-up
• Automate payment plan management
• Integrate with payment processors for automatic retry of failed payments

For subscription businesses, dunning management software is essential for recovering failed payments before they become permanent losses. See our guide to subscription revenue leakage.

For a broader discussion of recovery tools, see our guide to revenue recovery software.

Related Topics

• Revenue reconciliation: How to compare sales, invoices, and deposits
• Payment processing discrepancies: Why recorded sales may not match deposits
• Cash flow problems: How unpaid invoices affect cash flow
• Internal revenue controls: How to prevent billing errors and unauthorized adjustments

Summary

Unpaid invoices are one of the most common forms of revenue leakage, but they are also one of the most actionable. By reading the aging report, categorizing unpaid invoices by reason, and following a consistent collection cadence, you can recover a significant percentage of outstanding receivables and prevent future invoices from going unpaid.

The key is to act early. The probability of collecting an invoice decreases with every day it remains unpaid. A structured collection process—combined with accurate invoicing, proactive reminders, and multiple payment options—can reduce unpaid invoices and improve your cash flow.

If you want to assess how much of your revenue may be tied up in unpaid invoices, the Recoupant revenue assessment can help you identify potential collection gaps.

Frequently Asked Questions

How long should I wait before pursuing unpaid invoices? Do not wait. Send a reminder before the due date and follow up immediately after. The probability of collection drops significantly after 60 days. For large invoices, follow up by phone within 7 days of the due date.

What is the difference between bad debt and unpaid invoices? Unpaid invoices are outstanding receivables that have not yet been collected. Bad debt is the portion of unpaid invoices that you have determined will never be collected and have written off. Not all unpaid invoices become bad debt—many are collected with proper follow-up.

When should I write off an invoice as uncollectible? There is no fixed rule, but invoices over 180 days past due with no response to multiple collection attempts are generally candidates for write-off. Consult your accountant for the specific write-off policy that is appropriate for your business and tax situation.

Should I use a collection agency? For invoices that are 60-90 days past due with no response to your own collection efforts, a collection agency may be appropriate. Collection agencies typically charge a percentage of the amount collected (20-40%). Weigh the cost against the amount outstanding and the probability of collection.

How do I improve my collection process without damaging customer relationships? Start with friendly reminders, not demands. Assume the customer overlooked the invoice, not that they are refusing to pay. Offer payment plans for customers experiencing cash flow problems. Personalize follow-up for large accounts. Escalate tone gradually, not immediately.