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?

Not sure if this addresses your question exactly, but here's what I just figured out and it might help you also. I use Enterprise Suite, not Desktop, but I think these features would be the same across those platforms:

I found two options

Solution 1: For one specific payment, a Payment Receipt can be generated that shows the payment total a customer makes and also each invoice number, date and amount that was applied.

Pull up the Received Payment in Question [Customers>Transactions tab>select Received Payments>Double click on the payment in question. Once you see the "Customer Payment" titled screen with the date, amount and invoices checked that the payment is applied against [so that you know you are in the right place, this is the same screen we use to enter Received payments, so these fields are editable]>select Print at the yellow printer icon within the Receive Payments window>you can customize the print template if you want or hit "not now" button > click Preview to see what the print version would look like. It shows the amount customer paid and the invoice(s) and amounts that were applied to each invoice as well as the date it was applied. 

Solution 2: For a report that shows many payments/many customers, go to Reports menu at top>Report Center> search bar within Report Center enter "CR610" (the report ID number of the "Payments Received" Report. The report search result looks like the screen shot included. Double click on this report and you can customize down to one Customer, if you wish. It will list each Payment Received and the Invoice numbers and amounts that were applied. 

I hope this is helpful!

Thank you for offering those solutions. I wasn't able to get anything to come up when I searched that code in the Reports center. I was told recently by customer support that the report I'm looking for is not included in the QBO subscription we have. This at least gives me an answer to why I haven't found the report I've been looking for since we "upgraded" years ago. I just have to continue to manually enter all of the billing into a statement I created in Word. Thanks. 

Update. 240911

Using QBO Plus

I am now able to see the report "Invoices and Received Payments" in the "Who owes you" section of Standard reports. This reports both invoices and payments as seperate line items and those transactions have different fields listing the invoice number. 

I run this report, trim and clean it, add 2 invoice helper columns (using if statements to pull invoice # from correct field)  so that every line item, invoice and payment, has an invoice reference.  Then build a pivot table which builds ad hoc reports as needed.

Thank you

When I do the search for "bills and applied payments", I get a ton of results and nothing actually called that.  In fact, it's so many results that I've been scrolling for a long time without luck and am frustrated.  Can you give me some more clues on how to find it?

The original question is referring to customer invoices and the payments applied to them, not Vendor bills.

QBO is ridiculous and I would never switch again. I tried it for 3 months or so and it is even more limited than desktop. DO NOT waste your money or time on it

Hello there, Gsa. The Bills and Applied Payments report mentioned by the previous user, lizk1, is for QuickBooks Online. I'm here to clarify this further.

This report is exclusive to all QuickBooks Online versions. Please see the attached screenshot for visual reference.

The Bills and Applied Payments report is unavailable in QuickBooks Desktop, which explains why you are unable to find it. Please know this pertains to vendor bills, not customers.

If you're using QuickBooks Desktop, you can run the Transaction List by Vendor to view your vendor bills and corresponding payments. 

1. Go to the Reports menu. Select Vendors & Payables. 
2. Choose Transaction List by Vendor, then Customize Report.
3. Navigate to the Filter tab. Enter Transaction Type. 
4. Click the Transaction Type dropdown. Tick Multiple Transaction Types. 
5. Pick Bill and Bill Payment. 
6. Tap OK, then OK.
   
   

 

On the other hand, if you're referring to your customer's invoices and payments. Refer to this sample screenshot.

Moreover, I'm adding these articles to share some tips and information about reports: 

• Create, access, and modify memorized reports.
• Set report preferences. 

Feel free to reach out for any help with report generation. The information provided should help clarify any confusion.

The solution by @DanBu works and shows the information we want.  The report isn't pretty with a single line but it shows the invoice and payment for each.  When I search for the report CR610 he mentioned it comes up and works.