stock remaining..

  • Thread starter Thread starter salman.way
  • Start date Start date
S

salman.way

Suppose I have a expense head Internet and have Internet budget say 10000 for a year..
My sheet shoud work like

Sno. | Voucher No. | Head | Amount | Budget remaining
1 | V74 | Internet | 3000 | 7000

Means when every I put an expense "Budget remaining" column should show me the remaining budget.
 
Suppose I have a expense head Internet and have Internet budget say 10000 for a year..

My sheet shoud work like

Sno. | Voucher No. | Head | Amount | Budget remaining
1 | V74 | Internet | 3000 | 7000

Means when every I put an expense "Budget remaining" column should show
me the remaining budget.
Click to expand...

I'm assuming that the worksheet has only Internet expenses, with other categories elsewhere. If categories are intermixed, it's more complicated, but doable.

My suggestion is to put the yearly budget of 10000 in E2 under "Budget Remaining." The entry in B2 could say "Starting Balance" or something similar (it's not a voucher).

The first voucher would be in row 3.

To calculate the budget remaining in E3, put
=E2-D3
Copy this formula down as far as needed for new vouchers.

Hope this helps getting started.
 
Back
Top