cancel
Showing results for 
Search instead for 
Did you mean: 
Anicolee11
Level 1

Invoicing

How can I pull a report to show all customers who have not been invoiced?

6 Comments 6
MichelleBh
Moderator

Invoicing

Hello, @Anicolee11.

 

Currently, pulling up a report that shows all customers who have not been invoiced in QuickBooks Desktop is unavailable. As a workaround, I'd suggest running Transaction List by Customer report, then filter it to Transaction Type, and choose Invoice. All customers show in the said report has have created invoices in the system. 

 

Here's how: 

 

  1. Go to the Reports menu at the top. 
  2. Choose Customers & Receivables, then pick the Transaction List by Customer. 

 

       3. Hit Customize Report at the top. 

       4. Click the Filter tab, then enter Transaction in the search box. 

       5. Elect Invoice in the drop-down. 

       6. Tap OK

 

 

Next is, access the Customer Contact List to show all the customer's names and compare it to the Transaction List by Customer. That way, you can identify who does not have an invoice yet. Moreover, you have an option to print or download the mentioned report above. Let me guide you how: 

 

  1. Go to the Reports menu at the top. 
  2. Choose Customers & Receivables, then pick the Customer Contact List.
  3. Tap the Filter button, then choose All customer/jobs.  
  4. Hit OK

report.PNG

 

      5. Click Print drop-down. 

 

For more details about customizing reports, check out this article: Customize reports in QuickBooks Desktop

 

I've also added articles about handling reports, customer transactions, and other topics. 

 

 

Don't hesitate to tag me if you have other questions. I'm always here for you. Keep safe!

john-pero
Community Champion

Invoicing

What you are essentially looking for is a reverse of Accounts Receivable by Customer  since a customer withoutnan open invoice has a zero balance. Transactions by customer list, customize to filter by type and exclude Invoices.  Younwill be left with only customers who have paid sales receipts instead. Keep in mind paid invoices and unpaid (open) invoices can be filtered different. And that customers with open or closed invoces may also hace sales receipts.

 

Or Customer List and filfer to show only those with a zero balance.

Anicolee11
Level 1

Invoicing

@MichelleBh 

Is there a way to make the Customer Contact List look like the Transaction List by Customer? I am exporting to excel to create pivot tables to compare the 2 and I would like for the customer name and job number to be broken out on the contact list like it is on the transaction list

katherinejoyceO
QuickBooks Team

Invoicing

Thanks for coming back, @Anicolee11. The option to generate a Customer Contact List by Customer report to make it look like Transactions List by Customer is currently unavailable in QuickBooks. 

 

Exporting to Excel as you did is the workaround to achieve it. 

 

Here's an article you can read through to guide you more in customizing reports in QuickBooks Desktop.

 

For product updates and developments, I'd recommend visiting our Firm of the future regularly. 

 

Feel free to come again if you have additional questions about reporting, @Anicolee11. I'm here to help in any way I can. 

Anicolee11
Level 1

Invoicing

@katherinejoyceO 

 I have over 500 jobs for just this year to look at. What is the easiest way to see which job hasn’t been invoiced?

Mark_R
QuickBooks Team

Invoicing

Welcome back, @Anicolee11.

 

At this time, we don't have a report that shows which job hasn't been invoiced. As a workaround, you can consider following what @john-pero suggested, to run and customize the Transactions List by Customer report by filtering it by type and excluding invoices. This way, the report will show customers who have paid sales receipts instead.

 

To learn more about customizing reports, feel free to check out this article: Customize reports in QuickBooks Desktop.

 

You might also want to read this article to understand more about the reports in QuickBooks: Generate Reports.

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Have a good day.

Need to get in touch?

Contact us