Borang 8a Perkeso Excel New (FULL • HONEST REVIEW)
Related search term suggestions provided.
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
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!
In the quiet, humdrum office of "Maju Jaya Logistics," Ahmad was known as the Excel Whisperer
. While others saw spreadsheets as a maze of numbers, Ahmad saw them as a symphony. But even he felt a chill when the HR manager dropped the ultimate challenge on his desk: migrating the manual payroll to the new Borang 8A PERKESO format
The stakes were high. One wrong digit in an IC number or a misplaced decimal in the SOCSO or EIS contributions
, and the entire company’s compliance record would be in jeopardy. Ahmad didn't just want to fill out a form; he wanted to build a self-calculating masterpiece
He spent the night fueled by black coffee and the glow of his monitor. He mapped out the Schedule 1 contribution rates
, turning the rigid government tables into dynamic VLOOKUP formulas. He added Data Validation
to ensure no one accidentally entered a name where a salary should be.
By sunrise, the "Borang 8A Automator" was born. With a single click, the spreadsheet would: Scan the monthly wages. Calculate the exact Employee and Employer portions
Generate a clean, print-ready file that matched the PERKESO portal requirements perfectly.
When the HR manager saw the result—a process that used to take three days now took three minutes—she called it a miracle. Ahmad just smiled, adjusted his glasses, and whispered, "It’s not magic; it’s just a really good IF statement for the SOCSO contribution tiers or a to automate the data entry?
The Borang 8A PERKESO (SOCSO) is a mandatory monthly contribution form used by employers in Malaysia to report and remit social security payments for their employees. While PERKESO has transitioned to digital-first submissions via the PERKESO ASSIST Portal, the Borang 8A Excel format remains a critical tool for HR and payroll managers to organize data before bulk uploading it into the system. Latest Updates for 2026
Effective October 1, 2024, the wage ceiling for SOCSO contributions was increased from RM5,000 to RM6,000 per month. Additionally, a new Skim Lindung 24 Jam (24-Hour Protection Scheme) is set for phased implementation starting in June 2026, which will introduce additional contribution rates (0.75% for the first two years) to cover non-work-related incidents. 1. Key Features of the New Borang 8A Excel Format
Modern Excel templates for Borang 8A are designed to be compatible with the ASSIST Portal, allowing for a "Download/Upload" workflow that eliminates manual data entry.
Combined Contributions: The latest formats often combine SOCSO and EIS (Employment Insurance System) reporting into a single submission flow.
Status Indicators: The template includes columns for employee status codes, such as B (New Employee), H (Resigned), and T (Unpaid Leave).
Automatic Calculation: Advanced templates use the official Third Schedule (Act 4) tables to automatically calculate employer and employee shares based on the gross salary. 2. How to Use the Borang 8A Excel for Submissions borang 8a perkeso excel new
To successfully submit your monthly contributions, follow these steps using the data prepared in your Excel file:
Data Preparation: Ensure your Excel file contains accurate Employer Codes, IC Numbers, and Monthly Wages.
Generate Text File: Use your payroll software (like Deskera People or Your Payroll) to export the Excel data into a .TXT format.
Portal Upload: Log in to the ASSIST Portal, navigate to Contribution, and upload your .TXT file.
Verification: The system will generate an ACR (Arrears/Contribution Received) form. Review this against your Excel totals before making payment. 3. Submission Deadlines and Penalties
Deadline: Payments and Borang 8A submissions must be completed by the 15th of the following month.
Late Penalties: Overdue contributions incur an interest rate of 6% per annum for each day delayed, with a minimum fine of RM5. 4. Contribution Rates Summary (2026) Employer Share Employee Share First Category Employment Injury & Invalidity Second Category Employment Injury Only 0% (Pre-June 2026) EIS (Act 800) Unemployment Insurance
Note: PERKESO uses fixed contribution tables rather than exact percentages. Always refer to the official contribution schedule for exact amounts. Common Mistakes to Avoid Borang 8A - Perkeso
Slip Bayaran Bank dan salinan Borang 8A perlu disimpan oleh majikan bagi tujuan rekod. A. PANDUAN MENGISI BORANG 8A. 3.No. MyCoID. Pertubuhan Keselamatan Sosial (PERKESO) Rate of Contribution - Perkeso
Comprehensive Guide to Borang 8A PERKESO (Excel Format) 2026
Borang 8A is the mandatory monthly contribution schedule used by Malaysian employers to report and pay Social Security Organization (SOCSO) contributions for their employees. As of October 1, 2024 , PERKESO enforced a new wage ceiling of
, which must be reflected in all submissions moving forward. 1. Understanding Borang 8A
Borang 8A serves as a summary of monthly contributions, listing every employee, their identification details, and the specific contribution amounts for both the Employment Injury Scheme Invalidity Scheme Submission Deadline : Must be submitted and paid by the 15th of every month for the previous month's salary.
: Records accurate statutory compliance for SOCSO and the Employment Insurance System (EIS). 2. How to Use the Excel Format for Submission
Employers with multiple employees often use Excel to streamline data entry before uploading to the PERKESO ASSIST Portal Excel Layout : The standard format includes columns for: Employer Details : Employer code and name. Employee Information
: IC number, full name (as per IC), and employment start/end dates. Contribution Amounts
: Specific columns for the SOCSO and EIS share amounts based on the employee's salary bracket. Status Indicators : New employee. : Resigned/terminated. : Deceased. : Unpaid leave for the entire month. 3. Key Updates for 2024–2026 Borang 8A - Perkeso
Slip Bayaran Bank dan salinan Borang 8A perlu disimpan oleh majikan bagi tujuan rekod. A. PANDUAN MENGISI BORANG 8A. 3.No. MyCoID. Pertubuhan Keselamatan Sosial (PERKESO) Borang 8a perkeso excel: Fill out & sign online | DocHub
Introduction
Borang 8A Perkeso Excel is a form used by employers in Malaysia to notify the Social Security Organization (Perkeso) of any changes to an employee's salary or employment status. The form is used to update the employee's records and ensure that their social security contributions are calculated accurately.
What is Borang 8A Perkeso Excel?
Borang 8A Perkeso Excel is an electronic version of the traditional Borang 8A form, which was previously submitted manually to Perkeso. The Excel version of the form allows employers to easily edit and update the required information, making it more efficient and convenient to submit to Perkeso.
Who needs to submit Borang 8A Perkeso Excel?
All employers in Malaysia who have employees who are covered under the Employees Provident Fund (EPF) and Social Security Organization (Perkeso) schemes are required to submit Borang 8A Perkeso Excel to notify Perkeso of any changes to an employee's salary or employment status. This includes: Related search term suggestions provided
What are the benefits of submitting Borang 8A Perkeso Excel?
Submitting Borang 8A Perkeso Excel provides several benefits to employers and employees, including:
How to fill out Borang 8A Perkeso Excel?
To fill out Borang 8A Perkeso Excel, employers will need to provide the following information:
How to submit Borang 8A Perkeso Excel?
Once the form is completed, employers can submit it to Perkeso via the following methods:
Conclusion
In conclusion, Borang 8A Perkeso Excel is an important form that employers in Malaysia must submit to notify Perkeso of any changes to an employee's salary or employment status. The electronic version of the form provides a convenient and efficient way for employers to update employee records and ensure compliance with regulatory requirements. By submitting Borang 8A Perkeso Excel, employers can ensure that their employees' social security contributions are calculated accurately and that they comply with regulatory requirements.
The Borang 8A PERKESO is a mandatory monthly report used by employers in Malaysia to submit SOCSO (Social Security Organization) contributions for their employees. While a physical form exists, modern submissions are typically done via the PERKESO ASSIST Portal using specific data formats. Online Submission Formats
PERKESO has largely moved away from manual Excel submissions in favor of the ASSIST Portal, which uses two primary methods for reporting:
ACR (Arrears/Contribution Record): You can generate this directly within the ASSIST Portal by entering employee details online or selecting from a previously saved list.
TXT File Upload: Most payroll software (like Deskera or Your Payroll) generates a .txt file formatted specifically for the PERKESO system. This file contains all required contribution data and is uploaded to the portal to avoid manual data entry. Manual Reference & Templates
If you require a template for internal recording or manual filling:
Official PDF: The official blank Borang 8A PDF is available for reference on the PERKESO website.
Excel Formats: Some third-party sites like Scribd host user-uploaded Excel templates, but these should be used with caution to ensure they match current statutory rates and requirements. Key Deadlines and Data Required
Submission Deadline: Must be submitted and paid by the 15th of the following month (e.g., April contributions are due by May 15th). Employee Details Needed: Full Name (as per IC) IC Number / Social Security Number Contribution Amount (RM)
Status codes (e.g., 'B' for new employees, 'H' for resigned)
For the most secure and up-to-date submission, it is highly recommended to use the ASSIST Portal rather than manual Excel spreadsheets.
If you'd like, I can find a step-by-step guide for the ASSIST Portal or check if there's a free Excel template from a reputable payroll provider.
Borang 8A PERKESO (SOCSO Monthly Contribution) has evolved to support the ASSIST Portal
, which requires specific file formats for bulk uploading. While the manual Borang 8A PDF
still exists for counter payments, the "long feature" Excel format typically refers to the txt file structure
or combined contribution template used for online submission. Pertubuhan Keselamatan Sosial (PERKESO) Key Features of the New Format SSFW Integration : The updated format now captures the Social Security Foreign Worker Number (SSFW)
, allowing payroll admins to submit contributions for foreign employees alongside local staff. Wage Ceiling Update October 1, 2024 What are the benefits of submitting Borang 8A Perkeso Excel
, contributions are calculated based on a new wage ceiling of (increased from RM5,000). Combined Contribution : The current Text File Structure is designed to handle both
(Employment Insurance System) data in a single upload to the ASSIST portal. Pertubuhan Keselamatan Sosial (PERKESO) How to Get the Excel/Text Template
Instead of a standard "blank" Excel file, PERKESO utilizes a specific text file format for data consistency. You can manage this in two ways: Manual Template Preparation : Use the official Text File Structure (NEW)
provided by PERKESO to ensure your Excel columns match the required field lengths and data types (e.g., Employer Code, IC No, Name, and Salary). Payroll Software : Most Malaysian payroll systems (like Million Payroll PayrollPanda
) automatically generate the correct Borang 8A text file for you to upload directly to the portal. PayrollPanda Submission Checklist Borang 8A - Perkeso
Subject: Implementation and Usage Guide for the New Excel-Based PERKESO Form 8A
Date: [Insert Date]
Prepared by: [Your Name/Department]
Jangan muat turun dari sumber pihak ketiga. Hanya guna salinan rasmi dari:
Carian cepat: Taip "Borang 8A Perkeso Excel New" di laman web PERKESO. Pastikan tarikh kemas kini fail adalah dalam 12 bulan terkini.
Step 1: Download the Official Template Never use a homemade version. Always download the latest Borang 8A Excel file from the official PERKESO website (www.perkeso.gov.my) or directly from your ASSIST PERKESO dashboard.
Step 2: Enable Macros The Excel file contains Visual Basic for Applications (VBA) scripts for validation. When prompted, enable macros to unlock the form’s full functionality.
Step 3: Fill in Employer Details Enter your employer registration number, business name, and the contribution month/year. Do not modify the header cells – they are locked to prevent system rejection.
Step 4: Input Employee Data For each employee, provide:
Step 5: Review the Summary Check the auto-calculated total for employer contribution, employee contribution, and the grand total payable.
Step 6: Save and Upload
Save the file (keeping the .xls or .xlsm extension) and upload it through the ASSIST PERKESO portal under "Borang 8A Online."
Buka sheet Ketetapan Majikan. Isi:
Ramai majikan keliru di mana untuk mendapatkan versi terkini. Ikuti langkah ini:
Langkah 1: Layari portal rasmi PERKESO: https://www.perkeso.gov.my
Langkah 2: Klik menu "Perkhidmatan" > "e-Services" > "e-Caruman"
Langkah 3: Log masuk menggunakan ID Majikan dan kata laluan. (Jika belum daftar, perlu mendaftar di pejabat PERKESO berdekatan).
Langkah 4: Di dalam dashboard e-Caruman, pergi ke bahagian "Borang 8A" atau "Penyerahan Caruman".
Langkah 5: Klik butang "Muat Turun Template Terkini (Excel New)". Fail akan dinamakan: Borang8A_Versix.xlsx.
Peringatan Penting: Jangan muat turun borang ini dari sumber pihak ketiga (blog, Google Drive, Facebook) kerana format mungkin sudah lapuk atau mengandungi formula silap. Hanya guna yang dari portal PERKESO.
The Social Security Organization (PERKESO) in Malaysia has updated its administrative forms to streamline the processing of contribution adjustments. The latest version of Borang 8A (Borang Pindaan Caruman) – used to report changes in employees’ wages, correction of personal details, or adjustments for previous months’ contributions – is now available in a new Excel-based format.
Unlike the older static PDF or manual entry forms, this new Excel version includes built-in calculations and validation rules to reduce errors and ensure compliance with the Akta Keselamatan Sosial Pekerja 1969 and Akta Sistem Insurans Pekerjaan 2017.