Creating a budget variance column against current month actual and budgeted projections, same year

[seattleoutdoors]

I am trying to come up with a formula to show me in real time where my actuals are against my budget. The problem I am having is, I will be entering actuals as they come in, so I do not have data sets to simply run the percentage off of.

I have my yearly budget by month, and a column for the actuals that will be entered month by month. What I want to see, if the percent of variance based on the actuals plus the projections against the budget. Thoughts?