cancel
Showing results for 
Search instead for 
Did you mean: 
YehudaKalshi
Level 2

P&L Report split by account and then vendor

Hi,

Is there a way to run a report that is a P&L split by account (as usual) and then by vendor?
I want to see how much I spend on each vendor inside each expense account.

I know I can run a transaction by vendor report, but that gives me all the vendors in a period without any indication of which expense account everything is in.

Any ideas?

-Yehuda

7 Comments 7
Giovann_G
Moderator

P&L Report split by account and then vendor

Hello, Yehuda.

 

Yes, there is a way. You have the option to customize the Profit and Loss Detail report to show only the expense accounts. I'll show you how.

 

  1. Go to the Reports menu.
  2. Run Profit and Loss Detail report.
  3. Click the Customize button.
  4. Enter the correct reporting period.
  5. Go to the Filter section.
  6. Choose All Expenses Accounts under the Distribution Account dropdown.
  7. Once done, hit Run report.

 

Furthermore, you can also memorize the report to save the current customized setting. By doing this, you can avoid repeating the same steps whenever you want to run the same report in the future.

 

I'll be here to help you if you need further assistance with reports. Have a great day.

YehudaKalshi
Level 2

P&L Report split by account and then vendor

Hi,

Thank you for the response.

This doesn't get me the desired result.

I want it to have a line for the expense account and then, on the next row, have a breakdown of each vendor within that account.

 

For Example:

Expense Account 1 - $10,000

   Vendor 1- $200

   Vendor 2- $1,000

   Vendor 3- $8,800

Expense Account 2- $300

   Vendor 4- $100

   Vendor 2- $100

   Vendor 5- $100

Total Expense- $10,300

 

I managed to do this with Excel using a Pivot Table, but I see no reason QBO shouldn't be able to do this simple thing natively.

Any more ideas?

Thanks,

-Yehuda

Rea_M
Moderator

P&L Report split by account and then vendor

Thanks for the immediate response, @yehuda.

 

Let's send feedback or product recommendations to help improve the reporting feature and your experience using QuickBooks Online (QBO).

 

For the time being, the option to customize the Profit and Loss (P&L) report to have a breakdown of each vendor within a specific expense account is unavailable in QBO. The system will display the list of expense transactions linked to that account. With this, you can continue performing your workaround using Excel to get your desired result.

 

On the other hand, I can see how the benefit of being able to customize the P&L report to have a breakdown of each vendor within a specific expense account would aid you in managing your expenses with QBO. With this, I would encourage you to send suggestions or product recommendations. We'll take them as opportunities to improve the various features of our products.

 

Your valuable feedback will be forwarded and reviewed by our Product Development team and will help improve your experience while using the program. Here's how:

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Type in your recommendation in the Share your feedback field.
  4. Click Next.
  5. Follow the on-screen instructions to complete the process. 

 

Also, you may want to check out this article as your reference to guide you in pulling up customer or vendor reports to see all their payments and compare your income and expenses in QBO: Common custom reports in QuickBooks Online.

 

On top of that, I'd also recommend visiting this page to keep you updated with the latest software improvements and enhancements with QBO: Customer Feedback for QuickBooks Online.

 

Let me know if you have other reports and feature concerns in QBO. I'll gladly help. Take care, and I wish you continued success, @yehuda.

Katie101
Level 1

P&L Report split by account and then vendor

I would also like to see this repot available!

SarahannC
Moderator

P&L Report split by account and then vendor

Hello there, Katie101.

 

Thanks for joining this thread and letting me know that you also want to have this report in QuickBooks.

 

I understand how important to get this report added to QuickBooks. That would surely help you run your business seamlessly and get all the data according to your need. Still, we can utilize the same steps above to add your suggestion. 

 

  1. Go to the Gear icon.
  2. Select Feedback under Profile.
  3. Enter your suggestion. Then, click Next.

 

Also, we can learn more from the articles below. Each of them provides information about handling QuickBooks reports.

 

 

If you have more concerns about QuickBooks reports, please don't hesitate to post them here. We always want to hear from you. Take care and have a good one.

User23511
Level 1

P&L Report split by account and then vendor

Hi, I would also like to see this report available! This was a great by YehudaKalshi: 

 

For Example:

Expense Account 1 - $10,000

   Vendor 1- $200

   Vendor 2- $1,000

   Vendor 3- $8,800

Expense Account 2- $300

   Vendor 4- $100

   Vendor 2- $100

   Vendor 5- $100

Total Expense- $10,300

 

I'd also like to add, for the monthly cost of which I haven't seen an update that helps me, and constant "pay to play" additional costs QB continues to promote, I'd like to see some progress elsewhere. 

Rasa-LilaM
QuickBooks Team

P&L Report split by account and then vendor

Thank you for visiting the Community, @User23511, and @Yehuda.

 

We are committed to delivering a product that our clients can consistently rely on for their business. Adding a line for the expense account with the breakdown of your vendor and the monthly cost in the Profit and Loss report will benefit a lot of users. I suggest submitting feedback about this feature straight to our product engineers for inclusion in future developments.

 

Here's how:

 

  1. Head to the Gear icon and choose Feedback under Profile.
  2. Share your comments or product suggestions.
  3. Click Next to submit.

 

To stay updated on the most recent product updates and improvements implemented by our engineers, we invite you to explore the QuickBooks Blog. If you require further information on how to save your current customization settings in your report and filter the financial statement to display the bank account, you can refer to the following resources for step-by-step instructions:

 

 

If you have any concerns or questions on how to build the Profit and Loss report that will show the data you need, drop the comment below and tag my name. I'll get back and help you the best that I can. Have a great rest of the day, @User23511, and @Yehuda.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us