Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
houstonwb-elswor
Level 2

How do you change the Statement of Activity to consolidate some accounts but show others?

Most of our expenses are salaries. We have several other accounts that we wish to consolidate. We would like the Statement to have two expense lines--salaries and everything else. How?

1 Comment 1
Bryan_M
QuickBooks Team

How do you change the Statement of Activity to consolidate some accounts but show others?

The Statement of Activity shows the financial standing of your company for a specific period, and having control over how it would display is essential to have a complete overview of its liquidity, @houstonwb-elswor. I'll be sharing information on what you can do to consolidate some of the entries in this report.

 

When generating the Statement of Activity report, we can only customize the columns and accounts that will show. Consolidating it into two expense lines, which are salaries, and everything else is not possible. 

 

Please know that in QuickBooks Online (QBO), a financial report, such as the Statement of Activity, shows the specific accounts where your expense transactions are placed.

 

Since you wish to consolidate this into two expense lines, I recommend exporting the report to Excel and modifying the display outside QuickBooks to show the salaries and other expense section only. 

 

You can locate this option in your Statement of Activity report by going to the upper right corner, clicking the Export icon, and selecting the Export to Excel option.

 

 

A financial report is an important part of a business in forecasting plans based on the statement shown. If you have additional questions about consolidating the Statement of Activity, feel free to return here by leaving a comment below.

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

Need to get in touch?

Contact us