Skip to main content
M
member1000
February 10, 2020
Question

Vendor Ledger Report

  • February 10, 2020
  • 2 replies
  • 0 views

How do I create a vendor ledger report?

 

I want to see all bills, bill payments, credit memos, etc. for a specific vendor. How do I do it in QB Online?

 

In Quickbooks desktop there was a beautiful report called "vendor balance summary" and when clicking into one vendor, you could see everything from this vendor. Where can I find this in QB Online?

2 replies

MarsStephanieL
MarsStephanieL
February 10, 2020

You can find in in the Report tab, member1000.

 

You can see the vendor's transaction in the Reports tab in QuickBooks Online. Glad to show you the steps below.

 

Here's how:

 

  1. Go to the Hamburger icon and select Reports tab.
  2. Search for Transaction List  by Vendor.


     
  3. Verify the details and select Run report button.
     

You can also run a report for specific vendors. Here's how:

 

  1. In the Transaction List by Vendor report page, click the Customize button.
  2. Choose the Filter section and check the Vendor and select the vendor's name.
  3. Hit Run report button. (See screenshot below for your reference.)

 

 

Also, you can check this out memorize reports for future reference.

 

Loop me in if you have other concerns. Happy to lend a helping hand. Have a good one!

M
member1000Author
February 11, 2020

The report you suggested doesn't show a running balance. I'm looking for a report that has a running balance for a specific vendor.

 

Thank you.

Tori B
Tori B
February 11, 2020

Hey there, @member1000.

 

I'm here to get you on the right track. Let's run the Vendor Balance Summary report in QuickBooks Online.

 

Here's how:

 

1. Go to the Reports menu.

2. In the search field type in Vendor Balance Summary. Click on the drop-down option, as I have highlighted in the screenshot below.

3. This will show the vendor's balances, and you can click on the totals to zoom in on the list of transactions.

 

 

 

If you're still having some issues, or if this isn't what you're looking for, please reply to this thread, and I'll be here to help you every step of the way. Take care and enjoy your day!

 

JenoP
JenoP
February 11, 2020

Let me get the report that you need, member1000.

 

Instead of running the Vendor Balance Detail report, you can go to the vendor's profile and open the Transaction List.

 

The same page will also show you the vendor's current or running balance. This is something similar to what you can see in the Desktop version. Here's how:

 

  1. Go to the Expenses menu and proceed to the Vendors tab. 
  2. Click the name of the vendor.
  3. Select Transaction List.
  4. Click the Export icon in the right-hand side if you want to export the list to Excel.
  5. The vendor's current balance is also shown just above the Export icon. 

Let me know if you need a different report. I'll get back here to help you again.

 

M
member1000Author
February 12, 2020

This report doesn't show a running balance.

When I exported the report to excel, both bills and payments (called expenses in QB) were a positive number. I need bills to be a positive number and payments to be a negative number so I can see the running balance.

M
MadelynC
February 12, 2020

Hi member1000,

 

The answer given by my colleague JenoP will give you the list of transaction that has Bills as positive and Payments are negative.

 

To exclude the other transactions of the vendor, you’ll want to filter it first to bill and payments as a type of transaction then proceed to export.

 

You can also run a transaction List by Vendor and filter the transaction types then export. This will also show the bill as positive and the payment will be negative.

 

Here’s how:

 

  1. Select Reports in your left navigation pane, then click Customize.
  2. Select the date period.
  3. Hit Filter then selects the dropped-down button under Transaction type.
  4. Choose Bill and Bill Payments.
  5. Click Run Report.
  6. Select Export.

 

Performing these steps above will bring you on the right track.

 

To get specific details of your financial reports, you can check this article: Customize reports in QuickBooks Online.

 

I also added this link to learn more about managing your QBO account: Help articles. I’m sure you’ll find it helpful.

 

Should you have an additional concern, I’m always here to help.

Terms & ConditionsAccessibility statement