QuickBooks Overdue Invoices: 15-Minute Review

QuickBooks overdue invoices are easy to list. The harder part is deciding which balance needs attention, whether the report is reliable, and how the delay could affect cash.

That distinction matters more than ever. In its 2026 Small Business Late Payments Report, QuickBooks says 59% of surveyed businesses had invoices overdue by at least 30 days, up from 47% in the prior-year comparison. The same report says businesses carrying overdue invoices were owed $17,700 on average.

This guide turns those findings into a repeatable 15-minute review for bookkeepers, accounting firms, fractional CFOs, and owners. You will validate the report, find what changed, identify concentration and timing risk, assign a review priority, and prepare a plain-language explanation.

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.

Which guide do you need? This one walks the review: finding and prioritizing overdue invoices and deciding what needs attention. If you want to build a structured, reusable A/R aging and collections workbook as a review output, see the companion guide: an A/R aging and collections workbook from QuickBooks data.

What the 2026 late-payment data tells us

The QuickBooks report follows the path from invoice sent to payment received and, finally, to cash available for use. The four survey findings below show why an accounts-receivable review should go beyond a total balance.

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 research also reports that 51% of businesses with overdue invoices considered cash flow a problem, compared with 36% of those without overdue invoices. Businesses with late receivables were also more likely to report increased credit-card reliance and delayed outgoing payments.

These are associations in survey data—not proof that every overdue invoice causes borrowing or a missed vendor payment. Your review still needs context: customer history, disputes, credits, payment terms, the reliability of the bookkeeping data, and the company’s current obligations.

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’ current accounts-receivable aging guidance recommends the summary for a high-level view and the detail report when you need to see which transactions are past due.

For a dependable review, you may also need:

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 says the Balance Sheet, Trial Balance, and A/R aging reports should agree when they are configured consistently. Its aging-report matching guidance specifically calls out the report date, aging method, accrual basis, and matching date ranges.

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

The timing is a practical target, not a promise. A clean, familiar file may take less time. A mismatch, dispute, foreign-currency balance, or unusual credit may require a longer investigation.

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.

Movement answers a better question than “How much is overdue?” It tells you whether the problem is improving, spreading, or concentrating.

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.

They may point to four different customers.

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.

But concentration is not collectability. An aging report does not tell you whether a customer disputes the invoice, has promised a payment date, mailed a check, received the work, or has a credit that was recorded incorrectly. It identifies where judgment and follow-up are needed.

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 the review with four statements:

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.

A fictional client note might read:

Overdue A/R increased by $8,500 this month. Two customers account for 63% of the total, and one $6,000 balance moved into the 90+ day bucket. Before the owner follows up, the bookkeeper needs to verify a $2,000 customer credit and confirm whether the oldest invoice is disputed. The owner will review the two confirmed balances by Friday, and we will compare the aging again next week.

That explanation is more actionable than sending an aging report with no context.

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	Overdue balance	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 financial-data workspace inside Claude. For supported QuickBooks data, bookkeepers, accounting firms, and fractional CFOs can ask what changed, inspect a result, prepare a plain-language explanation, and reuse the same review method later.

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 inside Claude	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

The product boundary is deliberate. MosoFin does not replace QuickBooks, write journal entries, apply customer payments, send collection notices, make bill payments, file taxes, or run payroll. It helps teams get from financial data to a reviewable explanation without giving an agent permission to change the books.

You can learn more about how MosoFin works inside Claude and its read-only access and activity history.

Turn the review into a reusable workflow

A strong overdue-invoice process should produce comparable results every time. Standardize:

the review day and as-of date;
report settings and aging method;
materiality or prioritization guidelines;
data-quality checks;
comparison period;
client-note format;
action owner and due date; and
evidence retained with the review.

For firms managing several companies, keep each client’s questions, data access, and conclusions separate. See MosoFin’s guide to connecting multiple QuickBooks companies to Claude and the broader process for building repeatable QuickBooks report workflows.

The goal is not to automate professional judgment. It is to stop rebuilding the mechanical parts of the review so the professional can spend more time on exceptions, explanations, and decisions.

Copyable QuickBooks overdue-invoice checklist

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.

The bottom line

An overdue-invoice report is a starting point, not a conclusion. In 15 minutes, a reviewer can validate the data, compare movement, measure concentration, prioritize exceptions, and prepare a clear explanation. Anything unusual can then receive the time and professional judgment it deserves.

QuickBooks keeps the books. MosoFin helps financial professionals review and explain supported QuickBooks data in a separate, read-only workspace inside Claude—so the same method can be reused without turning analysis into uncontrolled action.

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.