Scribd
Upload
65 views3 pages

Teacher Payroll and Net Pay Breakdown

The document outlines the payroll details for teachers at Erenas Elementary School in the Samar Division of the Philippines, including days worked, rates, and deductions for regular and special holidays. It provides a breakdown of gross pay, deductions for GSIS, SSS, Pag-IBIG, and PhilHealth, as well as the resulting net pay for each employee. The calculations for holiday pay and total deductions are also included in the document.

Uploaded by

gdhphilhealthsection2024
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
65 views3 pages

Teacher Payroll and Net Pay Breakdown

The document outlines the payroll details for teachers at Erenas Elementary School in the Samar Division of the Philippines, including days worked, rates, and deductions for regular and special holidays. It provides a breakdown of gross pay, deductions for GSIS, SSS, Pag-IBIG, and PhilHealth, as well as the resulting net pay for each employee. The calculations for holiday pay and total deductions are also included in the document.

Uploaded by

gdhphilhealthsection2024
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

REPUBLIC OF THE PHILIPPINES

DEPARTMENT OF EDUCATION
SAMAR DIVISION
ERENAS ELEMENTARY SCHOOL
PAYROLL
REGULAR HOLIDAYS
EMPLOYEE NAME POSITION DAYS WORKED RATE PER DAY
WORKED
Mariel P. Doco Teacher 1 20 1450 1
Eloisa R. Montoya Teacher 1 19 1450 0
Christopher Teacher 1 20 1450 1
Tom Ribert Teacher 1 20 1450 1
Remart Teacher 1 18 1450 0
Yllor Teacher 1 19 1450 0

FORMULA:
HOLIDAY PAY:
GROSS PAY:
GSIS:
SSS:
PAG-IBIG:
PHILHEALTH:
TOTAL DEDUCTION:
NET PAY:
REPUBLIC OF THE PHILIPPINES
DEPARTMENT OF EDUCATION
SAMAR DIVISION
ERENAS ELEMENTARY SCHOOL
PAYROLL
SPECIAL HOLIDAYS HOLIDAY GROSS GSIS PhilHealth TOAL
SSS(4.5%) Pag-IBIG(2%)
WORKED PAY PAY (12%) (3%) DEDUCTION
1 4785 33785 4054.2 1520.325 675.7 1013.55 7263.775
1 1885 29435 3532.2 1324.575 588.7 883.05 6328.525
0 2900 31900 3828 1435.5 638 957 6858.5
1 4785 33785 4054.2 1520.325 675.7 1013.55 7263.775
1 1885 27985 3358.2 1259.325 559.7 839.55 6016.775
0 0 27550 3306 1239.75 551 826.5 5923.25

REGULAR HOLIDAY*RATE PER DAY*2 + SPECIAL HOLIDAY*RATE PER DAY*1.3


DAYS WORKED*RATE PER DAY+HOLIDAY PAY
GROSS PAY * 12%
GROSS PAY * 0.045
GROSS PAY * 0.02
GROSS PAY * 0.03
SUM(GSIS, SSS,PAG-BIG,PHILHEALTH)
GROSS PAY-TOTAL DEDUCTION
NET PAY

26521.23
23106.48
25041.5
26521.23
21968.23
21626.75

You might also like