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.

View solution in original post

15 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.

View solution in original post

Not applicable

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
Super 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. 

Not applicable

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.

Moderator

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.

Not applicable

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

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?

Not applicable

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

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. 

Experienced Member

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

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.

Experienced Member

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

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. 

Not applicable

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

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. 

Not applicable

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

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

Need to get in touch?

Contact us