Updated Payroll File

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 85

Company Name

Company Address
Companny Phone Number

INSTRUCTIONS: Manually input everything NOTE EMPLOYEE CODE SHOULD BE CORRECT FOR PROPER LOOKUP VALU
EMPLOYEE CODE EMPLOYEE NAME ATM NUMBER MONTHLY RATE
1 vht 40,000.00
CORRECT FOR PROPER LOOKUP VALUES
TIN NUMBER SSS NUMBER PHILHEALTH NUMBER HDMF NUMBER
ENTER COMPANY NAME HERE
ADDRESS

REGULAR

ATM MONTHLHY Number of


EMPLOYEE CODE NUMBER Employee Name RATE Working Days
1 0 vht 40,000.00 11.00
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
DATA REGULAR HOURS

SPECIAL LEGAL SPECIAL HOLIDAY


DAILY RATE HOURLY RATE HOLIDAY RATE HOLIDAY RATE REST DAY REST DAY
3,636.36 454.55 590.91 909.09 590.91 681.82
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
OVERTIME

SPECIAL LEGAL
HOLIDAY HOLIDAY
LEGAL HOLIDAY REGULAR SPECIAL LEGAL REST DAY REST DAY REST DAY
REST DAY OT HOLIDAY OT HOLIDAY OT OT OT OT
1,181.82 568.18 768.18 1,181.82 768.18 886.36 1,536.36
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
NIGHT DIFFERENTIAL HOURS

NIGHT DIFF NIGHT DIFF


SPECIAL LEGAL
NIGHT NIGHT DIFF NIGHT DIFF HOLIDAY HOLIDAY NIGHT DIFF
DIFFERENTIAL SPECIAL LEGAL NIGHT DIFF AND REST AND REST REGULAR
REGULAR HOLIDAY HOLIDAY REST DAY DAY DAY OT
500.00 650.00 1,000.00 650.00 750.00 1,000.00 625.00
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
NIGHT DIFFERENTIAL HOURS OT

NIGHT DIFF NIGHT DIFF


SPECIAL LEGAL
NIGHT DIFF NIGHT DIFF NIGHT DIFF HOLIDAY HOLIDAY
SPECIAL LEGAL REST DAY AND REST AND REST
HOLIDAY OT HOLIDAY OT OT DAY OT DAY OT
845.00 1,300.00 845.00 975.00 1,690.00
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

PAY PERIOD

FILL UP AREA ONLY EMPLOYEE CODE AND NUMBER OF HOURS MUST BE EDITED, ATM NUMBER AND EMPLOYEE N

REGULAR SPECIAL
EMPLOYEE CODE ATM NUMBER Employee Name HOLIDAY
HOURS HOURS

- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
ATM NUMBER AND EMPLOYEE NAME SHOULD AUTOMATICALLY APPEAR USING THE EMPLOYEE CODE
REGULAR HOURS

SPECIAL
LEGAL REST DAY HOLIDAY AND LEGAL HOLIDAY REGULAR OT SPECIAL
HOLIDAY AND RESTDAY HOLIDAY OT
HOURS HOURS REST DAY HOURS HOURS HOURS
HOURS
OYEE CODE
OVERTIME HOURS NIGHT DIFFERENTIAL HOURS

SPECIAL LEGAL
LEGAL REST DAY OT HOLIDAY HOLIDAY REGULAR SPECIAL LEGAL
HOLIDAY OT AND REST AND REST HOLIDAY HOLIDAY
HOURS HOURS DAY OT DAY OT HOURS HOURS HOURS
HOURS HOURS
GHT DIFFERENTIAL HOURS NIGHT DIFFERENTIAL OT HOURS

LEGAL
SPECIAL
REST DAY HOLIDAY HOLIDAY REGULAR OT SPECIAL LEGAL REST DAY OT
AND HOLIDAY OT HOLIDAY OT
HOURS AND REST RESTDAY HOURS HOURS HOURS HOURS
DAY HOURS HOURS
DO NOT EDIT AT THIS POINT
NTIAL OT HOURS BASIC PAY

SPECIAL LEGAL
REST DAY
HOLIDAY HOLIDAY SPECIAL LEGAL PAY
AND REST AND REST REGULAR PAY HOLIDAY HOLIDAY
DAY OT DAY OT PAY PAY (WORKED
HOURS HOURS ON RD)

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
OVERTIME HOURS

SPECIAL
HOLIDAY AND LEGAL HOLIDAY AND TOTAL REGULAR SPECIAL LEGAL
REST DAY RESTDAY (WORKED HOLIDAY HOLIDAY
(WORKED ON ON RD) BASIC PAY PAY PAY
RD)

- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
VERTIME HOURS NIGHT DIFFERENTIAL HOURS
SPECIAL LEGAL
REST DAY HOLIDAY HOLIDAY
PAY AND REST AND TOTAL OT REGULAR SPECIAL LEGAL
HOLIDAY HOLIDAY
(WORKED DAY RESTDAY PAY PAY PAY PAY
ON RD) (WORKED (WORKED
ON RD) ON RD)

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
GHT DIFFERENTIAL HOURS NIGHT DIFFERENTIAL OT HOURS
SPECIAL LEGAL
REST DAY HOLIDAY HOLIDAY
PAY AND REST AND TOTAL ND REGULAR SPECIAL LEGAL
HOLIDAY HOLIDAY
(WORKED DAY RESTDAY PAY PAY PAY PAY
ON RD) (WORKED (WORKED
ON RD) ON RD)

- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
- - - - _ - -
GHT DIFFERENTIAL OT HOURS EMPLOYEE DEDUCTIONS
SPECIAL LEGAL
REST DAY HOLIDAY HOLIDAY
PAY AND REST AND TOTAL TOTAL
PHILHEALTH HDMF
(WORKED DAY RESTDAY NDOT PAY GROSS PAY
ON RD) (WORKED (WORKED
ON RD) ON RD)

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
EDITABLE DO NOT EDIT EDITABLE

TOTAL PRIOR PERIOD INCOME ALLOWANCES/OTHER


WITHHOLDING TAX
DEDUCTIONS ADJUSTMENTS BEFORE TAX BENEFITS

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
NET PAY

-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

PAY PERIOD

FILL UP AREA ONLY EMPLOYEE CODE AND NUMBER OF HOURS MUST BE EDITED, ATM NUMBER AND EMPLOYEE N

REGULAR SPECIAL
EMPLOYEE CODE ATM NUMBER Employee Name HOLIDAY
HOURS HOURS

- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
ATM NUMBER AND EMPLOYEE NAME SHOULD AUTOMATICALLY APPEAR USING THE EMPLOYEE CODE
REGULAR HOURS

SPECIAL
LEGAL REST DAY HOLIDAY AND LEGAL HOLIDAY REGULAR OT SPECIAL
HOLIDAY AND RESTDAY HOLIDAY OT
HOURS HOURS REST DAY HOURS HOURS HOURS
HOURS
OYEE CODE
OVERTIME HOURS NIGHT DIFFERENTIAL HOURS

SPECIAL LEGAL
LEGAL REST DAY OT HOLIDAY HOLIDAY REGULAR SPECIAL LEGAL
HOLIDAY OT AND REST AND REST HOLIDAY HOLIDAY
HOURS HOURS DAY OT DAY OT HOURS HOURS HOURS
HOURS HOURS
GHT DIFFERENTIAL HOURS NIGHT DIFFERENTIAL OT HOURS

LEGAL
SPECIAL
REST DAY HOLIDAY HOLIDAY REGULAR OT SPECIAL LEGAL REST DAY OT
AND HOLIDAY OT HOLIDAY OT
HOURS AND REST RESTDAY HOURS HOURS HOURS HOURS
DAY HOURS HOURS
DO NOT EDIT AT THIS POINT
NTIAL OT HOURS BASIC PAY

SPECIAL LEGAL SPECIAL


REST DAY
HOLIDAY HOLIDAY REGULAR SPECIAL LEGAL PAY HOLIDAY AND
AND REST AND REST HOLIDAY HOLIDAY REST DAY
DAY OT DAY OT PAY PAY PAY (WORKED (WORKED ON
HOURS HOURS ON RD) RD)

- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
OVERTIME HOURS
SPECIAL
REST DAY HOLIDAY
LEGAL HOLIDAY AND TOTAL REGULAR SPECIAL LEGAL PAY AND REST
RESTDAY (WORKED HOLIDAY HOLIDAY
ON RD) BASIC PAY PAY PAY (WORKED DAY
ON RD) (WORKED
ON RD)

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
NIGHT DIFFERENTIAL HOURS
LEGAL SPECIAL
HOLIDAY REST DAY HOLIDAY
AND TOTAL OT REGULAR SPECIAL LEGAL PAY AND REST
HOLIDAY HOLIDAY
RESTDAY PAY PAY PAY PAY (WORKED DAY
(WORKED ON RD) (WORKED
ON RD) ON RD)

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
NIGHT DIFFERENTIAL OT HOURS
LEGAL SPECIAL
HOLIDAY REST DAY HOLIDAY
AND TOTAL ND REGULAR SPECIAL LEGAL PAY AND REST
HOLIDAY HOLIDAY
RESTDAY PAY PAY PAY PAY (WORKED DAY
(WORKED ON RD) (WORKED
ON RD) ON RD)

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
EMPLOYEE DEDUCTIONS
LEGAL
HOLIDAY
AND TOTAL TOTAL TOTAL
SSS PHILHEALTH HDMF
RESTDAY NDOT PAY GROSS PAY DEDUCTIONS
(WORKED
ON RD)

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
EDITABLE DO NOT EDIT EDITABLE DO NOT EDIT

PRIOR PERIOD INCOME ALLOWANCE


WITHHOLDING TAX NET PAY
ADJUSTMENTS BEFORE TAX S/OTHER
BENEFITS

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
DO NOT EDIT
COMPANY PAID BENEFITS

SSS ER

-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
SSS COMPENSATION TABLE UPDATED JANUARY 2021

LOW HIGH MSC ER EE TOTAL EC


0 3,249.99 3,000.00 255.00 135.00 390.00 10.00
3,250.00 3,749.99 3,500.00 297.50 157.50 455.00 10.00
3,750.00 4,249.99 4,000.00 340.00 180.00 520.00 10.00
4,250.00 4,749.99 4,500.00 382.50 202.50 585.00 10.00
4,750.00 5,249.99 5,000.00 425.00 225.00 650.00 10.00
5,250.00 5,749.99 5,500.00 467.50 247.50 715.00 10.00
5,750.00 6,249.99 6,000.00 510.00 270.00 780.00 10.00
6,250.00 6,749.99 6,500.00 552.50 292.50 845.00 10.00
6,750.00 7,249.99 7,000.00 595.00 315.00 910.00 10.00
7,250.00 7,749.99 7,500.00 637.50 337.50 975.00 10.00
7,750.00 8,249.99 8,000.00 680.00 360.00 1,040.00 10.00
8,250.00 8,749.99 8,500.00 722.50 382.50 1,105.00 10.00
8,750.00 9,249.99 9,000.00 765.00 405.00 1,170.00 10.00
9,250.00 9,749.99 9,500.00 807.50 427.50 1,235.00 10.00
9,750.00 10,249.99 10,000.00 850.00 450.00 1,300.00 10.00
10,250.00 10,749.99 10,500.00 892.50 472.50 1,365.00 10.00
10,750.00 11,249.99 11,000.00 935.00 495.00 1,430.00 10.00
11,250.00 11,749.99 11,500.00 977.50 517.50 1,495.00 10.00
11,750.00 12,249.99 12,000.00 1,020.00 540.00 1,560.00 10.00
12,250.00 12,749.99 12,500.00 1,062.50 562.50 1,625.00 10.00
12,750.00 13,249.99 13,000.00 1,105.00 585.00 1,690.00 10.00
13,250.00 13,749.99 13,500.00 1,147.50 607.50 1,755.00 10.00
13,750.00 14,249.99 14,000.00 1,190.00 630.00 1,820.00 10.00
14,250.00 14,749.99 14,500.00 1,232.50 652.50 1,885.00 10.00
14,750.00 15,249.99 15,000.00 1,275.00 675.00 1,950.00 30.00
15,250.00 15,749.99 15,500.00 1,317.50 697.50 2,015.00 30.00
15,750.00 16,249.99 16,000.00 1,360.00 720.00 2,080.00 30.00
16,250.00 16,749.99 16,500.00 1,402.50 742.50 2,145.00 30.00
16,750.00 17,249.99 17,000.00 1,445.00 765.00 2,210.00 30.00
17,250.00 17,749.99 17,500.00 1,487.50 787.50 2,275.00 30.00
17,750.00 18,249.99 18,000.00 1,530.00 810.00 2,340.00 30.00
18,250.00 18,749.99 18,500.00 1,572.50 832.50 2,405.00 30.00
18,750.00 19,249.99 19,000.00 1,615.00 855.00 2,470.00 30.00
19,250.00 19,749.99 19,500.00 1,657.50 877.50 2,535.00 30.00
19,750.00 20,249.99 20,000.00 1,700.00 900.00 2,600.00 30.00
20,250.00 20,749.99 20,000.00 1,742.50 922.50 2,665.00 30.00
20,750.00 21,249.99 20,000.00 1,785.00 945.00 2,730.00 30.00
21,250.00 21,749.99 20,000.00 1,827.50 967.50 2,795.00 30.00
21,750.00 22,249.99 20,000.00 1,870.00 990.00 2,860.00 30.00
22,250.00 22,749.99 20,000.00 1,912.50 1,012.50 2,925.00 30.00
22,750.00 23,249.99 20,000.00 1,955.00 1,035.00 2,990.00 30.00
23,250.00 23,749.99 20,000.00 1,997.50 1,057.50 3,055.00 30.00
23,750.00 24,249.99 20,000.00 2,040.00 1,080.00 3,120.00 30.00
24,250.00 24,749.99 20,000.00 2,082.50 1,102.50 3,185.00 30.00
24,750.00 OVER 20,000.00 2,125.00 1,125.00 3,250.00 30.00
WITHHOLDING TAX TABLE FOR COMPENSATION UNDER TR

TOTAL ER TOTAL EE TOTAL DUE


265.00 135.00 400.00
307.50 157.50 465.00
350.00 180.00 530.00
392.50 202.50 595.00
435.00 225.00 660.00
477.50 247.50 725.00
520.00 270.00 790.00
562.50 292.50 855.00
605.00 315.00 920.00
647.50 337.50 985.00
690.00 360.00 1,050.00
732.50 382.50 1,115.00
775.00 405.00 1,180.00
817.50 427.50 1,245.00
860.00 450.00 1,310.00
902.50 472.50 1,375.00
945.00 495.00 1,440.00
987.50 517.50 1,505.00
1,030.00 540.00 1,570.00
1,072.50 562.50 1,635.00
1,115.00 585.00 1,700.00
1,157.50 607.50 1,765.00
1,200.00 630.00 1,830.00
1,242.50 652.50 1,895.00
1,305.00 675.00 1,980.00
1,347.50 697.50 2,045.00
1,390.00 720.00 2,110.00
1,432.50 742.50 2,175.00
1,475.00 765.00 2,240.00
1,517.50 787.50 2,305.00
1,560.00 810.00 2,370.00
1,602.50 832.50 2,435.00
1,645.00 855.00 2,500.00 ACTUAL SSS CONTRIBUTION TABLE
1,687.50 877.50 2,565.00
1,730.00 900.00 2,630.00
1,772.50 922.50 2,695.00
1,815.00 945.00 2,760.00
1,857.50 967.50 2,825.00
1,900.00 990.00 2,890.00
1,942.50 1,012.50 2,955.00
1,985.00 1,035.00 3,020.00
2,027.50 1,057.50 3,085.00
2,070.00 1,080.00 3,150.00
2,112.50 1,102.50 3,215.00
2,155.00 1,125.00 3,280.00
R COMPENSATION UNDER TRAIN LAW
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE

FOR THE MONTH OF

EDITABLE DO NOT EDIT


EDITABLE
EMPLOYEE CODE EMPLOYEE NAME SSS NUMBER PHILPHEALTH NUMBER
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
HDMF NUMBER FIRST PERIOD SECOND PERIOD
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
SSS FILING PHILHEALTH FILING
MONTHLY PAY ER EE EC SSS TOTAL EMPLOYEE
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
HILHEALTH FILING HDMF FILING
EMPLOYER PHILHEALTH TOTAL EMPLOYEE EMPLOYER HDMF TOTAL
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE

FOR THE MONTH OF

NOTE: ONLY ENTER THE EMPLOYEE CODE, FIGURES WILL BE AUTO-GENERATED


DO NOT EDIT

EMPLOYEE CODE EMPLOYEE NAME TIN NUMBER FIRST PERIOD SECOND PERIOD

- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
EDITABLE DO NOT EDIT
TOTAL
ALLOWABLE COMPENSATION
DEDUCTIONS WITHHOLDING TAX
PAYABLE
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
SOURCE ACCOUNT NUMBER:
SOURCE ACCOUNT NAME:

ENTER EMPLOYEE NO. DO NOT EDIT AUTO-FILL IN PLACE


EMPLOYEE NUMBER ATM NUMBER EMPLOYEE NAME NET PAY
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
SOURCE ACCOUNT NUMBER:
SOURCE ACCOUNT NAME:

ENTER EMPLOYEE NO. DO NOT EDIT AUTO-FILL IN PLACE


EMPLOYEE NUMBER ATM NUMBER EMPLOYEE NAME NET PAY
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

EMPLOYEE NUMBER 1

EMPLOYEE NAME: vht PAY PERIOD

HOURS AMOUNT TOTAL HOURS AMOUNT TOTAL


NIGHT DIFF OT
BASIC PAY OVERTIME PAY - -
REG. HOURS WORKED - - SP. HOLIDAY OT - -
SP. HOLIDAY HOURS - - LEGAL HOLIDAY OT - -
LEGAL HOLIDAYS - - REST DAY OT - -
REST DAY WORK - - SP. HOLIDAY + RDOT - -
SP HOLIDAY + REST DAY - - LEGAL HOLIDAY +RDOT - -
LEGAL HOLIDAY + RD - - TOTAL OVERTIME -
TOTAL BASIC -
TOTAL GROSS PAY -
BASIC OVERTIME HOURS
OVERTIME PAY - - DEDUCTIONS:
SP. HOLIDAY OT - - PHILHEALTH -
LEGAL HOLIDAY OT - - PAGIBIG FUND -
REST DAY OT - - TOTAL DEDUCTIONS -
SP. HOLIDAY + RDOT - -
LEGAL HOLIDAY +RDOT - - ADJUSTMENTS
TOTAL OVERTIME - PRIOR PERIOD ADJ. -
TOTAL ADJUSTMENTS -
NIGHT DIFF HOURS
REG. HOURS WORKED - - INCOME BEFORE TAX -
SP. HOLIDAY HOURS - - WITHHOLDING TAX -
LEGAL HOLIDAYS - - ALLOWANCES -
REST DAY WORK - -
SP HOLIDAY + REST DAY - -
LEGAL HOLIDAY + RD - -
TOTAL NIGHT DIFF HOURS - NET PAYOUT -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

EMPLOYEE NUMBER

EMPLOYEE NAME: - PAY PERIOD

HOURS AMOUNT TOTAL HOURS AMOUNT TOTAL


NIGHT DIFF OT
BASIC PAY OVERTIME PAY - -
REG. HOURS WORKED - - SP. HOLIDAY OT - -
SP. HOLIDAY HOURS - - LEGAL HOLIDAY OT - -
LEGAL HOLIDAYS - - REST DAY OT - -
REST DAY WORK - - SP. HOLIDAY + RDOT - -
SP HOLIDAY + REST DAY - - LEGAL HOLIDAY +RDOT - -
LEGAL HOLIDAY + RD - - TOTAL OVERTIME -
TOTAL BASIC -
TOTAL GROSS PAY -
BASIC OVERTIME HOURS
OVERTIME PAY - - DEDUCTIONS:
SP. HOLIDAY OT - - PHILHEALTH -
LEGAL HOLIDAY OT - - PAGIBIG FUND -
REST DAY OT - - TOTAL DEDUCTIONS -
SP. HOLIDAY + RDOT - -
LEGAL HOLIDAY +RDOT - - ADJUSTMENTS
TOTAL OVERTIME - PRIOR PERIOD ADJ. -
TOTAL ADJUSTMENTS -
NIGHT DIFF HOURS
REG. HOURS WORKED - - INCOME BEFORE TAX -
SP. HOLIDAY HOURS - - WITHHOLDING TAX -
LEGAL HOLIDAYS - - ALLOWANCES -
REST DAY WORK - -
SP HOLIDAY + REST DAY - -
LEGAL HOLIDAY + RD - -
TOTAL NIGHT DIFF HOURS - NET PAYOUT -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

EMPLOYEE NUMBER 5

EMPLOYEE NAME: - PAY PERIOD

HOURS AMOUNT TOTAL HOURS AMOUNT TOTAL


NIGHT DIFF OT
BASIC PAY OVERTIME PAY - -
REG. HOURS WORKED - - SP. HOLIDAY OT - -
SP. HOLIDAY HOURS - - LEGAL HOLIDAY OT - -
LEGAL HOLIDAYS - - REST DAY OT - -
REST DAY WORK - - SP. HOLIDAY + RDOT - -
SP HOLIDAY + REST DAY - - LEGAL HOLIDAY +RDOT - -
LEGAL HOLIDAY + RD - - TOTAL OVERTIME -
TOTAL BASIC -
TOTAL GROSS PAY -
BASIC OVERTIME HOURS
OVERTIME PAY - - DEDUCTIONS:
SP. HOLIDAY OT - - PHILHEALTH -
LEGAL HOLIDAY OT - - PAGIBIG FUND -
REST DAY OT - - TOTAL DEDUCTIONS -
SP. HOLIDAY + RDOT - -
LEGAL HOLIDAY +RDOT - - ADJUSTMENTS
TOTAL OVERTIME - PRIOR PERIOD ADJ. -
TOTAL ADJUSTMENTS -
NIGHT DIFF HOURS
REG. HOURS WORKED - - INCOME BEFORE TAX -
SP. HOLIDAY HOURS - - WITHHOLDING TAX -
LEGAL HOLIDAYS - - ALLOWANCES -
REST DAY WORK - -
SP HOLIDAY + REST DAY - -
LEGAL HOLIDAY + RD - -
TOTAL NIGHT DIFF HOURS - NET PAYOUT -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

EMPLOYEE NUMBER

EMPLOYEE NAME: - PAY PERIOD

HOURS AMOUNT TOTAL HOURS AMOUNT TOTAL


NIGHT DIFF OT
BASIC PAY OVERTIME PAY - -
REG. HOURS WORKED - - SP. HOLIDAY OT - -
SP. HOLIDAY HOURS - - LEGAL HOLIDAY OT - -
LEGAL HOLIDAYS - - REST DAY OT - -
REST DAY WORK - - SP. HOLIDAY + RDOT - -
SP HOLIDAY + REST DAY - - LEGAL HOLIDAY +RDOT - -
LEGAL HOLIDAY + RD - - TOTAL OVERTIME -
TOTAL BASIC -
TOTAL GROSS PAY -
BASIC OVERTIME HOURS
OVERTIME PAY - - DEDUCTIONS:
SP. HOLIDAY OT - - SSS -
LEGAL HOLIDAY OT - - PHILHEALTH -
REST DAY OT - - PAGIBIG FUND -
SP. HOLIDAY + RDOT - - TOTAL DEDUCTIONS -
LEGAL HOLIDAY +RDOT - -
TOTAL OVERTIME - ADJUSTMENTS
PRIOR PERIOD ADJ. -
NIGHT DIFF HOURS TOTAL ADJUSTMENTS -
REG. HOURS WORKED - -
SP. HOLIDAY HOURS - - INCOME BEFORE TAX -
LEGAL HOLIDAYS - - WITHHOLDING TAX -
REST DAY WORK - - ALLOWANCES -
SP HOLIDAY + REST DAY - -
LEGAL HOLIDAY + RD - -
TOTAL NIGHT DIFF HOURS - NET PAYOUT -
COMPANY NAME
COMPANY ADDRESS
COMPANY PHONE NUMBER

EMPLOYEE NUMBER

EMPLOYEE NAME: - PAY PERIOD

HOURS AMOUNT TOTAL HOURS AMOUNT TOTAL


NIGHT DIFF OT
BASIC PAY OVERTIME PAY - -
REG. HOURS WORKED - - SP. HOLIDAY OT - -
SP. HOLIDAY HOURS - - LEGAL HOLIDAY OT - -
LEGAL HOLIDAYS - - REST DAY OT - -
REST DAY WORK - - SP. HOLIDAY + RDOT - -
SP HOLIDAY + REST DAY - - LEGAL HOLIDAY +RDOT - -
LEGAL HOLIDAY + RD - - TOTAL OVERTIME -
TOTAL BASIC -
TOTAL GROSS PAY -
BASIC OVERTIME HOURS
OVERTIME PAY - - DEDUCTIONS:
SP. HOLIDAY OT - - SSS -
LEGAL HOLIDAY OT - - PHILHEALTH -
REST DAY OT - - PAGIBIG FUND -
SP. HOLIDAY + RDOT - - TOTAL DEDUCTIONS -
LEGAL HOLIDAY +RDOT - -
TOTAL OVERTIME - ADJUSTMENTS
PRIOR PERIOD ADJ. -
NIGHT DIFF HOURS TOTAL ADJUSTMENTS -
REG. HOURS WORKED - -
SP. HOLIDAY HOURS - - INCOME BEFORE TAX -
LEGAL HOLIDAYS - - WITHHOLDING TAX -
REST DAY WORK - - ALLOWANCES -
SP HOLIDAY + REST DAY - -
LEGAL HOLIDAY + RD - -
TOTAL NIGHT DIFF HOURS - NET PAYOUT -

You might also like