Advanced Payroll Excel Workbook Creation
Budget: $1,500 – $3,000 AUD
I require an Excel Workbook that can support a wide range of rosters involving various pay parameters. The Workbook should allow for the input of any given roster, and automate the assessments of pay based on a variety of specifics:
- Premiums associated with hours of work which include daytime shifts, night shifts, weekends and public holidays.
- Calculation of pay parameters such as the hourly rate, overtime rate, and special shift percentages ( afternoon, night and weekend loadings).
The ideal freelancer for this task should possess a high level of competency in Excel, particularly in the areas of advanced VBA programming, functions and calculations. An attention to detail is imperative to ensure all factors of the pay parameters are applied correctly and implemented accurately.
- Premiums associated with hours of work which include daytime shifts, night shifts, weekends and public holidays.
- Calculation of pay parameters such as the hourly rate, overtime rate, and special shift percentages ( afternoon, night and weekend loadings).
The ideal freelancer for this task should possess a high level of competency in Excel, particularly in the areas of advanced VBA programming, functions and calculations. An attention to detail is imperative to ensure all factors of the pay parameters are applied correctly and implemented accurately.