# Remove Accounts from Balance sheet (or choose which Accounts it displays)- without Hiding Accounts! **URL:** \ **Category:** gSheets Templates\ **Tags:** google-sheets, balances\ **Created:** [August 7, 2025, 6:23pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143 "2025-08-07T18:23:45Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Cowboy13](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cowboy13/32/7668_2.png) [@Cowboy13](https://community.tiller.com/u/Cowboy13)\ **Post date:** [August 7, 2025, 6:23pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/1 "2025-08-07T18:23:45Z")
# Overview I searched the forums to see if there was a easy solution to choose which accounts show on the Balances sheet. I have many accounts that have been closed for a while but they still show up on the Balance sheet. I know I could Hide the Account, but that affects other sheets. All I want is to to be able to choose which accounts I show on the Balances sheet without affecting any other sheets. I found 2 posts ([Remove a Closed account from Balances sheet without losing historical data](https://community.tiller.com/t/remove-a-closed-account-from-balances-sheet-without-losing-historical-data/26060/4) and [How to remove certain accounts from the “Balances” tab?](https://community.tiller.com/t/how-to-remove-certain-accounts-from-the-balances-tab/397)), but it either looked complicated or had side effects. So, I updated the Balance sheet so I could choose which accounts are displayed. For example, my Automotive account group went from this… ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/b/e/be07800810d5504754e6bac56975a1ab80300126.png) to this… ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/8/6/868b6c4178bd4abd33dbdcfe389f1765025dad57.png) # Installation and Setup Simply copy the sheet into your workbook. Link is [here](https://docs.google.com/spreadsheets/d/1BMOWhT-ohy4I5s2M3EeCFFdVJG4EL8LxgkiL2otlUBQ/edit?usp=sharing). It behaves **identical to the current Balances sheet** , but you now have the option to deselect accounts you don’t want to show Balances for. You do this in column AA… ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/9/f/9f1d80da1ef95e02c67bf2b63ccb2a16caa635d8.png) By default, the sheet has all accounts checked to show, so if you don’t do anything after you copy into your workbook, all accounts will displayed just like the current Balances sheet. # Usage Nothing else is needed. # Permissions It is OK for others to copy, use, and modify this sheet. # Notes This doesn’t affect any other Tiller sheets. It would be great if the Tiller foundational Balances sheet was updated to include this capability. I can’t think of any downsides to doing this. Enjoy and let me know if you have any questions. ---
**Author:** ![Cowboy13](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cowboy13/32/7668_2.png) [@Cowboy13](https://community.tiller.com/u/Cowboy13)\ **Post date:** [August 7, 2025, 10:50pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/2 "2025-08-07T22:50:34Z")
@randy or @heather - any chance to update the current Balance foundation sheet with this functionality? Could also add the ability to sort Accounts in a Group by Account name, balance or last updated. Thanks. ---
**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\ **Post date:** [August 8, 2025, 3:33pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/3 "2025-08-08T15:33:00Z")
Here’s another quite easy option that doesn’t add sheets or columns: > [@Dynamic hiding of accounts with zero balance](https://community.tiller.com/t/dynamic-hiding-of-accounts-with-zero-balance/32653/4): > > Here’s another option to consider, if you like the idea of using your Accounts sheet method - introduce a Hide Balance option and use that instead of Hide in your formula. Then for Google sheets Balances sheet, cells K3 and R3 change: indirect(Y18)\<\>"Hide" to: indirect(Y18)\<\>"Hide",indirect(Y18)\<\>"Hide Balance" This is similar to [this Closed account share](https://community.tiller.com/t/remove-a-closed-account-from-balances-sheet-without-losing-historical-data/26060). ---
**Author:** ![Cowboy13](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cowboy13/32/7668_2.png) [@Cowboy13](https://community.tiller.com/u/Cowboy13)\ **Post date:** [August 8, 2025, 4:16pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/4 "2025-08-08T16:16:55Z")
Yes, I saw that. It’s pretty straight forward but didn’t want to alter the Accounts sheet. So I did it with the “Show” column option to the right on the Balances sheet, not Accounts. I then modified the formula in K3 and R3 to choose the right ones. I stay away from changing the Foundation sheets (like Accounts) as I am concerned that if/when there are updates to these core Foundation sheets, I’ll have to add my customizations back in and I don’t want to keep track of this. Also, since all other sheets reference the Foundation sheets, I am paranoid about screwing some of those up (which it shouldn’t if they are coded correctly, but you never know). Maybe I’m too paranoid on this, but I have peace of mind! Thanks. ---
**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\ **Post date:** [August 8, 2025, 4:26pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/5 "2025-08-08T16:26:31Z")
> [@Cowboy13](#): > > I stay away from changing the Foundation sheets (like Accounts) as I am concerned that if/when there are updates to these core Foundation sheets, I’ll have to add my customizations back in and I don’t want to keep track of this. Noting that you did change the Balances sheet though, which is a Foundation sheet. Anyhow, there are some options here for the Tiller team to consider for an often requested feature 🙂 ---
**Author:** ![Cowboy13](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cowboy13/32/7668_2.png) [@Cowboy13](https://community.tiller.com/u/Cowboy13)\ **Post date:** [August 8, 2025, 4:55pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/6 "2025-08-08T16:55:55Z")
> [@Mark.S](#): > > Noting that you did change the Balances sheet though, which is a Foundation sheet. Yes, that’s true! However, I view the Accounts, Transactions, and Balance History sheets as sacred and don’t modify those at all (but have messed with the Category sheet quite a bit- sorting, adding multiple years, etc. ). Thanks! ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [August 12, 2025, 12:50pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/7 "2025-08-12T12:50:49Z")
@Cowboy13 thanks for the suggestion here. Not sure it’s something we’ll prioritize. I think given the Balances sheet and Accounts sheet are Tiller official templates it may be advised that this capability be built into _other_ templates where you want to override the global “hide” setting on Accounts. Your solution here gives folks an option for how to do this in the Balances sheet, but for a lot of people Balances is the only one they care about and therefore not a common denominator to need that template specifically having a special hidden override. ---
**Author:** ![wally.bryan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/wally.bryan/32/13785_2.png) [@wally.bryan](https://community.tiller.com/u/wally.bryan)\ **Post date:** [August 12, 2025, 11:04pm UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/8 "2025-08-12T23:04:16Z")
I just created a group called Z-History and put all of these accounts in that group. This way they all display together, and by calling it “z”, it sorts to the bottom. It’s not very elegant, but it’s simple - like me. 🤪 ---
**Author:** ![RachelB](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/rachelb/32/2175_2.png) [@RachelB](https://community.tiller.com/u/RachelB)\ **Post date:** [August 14, 2025, 10:38am UTC](https://community.tiller.com/t/remove-accounts-from-balance-sheet-or-choose-which-accounts-it-displays-without-hiding-accounts/33143/9 "2025-08-14T10:38:58Z")
There’s also a simple way to modify the Net Worth sheet to still show accounts hidden from Balances. You only modify the Net Worth sheet so it avoids touching the Foundations templates. > [@Disable hidden accounts in net worth tracker](https://community.tiller.com/t/disable-hidden-accounts-in-net-worth-tracker/7172/6): > > Thank you! Here’s what I did On the Accounts tab, inserted a column to the right of Hide (Column Q) and titled it Hide from Net Worth (Column R). Copied over Hide values for the accounts I wanted to Hide from Net Worth and left cells blank for ones I wanted to show in Net Worth. In the Net Worth tab, I renamed AW23 from Hide to Hide from Net Worth (to match Column R in the accounts spreadsheet). I also adjusted the code in AX23 so that it looks all the way to column R. This is simp…