Isu: Hanya masukkan gaji pokok.
Penyelesaian: PERKESO mewajibkan caruman atas keseluruhan upah termasuk OT, bonus, dan claim tetap.
Isu: Struktur lajur versi lama tidak sama dengan sistem e-Caruman 2025.
Penyelesaian: Sentiasa muat turun template baru setiap bulan.
The new Excel-based Borang 8A PERKESO represents a significant improvement in accuracy, speed, and user-friendliness for Malaysian employers. By adopting this digital format, HR and payroll departments can reduce rejection rates, ensure timely contribution adjustments, and maintain full compliance with PERKESO regulations.
For further assistance: Contact PERKESO Care Centre at 1-300-22-8000 or visit your nearest PERKESO office. The official user manual for Borang 8A Excel is also available for download from the ASSIST portal.
Prepared by:
[Your Name]
[Position, e.g., HR Manager / Payroll Lead]
[Company Stamp & Date] borang 8a perkeso excel new
To prepare a proper Borang 8A (PERKESO) in Excel format, you must follow the specific layout required by the Social Security Organisation (SOCSO) of Malaysia. This form is used for the monthly submission of employee contributions. 📋 Essential Header Information At the top of your Excel sheet, include these fields: Employer Code: (e.g., A1100000000X) Employer Name: Your registered company name Month/Year: (e.g., 05 / 2024) Employer Address: Official business address 📊 Column Headers for Data Entry
Set up your spreadsheet with the following columns from left to right: (Sequence number) (12 digits, no dashes) Employee Name (As per MyKad) Contribution Category (Code 1 or 2) Salary (RM) (Gross monthly wages) Employer Share (RM) (Part 1 - SOCSO) Employee Share (RM) (Part 2 - SOCSO) Employer Share (EIS) (Part 3 - Employment Insurance System) Employee Share (EIS) (Part 4 - Employment Insurance System) Total (RM) (Sum of all 4 contribution parts) 💡 Formatting Tips for PERKESO No Symbols:
Do not include "RM" inside the cells; use number formatting. Two Decimals: Ensure all currency columns are set to two decimal places. No Dashes: IC numbers should be clean (e.g., 900101145566 Contribution Codes: Employment Injury & Invalidity (Employees under 60).
Employment Injury only (Employees over 60 or first-time joiners over 55). 📥 Sample Row Structure 950101105544 AHMAD BIN ALI 🚀 Pro-Tip: Use ASSIST Portal Isu: Hanya masukkan gaji pokok
While many use Excel for internal tracking, PERKESO now encourages the ASSIST Portal file directly from your Excel data.
This avoids manual data entry and reduces calculation errors. The system automatically generates the ACR (Automated Contribution Receipt)
To help you get the numbers exactly right, would you like me to: Provide the latest 2024 contribution tables for different salary brackets?
you can copy-paste into Excel to calculate these shares automatically? Explain the difference between SOCSO Category 1 and Category 2 Let me know which part of the payroll calculation you're stuck on! Prepared by: [Your Name] [Position, e
Isu: Guna "-" atau ruang (cth: 800101-10-5432).
Penyelesaian: Masukkan No. KP tanpa sebarang aksara khas: 800101105432.
| Problem | Solution | |---------|----------| | Excel file won’t open / macros disabled | Change Excel security settings to enable macros. Use PERKESO’s recommended Excel version (2016 or later). | | IC number shows as invalid | Remove dashes and spaces. Use 12 digits for Malaysian IC, or passport no. format for foreigners. | | Wage amount not auto-calculating | Ensure you selected the correct month/year. Check that “Previous Wage” and “New Wage” are numeric values. | | Upload fails on ASSIST | Check file size (<5MB). Rename file without special characters. Try clearing browser cache or using a different browser. | | Row limit reached | For more than 100 adjustments, split into multiple Excel files or use PERKESO’s bulk upload API (for large employers). |
Ini adalah bahagian paling kritikal. Setiap baris mewakili seorang pekerja.
| Column | Data yang Diperlukan | Format / Rujukan |
| :--- | :--- | :--- |
| A | No. KP Pekerja (Baru) | 12 digit tanpa tanda sempang. |
| B | Nama Pekerja | Seperti dalam MyKad. |
| C | No. Keselamatan Sosial (No. Ahli) | 10 digit. PERKESO akan mengesahkannya. Jika baru, kosongkan. |
| D | Bulan Mula Caruman (YYYY-MM) | Contoh: 2026-01 untuk januari. |
| E | Taraf Warganegara | WN (Warganegara) / BWN (Bukan Warganegara). |
| F | Gaji Bulanan (RM) | Jumlah kasar sebelum potongan (max RM6,000 untuk caruman). |
Tips Pro: Jika gaji pekerja melebihi RM6,000, sistem akan menganggap RM6,000 sebagai nilai untuk pengiraan caruman. Ini sudah diprogramkan dalam formula borang baru.