Checkbook type of spreadsheet with formulas

[SilverBullet3G]

Please forgive my ignorance here, but I am not very good with formulas in excel. What I would like to do is create a running spreadsheet that is like a checkbook. I'd like to create the spreadsheet with my monthly bills due along with my deposits, each line with a current balance. I'd like to do this not just for one month, but from now going forward into the future. The reason for this is that I live paycheck to paycheck and would like to see what my balance would be in the future, or if I will be short of funds on a certain day. But, not knowing what my paycheck will be each week (it varies), or any extra expenses that I will need to insert on any given day, I am not sure the best or easiest way to do the formulas since I will be adding and maybe deleting cells at times.

Is it possible so that the formulas stay in tact and adjust themselves if I add or delete a cell?

I currently have my first months bills entered with the formulas that I manually entered for each cell/row but as I add more data, I'd like to avoid having to do the formula for that new cell each time accordingly. Is this possible?

Here is a basic idea of what I have so far:

C1: 1000.00 (balance)
C2: 407.09 (amt of bill due)
D2: 592.91 (new balance) w/formula =SUM(C1-C2)
C3: 232.38 (amt of bill due)
D3: 360.53 (new balance) w/formula =SUM(D2-C3)
C4: 324.00 (amt of bill due)
D4: 36.53 (new balance) w/formula =SUM(D3-C4)
C5: 501.00 (deposit/paycheck)
D5: 537.53 (new balance) w/formula =SUM(D4+C5) (but I think this is wrong)

You can see what I'd like to do. But I'd like to enter about 3-4 or more months worth of my monthly bills ahead of time and then I will insert entries (either deposits or expenses such as gas, groceries, etc) as I have them.

I apologize if this is confusing or stupid, but I trust people here know alot about Excel and formulas so I thought I would try and ask for some help.

Thank you everyone!

[ncmay]

Try the attached file.
Macros will have to be enabled.