, turning the rigid government tables into dynamic VLOOKUP formulas. He added Data Validation
The official template can be downloaded from:
Always check these details before uploading to the ASSIST Portal. borang 8a perkeso excel new
Excel often drops leading zeros or alters long numbers into scientific notation (e.g., 9.00101E+11 ). To prevent this: Highlight your IC/Passport and Employer Code columns. Right-click, select , and choose Text . Type or paste the numbers carefully. Step 3: Populate Wages and Calculate Contributions
Artikel ini dikemas kini pada Januari 2026. Untuk sebarang perubahan dasar, sila rujuk portal rasmi PERKESO atau hubungi 1-300-88-9595. , turning the rigid government tables into dynamic
A smart Excel spreadsheet avoids manual errors by utilizing locked VLOOKUP paths or conditional lookup statements aligned with the official PERKESO Contribution Schedule. Understanding the Contribution Categories
Create a tab named Rates and paste the latest SOCSO Contribution Table. To prevent this: Highlight your IC/Passport and Employer
Instead of relying on third-party templates which may have outdated rates, use the official sources:
Managing monthly statutory contributions is a core responsibility for every HR professional and business owner in Malaysia. Among these mandates, stands out as the crucial monthly statement used by employers to declare and pay Social Security Organization ( PERKESO / SOCSO ) contributions.
: Modern payroll tools like Deskera or Your Payroll automatically generate the Borang 8A as a .txt or .csv file, which is the "new" standard for direct upload to the ASSIST portal, eliminating manual entry. Important Reminders Borang 8A - Perkeso
This matrix forms the bulk of the Excel template. Each row signifies an individual employee and must feature these exact data columns: Column Header Notes & Rules Sequential list tracking total headcount. IC / Passport Number Alphanumeric