Multi class expenses by vendor report

Thank you for your efforts in generating the multi-class expenses by vendor report, @laperna1. Separating expenses by vendor through classifications is crucial for creating a comprehensive budget report for 2024. Although customizing the expenses by vendor report can be challenging due to its reliance on specific data parameters, there's no need to worry. I can provide some detailed information to help you accomplish this task.

Let's begin by using the Custom Report from the Reports menu. From this report, we can achieve it by using the Summary as our data source and utilizing the class as a column and vendor as a row. Then, a few steps to keep the data reliable is to filter this report whether using Accounts with specific Expenses and Other Expenses or Transaction Types for checks, item receipts, and bills.

Here's how:

1. From the Reports menu and then select Custom Reports.
2. Choose Summary.
3. From the Display columns by field, pick Class from this list.
4. Then choose Vendor from the Display rows by column.
5. Tick Amount from the Display columns for section and choose a starting and ending date from the Dates' From (like January 1, 2024) and To (December 31, 2024) selection field respectively.
6. Go to Filters and then from the Search Filters box if you choose Account, customize it to show Expense and other expense accounts.
   
   
7. Click OK.
   
   

However, if you want to select Transaction Type, you can follow the same steps above excluding the direction specific to Accounts. Just make sure to select the Account from the Current Filter Choices section and then click Remove Selected Filter to clear it first. And then select Multiple Transaction Types and then choose all applicable expense transactions made for vendors like Check, Bill, and Item Receipt, and then hit OK. This way, you can depict total expenses by vendor by class. I've added video snippet and a screenshot below:

Doing this can help you display a much better vendor expense report for class for the year. The information in the Profit and Loss report is less achievable since this only displays specific accounts by class or show expenses by vendor as a column.
 

For a great overview about customizing reports and getting a better data output, you can check these articles:

• Customize reports
• Understand reports

That's it and you're good to extract this data to print or memorize it and start creating your budget and forecast. Please refer to this article for more details to access and modify it later for future use: Create, access and modify memorized reports.

I know this is a little bit tricky but I'm glad sharing you out a modified vendor reports to show each class expenses. Always let me know if you need more help about it and I'll be there to provide solutions anytime. Take care,  @laperna1.

That worked!  Thanks for the help!  Laurie

Thanks for following up with the Community, laperna1.

I'm happy to hear Jovychris_A was able to help with running a report to show expenses by class.

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

Please feel welcome to send a reply here or create a new thread if there's ever any questions. The Community's always here to help. Have an awesome Thursday!