Filtering General Ledger Report

Forum|Forum|5 years ago
February 10, 2021
2 replies
129 views

When filtering only specific GL accounts (COGS, expense & other expense) for general ledger the report includes all of the accounts with no activity for the time period. How do I filter report to only show GL accounts with activity?

Previous "accountant" created a 100s of unnecessary GL accounts which I have made inactive but when looking at prior periods my csv. export of the GL for 2018 is 4,818 rows long lol. Thanks in advance!

QuickBooks Desktop

Best answer by Ryan_M

Hi @boss429,

Welcome to the Community. I'll walk you through the steps on how you can filter a General Ledger report in QuickBooks Desktop (QBDT).

Here's how:

Click the Reports menu.
Highlight Accountant & Taxes.
Select General Ledger.
Press Customize Report.
Under the Display tab, hit the Advanced button.
Tick In Use under the Include section.
Hit OK, then OK.

Your General Ledger report will now show only active transactions. For additional details, I recommend you view these articles:

Let me know if you have other questions with custom reports in QBDT. I'll answer them for you.

Ryan_M

Answer

Moderator

Hi @boss429,

Welcome to the Community. I'll walk you through the steps on how you can filter a General Ledger report in QuickBooks Desktop (QBDT).

Here's how:

Click the Reports menu.
Highlight Accountant & Taxes.
Select General Ledger.
Press Customize Report.
Under the Display tab, hit the Advanced button.
Tick In Use under the Include section.
Hit OK, then OK.

Your General Ledger report will now show only active transactions. For additional details, I recommend you view these articles:

Let me know if you have other questions with custom reports in QBDT. I'll answer them for you.

boss429Author

Thank you!!!

Sign up

Login with SSO

Let's get you signed in

Login with SSO