Is there a way to mark accounts as closed or inactive so that they do not show up in places like net worth reports? I want to keep the history. I saw a post for Google Sheets back in 2020, but there was no graceful solution. If you searched, without success, feel free to clear this content away a…

Here’s one way to do it: [image] Easy Solution for removing a Closed account from the Balances sheet but not losing Historical data Show & Tell I checked the community a bit but couldn’t get a general sense what the best practice was for the following: I have some newly C…

Thank you, let me study this solution.

I may be oversimplifying (or missing something?), but what I’ve done so far is to simply mark the account to zero (either by transfers if applicable or entering a manual balance entry), and then… on the Accounts tab… changing the Group to “Closed” and Hide to “Hide”. I’ve grouped the “closed accoun…

If you hide a closed account it will also hide it from Net Worth and other historical sheets, so you will have an inaccurate net worth data set due to that data being hidden. Also, if the account is closed and you just hide it, you’ll get errors in the Google extension that it can’t connect to that …

By “closed”, I mean the account no longer has value (zero) so it wouldn’t be included in the current “Net Worth” view or related summaries. The accounts I’ve closed so far weren’t “connected”, but if they were then I’d disconnect them. I haven’t seen any negative consequences in summaries, or my o…

That works fine @Robert if you really just want today’s Net Worth. These changes are for maintaining historical Net Worth, so time periods when a currently closed account was open and non-zero. Marking them Hide removes them for all time periods in the Net Worth sheet.

Thanks for the clarification! I don’t use any templates from the community but have brewed a few of my own. I imported more than 30 years of data from MS-Money and replicated some data views I didn’t want to lose… including “net worth vs time”. I’ve mostly just created what I need so don’t fully …

:wave:, @buzzmaster1 Did any of these suggestions help? If so, please mark one as the solution. [mark-solution]

I have not had an opportunity to work on it. KH

Inactive/Closed Accounts in Spreadsheet

Spreadsheets Microsoft Excel

Mark.S August 24, 2024, 4:13pm 4

Note that I have also just updated that thread with a change for the Net Worth sheet

Topic		Replies	Views
Remove a Closed account from Balances sheet without losing historical data gSheets Templates google-sheets , how-to , showtell-votes	18	1325	February 24, 2026
Closed Account: Retain History But Keep from Showing Up Going Forward Google Sheets how-to , tracking	21	3453	January 9, 2026
How can I delete a closed and unlinked account from the balances sheet? Google Sheets	11	1265	June 29, 2020
Advice for modifying Accounts sheet to better handle closed accounts? Google Sheets	3	295	January 26, 2024
Closed account(s) showing up as "Active" in the tillerhq console. No way to tell the console that they are no longer active Ask Anything	3	291	January 11, 2024

Inactive/Closed Accounts in Spreadsheet

Related topics