Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
kspachek
Level 1

Paid Invoice Reporting

Quickbooks Enterprise Desktop - I am looking for a report that shows invoices paid for a customer date range that shows the amount paid (not invoice amount), the paid date and lets me include the class. I have tried average days to pay, customer transaction report and sales detail. Am I missing something on one of these reports or is there another report out there that can help?

4 Comments 4
Carneil_C
QuickBooks Team

Paid Invoice Reporting

Welcome to the Community, @kspachek.

 

Let me help you find the report you need in QuickBooks Desktop.

 

You can pull up a Customer Balance Detail report. It lets you view what payments and invoices make up each customer's current balance. Thus, utilizing the Filters feature allows you to see the invoices paid for a customer's Date range and Class.

 

Here's how:

 

  1. Go to the Reports menu.
  2. Click Customers and Receivables, then choose Customer Balance Detail report.
  3. From there, modify the report Date.
  4. Go to Customize report.
  5. On the Filters tab, select Class
  6. You can also apply other filters according to your data needs.
  7. Hit OK to save the changes.

 

To find out more about the different reports that cater to your business needs, check out these handy articles:

 

 

On top of that, you do not have to go through the customization process again in the future if you want the same settings of the customized report following the process in this reference: Create, access, and modify memorized reports.

 

I'll back you up if you need more assistance modifying your reports in QBDT. Keep safe, and have a great day ahead.

kspachek
Level 1

Paid Invoice Reporting

Not all of the payments received will show up on a customer balance detail as this report is only customers with an open balance. I want a deposit detail report that lets me see each payment broken down by class

kspachek
Level 1

Paid Invoice Reporting

This report won't work as some of the payments paid off a customer balance. All I'm looking for is a Deposit Detail report that shows the invoices paid and their class.

FateCandylaneT
QuickBooks Team

Paid Invoice Reporting

I appreciate you getting back into this forum, kspachek. Keeping track of your customer sales transactions and other business finances in your account helps improve your company's workflows. Let me provide additional insights to run reports with the invoices paid and classes on them.

 

Yes, you may consider running a Deposit Detail report to acquire the customer's amount paid with their classes. Just ensure to follow and customize all the necessary filters added below to show amounts paid on an invoice and specific class. To do this:

 

  1. Go to Reports and click Banking.
  2. Select Deposit Detail report.
  3. Modify the date period and click Customize Report.
  4. Under the Display tab, enter and select Classes.
  5. From the Filters tab, select the following: 
  • Accounts = All Accounts
  • Amount = Any
  • Detail Level = All except Summary
  1. Review all necessary information, then click OK.

 

This should enable all details including customer amounts paid and their specific classes. 

 

Moreover, you can memorize all the details to save the customization settings made to this report. This way, you do not have to go through the customization process again. 

 

I'll always be available in this thread to provide additional help. If there's anything else you need assistance with, just let me know in the comments below. Keep safe and have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us