cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Contributor **

Is there any report which shows payments with invoices?

Dear All,

 

I am using QB Premier Desktop 2018. Is there any report which shows payment (check) numbers and corresponding invoice numbers, as follows.

 

Payment      Invoice

282123       812343

282123       812567

212313       821456

Solved
Best answer 04-10-2019

Accepted Solutions
QuickBooks Team

Re: Is there any report which shows payments with invoices?

Hi there, BenTam.

 

QuickBooks can only generate the numbers per transaction type. If you've entered the payment number on the Memo field, then we can add the Memo column on any sales report. Otherwise, you'd have to open each transaction to get the data you need.

 

You can run the Transaction List by Customer report to get the invoice numbers.

 

Here's how:

  1. Click Reports at the top.
  2. Select Customers & Receivables, and then choose 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.

You can also export this report to Excel, edit the columns there, and then add the payment numbers. To do this, click the Excel button at the top of the report and select Create New Worksheet.

 

You can always get back to me if you need anything else. Thanks for dropping by.

9 Comments
QuickBooks Team

Re: Is there any report which shows payments with invoices?

Hi there, BenTam.

 

QuickBooks can only generate the numbers per transaction type. If you've entered the payment number on the Memo field, then we can add the Memo column on any sales report. Otherwise, you'd have to open each transaction to get the data you need.

 

You can run the Transaction List by Customer report to get the invoice numbers.

 

Here's how:

  1. Click Reports at the top.
  2. Select Customers & Receivables, and then choose 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.

You can also export this report to Excel, edit the columns there, and then add the payment numbers. To do this, click the Excel button at the top of the report and select Create New Worksheet.

 

You can always get back to me if you need anything else. Thanks for dropping by.

Established Member

Re: 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.

Moderator

Re: Is there any report which shows payments with invoices?

Hi rsaunar,

 

We've been gathering product suggestions from our customers that will be useful to all users. I'll personally send this feedback to our Product Developers Team for review.

 

We appreciate you sharing this with us. If you have any other questions, please let us know. We are here to help. 

wdi
Senior Explorer ***

Re: Is there any report which shows payments with invoices?

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. 

Moderator

Re: Is there any report which shows payments with invoices?

Hi wdi,


You can temporarily use the Transaction List by Customer report to view the invoice and payments. However, it won't show which invoices the payments were paid for. Another way would be going through each customer profile to view the transactions list. 

 

This request has been sent to our Product Developers Team. We'll reach out to you if there are any updates.

 

If you've got more questions, please post them here. 

Experienced Member

Re: Is there any report which shows payments with invoices?

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

Super Contributor **

Re: Is there any report which shows payments with invoices?

Hi Sophia,

 

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

QuickBooks Team

Re: Is there any report which shows payments with invoices?

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. 

Super Contributor **

Re: Is there any report which shows payments with invoices?

Hi Mary,

 

Thanks for your reply. It really helps.