Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 2, 2020
Question

Working Trial Balance

  • December 2, 2020
  • 2 replies
  • 17 views

When working with the Accountant's version of QuickBooks Desktop, does anyone know how to run a working trial balance that excludes inactive balance sheet accounts?

I have marked the box to exclude accounts without activity, but that only removes the income and expense items, not the balance sheet items. 

The inactive balance sheet accounts can't be deleted since they have historical transactions in previous years.  

thanks!

 

2 replies

IamjuViel
Level 8
December 2, 2020

Hello there, @KristiP1.

 

You can customize your Trial Balance report so it will only show the active accounts. I can guide you on how to do it.

  1. Go to the Reports menu.
  2. Scroll down to the Accountant & Taxes section.
  3. Select Trial Balance.
  4. Click the Customize Report button.
  5. From the Filters tab, locate the Accounts section.
  6. Choose Multiple Accounts from the Account drop-down.
  7. Mark the accounts you want to include in the report. 
  8. Click the Ok button.

Once completed, you can save the customization you've created for future use. You can read through this article for more detailed steps: Create, access, and modify memorized reports

 

Lastly, I've added these articles to help you manage your balance sheet and chart of accounts:

Drop by here again if you have other questions about generating financial reports in QuickBooks. I'm always here to help.

IamjuViel
Level 8
December 3, 2020

I want to make sure you can easily generate your financial reports, @KristiP1.,

 

Have you tried performing the solution I shared on how to customize your Trial Balance report? 


If you have additional questions or concerns, leave a comment below. I’m more than happy to lend a helping hand. Enjoy the rest of the day.

KristiP1Author
December 8, 2020

Thanks for your input, but I was aware on how to customize the report.

I am referring to the Working Trial Balance that is accessed through the Accountant menu in QuickBooks Accountant Desktop.  When you are in that screen you are unable to exclude the Balance Sheet accounts that do not have any balances.  You do get an option to exclude the income and expense items that do not have activity.

October 18, 2023

I have not found a way to do this with the Working Trial Balance, but this is close:

If you go to the report section, under Accountant & Tax and Select "Adjusted Trial Balance" you can then customize this report as follows:

Under filters, select "Multiple Accounts", then in the pop-up window you will see a list of accounts, however this list will Only Be Active Accounts", so if you check All Accounts, it will only be All Active Accounts.  Any account that has prior year activity, but not in the current year, I mark inactive.  Running the account as described above will print a Trial Balance with only active accounts.