Disable hidden accounts in net worth tracker

[Mark.S]

Also consider the following customization to add a Closed account option, so that historical Net Worth is maintained - visible before account is closed, hidden afterward.

Remove a Closed account from Balances sheet without losing historical data

Here is an extension of this solution for the Net Worth sheet. People often want to Hide accounts from the Net Worth report for time periods after the account was closed, but still want them visible for when the account was open. This uses the Accounts sheet Last Update date for the Closed date. The Last Update date can be changed by changing the Balance History for the closed account. Change Net Worth sheet cell AC7 to add the following to the QUERY’s WHERE clause: AND ("&AX23&" <> 'Closed…