Pull Missing Historical Balances?

Hi all,

I’m currently working on a workaround solution for credit card statement balances (which I’ll happily share once it’s working). However, my current iteration of the sheet hits a snag if there isn’t a balance on the Balance History sheet for the account a particular day. Is there a way to pull in these missing balances?

1 Like

@mgodwin to get additional/historical balances for accounts, you can manually add the balance by inserting a new row into the Balance History tab.

Thanks @warren. I was hoping there might be a way for any missing balances to be autofilled during sheet updates. Though now that I’m thinking through it a little more I can see where that might be tricky.