cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.

Reply to message

View discussion in a popup

Replying to:
Jovychris_A
Moderator

Reply to message

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:

1.mp4
Video Player is loading.
Current Time 0:00
Duration 0:07
Loaded: 100.00%
Stream Type LIVE
Remaining Time 0:07
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected
    • en (Main), selected
    (view in My Videos)

     

    2.mp4
    Video Player is loading.
    Current Time 0:00
    Duration 0:24
    Loaded: 40.94%
    Stream Type LIVE
    Remaining Time 0:24
     
    1x
      • Chapters
      • descriptions off, selected
      • captions off, selected
      • en (Main), selected
      (view in My Videos)


       

      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:

       

      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.

      Need to get in touch?

      Contact us