SQL Payroll

Payroll Malaysia – Process. Review. Print. It’s simplicity at it’s best

What's unique? SQL Payroll software is built from ground up around Payroll Process. You can easily process and print from one to hundreds of employee's pay slip with just a few mouse click. What's more is that you can virtually keep unlimited payroll history and have your data safe and sound with strong security and data protection.

SQL Payroll is so simple! Discover how you can go from payroll processing to printing pay slips in just a few steps.

SQL Payroll Feature

Sync Across All Devices

Everything you need to make your business grow super fast!

Monthly payroll process

What's unique?

Quick and Easy monthly payroll processing

Enjoy speedy payroll processing and view each earning breakdown with an intuitive screen display

Flexible amendment

Edit payroll processes anytime anywhere with SQL Payroll software. Experience accurate, real time recalculations of statutory contributions.

Compliant to all local legislation

SQL Payroll is compliant to all Malaysian statutory bodies like KWSP, LHDN and SOCSO. Our system saves you the trouble by auto calculating EPF, SOCSO, EIS, HRDF and PCB contribution. To ensure flawless calculations, our PCB calculator comes with the latest contributions rates.

Batch email payslip individually with password encryption

Send individual payslips by batch with the batch email feature. Every e-mail sent comes with a password encryption to ensure utmost privacy and security

Statutory reports with e-submission

SQL Payroll software contains all necessary statutory report forms like EPF Borang A, SOCSO Borang 8A, PCB Income Tax CP39, and EIS Lampiran 1

Bank Giro electronic payment - more than 25 Malaysia banks

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.

Pending payroll transactions

Enter overtime, claims, allowances, bonus, leaves, tax benefits, and other deductions in advance and incorporate it later on into the final payroll for that particular month

Unlimited month end process

Process multiple month ends by groups. You can process separate month end for different groups of employees. Eg, you can process the salaries for the sales group on the 25th of every month and the other groups on the end of every month.

Form EA and Borang E CP8D

Generate employee forms EA and employer form E and also perform e-submission with SQL Payroll software

Comprehensive management report

Our wide variety of customizable reports and payslips allow you to create the ideal report that truly represents your corporate identity and business nature.

Need a report?
SQL Payroll software provides payslips, payroll summary, credit bank report, cheque listing, contribution info listing, and HRDF report

Need a government report?
We provide government reports like: EPF Borang A, Socso Borang 8A, Socso Borang 2, Socso Borang 3, EIS Lampiran 1, EIS Borang 1, EIS Borang 2, Income Tax CP 39, Income Tax CP 39 A, CP 22, CP 22 A, CP 8, CP 159, e-Data Praisi, Lampiran B (PCB Audit), Zakat Borang Skim Berkat, PCB 2, CP 8D (Borang E).

Leave Management

What's unique?

Unlimited leave type

SQL Payroll HR software lets you manage multiple leave types for your employees. Including annual leave, unpaid leave, and medical leave. Create more leave types based on your business needs like compassionate leave, study leave and others.

Leave Group entitlement

By using leave group entitlement. You can set the number of leaves a group of employees are entitled to. You can create a group for managerial group, sales group, and contract worker group.

Leave calendar application

Checking your leave application has never been easier! Effortlessly view your applications using our calendar mode

Flexible unpaid leave formula

SQL Payroll software design with simplified interface, you can set your unpaid leave formula as easy by select the numbers of calendar method (labour law compliance) as well as by custom days setting example 26 days.
Set your own unpaid leave formulas by selecting the day of unpaid leave taken on the calendar (compliant with labour law) and the customizable number of days.

Annual Leave brought forward

Annual leave can be brought forward to the next year. All you have to do is set the maximum number of days and the system will do the rest.

Need a leave report?
SQL Payroll HR software consists of a complete and comprehensive set of leave reports such as leave application report, leave balance report, leave entitlement report, and yearly leave report.

Any unused annual can be carried forward to next year, you can even set maximum days of carried forward.

SQL E Leave - payroll app apply leave anytime, anywhere

What's unique?

Employee dashboard

say goodbye to printing leave application forms. apply your leave with SQL E Leave mobile app anytime, anywhere. Enjoy the freedom of checking your leave status on your mobile and receive notification alert when your leave has been approved.

View unlimited month payslip info in your app

View your past payslips from an unlimited number of months on the e-leave app. you can check your salary details like wages, allowance, deduction, epf, socso and many more.

Unlimited years form EA record

Have unlimited access when referring to your past records of EA forms for a seamless and smooth process of e-filing on LHDN.

Manager Dashboard

Check leave pending approval, apply leave on behalf of your employees, and check daily attendance all on your mobile phone! Leave application and leave balance reports can also be generated

Others useful function

What's unique?

Adhoc process

process adhoc payment interval such as bonus, commission, as separate payroll payment. These payouts are separated from the usual payroll process.

Comprehensive HR software package

SQL Payroll HR software comes with appointment letter, confirmation letter, increment letter, assessment letter, termination letter and other letter formats that are necessary in any HR management system.

SQL View - limit access to payroll process

limit your employees access and process payroll by designated grouping. For example, manager level salaries can only process by HR manager. Regular HR staff only can view executive level salaries.

Loan

Manage employee loans with SQL Payroll software. SQL Payroll will auto deduct the loan from your wages based on the loan repayment rate and repayment period that you set. You can check your loan repayment history for reference.

Income Tax calculator

SQL Payroll automatically calculates all necessary tax contribution for you. But you can always use our Income Tax calculator to double examine payroll entries that you recorded.

Data import

flexible data import / integration from any time attendance system in excel or csv format.

Unlimited year records

unlimited year payroll records can be store in SQL payroll, reprint previous EA Form or view previous year payroll information from any year. Especially useful when you are called for a PCB audit.

Frequency process

Set Payroll frequency to process bi-monthly or even weekly salary. Our system will automatically proportion the salaries accordingly.

All government report ready

SQL Payroll software ready with all malaysia government report EPF Borang A, SOCSO Borang 2, SOCSO Borang 3, SOCSO Borang 8A, EIS Borang 1, EIS Borang 1A, EIS Borang 2, EIS Borang 2A, EIS Lampiran 1, Income Tax CP39, CP39A, Income Tax CP 39A, Income Tax CP 22, Income Tax EA Form, Income Tax EC Form, Income Tax CP 8, CP 159, Income Tax e Data Praisi, Income Tax CP 8D Borang E, Income Tax Lampiran B (PCB Audit) Income Tax Lampiran 2 (PCB Audit), Income Tax PCB 2(II), Zakat Borang Skim Berkat, HRDF Report.

Mykad reading

Instead of manually keying in an employee’s information, use a mykad reader to retrieve all the necessary information that is needed by every employer and populate the employee master form within seconds.

Time management system

SQL Payroll can be integrated seamlessly with most time attendance systems. Sql Payroll calculates OT, Leaves, and allowances without any mistakes and minimal external interference.

Unlimited monthly free payroll software training and responsive support team

No worries if you are unfamiliar with our system! We provide free payroll software training every month. Contact us to find out more! Our technical support team is fully trained and equipped to assist you via phone, email, and remote access.

Featured Video

Send Inquiry

Try it for free!

Download brochure

Learn more about SQL Payroll

SQL Payroll Releases

SQL Payroll 1.2023.241.195

Released on May 22, 2023

Release Notes

Fixed PR.Tax.CP22-2021 Logo black when export to pdf
#5852: Preview payroll summary report doesn't follow grid column visibility
Bank Muamalat Payroll file format missing some bank codes
Database upgrade to version 125
Fixed black box when export to pdf for PR.Tax.CP22A-2021
Revise Show Map form in Sync Cloud
Add EarlyOutBuffer column to TA_SESSION and TA_CALENDAR table
Revise Show Log form in Sync Cloud
Fixed cannot run OT script for public holiday and rest day
Remove icon from menu for Work Schedule Summary
Add Post Date column to OT tab and Leave Tab in Sync Cloud
Add PostDate column to TA_TRANS table
Revise old Maintain Calendar to Maintain Public Holiday
Fix Work Unit Summary report return incomplete resultset

SQL Payroll 1.2023.239.194

Released on May 8, 2023

Release Notes

Database upgrade to version 124
#5843: Time in minute for wages should refer to employee maintain contribution working hour per day
Fixed PR.Tax.Lampiran B not Min Remuneration not follow user set
Fixed HR.Employee.Appointment Signature & date missing
Revise Pending Payroll Listing report
Add History Listing report
Add Permit No and Expiry Date for Permit, Immigration and Passport
#5866: Update Maybank2E-RC Universal Payment IRB file format based on version 7.2
#1249 & #1624: Add Permit No and Expiry Date for Permit, Immigration and Passport
Add PassportExpiryDate, ImmigrationExpiryDate, PermitNo, PermitExpiryDate columns to HR_EMP table
Add Time Attendance Multi-Location & Map View
Add Clear All Schedule and Location option when select multi employees
Allow delete records for TA_Calendar, TA_Summary, TA_Location in EMS if clear all records in local db
Feature #5832: Show map on GPS Range column in Sync Cloud
Feature #5833: Add Maintain Traveller Location entry form
Allow to show log from OT and Leave tab in Sync Cloud
#5865: Disable site photo if found drive is "Off"
Fix error prompt "RowIndex out of range" in Maintain Calendar
#5850: Fix unable to delete employee if employee have existing Time Attendance records
By default no rest days are selected for calendar wizard
Work Summary Summary remove grey background on today's date
#5860: Fixed prompt 'At end of table' in Maintain Calendar
TimeInMinute field is missing from PT.Overtime datamap
Fix Work Unit Summary report access right does not work
#5858: Append an overtime record to employee payroll prompt assertion error if a borne allowance record contributes to overtime.
#5857: Payroll Summary report filter by Payment Type prompt "Conversion error from string" error
#5856: Payroll summary no data display when filter with category
Fixed slow calendar drop down when editing TMS clock in and clock out time

SQL Payroll 1.2023.238.193

Released on April 18, 2023

Release Notes

#5848: Payroll summary dataset sort order doesn't match with sort order in grid table view when preview report
#5847: Payroll Summary report prompt "PISeq (AD) not found" error
#5424: Employer SOCSO number can only have up to 12 characters
Database upgrade to version 123
Add PR.Yearly.IndividualPay.Report-NoAD format
Replace pdf to jpg for PR.Tax.CP21-2021
Fixed PR.Tax.CP22B-2021 Tax number not correctly shown
#5781: Work Unit Summary support grouping
Adjust statutory body window caption
#5844: Paste record from excel into payroll detail dataset prompt "D_Wages: Dataset not in edit or insert mode" error
#5842: Time attendance log missing clock by default follow actual date
#5837: Allow user to set work session on current day
#5840: e-AmBiz Bulk Payment file format missing some bank codes
Feature #5841: Add UOB EIS file format
#5839: Pending unpaid leave record "Time in Minute" field is null if the record created via leave application
#5830: Reposition the Process button on Process Payroll window
Fixed missing OT records in Sync Cloud
Fixed Sync Time Attendance could not parse SQL TimeStamp string error
Add total late in, total early out, clock status and location status variable to Leave Rule script
Remove Maintain Calendar from Leave Menu
Maintain Branch set default radius to 60 meters
Map window allow to maximize in Maintain Branch
Rename ELeave tab to E HRSM in Company Profile and Maintain Employee
#5831: Allow to edit previous dates without session to rest day and public holiday
Remove Batch Edit and multiselect, Disable employee column sorting and branch column editing, Add cancel button, Set default work session text to 'To Assign'
Revise GPS Location label to GPS Monitoring (Work Hour) in Maintain Work Session and Maintain Calendar and revise variable name
Fix folder share being deleted on disable SQL Drive
#5835: Change HRDF contribution in paysheet does not recalculate HRDF
Fix Main menu invalid command ID for Import Data
#5811: Leave application table view show "Time in Minute" column
#5828: CP8D text format should merge records when the "New IC" or "Old IC" or "Passport No" are the same
#5823: Data entry form supports OnBeforeSave DIY event
#5822: Maintain Employee window shows Age and Service Year
#5827: Add Traveller, Manager Approval, Manager Review and Leave Malaysia column to Maintain Employee
Fixed Sync Cloud unable to load claim trans
#5824: Leave application attachments drop down prompt error "No mapping for the Unicode character"
#5821: OCBC bank Easi-Giro file format missing number of bank codes
#5836: Add "Require ID Check" option to OCBC bank Easi-Giro file format

SQL Payroll 1.2023.236.192

Released on March 18, 2023

Release Notes

Change EA & EC 2022 & 2023 to norm customise design format
#5816: Maintain Loan browse window unable to filter by Employee Name
#5817: CP8D 2022 column U contains decimals
#5818: Some reports still shown to user that does not have access right
Database upgrade to version 122
#5813: Add Religion field to income tax Lampiran 2 report Main dataset
Add Religion column to HR_EMP table
Add Online Approval for access right
Add remote approval message to access rights
SY_User add Mobile, Email & OpenID_Google fields. SY_Profile add Country field
Add Time Attendance module
Add support Attendance Reward
Add AttendanceReward column to HR_EMP table
Add validation when process payroll of there are error records
Add Time Attendance Summary Report
Add Time Attendance to Sync Cloud
Add Work Schedule Wizard, Work Schedule Summary and Redesign Calendar
Maintain Employee entry form add Work OT and IsTraveller field
Add GeoCoordinate input in Maintain Branch and GoogleMapsAPIKey input in Company Profile & sync GeoLat, GeoLong, Radius data
Add GeoLat, GeoLong & Radius column to HR_BRANCH and GoogleMapsAPIKey column to SY_PROFILE
Add TA Session, TA Calendar, TA Trans, TA Summary and TA OT
Add TA_CALENDAR, TA_SESSION, TA_LOG_PAIR, TA_SUMMARY, TA_TRANS, TA_OT_DTL, TA_OT table
Conversion of TimeInMinute to WorkUnit/LeaveDay and vice versa
Add TimeInMinute column to PT_WA, PT_AL, PT_OT, PT_CO, PT_DE, PT_PL, PT_UL, LV_APP table
#5815: CP8D filename contains leading zeros for employer tax number
Feature #5814: Add pending allowance and leave application for Invotime import data
#5810: Month end process tax amount is incorrect when ad hoc process compensation doesn't calculate tax

SQL Payroll 1.2023.234.191

Released on February 28, 2023

Release Notes

Fixed PR.Tax.CP8D-2022 Total not correctly shown when more then 3 pages
Remove Word Wrap option for Company Information for EA & EC 2022 & 2023
5743 : Fixed PR.Tax.CP22-2021 extra line on export to pdf
Fixed HR.Employee.Report-PCB.TP1-2023 page 3 not correct format
Remove Checking EPF code for PR.EPF.BorangA.2009.Report
Database upgrade to version 121
Feature #5801: Increase BankAccNo field length to 30 characters
#5793: Rename "Compensation" to "Employment Loss Compensation"
#5806: Zakat deducted from gross income when tick contribute to EA
#5807: E-Data praisi filename contains leading zeros for employer tax number
#5804: Sync EAForm detail and report not updated for year 2022
#5803: LampiranB employee socso amount include employee eis amount
#5799: Calculate EPF, SOCSO, EIS and Tax when paysheet field is changed
#5800: Incorrect employee EPF amount if select EPF option "Without balancing"
#5798: Pending unpaid leave "Leave Day As Time" doesn't follow maintain contribution "Working Hour Per Day" after reopen
Feature #5778: Add workunit in yearly individual report
#5792: Process missing employee that exists in payroll process newer than current payroll process is allowed