SQL Payroll

SQL Payroll
Table of Contents
1. Getting Started ...................................................................................................................... 1
1.1. System Requirements .................................................................................................. 1
2. Installation ........................................................................................................................... 2
2.1. Standalone Installation ................................................................................................. 2
2.2. Network Installation .................................................................................................... 6
2.2.1. At the Server Side ............................................................................................ 6
2.2.2. At the Client or Workstation Side ....................................................................... 6
3. Overview ............................................................................................................................. 9
3.1. Features .................................................................................................................... 9
3.2. Standard Functions & Buttons ....................................................................................... 9
4. Human Resource ................................................................................................................. 10
4.1. Maintain Employee ................................................................................................... 10
4.1.1. Personal ........................................................................................................ 10
4.1.2. Category ....................................................................................................... 10
4.1.3. Family .......................................................................................................... 11
4.1.4. Payroll Information ......................................................................................... 12
4.1.5. Allowance & Deduction ................................................................................... 13
4.1.6. Note ............................................................................................................. 13
4.2. Human Resource Maintenance ..................................................................................... 14
5. Payroll ............................................................................................................................... 16
5.1. New Payroll ............................................................................................................. 16
5.1.1. Final ............................................................................................................. 16
5.1.2. Frequency ..................................................................................................... 16
5.1.3. Ad Hoc ......................................................................................................... 17
5.2. Open Payroll ............................................................................................................ 18
5.3. Open Pending Payroll ................................................................................................ 21
5.4. Payroll Maintenance .................................................................................................. 22
5.4.1. Maintain Wages ............................................................................................. 22
5.4.2. Maintain Frequency ........................................................................................ 23
5.4.3. Maintain Contribution ...................................................................................... 24
5.4.4. Maintain Allowance, Deduction & Commission. ................................................... 25
5.4.5. Maintain Overtime .......................................................................................... 25
5.4.6. Maintain Claim .............................................................................................. 26
5.4.7. Maintain Payment Method ................................................................................ 26
6. Leave ................................................................................................................................ 29
6.1. Leave Entitlement Processor ....................................................................................... 29
6.2. Leave Application ..................................................................................................... 29
6.3. Leave Maintenance .................................................................................................... 32
6.3.1. Maintain Calender .......................................................................................... 32
6.3.2. Maintain Leave Type ...................................................................................... 33
6.3.3. Maintain Leave Group ..................................................................................... 34

iv
Chapter 1. Getting Started
1.1. System Requirements
The following requirements are needed in order to run SQL Suite Application

1. For Standalone or Client (Workstation) PC

• Microsoft Windows 2000 and above (recommended Windows XP).

• SVGA - minimum of 65K colors (16-bit) recommended.

• Pentium III and above computer (recommended Pentium IV and above).

• 256 MB of RAM (recommended 512 MB).

• 180 MB of available hard disk space.

• Microsoft Windows Compatible Printer.

2. For Server PC

• Microsoft Windows 2000 and above (recommended Windows XP).

• SVGA - minimum of 65K colors (16-bit) recommended.

• Pentium IV and above computer.

• 512 MB of RAM (recommended 1GB).

• 180 MB of available hard disk space.

• Microsoft Windows Compatible Printer.

• 100 Base-T NIC.

1
Chapter 2. Installation
2.1. Standalone Installation
1. Once you finish install the SQL Application, double click the SQL Application icon at the desktop and the
below dialog will appear.

2. Click Create Group.

A. Create Group : Use to create multi access server.

B. Add Group : To add the Existing Group Server.

3. Enter File Name example Default. It advisable to not to enter too long name and make sure the name does
not had any spacing.

2
 Installation

4. Click Save and you will see the below dialog.

A. Description : This is the Group Title. Very useful for user who wanted to access to multiple server. (E.g.
Standalone Version)

B. Database Engine : Which Database to be use for the SQL Application. (E.g. Fire bird Embedded
Database)

C. Server : The Server Name or IP Address. (For Network Installation Only (E.g. 192.168.0.1))

D. Port No : Is the Port Number to be use by the Database Engine.

3
 Installation

E. Database User name : Database Engine User Name.

F. Database Password : Database Engine Password.

G. Folder : Show where to keep the database.

H. Test Connection : To check the Connection Status. If the Status shown in Red color or Connection
Inactive, make sure

• Database Engine you select is correct and Installed.

• Server Name or IP Address is correct.

• Database surname & Password is Correct.

• Port Number is correct.

5. Click OK and you will see below dialog.

6. Double Click the Icon and you will see below dialog

4
 Installation

A. Backup : Backup the selected Database.

B. Restore : Restore the Database from the Backup.

C. Create New Database : Create actual database.

D. Create Sample Database : Create a database with sample transaction.

E. Find Database : To find the lost link database Automatically.

F. Add Database Link : Manually Add the lost link database

G. Back to Database Group : Go back to the Database Group Option (Back to Step 5).

7. Click Create New Database and you will see below dialogs.

A. Database : Is the Database file Name. May leave it as default.

5
 Installation

B. Company Name : The company name for the new Database.

C. Remark : Additional Information for differentiate the same company name.

D. Admin Password : Password for ADMIN user. Click the Change Password to change the password.
Default is ADMIN

8. Click OK and you will see the login screen as below.

A. Logon Automatically : This useful for single user & single company as you can by pass entering the
password.

B. 3 Dot button : Click this button to back to Step 6.

9. Enter ADMIN password and click Log on.

2.2. Network Installation

2.2.1. At the Server Side
1. Follow the Standalone Installation.

2. Full Sharing the Share Folder (in C:\Program Files\eStream\SQL Application).

2.2.2. At the Client or Workstation Side

1. Once you finish install the SQL Application, double click the SQL Application icon at the desktop and the
below dialog will appear.

2. Click Add Group

6
 Installation

3. In the Look in look browse to the Entire Network (My Network Places) and look for your Server PC Name.

4. In the Server PC folder, double click the Share | Default.DCF file.

5. Double Click the Newly Added Database Icon (e.g. Network Version) and you will see below dialogs.

7
 Installation

6. Double Click the Company Name where you wanted to enter.

7. Enter Your User Name & Password and Click Log On.

8
Chapter 3. Overview
3.1. Features

3.2. Standard Functions & Buttons

But- Shortcut Description
ton
Ctrl+X Cut

Ctrl+C Copy

Ctrl+V Past

First Record

Previous Record

Next Record

Last Record

Insert New Record

Edit Current Record

Delete Current Record

Save Current Record

Cancel Record

F5 Refresh
Ctrl+F Find Record
Print
Preview

9
Chapter 4. Human Resource
4.1. Maintain Employee
4.1.1. Personal
Enter the Employee Personal Profile like Gender, D.O.B, Home Address and etc in the Personal Tab.

A. Code : Employee Code or Number.

B. Name : Full Name of the Employee.

C. Active : Untick the Active to indicate the employee is resign

4.1.2. Category
This tab is recording the Employee Category or Group.

10
 Human Resource

A. Branch : Which Company Branch he/she is.

B. HR Group : Which Company Human Resource Group he/she in.

C. Department : Which Company Department he/she in.

D. Category : Which Company Category he/she is.

E. Project : Which Company Project he/she is.

F. Job : Which Company Job he/she is.

G. Task : Which Company Task he/she is

H. Calender : Which Calender Type is (For Leave Application)

I. Country : Which Country he/she from.

J. Race : What is he/she Race

K. Leave Group : Which Leave Group he/she is (For Leave Entitlement Calculation)

L. Join Date : When he/she Join the Company.

M.Confirm Date : When he/she Confirm.

N. Resign Date : When he/she Resign from Company.

4.1.3. Family
This recording the Employee Spouse or Family Information. Useful for I.C.E. (In Case of Emergency).

11
 Human Resource

4.1.4. Payroll Information

This recording the Payroll Calculation like EPF, Socso & Tax Information.

A. Wages Type : Which Wages type like Daily or Monthly.

B. Wages : Amount per Month or per Day

C. Contribution : Which Contribution Calculation like EPF Rate, Working Per Month and etc.

D. Frequency : How many payment per month.

E. Payment Method : The salary is pay by Cheque or Bank.

F. Bank Account No : Bank Account No (For Bank In or Bank Transfer)

G. EPF No : Employment Provided Fund (KWSP) Number. (For Borang A)

12
 Human Resource

H. NK : Refer to Borang A NK column.

I. Initial : For EPF Borang A Electronic Transfer.

J. Socso No : SOSCO Number

K. Socso Type : Which SOCSO Type is use to calculate (Norm is First Category)

L. Tax Branch : Tax Branch where the employee file is open.

M.Tax No : The employee Tax File Number.

N. Marital Status : Either Single, Married, Divorce or Widow. (For Tax Calculation (PCB or CP 39))

O. Tax Deduction Child : Number of Children which Deductible in Tax Calculation (PCB or CP 39)

P. Spouse Working : For Tax Calculation (PCB or CP 39)

Q. Tax Category : Tax Calculation Category (May Ignore it cause system will allocate for you)

R. EA Serial No : For CP 8A (EA Form)

4.1.5. Allowance & Deduction

The fixed Allowance or Deduction for the Employee.

A. Allowance/ Deduction : Allowance or Deduction Code.

B. Description : Description to shown in Pay slip.

C. Amount : Amount to be pay or deduct.

D. EPF : Include the calculation of EPF.

E. SOCSO : Include the calculation of SOSCO.

F. PCB : Include the calculation of PCB

G. OT : Include the calculation of OT.

H. EA : Shown in EA Form (CP 8A).

I. HRDF : Include the calculation of HRDF (Human Resource Development Fund).

4.1.6. Note
Additional Information and the Employee Photo. Advisable to use JPG format with Max resolution is 300 x
300 dpi.

13
 Human Resource

4.2. Human Resource Maintenance

The below screen is applied for the following Maintenance.

• Maintain Branch

• Maintain Department

• Maintain Group

• Maintain Category

• Maintain Project

• Maintain Job

• Maintain Task

• Maintain Race

• Maintain Country

14
 Human Resource

A. Code : Code

B. Description : Full Description.

C. Active : Untick it if the Code is not use anymore.

D. Set as Default : If Clicked it will auto select the Code In the New Employee.

15
Chapter 5. Payroll
5.1. New Payroll
Process or create New Payroll.

5.1.1. Final
Use to process the Month Pay Salary and Final Pay Salary.

A. Year : Year to be process.

B. Month : Month to be process.

C. Process Date : Posting Date (Norm is end of the Month)

D. Description 1: Information to be shown in Open Payroll.

E. Description 2, Ref 1 & 2 : Additional Information which can be shown in Report Eg. Pay slip.

5.1.2. Frequency
Use to process the Payroll which pay not pay on the Last Month (not Last payment of the Month)

16
 Payroll

A. Year : Year to be process.

B. Month : Month to be process.

C. Frequency : Frequency Type to be process.

D. Sequence : Which Sequence to be process from the selected Frequency Type.

E. UTD Contribution % : The % to be paid for EPF, Socso & Tax.

F. Process Date : Posting date.

G. Process From & To : Calculation Range Date.

H. Description 1: Information to be shown in Open Payroll.

I. Description 2, Ref 1 & 2 : Additional Information which can be shown in Report Eg. Pay slip.

J. Employee : List of Employee(s) will be process.

5.1.3. Ad Hoc
It same like Frequency. The different is the Frequency is keep preselected contribution and employee.

17
 Payroll

A. Year : Year to be process.

B. Month : Month to be process.

C. UTD Contribution % : The % to be paid for EPF, Socso & Tax.

D. Process Date : Posting date.

E. Process From & To : Calculation Range Date.

F. Fixed Transaction : This section is to process the Fixed Transaction which Maintain in Maintain Employee.

G. Pending Transaction : This section is to process the Transaction which had being Maintain in Pending
Payroll.

H. Description 1: Information to be shown in Open Payroll.

I. Description 2, Ref 1 & 2 : Additional Information which can be shown in Report Eg. Pay slip.

J. Employee : List of Employee(s) to be process

5.2. Open Payroll

This option is to Open the Past Process Transaction.

18
 Payroll

A. Show the Current Working Month Process.

B. Past Transaction in Yearly.

Click on the Month icon and Right Click and you will see the below popup menu.

A. Open Payroll : Open All Employee for the Selected Month Payroll Process.

B. Open : Open All Employee by Type in listing.

C. Print Payslip : Print the Pay Slip for the Selected Month.

D. Print Payroll Summary : Print Payroll Summary Report for the Selected Month.

E. Print EPF Borang A : Print KWSP Borang A for the Selected Month.

19
 Payroll

F. Print SOCSO Borang 8A : Print Socso Borang 8A for the Selected Month.

G. Print Income Tax CP 39 : Print Potongan Cukai Berjadual (PCB) for the Selected Month.

H. Delete : Delete the Selected Month process.

I. Refresh : Refresh the Open Payroll List.

Click on the Year icon and Right Click and you will see the below popup menu.

A. Open : Open the Selected whole year Payroll Process.

B. Print Yearly Report : Print the Yearly report by Type (E.g. Yearly Wages, Yearly Allowance etc)

C. Print Yearly Individual Report : Print Individual Payment Salary Report By Monthly.

D. Print Income Tax EA Form : Print the CP 8A form. (For Individual Income Tax)

E. Refresh : Refresh the Open Payroll List.

Double click the Month icon and you will see the below dialog.

A. List of Employee Name. Double Click one of the employee to open the detail of payment and you will the
below screen.

B. Click any of the button to print the Monthly required reports.

C. Process Missing Employee : This to progress the Employee where is not being processed because of Process
is done before the Employee Create.

20
 Payroll

Mouse over the each Type (where it circle with blue color) and click on it to view detail (E.g. Mouse over the
Allowance and Click on it and you will see something like the above screen).

A. Money Plus & Money Minus : To add or delete record.

B. Flag : To highlight what is currently added (Only work if the record is in Edit Mode (i.e. The highlight will
reset after Click Save).

5.3. Open Pending Payroll

Use to record the transaction which to be process at the Process Payroll. By Default it will display the Current
Working Month.

21
 Payroll

A. Pending XXXX : Show the Current Year Pending Transactions in Monthly. XXXX is the Current Working
Year.

B. Pending Navigator : Show the Current Months Pending Transaction in Month View (In Day)

C. Show All Pending Payroll : Show All the Pending Payroll in Yearly.

D. With Transaction : Show which Type which had transactions.

E. Without Transaction : Show which Type which doesn't had the transaction.

5.4. Payroll Maintenance

5.4.1. Maintain Wages
This to maintain the type of wages is going to pay and the contribution.

22
 Payroll

A. Code : Wages Code.

B. Description : Full Wages Type Description.

C. UOM : Unit Of Measurement for Wages (e.g. PCS, Day, etc). For Monthly may ignore this field.

D. Active : Untick if the record is no more in use.

E. Set as Default : If Click it will auto Insert on New Employee.

F. Contribution : Does this Wages type need to include the calculation of EPF, SOCSO, PCB, OT, EA &
HRDF(Human Resource Development Fund)

5.4.2. Maintain Frequency

This to Maintain the number of Payment in a Month.

A. Code : Frequency Code.

B. Description : Full Frequency Type Description.

C. Active : Untick if the record is no more in use.

23
 Payroll

D. Set as Default : If Click it will auto Insert on New Employee.

E. In The Grid

i. SEQ : Calculation Sequence. Normally start from 1.

ii. Day From & Day To : Which Range Day to be calculate.

iii. Contrib % : The Percentage to be pay for the Contribution Calculation.

iv. EPF, SOCSO, PCB, Allowance & Deduction : Which Contribution to be calculate.

The above example is base on the below condition

I. From Day 1 to 14 pay for 30% for all Contribution and Wages.

II. From Day 15 to 21 pay for 20% for all Contribution and Wages.

III.From Day 22 to end of Month pay for balance 50% for all Contribution and Wages.

5.4.3. Maintain Contribution

This to record Does the EPF, SOCO, PCB, EA, HRDF & OT is to be included for Bonus, Director Fee, Pay
Leave & Unpaid leave calculation?.

A. Code : Contribution Code.

B. Description : Full Contribution Type Description.

C. Active : Untick if the record is no more in use.

D. Set as Default : If Click it will auto Insert on New Employee.

E. Employee & Employer EPF Rate : The Percentage or Amount for KWSP for Employee & Employer. (For
KWSP Borang A).

F. Working Day Per Month : Show how many working day per month. (For OT Calculation)

G. Working Hour Per Day : Show how many working hours per day. For OT Calculation)

24
 Payroll

H. Overtime Calculation base on Maintain Employee Setting : If Untick the Overtime Calculation will base
on the Process Month.

5.4.4. Maintain Allowance, Deduction & Commission.

Below screen is apply to Maintain Allowance, Maintain Deduction and Maintain Commission.

A. Code : Code.

B. Description : Full Description.

C. Active : Untick if the record is no more in use.

D. Set as Default : If Click it will auto Insert on New Employee and Pay Sheet.

E. Contribution : Does this Type payment need to include the calculation of EPF, SOCSO, PCB, OT, EA &
HRDF(Human Resource Development Fund)

5.4.5. Maintain Overtime

25
 Payroll

A. Code : Overtime Type Code.

B. Description : Full Overtime Type Description.

C. Rate : Rate to be pay

D. Unit Type : Overtime is calculate on either Daily or Hourly.

• Daily : Overtime Amount = (Wages / Working Day Per Month) * Rate

• Hourly : Overtime Amount = ( Wages / Working Day Per Month / Working Hour Per Day) * Rate

E. Pay Rate Script : This is to override the System Overtime Calculation. (Refer to Maintain Script for Detail)

F. Active : Untick if the record is no more in use.

G. Set as Default : If Click it will auto Insert on Pay Sheet

H. Contribution : Does this Overtime type need to include the calculation of EPF, SOCSO, PCB, EA &
HRDF(Human Resource Development Fund)

5.4.6. Maintain Claim

A. Code : Claim Code.

B. Description : Full Claim Type Description.

C. Amount : Default Claim Amount.

D. Active : Untick if the record is no more in use.

E. Set as Default : If Click it will auto Insert on Pay Sheet.

5.4.7. Maintain Payment Method

This to maintain the Salary Payment type for the particular Employee.

26
 Payroll

A. Code : Payment Method Code.

B. Description : Full Payment Method Description.

C. Bank : For Bank Electronic Credit Transfer Only.

D. Bank Account No : Company Bank Account Number.

E. Next Cheque No : Next Running Check Number.

F. Payment Type : Payment Type

• Cash : Pay by Pure Cash (For Coinage Report)

• Cheque : Pay by Cheque (For Cheque Listing Report)

• Direct Transfer : Pay using Direct Debit or One Cheque Pay All Employee or Bank Electronic Credit
Transfer (For Credit Bank Report)

G. Branch : Bank Branch.

H. Address : Bank Address.

27
 Payroll

I. Contact Person : Bank Person In charge.

J. Reference 1 & 2 : Additional Information.

K. Phone 1 & 2 : Telephone Number 1 and 2

L. Fax : Fax Number

M.GL Account : General Ledger Bank Account Code (For Linking with SQL Accounting)

N. Set as Default : If Click it will auto Insert on New Employee.

28
Chapter 6. Leave
6.1. Leave Entitlement Processor
The to process the Annual Leave Entitlement. Normally process at the beginning of the year only.

A. Year : Select the year to be process.

B. Process : Start the Calculation.

6.2. Leave Application

This to record the Leave taken by employee.

A. New Leave Application : Open the new Leave Application.

B. Leave Inquiry : To check which employee is taken what leave type and in which day.

Click on the New Leave Application and you will see below screen.

A. Employee : Select the employee to be apply.

29
 Leave

B. Year : Year to apply.

You will see below screen once you click the Apply Leave button.

A. This area show the list of leave type which maintain in Maintain Leave Type. Click on any button.

B. Click the date in this area where the particular wanted to take.

C. You can change the Description and Number of day (i.e. From 1 to 0.5 for half day) in this Area.

Right Click at the Year Icon and you will see the below popup menu.

A. Open Leave Application : Open the Leave application for all employee.

B. Open Leave History : Open the past Leave application by Monthly

C. Leave Entitlement : Open the all employee Leave Entitlement List.

30
Leave

31
 Leave

6.3. Leave Maintenance

6.3.1. Maintain Calender

It maintain the different group of employee or state where their Rest Day or Public Holiday is different from
others. This useful in Leave Application

32
 Leave

A. Code : Code

B. Description : Full Description.

C. Active : Untick it if the Code is not use anymore.

D. Set as Default : If Clicked it will auto select the Code In the New Employee.

E. W, R & P button : It the Working Day, Rest Day & Public Holiday indicator. Click on of the button (E.g P
button) then select which day is the public holiday (e.g. 31 Aug 2007).

F. Annual Rest Days : This to set Rest Day in batch.

6.3.2. Maintain Leave Type

You may create New Leave type (E.g Study Leave) in here.

33
 Leave

A. Code : Code

B. Description : Full Description.

C. Caption : Caption to be shown in Leave Application.

D. Is Entitle : Is it with Limited Days?

E. Is Unpaid : Is under unpaid category?

F. B.Forward : Can it be Carried Forward to next year?

G. Style : Color Caption to be shown in Leave Application.

H. Active : Untick it if the Code is not use anymore.

I. Set as Default : If Clicked it will auto select the Code In the New Leave Group.

6.3.3. Maintain Leave Group

This to determine how each Leave type is calculated. The script calculation can be change in Maintain Script

34