Scribd
Upload
103 views2 pages

Janiola Hardware Employee Payroll

The document shows the payroll details of 20 employees of Janiola Hardware for the month. It includes information such as employee name and ID, daily rate, total days and hours worked, overtime rate and hours, overtime and gross pay, income tax deductions, other deductables and net pay. The total overtime pay for all employees was ₱59,960 and the total gross pay was ₱502,760 for the month. Income tax was deducted from employees earning over ₱25,000 as per company rules.

Uploaded by

darfrackz
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
103 views2 pages

Janiola Hardware Employee Payroll

The document shows the payroll details of 20 employees of Janiola Hardware for the month. It includes information such as employee name and ID, daily rate, total days and hours worked, overtime rate and hours, overtime and gross pay, income tax deductions, other deductables and net pay. The total overtime pay for all employees was ₱59,960 and the total gross pay was ₱502,760 for the month. Income tax was deducted from employees earning over ₱25,000 as per company rules.

Uploaded by

darfrackz
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

Janiola Hardware

Overtime Total
Employee Daily Total Total hours Overtime
Employee Name Rate(Per Overtime Gross Pay Income Tax
ID Rate Day Worked Pay
Hour) Hours
1 Daryll Jade S. Asa 500 24 192 50 10 500 ₱12,500.00 0.00
2 Danielle Simbajon 1000 24 192 60 6 360 ₱24,360.00 0.00
3 Jamaica Simbajon 1500 24 192 50 5 250 ₱36,250.00 9,062.50
4 Jayson Gamutan 1000 24 192 50 4 200 ₱24,200.00 0.00
5 Ma. Ellaine Ayano 500 24 192 50 4 200 ₱12,200.00 0.00
6 Terry Agujar 800 24 192 50 4 200 ₱19,400.00 0.00
7 Norma Coquilla 800 24 192 50 4 200 ₱19,400.00 0.00
8 Chona M. Padillo 1500 24 192 50 10 500 ₱36,500.00 9,125.00
9 Rebecca Tubo 800 24 192 50 4 200 ₱19,400.00 0.00
10 Jocil Saludo 800 24 192 50 7 350 ₱19,550.00 0.00
11 Socorin Jill 800 24 192 50 4 200 ₱19,400.00 0.00
12 Shiela Tadlap 1500 24 192 50 11 550 ₱36,550.00 9,137.50
13 Randy Simbajon 800 24 192 50 6 300 ₱19,500.00 0.00
14 Joy Tumulak 1500 24 192 50 4 200 ₱36,200.00 9,050.00
15 Jobe Udtohan 1500 24 192 50 4 200 ₱36,200.00 9,050.00
16 Evelyn Wahing 800 24 192 50 4 200 ₱19,400.00 0.00
17 Concepcion Tagaan 1500 24 192 50 4 200 ₱36,200.00 9,050.00
18 Lhoreen Rubia 800 24 192 50 15 750 ₱19,950.00 0.00
19 Maricel Rabino 1500 24 192 50 4 200 ₱36,200.00 9,050.00
20 Agnes Roma 800 24 192 50 4 200 ₱19,400.00 0.00
Total 20700 480 3840 1010 118 5960 ₱502,760.00 63525

*Note: If the salary not excedeed to 25000 no income tax deducted. It is exceeded income tax will be 25%
Other Deductables Net Pay

500 ₱12,000.00
1000 ₱23,360.00
1200 ₱25,987.50
1000 ₱23,200.00
500 ₱11,700.00
500 ₱18,900.00
500 ₱18,900.00
500 ₱26,875.00
500 ₱18,900.00
500 ₱19,050.00
500 ₱18,900.00
500 ₱26,912.50
500 ₱19,000.00
500 ₱26,650.00
500 ₱26,650.00
500 ₱18,900.00
500 ₱26,650.00
500 ₱19,450.00
500 ₱26,650.00
500 ₱18,900.00
11700 ₱ 427,535.00

You might also like