cancel
Showing results for 
Search instead for 
Did you mean: 
LIJ
Level 2

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.

I have many invoices where we make multiple payments on the bill in QBO, usually combined with other bills from that same vendor.
11 Comments 11
Rustler
Level 15

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

LIJ
Level 2

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.

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.

JenoP
Moderator

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.

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: 

 

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

LIJ
Level 2

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.

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.

Joseph_A
QuickBooks Team

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.

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!

 

AlohaAndy
Level 2

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.

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.

 

 

AlohaAndy
Level 2

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.

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! 🤷🏼‍♂️

 

 

AlohaAndy
Level 2

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.

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.

😅

Anonymous
Not applicable

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.

am i the only one not seeing the Reports > Standard > What You Owe > Bills and Applied Payments ????

Jen_D
Moderator

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.

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!

Builder Girl
Level 1

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.

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. 

Need to get in touch?

Contact us