Scribd
Upload
32 views5 pages

Employee Payroll Summary Report

The document outlines the payroll details for employees, including their hourly wages, hours worked, and total pay for specific dates in January. It provides a summary of maximum, minimum, and average wages, as well as total earnings for the month. Additionally, it includes overtime hours and bonuses, resulting in a comprehensive overview of employee compensation.

Uploaded by

jenishbbhanushali
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
32 views5 pages

Employee Payroll Summary Report

The document outlines the payroll details for employees, including their hourly wages, hours worked, and total pay for specific dates in January. It provides a summary of maximum, minimum, and average wages, as well as total earnings for the month. Additionally, it includes overtime hours and bonuses, resulting in a comprehensive overview of employee compensation.

Uploaded by

jenishbbhanushali
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

employee payroll Mr.

jenish
house worked
first name last name hourly wages 1-Jan 8-Jan 15-Jan
den mose ₹ 100.00 40 49 43
ben pose ₹ 90.00 48 29 54
men late ₹ 120.00 39 43 34
nate ate ₹ 190.00 26 40 23
mate dog ₹ 240.00 45 21 26
gate cow ₹ 49.00 50 35 49
tate lion ₹ 89.00 59 50 58
late jackal ₹ 71.00 43 33 36
bill cat ₹ 31.00 24 19 25
jack mat ₹ 99.00 51 39 29
mike hat ₹ 149.00 34 45 36
mouse track ₹ 175.00 39 32 57
lion train ₹ 89.00 40 45 34
tiger car ₹ 60.00 35 55 23
dog bike ₹ 40.00 54 34 19
pose plane ₹ 76.00 29 35 46
dose race ₹ 49.00 42 34 37

max ₹ 240.00 59.00 55.00 58.00


min ₹ 31.00 24.00 19.00 19.00
average ₹ 101.00 41.06 37.53 37.00
total ₹ 1,717.00 698.00 638.00 629.00
overtime hours
22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan
32 34 0 9 3 0
45 23 8 0 14 5
52 45 0 3 0 12
32 34 0 0 0 0
34 56 5 0 0 0
47 45 10 0 9 7
47 37 19 10 18 7
50 28 3 0 0 10
25 29 0 0 0 0
27 19 11 0 0 0
18 25 0 5 0 0
39 39 0 0 17 0
40 49 0 5 0 0
51 56 0 15 0 11
36 45 14 0 0 0
25 45 0 0 6 0
35 34 2 0 0 0

52.00 56.00 19.00 15.00 18.00 12.00


18.00 19.00 0.00 0.00 0.00 0.00
37.35 37.82 4.24 2.76 3.94 3.06
635.00 643.00 72.00 47.00 67.00 52.00
pay
29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan
0 ₹ 4,000.00 ₹ 4,900.00 ₹ 4,300.00 ₹ 3,200.00 ₹ 3,400.00
0 ₹ 4,320.00 ₹ 1,392.00 ₹ 1,566.00 ₹ 2,430.00 ₹ 1,035.00
5 ₹ 4,680.00 ₹ 1,677.00 ₹ 1,462.00 ₹ 1,768.00 ₹ 2,340.00
0 ₹ 4,940.00 ₹ 1,040.00 ₹ 920.00 ₹ 736.00 ₹ 1,088.00
16 ₹ 10,800.00 ₹ 945.00 ₹ 546.00 ₹ 884.00 ₹ 1,904.00
5 ₹ 2,450.00 ₹ 1,750.00 ₹ 1,715.00 ₹ 2,303.00 ₹ 2,115.00
0 ₹ 5,251.00 ₹ 2,950.00 ₹ 2,900.00 ₹ 2,726.00 ₹ 1,739.00
0 ₹ 3,053.00 ₹ 1,419.00 ₹ 1,188.00 ₹ 1,800.00 ₹ 1,400.00
0 ₹ 744.00 ₹ 456.00 ₹ 475.00 ₹ 625.00 ₹ 725.00
0 ₹ 5,049.00 ₹ 1,989.00 ₹ 1,131.00 ₹ 783.00 ₹ 513.00
0 ₹ 5,066.00 ₹ 1,530.00 ₹ 1,620.00 ₹ 648.00 ₹ 450.00
0 ₹ 6,825.00 ₹ 1,248.00 ₹ 1,824.00 ₹ 2,223.00 ₹ 1,521.00
9 ₹ 3,560.00 ₹ 1,800.00 ₹ 1,530.00 ₹ 1,360.00 ₹ 1,960.00
16 ₹ 2,100.00 ₹ 1,925.00 ₹ 1,265.00 ₹ 1,173.00 ₹ 2,856.00
5 ₹ 2,160.00 ₹ 1,836.00 ₹ 646.00 ₹ 684.00 ₹ 1,620.00
5 ₹ 2,204.00 ₹ 1,015.00 ₹ 1,610.00 ₹ 1,150.00 ₹ 1,125.00
0 ₹ 2,058.00 ₹ 1,428.00 ₹ 1,258.00 ₹ 1,295.00 ₹ 1,190.00

16.00 ₹ 10,800.00 ₹ 4,900.00 ₹ 4,300.00 ₹ 3,200.00 ₹ 3,400.00


0.00 ₹ 744.00 ₹ 456.00 ₹ 475.00 ₹ 625.00 ₹ 450.00
3.59 ₹ 4,074.12 ₹ 1,723.53 ₹ 1,526.82 ₹ 1,516.94 ₹ 1,587.12
61.00 ₹ 69,260.00 ₹ 29,300.00 ₹ 25,956.00 ₹ 25,788.00 ₹ 26,981.00
overtime bonus total
1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan
₹ - ₹ 450.00 ₹ 150.00 ₹ - ₹ - ₹ 4,000.00
₹ 360.00 ₹ - ₹ 630.00 ₹ 225.00 ₹ - ₹ 4,680.00
₹ - ₹ 180.00 ₹ - ₹ 720.00 ₹ 300.00 ₹ 4,680.00
₹ - ₹ - ₹ - ₹ - ₹ - ₹ 4,940.00
₹ 600.00 ₹ - ₹ - ₹ - ₹ 1,920.00 ₹ 11,400.00
₹ 245.00 ₹ - ₹ 220.50 ₹ 171.50 ₹ 122.50 ₹ 2,695.00
₹ 845.50 ₹ 445.00 ₹ 801.00 ₹ 311.50 ₹ - ₹ 6,096.50
₹ 106.50 ₹ - ₹ - ₹ 355.00 ₹ - ₹ 3,159.50
₹ - ₹ - ₹ - ₹ - ₹ - ₹ 744.00
₹ 544.50 ₹ - ₹ - ₹ - ₹ - ₹ 5,593.50
₹ - ₹ 372.50 ₹ - ₹ - ₹ - ₹ 5,066.00
₹ - ₹ - ₹ 1,487.50 ₹ - ₹ - ₹ 6,825.00
₹ - ₹ 222.50 ₹ - ₹ - ₹ 400.50 ₹ 3,560.00
₹ - ₹ 450.00 ₹ - ₹ 330.00 ₹ 480.00 ₹ 2,100.00
₹ 280.00 ₹ - ₹ - ₹ - ₹ 100.00 ₹ 2,440.00
₹ - ₹ - ₹ 228.00 ₹ - ₹ 190.00 ₹ 2,204.00
₹ 49.00 ₹ - ₹ - ₹ - ₹ - ₹ 2,107.00

₹ 845.50 ₹ 450.00 ₹ 1,487.50 ₹ 720.00 ₹ 1,920.00 ₹ 11,400.00


₹ - ₹ - ₹ - ₹ - ₹ - ₹ 744.00
₹ 178.26 ₹ 124.71 ₹ 206.88 ₹ 124.29 ₹ 206.65 ₹ 4,252.38
₹ 3,030.50 ₹ 2,120.00 ₹ 3,517.00 ₹ 2,113.00 ₹ 3,513.00 ₹ 72,290.50
jan pay
8-Jan 15-Jan 22-Jan 29-Jan
₹ 5,350.00 ₹ 4,450.00 ₹ 3,200.00 ₹ 3,400.00 ₹ 20,400.00
₹ 1,392.00 ₹ 2,196.00 ₹ 2,655.00 ₹ 1,035.00 ₹ 11,958.00
₹ 1,857.00 ₹ 1,462.00 ₹ 2,488.00 ₹ 2,640.00 ₹ 13,127.00
₹ 1,040.00 ₹ 920.00 ₹ 736.00 ₹ 1,088.00 ₹ 8,724.00
₹ 945.00 ₹ 546.00 ₹ 884.00 ₹ 3,824.00 ₹ 17,599.00
₹ 1,750.00 ₹ 1,935.50 ₹ 2,474.50 ₹ 2,237.50 ₹ 11,092.50
₹ 3,395.00 ₹ 3,701.00 ₹ 3,037.50 ₹ 1,739.00 ₹ 17,969.00
₹ 1,419.00 ₹ 1,188.00 ₹ 2,155.00 ₹ 1,400.00 ₹ 9,321.50
₹ 456.00 ₹ 475.00 ₹ 625.00 ₹ 725.00 ₹ 3,025.00
₹ 1,989.00 ₹ 1,131.00 ₹ 783.00 ₹ 513.00 ₹ 10,009.50
₹ 1,902.50 ₹ 1,620.00 ₹ 648.00 ₹ 450.00 ₹ 9,686.50
₹ 1,248.00 ₹ 3,311.50 ₹ 2,223.00 ₹ 1,521.00 ₹ 15,128.50
₹ 2,022.50 ₹ 1,530.00 ₹ 1,360.00 ₹ 2,360.50 ₹ 10,833.00
₹ 2,375.00 ₹ 1,265.00 ₹ 1,503.00 ₹ 3,336.00 ₹ 10,579.00
₹ 1,836.00 ₹ 646.00 ₹ 684.00 ₹ 1,720.00 ₹ 7,326.00
₹ 1,015.00 ₹ 1,838.00 ₹ 1,150.00 ₹ 1,315.00 ₹ 7,522.00
₹ 1,428.00 ₹ 1,258.00 ₹ 1,295.00 ₹ 1,190.00 ₹ 7,278.00

₹ 5,350.00 ₹ 4,450.00 ₹ 3,200.00 ₹ 3,824.00 ₹ 20,400.00


₹ 456.00 ₹ 475.00 ₹ 625.00 ₹ 450.00 ₹ 3,025.00
₹ 1,848.24 ₹ 1,733.71 ₹ 1,641.24 ₹ 1,793.76 ₹ 11,269.32
₹ 31,420.00 ₹ 29,473.00 ₹ 27,901.00 ₹ 30,494.00 ₹ 191,578.50

You might also like