Borang 8a Perkeso Excel New __exclusive__ -

Feature Breakdown: Borang 8A Excel Management

3. Kesalahan No. MyKad

Isu: Guna "-" atau ruang (cth: 800101-10-5432).
Penyelesaian: Masukkan No. KP tanpa sebarang aksara khas: 800101105432.

Key Features of the Latest Version

The new Excel format (typically version 3.0 or later) introduces several improvements over its predecessors:

  1. Dynamic Wage Table Integration: The sheet now auto-updates contribution rates (Class 1, 2, 3, etc.) based on the employee's monthly wages, removing the need for manual look-ups.
  2. Error-Checking Algorithms: Built-in conditional formatting highlights mismatched employee categories or incorrect contribution amounts in real time.
  3. Multi-Worksheet Structure:
    • Sheet 1: Employer information (registration no., name, month/year of contribution).
    • Sheet 2: Employee data grid (name, IC, wage, contribution breakdown).
    • Sheet 3: Summary of contributions (total employer/employee share).
  4. Bulk Upload Compatibility: The format is strictly aligned with PERKESO’s backend system, ensuring that a correctly filled Excel file can be uploaded directly without conversion errors.

How to Use the New Borang 8A Excel Template

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

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. Feature Breakdown: Borang 8A Excel Management 3

Step 4: Input Employee Data For each employee, provide:

  • Full name (as per IC)
  • MyKad number (without hyphens)
  • Monthly wages (including OT, commissions, etc.)
  • The Excel sheet will automatically populate the contribution tables (Categories A, B, C, D).

Step 5: Review the Summary Check the auto-calculated total for employer contribution, employee contribution, and the grand total payable. Dynamic Wage Table Integration: The sheet now auto-updates

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."

Panduan pengisian — langkah demi langkah (bersifat preskriptif)

  1. Sediakan maklumat majikan lengkap (ID, nama, alamat).
  2. Tentukan tempoh laporan (bulan/tahun) dan masukkan ke medan yang ditetapkan.
  3. Untuk setiap pekerja, masukkan No. Pengenalan, nama penuh, dan gaji bagi tempoh tersebut.
  4. Isi jumlah caruman yang ditolak daripada pekerja dan jumlah caruman majikan (ikut kadar semasa PERKESO).
  5. Semak jumlah keseluruhan caruman dan pastikan pengiraan sepadan dengan jumlah baris.
  6. Periksa medan wajib tiada kosong; betulkan format nombor dan tarikh.
  7. Simpan fail sebagai Excel (.xlsx) atau format yang diminta oleh sistem muat naik PERKESO.
  8. Muat naik melalui portal e-Perkeso atau hantar mengikut saluran yang diarahkan. Simpan salinan rujukan.

5. Official Excel Download Source

Instead of relying on third-party templates which may have outdated rates, use the official sources:

  1. PERKESO Official Portal: Look for "Buku Panduan Kerja" or "Jadual Caruman" downloadable in Excel format.
  2. LHDN/E-Filing: Often has calculators that can be repurposed.
  3. Mycalculator.my: A popular local resource for updated Excel tax and contribution calculators.

2. Tidak Kira Caruman untuk Elaun Tidak Tetap

Isu: Hanya masukkan gaji pokok.
Penyelesaian: PERKESO mewajibkan caruman atas keseluruhan upah termasuk OT, bonus, dan claim tetap.

7. Important Compliance Notes

  • Submission Deadline: Adjustments for previous months must be submitted within 12 months from the month of error. Late submissions incur penalties (1–4% of contribution amount per month).
  • Supporting Documents: Always attach proof of wage change (e.g., appointment letter, salary revision memo) or error evidence. PERKESO may audit adjustments.
  • Employee Consent: Inform affected employees in writing if the adjustment results in additional deduction from their future salary.
  • Record Keeping: Keep the submitted Excel file and acknowledgment receipt for at least 7 years for audit purposes.

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.