QuickBooks Accounts Receivable: How to Track Unpaid Invoices and Get Paid Faster
Published By IndiaBizExperts | Reviewed by Authorized Chartered Accountant: CA Unit Kr Jha
Unpaid customer invoices can create cash-flow pressure for a small business—even when sales are strong. If you use QuickBooks Online, its invoice tracking and accounts receivable reports can help you see which customers owe money, which invoices are overdue, and how long balances have remained unpaid.
However, sending an invoice is only one step in the payment process. You also need accurate invoice details, clear payment terms, consistent follow-up, and a reliable process for recording payments and investigating discrepancies.
This guide explains how accounts receivable works in QuickBooks Online, how to review unpaid invoices and aging reports, how to follow up professionally, and how to avoid common errors that can make customer balances misleading.
Table of Contents
1. What Is Accounts Receivable in QuickBooks?
Accounts receivable (A/R) represents money customers owe a business for goods or services that have been invoiced but not yet paid, generally under accrual-based accounting.
In QuickBooks Online, creating an invoice records the amount the customer owes and posts the transaction to the accounts receivable account. When the customer pays, the payment must be recorded and applied appropriately to the invoice.
A typical accounts receivable process includes:
- Creating an invoice with accurate customer, amount, and due-date information.
- Sending the invoice and confirming the customer can access it.
- Tracking the invoice's status and outstanding balance.
- Following up when payment is approaching or past due.
- Recording received payments and applying them to the correct invoices.
- Investigating credits, short payments, duplicate entries, or disputed amounts.
- Reviewing aging reports to identify older outstanding balances.
QuickBooks provides invoice statuses and reports that can help track this process. Available features and screen layouts may vary by subscription and interface version. See the official QuickBooks guide to understanding invoices.
2. Why Accounts Receivable Management Matters
Sales revenue does not always mean cash has been received. When customers pay after the invoice date, the business must manage the gap between delivering goods or services and collecting the money.
Consistent accounts receivable management can help you:
- See how much money customers owe.
- Identify overdue balances before they become significantly older.
- Prioritize collection follow-ups.
- Detect invoices that may be disputed or incorrectly recorded.
- Prepare more informed short-term cash-flow forecasts.
- Provide clearer information to a bookkeeper or accountant.
Accounts receivable is not the same as available cash. An invoice may appear as outstanding even though the customer has initiated a payment that has not yet been matched or recorded correctly. Likewise, a customer may dispute an invoice or request a correction before paying it.
For a broader understanding of how financial reports help explain business performance, see QuickBooks Profit and Loss Report: How to Read It, Find Errors, and Improve Accuracy. Verify the internal link before publishing.
3. How to Find Unpaid Invoices in QuickBooks Online
The exact labels and navigation may vary across QuickBooks Online versions, but you can generally locate unpaid invoices through the sales or invoicing area and through reports.
Method 1: Review invoices in the sales or invoicing area
- Sign in to the correct QuickBooks Online company.
- Open the Sales or Invoicing area, depending on your interface.
- Open the invoice list.
- Filter or review invoices by their payment status, such as unpaid or overdue, where available.
- Open an invoice to check its date, due date, total, recorded payments, and remaining balance.
- Investigate any invoice that appears unpaid despite the customer having paid.
Method 2: Run an Open Invoices report
- Open the Reports section.
- Search for the Open Invoices report, if available in your subscription.
- Set the relevant report date or period.
- Run the report and review outstanding invoices.
- Open individual transactions to investigate older or unexpected balances.
The Open Invoices report can be useful for reviewing individual outstanding invoices, while aging reports help organize balances by how long they have remained unpaid.
Method 3: Review customer balances
Customer balance reports can help identify customers with outstanding amounts. Review the underlying invoice and payment details before contacting a customer, especially if credits, partial payments, or disputed amounts may be involved.
For official instructions on tracking customer balances and aging information, see QuickBooks: How to Track What Customers Owe You.
4. How to Run an Accounts Receivable Aging Report
An accounts receivable aging report groups outstanding customer balances according to how long they have remained unpaid or overdue. It can help you identify which balances may need follow-up first.
Steps to run the report
- Open Reports in QuickBooks Online.
- Go to the standard reports area, if applicable.
- Search for Accounts receivable aging summary.
- Choose the appropriate report date and aging options.
- Run the report and review the outstanding balances by customer and aging period.
- Open the Accounts receivable aging detail report if you need to examine individual invoices, where available.
- Investigate large, old, or unexpected balances before deciding on the next action.
QuickBooks offers summary and detail versions of the aging report. The summary provides an overview of balances, while the detail report can help identify the invoices contributing to each balance. Report availability can depend on the subscription.
Read the official instructions: Run an accounts receivable aging report in QuickBooks Online.
5. How to Interpret Invoice Aging Categories
Many aging reports group balances into time bands such as current, 1–30 days, 31–60 days, 61–90 days, and more than 90 days. The exact categories depend on the report settings.
| Aging category |
What to review |
Possible next step |
| Current or not yet due |
Confirm the invoice was sent and payment terms are correct. |
Send a polite reminder before the due date if appropriate. |
| 1–30 days overdue |
Check whether the customer received the invoice and whether there is a payment update. |
Send a clear follow-up with the invoice attached or linked. |
| 31–60 days overdue |
Check for disputes, missing purchase-order details, or processing delays. |
Contact the customer to agree on a payment status and next step. |
| 61–90 days overdue |
Review previous communications, promises to pay, and any unresolved issue. |
Escalate the follow-up according to your business policy. |
| More than 90 days overdue |
Assess collectability, documentation, dispute status, and potential financial impact. |
Consider appropriate management or professional advice before taking further action. |
These are practical review bands, not legal deadlines or universal collection rules. The right approach depends on your contract, customer relationship, applicable law, and the facts of the invoice.
Important: Check the aging method
Depending on the report, aging can be calculated relative to the current date or a selected report date. The method can affect which period a balance appears in.
If you are comparing reports, ensure that the report date and aging method are consistent. QuickBooks explains how to configure aging reports and investigate differences in its guide to matching aging reports.
6. How to Follow Up on Overdue Invoices
A consistent, professional follow-up process can help resolve forgotten invoices, administrative delays, and misunderstandings. It cannot guarantee that a customer will pay, but it can make the outstanding balance and required next step clearer.
Step 1: Verify the invoice first
Before contacting the customer, confirm the invoice number, amount, due date, payment terms, and outstanding balance. Check whether a payment, credit, refund, or adjustment has already been recorded.
Step 2: Make sure the invoice was delivered
Confirm that the invoice was sent to the correct contact and that any required purchase-order number, supporting document, or billing detail was included.
Step 3: Send a clear reminder
Include the invoice number, invoice date, amount due, due date, payment instructions, and a way for the customer to raise a question. Keep the tone professional and factual.
Step 4: Ask about unresolved issues
If the customer has not paid, ask whether there is a billing dispute, missing document, approval delay, or other obstacle. Record the agreed next step and follow-up date.
Step 5: Escalate consistently
For older balances, follow your company's credit and collection policy. Depending on the circumstances, this may involve management review, pausing additional credit, or seeking professional advice. Consider contractual obligations and applicable laws before taking restrictive or legal action.
Example reminder email
Subject: Payment reminder — Invoice [Invoice Number]
Hello [Customer Name],
I’m following up on invoice [Invoice Number] for [Amount], which was due on [Due Date]. Our records currently show an outstanding balance of [Balance].
Could you please confirm the expected payment date? If you have already paid or need any additional documentation, please let us know so we can update our records.
Thank you,
[Your Name]
[Business Name]
Check the invoice and customer account before sending any reminder. Replace the bracketed placeholders with accurate information.
7. A Practical Accounts Receivable Workflow
A repeatable workflow makes it easier to identify outstanding invoices and decide what action is needed.
- Issue invoices promptly. Use accurate customer information, clear descriptions, payment terms, and due dates.
- Review invoice status regularly. Check for invoices that remain unpaid or overdue.
- Run an aging report. Identify balances by customer and age.
- Prioritize follow-ups. Consider the amount, age, customer communication, and business policy.
- Record all received payments. Apply payments to the correct invoices and investigate partial or unmatched payments.
- Review credits and disputes. Make sure credit memos and adjustments are appropriately documented.
- Reconcile relevant accounts. Investigate differences between accounting records and bank activity.
- Review unresolved balances with management. Decide whether further follow-up, a payment arrangement, or professional advice is appropriate.
8. Practical Example: Reviewing Overdue Invoices
Imagine a fictional US design agency that has the following outstanding invoices:
| Customer |
Outstanding balance |
Days past due |
Suggested review action |
| Customer A |
$1,200 |
8 days |
Confirm receipt and send a polite reminder. |
| Customer B |
$4,500 |
38 days |
Check for approval delays or a billing dispute; agree on a follow-up date. |
| Customer C |
$2,100 |
76 days |
Review the communication history and escalate under the business's collection policy. |
| Customer D |
$900 |
Not yet due |
Confirm the invoice details and monitor the due date. |
The agency has $8,700 in outstanding invoices in this simplified example. That figure is not the same as cash immediately available, and the business should not assume all balances will be collected on the same date.
The aging report helps the agency prioritize its work. Customer B has the largest outstanding balance, while Customer C has the oldest overdue invoice. The owner can review both according to amount, age, customer circumstances, and internal policy.
The next step is to verify the invoice details and payment status before contacting either customer. If a customer has already paid but the payment has not been applied correctly in QuickBooks, the account should be investigated rather than treated as an ordinary overdue invoice.
9. Common QuickBooks Accounts Receivable Errors
Paid invoices still appear as unpaid
This may happen if a payment was recorded but not applied to the correct invoice, the payment date falls outside the report period, or the report settings are inconsistent. Review the invoice, payment, and transaction links before making changes.
QuickBooks documents possible causes and troubleshooting steps in its article about paid invoices that still appear in open transaction reports.
Customer payments are not applied to invoices
A payment may exist in the books without reducing the intended invoice balance. Review the payment details and apply the payment correctly when supported by the underlying records.
Duplicate invoices or payments
Duplicate entries can inflate the amount customers appear to owe or create incorrect balances. Check invoice numbers, dates, amounts, and transaction history before deleting or changing entries.
Credits are not applied correctly
A credit memo or customer credit may affect the outstanding balance. Verify the reason for the credit and apply it according to the underlying transaction and your accounting process.
Invoice dates or terms are incorrect
Incorrect dates or payment terms can make an invoice appear overdue too early or too late. Check the customer agreement and invoice documentation before correcting the record.
Report dates or aging settings differ
Two reports can show different aging results if they use different report dates or aging methods. Confirm the settings before assuming that the customer balance is incorrect.
Payments are recorded in the wrong account
If a payment or deposit is recorded incorrectly, the customer balance and bank records may not agree. Review the transaction history and supporting documentation before making a correction.
Do not write off an invoice or create an unexplained adjustment simply to clear an old balance. If a debt may be uncollectible, consult an appropriately qualified accounting or tax professional about the correct treatment for your circumstances.
10. How to Improve Collections and Cash-Flow Visibility
These practices can help create a more consistent invoicing and collection process.
Set clear payment terms
State when payment is due, accepted payment methods, and how customers should raise billing questions. Make sure the terms are consistent with your agreement and applicable requirements.
Invoice promptly and accurately
Send invoices when contractually appropriate and include the information the customer needs to process payment. Correcting avoidable billing errors can reduce unnecessary delays.
Use a regular follow-up schedule
Choose a schedule suited to your business and customer agreements. Track the date of each reminder, the response, and the next action.
Monitor the aging report
Review older and larger balances routinely. A report is most useful when someone is responsible for investigating and following up on the items it identifies.
Record payments consistently
Apply payments to the right invoices and review unmatched transactions. This helps prevent customers who have paid from receiving inaccurate reminders.
Forecast cash conservatively
Use expected collection dates as estimates, not guarantees. Consider the customer's payment history, disputed amounts, contractual terms, and the age of the invoice when estimating when cash may arrive.
Keep records of communication
Retain invoices, payment confirmations, customer correspondence, and any agreed payment arrangements. Good documentation supports internal review and helps resolve disagreements.
11. Monthly Accounts Receivable Checklist
- Review open and overdue invoices.
- Run the accounts receivable aging summary report.
- Review invoice-level details for older balances.
- Confirm that recorded payments are applied to the correct invoices.
- Investigate unapplied payments and credits.
- Check for duplicate invoices and inaccurate due dates.
- Send reminders according to your follow-up policy.
- Document customer responses and promised payment dates.
- Review potentially disputed or uncollectible balances.
- Compare the aging report with relevant financial reports using consistent dates and settings.
- Escalate unresolved accounting issues when appropriate.
Good recordkeeping helps businesses monitor operations, prepare financial statements, track income and expenses, and support tax reporting. See the IRS recordkeeping guidance for small businesses.
12. When to Seek Professional Bookkeeping Support
You may benefit from help from an independent bookkeeping or accounting professional if:
- Many invoices remain overdue and the follow-up process is inconsistent.
- Customer balances do not match the underlying invoices and payments.
- Payments or credits have been recorded but not applied correctly.
- Your accounts receivable aging report does not agree with related financial reports.
- Historical balances require investigation.
- You need a repeatable month-end process for invoicing, collections, and reconciliation.
- You need support preparing records for an accountant or tax professional.
Before hiring a provider, confirm the exact work included, their relevant experience, the reporting frequency, data access arrangements, fees, and how unresolved discrepancies will be handled.
Need help finding independent professional support? IndiaBizExperts is a facilitation platform that helps users connect with independent professionals. You can submit a request through IndiaBizExperts to explore a connection. The independent professional determines the agreed services, qualifications, availability, and fees.
13. Frequently Asked Questions
1. What is accounts receivable in QuickBooks Online?
Accounts receivable represents money customers owe for invoiced goods or services that have not yet been paid. QuickBooks can track invoices and customer payments when transactions are recorded and applied correctly.
2. How do I find unpaid invoices in QuickBooks?
Review the invoice list in the sales or invoicing area, filter by payment status where available, or run an Open Invoices report. Check the invoice details before following up.
3. What is an accounts receivable aging report?
It groups outstanding customer balances by how long they have remained unpaid or overdue. It helps businesses identify older balances and prioritize review and follow-up.
4. Why does QuickBooks show an invoice as unpaid after the customer paid?
The payment may not have been recorded, may not have been applied to the correct invoice, or may have a date or reporting issue. Review the invoice and payment transaction details before making a correction.
5. How often should I review accounts receivable?
Many small businesses review open invoices and aging reports weekly or monthly, depending on invoice volume and payment terms. Businesses with high transaction volumes or tight cash-flow requirements may need more frequent monitoring.
6. What do 30-, 60-, and 90-day overdue invoices mean?
These labels generally describe how long an invoice has been overdue, depending on the report's settings. They help prioritize follow-up but are not universal legal deadlines.
7. Should I write off an old unpaid invoice?
Not simply because it is old. First review the invoice, collection history, disputes, credits, and likelihood of collection. Seek qualified accounting or tax advice before writing off a balance, as the appropriate treatment depends on the facts and applicable rules.
8. Does an unpaid invoice mean my business has cash available?
No. An unpaid invoice represents an amount owed, not cash already received. Actual collection timing may differ from the due date, and some invoices may be disputed or uncollectible.
9. Can QuickBooks send invoice reminders?
QuickBooks Online includes invoice and reminder features that vary by product and configuration. Review the current settings and verify that the reminder content, recipient, and timing are appropriate before using them.
10. Does IndiaBizExperts directly collect unpaid invoices for businesses?
IndiaBizExperts is a facilitation platform that helps users connect with independent professionals. It does not itself provide debt collection or accounting services. Confirm the independent professional's scope, qualifications, fees, and terms before engagement.
14. Conclusion
Managing accounts receivable in QuickBooks Online involves more than creating invoices. Businesses also need to monitor payment status, review aging reports, apply customer payments correctly, investigate discrepancies, and follow up consistently.
A regular process can help you identify overdue balances earlier and make more informed cash-flow decisions. When reports do not agree or old balances cannot be explained, investigate the underlying transactions before making adjustments.
Looking for independent bookkeeping support? Submit a request through IndiaBizExperts to explore a connection with an independent professional. Confirm the provider's qualifications, services, fees, and terms before proceeding.
Editorial note: This article is for general educational purposes only and does not constitute accounting, tax, legal, or financial advice. QuickBooks features may vary by subscription and interface version. IndiaBizExperts is an independent facilitation platform and is not affiliated with or endorsed by Intuit or QuickBooks.