How do I get a report on QBO that shows the bills from a vendor and all payments made on those bills. In a grouping with each bill.

in reports, enter purchases in the search box and select purchase by vendor detailed

that just lists the bills, I also need the breakdown of what payments have been made on each bill. My company sometimes makes 5 or 10 payments on a bill.

Joining the thread to help with the report that you need, LIJ.

You can run the Bill and Applied Payments report. This will give you all the payments you’ve made and the bills that go with them. Here's how:

1. Go back to the Reports menu.
2. Scroll-down to the What you owe section and look for Bill and Applied Payments.
3. You can also type in the name of the report in the Search bar to easily find it.

Let me also share these articles about running reports in the program for additional reference: 

• Reports Included In Your QuickBooks Online Subscription
• Customize Reports in QuickBooks Online
• Popular Custom Reports in QuickBooks Online

Don't hesitate to reach out to us again if you need more help. We're always here for you. ​​​​​​​

Thanks but that's not quite what I need either. I want it to give me a bill and then the dates and amounts of payments made on that bill. You can see it that way when you are in the bill itself by clicking on the 'payments made' in blue in the upper right corner of the screen. But I can't get a report that way. The Bills and Applied Payments Report tells me the amount of a payment and the the total amount of the bills but not the breakdown of how much was applied to each bill.

Hello there, @LIJ.

As of now, the options provided in running reports for the bill are the only available options inside QuickBooks. If you want more personalized customization of your reports, you can use a third-party application. 

Here's how you can choose a third-party application:

1. On the left navigation pane, go to Apps.
2. Go to the Find apps tab.
3. Enter the app name in the search bar or select the Browse category drop-down menu to check out different apps.

Follow this article on how you can install the app: Install and use apps.

You can also check some of the popular apps that can be integrated into QuickBooks: https://quickbooks.intuit.com/app/apps/home/

The Community is always open and ready to help you out. Have a great day!

This is unfathomable!

Generating a list of bills & payments to a particular vendor is a very basic accounting task.

After spending some $300 monthly for QBO subscriptions I still have to export to Excel or buy additional 3rd party subscriptions that may or may not suffice?

Please tell me there is a readily generated Vendor Report in 2021 showing bills & payments?

This is painful to be spending so much time to research QBO's can and cannot do nuances to accomplish essential business bookkeeping requirements.

Please tell me there is a readily generated Vendor Specific Report in 2021 showing billing & payments?

Generating a list of bills & payments to a particular vendor is a basic accounting task.

This is painful to be spending so much time to research QBO's can and cannot do nuances to accomplish essential business bookkeeping requirements.

After spending some $300 monthly for QBO subscriptions I still have to export to Excel?

This is unfathomable! 🤷🏼‍♂️

Here is a solution for others needing to track open balance of billing & payment for specific vendor. 

Go to Reports > Standard > What You Owe > Bills and Applied Payments

Customize > Filter

Specify Vendor

Add Open Balance column.

😅

Thanks for joining the thread, @Anonymous.

I can share some insights on how you can find the Bills and Applied Payments report in your QuickBooks Online account. Before that, I want you to know that the availability of the report is based on the subscription you have.

For now, this reporting is available in Plus and Advanced versions. To check your subscription info, follow the steps below:

1. Sign in to QuickBooks Online as a primary admin.
2. Click on Settings ⚙, then Account and settings.
3. Select Billing & Subscription.
4. In the QuickBooks Online section, you will see your QBO plan.

If you have Plus or Advanced, here is how you can locate the report.

1. Go to the Reports menu and tap the Standard tab.
2. Scroll down to the What you owe section.
3. You can also use the report finder and type in Bills and Applied Payments.
   

See this link to learn about the reports available for your QBO versions: Reports included in your QuickBooks Online subscription

Visit us again if you have other reporting questions. You can also mention me anytime, so I can help you out. Have a nice day!

I think what you are looking for is a check detail. 

Go to Reports, banking, check detail.

Filter on:

Name: Choose name

Transaction type: Bill Payment

Filter for the dates that you need. 

It will list the checks written to that vendor and, as long as you entered invoice numbers, it will show the invoice(s) that the check paid. 

Hi team,

May I check if it is possible to arrange the invoice number sequentially within the bill and applied payment report?

Thank you.

Thank you for joining the thread, @wq32. Let me help you with your report about bills and bill payments.

Running the report you want is currently unavailable in QBO. I suggest exporting your report to Excel and organizing it by invoice number. Here's how to export:

1. Go to Reports.
2. On the search bar, type Bills and Applied Payments Report.
3. Click the Export button. 
4. Hit Export to Excel.

If you want to customize your invoices and estimates, check out this article: Customize invoices, estimates, and sales receipts in QuickBooks Online.

Don't hesitate to comment below if you still have questions about your reports. Take care always.