Spreadsheet: 123774d1317846322-sage-payroll-upload-using-vlookup-sage-upload
Sheet: Sheet1 (2)

Team Member | Employee | Hours | Bonus Applicable | Department | Manager | Notes | Week One |  |  |  |  |  |  |  | Notes | Week Two |  |  |  |  |  |  |  | Notes | Week Three |  |  |  |  |  |  |  | Notes | Week Four |  |  |  |  |  |  |  | Bonus Calculations
 | Payroll No |  |  |  |  | And | Hours |  |  |  | Leave |  | Abs | Bonus | And | Hours |  |  |  | Leave |  | Abs | Bonus | And | Hours |  |  |  | Leave |  | Abs | Bonus | And | Hours |  |  |  | Leave |  | Abs | Bonus
 |  |  |  |  |  | Comments | [NAME] | Add | Over | Total | Paid | U/P |  |  | Comments | [NAME] | Add | Over | Total | Paid | U/P |  |  | Comments | [NAME] | Add | Over | Total | Paid | U/P |  |  | Comments | [NAME] | Add | Over | Total | Paid | U/P |  |  | Bonus | Hol Bonus | Hours | Hours Bonus | Total Bonus
[NAME] | 1 | 40 | y | Factory | [NAME] |  | 40 |  | 1 |  |  |  | 0 |  |  | 37.5 |  | 1 |  |  |  | 0 |  |  | 37.5 |  | 1 |  |  |  | 0 |  |  | 37.5 |  | 1 |  |  |  | 0
[NAME] | 2 | 40 | Y | Factory | [NAME] |  | 40 |  | 2 |  |  |  | 0 |  |  | 37.5 |  | 2 |  |  |  | 0 |  |  | 37.5 |  | 2 |  |  |  | 0 |  |  | 37.5 |  | 2 |  |  |  | 0
Super Man | 3 | 40 | Y | Factory | [NAME] |  | 40 |  | 3 |  |  |  | 0 |  |  | 37.5 |  | 3 |  |  |  | 0 |  |  | 37.5 |  | 3 |  |  |  | 0 |  |  | 37.5 |  | 3 |  |  |  | 0
[NAME] | 4 | 40 | Y | Factory | [NAME] |  | 40 |  | 4 |  |  |  | 0 |  |  | 37.5 |  | 4 |  |  |  | 0 |  |  | 37.5 |  | 4 |  |  |  | 0 |  |  | 37.5 |  | 4 |  |  |  | 0
[NAME] | 5 | 40 | Y | Factory | [NAME] |  | 40 |  | 5 |  |  |  | 0 |  |  | 37.5 |  | 5 |  |  |  | 0 |  |  | 37.5 |  | 5 |  |  |  | 0 |  |  | 37.5 |  | 5 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UPLOAD WEEK ONE |  |  |  |  |  |  | UPLOAD WEEK ONE |  |  |  |  |  |  | UPLOAD WEEK ONE |  |  |  |  |  |  | UPLOAD WEEK ONE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Reference | Payment Reference | Hours | Rate |  |  |  | Employee Reference | Payment Reference | Hours | Rate |  |  |  | Employee Reference | Payment Reference | Hours | Rate |  |  |  | Employee Reference | Payment Reference | Hours | Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9