Declining balance

[btr]

Can someone give me the "easiest" instructions to keep a running balance
using formulas?

Ex: Balance 125,000
Less 1,394.50
Balance
Less 2,356.89

I thought I did the following but I can't get the formula to automatically
deduct the expenditures and give a balance each and every time. This is what
I have been doing.

fx, click on sum
=Sum (K3-J3)
Copy & paste

Help me learn how to do this painlessly and quickly. Thanks

 

[Dave]

Hi,
If this sheet only records expenditures, then with your initial balance in
A2, and all expenditures starting in A3 and going down the column:
In B2, enter: A2-SUM(A3:A10000)
B2 will now always display the running balance.
Change the refs to suit your data.
Hope this helps.
Regards - Dave.

 

[btr]

I have put my beginning cell of K3 and the expenditures beginning in J5--what
now?

$85,848.82 K3

J5 $1,222.19 $84,626.63
J6 $916.00 $84,626.63
J7 $1,048.80 $84,626.63
$377.00 $84,626.63
$62.70 $84,626.63
$400.85 $84,626.63
$180.00 $84,626.63
$479.07 $84,626.63
$177.84 $84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63

 

[Dave]

Ok, in K5 enter:
=IF(J5="","",$K$3-SUM($J$5:$J5))
Then fill down way past the bottom of your data in Column J
Let me know.
Dave.

 

[btr]

this did not work. I typed in exactly what you have below (do I need to
insert the actual dollar amount where you have the $ sign?)

 

[btr]

I did this and got $84,626.63 and filled this amount all the way down to at
least J27 but when I put in my next expenditure it does not change the
balance. Any other suggestions other than using a calculator?

 

[Dave]

Hi,
It really does work. I've tested it.
Yes, you need all the $ signs.
It's better if you highlight the formula straight off this page, then copy,
then double click in cell K5, then paste, then enter, then copy down.

=IF(J5="","",$K$3-SUM($J$5:$J5))

But just one question: are the balances you have already, as shown in your
data, in Column K? If so, save the workbook, delete them, then proceed as
above.

Regards - Dave.