cancel
Showing results for 
Search instead for 
Did you mean: 
mikeshick
Level 3

How can I print a payment history report for a Vendor

I'd like to be able to print payment history for a vendor for a period of time, so that I can essential provide a duplicate payment stub and see which invoices were paid by what checks.  Is there a report for this?

 

Thanks.

Solved
Best answer January 22, 2019

Best Answers
Anonymous
Not applicable

How can I print a payment history report for a Vendor

Hello, @mikeshick.

 

Allow me to chime in and help generate a report that'll track how each payment was applied.

 

Let's try to open a Check Detail report then let's filter the transaction type.

 

Here's how:

 

  1. Go to Reports menu and click Report Center.
  2. Type in Check Detail on the search field to locate the report.
  3. Then, let's run the Check Detail to open the report.
  4. Click the Customize tab and filter the transaction type.

This will show the payment history report for your vendor.

 

For more information about customizing reports in QuickBooks, you can check out this helpful article: https://community.intuit.com/articles/1764377-customize-reports-in-quickbooks-desktop.

 

Let me know if you have other questions about your applied payments. I'll be here to help. 

View solution in original post

21 Comments 21
ShiellaGraceA
QuickBooks Team

How can I print a payment history report for a Vendor

You can use the Transaction List by Vendor report, mikeshick

Here's how to get it:

  1. Click Reports, then click Vendors & Payables.
  2. Click Transaction List by Vendor.
  3. Click Customize Report at the top.
  4. Click the Filters tab. Then, click Transaction Type in the Filter drop-down.
  5. Choose Multiple Transaction Types.
  6. Put a check mark next to Bill, Bill Payment, Check, and Invoice.
  7. Click OK, and then OK.

Please see attached screenshot below.

You can also choose a preferred vendor to print the transaction history. 

I'm here if you have other questions in mind.

mikeshick
Level 3

How can I print a payment history report for a Vendor

Thank you.  This gets me really close, but it doesn't tell me how each payment was applied, so I'm left having to do that for each bill payment.  Is there a way to see that info, also?

mikeshick
Level 3

How can I print a payment history report for a Vendor

This is what I'd like to do but for a whole year.

https://www.dropbox.com/s/iadp4pjb5amjumd/2019-01-22_11-29-42.png?dl=0

Anonymous
Not applicable

How can I print a payment history report for a Vendor

Hello, @mikeshick.

 

Allow me to chime in and help generate a report that'll track how each payment was applied.

 

Let's try to open a Check Detail report then let's filter the transaction type.

 

Here's how:

 

  1. Go to Reports menu and click Report Center.
  2. Type in Check Detail on the search field to locate the report.
  3. Then, let's run the Check Detail to open the report.
  4. Click the Customize tab and filter the transaction type.

This will show the payment history report for your vendor.

 

For more information about customizing reports in QuickBooks, you can check out this helpful article: https://community.intuit.com/articles/1764377-customize-reports-in-quickbooks-desktop.

 

Let me know if you have other questions about your applied payments. I'll be here to help. 

mikeshick
Level 3

How can I print a payment history report for a Vendor

Beautiful!  Thank you.

mikeshick
Level 3

How can I print a payment history report for a Vendor

Would you kindly explain how to do the same for a customer for received payments.

Anonymous
Not applicable

How can I print a payment history report for a Vendor

You can also use the Transaction List by Customer report, mikeshick. 

 

Let's customize it to show the receive payment histories for your customers. Here's how:

  1. Click on the Reports menu.
  2. Select Customers & Receivables
  3. Choose Transaction List by Customer.
  4. Click on Customize Report.
  5. In the search box for COLUMNS, enter Paid and Paid Date.
  6. Click on OK.

Please post more questions if you need anything else. 

mikeshick
Level 3

How can I print a payment history report for a Vendor

This last suggestion for Transaction list by Customer didn't quite do what I was looking for.  I'd like to be able to see all payments for a customer, but also see to what invoices those payments were applied in the very same report.  Is that possible.

Kristine Mae
Moderator

How can I print a payment history report for a Vendor

Hello, Mikeshick.

 

When you pull up any customer reports, you're unable to see what invoices the payments are applied to. For now, you can follow my colleague @GarlynGay's suggestion, then manually check the transactions.

 

You can send feedback to have this idea added to our future updates. Most of our features/updates come from our user's insights. You can do that by clicking the Help menu, going to Send Feedback Online, then choosing Product Suggestion

 

Feel free to post if you have other concerns. Have a good one! 

mikeshick
Level 3

How can I print a payment history report for a Vendor

Well, actually i got much closer by starting with the "Payments and the Invoices and Deposits They Are Linked To."

 

Then:

>Custom Report

>Filters

>Transaction>Payment

>Account>All Accounts Receivable

>Name>Customer of Choice

 

This works pretty well, and does tell me which invoices were paid by a single payment.  However, I don't like how the report shows the payment split detail.  In other words, it shows:

Payment 1    $50

Invoice 1      $50

Invoice 2      $25

Invoice 3      $30

 

Payment 1    $25

Invoice 1      $50

Invoice 2      $25

Invoice 3      $30

 

Payment 1    $30

Invoice 1      $50

Invoice 2      $25

Invoice 3      $30

--------------------------------------------------------------------------------

Instead, I would like to see:

Payment 1 $105

Invoice 1      $50

Invoice 2      $25

Invoice 3      $30

 

But at least this report gets me closer to what I'm trying to accomplish rather than double click to view every payment individually.

vpcontroller
Level 11

How can I print a payment history report for a Vendor

.

mikeshick
Level 3

How can I print a payment history report for a Vendor

That's exactly what I would want, but I'm using desktop :(

MirriamM
Moderator

How can I print a payment history report for a Vendor

Great day to you, mikeshick,

 

Appreciate your response and verifying the version of your QuickBooks product.

 

I was able to pull up a report with the information you need. Just to verify if this is the report you're looking for? See screenshot below for your reference:

 

 

If yes, please know that you'll be able to track the paid transaction if you've able to add the transaction number in the Memo field when receiving payment.

 

However, if you mean something else, please feel free to reach us back. Have a great day!

mikeshick
Level 3

How can I print a payment history report for a Vendor

That sort of works.  But much like the Bill Payment History Report, I dont want to have to add memos, especially when the payments apply to multiple invoices at once.  See Payment History for reference:

https://www.dropbox.com/s/ej83095n9kx7nwa/2019-01-23_14-52-56.png?dl=0

 

see the problem i have, with a solution that almost works:

https://www.dropbox.com/s/ea9gh7e17dhu2ga/2019-01-23_14-57-01.png?dl=0 

 

Holly31
Level 3

How can I print a payment history report for a Vendor

What if the payee is not a vendor?

bill89
Level 1

How can I print a payment history report for a Vendor

i understand the check detail.  can i get the same detail for credit card payments.  instead of writing checks we batch several invoices and pay with a credit card.

marely
Level 2

How can I print a payment history report for a Vendor

i am trying to print the payment report for a vendor but is there any way i can see the MEMO or the DESCRIPTION in the report? 

i only see

DAte

Type

N.

Payee

Category

Total 

and Attachment 

Nick_M
QuickBooks Team

How can I print a payment history report for a Vendor

Hey there marely. 

 

Thanks for dropping by the Community. I'm happy to shed some light on this for you. If you’re referring to the Memo field below Terms you just have to customize the report after generating it.

 

Just go to the Display tab, go to Columns section and click on Memo to add in the report. Follow the steps below:

 

  1. Generate the report and then go to Custom Report button. 
  2. Go to the Display tab and go to Columns and click Memo to add a check mark beside it. 
  3. Click on OK once you're done. 

Check this report for more information: Customize reports in QuickBooks Desktop.

 

Keep me posted if there’s anything else that I can help with your reports by leaving a comment below. Take care and have a wonderful day!

Florence5
Level 1

How can I print a payment history report for a Vendor

Hi, 

This report is not working for me, it only brings up an empty window with no transaction. Could you please run me through the report creation again? Thanks.

JenoP
Moderator

How can I print a payment history report for a Vendor

Good day, Florence5.

 

I'd be glad to walk you through the steps on how to run the report. Also, make sure that the date in the Dates section of the report is correct. 

 

Here's how:

 

  1. Go to the Reports menu, then click Vendors & Payables.
  2. Select Transaction List by Vendor.
  3. Click Customize Report at the top.
  4. Proceed to the Filters tab. Then, click Transaction Type in the drop-down list for Filter.
  5. Select Multiple Transaction Types.
  6. Put a check mark next to BillBill PaymentCheck, and Invoice.
  7. Click OK, and then OK again.

 

Aside from that, you can also go to the Vendor Center and run the report from there. Here's how:

 

  1. Go to the Vendors menu and select Vendor Center.
  2. Click the name of the vendor and go to the Transactions tab under the Vendor Information section.
  3. Select All Payments Issues in the drop-down list for Show.
  4. Click Run reports at the bottom of the screen. 

 

Please don't hesitate to add another reply and visit us again if you have any other questions. The QuickBooks Team is always here to help. 

 

Florence5
Level 1

How can I print a payment history report for a Vendor

Thanks, 

This report does not show very clearly, however, which payments are applied to which invoices, so it remains a bit hard to read and analyze.

Need to get in touch?

Contact us