mikeshick
Level 3
posted
January 21, 201906:42 PM
last updatedJanuary 21, 20196:42 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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!Go to Solution.
Solved
Labels:
- QuickBooks Desktop
1
Cheer
Reply
Join the conversation
Best answer January 22, 2019
Solved
Best Answers
Anonymous
Not applicable
January 22, 201901:59 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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 opena Check Detail report then let's filter the transaction type.
Here's how:
- Go to Reports menu and click Report Center.
- Type in Check Detail on the search field to locate the report.
- Then, let's run the Check Detail to open the report.
- 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
1
Cheer
Reply
Join the conversation
21 Comments 21
ShiellaGraceA
QuickBooks Team
January 21, 201909:40 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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:
- Click Reports, then click Vendors & Payables.
- Click Transaction List by Vendor.
- Click Customize Report at the top.
- Click the Filters tab. Then, click Transaction Type in the Filter drop-down.
- Choose Multiple Transaction Types.
- Put a check mark next toBill, Bill Payment, Check, and Invoice.
- 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.
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 22, 201911:26 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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?
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 22, 201911:30 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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
Cheer
Reply
Join the conversation
Anonymous
Not applicable
January 22, 201901:59 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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 opena Check Detail report then let's filter the transaction type.
Here's how:
- Go to Reports menu and click Report Center.
- Type in Check Detail on the search field to locate the report.
- Then, let's run the Check Detail to open the report.
- 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.
1
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 22, 201905:09 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
How can I print a payment history report for a Vendor
Beautiful! Thank you.
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 22, 201905:58 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Cheer
Reply
Join the conversation
Anonymous
Not applicable
January 22, 201909:18 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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:
- Click on the Reports menu.
- Select Customers & Receivables.
- Choose Transaction List by Customer.
- Click on Customize Report.
- In the search box for COLUMNS, enter Paid and Paid Date.
- Click on OK.
Please post more questions if you need anything else.
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 23, 201904:18 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Cheer
Reply
Join the conversation
Kristine Mae
Moderator
January 23, 201904:45 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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 comefrom 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!
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 23, 201907:20 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Cheer
Reply
Join the conversation
vpcontroller
Level 11
January 23, 201907:48 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
How can I print a payment history report for a Vendor
.
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 23, 201912:30 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
How can I print a payment history report for a Vendor
That's exactly what I would want, but I'm using desktop :(
Cheer
Reply
Join the conversation
MirriamM
Moderator
January 23, 201902:47 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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!
Cheer
Reply
Join the conversation
mikeshick
Level 3
January 23, 201902:55 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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
Cheer
Reply
Join the conversation
Holly31
Level 3
July 09, 202005:20 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
How can I print a payment history report for a Vendor
What if the payee is not a vendor?
Cheer
Reply
Join the conversation
bill89
Level 1
July 17, 202010:01 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Cheer
Reply
Join the conversation
marely
Level 2
October 02, 202004:08 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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
Cheer
Reply
Join the conversation
Nick_M
QuickBooks Team
October 02, 202006:01 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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 theMemofield belowTermsyou just have to customize the report after generating it.
Just go to theDisplaytab, go toColumnssection and click onMemoto add inthe report. Follow the steps below:
- Generate the report and then go toCustom Reportbutton.
- Go to theDisplaytab and go toColumnsand click Memo to add a check mark beside it.
- Click onOKonce 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!
Cheer
Reply
Join the conversation
Florence5
Level 1
February 16, 202109:22 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Cheer
Reply
Join the conversation
JenoP
Moderator
February 16, 202110:43 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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:
- Go to theReports menu, then clickVendors & Payables.
- SelectTransaction List by Vendor.
- ClickCustomize Reportat the top.
- Proceed to theFilterstab. Then, clickTransaction Typein thedrop-down list for Filter.
- SelectMultiple Transaction Types.
- Put a check mark next toBill,Bill Payment,Check, andInvoice.
- ClickOK, and thenOK again.
Aside from that, you can also go to the Vendor Center and run the report from there. Here's how:
- Go to the Vendors menu and select Vendor Center.
- Click the name of the vendor and go to the Transactions tab under the Vendor Information section.
- Select All Payments Issues in the drop-down list for Show.
- 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.
Cheer
Reply
Join the conversation
Florence5
Level 1
February 16, 202111:01 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Cheer
Reply
Join the conversation