Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
NCNM
Level 1

Report showing monthly expenses by gl accounts and vendors

Trying to create a custom report that looks similar to the attached example.  Suggestions are appreciated.

 

Thanks

2 Comments 2
ShangY
QuickBooks Team

Report showing monthly expenses by gl accounts and vendors

I understand you're trying to create a custom report to show monthly expenses by GL accounts and vendors similar to the example you've attached, @NCNM. I suggest generating a Transaction List by Vendor report as the closest option to the Online report you are looking for. This report can help you view your monthly expenses broken down by accounts and vendors.

 

Here's how:

 

  1. Go to Reports.
  2. Enter Transaction List by Vendor in the Search bar.
  3. Click Filter.
  4. Select Account in the first drop-down, then Equals in the second drop-down, and choose your GL accounts in the third drop-down.
  5. Group Date by month



     

Moreover, you can export the report to Excel, allowing you to organize the data in the same format as the example you provided.

 


 

In addition to this, you can explore this resource: Use reports to track cash flow in QuickBooks Online. This article provides insights on how to effectively utilize QuickBooks Online reports for monitoring your cash flow and managing your finances.

 

I'm excited to share our popular product, QuickBooks Live! If you need expert help with managing your finances, especially during tax season, this is perfect for you. To learn more about its benefits, you can easily schedule a free consultation whenever it works for you.

 

I appreciate the opportunity to help you. Please let me know if you have further questions or concerns about the suggestions I provided or anything inside QuickBooks. I'm always happy to help. Have a good one.

NCNM
Level 1

Report showing monthly expenses by gl accounts and vendors

Thanks

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us