Advanced Payroll Calculation Spreadsheet
$250-750 USD
着払い
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including:
- Weekly overtime after 40 hours.
-All hours on any given workday shall be paid at the straight time rate of pay unless forty
(40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unless forty (40) hours have already been worked at straight time. Hours already compensated at the overtime rate will not be considered when calculating overtime after 40 hours in a week.
- If performing extra work in addition to the employee's bid/scheduled route - Daily overtime is triggered for the day after 8 hours.
Employees will need to be able to enter their clock in and out times in the hours and minutes format
(example: 10:13am). A workweek is Monday through Sunday.
-initial clock in
-clock out for lunch
-clock in from lunch
-end of shift clock out
*some routes will not have an unpaid meal break and will only need to enter an Initial clock in and an end of shift clock out.
**employees may need to use the clock in / clock out feature to split up 'extra work' and bid/scheduled time for the purpose of accurately calculating differentials
Employees will need to be able to select on a per day basis whether or not they worked
1)only their bid route (straight time rate of pay unless forty (40) hours have already been worked at straight time)
or
2)picked up additional work (overtime triggered after 8 hours for the day)
so that the correct overtime rule has been applied.
Employees will need to use the clock in / clock out to designate time as 'paid time off' / 'holiday bonus'. This time will not apply to the weekly overtime after 40 hours calculation. Using the clock in / clock out employees may enter an entire day as paid time off or holiday bonus, or a partial day.
Hours worked may also qualify for shift differentials. Differentials may apply to an entire shift or only a portion of one's shift. Employees will need to be able to select if a shift qualifies for a differential on a per work period basis. Example: The employee works his normal bid shift which does not qualify for a differential but picks up 3 hours of extra work on the end of their shift. The employee would need to be able to select that specific 3 hours of time in their workday to apply the differential. If only a period of time during the workday and not the entire workday qualifies for a differential, employees can separate the periods of time by using a clock in / clock out entry on the spreadsheet.
swing shift – 3%
split shift – 4%
long split shift – 5%
A period is two weeks. Week one will be the first Monday through Sunday of the pay period. Week two will be the second week of the pay period.
Payroll Audit report should include the following and represent hours in a decimal format (example 5.76 hours):
1)Total pay period regular time hours
2)Total pay period overtime hours
3)Total pay period 'Paid time off' / 'holiday' hours
4)Total pay period hours that qualify for regular time swing shift differential – 3%
5)Total pay period hours that qualify for overtime swing shift differential – 3%
6)Total pay period hours that qualify for regular time split shift differential – 4%
7)Total pay period hours that qualify for overtime split shift differential – 4%
8)Total pay period hours that qualify for regular time long split shift differential – 5%
9)Total pay period hours that qualify for overtime long split shift differential – 5%
10)Week one total regular hours
11)Week one total overtime hours
12)Week two total regular hours
13)Week two total overtime hours
The deadline for this project is within a month. The ideal freelancer should have a strong understanding of pay calculations and overtime rules, as well as advanced Excel skills.
プロジェクトID: #38067327
プロジェクトについて
52人のフリーランサーが、平均$500 で、この仕事に入札しています。
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look もっと
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
Hi there! As I have read, I see you need help developing a spreadsheet that calculates gross pay based on clock in and clock out times, factoring in specific overtime rules for your workplace. I could help you! I can もっと
Hello Kelsey T., I can get this project done ASAP with high accuracy! Accounting I am a qualified accountant and a certified quickbooks and Xero Advisor with 12 years of experience in bookkeeping, reconciliation, f もっと
Hi there, I am pleased to present for providing Windows Application and services to meet your organization's data management and storage needs. I am an experienced Desktop Application professional with SQL and relatio もっと
Professional Excel VBA developer ready to develop the Advanced Payroll Calculation Spreadsheet, All point checked, understood, Reach out will be pleasure to help.
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For もっと
Drawing on my extensive 15 years of industry experience, I am confident that I am the perfect fit for your Advanced Payroll Calculation Spreadsheet project. Excel is one of my core skills and a powerful tool I have use もっと
Hey Kelsey, I have carefully read through the project requirements for the development of an Advanced Payroll Calculation Spreadsheet. To ensure accurate gross pay calculations based on clock in and clock out times, t もっと
Hi! I will develop an excel sheet that will cater all these computations and we might have to use VBA codes as well to prepare this which I am expert of. I am a seasoned professional in preparing models which help my c もっと
Hi dear friend I am proficient in programming in asp.net core, vb.net, SQL, Excel, VBA and automation tools in the Windows environment. Plus 15 years of challenging experience in organizations and 5 years in freelanc もっと
Hi Good afternoon , How are you? I just saw your job posting . I see you have been looking for someone experience with these technologies Data Processing, Excel and Accounting. I believe this is some thing I can help もっと
Hello Kelsey T.! I have read your instructions keenly, and this is something I can comfortably do. I have advanced experience in Data Processing, Excel and Accounting. I am excited to use my skills to help achieve もっと
