@randy - This sheet is fantastic! Last piece that was missing in my day to day tracking for the excel environment. One thing I noticed when importing my google sheets data is that the balances were just a bit off. I think I got it by adjusting the Filter function in columns AF:AQ where balance history date < EOMONTH. I was showing the balances from a day or two before the end of the month, rather than the true EOM date, so I made the comparison ‘<=’, which looks to have resolved it for me.
I could be wrong, I’ve only been working in the sheet for about 30 minutes!