Borang | 8a Perkeso Excel New

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?

Here’s a social media post (suitable for Facebook, LinkedIn, or Telegram groups) regarding Borang 8A PERKESO Excel format – focusing on the latest update.

📢 Attention Employers! New Update on PERKESO Borang 8A (Excel Format)

Are you still manually filling out the hardcopy Borang 8A – Laporan Bulanan Majikan?

PERKESO now encourages employers to use the latest Excel version of Borang 8A for smoother monthly contribution submissions.

✅ What is Borang 8A?
Monthly report of employees’ wages and SOCSO contributions (SIP & EI).

✅ What’s new in the Excel format?

Auto-calculation of contribution amounts
Built-in validation to reduce errors
Compatible with PERKESO’s ASSIST online system
Faster upload compared to manual key-in

✅ Where to download the latest Borang 8A Excel (2024/2025 version)?
👉 PERKESO official website → e-Contributions → Borang 8A (Excel Template)
👉 Or request from your nearest PERKESO office.

⚠️ Important:
Always use the latest version – old Excel templates may be rejected by the system.

📌 Submission deadline:
15th of every month (or next working day if falls on public holiday).

💡 Pro tip: Keep a master copy of Borang 8A Excel for each month. It helps during audit or salary revision claims.

Need help with the Excel formula or upload process? Drop your questions below! 👇 borang 8a perkeso excel new

#PERKESO #Borang8A #Socso #EmployerResponsibility #HRMalaysia #ExcelTemplate #MonthlyReporting

Borang 8A is the mandatory monthly report used by Malaysian employers to declare and remit SOCSO (Social Security Organization/PERKESO) contributions. While many large companies use payroll software like Your Payroll or Deskera People to automate this, smaller businesses often rely on Excel-based Borang 8A templates for manual tracking and direct uploads to the PERKESO ASSIST Portal. Core Requirements for Borang 8A

Under Malaysian statutory requirements, every employer must submit Borang 8A and complete payments by the 15th of the following month. The form must include specific employee details:

Employer Details: Employer Code (No. Kod Majikan) and registered business name.

Employee Information: Full name (as per NRIC), IC Number, and their SOCSO Reference Number.

Contribution Amounts: Calculated based on the employee's monthly salary under either Skim 1 (Employment Injury and Invalidity Scheme) or Skim 2 (Employment Injury Scheme only for older workers).

Employee Status: Codes for new employees (B), resigned (H), or deceased (M). Using the Borang 8A Excel Template

Many employers prefer the "new" Excel format because it allows for bulk data entry and can be converted or directly uploaded to avoid manual entry on the PERKESO website.

Download and Setup: You can find fillable templates on platforms like DocHub or view samples on Scribd.

Data Integrity: Ensure numerical fields for contributions do not touch the borders of the cells to maintain readability for automated systems. Submission Process: Log in to the ASSIST Portal. Navigate to Employer Contribution > Add Contribution.

Choose the upload option to submit your formatted file. The system will generate an ACR (Automated Contribution Receipt) which serves as the final billing for payment. Payment and Compliance

Payments can be settled via FPX (online banking), Direct Debit, or at authorized bank counters like Maybank and Public Bank. Employers must keep a physical or digital copy of the Borang 8A and the bank payment slip for their internal audit records. 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)

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? In the quiet, humdrum office of "Maju Jaya

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!

What is Borang 8A Perkeso?

Borang 8A Perkeso is a form used by the Social Security Organization (Perkeso) in Malaysia to report employee's salary and contribution information. The form is used to declare the employee's salary and contribution details to Perkeso.

What is the new Borang 8A Perkeso Excel format?

The new Borang 8A Perkeso Excel format is an updated version of the form that is designed to be filled out and submitted electronically. The new format is in Excel (.xlsx) format, making it easier for employers to fill out and submit the required information.

Benefits of using the new Borang 8A Perkeso Excel format

The new Borang 8A Perkeso Excel format offers several benefits, including:

Easier data entry and calculation
Automatic validation of data
Reduced errors and inconsistencies
Faster submission and processing time
Electronic storage and retrieval of data

How to fill out the new Borang 8A Perkeso Excel format

To fill out the new Borang 8A Perkeso Excel format, employers will need to provide the following information:

Employee's personal details (name, IC number, etc.)
Employee's salary and contribution details
Employer's details (company name, address, etc.)

The form will also require employers to declare that the information provided is true and accurate.

Tips for using the new Borang 8A Perkeso Excel format

Here are some tips for using the new Borang 8A Perkeso Excel format:

Make sure to download the latest version of the form from the Perkeso website
Use a compatible Excel software to open and edit the form
Fill out the form carefully and accurately to avoid errors
Use the built-in validation features to check for errors and inconsistencies
Submit the form electronically to Perkeso for faster processing

Conclusion

The new Borang 8A Perkeso Excel format is a convenient and efficient way for employers to report employee's salary and contribution information to Perkeso. By using the new format, employers can reduce errors and inconsistencies, and ensure that the information provided is accurate and up-to-date.

I hope this helps! Let me know if you need any further assistance or clarification.

Here is a basic template in excel format but please note you may need to adjust according to your needs and actual specifications

| Column A | Column B | Column C | Column D | | --- | --- | --- | --- | | Employee Name | IC Number | Salary | Contribution | | | | | |

Please let me know if you want me to add more details or want a more complex template.

Please also note, for Borang 8A, the template should follow the official format provided by Perkeso. For official use, you should download the template from official sources.

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 📢 Attention Employers

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

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

What is the "New Excel" Borang 8A?

The new Borang 8A Excel template is a macro-enabled workbook designed to simplify payroll processing. Unlike the old PDF or printed forms, this digital spreadsheet allows employers to:

Calculate contributions automatically based on wage brackets.
Validate employee identification numbers (MyKad) instantly.
Flag common data entry errors before submission.
Generate the exact file format required for online submission via ASSIST PERKESO.

2. Essential Excel Template Features

A solid Borang 8A Excel template (often called a Kalkulator Caruman) should include the following automated features:

A. Automated Contribution Calculation (The Core Feature) Instead of manually looking up rates, the Excel sheet should use formulas:

SOCSO Formula Logic:
- The sheet compares the employee's wages against the Jadual Caruman Pertama (First Category Schedule).
- Excel Implementation: Use VLOOKUP or INDEX/MATCH to pull the Employer and Employee share from a hidden "Data" tab containing the latest rates.
EIS Formula Logic:
- Formula: =IF(Wages>5000, 5000, Wages) * 0.002 (for employer share).
- Formula: =IF(Wages>5000, 5000, Wages) * 0.002 (for employee share).

B. Wage Cap Handling (RM 5,000 Limit) The feature must automatically cap the wages at RM 5,000.

Manual Error: Users often calculate contribution on a salary of RM 10,000.
Excel Fix: Use the MIN function: =MIN(Actual_Wage, 5000).

C. Age Category Filtering SOCSO contributions differ by age.

First Category: Below 60 years old (Employer + Employee pay).
Second Category: 60 years and above (Only Employer pays for Employment Injury).
Excel Feature: A column for "Date of Birth" that automatically flags the category and adjusts the contribution formula to zero out the employee share if they are over 60.

D. "Caruman Pekerja" vs "Caruman Majikan" Breakdown The Excel sheet must clearly separate columns for:

Caruman Pekerja (Employee Share): Deducted from salary.
Caruman Majikan (Employer Share): Company cost.
Jumlah Caruman (Total): The amount to be paid to PERKESO.

Summary Checklist

For a robust feature set, your Excel file must:

[ ] Cap wages at RM 5,000 automatically.
[ ] Calculate EIS at 0.2% + 0.2% automatically.
[ ] Use VLOOKUP for SOCSO sliding scale rates.
[ ] Exclude EIS for foreign workers.
[ ] Exclude Employee Share for workers aged 60+.

1. Guna Format Excel Lawas

Isu: Struktur lajur versi lama tidak sama dengan sistem e-Caruman 2025.
Penyelesaian: Sentiasa muat turun template baru setiap bulan.