Closed

Design Excel Staff Roster to work with MYOB payroll

We use MYOB for payroll. We use an excel spreadsheet for the weekly roster. We would like the weekly roster to automatically calculate the total hours worked by each staff member instead of doing it manually. There are different rates for different times of the days, so as well as an overall total hours worked, the excel spreadsheet must also calculate totals for each different time period.

There are several different classes of employees. Each different class of employee has its own rate/times. Most employees hours change every week.

An excel spreadsheet has previously been created to do this but it is too complicated. We just need the totals, not all the workings. This file is attached. It has two sections. The section Staff Roster works well but it is the computation section that needs to be refined into a much simpler format.

Skills: Accounting, Excel, Payroll

See more: excel staff roster, staff roster excel, design staff roster excel, design staff roster, roster design excel, design roster excel, myob roster, roster work, payroll design excel, work roster excel, excel roster work, payroll work excel, roster hours excel, roster excel staff, weekly roster employees excel, payroll spreadsheet myob, employee roster excel, design excel payroll staff, design excel payroll, staff roster works, design work roster, excel work roster, staff payroll excel work, excel work roster staff, design weekly payroll excel

About the Employer:
( 1 review ) la, Australia

Project ID: #1236337

16 freelancers are bidding on average $102 for this job

psprongs

HI, I have lots of experience with data processing using excel. I can provide you with a easy to use solution for the computation sheet with just the click of a button. Please check PMB psprongs

$50 USD in 2 days
(9 Reviews)
4.2
shacoim

***Plz Check PM***

$50 USD in 1 day
(10 Reviews)
3.9
FreddieQ

Hi, I can provide you with this service, and am ready to start. I am perfectly skilled in spreadsheets. Looking forward to work with you. Regards, Fredrick

$100 USD in 5 days
(0 Reviews)
0.0
farazlogics

Hello, Excel VBA expert here, Pleas contact, Thanks,

$80 USD in 3 days
(0 Reviews)
0.0
Renee1958

Hello, I am interested in the project you have available revising your Excel Spreadsheet for Payroll. As an Accountant I have had experience in Payroll and the Excel Program Work Experience 15 years Accountant More

$50 USD in 2 days
(0 Reviews)
0.0
MaryMuthama

Vast experience in data processing

$100 USD in 2 days
(0 Reviews)
0.0
nguyenthuha

Dear Sirs, Iam familar with creating excel formulation as a financial analyst at an Korean company. So that, I think I could do this work well. Please tell me more detail what you want do. Best Regards, Ha.

$70 USD in 3 days
(0 Reviews)
0.0
DevinderPal

Designed and Implemented Payroll on Excel for 250+ Employees with different pay scales Provided Macros and Buttons to execute regular and repeated steps Automated calculations and totals Provided Department T More

$150 USD in 5 days
(0 Reviews)
0.0
tra0109

Hi I am an MBA from University of Canberra (Australia). Did MYOB course in accounting unit. I am also good at excel. You can count on me for this project. Thanks.

$75 USD in 3 days
(0 Reviews)
0.0
onlyshipar

I am confident to finish your job. I have much knowledge in excel.

$100 USD in 3 days
(0 Reviews)
0.0
nomansiddiqui

waiting for your response.

$250 USD in 2 days
(0 Reviews)
0.0
prafulla1

I am interested to do this work. I will give my best .

$30 USD in 2 days
(0 Reviews)
0.0
SyncOrSwim

Hi there, I truly believe you need to review the over all cause to the need of such a tool! I'll write to you privately with a recommendation. Kind Regards, Loren

$200 USD in 1 day
(0 Reviews)
0.0
preethaVijay

Sample attached, we would need more data to generate the report

$120 USD in 2 days
(0 Reviews)
0.0
tokdiamond

Hi I am a business analyst with over 10 years experience at some of the top companies in Australia. I can automate this simply for you but you will need to provide me information regarding standard operating hours and More

$150 USD in 2 days
(0 Reviews)
0.0
zulu47

I have ten years of experience in working with payroll using excel. I can complete this job on time and accurately.

$50 USD in 1 day
(0 Reviews)
0.0