Download our free salary calculator software that includes PCB Schedule, EPF/SOCSO Calculator and EIS Calculator. This software uses the same salary calculation engine as our commercial Actpay payroll system. Verify your calculations using this free software before generating your monthly payroll. Save your regular calculations for faster payroll verification. Export to excel to do further calculations and reports.
Note : LHDN does not provide a PCB Schedule (TABLE OF MONTHLY TAX DEDUCTIONS) anymore. The SCHEDULE OF MONTHLY TAX DEDUCTIONS has been replaced by E-CP39 that provides the same results. E-CP39 tax is based on monthly income. Computerised and Online LHDN PCB Calculator are based on Year to Date income.
Actpay Free Salary Calculator Basic Functions and Features
No user registration is required to use this salary calculator software. Just download zip file and unzip. No database drivers, no complicated installation. Just unzip and run. All data is stored in an Excel file.
Actpay Salary Calculator Download Files
Download Actpay Free Salary Calculator
There are only 2 files. All the saved salary information is stored in actpayfree.xls. You can open this file to view the details. If you need to delete some of the staff information, you have to delete the rows in this file. In the software, you can add but cannot delete rows.
If you need to do other calculations or reports, please make a copy of Acptayfree.xls and edit as needed. Try not to edit the ActpayFree.xls directly. Make copies of the file and make changes as needed.
How to use Actpay Salary Calculator
This Free Salary Calculator is very easy to use. Just Click Edit and enter the information you want. If you just want to calculate for a single amount just enter the total in Basic Salary. This will calculate EPF, SOCSO, EIS and PCB for that amount.
For a blank screen, Click Add.
To Start Click Add to get an empty screen. Input basic staff information and Save. Staff information is optional and not needed for calculations. Enter staff information if you want to use the Excel file to do your payroll.
Enter the values want and click “Calc Salary” to calculate. Click “Save” to save the information to the Excel File.
All staff fields are optional, but staff number, name and IC are useful for reporting. IC and other information can be saved in the excel file to create your own payslips.
Marital Status, No. of Children and EPF rate will be set to default values if not entered. You can edit and change these parameters if required.
The values used for calculation are :
- Basic Pay
- Benefit in Kind
3 Flexible Allowance fields are provided.
Each Allowance has 8 options.
- EPF + SOCSO + PCB
- EPF + PCB
- EPF + SOCSO
- PCB + SOCSO
- EPF (Only)
- SOCSO (Only)
- PCB (Only)
For example if you want to calculate PCB only, choose 8. Choose 3 for EPF. SOCSO Calculator. You can use different settings for different staff. The allowance amount and description will be saved in the Excel file. You can view the details using the Browse function.
*Please note that if you choose SOCSO it will also include EIS.
Sample Payslip Calculation
|Service Charge / Tips||300|
Payslip Calculation Explanation.
Total Income subject to EPF = Basic + Bonus + Commission = 5,000+5,000+1,000 = 11,000
Traveling Allowance is not subject to EPF and SOCSO. Also no PCB for up to RM6000 per year.
SOCSO and EIS Calculations
Total Income subject to SOCSO and EIS = Basic + Commission + Service Charge / Tips = 5,000+1,000+300 = 6,300
Note that Bonus is not subject to SOCSO
Total Income (excluding Bonus) subject to PCB = Basic + Commission + Service Charge / Tips = 5,000+1,000+300-333.33 = 5,966.67
Note : Minus 333.33 is based on 4,000 PCB Exemption for EPF per year. Per month = 4,000 / 12 = 333.33
PCB for Bonus is calculated as Additional Remuneration using a different formula. You can find the Bonus PCB amount by calculating the same values without Bonus and calculate the difference.
Please note that PCB calculations are based on e-CP39 and not e-PCB
This screen allows you to view all the staff information you have saved. All this data is stored in an Excel File, “actpayfree.xls”
Note the Allowance information, Allowance 1, 2 and 3.
Details on EPF, SOCSO, EIS and PCB Calculations can be found here.
Note the Bonus PCB of 551.56 and PCB Deduction of 792.10. Total PCB for the month is 792.10 and the PCB portion for the Bonus is 551.56. This information can be used when Bonus is paid separately before the monthly payslip.
This software is designed to provide basic and accurate calculations for EPF, SOCSO, EIS and PCB. There is sufficient functionality provide all the calculations to produce a payslip. But, the salary calculator is limited to basic calculations and does not have advanced features needed for more complex payroll calculations and reporting. For more advanced features and flexibility please take a look at our Actpay payroll software pricing information. This also includes details reports and upload files for EPF, SOCSO and PCB as well as EA Form.
We look forward to your questions and suggestions.
Please Login and Comment below for Support.