I'm happy to hear everything worked out well on your reports and thank you for the insights, territyree.

Please don't hesitate to post again if you have other QuickBooks concerns. The Community is always open to providing tips and tricks to your questions.

Thank you and enjoy the rest of your day!

I guess I have found the way to look it. If you go to reports - customers and receivables - contributed... there is a report called " Payments and the Invoices and Deposits they are linked to". Let me know if its something you were looking for. 

The closest I've found is the "Customers & Receivables->Average Days to Pay Report".  Before customization, this report will give you the following fields:

You will need to filter/customize this report to get what you need.  Use the Due Date to minimize the amount of data you pull.  You won't get the number from the payment transaction but you will get the date.  Partial payments won't be easy to identify. Not the best but it may work in some cases.

Found this through Google. Apparently this report "Invoices and Received Payment" is available in some parts of the world.  Why I cant find in menu is an unhappy mystery.

I created a report by using the QB "Bills and Applied Payments" report:

1. Go to Reports, then type Bills and Applied Payments in the search bar.
2. Under Report Period, select the date you made the payment for start and end date.  This will populate the payment as well as all bills paid with that payment.
3. Go to Customize, Filter.  Select the vendor you paid.
4. Go to Header/Footer and put your desired report name, add logo, etc.
5. Run Report.
6. Go to the settings icon, and select date, num and amount.
7. This will give you a simple report to email to your vendor when you send your payment including the payment and bill dates, the bill or payment numbers and the total amounts

NOTE:  When I make an EFT payment, I put "EFT PAYMENT" in the "check number" box.  This will let your vendor know that the EFT payment is for the group of bills that you paid.  It lists the bills numbers under that column.

Is this solution for QuickBooks Online or QuickBooks Desktop?

Hello there, @djwunderlin.

The solution provided by Liz K above is for QuickBooks Desktop (QBDT). 

Just in case you want to memorize this report to save its current customization, you can check out this article for more guidance: Memorize reports in QuickBooks Desktop.

If you have any other concerns about managing reports in QuickBooks Desktop, don't hesitate to leave a comment below. The Community forum is always open to help you again.

This is for Quickbooks Online Advanced.

NOT Vendor invoices! Customer invoices with payment information.

You can follow similar steps by editing the Invoices and Received Payments Report under the Who owes you? section of reports in QBO Advanced.

Hello TMHCMT,

I know the importance of having complete reports for your business needs. Allow me to chime in and clarify things about the sales reports in QuickBooks Desktop.

A direct report to show invoices and linked payments is unavailable. You can only show all invoices and payments by customer within QuickBooks.

Here's how:

1. Click on Reports at the top.
2. Navigate to Customers & Receivables > select Transaction List by Customer.
3. On the Num column, you'll see all of the invoice numbers. You can open each transaction to see the payment numbers.
4. To add or remove filters on the report, just click the Customize Report button in the upper left-hand corner.

It would be beneficial to have this report in QuickBooks. Our engineers might be working to bring this feature to this platform.

While we assess this, I recommend sending your feedback directly to our product engineers. We continue to improve the features, and this might be available in the future. 

You can follow these steps to send feedback:

1. Open QuickBooks Desktop.
2. Click the Help tab at the top menu bar.
3. Hover your cursor to Send Feedback Online, then select Product Suggestion or Help System Suggestion.

You can also easily keep track of your sales and expenses using predefined customer, job, and sales reports in QuickBooks. I've attached a link you can check for future guidance depending on the report type you need: Customize customer, job, and sales reports in QuickBooks Desktop.

Click the Reply option for additional questions about running sales reports or other information. We'll be sure to get back to you. Take care always.

I've been trying to get a report of which customer payments were applied to each invoice for about 10 years now.  It just doesn't exist from what I found.  The OP in this thread is 4 years old and still no report that shows that info.  All we need is one more field in the "Columns" under customize report that shows the number of the payment check.  I started searching again today because I had yet another customer that wanted this report and the best I could do is manually go into a handful of invoices and write down which checks paid each invoice and send that to them in an email.

The development team must be working on more ways to force customers to convert to QBO instead of adding some stuff we can actually use.  I've never seen them fix any of the bugs or lack of basic reports and features that users have complained about for years.  This is an obvious report that anyone that has used QB for a while for a business would want.

There are 5 pages on this topic and countless other attempts to get this feature.

Now after 5 years, you're asking us to reach out to the developers?

Thank you. I appreciate the sincerity in acknowledging this need, but this response is hilariously not hilarious.

@rsaunarI wasn't asking anyone to reach out to the developers, I don't know what you're talking about.  I was explaining how I've been trying to do this same thing for long before this post and they haven't done anything to resolve the issue, and instead continue to add more "features" and attempts to get everyone to convert to QBO instead of fixing simple things like this that we actually need.  They have fields in the customize report options that are so rarely used by anyone, but something simple like payment check number isn't in there.

@rsaunar  If you were responding to the post before mine, sorry.  Looked like you were responding to me.

I know it's been said (probably by me) but I think when you sit down and try to put the information you're requesting into a report format (rows and columns), the format breaks down as complexity increases. If it was just invoice A paid by check A, B, C, then you're all good. But imagine my company where an invoice can be paid by multiple checks, checks can pay multiple invoices, payments can be refunded, invoices can be credited, credits can be voided, balances can be present, credits can be partially applied and have balances, Overpayments can be incurred, and JE's are used as necessary. The report would need to reflect all that if it were to work all the time, but data modelling in a row and column format (which all qb reports are) does not work. 

The solution that's been provided by others: Use the Memo field in the payment window to list invoice #'s. We do that as well, and I'm literally looking at a customer transaction report with Payment #### followed by Inv###'s for each. It's super simple, (screenshot attached).

I remember when I got my Nintendo Wii. It plays game disks but not DVD's. No matter how much I wanted to watch the Matrix on my Wii, it was not going to happen.

The other issue may be: 15 people asking for something is just that. When did we start thinking we were always going to get our way?