Medicare Levy | = | 1.50% | ||||||||||||||||
Period ending | = | 05-10-2018 | ||||||||||||||||
Overtime Rate | = | 1.5 | ||||||||||||||||
Total Gross Pay for the company for this pay period | = | $54,463.86 | ||||||||||||||||
Total Net Pay for the company for this pay period | = | $35,192.08 | ||||||||||||||||
Total tax and payments withheld from employees, excluding superannuation for this pay period | = | $19,271.78 | ||||||||||||||||
Total superannuation liability for the company for this pay period | = | $4,923.76 | ||||||||||||||||
Number of employees who took sick hours in week 1 pay period | = | 3 | ||||||||||||||||
Number of employees who took sick hours in week 2 pay period | = | 2 | ||||||||||||||||
Number of employees currently at work | = | 22 | ||||||||||||||||
Number of hours of overtime worked in week 1 | = | 63.00 | ||||||||||||||||
Number of hours of overtime worked in week 2 | = | 53.00 | ||||||||||||||||
Number of employees worked overtime in week 1 | = | 14 | ||||||||||||||||
Number of employees worked overtime in week 2 | = | 16 | ||||||||||||||||
Employees worked 7 hours or more overtime in this pay period | ||||||||||||||||||
Given Name | Last Name | Week 1- Overtime hours | Week 2- Overtime hours | |||||||||||||||
Harish | Aeddula | 10 | 2 | |||||||||||||||
Arif | Arora | 7 | 5 | |||||||||||||||
John | Smith | 5 | 6 | |||||||||||||||
Nishan | Bista | 3 | 4 | |||||||||||||||
Toby Peter | Wong | 6 | 2 | |||||||||||||||
Aaron | Hunter | 7 | 4 | |||||||||||||||
Robert | Taylor-Jones | 5 | 4 | |||||||||||||||
Paul | Batten | 6 | 4 | |||||||||||||||
Mohammed Mujtaba | Ottal | 4 | 4 | |||||||||||||||
Employee ID | First Name | Last Name | Address | City | State | Postcode | State Postcode | Phone Number | Hourly wage | Income tax | Superannuation Rate | Medical insurance | Other Regular Deductions | Total Tax Rate | Total Regular Deductions | |||
24 | Kiran | Kiran | Achhami | Achhami | 37 Weppner Drive | 37 Weppner Drive | Belford | Nsw | 2335 | NSW 2335 | 0494780929 | $29.45 | 25.00% | 1.00% | $23.00 | $22.00 | 26.50% | $45.00 |
1 | harish | Harish | Aeddula | Aeddula | 15 Salomon Lane | 15 Salomon Lane | Belconnen | act | 2617 | ACT 2617 | 0401916011 | $17.00 | 28.00% | 9.50% | $50.00 | $5.00 | 29.50% | $55.00 |
3 | Arif | Arif | Arora | Arora | 931 Ferguson Circuit | 931 Ferguson Circuit | Bridgewater | VIC | 3516 | VIC 3516 | 0449124893 | $36.50 | 30.00% | 18.00% | $50.00 | $15.00 | 31.50% | $65.00 |
16 | paul | Paul | batten | Batten | 49 Macdonald Boulevard | 49 Macdonald Boulevard | Bray Park | QLD | 4500 | QLD 4500 | 0448378288 | $28.75 | 25.00% | 1.00% | $23.00 | $35.00 | 26.50% | $58.00 |
12 | Lovish | Lovish | Bhimavarapu | Bhimavarapu | 3 Field Street | 3 Field Street | Iluka | NSW | 2466 | NSW 2466 | 0451108913 | $31.20 | 35.00% | 9.50% | $50.00 | $14.00 | 36.50% | $64.00 |
11 | Nishan | Nishan | bista | Bista | 6 Creamer Close | 6 Creamer Close | Avon plains | VIC | 3477 | VIC 3477 | 0477905738 | $21.85 | 30.00% | 9.50% | $50.00 | $47.00 | 31.50% | $97.00 |
17 | Michael | Michael | bond | Bond | 35 Westcott Boulevard | 35 Westcott Boulevard | Iluka | NSW | 2466 | NSW 2466 | $19.65 | 25.00% | 1.00% | $23.00 | $36.00 | 26.50% | $59.00 | |
19 | Rehan shah | Rehan Shah | Cabillo | Cabillo | 10 Robertson Close | 10 Robertson Close | Nayook | vic | 3832 | VIC 3832 | 0415916843 | $26.96 | 25.00% | 1.00% | $23.00 | $20.00 | 26.50% | $43.00 |
10 | Ting | Ting | Fu | Fu | 40 Ball Close | 40 Ball Close | Belford | nsw | 2335 | NSW 2335 | 0487738599 | $21.85 | 30.00% | 9.50% | $50.00 | $25.00 | 31.50% | $75.00 |
14 | Aaron | Aaron | Hunter | Hunter | 1 Allen Drive | 1 Allen Drive | Belford | NSW | 2335 | NSW 2335 | 0480280872 | $33.87 | 30.00% | 18.00% | $45.00 | $20.00 | 31.50% | $65.00 |
9 | alice | Alice | jones | Jones | 8 Wieck Close | 8 Wieck Close | Belford | nsw | 2335 | NSW 2335 | 0470105100 | $25.75 | 30.00% | 9.50% | $55.00 | $33.00 | 31.50% | $88.00 |
22 | navjot | Navjot | kaur | Kaur | 76 Ryan Avenue | 76 Ryan Avenue | Nayook | VIC | 3832 | VIC 3832 | 0427188473 | $27.35 | 25.00% | 1.00% | $23.00 | $15.00 | 26.50% | $38.00 |
25 | Sungsam | Sungsam | Li | Li | 9 Buckle Crescent | 9 Buckle Crescent | Bamboo | QLD | 4873 | QLD 4873 | $23.25 | 25.00% | 1.00% | $23.00 | $24.00 | 26.50% | $47.00 | |
23 | urgen | Urgen | Maan | Maan | 51 Burton Crescent | 51 Burton Crescent | Alleena | NSW | 2671 | NSW 2671 | 0462804166 | $26.45 | 25.00% | 1.00% | $23.00 | $15.00 | 26.50% | $38.00 |
6 | karl Onga | Karl Onga | Moes | Moes | 6 Alwabel Road | 6 Alwabel Road | Aberfoyle | NSW | 2350 | NSW 2350 | 0401762725 | $22.20 | 28.00% | 9.50% | $50.00 | $14.00 | 29.50% | $64.00 |
7 | Pramod kumar | Pramod Kumar | Mudigonda | Mudigonda | 45 townes Way | 45 Townes Way | Aberfoyle | Nsw | 2350 | NSW 2350 | $21.80 | 30.00% | 9.50% | $50.00 | $17.00 | 31.50% | $67.00 | |
20 | Mohammed mujtaba | Mohammed Mujtaba | Ottal | Ottal | 7 Harrison Close | 7 Harrison Close | Bray Park | qld | 4500 | QLD 4500 | 0464152018 | $26.20 | 25.00% | 1.00% | $23.00 | $18.00 | 26.50% | $41.00 |
8 | Tianke | Tianke | Shah | Shah | 225 Yegiora Boulevard | 225 Yegiora Boulevard | bamboo | qld | 4873 | QLD 4873 | 0412230665 | $21.35 | 30.00% | 9.50% | $50.00 | $22.00 | 31.50% | $72.00 |
18 | Vanja | Vanja | Shin | Shin | 33 Karl boulevard | 33 Karl Boulevard | Bray park | Qld | 4500 | QLD 4500 | 0468532027 | $22.23 | 25.00% | 1.00% | $23.00 | $20.00 | 26.50% | $43.00 |
2 | Harpreet | Harpreet | Singh | Singh | 37 Morris Court | 37 Morris Court | Bridgewater | Vic | 3516 | VIC 3516 | 0477662767 | $22.00 | 28.00% | 18.00% | $50.00 | $10.00 | 29.50% | $60.00 |
21 | tamanna | Tamanna | Singh | Singh | 38 Duffy Circuit | 38 Duffy Circuit | Areegra | VIC | 3480 | VIC 3480 | 0491575433 | $23.75 | 25.00% | 1.00% | $23.00 | $16.00 | 26.50% | $39.00 |
4 | john | John | Smith | Smith | 64 Coy Boulevard | 64 Coy Boulevard | Caliph | SA | 5310 | SA 5310 | 0444344327 | $42.00 | 32.00% | 18.00% | $50.00 | $20.00 | 33.50% | $70.00 |
5 | rosan | Rosan | subedi | Subedi | 773 Harrison Circuit | 773 Harrison Circuit | Black Hills | tas | 7140 | TAS 7140 | 0427580782 | $21.87 | 28.00% | 18.00% | $50.00 | $5.00 | 29.50% | $55.00 |
15 | Robert | Robert | taylor-Jones | Taylor-Jones | 9 Quade Street | 9 Quade Street | Aberfoyle | nsw | 2350 | NSW 2350 | 0443107622 | $41.36 | 28.00% | 18.00% | $50.00 | $10.00 | 29.50% | $60.00 |
13 | Toby Peter | Toby Peter | wong | Wong | 493 Lane Avenue | 493 Lane Avenue | Aberfoyle | NSW | 2350 | NSW 2350 | 0466896974 | $28.65 | 27.00% | 9.50% | $50.00 | $15.00 | 28.50% | $65.00 |
Period Ending | 05-10-2018 | |||||||||||||||||
Week 1 | ||||||||||||||||||
Employee ID | Given Name | Last Name | Regular Hours Worked | Vacation Hours | Sick Hours | Overtime Hours | Overtime Rate | Gross Pay | Deduction | Total Taxes and Deductions | Superannuation Amount | Net Pay | Whether Sick Pay | |||||
1 | Harish | Aeddula | 37.50 | 0.00 | 0.00 | 10.00 | $25.50 | $892.50 | $0.00 | $318.29 | $84.79 | $574.21 | ||||||
2 | Harpreet | Singh | 37.50 | 0.00 | 0.00 | 2.00 | $33.00 | $891.00 | $35.00 | $357.85 | $160.38 | $533.16 | ||||||
3 | Arif | Arora | 37.50 | 0.00 | 0.00 | 7.00 | $54.75 | $1,752.00 | $0.00 | $616.88 | $315.36 | $1,135.12 | ||||||
4 | John | Smith | 37.50 | 0.00 | 0.00 | 5.00 | $63.00 | $1,890.00 | $0.00 | $703.15 | $340.20 | $1,186.85 | ||||||
5 | Rosan | Subedi | 0.00 | 0.00 | 37.50 | 0.00 | $32.81 | $820.13 | $0.00 | $296.94 | $147.62 | $523.19 | Sick Pay | |||||
6 | Karl Onga | Moes | 15.00 | 7.50 | 0.00 | 0.00 | $33.30 | $499.50 | $0.00 | $211.35 | $47.45 | $288.15 | ||||||
7 | Pramod Kumar | Mudigonda | 37.50 | 0.00 | 0.00 | 1.00 | $32.70 | $850.20 | $0.00 | $334.81 | $80.77 | $515.39 | ||||||
8 | Tianke | Shah | 0.00 | 37.50 | 0.00 | 0.00 | $32.03 | $800.63 | $0.00 | $324.20 | $76.06 | $476.43 | ||||||
9 | Alice | Jones | 37.50 | 0.00 | 0.00 | 0.00 | $38.63 | $965.63 | $0.00 | $392.17 | $91.73 | $573.45 | ||||||
10 | Ting | Fu | 0.00 | 37.50 | 0.00 | 0.00 | $32.78 | $819.38 | $50.00 | $383.10 | $77.84 | $436.27 | ||||||
11 | Nishan | Bista | 37.50 | 0.00 | 0.00 | 3.00 | $32.78 | $917.70 | $0.00 | $386.08 | $87.18 | $531.62 | ||||||
12 | Lovish | Bhimavarapu | 26.00 | 0.00 | 11.50 | 0.00 | $46.80 | $1,170.00 | $0.00 | $491.05 | $111.15 | $678.95 | Sick Pay | |||||
13 | Toby Peter | Wong | 37.50 | 0.00 | 0.00 | 6.00 | $42.98 | $1,332.23 | $0.00 | $444.68 | $126.56 | $887.54 | ||||||
14 | Aaron | Hunter | 37.50 | 0.00 | 0.00 | 7.00 | $50.81 | $1,625.76 | $0.00 | $577.11 | $292.64 | $1,048.65 | ||||||
15 | Robert | Taylor-Jones | 37.50 | 0.00 | 0.00 | 5.00 | $62.04 | $1,861.20 | $0.00 | $609.05 | $335.02 | $1,252.15 | ||||||
16 | Paul | Batten | 37.50 | 0.00 | 0.00 | 6.00 | $43.13 | $1,336.88 | $0.00 | $412.27 | $13.37 | $924.60 | ||||||
17 | Michael | Bond | 37.50 | 0.00 | 0.00 | 3.00 | $29.48 | $825.30 | $0.00 | $277.70 | $8.25 | $547.60 | ||||||
18 | Vanja | Shin | 37.50 | 0.00 | 0.00 | 0.00 | $33.35 | $833.63 | $0.00 | $263.91 | $8.34 | $569.71 | ||||||
19 | Rehan Shah | Cabillo | 37.50 | 0.00 | 0.00 | 0.00 | $40.44 | $1,011.00 | $0.00 | $310.92 | $10.11 | $700.09 | ||||||
20 | Mohammed Mujtaba | Ottal | 37.50 | 0.00 | 0.00 | 4.00 | $39.30 | $1,139.70 | $20.00 | $363.02 | $11.40 | $776.68 | ||||||
21 | Tamanna | Singh | 37.50 | 0.00 | 0.00 | 2.00 | $35.63 | $961.88 | $20.00 | $313.90 | $9.62 | $647.98 | ||||||
22 | Navjot | Kaur | 37.50 | 0.00 | 0.00 | 0.00 | $41.03 | $1,025.63 | $0.00 | $309.79 | $10.26 | $715.83 | ||||||
23 | Urgen | Maan | 37.50 | 0.00 | 0.00 | 2.00 | $39.68 | $1,071.23 | $10.00 | $331.87 | $10.71 | $739.35 | ||||||
24 | Kiran | Achhami | 37.50 | 0.00 | 0.00 | 0.00 | $44.18 | $1,104.38 | $0.00 | $337.66 | $11.04 | $766.72 | ||||||
25 | Sungsam | Li | 0.00 | 0.00 | 37.50 | 0.00 | $34.88 | $871.88 | $0.00 | $278.05 | $8.72 | $593.83 | Sick Pay | |||||
Period Ending | 05-10-2018 | |||||||||||||||||
Week 2 | ||||||||||||||||||
Employee ID | Given Name | Last Name | Regular Hours Worked | Vacation Hours | Sick Hours | Overtime Hours | Overtime Rate | Gross Pay | Deduction | Total Taxes and Deductions | Superannuation Amount | Net Pay | Whether Sick Pay | |||||
1 | Harish | Aeddula | 37.50 | 0.00 | 0.00 | 2.00 | $25.50 | $688.50 | $0.00 | $258.11 | $65.41 | $430.39 | ||||||
2 | Harpreet | Singh | 37.50 | 0.00 | 0.00 | 0.00 | $33.00 | $825.00 | $35.00 | $338.38 | $148.50 | $486.63 | ||||||
3 | Arif | Arora | 37.50 | 0.00 | 0.00 | 5.00 | $54.75 | $1,642.50 | $0.00 | $582.39 | $295.65 | $1,060.11 | ||||||
4 | John | Smith | 37.50 | 0.00 | 0.00 | 6.00 | $63.00 | $1,953.00 | $0.00 | $724.26 | $351.54 | $1,228.75 | ||||||
5 | Rosan | Subedi | 37.50 | 0.00 | 0.00 | 2.00 | $32.81 | $885.74 | $0.00 | $316.29 | $159.43 | $569.44 | ||||||
6 | Karl Onga | Moes | 22.50 | 15.00 | 0.00 | 2.00 | $33.30 | $899.10 | $0.00 | $329.23 | $85.41 | $569.87 | ||||||
7 | Pramod Kumar | Mudigonda | 37.50 | 0.00 | 0.00 | 3.00 | $32.70 | $915.60 | $0.00 | $355.41 | $86.98 | $560.19 | ||||||
8 | Tianke | Shah | 37.50 | 0.00 | 0.00 | 2.00 | $32.03 | $864.68 | $0.00 | $344.37 | $82.14 | $520.30 | ||||||
9 | Alice | Jones | 37.50 | 0.00 | 0.00 | 0.00 | $38.63 | $965.63 | $0.00 | $392.17 | $91.73 | $573.45 | ||||||
10 | Ting | Fu | 0.00 | 37.50 | 0.00 | 0.00 | $32.78 | $819.38 | $50.00 | $383.10 | $77.84 | $436.27 | ||||||
11 | Nishan | Bista | 37.50 | 0.00 | 0.00 | 4.00 | $32.78 | $950.48 | $0.00 | $396.40 | $90.30 | $554.08 | ||||||
12 | Lovish | Bhimavarapu | 26.00 | 0.00 | 11.50 | 0.00 | $46.80 | $1,170.00 | $0.00 | $491.05 | $111.15 | $678.95 | Sick Pay | |||||
13 | Toby Peter | Wong | 37.50 | 0.00 | 0.00 | 2.00 | $42.98 | $1,160.33 | $0.00 | $395.69 | $110.23 | $764.63 | ||||||
14 | Aaron | Hunter | 37.50 | 0.00 | 0.00 | 4.00 | $50.81 | $1,473.35 | $0.00 | $529.10 | $265.20 | $944.24 | ||||||
15 | Robert | Taylor-Jones | 37.50 | 0.00 | 0.00 | 4.00 | $62.04 | $1,799.16 | $0.00 | $590.75 | $323.85 | $1,208.41 | ||||||
16 | Paul | Batten | 37.50 | 0.00 | 0.00 | 4.00 | $43.13 | $1,250.63 | $0.00 | $389.42 | $12.51 | $861.21 | ||||||
17 | Michael | Bond | 37.50 | 0.00 | 0.00 | 0.00 | $29.48 | $736.88 | $0.00 | $254.27 | $7.37 | $482.60 | ||||||
18 | Vanja | Shin | 37.50 | 0.00 | 0.00 | 3.00 | $33.35 | $933.66 | $0.00 | $290.42 | $9.34 | $643.24 | ||||||
19 | Rehan Shah | Cabillo | 37.50 | 0.00 | 0.00 | 0.00 | $40.44 | $1,011.00 | $0.00 | $310.92 | $10.11 | $700.09 | ||||||
20 | Mohammed Mujtaba | Ottal | 37.50 | 0.00 | 0.00 | 4.00 | $39.30 | $1,139.70 | $20.00 | $363.02 | $11.40 | $776.68 | ||||||
21 | Tamanna | Singh | 37.50 | 0.00 | 0.00 | 3.00 | $35.63 | $997.50 | $20.00 | $323.34 | $9.98 | $674.16 | ||||||
22 | Navjot | Kaur | 37.50 | 0.00 | 0.00 | 0.00 | $41.03 | $1,025.63 | $0.00 | $309.79 | $10.26 | $715.83 | ||||||
23 | Urgen | Maan | 37.50 | 0.00 | 0.00 | 3.00 | $39.68 | $1,110.90 | $10.00 | $342.39 | $11.11 | $768.51 | ||||||
24 | Kiran | Achhami | 37.50 | 0.00 | 0.00 | 0.00 | $44.18 | $1,104.38 | $0.00 | $337.66 | $11.04 | $766.72 | ||||||
25 | Sungsam | Li | 0.00 | 0.00 | 37.50 | 0.00 | $34.88 | $871.88 | $0.00 | $278.05 | $8.72 | $593.83 | Sick Pay |