First u get the last month amount and keep it in one variable,
Select Sum(amount) from tablename where paidDate >= '01/11/2010' and paidDate <= '30/11/2010'
then,
insert into tablename(remain_amount) values(last_amount - 1000)
1000 is the currenty entered amount.