Borang 8a Perkeso Excel New //top\\ -

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. borang 8a perkeso excel new

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?

Cara mendapatkan templat Excel Borang 8A

  • Lawati portal rasmi PERKESO atau laman e-Perkeso untuk muat turun templat Excel dan arahan pengisian.
  • Hubungi pegawai PERKESO atau bahagian khidmat pelanggan untuk versi terkini atau bantuan teknikal. (Nota: saya tidak memautkan terus kepada sumber rasmi dalam jawapan ini.)

Keselamatan data

  • Simpan fail yang mengandungi maklumat pekerja di lokasi yang dilindungi (folder terenkripsi atau server selamat).
  • Hadkan akses kepada fail kepada pihak yang diberi kuasa.
  • Padam salinan sementara selepas muat naik jika tidak diperlukan untuk rekod.

1. Distinction: Borang 8A (SOCSO) vs. Borang 8A (New - EIS)

Before building or using an Excel template, you must distinguish between the two forms, as they are often managed in the same workbook but are distinct regulatory requirements.

| Feature | Borang 8A (SOCSO) | Borang 8A (New) - EIS | | :--- | :--- | :--- | | Purpose | Monthly contribution for injury & invalidity. | Monthly contribution for employment insurance (retrenchment benefits). | | Contribution Rate | Based on a specific contribution table (First Category). | Fixed at 0.4% (0.2% Employer + 0.2% Employee) of monthly wages. | | Excel Logic | Requires VLOOKUP against the official SOCSO Table. | Requires simple percentage formula (Wages * 0.002). | | Wage Ceiling | Maximum wage cap is RM5,000. | Maximum wage cap is RM5,000. |

Soalan Lazim (FAQ) – Borang 8A Perkeso Excel New

S1: Bolehkah saya guna Borang 8A Excel New untuk pembetulan caruman (Borang 8B)? Jawapan: Tidak. Untuk pembetulan, anda perlu menggunakan Borang 8B khas atau meminta bantuan kaunter PERKESO. In the quiet, humdrum office of "Maju Jaya

S2: Di mana saya boleh dapatkan template jika tiada internet di pejabat? Jawapan: Anda boleh minta salinan CD atau pendrive dari pejabat PERKESO cawangan terdekat. Tapi, disarankan guna portal rasmi.

S3: Kenapa jumlah di Ringkasan tidak sama dengan jumlah gaji saya? Jawapan: Mungkin kerana gaji sebahagian pekerja melebihi RM6,000. Borang new akan mengehadkan caruman pada siling RM6,000, bukan gaji sebenar.

S4: Apakah perbezaan antara Borang 8A Excel New dengan Borang 8A PDF? Jawapan: Excel New membolehkan pengiraan automatik dan muat naik terus ke sistem. PDF hanya untuk simpanan rekod atau serahan manual (yang kebanyakannya tidak digalakkan lagi).

Siapa yang perlu menggunakan Borang 8A (Excel)?

  • Majikan berdaftar dengan PERKESO yang perlu mengemukakan maklumat pekerja dan butiran caruman.
  • Penyedia perkhidmatan perakaunan atau payroll yang menghantar data bagi pihak majikan.
  • Organisasi yang memilih penghantaran data elektronik untuk memudahkan integrasi dengan sistem gaji.

Kesilapan biasa dan cara elakkan

  • Nombor pengenalan dimasukkan salah: salin daripada rekod rasmi; elakkan menambah ruang atau tanda baca.
  • Fail Excel tidak mengikut template: mulakan dengan templat rasmi, jangan ubah nama lajur.
  • Tarikh/gaji dalam format teks: tukar sel kepada format Tarikh atau Nombor/Perangkaan.
  • Jumlah tidak sepadan: gunakan formula Excel (SUM) dan semak dengan reconciliation report payroll.

Format Baharu Berbanding Format Lama: Apa Bezanya?

| Ciri | Format Lama (CSV/Manual) | Borang 8A Excel New | | :--- | :--- | :--- | | Pengiraan | Manual guna kalkulator | Automatik (formula) | | OverTime | Perlu dikira berasingan | Lajur khas "Elaun Tidak Tetap" | | EIS (Akta 1) | Boleh diabaikan | Wajib diisi (kecuali pekerja asing) | | Pengesahan Data | Tiada | Ya (sekatan input) | | Muat Naik e-Caruman | Tidak disokong | Ya (.xlsx) |

Langkah 4: Pengiraan Automatik di Sheet "Caruman"

Setelah data pekerja diisi, beralih ke sheet Caruman. Borang baru akan mengira empat komponen:

  1. Caruman Majikan Skim 1 (Bencana Pekerjaan): Cara mendapatkan templat Excel Borang 8A

    • Kadar: 0.25% x Gaji (max RM6,000)
    • (Untuk pekerja bergaji RM6,000 = RM15.00)

  2. Caruman Majikan Skim 2 (Rizab Pencen):

    • Kadar: 1.25% x Gaji (max RM6,000)
    • (Untuk gaji RM6,000 = RM75.00)

  3. Caruman Pekerja Skim 2:

    • Kadar: 0.5% x Gaji (max RM6,000)
    • (Untuk gaji RM6,000 = RM30.00)
    • Caruman Skim 1 adalah ditanggung sepenuhnya oleh majikan.

  4. Caruman EIS (SIP):

    • Majikan: 0.2% x Gaji (max RM6,000 = RM12.00)
    • Pekerja: 0.2% x Gaji (max RM6,000 = RM12.00)

Jadual Caruman Contoh (Borang 8A Excel New):

| Gaji Bulanan | Majikan Skim 1 | Majikan Skim 2 | Pekerja Skim 2 | Majikan EIS | Pekerja EIS | Jumlah Caruman | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | RM2,000 | RM5.00 | RM25.00 | RM10.00 | RM4.00 | RM4.00 | RM48.00 | | RM5,000 | RM12.50 | RM62.50 | RM25.00 | RM10.00 | RM10.00 | RM120.00 | | RM6,000 | RM15.00 | RM75.00 | RM30.00 | RM12.00 | RM12.00 | RM144.00 | | RM7,000 | RM15.00 | RM75.00 | RM30.00 | RM12.00 | RM12.00 | RM144.00 |

Nota: Untuk gaji > RM6,000, caruman menggunakan kadar maksimum RM6,000.