Custom Payroll Spreadsheet Development
Budget: $750 – $1,500 USD
We need a custom payroll spreadsheet for home delivery drivers, built on Microsoft Excel. Our employee payment system is based on points, where one point equals one delivery at a set rate per-employee. Each employee is paid at a different rate per point. Each employee does an average of 10 stops (10 points) per-day. Additionally, we have several situational bonuses points that need to be incorporated. Each situational bonus point pays at a pre-determined rate. Some are full points; some are percentage points. The system needs to calculate the points and multiply it against the employee pay rate, to show the employee their anticipated pay.
Employees need to be able to enter the system using their employee ID. Employees need to see a standardized form where each stop is entered by Invoice number. Several data fields need to be incorporated into the form. Employees then select or check a box that indicates their situational bonus that apply to that stop. A comments field must allow for several lines of text. If a situational bonus is selected comments must be entered. No comments, no bonuses paid.
All home delivery teams are performed by a team of two or three employees. We would like one sheet per delivery that holds data for all the employees in the truck. We do not care which employee completes the form. Once an invoice has been entered, it should represent the same points for all involved employees. However, we do not want employees to view other employees pay. They should log in individually to see their pay statement.
Management needs to be able to add and remove employees. Management has to be able to periodically adjust employee pay and situational bonus points. Management needs to be able to add and remove situational bonuses. Everything must be locked and accessible by password only. Change tracking must be available.
There needs to be a review process by management to approve/disapprove the daily sheets. Finance and HR have to have full visibility of the process. Employees should be able to log into the system at any time and see where the approval process stands. The employees have to be able to see what points were approved or disapproved. Employees need to see management comments for disapproved points. Employees need to be able to print their sheets as a pay statement after approval. Sheets must remain on file for reference for a period of time, to be determined.
Requirements:
- Front end data entry screen for each driver with access by employee ID
- Calculate points based on deliveries
- Integrate a variety of situational bonuses
- Show estimated pay
- Review stage by managers to approve/disapprove points submitted by drivers, with a comments space
- Drivers have to be able to see their submitted sheets, with approval/disapproval comments or final payroll approval
- Backend spreadsheet for Finance that automatically calculates the approved pay
Ideal Skills and Experience:
- Proficient in Microsoft Excel
- Experience in creating complex payroll or financial spreadsheets
- Attention to detail and accuracy
The complete list of situational bonuses will be provided later.
Employees need to be able to enter the system using their employee ID. Employees need to see a standardized form where each stop is entered by Invoice number. Several data fields need to be incorporated into the form. Employees then select or check a box that indicates their situational bonus that apply to that stop. A comments field must allow for several lines of text. If a situational bonus is selected comments must be entered. No comments, no bonuses paid.
All home delivery teams are performed by a team of two or three employees. We would like one sheet per delivery that holds data for all the employees in the truck. We do not care which employee completes the form. Once an invoice has been entered, it should represent the same points for all involved employees. However, we do not want employees to view other employees pay. They should log in individually to see their pay statement.
Management needs to be able to add and remove employees. Management has to be able to periodically adjust employee pay and situational bonus points. Management needs to be able to add and remove situational bonuses. Everything must be locked and accessible by password only. Change tracking must be available.
There needs to be a review process by management to approve/disapprove the daily sheets. Finance and HR have to have full visibility of the process. Employees should be able to log into the system at any time and see where the approval process stands. The employees have to be able to see what points were approved or disapproved. Employees need to see management comments for disapproved points. Employees need to be able to print their sheets as a pay statement after approval. Sheets must remain on file for reference for a period of time, to be determined.
Requirements:
- Front end data entry screen for each driver with access by employee ID
- Calculate points based on deliveries
- Integrate a variety of situational bonuses
- Show estimated pay
- Review stage by managers to approve/disapprove points submitted by drivers, with a comments space
- Drivers have to be able to see their submitted sheets, with approval/disapproval comments or final payroll approval
- Backend spreadsheet for Finance that automatically calculates the approved pay
Ideal Skills and Experience:
- Proficient in Microsoft Excel
- Experience in creating complex payroll or financial spreadsheets
- Attention to detail and accuracy
The complete list of situational bonuses will be provided later.