FAQ:How Can I Find Missing Invoice Numbers in QuickBooks?
If you want to know if there are some invoice numbers missing in a sequence, OR if you aren’t sure what the next invoice number should be in your sequence (if you have gotten out of sequence for some reason), you can modify the missing checks report to help.
This report is found under the Banking section of the reports menu. Select the A/R account as the account to work with and it will list all the numbers used.
About the Author (Author Profile)
Charlie Russell is the founder of CCRSoftware. He’s been involved with the small business software industry since the mid 70′s, focusing on inventory and accounting software for small businesses. Charlie is a Certified Advanced QuickBooks ProAdvisor. Look for Charlie’s articles in the QuickBooks and Beyond blog, as well as his California Wildflower Hikes blog.
Connect with Charlie at Google
Subscribe
If you enjoyed this article, subscribe to receive more just like it.
Hi Charlie -
Another way to accomplish this is to go to the customer center and click on the transactions tab (on the left side of the screen), select invoices, filter by all invoices,all dates, click at the top of the number column and it will sort by number.
At least that’s how I do it. Don’t know which way is faster.
That works too, Elizabeth. Always more than one way to accomplish tasks in a flexible program like QuickBooks. Both work.
You can also start with the Missing Check report and filter it out for invoices instead of Checks and filter off of the AR account.
The will give you the duplicate numbers and the missing numbers instead of hving to review the list manually.
Robin, unless I misunderstand what you are saying, isn’t that what my original recommendation was? Pick the Missing Checks report and set it to the A/R account – and you get the “missing number” info? Unless you are trying to point out something different.
But you point out the issue I woudl have with Elizabeth’s recommendation – the Missing Checks report highlights the items that are missing, the Customer Center won’t make that as obvious.
How do I credit sales tax on an invoice?
We invoiced a customer for goods sold, including sales tax. A week later they brought in a tax exempt form. The invoice has not been paid.
How do I credit just the amount of sales tax on this invoice?