help creating a better household spend tracker

For the last 4 years i have used an excel budget (pretty basic) to input my predicted spend each month and also the actual spend. The only problem is i have to amend the predicted to match the actual at the end of each week/month to ensure the following week/months predicted balances are correct. So i never have any information about how far out my budget predictions are from the actual spend. To combat this my partner added a variance column but i think there should be a better way and probably a more efficient layout to allow me to see the predicted balance several months from now that changes each moth as i updatethe actual spend but also gives me the difference in a figure that doesn't change.

The attached sample is just 1 month long (as taking out all of the personal info for a full year is a pain).

Any design tips or otherwise would be greatly appreciated.

This is a bit of an open-ended request. You would be far better off mocking up the sort of layout you envisage being better and then taking it from there.

Yeah I give that a try I'm just not sure if I should be using excel and can track variance in a way that stores the variance but still adjust the future predicted to reflect the past actual (without wiping out the past variance too) or if I should be looking at a different method like a database?

No, Excel will be fine. I have no idea what you mean about wiping out past variances. As there is NO SAMPLE DATA in your original attachment, we are having to guess what you are after.

Thanks for letting us know.