So, my Vanguard data isn’t updating and I see it is in the institution alerts. My question is:
Can I grab the current balances and create a new entry in the Balance History worksheet, just to keep things updated? I’m not crazy about the idea of converting them to a manual account.
I wouldn’t edit the balance history lines unless you’re familiar with it because once the system is back it’ll try to catch up. What are the end numbers you need updated currently? ie If you want all the transactions updated i would use the CSV upload, but mark them for when the system imports duplicate entries.
But if you need the history balance to be correct for reports you’re running, you’re right as that might be the only place to update, just mark the manual lines you’ve added and when the automated system is back up; check to see if there’s any duplicates and run the repair balance history from the tiller community module.
If you’re just caring about the balances for the account (not the transactions @kingsdotter ) adding a balance history entry is totally fine. Just be sure to add it below row 1 and mimic the data in the other rows. I usually will just copy a previous entry and update the date and the balance. The main thing is just making sure that you use the same account ID as all the other entries for the account, which will happen if you just copy/paste/update a row.
Duplicates in the balance history sheet aren’t a big deal.
Yeah, I was thinking dups were no issue. I made the transaction number be something I could find later and delete if I needed to. I just copied a previous line for the account and changed the date and amount.
For anyone else with a similar query just to note we also have a help article on this here.
