Payroll Program

I am tasked to develop a payroll system that is suitable for Singapore environment. 1) Bidder must be conversant in Excel VBA. This is the language the program will be developed. 2) The program must be working in all versions of Excel. 3) Have done up a payroll program before. Please submit screen shots of similar programs you have done before. 4) The program will be created in modules. As such, I may use different coders for different part of the projects. Shortlisted bidders will be asked to bid by modules

## Deliverables

The brief specifications: 1. User starts PayrollWorks for the first time. 1.1. The program prompted that the user is using the program for the first time. Program asked user to obtain password based on product code generated. 1.2. Once user entered the password, the program will bring the user to the first setup screen. The screen is a form asking user to set up the company information. User is allowed to create a single record from this machine. 1.3. Once these information is entered, user will be told that they are able to amend any of the information in the menu title company setup 1.4. User will be prompt to enter the company’s policy setup details. This includes OT computation, No pay leave, Leave encashment, Payment in-lieu of notice for employer as well as for employees, Overtime rates for Office Staff and Operation Staff 1.5. User will be prompted to provide a password for entering the payroll information. Admin ID and password will remain as default and the most powerful for program developer, i.e. SynergyWorks. 1.6. Once the details are captured into the database, user will be brought to the main menu screen. This will be the screen user will see from second login onwards. 2. From second login. User will click on the file on the file to open up payrollworks. The file will prompt them for enable or disable macros. If security is set to high, this screen will provide instruction on how to set the macro security to medium. It would be good if the program can be digitally signed. In this case, there will be no security prompt. Once macro is enabled, they will be prompt for login name and password. If their login is incorrect, an invalid login message would appear. A module must be set up to manage (Add, delete and amend) users. A module to allow user to change password is required. Administrator is not allowed to view users’ passwords. Only Super user can. 3. Once user has login, they would be presented with the main. All screens they go through must have a button to return back to main menu. 4. User will have to enter the employees’ details into the form to capture all the relevant data. All the required data must be coloured red or with an asterisk. These fields are necessary to calculate CPF or reporting to CPF (both are different items) or to prepare IR8A form. 5. User can update the adhoc or non-consistent items either individually or by batch. If the cost is significant to do both, I would rather have it by batch update. Employee list must be filtered to exclude those who have resigned in the prior month (prior month because they may be eligible for pro-rated pay if their last days are in the payroll month). 5.1. When working on batch payroll, it must be able to filter out those month that has been processed. This means that it is NOT an option to process payroll of a particular month if the records have been submitted to CPF board. 5.2. Resigned employees must be processed together with the main group. Their payments must be handled manually. I do not see the need to cater to this procedure because the resignation should not be that high. This could be included in the enhancement. 5.3. Due to the need to handle Giro payment processing, the payment method must be included. This is also to address those who are paid using cheques, especially those who resigned. Cheque No field must be given. 6. Payroll can be processed with or without updating the adhoc items. This is because not all staffs have adhoc items especially monthly rated staff. However, a warning prompt must be given and the option to go back to update the details is required. 7. Payroll must be presented in Excel Worksheets for checking and to make additional amendments where necessary (this is very similar to batch updates). Once the details are firmed up, they can calculate the CPF contribution for employer and employee. The process can occur many times. Every time the process is clicked, the details are saved into a temporary table. 8. The temporary table is the holding area where documents are processed. These documents refers to Letter of Instruction to the bank, Giro details, printing of payslips. I would suggest that the payslip are printed/generated only when the payroll is confirmed. This is to ensure that the employees received the same info as what we submit to CPF board. Should the amount submitted to CPF be wrong, the details must be taken down manually and adjustment made on the following month payslip. 9. Submit the payroll to CPF board. 10. At the end of the year, generate the IR8A and IR8S. 11. There is a form that needs to be submitted to CPF board for new employees. Need to prepare that as well. 12. 13. Uploading to CPF board is needed. There is an online system and this must be studied further. The Add, amend, delete functions must be available for all the processes.

## Platform

Window 98 onwards Compatiable with Excel 97 onwards. Access Database

Inženýrství Excel Microsoft Access Microsoft Exchange MySQL PHP Powerpoint Softwarová architektura Testování softwaru Visual Basic pro aplikace Word

Identifikační číslo projektu: #3220132

O projektu