Forum Discussion

RobNob's avatar
RobNob
Experienced Cover User
7 years ago
Solved

BS report shows bank accounts with $0

How do you get rid of old bank accounts appearing in the BS reports, which have been zeroed - they show $0 but I don't want them to appear at all.

  • Hi RobNob

     

    Thanks for the extra detail, yes these reports do have differing options in this case.

     

    With the Category Balance Sheet, this won't show any accounts that a transaction wasn't recorded against with that Category which means the accounts should only show if they have had activity with that Category.

     

    If there has been any transactions reversed to those accounts to create a $0 effect on the report, they will continue to display and there's no automatic way to hide those on the Category Balance Sheet reports. A workaround for this would be to export this to Excel and manually remove the $0 values.

3 Replies

Replies have been turned off for this discussion
  • Haydes's avatar
    Haydes
    MYOB Product Team
    7 years ago

    Hi RobNob

     

    From the sounds of it, sounds like there's a checkbox ticked to show $0 balances:

     

    By default this is not selected. If you display the report now, could you check this?

     

    If you're running AccountRight V19, try customising the report and going to the Finishing tab and see if Include $0.00 balances is ticked:

     

     

    Let us know what you find.

  • RobNob's avatar
    RobNob
    Experienced Cover User
    7 years ago

    Thank Hayden, but it seems that option is not available on the version of MYOB I'm using, which is AR Plus 2018.

    I see it is an option in the normal BS report, but we use Categories and no such option is available in any of the category reports.

     

  • Haydes's avatar
    Haydes
    MYOB Product Team
    7 years ago

    Hi RobNob

     

    Thanks for the extra detail, yes these reports do have differing options in this case.

     

    With the Category Balance Sheet, this won't show any accounts that a transaction wasn't recorded against with that Category which means the accounts should only show if they have had activity with that Category.

     

    If there has been any transactions reversed to those accounts to create a $0 effect on the report, they will continue to display and there's no automatic way to hide those on the Category Balance Sheet reports. A workaround for this would be to export this to Excel and manually remove the $0 values.