@xlengthy, thank you! This is spot on. I would make same recommendation too except I wouldn’t worry about making a back up - Google Sheets has a version history so easy to revert if it did mess anything up. The keys are
- Insert the row for the updated balance above row 2 (right click row number to insert a row)
- Copy the data over exactly - Account ID is very important in sheets after 8/26/19, not so important in sheets created before 8/26/19, which rely on Index number instead so you may need to make sure the index number is consistent between the last automated entry and your last manual entry to reflect $0.
- Some columns may be hidden in the Balance History sheet. The Balance History sheet is hidden by default in most templates. Click the four horizontal lines in the lower left to view/unhide.
If the error for the account that’s closed is bothersome you can remove it from the Account Summary on the Tiller Console by clicking the gear icon and then choosing “remove account” - it will remove the data associated so if you ever think you’d want to be able to pull in the historical data into a new/different sheet in the future, I don’t recommend removing it.