Importance of payroll:-

Employees moral is affected by payroll administration and employee is the main resource of any organization.

Employees should be paid sufficiently to motivate employees.

Scope 

Payroll system has following scope.

1) Defining salary structure of an employee.

2) Acceptance of attendance of employees.

3) Defining leave structure of an employees.

4) Identify employee type & designation.

5) Calculating Gross income, deductions & finally Net Income of an employee.

6] Providing salary details to employee.

7) Generation of reports.

Existing System 

Working of an existing manual payroll system is as follows:

  1. Salary structure and leave structure are obtained by payroll department from HR department.
  2. Attendance record in form of musters is also obtained from attendance monitoring system.
  3. All the employees are identified manually  ,  records from musters are checked to identify employee type. After identifying the employee type depending on his/her designation Net salary, gross salary are calculated . if any deductions are there then that are also deducted. Payslip is generated by considering there payable days depending on the records obtained from attendance monitoring system, salary structure and leave structure.
  4. Reports are generated ,reports like total amount given in form of salaries.
  5. Monthly reports and yearly reports are also generated. This reports are then transferred Management.
  6. All this calculations are done manually by the payroll department staff.

Payroll Management System Home Page

Limitation of existing system:

1)   For identifying the employee type Existing manual method takes time as it uses musters to check the records.

2)   Net income , gross income and all the necessary deductions are done manually in existing system , which may cause error in calculations.

3)   All the employee details are maintained in Musters , which involves lot of redundancy and also it takes lot of time in order to backup the whole employee details ,which physically is not much feasible.

4)   Generation of pay slips are done manually by pay role employees. Which is a time consuming process.

5)   All the reports, are also developed by payroll employees manually.

All this tasks are time consuming and can involves errors due to lot of human  interface.

User Environment:

The development environment of system is client server.

  1. Client side requirements.
  1. Server side requirements 

Client side requirements:- 

minimum Hardware requirements:- 

  • It require minimum 512 mb ram.
  • 10 gb of memory to store data of  customers.
  • It require monitor i.e L.C.D or desktop.
  • It supports to keyboard of 120  keys(only English)
  • It require optical mouse.

software requirements:- 

  • Front end:- it require JVM (Java Virtual Mahine).
  • It supports Microsoft related operating
  • Related drivers as specified in hardware

Software requirements:-

  • It require jdk1.6.0
  • MYSQL to maintain database.

Network connectivity requirement:-

Star topology :- it require hub. fiber optic cable in order to connect clients to server.

Payroll Management System in jsp

Test Case for Payroll Management System:

Test Case ID Input Description Expected Result Actualresult
 1 User name=e1000 Enter user name with the help of  i/p interface1)Enter username

2)Enter valid password

3)Press Login

System should accept the behavior.System will display Home page.
 2 User name=”” Enter user name with the help of  i/p interface1)Enter valid password

2)Press Login

System will display error message.
 3 User name=employee Enter user name with the help of  i/p interface1)Enter username

2)Enter valid password

3)Press Login

System should accept the behavior.System will display Home page.
 4 Password=”invalid” Enter user name with the help of  i/p interface1)Enter username

2)Press Login

System will display error message.
 5 User name=#$kiran Enter user name1)Enter user name

2)Password

3)Press Login

System will display error messageUser will be navigated on same page
      6 Enter Employee Id=e1000 Enter Employee Id with the help of i/p interface1)Enter Employee Id

2)Press Submit

System should generate new password & send to valid employees mobile no
7       Enter Employee Id=*&kiran% Enter Employee Id with the help of i/p interface1)Enter Employee Id

2)Press Submit

System should not generate new password& display Invalid employee id message
8 Enter Employee Id=e1000 If user selected forgot password link  & entered Employee ID  System should send existing user password to user via mobile
     9 Click on Paygrade Button If manager click on paygrade button system should display available paygrade in system
    10 Click on Edit Button If manager click on paygrade tabs Edit button system should allow manager to edit fields in paygrade table
   11 Click on Save Button If manager click on paygrade tabs Save button system should save details changed by manager
   12 Click on Earning Button If manager click on Earning button system should display available Earning in system
    13 Click on Edit Button If manager click on paygrade tabs Edit button system should aloow manager to edit fields in paygrade table
    14 Click on Save Button If manager click on paygrade tabs Save button system should save details changed by manager
    15 Click on Deduction Button If manager click on Deduction Button system should display available Deductions in system
    16 Click on Leave structure Button If manager click on Leave structure  Button system should display available Leave structures in system
    17 Click on Employee Details Button If manager click on Employee Details Button system should display available Employee Details  in system
    18 Click on Reports Button If manager click Reports Button system should display Reports  to manager
     19 Click on Generate payslip Button If Payroll Accountant click Generate payslip Button system should  display search employee form toPayroll Accountant
    20 Click on Submit Button If Payroll Accountant click Generate payslip’s Submit  Button system should  display employee details of corresponding employee id
    21 Click on Generate Button If Payroll Accountant click Generate payslip’s  generate  Button system should  display employee salary slip of that employee

 

Test Plan of Payroll Management System

General Information:

Summary:

We are testing the software of an Payroll Management System which maintains the information of salary of every employee of whole  organization.& generates payslips of employees.

Environment and Pre-Test Background:

This software is being tested in Sibar-Mca Computer lab by Mca 2nd year.

No prior testing has been done on this project.

Test Objective:

Authentication & Authorization.

View Employee Details.

Employee Performance Appraisal

Generates Payslips

Report Generation.

Modify Leave & salary structure

Plan

Software Description:

Sr no: Process Input Output
1 Change Paygrade Details Click on Edit Button of Paygrade Updates DatabasePrompt message to user for completion
2 Change Leave Structure Details Click on Edit Button of Leave Structure Updates DatabasePrompt message to user for completion
3 Change Earnings Details Click on Edit Button of Earnings Updates DatabasePrompt message to user for completion
4 Change Deductions Details Click on Edit Button of Deductions Updates DatabasePrompt message to user for completion
5 Payslip Generation  Employee Id Printed payslip

Test Team:

Test team will have following members:

Tester:

Tester will perform the actual testing.

Business Expert:

Business Experts are those people who have knowledge about the business domain.

Test-Team Manager:

Test-Team Manager will be monitoring the whole testing process.

User:

User is the End user who will be actually dealing with the software.

Requirement:

Computer with Eclipse any version  Apache tomcat  Java 1.6.0 and MYSQL Software installed on it.

We will require Software requirement Specification document as well as Vision Document.

Specifications & Evaluations: 

Salary Strucure Details:

This will help the Organization to keep information of salary structures of each employees and will provide facilities to access it.

Leave Strucure Details:

This will help the Organization to keep information of Leave structures of each employees and will provide facilities to access it…

Report Generation 

This will generate various reports demanded by the organization to keep an eye on growth of their organization, working of staff etc

Structural Functions:

Give Specifications:

User will have to register for that Application form will be provided.

After Registration, User will have Password.. 

Employee Information:

Depending upon the paygrade employee will be classified into either payroll employee or payroll manager.If user is a payroll manager of Organization then we will provide him facilities to Add, Edit as well as Delete payroll Details.

Payroll employee will be provided with search option to search particular employee for generation of his/her payslip.

Report Generation:

User will be provided with list of Reports using which he can generate report by clicking on that options

User will be provided interface where he need to give dates of which report has to be generated.

According to the Report, user will need to give details on basis of that detail report will be generated.

 Functional Requirements:

Sr no Functions Tests
1 Give Specification UsabilityCorrectness

Reliability

Security

Performance

Maintainability

Visibility

2 Report Generation SecurityReliability

Correctness

Understandability

Visibility

Methods & Constraints:

Methodology:

We will be using White box testing for testing the project of  payroll management. 

Evaluation:

Sr no Objective Priorities Completeness Criteria
1 Adding Data High System should Add data into the database.It should also prompt acknowledgement to the user.
2 Updating data High System should update the old data with new updated data.System should check the authentication of user and then make changes to the database.

It should prompt message to the user about updating.

3 Deleting data High System should Remove the data demanded by the user from the database.It should check the authentication of the user before deleting the record.

It should also confirm that a message is prompted to user about deletion confirmation.

4 Searching data High System should retrieve data from database when search option has been clicked.If data is not found relevant to user demand, a message should be displayed to the user about data not present.
5 Report Generation High After selecting particular report, Data related to that report should be properly retrieved from the database in proper format.