I’ve consolidated several accounts, and my retirement account has moved between custodians. As a result I’ve got a few closed accounts that are cluttering up reports.
I understand that the purpose of the Hide override is to hide these accounts from balanced based reports, but this isn’t precisely what I want in some cases.
For example, as implemented, if I Hide an account, it will disappear completely from the net work report. This means that if I had $X in old retirement account, and I hide it because that was moved to new retirement account, instead of a smooth graph it will be dropped from history, and there will be a spike on account transition date.
In my balances sheet, I did make an entry on the date of the transfer setting the balance of the old account to $0, and setting the status to CLOSED.
Modifying the Accounts sheet is a bit of a bear because of the hard-coded columns, but I added a column in the left hand section called Date Closed, and intend to update Net Worth so that the table at the bottom of the sheet doesn’t list an account if it was closed for the entire report period. (Effectively, this new column acts as a “hide after this date” column.)
My question is, is it possible to derive this information from the balance sheet by copying the Status column for the last entry into the Accounts sheet? How do I do this?
Absent a good solution for that, my manual solution is acceptable, but having denormalized data for derived values is always a source of potential inconsistencies.