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