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?!
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.
"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.