Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Pro Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 06-12-2017, 10:26 PM
smalltowngirl smalltowngirl is offline
Registered User
 
Join Date: Jun 2011
Posts: 159
Invoice ?

Is there a way to run a missing invoice numbers report? For example: I might show invoice #100, #102, #103, etc but I would like to know that #101 was missing.
Reply With Quote
  #2  
Old 06-13-2017, 10:40 AM
Froid Froid is offline
Registered User
 
Join Date: Feb 2017
Location: Southern California
Posts: 95
Export to Excel

Quote:
Originally Posted by smalltowngirl View Post
Is there a way to run a missing invoice numbers report? For example: I might show invoice #100, #102, #103, etc but I would like to know that #101 was missing.
You could create a memorized invoice report and export it to Excel. Then re-sort the spreadsheet to isolate the invoice numbers sequentially. Throw in a conditional "if" formula to flag the missing ones. (e.g., =if(A1+1<>A2,"xxxxx","-") Test out my simple formula on a blank spreadsheet.

Our company likes QB's ability to choose specific invoice numbers, because our complicated invoicing process originates from a third party program. We enter those oddball invoice numbers into QB, since we utilize every other A/R feature (aging, payment app, sales by territory, CM/DM, etc.)
Reply With Quote
  #3  
Old 06-13-2017, 07:47 PM
smalltowngirl smalltowngirl is offline
Registered User
 
Join Date: Jun 2011
Posts: 159
I will have to try it out when I find some time. Thank you for this idea.
Reply With Quote
  #4  
Old 06-15-2017, 07:04 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 9,376
Try running the Missing Check report then modify it for AR account and Invoice transactions.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #5  
Old 06-16-2017, 09:18 PM
smalltowngirl smalltowngirl is offline
Registered User
 
Join Date: Jun 2011
Posts: 159
Is there a button that says modify?
Reply With Quote
  #6  
Old 06-26-2017, 05:04 PM
smalltowngirl smalltowngirl is offline
Registered User
 
Join Date: Jun 2011
Posts: 159
Joe,
I went to missing checks report, then customize, filters, then transaction type, (accounts receivable is not listed), then invoice. It did not work....it is blank. Any more ideas?
Reply With Quote
  #7  
Old 06-26-2017, 06:18 PM
Froid Froid is offline
Registered User
 
Join Date: Feb 2017
Location: Southern California
Posts: 95
QB Enterprise has one...

Unsure what QB Pro looks like, but with QB Enterprise we can search the report center for various reports. One exists for "missing invoices" as report ID CR616. It throws a highlighted section where the sequence is broken.

Otherwise, my Excel solution will work very well. Once you create an Excel template, you can copy/insert your extracted data and copy the formula down the page.

Identifying missing invoices can catch forms of embezzlement or tax fraud. QB is not at all strict at the sequencing, so somebody can easily produce invoices outside the program (directing the recipient to pay another address or fund another bank). Finding missing invoices will tell you much, unless you can trace it back to goods leaving the premises.
Reply With Quote
  #8  
Old 06-27-2017, 05:08 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,305
The closest I can come is to use reports>accountant & Taxes> transaction list by date
click customize, set the sort by field to num, click filters and select only the a/r account under the account filter
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 07:19 AM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.