QuickBooks: Creating a Missing and Duplicate Invoice Number Report

Most companies have some control over the process of creating customer invoices.  One control, especially if invoices are created manually in the field and later entered into QuickBooks, is to maintain a numeric invoicing pattern.  This method of invoice recordkeeping can be an important process to have if your company is ever audited and you are required to provide a list of all invoices.


To see whether your data has any missing numbers in the invoicing sequence, follow these steps:


Click Reports, Banking, Missing Checks.



In the next screen, choose Accounts Receivable from the drop-down menu.



It is also recommended to rename the report by choosing Modify Report, clicking the Header/Footer tab and typing a new title for the Report Title field, such as Missing Invoices. 


Looking For More?


Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 260-5250 or
find out more here.


When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting


When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics