Borang 8a Perkeso Excel New !!install!! -
Use the official PERKESO contribution rate tables, based on an employee's monthly salary up to RM 4,000 (from 2024). Remember to deduct RM 5.00 for the Employment Insurance System (EIS) from the employee's share where applicable.
The standard updated Borang 8A Excel template is structured systematically to allow the ASSIST system to convert columns into a valid text file (.txt) or accept the spreadsheet directly. The key columns you will find include: 1. Header Information
The shift began with a 2003 directive requiring employers to use new digital formats. By 2018, PERKESO no longer issued physical forms, fully endorsing electronic submission for efficiency.
Managing payroll in Malaysia requires strict adherence to statutory obligations. Among these, the Social Security Organisation (PERKESO/SOCSO) contributions are critical. For employers managing payroll manually or looking for a seamless way to upload bulk employee data to the PERKESO ASSIST portal, the template is an indispensable tool. borang 8a perkeso excel new
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.
: Input the employer registration number, contribution month/year, and individual employee amounts. Automated Export payroll software
An effective Borang 8A Excel spreadsheet relies on automated lookups rather than manual entry. The spreadsheet should be split into three core worksheets: the , the Statutory Rate Table , and the Automated Borang 8A Form . 1. The Statutory Rate Table (Reference Sheet) Use the official PERKESO contribution rate tables, based
Collect the monthly payroll for all employees, including their basic salary, allowances, commissions, and any other remuneration subject to SOCSO.
Choose the upload option to submit your formatted file. The system will generate an which serves as the final billing for payment. Payment and Compliance
The 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 The key columns you will find include: 1
PERKESO contributions do not use a flat percentage across all income levels; instead, they utilize a localized bracket system up to a salary ceiling of RM5,000 per month.
| | Tindakan | Penerangan / Perkara Penting | | :--- | :--- | :--- | | 1 | Sediakan Data Pekerja | Gunakan Microsoft Excel untuk menyenaraikan semua pekerja yang aktif pada bulan berkenaan. Pastikan semua maklumat berikut disediakan dalam lajur berasingan. | | 2 | Tetapkan Format Lajur | - Nombor PERKESO (A) - Nama Pekerja (B) - No. Kad Pengenalan (C) - Tarikh Mula / Berhenti Kerja (D) - Jumlah Caruman Majikan (E) - Jumlah Caruman Pekerja (F) | Pastikan format untuk setiap lajur ini adalah betul untuk mengelakkan ralat semasa penukaran ke .txt. | | 3 | Semak Format Data | - Tarikh : Format ddmmyyyy (cth: 01022025 untuk 1 Februari 2025) - Nombor : Gunakan format nombor tanpa sebarang simbol seperti , atau RM . | Sebarang kesilapan dalam format ini akan menyebabkan fail yang dijana ditolak oleh sistem PERKESO. | | 4 | Gunakan Formula Excel | Gunakan formula untuk mengira jumlah caruman secara automatik berdasarkan kadar caruman PERKESO terkini. Contohnya: =SUM(E2:F2) untuk jumlah keseluruhan setiap pekerja. | Ini meminimumkan risiko kesilapan pengiraan manual dan menjimatkan masa. | | 5 | Jana Fail Teks (.txt) | Salin keseluruhan data pekerja ke dalam Notepad atau terus guna formula Excel untuk eksport dalam format teks biasa. | Pastikan setiap baris data pekerja dipisahkan dengan baris baru. |
In recent years, PERKESO has introduced a new format for the Borang 8A, which can be completed and submitted using Microsoft Excel. The new format aims to simplify the reporting process and reduce errors. The Borang 8A PERKESO Excel new format is available on the PERKESO website and can be downloaded by employers.
The Employment Insurance System (EIS) is calculated using a dedicated rate table capped at a salary of RM5,000. Both the employer and employee contribute an equal share of 0.2% based on the statutory wage tier. How to Upload Your Excel File to the PERKESO ASSIST Portal