My small requirement is below:
I have a small firm where around 5-8 resources work on monthly daily rate basis.
Need an excel master sheet which is having below requirement:
1.As a user I can register new resources with following details:
b)Resource Daily Rate
d)Duration of contract
e)Daily rate customer
On Monthly sheet say January if I enter No of days next to Resource column then it should calculate amount paid to resource & my profit and additionally it should have place holder to enter invoice no,Invoice received date & Payment date, If VAT required is Yes then VAT should be calculated based on below formula
(daily rate* no of days)*19%
If profit then it should be Green else RED should be that column.
If a month has more then 1 resource work then it should club all profit & loss and show a summary.