Skip to main content
February 18, 2025
Question

Detail transaction report - Vendor

  • February 18, 2025
  • 1 reply
  • 0 views

I am urgently looking for a report like the Detail Transaction Report for a specific Vendor that shows what invoices were paid with each Bill Payment. I need to provide the vendor with detail showing them what invoices we believe our checks paid through all of 2024 to current, and the transaction report shows the invoices, credits and bill payments, but doesn't identify which invoices were paid with each check. The vendor didn't always apply the payments as we intended and so now we are at a point where they have agreed to review the detail we intended to help straighten things out.

 

Is there a report that will show the detail on which invoices were paid with each check other than looking at each individual check throughout the prior year?  Help!!

 

Thanks in advance for any guidance on this.

1 reply

February 18, 2025

Hello there, Deadwood Al.

 

Currently, the report you're looking for is unavailable in QuickBooks Desktop. However, I can assist you in generating the Vendor Bill Detail report to let you view the bills and bill payments associated with the vendor. I'm here to guide you through this process.

 

This report provides detailed information about your company's transaction with your vendor. Also, it offers assistance in identifying and tracking your bills and bill payments. To generate this report, here's how:

 

  1. Open your QuickBooks company file.
  2. Go to Reports, then Contributed Reports.
  3. Select Vendors & Payables, then choose Vendor Bill Detail report.
  4. Head to the Customize Report button, then Filters.
  5. Under the Columns section, please tick the following filters: Type, Date, Num, Name, Item, Account, Original Amount, and Paid Amount. Make sure to adjust the date to the correct one.
  6. Once done, head to the Filters tab, and search for transaction type.
  7. Click the dropdown, then select Multiple Transaction Types, and choose Bill and Bill Payments.
  8. After that, search for Name, then select All vendors from the dropdown.

 

Afterward, it will show you all your bills and bill payment transactions made for your vendor.

 

Here's a screenshot for your reference:

 

 

Also, here are some articles you can save or bookmark for help with exporting or retaining your customized report in QuickBooks:

 

 

If you have other concerns or questions regarding generating reports for your vendors, don't hesitate to post in this forum, Deadwood Al. We're always here to assist anytime.