Updated Payroll File
Updated Payroll File
Updated Payroll File
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
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
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
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
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
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
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
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
DO NOT EDIT
COMPANY PAID BENEFITS
SSS ER
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
SSS COMPENSATION TABLE UPDATED JANUARY 2021
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:
EMPLOYEE NUMBER 1
EMPLOYEE NUMBER
EMPLOYEE NUMBER 5
EMPLOYEE NUMBER
EMPLOYEE NUMBER