Payroll Software Malaysia | Best HR & Leave Software | SQL Payroll HQ

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?
Enjoy speedy payroll processing and view each earning breakdown with an intuitive screen display
Edit payroll processes anytime anywhere with SQL Payroll software. Experience accurate, real time recalculations of statutory contributions.
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.
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
SQL Payroll software contains all necessary statutory report forms like EPF Borang A, SOCSO Borang 8A, PCB Income Tax CP39, and EIS Lampiran 1
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.
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
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.
Generate employee forms EA and employer form E and also perform e-submission with SQL Payroll software
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

Leave Management

What's unique?
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.
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.
Checking your leave application has never been easier! Effortlessly view your applications using our calendar mode
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 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?
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 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.
Have unlimited access when referring to your past records of EA forms for a seamless and smooth process of e-filing on LHDN.
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?
process adhoc payment interval such as bonus, commission, as separate payroll payment. These payouts are separated from the usual payroll process.
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.
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.
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.
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.
flexible data import / integration from any time attendance system in excel or csv format.
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.
Set Payroll frequency to process bi-monthly or even weekly salary. Our system will automatically proportion the salaries accordingly.
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.
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.
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.
Training

Featured Video

Send Inquiry
Try it for free!
Download brochure
SQL Payroll Handbook
NEW

Learn more about SQL Payroll

User Guide

Payroll User Guide

Learn how to use and master SQL Payroll with step-by-step guide
Read the guides

Help Video

Payroll Help Video

Watch & learn new SQL Payroll skills you can use today
Watch the videos

Release Notes

SQL Payroll Releases

Read all current and past software build releases
View all releases

SQL Payroll Releases

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

SQL Payroll 1.2024.256.205

Released on March 15, 2024
Release Notes
  • Fixed Export to PDF Leave Long Description Overlapping
  • Fixed PR.Tax.CP22A-2023 A5 & A11 wrongly map
  • #5999: Incorrect leave BF after process current year leave entitlement if last year leave application post date fall in current year
  • #6023: CP8D employee section text file is required even though content is empty
  • #6021: Leave.Entitlement.Processor.RoundToDay script return value with decimal place for employee has not completed one year of service
  • #5911: Application does not prompt message when leave application fall outside acceptable transaction date
  • #6001: Non resident PCB amount not tally with LHDN calculator
  • #6014: Generate income tax CP8D year 2022 text file prompt error "Access violation"

SQL Payroll 1.2024.254.204

Released on February 22, 2024
Release Notes
  • Add PR.Tax.CP22A-2023 format
  • Fixed EA 2023 & 2024 Typo Error
  • Fixed PR.Tax.CP8D-2023 only shown 1 page even data more then 9
  • Add PR.Tax.CP8D-2023-BorangE - Part A format
  • #6004: Add income tax CP22A year 2023
  • #6003: "Staff IC No" column in Public bank SOCSO excel format is not filled with foreign worker SOCSO number
  • #6006: Infinite loop in leave entitlement processor script
  • #6005: CP21 show record with commission for not resigned employee
  • Fixed PR.SOCSO.Borang2.Report-Foreign Moble number shown unknow info when not enter
  • #6011: Add MBSB Bank Journey Corporate Payroll file format
  • #6010: User can still view employee wages even though user doesn't have access right
  • Fixed PR.Tax.BorangEA-English version label not fully shown
  • Bug #6013: Income Tax CP8D 2023 Borang E Part A incorrect A2 value

SQL Payroll 1.2024.252.203

Released on January 31, 2024
Release Notes
  • Add PR.Tax.CP8D-2023 format
  • Update EA & EC for 2023 & 2024 to Pin 2023
  • #5996: Revise income tax CP8D year 2023
  • #5997: Rename "Maintain Public Holiday" to "Maintain Public Holiday Calendar"
  • #5956: Application does not prompt warning message when ADMIN user process month end payroll fall outside acceptable transaction date
  • #5968: Employee has not completed one year of service shall calculate AL entitlement based on number completed months service proportion
  • #5994: Income tax EA report shows an incorrect amount for tax exemption allowance
  • Change 2024 paysheet lhdn calculator to english
  • #5991: Update CP22A LHDN file format

SQL Payroll 1.2024.250.202

Released on January 10, 2024
Release Notes
  • Database upgrade to version 130
  • Update PR.Claim.Report field mapping
  • Add TP1 & TP3 for 2024
  • #5980: Get public holidays from web
  • Add payroll calculator year 2024
  • Add income tax EA and EC reports for year 2024
  • Optional Tax relief 2024 changes
  • Add payroll calculator year 2024
  • Add income tax CP8D year 2023
  • Add Classification, RetirementDate, ContractExpiryDate to Maintain Employee
  • Revise Time Attendance Work Schedule Processor TestCase
  • #5981: RHB Smart Payroll format unable to generate record when beneficiary bank is not RHB
  • #5978: Preview PR.Claim report prompt error "Field not found. Main."Amount""
  • Revise TMS process to get the calendar data up to current date time
  • Add RemarkIn and RemarkOut to time attendance summary report pipeline
  • #5976: EA form raise item not found error for employee with payroll opening but without payroll process
  • Fix Pending paid leave doesn't display leave day with full decimal when editing leave day column

SQL Payroll 1.2023.249.201

Released on December 29, 2023
Release Notes
  • #5975: Add email for UOB IBG file format with payment advice
  • #5973: Tax exempted allowance calculated wrongly when more than 1 allowance with same tax code
  • #5969: Add Alliance Bank BizSmart Zakat file format
  • #5972: RHB Smart Payroll format does not support Rentas bank code
  • #5941: MC leave type Process script default to "Based on calendar year, no proportion, round to 1 decimal"
  • #5971: Claim transaction project different from pending claim transaction project after process payroll
  • #5970: Add Pending Director Fee, Bonus, Paid Leave, Compensation, Advance Paid, Loan, CP38, Unpaid Leave data import from command line

SQL Payroll 1.2023.248.200

Released on December 13, 2023
Release Notes
  • Add PR.Zakat-Sarawak format
  • Add Time Attendance Summary Report with Location Status & Photo
  • Time Attendance Summary Report - Add Attachments & LocationStatus to pipeline
  • #5955: Add Merchantrade Top Up file format
  • #5953: Stores instruction file output directory in DB registry
  • #5965: Leave entitlement recalculation clear last year entitlement
  • #5964: Update UOB Instant Transfer file format v2.3
  • #5960: Add China Construction Bank Malaysia IBG file format
  • #5958: Unable to reconfigure leave group entitlement policy if the script is missing

SQL Payroll 1.2023.247.199

Released on October 27, 2023
Release Notes
  • Added Effective Date under Section ii (Action Taken) page 2 in HR.Employee.Confirmation Evaluation Form
  • Add PR.Zakat-Perlis format
  • Add Prorate Info for LV.Yearly.Report
  • Database upgrade to version 129
  • #5950: Clone Master Data required to clone over Maintain Work Session
  • Sync Cloud Time Attendance filter resigned employees
  • Work Schedule Summary - Add PH and Rest label for Public Holiday and Rest Day
  • Time Attendance Summary - Default checked On Time and Append script name to Clock Status
  • Add new time attendance day type - Rest Day (Special Rate 2) & Rest Day (Special Rate 3)
  • Sync Cloud Leave and Claim unchecked Rejected by default
  • #5946 & #5947: Time Attendance Summary - Add TotalWork, TotalOT, TotalBreakTime, TotalLateIn, TotalEarlyOut for the day
  • #5795: Leave application report Main dataset added "Time in Minute" field
  • #5921: Tax calculation sensitive to year and month
  • Add Tax exemption calculator
  • Add Tax relief calculator
  • #5954: Income tax CP21 report B-3 column does not include commission amount
  • #5952: Unable to generate loan schedule based on loan balance amount
  • #5949: Add Age field to Main Dataset of Employee report
  • Optimize performance for Sync Cloud TMS
  • #5945: Add payment advice if have email for AffinMax Corporate IBG excel file format
  • #5936: Remove leave day limitation when claim leave on the same day in Leave Application

SQL Payroll 1.2023.246.198

Released on August 16, 2023
Release Notes
  • Database upgrade to version 128
  • Add PR.SOCSO.Borang2.Report-Foreign format
  • Change Pipeline from Country to Nationality for PR.Tax.CP22-2021
  • Add Grand Total for PT.Claim.Report
  • Show Payment Type Description for Parameter PayType instead of number when selected 1 PayType for Payroll summary report
  • Add PR.Zakat-Sabah format
  • Update mapping City for PR.Tax.CP22-2021
  • #5916: Increase Passport, ImmigrationNo and PermitNo field length to 40 characters
  • #5904: Add "Send ELeave Email Notification" in Company Profile | E HRMS
  • Add EmailNotif_ELeave column to SY_PROFILE table
  • Fix unable to fill in missing clock in and revise time attendance date range filter
  • Redesign Work Schedule Summary and Rename to Print Work Schedule Summary
  • Display the day of the week in Maintain Calendar, Maintain Public Holiday and Maintain Traveller Location
  • Add label to show ETMS last update date
  • Add PIType and PICode support for TMS Leave Script
  • Rename Print Time Attendance Transaction Listing to Print Time Attendance Unassigned Listing
  • Disable inserting and deleting on sync Time Attendance grid
  • #5897 & #5925: Public Holiday setting removed after user edit employee details
  • #5912: Maintain Public Holiday Calendar - W change to C
  • Change action to "Cancelled" if deductible is 0
  • Add IsOT column to Leave tab in Sync Cloud and support IsOT in Leave Rules script
  • Add IsOT column to TA_TRANS table
  • Add schedule option in Maintain Calendar wizard for Rest Day
  • #5933: Hong Leong bank Connect First IRB file format Country Code column is empty and Staff No column contains non-alphanumeric characters
  • #5932: Leave Attendance report detail record decimal place not same as grand total
  • #5929: Add Nationality dataset to Payroll and Employee reports
  • #5906: Add time mask popupedit for time in minute entry
  • #5923: Maintain employee service year show in years and months
  • #5924: UOB EPF file format version 2.3
  • #5919: Some CP22A, CP22B and CP21 fields does not exclude tax exempted amount
  • #5819: Add Bank of China IGTB Payroll file format
  • Fix sync cloud WorkingHourPerDay value type from integer to TBcd for leaveday calculation
  • #5920: Add Attendance Reward column to employee browse window
  • #5915: Leave entitlement that is manually entered become 0 when recalculate
  • #5918: Allowance Reward script aTransDS dataset added TransDate, WorkUnit, TimeInMinute and Rate field
  • #5917: Delete tax benefit in maintain employee prompt out of bounds error

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info