TemplatesType: Spreadsheet/Log8 min readUpdated May 2026By Julian Vance

Payroll Template Malaysia EXCEL

Having a well-structured payroll template malaysia excel is the single most important step you can take to ensure financial health, tracking metrics, and auditing processes. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive Payroll Template Malaysia EXCEL template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.

What is a Payroll Template Malaysia EXCEL?

A payroll template malaysia excel is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the finance-accounting domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as a secure PDF, allowing for immediate implementation.

Spreadsheet/Log Preview

Template Registry

Standard Operating Procedure

Registry ID: TR-PAYROLL-

Malaysian Payroll Management System: Production Architecture & Specification

1. System Overview & Purpose

Purpose

To provide a legally compliant, auditable, and automated payroll calculation matrix for Malaysian employers adhering to statutory deductions under the Malaysian Employment Act 1955, Employees Provident Fund (EPF), Social Security Organization (PERKESO/SOCSO), Employment Insurance System (EIS), and Schedular Tax Deduction (PCB/CP38) regulations overseen by the Inland Revenue Board of Malaysia (LHDN).

Scope

Full gross-to-net pay computation.
Automated statutory contribution tiering based on prevailing Malaysian statutory schedules.
Overtime (OT) calculations compliant with the Employment Act 1955 (Sabah, Sarawak, and Peninsular Malaysia variants where applicable).
Production-ready data layout for bank Giro file generation (Maybank2u/CIBBizChannel format) and statutory submissions (KWSP i-Akaun, PERKESO Assist, LHDN e-PCB).

Update Cadence

Monthly: Pre-payroll adjustments (additions, deductions, unearned leaves), calculation run, statutory file generation, and payout execution (by the 28th of each month).
Annually/Ad-hoc: Updates to statutory rate tables (e.g., EPF wage ceilings, SOCSO salary brackets, PCB computerised calculation methods) as mandated by the Ministry of Finance and LHDN.

2. Data Structure & Column Definitions Table

Col ID	Field Name	Data Type	Validation Rules / Format	Description / Statutory Reference
A	`Emp_ID`	Text	Unique, Format: `EMP[0-9]{4}`	Primary identifier for employee record matching.
B	`Full_Name`	Text	Title Case, Matches NRIC/Passport	Legal name as per MyKad or official identification.
C	`IC_Passport`	Text	Malaysian NRIC (`[0-9]{6}-[0-9]{2}-[0-9]{4}`) or Passport	Used for statutory submission validation (EPF/SOCSO/LHDN).
D	`EPF_No`	Text	10-digit numeric string	EPF membership number.
E	`SOCSO_No`	Text	10-digit numeric string	PERKESO registration number.
F	`Tax_No`	Text	LHDN SG/OG number (`[0-9]{10}`)	Income tax reference number.
G	`Base_Salary`	Currency	`>= 1500.00` (MYR), 2 decimal places	Monthly contracted base wage.
H	`Allow_Fixed`	Currency	`>= 0.00`, 2 decimal places	Fixed taxable allowances (e.g., transport, fixed cola).
I	`OT_Hours`	Numeric	`>= 0.00`, 2 decimal places	Total overtime hours worked in the current cycle.
J	`Bonus_Comm`	Currency	`>= 0.00`, 2 decimal places	Variable additions, commissions, or bonuses.
K	`Unpaid_Leave_Days`	Numeric	`>= 0.00`, increments of 0.5	Deductible days for unpaid leave.
L	`Gross_Salary`	Formula	Derived, 2 decimal places	Total taxable earnings before statutory deductions.
M	`EPF_Employee`	Formula	Rounded to nearest MYR or exact	Employee statutory EPF contribution (Standard: 11% or 9%).
N	`EPF_Employer`	Formula	Rounded to nearest MYR or exact	Employer statutory EPF contribution (12% or 13%).
O	`SOCSO_Employee`	Formula	Bracket-lookup based on Wage	Employee Employment Injury & Invalidity scheme deduction.
P	`SOCSO_Employer`	Formula	Bracket-lookup based on Wage	Employer Employment Injury & Invalidity scheme contribution.
Q	`EIS_Employee`	Formula	Capped bracket lookup (Max wage RM5,000)	Employee Employment Insurance System deduction (0.2%).
R	`EIS_Employer`	Formula	Capped bracket lookup (Max wage RM5,000)	Employer Employment Insurance System contribution (0.2%).
S	`PCB_Tax`	Currency	Manual Input (from LHDN e-PCB) or Formula	Schedular Tax Deduction (Potongan Cukai Bulanan).
T	`Net_Salary`	Formula	Derived, 2 decimal places	Take-home pay transferred to employee bank account.

3. Complete Master Data Table / Tracker

Note: All monetary values are in Malaysian Ringgit (MYR). EPF employee rates calculated at standard 11% for wages > RM5,000, SOCSO/EIS based on 2024 revised wage ceiling tables.

Emp_ID	Full_Name	IC_Passport	Base_Salary	Allow_Fixed	OT_Hours	Bonus_Comm	Unpaid_Leave	Gross_Salary	EPF_Emp	EPF_Empr	SOCSO_Emp	SOCSO_Empr	EIS_Emp	EIS_Empr	PCB_Tax	Net_Salary
EMP1001	Aminah Binti Omar	880514-14-5232	4500.00	300.00	5.0	0.00	0.0	4923.08	528.00	624.00	14.75	51.65	9.50	9.50	45.00	4316.33
EMP1002	Loganathan A/L Muthu	920322-08-6111	7500.00	500.00	0.0	1000.00	0.0	9000.00	990.00	1170.00	24.75	86.65	19.75	19.75	520.00	7285.50
EMP1003	Wong Mei Ling	951112-10-5428	3200.00	200.00	12.0	0.00	1.0	3446.15	379.00	448.00	10.25	35.85	6.50	6.50	0.00	3004.90
EMP1004	Steven Chong	841203-08-3321	12000.00	1000.00	0.0	2500.00	0.0	15500.00	1705.00	2015.00	24.75	86.65	19.75	19.75	1650.00	14080.75
EMP1005	Siti Nurhaliza	900612-03-5182	2800.00	150.00	0.0	0.00	0.0	2950.00	325.00	384.00	8.75	30.65	5.90	5.90	0.00	2604.45
EMP1006	Rajoo A/L Gopal	790415-05-5011	5500.00	400.00	8.5	0.00	0.0	6092.31	670.00	793.00	19.75	69.15	13.90	13.90	185.00	5190.76
EMP1007	Tan Wei Kiat	980125-14-6133	2100.00	100.00	4.0	0.00	0.0	2253.85	248.00	293.00	6.75	23.65	4.45	4.45	0.00	1990.20
EMP1008	Noraini Binti Zakaria	860909-02-5402	6200.00	450.00	0.0	500.00	2.0	6640.00	730.00	863.00	22.25	77.85	15.75	15.75	310.00	5546.25

4. Key Formulas & Calculation Logic

Implement these exact formulas in the corresponding columns within your spreadsheet processing engine. Assuming Row 2 is the active data record.

1. Gross Salary Calculation

Accounts for base remuneration, fixed allowances, overtime computations (based on standard Malaysian formula: [Base / 26 days / 8 hours * 1.5 * OT Hours]), bonuses, and unpaid leave deductions (Base / 26 * Unpaid Days).

=ROUND(G2 + H2 + ((G2 / 26 / 8) * 1.5 * I2) + J2 - ((G2 / 26) * K2), 2)

2. Employee EPF (KWSP) Contribution

Calculates 11% of the gross/base earnings (as per statutory guidelines, typically computed on total monthly wages, rounded to the nearest Ringgit).

=ROUND(L2 * 0.11, 0)

3. Employer EPF (KWSP) Contribution

Calculates 13% for employees earning $\le$ RM5,000, or 12% for employees earning $>$ RM5,000.

=IF(G2<=5000, ROUND(L2*0.13, 0), ROUND(L2*0.12, 0))

4. Employee SOCSO (PERKESO) Deduction

Utilizes an absolute lookup array referencing the Malaysian SOCSO Second Schedule (Employment Injury & Invalidity Schemes). Replace SOCSO_Table with your named range.

=VLOOKUP(L2, SOCSO_Table, 2, TRUE)

5. Employer SOCSO (PERKESO) Contribution

Retrieves the employer's corresponding contribution tier from the statutory table.

=VLOOKUP(L2, SOCSO_Table, 3, TRUE)

6. Employee EIS (SOCSO SIP) Deduction

Uses the Employment Insurance System wage-bracket matrix (capped at RM5,000 wage ceiling resulting in fixed max employee deduction of RM19.75). Replace EIS_Table with your named range.

=VLOOKUP(MIN(L2, 5000), EIS_Table, 2, TRUE)

7. Employer EIS (SOCSO SIP) Contribution

Retrieves employer's matching EIS contribution.

=VLOOKUP(MIN(L2, 5000), EIS_Table, 3, TRUE)

8. Net Salary Take-Home Pay

Deducts all statutory obligations from the Gross Salary.

=ROUND(L2 - M2 - O2 - Q2 - S2, 2)

5. Summary KPI Dashboard

Construct this executive KPI summary block at the top of your sheet (Rows 1–5) or on a dedicated reporting tab.

KPI Metric	Calculation Formula / Reference	Value (MYR / Count)
Total Headcount	`=COUNTA(A8:A100)-1`	`8`
Total Gross Payroll	`=SUM(L8:L100)`	`48,906.34`
Total EPF (Employee + Employer)	`=SUM(M8:M100) + SUM(N8:N100)`	`10,480.00`
Total SOCSO (PERKESO)	`=SUM(O8:O100) + SUM(P8:P100)`	`374.80`
Total EIS (SIP)	`=SUM(Q8:Q100) + SUM(R8:R100)`	`153.80`
Total PCB (LHDN Tax)	`=SUM(S8:S100)`	`2,710.00`
Total Net Cash Outflow	`=SUM(T8:T100)`	`35,187.94`

6. Standard Operating Workflow

Data Ingestion (Day 20–23 of Month):
- Populate Base_Salary, Allow_Fixed, and check employee status changes.
- Import attendance data to populate OT_Hours and Unpaid_Leave_Days.
- Input any variable Bonus_Comm approved by management.
Calculation & Verification (Day 24–25):
- Verify that all dynamic formulas (Gross_Salary, EPF, SOCSO, EIS, Net_Salary) auto-calculate correctly without circular reference errors.
- Run manual cross-checks on anomalous records (e.g., new hires, resignations prorated calculations).
Tax & Statutory Validation (Day 26):
- Input monthly computed PCB_Tax figures extracted directly from the LHDN e-PCB portal calculation engine.
- Cross-verify summary KPI dashboard totals against finance cash-flow projections.
Disbursement & Statutory Remittance (Day 27–28):
- Generate the corporate banking Giro text/Excel file for salary crediting.
- Generate submission text files for KWSP i-Akaun, PERKESO Assist Portal, and LHDN CP38/PCB portals.
- Execute payments and archive signed payroll summary reports in the secure audit directory.

Official Standardized Document

Download this Template

View all