Tammy Payroll

Payroll Date _______
# Employee No.
1
2
3
4
5
6
7
8
9
10
14-0790-235
14-0662-809
14-0715-316
14-0831-914
14-7564-980
14-0671-543
14-0887-702
14-0040-286
14-0145-409
14-0031-148
Employee Name
Esther Bulahao
Precious Jane Santos
Yvonne Liezle Lang-ay
Ranel Wacnang
Denia Balasso
Nicole Suzanne Dolatre
Donna Marie Caguisano
Flordilyn Sarol Omaweng
Milbern Paderes
Caroline Joy Suratos
NOTE.
Regular Working Hours:8
COLA ( fixed amount)
Prepared by:
________________
Payroll Clerk 1
Status
Hourly Wage
Z
S
2
2
2
3
3
4
4
4
Php287.30
Php546.20
Php342.50
Php129.00
Php325.70
Php435.50
Php876.90
Php298.90
Php76.30
Php46.80
8
Php500.00
Number of Working Days

23
25
25
26
28
25
23
24
25
25
University of the Cordilleras

Baguio City
Overtime Hours
2
3.2
1.3
5
2
6
10
2
4
6
# of Holidays
Tardiness
1
1
1
1
1
1
1
1
1
1
1.23
1.45
0.67
5.34
6.1
0.89
1.34
2.76
1.15
0
TOTAL
Checked by:
_______________
Chief Accountant
Gross Pay
Php55,882.82
Php115,065.45
Php71,955.78
Php28,320.14
Php74,727.03
Php93,309.41
Php176,458.75
Php60,052.84
Php16,587.86
Php10,515.20
Government Contributions
SSS
PhilHealth
HDMF
Php500.00 Php437.50 Php1,117.66
Php500.00 Php437.50 Php2,301.31
Php500.00 Php437.50 Php1,439.12
Php500.00 Php350.00
Php566.40
Php500.00 Php437.50 Php1,494.54
Php500.00 Php437.50 Php1,866.19
Php500.00 Php437.50 Php3,529.18
Php500.00 Php437.50 Php1,201.06
Php500.00 Php200.00
Php331.76
Php350.00 Php125.00
Php210.30
Taxable Income
Php100,000.00
Php111,826.64
Php69,579.16
Php26,903.74
Php72,294.99
Php90,505.72
Php171,992.08
Php57,914.28
Php15,556.10
Php9,829.90
Approved by:
_________________
VP for Finance
Withholding Tax
Php16,424.27
Php34,695.83
Php20,234.18
Php6,270.77
Php21,120.98
Php26,733.90
Php53,341.69
Php15,758.68
Php2,063.71
Php623.81
SSS
Php500.00
Php200.00
Php300.00
Php150.00
Php123.00
Php156.00
Php156.00
Php258.00
Php256.00
Php255.00
Loans
Pag-ibig
Php895.00
Php568.00
Php658.00
Php254.00
Php214.00
Php256.00
Php254.00
Php254.00
Php254.00
Php258.00
Coop
Php456.00
Php253.00
Php236.00
Php45.00
Php265.00
Php584.00
Php0.00
Php585.00
Php584.00
Php584.00
Other Deductions
Php1,200.00
Php200.00
Php900.00
Php200.00
Php900.00
Php2,300.00
Php4,000.00
Php500.00
Php560.00
Php120.00
Take Home Pay

Php36,407.55
Php79,148.62
Php49,627.60
Php21,400.37
Php52,104.05
Php63,279.51
Php118,707.06
Php42,697.16
Php12,870.14
Php8,674.39
Minimum
Maximum
Average
Count
Php8,674.39
Php118,707.06
Php48,491.64
10

Baguio City
Payroll Date ____________
#
Employee No.
1
2
3
4
5
6
7
8
9
10
14-0790-235
14-0662-809
14-0715-316
14-0831-914
14-7564-980
14-0671-543
14-0887-702
14-0040-286
14-0145-409
14-0031-148
Employee Name
Esther Bulahao
Ranel Wacnang
Denia Balasso
Milbern Paderes
Complete the SSS Table based on the given SSS Table

Use lookup functions to generate the SSS ER and EE.
Gross Pay
PHP 55,882.82
PHP 115,065.45
PHP 71,955.78
PHP 28,320.14
PHP 74,727.03
PHP 93,309.41
PHP 176,458.75
PHP 60,052.84
PHP 16,587.86
PHP 10,515.20
TOTAL
SSS Contribution
EE
Php500.00
Php500.00
Php500.00
Php500.00
Php500.00
Php500.00
Php500.00
Php500.00
Php500.00
Php350.00
Employer - Employee
Monthly
SSS Contribution
Range of Compensation
Salary
Credit
SOCIAL SECURITY
ER
EE
TOTAL
1,000.00
1,249.99
1,000.00
70.70
33.30
104.00
1,250.00
1,749.99
1,500.00
106.00
50.00
156.00
1,750.00
2,249.99
2,000.00
141.30
66.70
208.00
2,250.00
2,749.99
2,500.00
176.70
83.30
260.00
2,750.00
3,249.99
3,000.00
212.00
100.00
312.00
3,250.00
3,749.99
3,500.00
247.30
116.70
364.00
3,750.00
4,249.99
4,000.00
282.70
133.30
416.00
4,250.00
4,749.99
4,500.00
318.00
150.00
468.00
4,750.00
5,249.99
5,000.00
353.30
166.70
520.00
5,250.00
5,749.99
5,500.00
388.70
183.30
572.00
5,750.00
6,249.99
6,000.00
424.00
200.00
624.00
6,250.00
6,749.99
6,500.00
459.30
216.70
676.00
6,750.00
7,249.99
7,000.00
494.70
233.30
728.00
7,250.00
7,749.99
7,500.00
530.00
250.00
780.00
7,750.00
8,249.99
8,000.00
565.30
266.70
832.00
8,250.00
8,749.99
8,500.00
600.70
283.30
884.00
8,750.00
9,249.99
9,000.00
636.00
300.00
936.00
9,250.00
9,749.99
9,500.00
671.30
316.70
988.00
9,750.00
10,249.99
10,000.00
706.70
333.30
1,040.00
10,250.00
10,749.99
10,500.00
742.00
350.00
1,092.00
10,750.00
11,249.99
11,000.00
777.30
366.70
1,144.00
11,250.00
11,749.99
11,500.00
812.70
383.30
1,196.00
11,750.00
12,249.99
12,000.00
848.00
400.00
1,248.00
12,250.00
12,749.99
12,500.00
883.30
416.70
1,300.00
12,750.00
13,249.99
13,000.00
918.70
433.30
1,352.00
13,250.00
13,749.99
13,500.00
954.00
450.00
1,404.00
13,750.00
14,249.99
14,000.00
989.30
466.70
1,456.00
14,250.00
14,749.99
14,500.00
1,024.70
483.30
1,508.00
14,750.00
30,000.00
15,000.00
1,060.00
500.00
1,560.00
Employer - Employee
SE / VM / OFW
Total Contribution
EC
ER
ER
EE
Total
Total Contribution
10.00
80.70
33.30
114.00
104.00
10.00
116.00
50.00
166.00
156.00
10.00
151.30
66.70
218.00
208.00
10.00
186.70
83.30
270.00
260.00
10.00
222.00
100.00
322.00
312.00
10.00
257.30
116.70
374.00
364.00
10.00
292.70
133.30
426.00
416.00
10.00
328.00
150.00
478.00
468.00
10.00
363.30
166.70
530.00
520.00
10.00
398.70
183.30
582.00
572.00
10.00
434.00
200.00
634.00
624.00
10.00
469.30
216.70
686.00
676.00
10.00
504.70
233.30
738.00
728.00
10.00
540.00
250.00
790.00
780.00
10.00
575.30
266.70
842.00
832.00
10.00
610.70
283.30
894.00
884.00
10.00
646.00
300.00
946.00
936.00
10.00
681.30
316.70
998.00
988.00
10.00
716.70
333.30
1,050.00
1,040.00
10.00
752.00
350.00
1,102.00
1,092.00
10.00
787.30
366.70
1,154.00
1,144.00
10.00
822.70
383.30
1,206.00
1,196.00
10.00
858.00
400.00
1,258.00
1,248.00
10.00
893.30
416.70
1,310.00
1,300.00
10.00
928.70
433.30
1,362.00
1,352.00
10.00
964.00
450.00
1,414.00
1,404.00
10.00
999.30
466.70
1,466.00
1,456.00
10.00
1,034.70
483.30
1,518.00
1,508.00
30.00
1,090.00
500.00
1,590.00
1,560.00

Baguio City
Payroll Date: ___________
PhilHealth Contribution
#
Employee No.
1
2
3
4
14-0790-235
14-0662-809
14-0715-316
14-0831-914
Employee Name
Esther Bulahao
Ranel Wacnang
Gross Pay
Php55,882.82
Php115,065.45
Php71,955.78
Php28,320.14
EE
Php437.50
Php437.50
Php437.50
Php350.00
5 14-7564-980
Denia Balasso
Php74,727.03 Php437.50
6 14-0671-543
Php93,309.41 Php437.50
7 14-0887-702
Php176,458.75 Php437.50
8 14-0040-286
Php60,052.84 Php437.50
9 14-0145-409
Milbern Paderes
Php16,587.86 Php200.00
10 14-0031-148
10515.20
TOTAL
Complete the PhilHealth Table based on the given PhilHealth Table.

Use lookup functions to generate the PhilHealth ER and EE.
125.00
ontribution
PhilHealth Table
Salary
Bracket
Salary
Range
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
4,999.99
5000
6000
7000
8,999.99
and below
9,000.00 9,999.99
10,000.00 10,999.99
11,000.00 11,999.99
12,000.00 12,999.99
13,000.00 13,999.99
14,000.00 14,999.99
15,000.00 15,999.99
16,000.00 16,999.99
17,000.00 17,999.99
18,000.00 18,999.99
19,000.00 19,999.99
20,000.00 20,999.99
21,000.00 21,999.99
22,000.00 22,999.99
23,000.00 23,999.99
24,000.00 24,999.99
50.00
62.50
75.00
87.50
Total
Monthly
Premium
100
125
175
200
8,000.00
Salary
Base
Employee
Share
Employer
Share
50
62.5
75
87.5
50
62.5
75
87.5
200
100
100
9,000.00
225
112.5
112.5
10,000.00
250
125
125
11,000.00
275
137.5
137.5
12,000.00
300
150
150
13,000.00
325
162.5
162.5
14,000.00
350
175
175
15,000.00
375
187.5
187.5
16,000.00
400
200
200
17,000.00
425
212.5
212.5
18,000.00
450
225
225
19,000.00
475
237.5
237.5
20,000.00
500
250
250
21,000.00
525
262.5
262.5
22,000.00
550
275
275
23,000.00
575
287.5
287.5
24,000.00
600
300
300
25,000.00 22 25,999.99
26,000.00 23 26,999.99
27,000.00 24 27,999.99
28,000.00 25 28,999.99
29,000.00 26 29,999.99
30,000.00 27 30,999.99
31,000.00 28 31,999.99
32,000.00 29 32,999.99
33,000.00 30 33,999.99
34,000.00 31 34,999.99
35,000.00
32 and up
25,000.00
625
312.5
312.5
26,000.00
650
325
325
27,000.00
675
337.5
337.5
28,000.00
700
350
350
29,000.00
725
362.5
362.5
30,000.00
750
375
375
31,000.00
775
387.5
387.5
32,000.00
800
400
400
33,000.00
825
412.5
412.5
34,000.00
850
425
425
35,000.00
875
437.5
437.5

Baguio City
Payroll Date: ___________
#
1
2
3
4
5
6
7
8
9
10
Employee No.
14-0790-235
14-0662-809
14-0715-316
14-0831-914
14-7564-980
14-0671-543
14-0887-702
14-0040-286
14-0145-409
14-0031-148
Employee Name
Esther Bulahao
Ranel Wacnang
Denia Balasso
Milbern Paderes
Gross Pay
Php55,882.82
Php115,065.45
Php71,955.78
Php28,320.14
Php74,727.03
Php93,309.41
Php176,458.75
Php60,052.84
Php16,587.86
Php10,515.20
TOTAL
HDMF Contribution
EE
Php1,117.66
Php2,301.31
Php1,439.12
Php566.40
Php1,494.54
Php1,866.19
Php3,529.18
Php1,201.06
Php331.76
Php210.30
Multiplier
Gross Pay Range
0-1499.99
1500-over
Employee
Employer
0.01
0.02
0.02
0.02

Baguio City
#
Employee No.
1
2
3
4
5
6
7
8
9
10
Employee Name
14-0790-235
14-0662-809
14-0715-316
Status
Esther Bulahao
Ranel Wacnang
Denia Balasso
Milbern Paderes
14-0831-914
14-7564-980
14-0671-543
14-0887-702
14-0040-286
14-0145-409
14-0031-148
Gross Pay
Z Php55,882.82
1 Php115,065.45
1 Php71,955.78
2 Php28,320.14
2 Php74,727.03
3 Php93,309.41
3 Php176,458.75
4 Php60,052.84
4 Php16,587.86
4 Php10,515.20
Taxable Income
Php100,000.00
Php111,826.64
Php69,579.16
Php26,903.74
Php72,294.99
Php90,505.72
Php171,992.08
Php57,914.28
Php15,556.10
Php9,829.90
Withholding Tax Table
Z
S/ME
1
2
3
4
1
0
0%
1
1
2
0
5%
0
2083
3
20.83
10%
417
2500
4
104.17
15%
1250
3333
5
354.17
20%
2917
5000
1
1
1
1
3125
4167
5208
6250
3542
4583
5625
6667
4375
5417
6458
7500
6042
7083
8125
9167
1
0
417
1250
2917
5833
10417
20833
0
0
20.83
104.17
354.17
937.5
2083.33
5208.33
0%
5%
10%
15%
20%
25%
30%
32%
0
0
20.83
104.17
354.17
937.5
0%
5%
10%
15%
20%
25%
S/ME
1
2083
2500
3333
5000
7917
12500
22917
2083.33
5208.33
30%
32%
1
1
3125
3542
4375
6042
8958
13542
23958
0
0
20.83
104.17
354.17
937.5
2083.33
5208.33
0%
5%
10%
15%
20%
25%
30%
32%
1
4167
4583
5417
7083
10000
14583
25000
0
0
20.83
104.17
354.17
937.5
2083.33
5208.33
0%
5%
10%
15%
20%
25%
30%
32%
3
1
5208
5625
6458
8125
11042
15625
26042
0
0
20.83
104.17
354.17
937.5
2083.33
5208.33
0%
5%
10%
15%
20%
25%
30%
32%
4
1
6250
6667
7500
9167
12083
16667
27083
0
0
20.83
104.17
354.17
937.5
2083.33
5208.33
0%
5%
10%
15%
20%
25%
30%
32%
2
b
Cordilleras
City
Withholding Tax
Php16,424.27
Php34,695.83
Php20,234.18
Php6,270.77
Php21,120.98
Php26,733.90
Php53,341.69
Php15,758.68
Php2,063.71
Php623.81
6
7
8
937.5 2083.33 5208.33
25%
30%
32%
5833
10417
20833
7917
12500
22917
8958
10000
11042
12083
13542
14583
15625
16667
23958
25000
26042
27083
Co
Company Address
Phone:555-555-555555
Fax:123-456-6659847467
Write your Website here
Write your Email Address here
Name of Employee:_______________
Period of Payment:_______________
Scale of Payment
Description
Days
Regular working hours
8
No. of Working Days
25
No. of Holidays
1
Computation of Gross Salary to be Paid for This Month:
Hours of overtime
2
Tardiness
1.23
Break Up of Deductions for the Month
Contribution for social security
Php500.00
Contribution for Health Insurance
Php437.50
Contribution for Housing Insurance
Php1,117.66
Amount of Witholding Tax
Php16,424.27
Total Deductions
Php1,200.00
Net Salary
Php36,407.55
Prepared by: Ms. Kahren Tammy
Company Name
Pay Slip
Description
Pay Rate per Hour
Total of Gross Salary
Receivedby: Esther Bulahao
Amount ($)
Php287.30
Php55,882.82
Name

Tammy Payroll

Uploaded by

Copyright:

Available Formats

Tammy Payroll

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Tammy Payroll

Uploaded by

Copyright:

Available Formats

Payroll Date _______

Number of Working Days

University of the Cordilleras

Take Home Pay

University of the Cordilleras

Complete the SSS Table based on the given SSS Table

University of the Cordilleras

Nicole Suzanne Dolatre

Donna Marie Caguisano

Flordilyn Sarol Omaweng

Caroline Joy Suratos

Complete the PhilHealth Table based on the given PhilHealth Table.

University of the Cordilleras

University of the Cordilleras

Withholding Tax Table

Total of Gross Salary

Receivedby: Esther Bulahao

You might also like