Duplicate Invoice Reports in QuickBooks
Duplicate invoice numbers in QuickBooks business accounts software can cause confusion when you reconcile and balance your company’s accounts at the end of a fiscal period. There’s no dedicated tool for automatically detecting duplicate invoices in QuickBooks, but you can adapt another program feature to provide a workaround solution.
Other People Are Reading
-
Duplicate Invoice Problems
-
When manually creating or editing an invoice in QuickBooks to charge a customer for goods or services, the program prompts the user to assign a number to the invoice document. If the user accidentally allocates identical numbers to separate invoices, the invoices can show up as duplicates in the company’s customer accounts. The duplicate invoice problem can occur if multiple users access QuickBooks to create and send customer invoices.
Locating Duplicate Invoices
-
Locating duplicate invoices in your company accounts is important, because duplicates can signify possible fraudulent activity or simple data entry errors. QuickBooks doesn’t include a duplicate invoice report feature, but it does include a tool for tracking down missing and duplicate check numbers. The workaround solution for finding duplicate invoices involves adapting the duplicate check number tool.
-
Duplicate Invoice Workaround Solution
-
The first step for detecting duplicate invoices in QuickBooks is to create a Missing Checks report, which you can access by selecting “Reports” in the main menu, followed by “Banking” and then “Missing Checks.” In the Account field, enter the accounts receivable account that you want to check for duplicate invoices instead of a bank checking account. Click the “OK” button to start the search. Because you’ve selected an accounts receivable account instead of a bank account, QuickBooks searches for duplicate and missing invoices rather than duplicate or missing checks.
Duplicate Invoice Report
-
QuickBooks scans the account and displays a report listing invoices in numerical order. The report flags up all duplicate invoice numbers in addition to missing invoice numbers. Click the “Modify Report” button on the main menu to edit and change the report’s title to “Duplicate and Missing Invoices.” To save time when running duplicate invoice reports in the future, click the “Memorize” button to save the report settings. You can access the duplicate invoice report from the QuickBooks “Reports” menu.
-
References
Resources
- Photo Credit Creatas/Creatas/Getty Images
