cancel
Showing results for 
Search instead for 
Did you mean: 
BenTam
Level 5

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 April 10, 2019

Best Answers
SophiaAnnL
Moderator

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

119 Comments 119
SophiaAnnL
Moderator

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.

rsaunar
Level 3

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.

Anonymous
Not applicable

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
Level 4

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. 

Anonymous
Not applicable

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. 

Thermos
Level 1

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

BenTam
Level 5

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.

MaryLurleenM
Moderator

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. 

BenTam
Level 5

Is there any report which shows payments with invoices?

Hi Mary,

 

Thanks for your reply. It really helps.

loudcanvas
Level 1

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?

arthur1halevy
Level 1

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. 

Thinojosa
Level 1

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.

BA-PWNA
Level 1

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. 

rsaunar
Level 3

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. 

rsaunar
Level 3

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?

tstjuste
Level 2

Is there any report which shows payments with invoices?

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. 

tstjuste
Level 2

Is there any report which shows payments with invoices?

Here are the reports I create to achieve this. 

MariaSoledadG
QuickBooks Team

Is there any report which shows payments with invoices?

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.

 

 

 

 

Thinojosa
Level 1

Is there any report which shows payments with invoices?

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.

RCV
QuickBooks Team
QuickBooks Team

Is there any report which shows payments with invoices?

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:

 

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

 

report 01.PNGreport 02.PNG

BenTam
Level 5

Is there any report which shows payments with invoices?

Hi RCV

 

Thanks for your detailed steps.

mgorak
Level 1

Is there any report which shows payments with invoices?

AGREED!!! QB seriously?

tstjuste
Level 2

Is there any report which shows payments with invoices?

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.

rsaunar
Level 3

Is there any report which shows payments with invoices?

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us