ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Employment Income
Tax YE2023
2
Salary RM 88,888.00 Edit only yellow cells, don't touch grey cells (will have formulas)
Don't request permission to edit the sheet - either "Download as Excel" or "Save a Copy to Drive"
3
Bonus RM 1,234.00
4
Bonus RM 1,234.00
5
Bonus
6
Other Payments
7
Dividends Received RM 1,234.00
8
TOTAL EMPLOYMENT INCOME RM 92,590.00
9
10
(Less Donations)
11
Approved Charitiesn/a
12
TOTAL DONATIONS RM -
13
14
Other Income
15
Other Dividend, royalties, ….. RM -
16
TOTAL OTHER INCOME RM -
17
18
TOTAL INCOME
 RM 92,590.00
19
20
RELIEFSremove/add/change items accordingly and set the cap amountcapactualsItem 1 Description Item 1 AmountItem 2 Description Item 2 AmountItem 3 Description Item 3 AmountItem 4 Description Item 4 Amount
21
1Individual and dependent relativesRM (9,000.00) RM (9,000.00) Self RM 9,000.00
22
5(iii)Course of study undertaken for the purpose of upskilling or self-enhancementRM (2,000.00) RM (24.00) course 1 RM 12.00 course 2 RM 12.00
23
6(ii)Medical Expenses Fertility treatment for selfRM (500.00) fertility RM 500.00
24
7(i) & (iii)Complete Medical Examination and Mental Health ConsultationRM (1,000.00) RM (246.00) medical checkup RM 123.00 mental health RM 123.00
25
9(ii) & (iv)Personal Computer/Phone/Tablet; Internet SubscriptionRM (2,500.00) RM (2,468.00) TIME Internet RM 1,234.00 ipad tablet RM 1,234.00
26
17(i)EPF ContributionsRM (4,000.00) RM (4,000.00) EPF Contrib. Employee RM 12,345.00
27
17(ii)Life InsuranceRM (3,000.00) RM (2,468.00) life insurance 1 RM 1,234.00 life insurance 2 RM 1,234.00
28
18(ii)Private Retirement Scheme (PRS)RM (3,000.00) RM (3,000.00) PRS fund 1 RM 3,000.00
29
19(ii)Medical insuranceRM (3,000.00) RM (400.00) medical insurance 1 RM 400.50
30
20Social Security Organization (SOCSO)RM (350.00) RM (123.00) PERKESO/SOCSO RM 123.00
31
 RM -
32
 RM -
33
 RM -
34
RM (27,850.00) RM (22,229.00)
35
36
CHARGEABLE INCOME
 RM 70,361.00
37
38
INCOME TAX BRACKET
input bracket rate %
39
for first line, input tax amount from LHDN
40
 $ 35,000.00 On the first 35,000 [1 - 35,000] RM 600.00 35,0001.7%600
41
 $ 15,000.00 On the next 15,000 [35,001 - 50,000] RM 900.00 15,0006.0%
42
 $ 20,000.00 On the next 20,000 [50,001 - 70,000] RM 2,200.00 20,00011.0%
43
 $ 361.00 On the next 30,000 [70,001 - 100,000] RM 68.59 30,00019.0%
44
 $ - On the next 300,000 [100,001 - 400,000] RM - 300,00025.0%
45
 $ - On the next 200,000 [400,001 - 600,000] RM - 200,00026.0%
46
TAX PAYABLE RM 3,768.59
https://www.hasil.gov.my/en/individual/individual-life-cycle/how-to-declare-income/tax-rate/
47
48
(Less : Monthly Tax Deductions)RM (4,500.00)
49
50
51
BALANCE OF TAX PAYABLE / (TAX PAID IN EXCESS)
RM (731.41) TO RECEIVE
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100