An overdue-invoice report tells you who owes money, but not which balance to investigate first. This 15-minute review checks the report, compares it with the last period, and assigns follow-up owners.
Quick answer: Review overdue invoices in five passes: validate the report, compare it with the previous period, measure customer concentration, prioritize exceptions, and document the next action. Do not treat the total A/R balance as cash that is certain to arrive.
Need a reusable output instead? See the A/R aging and collections workbook guide.
What the 2026 late-payment data tells us
The 2026 QuickBooks Small Business Late Payments Report found:
| Finding from surveyed businesses | Why it matters during an A/R review |
|---|---|
| 59% had invoices overdue by 30 days or more | Late receivables are common enough to require a consistent review process. |
| Affected businesses were owed $17,700 on average | A material amount may sit outside available cash. |
| 39% said one late payment made payroll or bills difficult | One invoice can matter even when total revenue looks healthy. |
| 49% said normal processing times created moderate or critical cash-flow gaps | A customer payment and usable cash are not always the same event. |
The report also found that 51% of businesses with overdue invoices considered cash flow a problem, versus 36% without overdue invoices. That association does not show that overdue invoices caused a particular business to borrow or miss a payment. Check its actual terms, disputes, credits, and cash needs.
Start with the right QuickBooks reports
QuickBooks provides two core accounts-receivable aging views:
- A/R Aging Summary shows the outstanding balance for each customer across aging buckets.
- A/R Aging Detail shows the invoices and other transactions behind those customer balances.
QuickBooks’ report guide explains how to run both. Also use, as needed:
- an Open Invoices view for the current operational list;
- the Balance Sheet or Trial Balance for the A/R control-account total; and
- the prior month’s aging report or prior saved review for comparison.
Use the same company, report date, aging method, accounting basis, currency, and filters when comparing reports. QuickBooks’ matching guidance specifically calls out report-date aging, matching dates, and accrual basis for comparison with the Balance Sheet or Trial Balance.
The menu labels and available options can change. Confirm the current QuickBooks interface and the company’s subscription before documenting a firm-wide procedure.
The 15-minute overdue-invoice review
Fifteen minutes is a target for a routine review. A mismatch, dispute, or unusual credit may take longer.
Minute 0–3: validate before interpreting
Begin by confirming what the report actually represents:
- correct client or company;
- intended as-of date;
- correct aging method;
- expected accounting basis;
- relevant currency, customer, class, or location filters; and
- complete access to the transactions needed for the report.
Then perform a reasonableness check. Does total A/R agree with the corresponding Balance Sheet or Trial Balance amount when the reports use compatible settings?
If it does not, stop treating the aging report as a collection list until you understand the difference. A mismatch can arise from the report date or aging method, but it may also point to incomplete transaction links or other bookkeeping issues.
Look for visible exceptions too:
- customer rows with a zero net balance;
- unapplied payments or credits;
- negative customer balances;
- duplicate-looking invoices;
- missing or implausible invoice dates;
- balances posted to an unexpected customer; and
- old amounts that have not moved for several reviews.
QuickBooks has separate guidance for clearing customers with zero net balances. Do not make corrections merely to make the report look cleaner. Verify the underlying invoice, payment, and credit before changing the books.
Minute 3–6: find what changed
A static ending balance tells you less than movement between reviews. Compare the current A/R aging with the previous month or week and identify:
- invoices that became overdue for the first time;
- balances that moved into 31–60, 61–90, or 90+ days;
- customers whose total overdue balance increased;
- payments or credits applied since the last review;
- invoices that disappeared from the report; and
- old balances that remain unchanged.
For each material change, record the amount, aging bucket, prior position, and known explanation. If the explanation is not in the books or existing review notes, mark it as a question rather than inventing one.
Minute 6–9: measure concentration and timing risk
Now separate four signals that are often confused:
- Largest balance: the customer representing the most overdue dollars.
- Oldest balance: the invoice that has remained unpaid the longest.
- Fastest-growing exposure: the customer whose overdue total or invoice count is increasing most quickly.
- Most immediate cash concern: the balance whose delay matters most given near-term obligations and available cash.
Calculate the largest customer’s share of total overdue A/R:
Customer overdue balance ÷ total overdue A/R × 100
For example, a customer with $20,000 of a $48,000 overdue balance represents approximately 41.7% of the exposure. That concentration deserves attention even if the invoice only became overdue last week.
Concentration is not collectability. The report may not show a dispute, payment promise, mailed check, or misapplied credit. Verify those separately.
Minute 9–12: assign a review priority
Use a consistent decision table instead of sorting only by amount or days overdue.
| Signal | Question to answer | Review priority |
|---|---|---|
| Large balance in the 90+ bucket | Is there a dispute, payment commitment, credit, or escalation owner? | Immediate human review |
| Several aging invoices for one customer | Is exposure becoming more concentrated? | High |
| A normally prompt customer becomes overdue | Is this a one-time delay, delivery issue, or bookkeeping error? | Medium |
| Negative or zero-net customer balance | Was a payment or credit applied correctly? | Bookkeeping check first |
| Old balance with a documented dispute | Who owns the next action, and when is the status reviewed? | Track by agreed status |
| Large invoice newly overdue | Does its size create a near-term cash concern despite its age? | Context-dependent |
This is a review framework, not a legal collection policy. The company’s contract, payment terms, customer relationship, internal controls, and professional advice should determine the actual response.
Minute 12–15: prepare the explanation
End with four points:
- What changed: the new overdue amount and movement between aging buckets.
- Where exposure is concentrated: the customers or invoices driving the result.
- What needs verification: report differences, credits, disputes, or missing context.
- Who owns the next action: the person responsible and the next review date.
Worked example: the largest invoice is not always first
Consider a fictional company with $48,000 of overdue A/R. Every customer, amount, percentage, and status in this example was created by MosoFin solely to demonstrate the review method; none comes from a customer file or the QuickBooks survey.
| Customer | Balance or exception | Status | What the report suggests |
|---|---|---|---|
| Atlas Studio | $20,000 | 7 days overdue | Largest concentration: 41.7% of overdue A/R |
| Northstar Supply | $6,000 | 97 days overdue | Oldest named balance; dispute status unknown |
| Riverbend Group | $9,000 | Four invoices across 31–90 days | Exposure and invoice count have grown for two periods |
| Cedar Works | $2,000 credit exception | Customer row nets to zero | Verify whether the credit and payment were applied correctly |
| Other customers | $13,000 | Mixed recent balances | Review according to amount, age, and history |
Sorting by amount alone puts Atlas first. Sorting by age puts Northstar first. Looking at trend highlights Riverbend. Testing report reliability sends Cedar Works to the bookkeeper before anyone contacts the customer.
A sound sequence could be:
- verify the Cedar Works credit so the operational list is reliable;
- confirm Northstar’s dispute and ownership status;
- review Riverbend’s growing exposure and multiple invoices;
- assess whether Atlas’s concentration creates a near-term cash concern; and
- document the remaining balances for the next scheduled review.
The sequence is based on review needs—not a prediction about which customer will pay.
Where MosoFin fits in the workflow
QuickBooks remains the accounting system. It stores the invoices, payments, credits, customer balances, and reports used in the review.
MosoFin adds a separate, read-only workspace for supported QuickBooks data. Reviewers can ask what changed, inspect the result, and reuse the review method in a supported AI app.
| Part of the workflow | QuickBooks | MosoFin | Human owner |
|---|---|---|---|
| Store invoices, payments, and credits | Yes | No | Bookkeeper validates entries |
| Produce accounting data and reports | Yes | Reads supported data | Reviewer chooses the relevant view |
| Compare and explain a supported result | Source data | Read-only assistance in a supported AI app | Professional verifies the conclusion |
| Correct a payment, credit, date, or customer | Authorized QuickBooks user | Never writes to the books | Authorized bookkeeper or accountant |
| Contact a late-paying customer | May provide invoicing/reminder features | Does not perform collections | Business or collections owner |
| Approve policy or escalation | No | No | Management and qualified advisers |
MosoFin does not change the books, send collection notices, or make payments. An authorized person handles those actions in the appropriate system.
Learn how MosoFin works and about its read-only access and activity history.
Make the review repeatable
Record the as-of date and report settings, comparison period, exceptions, action owner, due date, and evidence. For firms managing several companies, keep each client’s questions, access, and conclusions separate. See the guide to connecting multiple QuickBooks companies to Claude and building repeatable QuickBooks report workflows.
Frequently asked questions
How do I find overdue invoices in QuickBooks Online?
Run an A/R Aging Summary for customer-level balances and aging buckets. Use A/R Aging Detail when you need the individual invoices and transactions behind those balances. Confirm the current navigation in QuickBooks because menus can change.
What is the difference between A/R Aging Summary and A/R Aging Detail?
The summary groups outstanding balances by customer and age. The detail report shows the transactions that make up those balances. Start with the summary to find concentration, then use the detail report to investigate specific invoices, payments, or credits.
Why might an A/R aging report not match the Balance Sheet?
QuickBooks identifies inconsistent report dates, aging methods, accounting bases, or comparison settings as common causes. Use compatible dates and select the appropriate report-date aging method before assuming the books are wrong. Escalate an unexplained difference for bookkeeping or accounting review.
Should I review the oldest or the largest overdue invoice first?
Review priority should consider amount, age, customer concentration, growth, dispute status, data quality, payment history, and near-term cash needs. The oldest balance and the largest balance are not always the same risk.
Does an overdue invoice count as available cash?
No. Accounts receivable represents amounts owed, not cash already available to spend. Payment timing, processing time, credits, disputes, and collectability can all affect when—or whether—the amount becomes usable cash.
Can MosoFin send reminders or correct an overdue invoice?
No. MosoFin is a read-only reporting and review layer. It does not contact customers or write changes into QuickBooks. Authorized people remain responsible for corrections, communications, decisions, and sign-off.
See how MosoFin works or start with one read-only connection.
This article is for general information and is not accounting, tax, legal, or collection advice. QuickBooks and Intuit are trademarks of Intuit Inc. MosoFin is an independent product and is not affiliated with or endorsed by Intuit. Product features and report navigation can change; verify current behavior before relying on it.
