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.

Reply to message

View discussion in a popup

Replying to:
BigRedConsulting
Community Champion

Reply to message

@tomlhall 

Generally, a GL is supposed to show all accounts and the account activity, even if there isn't any activity, which is a confirmation of that case.

 

If by "inactive" you mean hidden/inactive on the chart of accounts (as compared to not used in the reporting period), then there's a rather quick way to create the report without the unwanted accounts. Even if they are active/not hidden, you can exclude both the activity and the account node.

 

1 - Run the report.

2 - Click Customize.

3 - On the Display tab, click the Advanced button and then pick In Use.

4 - Then the Filters tab, then the Account filter.  Click Multiple Accounts... to open the Select Account window, which will list only the accounts that are active (not hidden) on the chart of accounts.

5 - Click the Select All button. This selects all the accounts that aren't hidden/inactive on the chart of accounts and is what makes this fast, since it's just a button click.

------------------------------------------

Note at this point that - if desired - you can de-select active accounts and then even if they are in use during the reporting period they will still be excluded from the report. In this way you can create a GL for only select accounts, or one account, but at that point it's not really a GL report anymore (sort of like a balance sheet that doesn't balance because it's filtered.)

------------------------------------------

6 - Run the report.

 

The combination of the two settings will exclude the unwanted nodes, whether or not there is activity for the accounts that have been excluded from the report.

 

 

View solution in original post

Need to get in touch?

Contact us