SQL Payroll Handbook 3
SQL Payroll Handbook 3
2024
TABLE OF CONTENTS
Introduction Employee Perspective
3 4
SQL Payroll is compliant to all Malaysian
statutory bodies like KWSP, LHDN and SOCSO. Make salary payments via electronic
Our system saves you the trouble by auto submissions. More than 25 Malaysia banks
calculating EPF, SOCSO, EIS, HRDF and PCB including Maybank, Hong Leong Bank,
contribution. To ensure flawless calculations, CIMB Bank, Public Bank can be used to
our PCB calculator comes with the latest perform bank giro on SQL Payroll Malaysia
contributions rates. software.
1
PENDING PAYROLL TRANSACTIONS UNLIMITED MONTH END PROCESS
COMPREHENSIVE MANAGEMENT
REPORT FORM EA AND BORANG E, CP 8D
https://www.hasil.gov.my/media/jj0amwog/payroll-vendor-and-employer-2024.pdf
2
Comparison between Desktop Based & Cloud Based
SQL Payroll is a versatile payroll software that offers both desktop-based and cloud-based solutions to cater
to different client needs. Here is a breakdown of the options:
01 01
Automatic
Security Updates
Data is stored on the 02 02 Cloud versions often come
company’s servers, providing with automatic updates,
control over sensitive payroll ensuring that the software
information. is always up-to-date with
VS the latest features and
compliance requirements.
03 Desktop-Based Cloud-Based 03
Version Version
Customization
Often provides more
customizable features that can
04 04 Data Backup
be tailored to the specific needs Cloud solutions generally
of the organization. provide automatic data
backups, reducing the risk
of data loss.
Single-location Customization
Best suited for companies with Often provides more
a centralized workforce and customizable features that can
fewer remote operations needs. be tailored to the specific
needs of the organization.
By providing both options, SQL Payroll caters to a wide range of businesses, from those that need a more traditional, secure
desktop setup to those that benefit from the flexibility and accessibility of cloud-based solutions.
3
SQL E Leave / HRMS App
Transform your HR management with SQL HRMS Mobile App
Improved Workflow
Effortless Team Management
Identify potential issues and
Manage time attendance, enhance workflow planning
clock in/out, leave status,
expense claims, payslips, Real-Time Updates
and EA forms.
Stay informed with real-time
Comprehensive Overview attendance records and insights.
Modules:
4
E Time Attendance
Track own attendance and Track late in, early out, absent,
overtime pay rate and out of office employees
5
E Leave
6
E Claim
7
E Payroll
Just click Sync Cloud and you will be able to link all leaves that have been applied through the app into your SQL
Payroll Software. If your manager hasn’t approved the application, you can approve it on the software too.
Enhanced Accuracy
Time Savings
Data Visualization
Financial Overview
Tax Preparation
Performance Analysis
8
Employer
Perspective
Employer Perspective
To facilitate a successful configuration of your SQL Payroll system, please ensure that you have the following crucial
details prepared and accessible:
ADDRESS ATTENTION
Provide the complete address Enter the attention name of the in-
associated with your company charge person
9
Employer Perspective
Enter the Enter the TAX Fill in the SOCSO If the company is Enter the Officer’s
Employer's EPF details of the details of the HRDF registered and name, IC, job title,
details. It is crucial employer, and the employer. required to phone no. and
to ensure the most important part contribute, enter 1% email address, as
accuracy of the EPF is that the TAX The SOCSO Employer or 0.5%; otherwise, these are crucial for
Employer Number Employer No. Number is especially enter 0%. the EA Form
for EPF Borang A important
10
An Overview of employer’s responsibilities on
Except in limited
circumstances, EIS covers
Submit yours and your employee’s share of contribution
employees aged 18 to 60
who have their lost jobs.
11
Statutory Contributions Employer’s Responsibilities Link for Reference
As your company expands, managing statutory contributions for your employees can become cumbersome. It is important to choose a
payroll service provider to handle your employee’s EPF and SOSCO registration, salary disbursement, payroll taxes, and other statutory
contributions. With SQL Payroll, you can transform complex compliance tasks into a smooth, hassle-free experience, letting you focus on
what truly matters - growing your business.
12
e-PCB Plus will replace the current PCB system ((e-PCB/e-CP39/e-Data
PCB) by bringing everything together on the MyTax portal.
Phase 1 launches on September 24, 2024
Users must log in to the MyTax portal using their individual ID and
password, then select the appropriate role to access e-PCB Plus. For
more details, please refer to the User Guide on MyTax.
*Note: The current e-PCB system will continue to operate as normal until an official closure
announcement is made.
13
EPF sosco EIS PCB HRDF
14
What payments are included in EPF? What payments are included in SOSCO?
15
What payments are included in EIS? What payments are included in PCB?
16
What payments are included in HRDF?
Salary
FIxed Allowances
17
EMPLOYER PERSPECTIVE
Payroll Calculation
Here are specific payroll calculation formulas for monthly employees based on government rules.
Use these formulas as a reference :
2 Unpaid Leave/Absent
Deduction =
( Monthly Wages
In Conclusion :
The calculation formulas given are in accordance with the 2022 amendments to the Employment Act,
particularly the new section 18A.
These formulas are designed to ensure precise payroll calculations as per the latest regulations.
18
No. Type Formula
( )
Monthly Wages
3 Paid Leave Paid Leave = x Number of Days With
Number of Working Days Paid Leave
In Conclusion :
The calculation formulas are based on Section 60I of the Employment Act 1955. In this framework :
The “Ordinary Rate of Pay” is defined as the wages outlined in Section 2 of the Act.
For monthly employees, this rate should be divided by 26 days to determine the daily rate.
The “Hourly Rate of Pay” is calculated by dividing the ordinary rate of pay by the standard number od work hours
specified in the Act.
These definitions and methods ensure that payroll processing adheres to the standards set by the Employment Act 1955.
19
NOTE :
In the context of the provided calculation formulas, the
figures 8.0 or 7.5 represent the employee's normal work
hours.
20
SQL Payroll
Leave Entitlement Calculation
Examples of how to calculate annual leave using SQL queries
How many days of leave this employee will be entitled to How many days of leave this employee will be entitled to
for the remainder of 2024? for the remainder of 2024?
Pro-rated leave =
( Days worked in partial year
( )
Days Work in Partial Year = 15(jun) + 31(July)+ 31(Aug)+30(Sept)+31(Oct)+30(Nov)+31(Dec) = 199
365
Pro-rated leave = x 8 days
( )
365 199
Pro-rated leave = x 8 days
365
= 8 days
= 4.36 days
* This calculation assumes a 365-day year and does not account for leap years or other adjustments.
21
Payroll Calculation
OVERTIME RATE INFORMATION
This is an essential reference as it is defined in the Employment Act 1955, ensuring compliance
with legal standards for overtime pay.
22
Employer Perspective
SALARY PAYMENT DATE & PAYSLIP
NOTE :
For regular terminations,
employers are required to pay the
Timely salary payments are essential for employee's salary on the
employers, as mandated by the Employment termination date, ensuring
Act 1955, Part III, which governs the Payment compliance with legal standards
of Wages. This act stipulates that wages must for fair and prompt compensation.
be disbursed no later than the seventh day
after the end of the payroll period. Many
companies adhere to a payroll schedule that
aligns with the calendar month, typically
ensuring that salaries are paid by the 7th of
the subsequent month.
23
BENEFITS OF DISTRUBUTING PAYSLIPS
EMPLOYEE EMPLOYER
24
Monthly Government Report
DOCUMENT DESCRIPTION DEADLINE
Login e-Tris system through HRD Corp portal No later than the 15th day of the following
HRDF Form
and key in payment information month
*Take Note: SQL Payroll able to generate the txt file direct submit to kwsp/ though bank
25
Yearly Government Report
*Take Note: SQL Payroll able to generate the txt file to submit e-filling!
26
What is Benefits The Formula Method :
27
Prescribed Average Life Span (Years)
1 Motorcar 8
Entertainment:
Piano 20
4 Organ 10
TV, video recorder, CD/DVD player, stereo set 7
Swimming pool (detachable), sauna 15
5 Miscellaneous 5
28
Prescribed Value Of
Household Furnishing, Apparatus and Appliances
29
Prescribed Value Of Other Benefits
b) Bills:
i. Telephone is subscribed and paid by the employer
The benefit is taxed under paragraph 13(1)(b) of the ITA 1967.
a) Before the year The prescribed value is RM300 per telephone.
of assessment When the formula method is used, the value of the benefit is the
2008 actual cost of the private bills paid by the employer.
30
Prescribed Value Of Other Benefits
31
3 4
Dental Benefit Child-care benefit
I O N
P T
Discounted price for M
2 5
E
consumable business Insurance premiums
EX
products of the which are obligatory for
employer and foreign workers as a
TAX
discounted price for replacement to SOSCO
services provided by the contributions
employer
ON
Food and drink 1 K
BI 6 Free transportation
between pick-up
provided free of points or home and
charge place of work (to and
from)
32
(Value of Living Accommodation)
When an employer provides free housing to an employee, this is considered a taxable benefit. The value of
this benefit, which is the worth of the free housing, must be included in the employee's gross income for tax
purposes. This applies to any living accommodation provided in Malaysia, including housing in buildings
owned by the employer.
Category 1:
Living accommodation provided
for employee or service director Service Director represents director who is employed
in the service of the company in a managerial or
technical capacity and does not hold more than 5% of
the ordinary share capital of the company.
33
Category 2:
Living accommodation provided for
directors of controlled companies
Director includes:
a. A manager of the company
b. Remunerated out of the funds of that business
c. A beneficial owner of 20% or more of the ordinary share
capital of the company
Category 3:
Hostel living accommodation for
employee or service director Where the living accommodation provided for
employee or service director, is:
a. in a hotel, hostel or similar premises
b. any premises in plantation or in a forest
c. any premises which although in rateable area are not
subject to rates
34
Credit Bank
Report
Make salary payments via electronic
submissions. More than 25 Malaysia banks
including Maybank, Hong Leong Bank, CIMB
Bank, Public Bank can be used to perform
bank giro on SQL Payroll Malaysia software.
35
Employee
Perspective
Employee Perspective
EMERGENCY BANK
CONTACT ACCOUNT
INFORMATION DETAILS
PERSONAL
Name MARITAL STATUS AND Bank Name STATUTORY BODY
IDENTIFICATION Relationships
Contact details FAMILY INFORMATION Bank Account Number
INFORMATION Routing number MEMBERSHIP
Legal marital status
Full Name Spouse/ Dependent information:
NUMBERS
Birth of Date - Full Name Income tax number
NRIC/ Passport - NRIC EPF number
Work Permit - Employment status SOSCO number
Current Address - Health status EIS number
Contact Number - Number of tax deductible
Email Address person
36
Employee are encouraged to proactively gather and input essential employees’
details into SQL Payroll system. This proactive mesure guarantees precise and
compliant payroll management, optimizes worksflow efficiency, and migitates risks
related to missing or outdated data.
By taking these steps, employers can ensure smooth payroll operations and
prevent potential issues before they arise.
37
ONBOARDING TIPS FOR NEW JOINER
Access setup:
HR needs to ensure that all
necessary systems, software, and
accounts are set up and accessible.
1
Workspace preparation:
HR needs to ensure that all
necessary equipment or company
Employment Pre-start assets are prepared.
Documentation Preparation
2
3
HR ensures that offer letter and employment
contract outline compensation details,
including salary, pay frequency, and any Orientation session:
bonuses or benefits. HR conducts a structured orientation to Governmental
familiarize the new employee with company’s Requirements
HR prepares and sends necessary tax forms to culture, values, and procedures.
be completed by the new employee.
New employee shall submit TP3
Support and resources: Form to his/her employer to notify
HR sets up the new employee’s profile in HR ensures new employee knows where to find information relating to his
payroll system. additional resources such as HR contacts, employment with previous
internal knowledge bases, and training employer in the current year.
materials.
38
EPF - Employees Provident Fund Contribution
Malaysian 11 % 13 % 12 %
Below Age 60
Malaysian Age 60
0% 4%
and Above
Permanent Resident
5.5 % 6.5 % 6%
Age 60 and Above
Permanent Resident
11 % 13 % 12 %
Below Age 60
Non-Malaysian Age
5.5 % RM 5.00
60 and Above
Non-Malaysian
11 % RM 5.00
Below Age 60
39
SOSCO - Social Security Organization
As of October 1, 2024, the salary cap for SOSCO contributions has been increased from RM5,000 to RM6,000. The
contribution rates for the scheme are based on an employee’ monthly wages. An employee only contributes 0.5% of
their monthly salary, whereas an employer contributes 1.25% of the employee’s monthly wage.
https://perkeso.gov.my/en/our-services/employer-employee/kadar-caruman.html
40
EIS- Employment Insurance System
The contribution rate for Employment Insurance System (EIS) is 0.2% for the employer and 0.2% for employee based on the
employee’s monthly salary. To view the full contribution rate, may visit https://www.kwsp.gov.my/documents/d/guest/jadual-
ketiga-bi-pdf-1?preview
41
PCB - Potongan Cukai Bulanan (Income Tax)
No Tax If : Exceptions :
You spend 60 days or less in Malaysia
Your stay is a continuous period (≤ 60 days) overlapping two Non-resident directors of Malaysian companies
years Public entertainers
The continuous period (≤ 60 days) overlaps two years with
additional periods totaling ≤ 60 days
Tax Rate :
Residents: Non-Residents:
Graduated rates: 0% to 30% based on income Flat rate of 30%
Eligible for personal and familty tax reliefs No tax reliefs, available but exemptions on certain allowances
apply
42
PCB (Monthly Tax Deductions) :
Position of C Suite :
Taxed at the rate of 15% on income from employment with a company that has been granted a relocation tax incentive under the
PENJANA incentive.
43
HRDF - Human Resources Development Fund
1%
Malaysian 0% (Compulsory if have more than
10 Malaysian employees)
0.5%
(Optional if have 5-9 Malaysian
employees)
Non-Malaysian 0% 0.2 %
44
Leave Entitlement & Public Holiday
The Employment Act 1955 outlines mandatory leave types that employers must adhere to under
Malaysian law to prevent legal issues. Additionally, there are optional leave types that many
organizations provide to enhance employee well-being and satisfaction.
compulsory leave
1 rest day
Rest Day 1 rest day
(if work > 5 days, or <= 20 hours per week)
Hospitalization
60 days Not Entitled
Leave
45
Leave Entitlement & Public Holiday
Maternity
98 consecutive days Not Entitled
Leave
46
Leave Entitlement & Public Holiday
47
Working Hours
To classify employment as full-time or part-time, refer to the Employment Act 1955. The Act sets the
criteria for standard working hours, overtime, and entitlements, ensuring both employees and
employers adhere to legal standards.
Max 8 hours/day
<30 hours/week
Working Hours Max 45 hours/week
<70% full-time hours
Total daily work including breaks: max 10 hours
Break 30-min unpaid break after 5 hrs. 30-min unpaid break after 5 hrs.
48
Allowance Tax Exemption Rules
If an employee receives more Parking rate and parking Meal allowances for The tax exemption for child
than RM6000 a year for allowance. This includes overtime, outstation, or care allowances for children
petrol, travel, or toll expenses, parking rate paid by the overseas trips are only up to 12 years old is now
they can deduct the amount employer directly to the exempt if they follow the RM3000 per year, whether
spent on official duties. parking operator. rates specified in the received by the employee or
Records of these expenses employer's internal circular or paid directly to the child care
and deductions must be kept written instructions. center by the employer.
for 7 years for audit purposes.
Max Value: RM6,000 Max Value: No limit Max Value: No limit Max Value: RM3,000
49
Allowance Tax Exemption Rules
Gift of fixed line telephone, Monthly bills for subscription Perquisites given to an Subsidised interest for Educational loan of the
mobile phone, pager or of broadband, fixed line employee, such as past housing, education or car loan Perbadanan Tabung
Personal Digital Assistant telephone, mobile phone, achievement awards, service is fully exempted from tax if Pendidikan Tinggi Nasional
(PDA) registered in the name pager and PDA registered in excellence awards, innovation the total amount of loan taken (PTPTN) paid by an
of the employee or employer the name of employee or awards, productivity awards, in aggregate does not exceed employee who is a Malaysian
including cost of registration employer including cost of or long service awards, are RM300,000. citizen, works full-time and
and installation registration and installation considered taxable if the not his relative, from the
year of assessment 2019
employee has worked for the
until 2021
same employer for over 10
years.
Max Value: No limit Max Value: No limit Max Value: RM2,000 Max Value: No Limit Max Value: No Limit
With its user-friendly interface, real-time reporting, and integration capabilities, SQL Payroll ensures
accuracy and efficiency in managing employee compensation and statutory obligations. As you continue to
leverage this software, we encourage you to explore its full potential to enhance your payroll operations.
Thank you for choosing SQL Payroll as your trusted payroll management solution. We believe it will greatly
contribute to the success of your HR and payroll strategies, ensuring that your business stays compliant,
efficient, and forward-looking.
Disclaimer
The information provided in this guide is for general informational purposes only and may be subject to
change without prior notice. While every effort has been made to ensure the accuracy and completeness
of the content, users are encouraged to verify details and consult with professionals or relevant
authorities for the most current information. The software features described may vary depending on the
version and implementation.