cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Trial Balance Report and non activity accounts

I do not want my my trial balance report to include accounts that have not have acitivity on them for years (some since 2013). I have made them all 'inactive'.  However, my trail balance report still lists them at 0.  In the 'advanced' feature I have selected Active which seems to me should solve it but they still appear.

Other answers to this problem I have found say to pick Active and then only accounts with activity during the reporting period will show but it simply doesn't work.  Does anyone know if this is a gltich?!

3 Comments
Established Community Backer ***

Let's understand that the word Active in QB = Active or n...

Let's understand that the word Active in QB =

Active or not is a Status on the List. So, Make Inactive has nothing to do with Reporting. It is a Status of: "Please stop showing this to me in Lists and on Dropdowns, as I no longer need to be able to see it for Selection."

Active for Financial report status = Has Entries or activity in it. And an ending Balance of 0 is not the same as Never Used. it means, Has activity that Math = 0 here.

In Advanced, you seem to want Non-Zero for Rows and/or Columns.

Not applicable

Thanks for the quick reply!  I know understand the differ...

Thanks for the quick reply!  I know understand the difference between Active and Non Active (too bad QB chose the same word for the advanced function in Reporting- that is confusing).  However, non zero is not what I want as it clears out all non zero accounts and I want the ones with activity in the reporting period to show as 0.00.  It seems that the ACTIVE button should be the one - I want accounts with no activity in the reporting period and a zero balance to NOT show- but they still do!
Established Community Backer ***

"However, non zero is not what I want as it clears out al...

"However, non zero is not what I want as it clears out all non zero accounts and I want the ones with activity in the reporting period to show as 0.00."

This will be a problem if you are asking about Balance Sheet accounts.

Example: We used to pay rent expense, and stopped years ago = No Longer Active (has no activity).

But, the Vehicle Loan is paid off = 0, even if it has no activity, that Zero is Meaningful.