cancel
Showing results for 
Search instead for 
Did you mean: 
laura-allen
Level 1

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

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? 

Solved
Best answer October 15, 2018

Best Answers
nicole
Level 3

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

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!

View solution in original post

5 Comments 5
nicole
Level 3

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

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!

davidatp
Level 1

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

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.

JonpriL
Moderator

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

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.

Vickie-Ongweoweh Management
Level 1

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

HOW DO WE RUN A VENDOR TRANSACTION REPORT THAT ACTUALLY PULLS IN THE VENDOR SHIPPED FROM FIELD?

 

katherinejoyceO
QuickBooks Team

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

Hello @Vickie-Ongweoweh Management,

 

You'll need to filter the settings from your vendor transaction report to display the Vendor shipped from.

 

 Here's how:

 

1. Go to Reports at the left panel.
2. Type in Transaction List by Vendor in the search bar.
3. Filter the date at the Report period drop-down menu.
4. Click the Settings icon.
5. Click Show More.
6. Check the box for Vendor shipped from.

 

The SHIPPED FROM should display on your report as soon as you click the Run report tab.

 

For additional reference about printing and exporting customized reports, you can also read through this article link: How to Customize Reports.
 
Visit us again here in the Community if you need anything else. We'll be happy to serve you. Enjoy your weekend!

Need to get in touch?

Contact us