how do i set up an income and expenditure account in excel?
 

i am recording the receipt of funds and the deduction of expenses from
project accounts for my office. The reason for my question is this; i want to
set the formula so that the expenses column is automatically subtracted from
the balance. another function i would like it do is 'balance off' or 'close
the balances' at the end of each month.

best regards,

LSB