Excel work

Closed - This job posting has been filled and work has been completed.
Web & Mobile Development Scripts & Utilities Posted 3 years ago


Hours to be determined
Less than 1 week

Start Date

November 19, 2012


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:
a)Resource name
b)Resource Daily Rate
c)VAT required
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.

About the Client

(5.00) 1 review

Munich 02:53 AM

20 Jobs Posted
15% Hire Rate, 3 Open Jobs

$138 Total Spent
3 Hires, 0 Active

Member Since Nov 19, 2012