Build advance excel sheet

I want an excel sheet where i add open banlance and deduct amount on different customer based the deduct amount will deduct from main balance then i will recive amount from that customer write in paid amount that amount will add in total openings balance with profit
All customer transaction will charge with different % that % amount will show in profit and it will add on main opening balance also show different customer remaining balance with profit.
The sheet is on daily bassis but all data show customer wise seprate with total transaction today and overall remaining balance like that and daily transaction on each customer 50 to 100 so sheet setting un change able with password protected
After work finsh the opening balance with profit amount show exact the amount cash in hand