How to Calculate MTD (PCB) Formula in your Payroll

If you are interested to know the calculation of the PCB (MTD) formula in Malaysua, you have came to the right place.

In the event you are looking for ERP system with an affordable HR Payroll, read this "HR Payroll for Malaysia".

An employee with Monthly Salary of RM4840, single and with 1 month bonus.

Source: LHDN Garis Panduan PCB

a) Determine the Maximum allowed Employee EPF (K) in a Year.

In Year 2020, Maximum Allowed EPF is RM4,000. Note: Subject to change on Budget each year.

So the monthly allowed EPF is RM4000/12 = RM333.33

In this example, Employee EPF is 9% or 11% (optional) of Monthly Salary (Gross). If 11%, the Employee EPF is RM533, which is more than RM333.33.

See this blog for EPF calculation.

b) Get the Yearly Taxable Income for Basic Salary

P = [(Y – K) x 12] + [Σ(Yt1 – Kt1)] + (Yt – Kt) – (D + S + QC)

P = [(4840 - 333.33) x 12] + 0 + 0 - (9000)

P = 45080.04

Y = Monthly Salary (Gross)

K = Maximum Monthly Allowed EPF is RM333.33 (Step a)

Yt = Additional income, such as Bonus, Commissions, etc.

Kt = EPF deducted for additional income, such as life insurance (if Employee EPF < RM333.33)

D = personal deduction = RM9,000

S = spouse deduction = RM4,000 if spouse not working

Q = No. of children,

C = Deduction per child = RM2,000.

c) Get the Monthly Tax Deduction for Basic Salary

Monthly Tax Deduction = [[(P-M) x R] + B] / 12

= [[(45,080.04 - 35,000) x 0.08] + 600] / 12

= 1406.40 / 12

= 117.2

P = Yearly Taxable Income (step b)

M = First chargeable income range. See the table below.

R = Tax rate

B = Amount of tax on M after deduction of tax rebate

Note: This table is valid until year 2021, and may be changed from year to year.

d) Get the Yearly Taxable Income for Basic Salary and Bonus

P = [(Y – K) x 12] + [Σ(Yt1 – Kt1)] + (Yt – Kt) – (D + S + QC)

P = [(4840 - 333.33) x 12] + 0 + 4840 - (9000)

P = 49,920.04

e) Get the Bonus PCB

[[(P-M) x R] + B ]/ 12 - 1406.40 (PCB from Basic Salary)

= [[(49,920.04 - 35,000) x 0.08] + 600] / 12 - 1406.40

= 1793.60 - 1406.40

= 387.20

f) Get the Monthly PCB

117.2 + 387.2

= 504.40

g) Round up to the nearest 5 cent.

Eg, RM812.12 is round up to RM812.15. RM812.18 is rounded up to RM812.20.

You may simulate the Payroll at Payroll.my or LHDN PCB Calculator.

Click "Like" at the bottom of this blog, to motivate us to continue sharing more tips.