Skip to main content
A
arkvalleyinfo
October 16, 2018
Solved

Pull an Expense by Vendor Detail report filtering by specific Classes.

  • October 16, 2018
  • 1 reply
  • 0 views

On my desktop version of Quickbooks I was able to pull an Expense by Vendor Detail report filtering by specific Classes. This report helped me job cost. I need to know how much in payables that I still owe to all of my Vendors for one specific job. Unfortunately, I'm not finding that reports like the Vendor Open Balance Detail can be filtered by a specific Class, or grouping of Classes. Filtering by a specific Memo is also an option, but again these reports do not allow me to filter by Memo. 

The Transactions Detail by Vendor is helpful because it can filter by Class, but the Open Balance column is totally blank. Why is it not populating data? 

Best answer by nicole11_2

Hello laura.allen,

At the moment, you can't run an Expense by Vendor Detail report and customize it by the vendor's open balance and classes. You need to run the Transaction List by Vendor report that will show the vendor's open balance and Expenses by Vendor Summary report. Export the reports to an excel file and customize it from there.

  1. Go to the Reports tab.
  2. Enter Transaction List by Vendor in the search bar.
  3. Click the Customize button at the upper left.
  4. Click the Change Columns button.
  5. Select Open Balance under Available Columns. From there, you can also add a column you want to show in your report.
  6. Click Add.
  7. Click OK.
  8. Click Run Report.

To customize Expenses by Vendor Summary report, click the Customize button, then click on the drop-down labeled Column and select Classes.

I'd suggest sending feedback to our engineers and let them know you want this report added to the program. To send feedback, please follow this link: http://feedback.qbo.intuit.com.

Please let me know how it goes. Thanks!

1 reply

N
nicole11_2Answer
October 16, 2018

Hello laura.allen,

At the moment, you can't run an Expense by Vendor Detail report and customize it by the vendor's open balance and classes. You need to run the Transaction List by Vendor report that will show the vendor's open balance and Expenses by Vendor Summary report. Export the reports to an excel file and customize it from there.

  1. Go to the Reports tab.
  2. Enter Transaction List by Vendor in the search bar.
  3. Click the Customize button at the upper left.
  4. Click the Change Columns button.
  5. Select Open Balance under Available Columns. From there, you can also add a column you want to show in your report.
  6. Click Add.
  7. Click OK.
  8. Click Run Report.

To customize Expenses by Vendor Summary report, click the Customize button, then click on the drop-down labeled Column and select Classes.

I'd suggest sending feedback to our engineers and let them know you want this report added to the program. To send feedback, please follow this link: http://feedback.qbo.intuit.com.

Please let me know how it goes. Thanks!

D
davidatp
March 21, 2019

Is there a way to pull a vendor detail report that already has formulas in place when it is exported to excel? I know this happens when you export a larger P&L/Balance sheet to excel so i was wondering if the same could be done for this report.

J
JonpriL
March 21, 2019

Hello there, @davidatp!

 

At this time, QuickBooks Online exports your data into MS Excel in actual values, not formulas.

 

Yes, you're correct about exporting your Profit and Loss and Balance Sheet reports to excel includes formulas. But only these two reports has formulas on excel.

 

If you haven't yet, here's how you can export your vendor reports to excel:

  1. Go to Reports page.
  2. Select any of your vendor reports and open it.
  3. Click the Export button.
  4. Choose Export to Excel.

Once done, you can now open your vendor reports to excel. In addition, I've included our detailed guide in exporting your reports to excel.

 

Please don't hesitate and let me know if you have any other questions about your reports and exporting them. It'll be always my pleasure to share my expertise in helping you out.

Terms & ConditionsAccessibility statement