@chris.meyers I don’t have a solution to your specific issue here, but I’m curious if you’ve tried the Savings Goal Tracker (beta) sheet? Savings Goal Tracker (Beta)
It’s a little different than this one, but it’s entirely based on account balances vs transactions so you’re always tracking toward the money that’s actually available in your account.