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.
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
Learn more about SQL Payroll
Payroll User Guide
Learn how to use and master SQL Payroll with step-by-step guideRead the guides
Payroll Help Video
Watch & learn new SQL Payroll skills you can use today
Watch the videos
SQL Payroll Releases
Read all current and past software build releases
View all releases
SQL Payroll Releases
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
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
