Scribd
Upload
48 views4 pages

Payroll

The document contains a payroll report for 10 employees listing their name, rate per day, total hours needed, remaining hours, absences, times late, deductions, gross pay, income tax, and total deductions. It shows information such as Jamar Muslim Tashim's rate is ₱545 per day for 120 total hours needed and they had 1 absence and were late 34 times totaling 1 hour. Their gross pay was ₱7,630.56 with income tax of ₱228.92.

Uploaded by

I Love Lyrics
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
48 views4 pages

Payroll

The document contains a payroll report for 10 employees listing their name, rate per day, total hours needed, remaining hours, absences, times late, deductions, gross pay, income tax, and total deductions. It shows information such as Jamar Muslim Tashim's rate is ₱545 per day for 120 total hours needed and they had 1 absence and were late 34 times totaling 1 hour. Their gross pay was ₱7,630.56 with income tax of ₱228.92.

Uploaded by

I Love Lyrics
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
You are on page 1/ 4

Employe

No. Employee Name Rate/Day Total Hour Needed


1 Jamar Muslim Tashim ₱ 545.00 120
2 Arvy Mapagmahal Togonon ₱ 545.00 120
3 Airemar Nam4m4Ril Mayor ₱ 545.00 120
4 BhoeXcZ Franz Cabañes ₱ 545.00 120
5 Exkalamato Felix ₱ 545.00 120
6 prangkalamatik Goldilocks ₱ 545.00 120
7 Rustimatom omega ₱ 545.00 120
8 Tramelitik Speedy ₱ 545.00 120
9 Embastong Certifiedism ₱ 545.00 120
10 Motarikalampo Safetyer ₱ 545.00 120
Employee Payroll
Remaining Hours Absent late Total time late other Deduction
112 1 34 1 hour ₱ 381.53
104 2 31 1 hour ₱ 354.28
96 3 1 30 minutes ₱ 327.02
40 10 31 1 hour ₱ 136.26
88 4 33 1 hour ₱ 299.77
80 5 30 30 minutes ₱ 272.52
72 6 38 1 hour ₱ 245.27
120 0 0 ₱ 408.78
96 3 15 30 minutes ₱ 327.02
80 5 8 30 minutes ₱ 272.52
gross pay Income tax net pay Total absent deduction
₱ 7,630.56 ₱ 228.92 #VALUE! ₱ 545.00
₱ 7,085.52 ₱ 212.57 #VALUE! ₱ 1090.00
₱ 6,540.48 ₱ 196.21 #VALUE! ₱ 1635.00
₱ 2,725.20 ₱ 81.76 #VALUE! ₱ 5450.00
₱ 5,995.44 ₱ 179.86 #VALUE! ₱ 2180.00
₱ 5,450.40 ₱ 163.51 #VALUE! ₱ 2725.00
₱ 4,905.36 ₱ 147.16 #VALUE! ₱ 3270.00
₱ 8,175.60 ₱ 245.27 ₱ 7,521.55 0
₱ 6,540.48 ₱ 196.21 #VALUE! ₱ 1635.00
₱ 5,450.40 ₱ 163.51 #VALUE! ₱ 2725.00
Total late deduction Deducted to Total Hours
₱ 68.13 8
₱ 68.13 16
₱ 34.07 24
₱ 68.13 80
₱ 68.13 32
₱ 34.07 40
₱ 68.13 48
0 0
₱ 34.07 24
₱ 34.07 40

You might also like