Bank Salary System VB & MS Access Project

The Bank Salary System is useful for the employee‟s of the branch and reduce the manual calculation and saves lot of time and will give precise answers for all the fields of earnings. The reports of pay slip, register and loans are also complete and accurate.

Front – end : Microsoft Visual Basic 6.0
Back – end : Microsoft Access 2000
Project duration : 200 hours approximately

ABOUT EXISTING SYSTEM
In the existing Bank Salary System the salary of the employee of the SBI branch is calculated manually. The staff of the branch is divided in three categories.
1.) Officers (Management).
2.) Award Staff (Clerical).
3.) Subordinate Staff.

The above-described categories are further divided in the following Designations.

1.) Officers (Management): –

i.) JMG (Joint Manager)
ii.) MM – II (Main Manager – II)
iii.) MM – III (Main Manager – III)
iv.) SMG – IV (Subordinate Manager –IV)
v.) SMG – V (Subordinate Manager – V)
2.) Award Staff (Clerical): –

i.) Clerk
ii.) Sr. Assistant
iii.) Special Assistant
 3.) Subordinate Staff :-

i.) Messenger
ii.) Watch Man
iii.) Record Keeper
In the existing Bank Salary System the calculation of the salary is done on the bases of Basic Pay of an employee according to categories of the employee.
The salary of an employee is mainly based on the Earnings and the Deduction. There are number of fields in the earnings and the deduction from the salary of an employee. The calculation of each and every field is mainly based on the Basic Pay of an employee. And some of the fields of earnings and deduction are maintained with fix amount according to the status, seniority, and post or according to the designation of an employee.

The Basic Pay of an employee is fixed according to the designation and seniority of an employee working in the bank. And calculations of other fields are done on some fix percentage of Basic Pay of an employee according to the Memoranda of Settlements.
In the existing system the calculation of the fields of the earnings and deduction is calculated manually. So while calculating the amount of each and every field manually the chances of errors and calculation of wrong values are always possible.
In the existing system the salary of an employee is done manually and the person who is doing the salary of the branch fills the amount of each and every field of earnings and deduction. The fields whose amount are fixed are directly written at proper place and the fields whose value is depend on the fix percentage of Basic Pay is calculate and then are written in the Pay Slip. So the person who is doing the salary of the branch has to first of all fill all the information of an employee like employee number, employee name, designation of an employee, grade of an employee, department, date of salary etc. and then has to calculate the value of each and every field and then total the all fields of Earnings and Deduction and by deducting the total of deduction from the total of earnings the net pay is calculated. Now while doing the salary of an employee the person also has to maintain the Register in which all the information of the salary of an employee is noted. Register is maintained for the purpose of keeping the record of each employee for calculation of Income Tax and for the calculation of Provident Fund etc.
As mentioned above the salary of all employee of the branch are calculated with large calculations, manpower and handling of the large documents with chance of having lots of errors and time consumption.

PROBLEM IDENTIFICATION

Drawbacks of existing system.

1.) Register Maintenance.
2.) Time Consumption.
3.) Pay Slip Preparation.
4.) Problem In Calculating Income Tax.
5.) Problem In Calculating the amount of Loans.
6.) Calculating the field amount.

1.) Register Maintenance: –

At the time of calculating the salary of the branch the register is also maintained and a person who is doing the salary has to copy all the amounts of fields in the pay slip from the register.
A register is maintained for whole year and the salary of each employee is noted in the register. So if an employee wants to know his salary of previous month he/she has to refer the whole register and find his/her employee number from the register, the particular month he/she wants etc. and then he/she will be able to get the salary record. Now if he/she wants the copy of the salary slip he/she has to manually write the whole pay slip. Now there is also problem of storage of all the registers, because there are so many factors by which the registers can be destroyed like fire, water, stolen, etc.

2.) Time Consumption: –

The process of calculating the amount of each field whose value is depend on the basis of percentage of basic pay is very much time consuming and it is having lots of calculations.
If an employee wants more than one copy of the pay slip then also it will take lots of time for preparing another copies of the pay slip. The process of calculating the salary of an employee is very much time consuming and boring for a person who is doing the salary of the whole branch.

3.) Pay Slip Preparation: –

As mentioned above the process of register maintenance, and then the pay slip is prepared from the register is very much time consuming and the chances of errors and mistakes is always present.

4.) Problem In Calculating Income Tax: –

The employer is required to deduct income tax from the salary paid to an employee. The income tax is calculated based on gross salary paid to the employee during a year, if it exceeds a limit. Because of the manual system the calculation the income tax amount become very difficult and time consuming.

5.) Problem in calculating the amount of Loans: –

The handling of the loan amount and the calculation of loan amount is very difficult and time consuming in the existing bank salary system. The problems with the handling of loan amount is that sometimes the amount is wrongly written by the person who is doing the salary, the employee has to pay more amount from his/her salary.

6.) Calculating the field amount: –

The calculation of the field amount of the earnings and deduction is very hard and time consuming when the field amount is based on the basis of the fix percentage of the Basic Pay of the employee. The chances of errors and mistake are very much in the existing bank salary system.The above described are the drawbacks of the manual bank salary system with makes the process difficult, time consuming and very hard for the person who is doing the salary of the branch and is also not beneficial to the employees of the branch