In my foundation template, I have 5 very simple manual accounts (a car, a house, a promissory note, and a nonfeed health savings account) with a very few transactions. Here they are:
My Account sheet persists in flagging ONE of these accounts with a red caret symbol (“Invalid Input must fall within specified range”). The dropdown list of accounts does NOT include that account - despite the Balance History sheet plainly containing its entry (entries). And of course that account then does not register in the Balances sheets or any reports. Presently, this is my car.
I am fairly certain this may reflect something the Tiller Money Labs Account Repair Balance History Tool created in some part of the template. Oddly, in using the Tiller Feeds Manual Accounts Tool, ALL 5 accounts are shown (but, again, in the Account sheet, the dropdown list does not, as this tool does, include the careted car account).
(One other possible issue is that I did not have a column called Month when the manual accounts were first entered; I added that because of your video on making a pivot table.)
I have tried to use that Tiller Feeds Manual Accounts tool to delete accounts and recreate them. When I do, I may restore the targeted account (yep, the red caret and invalid data error goes away), but ANOTHER one of the manual accounts gets the error and disappears from the Balances and reports. (For example, instead of the car account, the home account may get the caret, error and not appear on reports.) Its like a “Whack A Mole” issue!
Finally, if it helps, this is a list of the Tiller Money Labs Repair History Tool noting Account ID Mismatch(es):
There are so few manual entries, I would think there would be a way to fix pretty quickly by deleting and reentering or … But when I have tried in the past, the template becomes unstable and all accounts unlink.
Thank you for any help!