Balance Sheet Report - zero accounts showing that are not "zero"...IIF issues?

I'd be glad to help you run the Balance sheet report excluding the accounts with 0 balance, @GRMVT.

You may need to filter the report to just include the active accounts and exclude the inactive accounts. Let me show you how.

1. Go to the Reports menu.
2. Select Company and Financial and then choose Balance Sheet Detail.
3. Click the Customize Report button at the upper right of the page.
4. Go to the Filters.
5. Look for Account under Choose Filter.
6. Under Account choose Multiple accounts.
7. Select the active accounts.
8. Click OK to refresh the page.
   
   

For more information on how to personalize your report, feel free to check out this article: Customize reports in QuickBooks Desktop.

You'll want to save your current customization. You can use the memorized report feature in QuickBooks Desktop.

Feel free to add a comment below if you have any other concerns, we're always here to help. Have a blessed day.

Thanks for quick response!

I see your approach here but the problem with this solution is that the person running the report will have to know to update the Balance Sheet account "Multiple Account" list each time a new account is added. If this is not understood by that staff accountant, the report will be incorrect as the new account is not part of the inclusion filter. This could result in a major misstatement. If this was an exclusion filter and those pesky accounts were on that list I would agree that was a valid solution. Or perhaps if QB allowed a popup message during the run of the report that provided a warning reminder.

I'm curious as to what would cause these accounts to show a "zero" balance, yet not be excluded when that zero filter is applied? I still believe this is something to do with the IIF imports we do and QB holding less than .01 values in the data tables. This is especially true since one account shows -0.00, which would lead one to believe it is holding a tiny negative value.

Greg in VT.

Thanks for your prompt reply.

I would accept this as valid solution if the danger of a staff accountant not adding a new Balance Sheet account to the filter list would be quite high, resulting in a potential material misstatement of our position. If this were an exclusion rather than inclusion filter and those pesky 5 accounts could be added to that list, I would agree your approach was a great one.

Or, if QB allowed for a popup box during the run of a custom report reminding the user to update the list, that would be acceptable.

I'm still curious about why these accounts are showing up with the zero filter in place? I still suspect that the IIF imports we do have left a less than .01 value in these accounts (net) and therefore they are still shown. I think the indication of this is the one account that shows a negative zero amount as in -0.00.

Greg in VT

...my apologies for the redundant reply, I'm still not used to this board!

G