Lol, I get the idea for wanting this report, but I don't understand why a professional would need it for double-entry accounts, that maintain a running balance, and reconcile to a bank. What auditor has to link all invoice numbers to all payment numbers in a system where applying a payment zeroes out the invoice and the payment? There are so many other measures for reconciling account balances and totals that I imagine QB is not going to restructure their data for a bunch of people that can't figure out accounting. If you need to see what payment applied to an invoice, open the payment and see. This should be done on a sample basis, not a draw a line connecting every transaction, for every customer basis. When a payment applies to two invoices, and those same invoices involve a payment from another source (which may itself apply to even further invoices) reporting structure breaks down for the all encompassing format you guys want. Sure, it may work for examples of data on the simpler side. i.e. invoice X paid by check Y. But throw in a mix of transactions, unapplied amounts, over payments, etc and the report becomes moot. And for goodness sakes people, act like adults.

Wow. You don't understand it, therefore it isn't needed.

Seriously?

Let me explain something to you: There are many of us trying to get paid in ways you may not imagine, and based on your post, that imagination includes insulting anyone that doesn't think like you. 

By the way, the "new features" are finding ways to get us to pay more for the same crap software you believe works perfectly.

No progress on this? I can't go any deeper in the replies. I'm still in 2019, and I don't see resolution. In the meantime, Quickbooks tries to upsell me thru the product or run at ads at me. I mean, I pay a subscription fee. Why do I have to see this garbage? Why is so hard to provide a report with invoice numbers and payment numbers? It's essential. Pitiful.

You're right. I'm in software development. This is pathetic.

It must be very frustrating to work for Quickbooks when your dev team cannot resolve a simply, essential report in 2 years time.

found this method:

1. From the Reports menu, choose Banking then click Check Detail.
2. Click Customize Report.
3. On the Display tab, choose the appropriate date range.
4. From the Filters tab, remove all selected filters under the Current Filter Choices.
5. Select the filter for Transaction Type then choose Payment.
6. Select the filter for Detail Level and choose All Except Summary.
   Note: If the Detail Level filter is selected as Summary Only, it will only show linked deposits. You can filter this report for specific customers by choosing the Name filter and narrowing down to a single name or type of name.
7. Select OK.

this method worked for me Payment and corresponding invoices:

1. From the Reports menu, choose Banking then click Check Detail.
2. Click Customize Report.
3. On the Display tab, choose the appropriate date range.
4. From the Filters tab, remove all selected filters under the Current Filter Choices.
5. Select the filter for Transaction Type then choose Payment.
6. Select the filter for Detail Level and choose All Except Summary.
   Note: If the Detail Level filter is selected as Summary Only, it will only show linked deposits. You can filter this report for specific customers by choosing the Name filter and narrowing down to a single name or type of name.
7. Select OK.

It truly is ridiculous that the user community has to rally for this basic functionality. Does anyone inside QBO appreciate the need for this basic need that would help us immensely or do you not really care?

We have payments which apply to hundreds of invoices.

My boss is upset with me for not being able to provide this report, along with an estimates report that shows each estimate with it's invoices and payments. We have TENS of thousands of estimates and I have to MANUALLY export this report of ALL of them, sift through it to find what he wants, and put it into a report myself. I am beyond angry and shocked that this report was a staple in your desktop version but unavailable in the UPGRADED online version. And this is year 3 or so that I have been on your message boards, with this same old tired rant. QBO has been the worst "upgrade" I have ever dealt with.

Hello 

Using LetSync Desktop. You can get that export it automaticly :

https://www.letsyncsolution.com/docs/report-payments-with-invoices/

Regards,

Thank you! We may very well buy your product.

You will get 30 days trial for testing without any risk. Looking forward to hearing from you.

So QB solution is to purchase a $400 3rd party add on application to perform this function (a simple accounting report showing estimates invoices and payments by job), that was free in the desktop version and available to us before we spent thousands of dollars on the upgraded? 

I had the same issue a year ago during an audit, where the credit memo and what invoices they were applied to was information needed and I couldn't find a report. 

I then found an answer on these message boards, it works and the instructions, which I saved, also work for payments. below is what I saved from last year. I was just able to do this report to give me all the payments by customers and the invoices they were applied to. 

"I think I may have found the answer to your question:

1.  Go to Reports>Banking>Check Detail

2.  Select Customize Report

3.  Click on Filter Tab

4.  Modify Report as follows:

     Account:  All Accounts

     Date:  Specify the date you desire

     Detail Level:  All

     Transaction Type:  Credit Memo

5.  Select OK

This should show you the Credit Memos for the date specified and the invoices and items it applied to.  You can also run this for PAYMENTS.  Just change the Transaction Type to PAYMENT. "

I was taught to put the check number in the "Reference Number" field when entering payments against an invoice. We want to print a Customer transaction report showing all invoices open and closed and the "Reference Number" for those that were paid. How can we accomplish this? 

Thank you. 

I'd be glad to join you here and help you get all the details that you need, mjkahn.

You can run the Invoice List report. This will give you a list of all invoices whether paid or not. Then, customize it to include the payments that were applied to the transactions. 

Here's how: 

1. Go to the Reports menu and select Invoice List.
2. Click Customize in the upper-right hand corner of the report.
3. Scroll-down to the Filter section and check the box for Transaction Type.
4. Click the drop-down list beside it and check the boxes for Invoice and Payment.
5. Select Run report. 

Please note that the reference number is shown under the Num column. 

I'll be sharing these references as well in case you need more guidance when running reports in QBO:

• Customize Reports in QuickBooks Online
• Common Custom Reports in QuickBooks Online

Feel free to join us again in the Community if you have other questions for us. We'll make sure to answer them for you. 

yes you can get this easily. Go to Reports > Sales > Sales by customer detail. Then when the customize box opens, you choose the dates you need, and mark the little bubble under report basis to CASH, then the report will show you the the items paid for, the customer name, the invoice number and the date paid. The date paid is under the column heading date. 

Hello

yes, you can query report using LetSync: https://www.letsyncsolution.com/docs/report-payments-with-invoices/

I hope this helps

Regards,

LetSync

THANK YOU!!! All of the reading, searching, etc.,etc. that I have spent on this and your suggestion provides EXACTLY what the original poster requested! Intuit couldn't resolve this or provide a report in over 2 years and what you have detailed is exactly what is needed!

Hello 

You can use LetSync Desktop to pull that report from QuickBooks to your database: https://www.letsyncsolution.com/docs/report-payments-with-invoices/

I hope it helps

LetSync

Thank you!!!!!!!!! I appreciate your response and appreciate that you listened to the request for the Vendor invoice and check report. 

Well, I was happy too soon.  My report cut off in Late November 22 but I have payments (the same type) going through to Feb 2023.  My date was through current date.  So Strange, but very disappointing.