This does not work. I've read multiple forum threads where people representing Quickbooks state that this is the solution. It's not. I've tried this multiple times and it will not show accounts that have no transactions during the FY. I've tested it multiple times. I've also cleared the desktop app cache and reset it on the recommendation of another post. I've tried multiple strategies to manipulate the accounts in excel the way I need them, and it takes far too much time, for something that we are supposedly able to run with a few clicks. This is incredibly frustrating.

If you look at the description of Active just above the pull down box, it even implies that the accounts aren't going to show - "Choose Active to hide empty rows or columns. Choose Non-zero to also hide ones where the total is zero." What's the difference between empty rows and those that total zero? The only way I have been able to get active accounts that total zero to show is by selecting "All", which then pulls up dozens of deleted accounts.

Please, we need an actual solution to this.