Only Change Account Balance on That Date Forward

I have a calendar budget app. What I want is to be able to add a deposit or withdrawal, but only update the balance in the account on that day forward (the balance on the days before should not change). Ideas?

Where is that $5239.94 being stored in your database? Sounds like you need a Current Balance field so you can display a different one each day