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.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
SQL Payroll 1.2023.243.197
Released on July 6, 2023
Release Notes
- Database upgrade to version 127
- Update mapping PostCode & State for PR.Tax.CP22-2021
- Fixed TA.Attendance1 & TA.Attendance2 not Scale to A4 side
- Lookup new entry form support access right approval
- Revise sync manager data to include only active employees
- #5903: Unable to capture Permit Expiry Date in report Employee Listing
- #5901: Employee tax category in payroll summary report differs from employee master tax category
- #5898: Revise existing LZS Zakat format to CSV format
- #5885: Add Access Right for Time Attendance in Sync Cloud
- Fix error prompt "Dataset not in edit or insert mode" when copy & paste time attendance location
- Revise Show Map marker in Sync Cloud
- #5893: Payroll accounting employee EPF, employee SOCSO, employer SOCSO, employee EIS, employer EIS and PCB support GL code by contribution
- #5886: Add income tax CP22A file format
- #5894: Access right "Print Payroll Summary - All" is not working
- #5892: Incorrect description when preview Work Unit Summary report
- Revise implementation of export PTPTN, CP8D, eData Praisi and Lampiran2
- #5888: By default, Rest Day is checked in Leave Application
- #5887: Alliance bank BizSmart Bulk Payment file format version 1.7
- #5889: Incorrect Commission Summary report data form caption
- #5880: Standard Chartered bank Bulk Payment format update
- #5876: Generate new script for Leave Entitlement Policy, Leave Calculate BF and Leave Calculate Amount when pasting Leave Group from clipboard
- #5884: The default HRDF rate for new company is 1%
- #5883: Add "Age 60 and above" to EIS category on Maintain Employee window
- #5870: Pending Overtime doesn't recalculate WorkUnit when Code is changed
SQL Payroll 1.2023.242.196
Released on June 9, 2023
Release Notes
- Database upgrade to version 126
- Add monthly tax deduction computerized calculation year 2023
- Fix bug: Incorrect monthly tax deduction amount calculated using the Knowledge Worker computerized calculator
- Add HomeScreen
- #5874: Add Postcode, city and state fields in Maintain Employee | Personal
- Update TP1 & TP3 2023 new format
- Fixed PR.SOCSO.Borang8A.Report Export to pdf Logo Black
- Set late in buffer and early out buffer to 0 when create new session
- Add Work Session and Work OT report
- Add OT Remark to Print Time Attendance Summary
- Fixed Time Attendance Summary report not in order
- Add new time attendance day type - Rest Day (Special Rate)
- Add Time Off Leave Type
- Add Script Name col in Sync Cloud OT and Leave tab
- Add Script column to TA_Trans table
- Add Batch Edit to Sync Cloud
- Add Time Attendance Transaction Listing Report
- Add Flexi Working Hour script
- Allow to choose custom script in Maintain Work OT
- 5875: Preview pending claim in pending payroll listing prompt conversion error
- #5872: Automation process for current year leave entitlement is not applied to newly created employee
- #5871: Delete employee prompt "Delete is not allowed" but no TMS trans posted to payroll
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
