Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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.
You can use the Transaction List by Vendor report, mikeshick.
Here's how to get it:
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.
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?
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
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:
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.
Beautiful! Thank you.
Would you kindly explain how to do the same for a customer for received payments.
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:
Please post more questions if you need anything else.
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.
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!
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.
.
That's exactly what I would want, but I'm using desktop :(
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!
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
What if the payee is not 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.
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
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:
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!
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.
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:
Aside from that, you can also go to the Vendor Center and run the report from there. Here's how:
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here