Report showing bills and payments to Vendor, grouped by Customer

I'm happy to see you in the Community, JABu.

I can share a report that contains these columns.

You can run the Transaction Detail report and customize it by following these steps:

1. Go to Reports > Custom Reports > Transaction Detail.
2. In the Modify Report: Customer Transaction Detail Report window, click the Display tab.
3. Set the appropriate date range.
4. In the Columns section, type Source Name and put a check mark to it. Then, Type Name and un-check it to remove it from the list.
5. From the Total By drop-down menu, select Customer.
6. Go to the Filters tab and search for the Transaction Type.
7. Select the Multiple Transaction types from the Transaction Type drop-down list and choose the transactions associated with the Vendor purchases (i.e. Bill. Bill Payment, or Check).
8. Hit OK to display the report.

Please see this sample screenshot for a visual reference:

For reference on the steps above, go to the Vendor expenses by Customer:job section in this article: Customize vendor reports.

Please let me know if you're looking for something else. I'll be around to help you out some more. Thanks.

Thanks, but that shows all transactions for the given customers. I need to limit it to 1 specific vendor.

Hi JABu,

I'm letting our engineers know that the report you're looking for is not available. That way, they can consider adding it in future updates. You can also send a suggestion by going to the Help menu and choosing Send Feedback Online.

In the meantime, you can open each transaction to know which check and customer are associated to a bill. That way, you can create a comprehensive report in Excel. You can also check about exporting reports to Excel.

Feel free to go back to this thread if you need more help.

I frequently need a report showing payment/bills to a vendor for a specific customer. Please add this "customer: job" column to  a vendor report filter. ASAP would be nice.

I understand that the features you stated are useful for you, jetco.

You can submit another feedback straight to our product developers. To do this, here's how:

1. Go to the Help menu at the top.
2. Select Send Feedback Online.
3. Click Product Suggestion. 
4. Click on the drop-down for Type of Feedback and select Product Suggestion.
5. Select the Product Area.
6. Enter your thoughts and suggestions.
7. Click Send Feedback.

Please know that your voice matters and that updates and changes to QuickBooks are the results of feedback by users like you.

Need help with managing your vendors? You can visit our Help page. It provides a reference for future use.

You can post again here if you need anything else. The Community is ready to help.

How can you create this report for Quickbooks Online? Thanks,

Hey there, @seonjoo-ccc. 

Thanks for chiming in on this thread. It's great to see you back in the Community. 

The best report to run in QuickBooks Online would the Transaction Detail by Account. Here's how to: 

1. Go to the Reports tab on the left-hand menu bar. 
2. Choose the Reports portion of the page. 
3. Ensure that you're on the Standard section. 
4. Scroll down to the For my accountant section. 
5. Pick the Transactions Detail by Account report. 

From there, you can customize it to your liking. 

This should do the trick. Don't hesitate to reach back out if you have any trouble along the way. Have a splendid day! 

I have needed this report as well.  I ran a "Transaction Report" and then in the "Filter" section of customizing the report you can select a specific vendor and customer.

I need to know how can I print out a report for a date range of bills that I have paid to vendors?

It's nice to see you here in the Community, @Relmanagement. I'm happy to guide you in printing a report for bills you paid to vendors in QuickBooks Desktop (QBDT).

To do so, you simply need to select the Print option located at the upper right corner of the report page. Follow along below to get this done right away:

1. In your QBDT program, select the Reports tab. 
2. Scroll down to the Vendors & Payables section and click Transaction List by Vendor.
3. Next, select the Customize Report button and go to the Columns field.
4. From there, look and check the Paid option.
5. Then, click the Filter tab and search for Transaction Type.
6. Choose Multiple Transaction Types and check Bill and Bill Payment.
7. When finished, click OK twice.
8. You'll be routed back to the report page. From there, select the Print option and choose Report.
9. Set the printing settings and click the Print button when ready.

For reference in managing vendor reports, feel free to check this article: Customize reports in QuickBooks Desktop.

I've also attached this helpful resource that you can use as a guide in handling transactions for vendors: Accounts Payable workflows in QuickBooks Desktop.

Please let me know how this goes. I want to ensure you'll be able to print the report you need. Have a good one and keep safe always.

When you choose Customer as the grouping, you cannot then choose Bill Payment (either by check or cc) as a transaction type.  You can still use the status to only get the bills paid but you cannot get the payment transactions and thus the date the bill was paid or how it was paid (check or cc).  This would be great to have!  I will fill out the suggestion form.

You are a goddess! Thank you

You're always welcome, Kity.

I'm glad that the information and guidelines my colleague outlined help you obtain vendor reports showing the bills you have paid to them in QuickBooks Desktop (QBDT). 

Rest assured, every concern posted in the Community will be addressed accordingly. Having said that, be bold and ask any other QuickBooks questions you may have here.

I want your business to prosper. Have a wonderful day!