cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Report showing invoices paid and upaid

I'd like a report for a customer that shows each invoice sent to that customer over a given time period.  I'd like one column for the date submitted and another column for the date paid.  I can get a report of invoices for a customer, but when I add the "Date Paid" field, it's blank.  How can I get this report to show, on the same line as the invoice, the date that I recorded payment for that invoice from the customer?

Solved
Best answer April 23, 2019

Best Answers
Highlighted
Moderator

Report showing invoices paid and upaid

Thanks for sharing the complete details of your concern, rgarton.

 

I can add some information about the reports in QuickBooks Desktop.

 

At this time, we are unable to run a report that shows the payment date of an invoice. However, you can customize the Transaction Detail report to show the list of invoices and payments by date. Here's how to run the report:

  1. Go to Reports at the top menu bar.
  2. Under Custom Reports, choose Transaction Detail.
  3. Under Display, add the Paid column.
  4. Remove the unnecessary column.
  5. Click on the Filters tab.
  6. In the Search Filters field type Transaction Type.
  7. Click the Transaction Type drop-down and select Multiple Transaction Types.
  8. In the Select Transaction Types window, click Invoice and Payment.
  9. Click OK twice.
  10. In the Total By drop-down, select Customer.
  11. Update the report date.

image.png

 

I'll definitely pass this along to our engineers. This way, we can keep the report updated. They also make improvements in QuickBooks by listening to our customers' suggestions and comments.

 

Thanks a lot for raising this concern. I'd appreciate if you can update me on how it goes. I'll be here if there's anything else you need. I'm cheering you to continued prosperity.

View solution in original post

8 Comments 8
Highlighted
Moderator

Report showing invoices paid and upaid

Thanks for sharing the complete details of your concern, rgarton.

 

I can add some information about the reports in QuickBooks Desktop.

 

At this time, we are unable to run a report that shows the payment date of an invoice. However, you can customize the Transaction Detail report to show the list of invoices and payments by date. Here's how to run the report:

  1. Go to Reports at the top menu bar.
  2. Under Custom Reports, choose Transaction Detail.
  3. Under Display, add the Paid column.
  4. Remove the unnecessary column.
  5. Click on the Filters tab.
  6. In the Search Filters field type Transaction Type.
  7. Click the Transaction Type drop-down and select Multiple Transaction Types.
  8. In the Select Transaction Types window, click Invoice and Payment.
  9. Click OK twice.
  10. In the Total By drop-down, select Customer.
  11. Update the report date.

image.png

 

I'll definitely pass this along to our engineers. This way, we can keep the report updated. They also make improvements in QuickBooks by listening to our customers' suggestions and comments.

 

Thanks a lot for raising this concern. I'd appreciate if you can update me on how it goes. I'll be here if there's anything else you need. I'm cheering you to continued prosperity.

View solution in original post

Highlighted
Level 2

Report showing invoices paid and upaid

Thanks.  This is what I suspected, that QB cannot produce the report I want.  QB has a habit of providing reports that fall short of what I need in my work.  As you pass feature requests along to your engineers, another major problem for me is no way to report transactions that have no customer assigned.  I often produce custom detail reports with hundreds of transactions.  There's a total at the bottom.  Then I sort by customer and the total changes because QB does not list transactions without customers when you're sorting by customer.  I need to find those customer-less transactions, but there is no way in QB to do that.  Major pain.

Highlighted
Moderator

Report showing invoices paid and upaid

 

Allow me to jump into this conversation, rgarton.

 

Let me help you customize the report to find those customer-less transactions.

 

When running the Transaction Detail report in QuickBooks Desktop, you'll have to opt out any filters applied to it. The report will display all transactions that don't have a customer associated in the No name section. These include deposits, transfers, and sales receipt.

 

Let me show you how:

  1. Go to Reports.
  2. Under Custom Reports, choose Transaction Detail.
  3. Set the date and click on OK.
  4. Select Customer in the Total By drop down.
  5. Click on Refresh.
  6. Scroll down to the bottom of the report until you reach the No name section.

To help you with the process, I've attached some screenshots below.

 

r1.PNG

 

r2.PNG

 

r3.PNG

 

r4.PNG

 

As a reference, you can also check out this article: Customize reports in QuickBooks Desktop.

 

Please know that we are constantly improving our product's features to meet your needs. You can check out regularly for product updates and feature enhancements through this link: Firm of the Future.

 

That should do it. Leave a comment below if you have further questions. I'm always glad to help.

Highlighted
Level 2

Report showing invoices paid and upaid

Nicely detailed response; thank you.  The trick I had been missing was remove all filters except the date filter.  When I do that, I get a report with lots of transactions I don't want in the report.  But I do get a list of transactions without customers, which is more than I've been able to do before.  That will come in handy.

 

I don't know why QuickBooks can't include the No Name category in filtered reports where I mostly need it.  As so frequently happens, QB gets me close to what I want but then requires additional manipulations before I get what I need.

Highlighted
Level 1

Report showing invoices paid and upaid

This is a major problem. Why does this date not come through in reports? This is critical for commission reports when trying to pay based on when transactions actually take place. What's the point of a data field if it doesn't populate the data? Please push this up the channels to the engineers as an issue to resolve.

Highlighted
QuickBooks Team

Report showing invoices paid and upaid

Hello there, @arcticnathan09.

 

 I can see how this feature would be helpful for you and your organization, and I'm going to submit feedback directly to our Product Development Team for consideration in future updates.

 

To understand more about reports, please check out this article for your future reference: Understand Reports.

 

Also, you can check out regularly for product updates and feature enhancements through this link: Firm of the Future.

 

Reach out to me if you have any other questions. I'm a few clicks away to help. Have a good day!

Highlighted
Level 1

Report showing invoices paid and upaid

Hi,

I would like to have a report like this but I would like to see the invoice number and the payment date.
The transaction is not a solution for me because in one transaction, it's possible to pay several invoices.
I want a detail by invoices, so this can be like: 

 Transaction   PaymentDate   InvoiceNumber       Amount   Customer

  Payment       10/04/2020        2020-001                     1000   Cust1

  Payment       10/04/2020        2020-002                       500   Cust1

                 SubTotal                                                           1500

 Payment       11/04/2020         2020-003                     1800  Cust2

 Payment       11/04/2020         2020-004                       200  Cust2

                 SubTotal                                                           2000

Is that something feasible?
Many thanks,

Alain

Highlighted
QuickBooks Team

Report showing invoices paid and upaid

Hi there, Sonia Muller.

 

I can see that you have a duplicate post about customizing your invoices and payments in this link: https://intuit.me/3cDRQag.

 

Count me in if you have any other concern and  I'll get back to you. Take care.

Need to get in touch?

Contact us