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

SQL Payroll Handbook

NEW

Learn more about SQL Payroll

SQL Payroll Releases

SQL Payroll 1.2025.274.220

Released on April 26, 2025

Release Notes

Database upgrade to version 140
Add "Process Bonus" access right
Add PITypes column to PT_INFO table
Fix server raise "Duplicate entry..." error when sync paysheet
Fix server raise "Duplicate entry..." error when sync leave entitlement
Allow user to set announcement period
Add DateTo column to HR_ANNCMNT table
#5967: Add OT tier up to 5 levels in Work OT
Add new leave type when create new sample database
Add OT4, OT5 to TA_OT_DTL
Delete Public Holiday record if that year doesn't have any Work Day records
Fix Possible having less than 365 / 366 calendar dates when copying work schedule
Fix Unable to fix TMS log due to different calendar date
Revise rollback if error occurs when posting to time attendance tables
Fix Reminder to generate calendar date still prompt even before October
Add PR.Tax.CP8D-2024-English format
Fixed export to excel total shown white color for PR.Summary.Grouped-L1.Report 1
#6166: Saving paysheet changes prompt error "is not a valid boolean value"
#6163: Alert if nationality is MY and New IC is empty
#6164: Maybank Universal Payment EIS file format footer record "Total Employer Contribution Amount" column value is incorrect
Fix Employee age and service year are not refresh after reset payroll
#6162: CIMB ePayroll Payment / Bulk Payment file format missing some bank codes
#6157: Win64 - Change and save employee master record wage prompt error "Access Violation"

SQL Payroll 1.2025.273.219

Released on March 1, 2025

Release Notes

Print PCB year 2025
Add checking for Join & Resign Date for EA & EC format
Fix Saving a pending optional tax relief record with code "TD.7001" prompt error "Code (TD.7001) not found"

SQL Payroll 1.2025.272.218

Released on February 18, 2025

Release Notes

Database upgrade to version 139
Update income tax EA and EC form
#6120: Auto update City and State after input PostCode
Auto update City and State after input PostCode
Add Country to HR_EMP table
Increase SMTP_URI field length to 500
Revise MI_ENTITLEMENT table
Update PR.Tax.CP8D-2024 Note
Add paysheet OPF year 2025
Revise commit dd952162: Close paysheet prompt error "Cannot focused a disabled or invisible window"
#6148: Auto-fill benefit-in-kind description in income tax EA form
#6147: Submit Maybank Universal Payment Zakat file to bank return error "Address 1 is mandatory" if payment indicator is equal to 01 in header record
Revise commit 28a3855f: Reminder to generate Calendar Date prompted for non TMS user
#6152: PCB amount is incorrect if employee paysheet deduction record type is changed to zakat
#6149: AffinMax EPF excel format "Contribution Month and Year" column value is invalid
Add i-bizRakyat Salary Payment, LHDN, SOCSO, EIS excel formats
Add income tax CP8D report for year 2024
Prompt confirmation message in Maintain Employee if wage is entered below 1700

SQL Payroll 1.2025.271.217

Released on February 5, 2025

Release Notes

Database upgrade to version 138
#6142: Fix UBS Payroll import to raise exception if detect invalid or out of range date value
#6144: Add TransDate to PR.Cloud.Claim datamap
Fix Reminder to generate Calendar Date prompted for non TMS user
Fix Some data processors access rights are not functional
Fix "Pending Payroll Listing - Gratuity" access right is missing

SQL Payroll 1.2025.270.216

Released on January 17, 2025

Release Notes

Add payroll calculator 2025
Add income tax EA and EC reports for year 2025
Add TP1 and TP3 reports for year 2025
#6140: Add "Edit Statutory Contribution Amount" access right
Fix Recalculate leave entitlement prompt error "Invalid argument to date encode"
#6138: Maybank Universal Payment Zakat format missing Payment Indicator option
#6121: Add Access Right for Time Attendance
Fix Duplicate Key error when Sync Time Attendance for same Employee with same AdjTransDate
Add Reminder to generate Work Session for next year in Sync Cloud
Add leave entitlement processor reminder on after login
#6136: The rate of pending wage record is not filled with the employee wage rate if the code of pending wage record is changed
Fix Paysheet contribution amount is incorrect if the Esc key is pressed after editing
#6135: Add Leave Passage tax exemption

SQL Payroll 1.2024.269.215

Released on December 19, 2024

Release Notes

#6134: Revise DB metadata to include O_TA_LOG_PAIR and O_TA_SUMMARY
Revise Work OT sample data to include MinOT
Revise DB upgrade version 122 to insert Work OT using INSERT query to fix possible 'Invalid class typecast' error
Revise DB upgrade version 136. Run Boolean script convert in main thread to prevent random exception
#6133: Submit RHB CP39 text file to bank return error "Country code is mandatory if passport no. is entered" when there is an employee record with NewIC and Passport entered
Database upgrade to version 137
Revise TMS Status field to boolean
Add IsClaimLeave field to TA_Log_Pair and O_TA_Log_Pair
#6130: Sync cloud leave balance not tally with leave balance report
Rollback if error occurs when posting to time attendance tables
Revise Cloud.TimeAttendance.fm to exclude inactive and resign employee in total employee count
#6131: Submit Interbank Giro file to UOB return error

SQL Payroll 1.2024.267.214

Released on December 3, 2024

Release Notes

#5588: Convert Boolean field to actual Boolean Type
Database upgrade to version 136
#6112: The Employment Act 1955 reduce maximum weekly working hours from 48 to 45 for Peninsular Malaysia and Labuan, with effect from 1 January 2023
Rename other income form grid column caption
#6127: Repeating the pasting of paysheet detail records, then deleting them, results in an incorrect gross pay
#5812: Income tax EA form does not exclude employee record where none of the remuneration contribute to PCB, PCB (A) or EA for the year
Fix Payment voucher missing companyname field
#6122: Submit CP22A text file to IRBM return error "No Telefon Majikan Wajib Diisi"
#6119: OTContribDS dataset does not contain pending payroll items for current process

SQL Payroll 1.2024.266.213

Released on October 29, 2024

Release Notes

Database upgrade to version 135
Bug #6113: Submit Maybank2E RC Universal Payment file to bank return error "Favorite Beneficiary/Biller Code is mandatory"
Add Giro column to HR_EMP table
#6101: Add Rate field to Maintain Wages
Add Rate column to HR_WA table
Fixed PR.Tax.CP22A-2023 format employee email not shown
Update PR.Coinage.Report by add 20 column
Fix Sync Cloud Time Attendance grid export to spreadsheet unable to show Clock Status
Add WorkStart and WorkEnd to Time Attendance Summary Report
Fix Sync Cloud Edit Log that may cause duplicate InKey or OutKey
#6024: Rename employee classification options
#6116: Payroll summary shows empty result if filtered by payment type of the payroll process
#6115: Display color and status for Grid Export in Excel file from Sync Cloud
#6114: Generate payment voucher including e-Invoice fields
#6105: Coinage report added currency note 20
#6104: Month end payroll overtime pay rate is incorrect calculated if pending allowance is processed first in Ad Hoc
#6111: Submit AmAccess Biz salary file to bank return error "Zakat Tab - Zakat Employer Reference Number is required"
Revise TimeAttendance.Map to exclude records which coordinates is 0 when show route
Fix Sync Cloud Time Attendance OT tab unable to edit if license is unregistered or expired
Fix Income tax report when printed or saved to file is not based on grid view filtered records
#6106: Bank of China file format incorrect beneficiary bank name

SQL Payroll 1.2024.265.212

Released on October 2, 2024

Release Notes

#6102: SOCSO new wage ceiling increase to 6000 effective on 1 Oct 2024
#6099: UOB Interbank Giro and Inter Account Fund Transfer file format should contain all records in one file, regardless of IBG or internal fund transfer
#6103: Submit Maybank2E-RC Universal Payment file to bank portal return error if payment mode is Duitnow Transfer
#6097: Fix Maintain Announcement window unable to resize

SQL Payroll 1.2024.264.211

Released on September 26, 2024

Release Notes

Database upgrade to version 134
#6094: Hong Leong Bank Connect First bank file format missing some routing code
Sync Cloud add duplicate record checking and data transfer for TA_LOG_PAIR and TA_SUMMARY
Add TA_LOG_PAIR & TA_SUMMARY unique indexes and set NOT NULL to TransDate of TA_LOG_PAIR
Add HR Announcement
Sync Announcement in Sync Cloud
Add HR Announcement UI
Add HR Announcement
Add HR_ANNCMNT table
Include Gratuity and Employement Loss of Compensation to paysheet when Sync Cloud
#6093: Net pay is incorrect on employee payroll if adjustment is not equal to zero
#6092: Employee listing grid column values become empty after using "Add to Payroll"
#6072: Bank of China IGBT Payroll file format version 1.7

SQL Payroll 1.2024.262.210

Released on August 30, 2024

Release Notes

#6089: Payroll yearly reports missing access rights
#6087: Update CP22 LHDN file format
#6062: Add payment method option before process payroll

SQL Payroll 1.2024.261.209

Released on August 14, 2024

Release Notes

Add PR.Tax.CP21-2023.fr3 format
Add leave entitlement processor "< 1 Year - Based on completed months of service proportion" script.
Add Late In Buffer and Early Out Buffer column to Maintain Calendar
#6074: Update CP22A and CP22B LHDN file format
Fix Print Time Attendance Summary fr3 unable to show attachments
#6071: Unable to upload CP22 due to wrong Gender info
Fix bug: Ad hoc payroll calculated PCB additional differs from PCB additional calculated by IRBM calculator

SQL Payroll 1.2024.260.208

Released on July 13, 2024

Release Notes

Database upgrade to version 133
#6059: Add Attendance Reward for non TMS user
Add AttendanceReward column to HR_EMP table
#6058: Employee payroll support taxable other income
Add pending taxable other income
Optimize Time Attendance Summary report form performance
Update day Type for TA.Attendance reports
Add PT_OI table
Add HRDF Info for Yearly Individual Report
Fixed TA.Attendance1.Report report DayType not correctly shown
Add PR.Tax.CP22B-2023 format, Remove PR.Tax.CP22B-2015 format & update PR.Tax.CP22B-2021 format
#6068: Add Yearly EPF, Yearly SOCSO and Yearly EIS reports
Add PostDate index to pending transaction tables
Total tax benefit and total tax deduction are not updated if press Esc key
#6064: Add Income Tax CP22 text file format
#6048: Prompt confirmation message in Maintain Employee if wage is entered below 1500
#6067: Foreign workers contribute to SOCSO First Category with effect from 1 July 2024
#6065: Maybank2E-RC Universal Payment file format support Duitnow Transfer payment mode
#6063: Add HRDF amount to Yearly Individual report
#6061: AmAccess Biz Payroll SOCSO file format IC number column is not filled with SOCSO number for foreign worker
Update RowVer for HR_BRANCH, PR_CL, LV_ENTITLE, LV_GROUP_DTL. LV_TYPE, TA_CALENDAR, TA_OT to fix cannot show special characters for Code and Description field
#6060: Compensation and Gratuity month end calculation error if calculated pcb in adhoc
#6057: After process month end, able to edit earlier process in the same month for an employee
#6056: Hong leong bank connect first giro file format missing bank codes
#6055: Add Affin Bank AffinMax Statutory Excel format
Database upgrade to version 131 prompt "string truncation" error when execute procedure APPEND_PT_TRANS if source column contains unicode characters
#6051: Print Time Attendance Summary Photo capture different from Sync Cloud
#6050: MBSB Journey Corporate Payroll file format incorrect bank codes
Disable inserting and deleting on Maintain Traveller Location grid
#6049: Am-Access Biz Payroll file format missing columns I & J for non resident
#6044: UOB IBG with payment advice file format missing payment currency for some employee
Set MgrAutoApproval to false when create new employee
Fixed PR.Summary.Grouped-L3.Report 2 export to excel Bonus amount not shown

SQL Payroll 1.2024.259.207

Released on April 30, 2024

Release Notes

Database upgrade to 132
#5625: Cloud pending claim window added "Trans Date" grid column
#6042: CP8D employer section file is still created even the "Include Employer's Particular" option is checked
#6041: HSBC bank EIS file format has an incorrect filename
Add MgrAutoApproval to HR_EMP
Fixed PR.Zakat-Penang & Sarawak Format report some data not correctly shown
Add Country parameter to TCreateDatabase constructor
#6038: Exempted compensation and gratuity should not add in EA form column F and EC form column E
#6037: MBSB Journey Corporate unable to capture Recipient Reference and Other Payment Details

SQL Payroll 1.2024.257.206

Released on April 1, 2024

Release Notes

Database upgrade to 131
Add HR.HistoryListing report
Add Gratuity for PR.Payslip Report with V2 format
Add Gratuity column PR.Summary.Grouped Report
Add Transaction Code for PR.Yearly reports
PR.SOCSO.Borang2.Report-Foreign Add passport validity and permit starting date
#5642: Add support gratuity
Add PT_GR table; add DOB column to PT_INFO
Add Code column to PT_CP table
Fixed Lampiran 2 report not showing total compensation
#6008: Add PassportIssueDate, ImmigrationIssueDate, PermitIssueDate to Maintain Employee
#6034: Add GX Bank to employee bank lookup
#6033: e-AmPayDay net payroll socso file format IC number column is not filled with SOCSO number for foreign worker
#6032: Add "Include Employer's Particular" option to income tax CP8D and eData Praisi windows
#6028: Income tax CP8D report exclude employee record with gross remuneration equal to zero
#6027: Payroll yearly individual report rearrange employee eis position
#6026: Empty child DOB error message is unclear
Revise Sync Cloud DateTime format to follow system format
Revise Time Attendance show map marker icons
#5989: Add day name to Print Time Attendance Summary
Revise Print Work Schedule Summary to exclude resigned and inactive employees
#6000: Print Time Attendance Summary error when untick few status
Revise Time Attendance Summary report to show logs without session
Add DayType field to Time Attendance Leave Rule scripts
Fix override note field and post employee userkey to PT_CL_LOG when update status in Sync Cloud Pending Claim

We are the Number 1 accounting software in South East Asia use by more than 270,000 companies!