How to Search Invoices in QuickBooks

Finding a specific invoice in QuickBooks is something most business owners need to do regularly, whether a customer is disputing a charge, an accountant is reconciling accounts, or a team member needs to verify a payment status. This guide covers every search method available in QuickBooks Desktop 2022, 2023, and 2024, as well as QuickBooks Online, so you can find the right invoice in seconds rather than scrolling through hundreds of entries. QuickBooks provides multiple ways to locate invoices, and knowing which method fits your situation saves time and prevents errors.

Where to Find Invoices in QuickBooks?

Before searching, you need to know where QuickBooks stores invoice records. The location differs between QuickBooks Desktop and QuickBooks Online.

QuickBooks Desktop:

Invoices in QuickBooks Desktop are stored under the Customers module. You can access them from:

• Customers > Customer Center - shows all transactions per customer including invoices
• Edit > Find - opens a dedicated search window to filter transactions across the entire company file
• Reports > Sales > Open Invoices or Transaction List by Customer - generates a list of invoices matching report parameters

QuickBooks Online:

In QuickBooks Online, invoices live under:

• Sales > Invoices - the primary invoice list with built-in search and filter tools
• Reports > Sales and Customers - includes Invoice List and other summary reports
• +New > Invoice history visible from the customer profile

Once you know where to look, you can use the methods below to find a specific invoice quickly.

How to Search Invoices by Invoice Number

Invoice numbers are the fastest lookup key. If a customer provides their invoice number, use this method in QuickBooks Desktop.

1. Open QuickBooks Desktop and go to Edit > Find (or press Ctrl+F)
2. Click the Simple tab
3. In the Transaction Type dropdown, select Invoice
4. In the Number field, enter the invoice number
5. Click Find
6. QuickBooks will display all matching invoices in the results panel at the bottom of the window
7. Double-click any result to open the full invoice

If you know only part of the invoice number, enter what you know. The Simple Find treats partial entries as a "contains" search for the number field.

In QuickBooks Online, go to Sales > Invoices and type the invoice number into the search bar at the top of the invoice list. Results filter in real time as you type.

How to Search Invoices by Customer Name

When you do not have the invoice number but know the customer, searching by customer name is the most practical approach.

QuickBooks Desktop - via Customer Center:

1. Go to Customers > Customer Center
2. In the customer list on the left, scroll to and click the customer name
3. The right panel shows all transactions for that customer, including invoices
4. Use the Show dropdown above the transaction list to filter to Invoices only
5. Use the Date dropdown to narrow the date range if needed

QuickBooks Desktop - via Edit > Find:

1. Go to Edit > Find and click the Simple tab
2. Set Transaction Type to Invoice
3. In the Name field, enter the customer name (partial names work)
4. Click Find

QuickBooks Online:

1. Go to Sales > Invoices
2. In the search bar, type the customer name
3. Use the Filter button to add date range or status filters alongside the name search

How to Use Advanced Find for Multi-Criteria Searches

The Advanced Find option in QuickBooks Desktop is the most powerful search tool when you need to combine multiple criteria, such as a date range plus a specific dollar amount, or all overdue invoices for a particular customer.

1. Go to Edit > Find
2. Click the Advanced tab
3. In the Filter column on the left, click a filter type to add it. Available filters include:

- Transaction Type - set to Invoice

- Name - customer or job name

- Date - specific date or range

- Amount - exact amount or range

- Number - invoice number

- Paid Status - open, closed, or either

- Due Date - useful for finding overdue invoices

1. Each filter you select adds a row to the active filter list on the right
2. After setting all filters, click Find
3. Results appear in the lower panel. Double-click any row to open that invoice directly

The Advanced Find is particularly useful for accountants running end-of-month reviews. You can set a date range of the entire month, filter to Invoice type, and set Paid Status to Open to immediately see all outstanding receivables for the period.

How to Search Invoices in QuickBooks Online

QuickBooks Online consolidates invoice search into the Sales section and includes filter options that cover most search scenarios.

Using the Invoice List:

1. Click Sales in the left navigation menu
2. Click Invoices
3. The invoice list loads showing all invoices. Use the search bar at the top to search by customer name, invoice number, or amount
4. Click the Filter button (funnel icon) to access additional filter options:

- Status - Draft, Sent, Overdue, Paid, Voided

- Date - custom date range

- Customer - specific customer

- Delivery Method - online or print

1. Apply filters and the list updates automatically
2. Click any invoice row to open it

Using Reports:

For bulk invoice reviews, go to Reports > Sales and Customers > Invoice List. This report lists all invoices with columns for date, invoice number, customer, amount, and balance. You can filter the report by date range and export to Excel for further analysis.

How to Search Invoices by Amount

Searching by a specific dollar amount is useful when a customer references the amount on a check or payment but does not have the invoice number.

QuickBooks Desktop:

1. Go to Edit > Find > Advanced tab
2. Add a filter for Transaction Type and set it to Invoice
3. Add a filter for Amount and enter the specific amount
4. Click Find

If you are not sure of the exact amount, open the Customer Center, navigate to the customer, and browse their transaction list visually.

QuickBooks Online:

The invoice list search bar in Sales > Invoices accepts amounts as search terms. Type the dollar amount and QuickBooks Online will return invoices matching that value. Combine with a customer name filter to narrow results when multiple invoices share the same amount.

How to Find Overdue Invoices

Overdue invoices require attention for cash flow management. Both versions of QuickBooks have direct views for this.

QuickBooks Desktop:

1. Go to Reports > Customers and Receivables > Open Invoices
2. This report lists every unpaid invoice with the due date and number of days overdue
3. Use Customize Report to add or remove columns, or to filter by a specific customer

Alternatively, the Collections Center (available in QuickBooks Pro Plus, Premier, and Enterprise) flags customers with overdue balances and lets you send reminder emails directly from the screen. Access it from Customers > Collections Center.

QuickBooks Online:

1. Go to Sales > Invoices
2. Click Filter and set Status to Overdue
3. The list shows all invoices past their due date with the customer name and amount owed
4. You can select multiple invoices and send reminder emails in bulk using the Action dropdown

How to Recover Missing Invoices

If a search returns no results and you are confident the invoice was created, the company file may have data integrity issues.

QuickBooks Desktop - Verify and Rebuild Data:

1. Go to File > Utilities > Verify Data
2. QuickBooks will scan the company file for data issues. If it finds problems, it will prompt you to rebuild
3. Go to File > Utilities > Rebuild Data to repair any detected issues
4. After the rebuild completes, run your invoice search again

Before running Rebuild Data, QuickBooks automatically creates a backup of the company file. Still, it is good practice to create a manual backup first via File > Back Up Company > Create Local Backup.

QuickBooks Online:

If invoices are missing in QuickBooks Online, check the Audit Log at Settings > Audit Log to see if the invoices were deleted and by whom. If invoices were deleted accidentally, you cannot restore them directly; you would need to recreate them manually using the information from the audit log entry.

When to Call Support

Contact QuickBooks support phone number if:

• Invoice search returns no results after a successful Verify and Rebuild Data operation
• The Find window in QuickBooks Desktop is unresponsive or fails to open
• Invoices are present in the company file but do not appear in reports
• You suspect data corruption beyond what the built-in tools can repair
• QuickBooks Online is not syncing invoice data correctly after a bank connection update