Skip to main content
January 17, 2024
Question

Paid Invoice Reporting

  • January 17, 2024
  • 1 reply
  • 0 views

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?

1 reply

January 17, 2024

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.

kspachekAuthor
January 17, 2024

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