Help me on Calculation problem of Journal Ledger

Guys,,
I need your help in the attach excel file.
I want you to write funciton or macros whatever appropriate in the "Balance Column" and
Sum, minus my credits, debits and Balance for me automatically in "Balance column", whenever I enter data in cells. But I want to Get Balance for each row seperately.. And also when I put data every day in it, then it should not update the previous day calculations.
Thanks in Advance, Sorry for my bad English.