Skip to main content
J
jmkentel
March 12, 2019
Question

Trial Balance Report and non activity accounts

  • March 12, 2019
  • 2 replies
  • 0 views

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

2 replies

qbteachmt
qbteachmt
March 12, 2019

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.

J
jmkentelAuthor
March 12, 2019
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!
qbteachmt
qbteachmt
March 12, 2019

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


J
Jonathan_20
January 10, 2020

I know this is an old thread, but I don't see that you got your answer.  To resolve this issue, follow these steps...

 

Open the Trial Balance report
Select Customize Report
On the Display tab, select the Advanced... button
Under the DISPLAY ROWS column, select Non-zero

If you wish to save these settings for future use, save the report as a Memorized report

    J
    Jonathan_20
    January 10, 2020

    I just re-read your last response and realized that my suggestion will not resolve your issue.  Sorry for any confusion, but I hope this helps others that just want to hide accounts with a zero value.  If someone finds an answer to your specific issue, please share with the rest of us.

    Terms & ConditionsAccessibility statement