"bug28" wrote in message
...
i have a budget setup in a spreadsheet and i cant figured how to keep a
balance updated on a loan without typing in the new balance everytime

It's not clear what you are trying to do. Is it something along these lines?

Put the initial loan amount in B1.
Put each repayment in column A, starting at A2.
Put this formula
=B1-A2
or this one
=IF(A2<"",B1-A2,"")
in B2 and drag down column B as far as needed.