Is there any report which shows payments with invoices?

After multiple decades, why is this software incapable of listing all invoices by date with payments listed under each invoice?

How is it possible Intuit can not make this happen?

Ridiculous.

Interesting. I was actually just searching for this very same report.

The payment transactions display the check number in the 'Num' field, but I'd also like to see which invoices the payment was applied to. 

Hi There

I am also looking for a similar report which shows the details of the vendor bill details, our payment date and check no.  I tried to add columns like "Paycheck Date" and "Check #" to Transaction List by Vendor or Job Cost Report unfortunately these columns are blank.  Now I am doing it in a very stupid way which is to export the data to an excel file first, then go back to Quickbook to retrieve the payment date and check no. by clicking "transaction history", and then paste these in the excel spreadsheet..........

It would be much appreciated with the development team could allow data flow between bill payment and payment details.

Cheers

Hi Sophia,

Thanks for your reply. I don't see any invoice number.  I only see check# in the 'Num' column.

Hello there, BenTam,

As per my colleague Sophia mentioned, QB generate the numbers per transaction type.

There's a possibility that the report is filtered to only show payment transactions. If that's the case, the check number will show on the Num column.

Let's click the Customize Report button to check the filters. Then, run the report again. You can also create a memorized report to save it for future use.

I'll be here if you need more help. 

Hi Mary,

Thanks for your reply. It really helps.

i must add my voice to those of my compatriots here in this channel. i echo their frustration and confusion - it should be relatively easy to create a report which shows all invoices and then the payments made against those invoices. this isn't exactly rocket science - it's pretty basic stuff. why isn't this a standard report made available to all who use the QB platform?

Same problem here. Why can't QB allow be to add a column to list the respective invoice in the same line of the payment?

This lack of functionality is one of the reasons why so many of us are changing to Netsuite. 

One would think that for the price we are paying for this software you would be able to pull any report you needed. Not so here. They just want you to purchase more apps to perform the duties that the program does not provide.

Actually I figured this out, but it's non intuitive.  Go to a transaction list and then click a bill payment -- any bill payment, it doesn't matter.  Once in a bill payment go to the reports tab and hit check detail.  That will bring up check detail on all checks for a given date range.  Next, customize the report by selecting a Name filter and choosing the vendor you want to isolate.  Then you can change the date range as needed.  You end up with a list of checks and each bill underneath that the checks paid. 

This is not responsive to the questions. You are describing payments to vendors, not from customers.

We need this for customers, especially customers relying on a 3rd party or partial payments. 

It's been months since I posted this. Is there an update from the Product Developers Team to this?

I run a check detail report which will show the date the check was dated as well as the invoice numbers associated with the check.  

I filter the report by Vendor name and multiple transaction types as well as dates.  It’s perfect.

You can also go to File, Print Forms and choose Bill Payment Stubs, select the date range, select the Vendor and it will print the check stub listing all the invoices paid by that check or in my case the EFT payment.  

Hope that helps y’all. 

Here are the reports I create to achieve this. 

Hi tstjuste,

You can run the Transaction List by Customer report to show the invoices and its' payment. Let me guide you with the steps.

1. Click Reports at the top.
2. Select Customers & Receivables, and then choose Transaction List by Customer.
3. Under the Num column, it will show the invoice numbers. 

Once done, you can open the payment transactions to view more details.

I have attached screenshots for your visual guide.

I have also included this link for your future references: Reports.

Keep me posted if there's anything else you need. I'm right here to help.

This is not what we are looking for. We need a report, for auditing purposes, that shows all payments for a particular period that lists all of the invoices that the payment was applied to, that could be printed out.

Or, a report that lists all invoices for a period that shows the payment number, that can be printed out.

We appreciate you for coming back and providing details on what report you need, Thinojosa.

The option to show the lists of invoices with payments linked from it is unavailable. However, you can run the Transaction List by Customer report to show the list of invoices and payments. Then, customize the columns to show the transaction type, date, and transaction number.

Here's how:

1. Click Customize Report tab on the upper left side of the report.
2. Choose Display.
3. Under the Columns field, select Type, Date, and Num.
4. Hit Filters tab.
5. Select Transaction Type in the Choose Filter field.
6. Tick the Transaction Type drop-down and choose Multiple Transaction Types.
7. Place a checkmark for Invoice and Payment.
8. Tap OK. Then, press OK again.

You can also export the report to Excel to come up wth the data you need. Just click the Excel button at the top of the report and select Create New Worksheet.

I'll personally share your product suggestion to our engineers regarding this one.

For more details about customizing reports, you can check out these articles:

• Customize reports in QuickBooks Desktop
• Customize customer, job, and sales reports in QuickBooks Desktop

Visit the Community again if you need anything else with running reports in QuickBooks. I'm here to help.

Hi RCV

Thanks for your detailed steps.

AGREED!!! QB seriously?

I created this one.  You can have multiple vendors or run the report for just one vendor and it will show what invoices were paid with each EFT or check payments.  Hope that's what you were looking for.

Again, these answers "solved" by Quickbooks employees are not anything close to being solved.

We need the software to report invoices with all payments listed by invoice in a report.

Having to enter each individual invoice record before clicking payment details DOES NOT CUT IT. We can't even print this information, which we go to great lengths to enter this information accurately

We need this report and this functionality to help us get paid!

For this software not to support reports with invoice payment details is no longer acceptable. It's been forever. Thousands have been spent by individual customers over many years, and it's time for Intuit to step up.

Please step up, Intuit.

Stop with this "solved" nonsense.