COMPUTATION FOR WITHHOLDING TAX ON COMPENSATION.xlsx

	A	B	C	D	H	I	P	Q	S	U	V	W	X	Y	Z	AA	AE	AF	AK	AL
1	CY 2025 TAX COMPUTATION
2
3	Name				:	EMPLOYEE A										Tax Identification Number			:
4	Position/Salary Grade				:	TEACHER III/SG 13										Date of Birth			:
5	Address				:											Date of Appointment			:	December 18, 2024
6
7
8	Basic Salary						(	34,421.00		x	12	months	)						413,052.00
9	Tax-exempt compensation:
10	PERA						(	2,000.00		x	12	months	)						24,000.00
11	RATA						(	0.00		x	12	months	)						-
12	13th Month Pay and Other Benefits:
13	Mid-Year Bonus						(	34,421.00		x	1		)						34,421.00
14	Year - End Bonus						(	34,421.00		x	1		)						34,421.00
15	Cash Gift						(	5,000.00		x	1		)						5,000.00
16	Productivity Enhancement Incentive (PEI)						(	5,000.00		x	1		)						5,000.00
17	Special Ameliorative Measure (SAM)						(	10,000.00		x	1		)						10,000.00
18	Service Recognition Incentive (SRI)						(	20,000.00		x	1		)						20,000.00
19	De Minimis (Additional) Benefits:
20	Clothing Allowance						(	7,000.00		x	1		)						7,000.00
21	Medical Allowance						(	7,000.00		x	1		)						7,000.00
22
23	LESS: TOTAL NON-TAXABLE/EXEMPT																		559,894.00
24			Tax Exempt (RATA and PERA)														24,000.00
25			13th Month Pay and Other Benefits (Limit 90,000 or Actual amount of bonuses/benefits whichever is lower)														90,000.00
26				Actual amount											108,842.00
27				vs
28				Limit											90,000.00
29			De Minimis Benefits
30				Uniform/Clothing Allowance			(	7,000.00		x	1		)		7,000.00
31				Medical Allowance			(	7,000.00		x	1		)		7,000.00			14,000.00
32
33			Statutory Contributions and Union Dues (Employee Share only)
34				GSIS			(	3,097.89		x	12	months	)	37,174.68
35				PHIC			(	860.53		x	12	months	)	10,326.30
36				PAG-IBIG			(	200.00		x	12	months	)	2,400.00
37																	49,900.98		177,900.98
38	NET TAXABLE COMPENSATION INCOME																		381,993.02
39
40	TAX DUE (See Income Tax table under TRAIN LAW)
41		On		250,000.00													-
42			131,993.02		x	15%											19,798.95
43																	19,798.95
44
45	SCHEDULE OF WITHHOLDING TAXES
46		January					(	1,649.91		x	1	)		1,649.91
47		February					(	1,649.91		x	1	)		1,649.91
48		March					(	1,649.91		x	1	)		1,649.91
49		April					(	1,649.91		x	1	)		1,649.91
50		May					(	1,649.91		x	1	)		1,649.91
51		June					(	1,649.91		x	1	)		1,649.91
52		July					(	1,649.91		x	1	)		1,649.91
53		August					(	1,649.91		x	1	)		1,649.91
54		September					(	1,649.91		x	1	)		1,649.91
55		October					(	1,649.91		x	1	)		1,649.91
56		November					(	1,649.91		x	1	)		1,649.91
57		December					(	1,649.91		x	1	)		1,649.91			19,798.95
58	TAXES ACTUALLY WITHHELD
59		January					(			x	1	)		-
60		February					(			x	1	)		-
61		March					(			x	1	)		-
62		April					(			x	1	)		-
63		May					(			x	1	)		-
64		June					(			x	1	)		-
65		July					(			x	1	)		-
66		August					(			x	1	)		-
67		September					(			x	1	)		-
68		October					(			x	1	)		-
69		November					(			x	1	)		-
70		December					(			x	1	)		-			-
71	TAX DUE																19,798.95
72
73	Income taxes and withholding taxes are subject to adjustments. For any inquiries or comments, please see the undersigned. Thank you.
74
75									Certified Correct by:
76
77
78														Accountant
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100