Sounds like you want a checkbook register.

Something like this?
A B C D E
Start Bal $1,023.32
Date Item Expense Deposit Balance
$10.12 $1,013.20
$23.32 $989.88
$9.95 $100.00 $1,079.93

The formula in column E:
=IF(C4+D4=0,"",$E$2-SUM($C$4:C4)+SUM($D$4:D4))

The formula starts with the Starting Balance and subtracts the sum of all of
the Expenses, then adds the sum of all of the Deposits.
Ths Sum function uses a combination of Abolute and Referential referencing
to allow the Sum range to grow as you copy it down the page.
The If statement checks to see if Both column C and column D are zero, if
they are it prints a blank in the cell, if either one has a value greater
than zero then it calculates the sum.

Mike