Spreadsheet: 822933d1679600902-multi-layered-look-up-needed-zone-accrual-excel-question
Sheet: Sheet1

2023-06-30 00:00:00
50% ACCRUED BONUS 1% PSR
Saleman:
ZONE COMMISSIONS |  |  |  |  |  |  |  |  | ZONE COMMISSIONS
January 2023 Bonus |  |  |  |  |  |  |  |  | July 2023 Bonus
2023-01-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify |  | 2023-07-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify
 | 031 - Canton | 0 | 0 | 0 | 0 | 0 |  |  |  | 031 - Canton | 0 | 0 | 0 | 0 | 0
 | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0 |  |  |  | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0
 | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0 |  |  |  | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0
 | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0 |  |  |  | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0
 | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0 |  |  |  | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0
 | 039 - Battery | 0 | 0 | 0 | 0 | 0 |  |  |  | 039 - Battery | 0 | 0 | 0 | 0 | 0
 | Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
ZONE COMMISSIONS |  |  |  |  |  |  |  |  | ZONE COMMISSIONS
February 2023 Bonus |  |  |  |  |  |  |  |  | August 2023 Bonus
2023-02-28 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify |  | 2023-08-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify
 | 031 - Canton | 0 | 0 | 0 | 0 | 0 |  |  |  | 031 - Canton | 0 | 0 | 0 | 0 | 0
 | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0 |  |  |  | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0
 | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0 |  |  |  | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0
 | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0 |  |  |  | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0
 | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0 |  |  |  | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0
 | 039 - Battery | 0 | 0 | 0 | 0 | 0 |  |  |  | 039 - Battery | 0 | 0 | 0 | 0 | 0
 | Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
ZONE COMMISSIONS |  |  |  |  |  |  |  |  | ZONE COMMISSIONS
March 2023 Bonus |  |  |  |  |  |  |  |  | September 2023 Bonus
2023-03-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify |  | 2023-09-30 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify
 | 031 - Canton | 0 | 0 | 0 | 0 | 0 |  |  |  | 031 - Canton | 0 | 0 | 0 | 0 | 0
 | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0 |  |  |  | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0
 | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0 |  |  |  | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0
 | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0 |  |  |  | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0
 | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0 |  |  |  | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0
 | 039 - Battery | 0 | 0 | 0 | 0 | 0 |  |  |  | 039 - Battery | 0 | 0 | 0 | 0 | 0
 | Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
ZONE COMMISSIONS |  |  |  |  |  |  |  |  | ZONE COMMISSIONS
April 2023 Bonus |  |  |  |  |  |  |  |  | October 2023 Bonus
2023-04-30 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify |  | 2023-10-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify
 | 031 - Canton | 0 | 0 | 0 | 0 | 0 |  |  |  | 031 - Canton | 0 | 0 | 0 | 0 | 0
 | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0 |  |  |  | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0
 | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0 |  |  |  | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0
 | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0 |  |  |  | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0
 | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0 |  |  |  | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0
 | 039 - Battery | 0 | 0 | 0 | 0 | 0 |  |  |  | 039 - Battery | 0 | 0 | 0 | 0 | 0
 | Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
ZONE COMMISSIONS |  |  |  |  |  |  |  |  | ZONE COMMISSIONS
May 2023 Bonus |  |  |  |  |  |  |  |  | November 2023 Bonus
2023-05-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify |  | 2023-11-30 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify
 | 031 - Canton | 0 | 0 | 0 | 0 | 0 |  |  |  | 031 - Canton | 0 | 0 | 0 | 0 | 0
 | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0 |  |  |  | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0
 | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0 |  |  |  | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0
 | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0 |  |  |  | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0
 | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0 |  |  |  | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0
 | 039 - Battery | 0 | 0 | 0 | 0 | 0 |  |  |  | 039 - Battery | 0 | 0 | 0 | 0 | 0
 | Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
ZONE COMMISSIONS |  |  |  |  |  |  |  |  | ZONE COMMISSIONS
June 2023 Bonus |  |  |  |  |  |  |  |  | December 2023 Bonus
2023-06-30 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify |  | 2023-12-31 00:00:00 | Branch | Shop | Road | Rental | Parts | Total | Verify
 | 031 - Canton | 0 | 0 | 0 | 0 | 0 |  |  |  | 031 - Canton | 0 | 0 | 0 | 0 | 0
 | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0 |  |  |  | 032 - Sterling Heights | 0 | 0 | 0 | 0 | 0
 | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0 |  |  |  | 034 - Bridgeports | 0 | 0 | 0 | 0 | 0
 | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0 |  |  |  | 035 - Grand Rapids | 0 | 0 | 0 | 0 | 0
 | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0 |  |  |  | 037 - Warehouse Solutions | 0 | 0 | 0 | 0 | 0
 | 039 - Battery | 0 | 0 | 0 | 0 | 0 |  |  |  | 039 - Battery | 0 | 0 | 0 | 0 | 0
 | Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Zone
Dept | Account |  | Amounts
Shop |  | 031 - Canton | 0 | C57
Road |  | 031 - Canton | 0 | D57
Rental |  | 031 - Canton | 0 | E57
Parts |  | 031 - Canton | 0 | F57
Shop |  | 032 - Sterling Heights | 0 | C58
Road |  | 032 - Sterling Heights | 0 | D58
Rental |  | 032 - Sterling Heights | 0 | E58
Parts |  | 032 - Sterling Heights | 0 | F58
Shop |  | 034 - Bridgeports | 0 | C59
Road |  | 034 - Bridgeports | 0 | D59
Rental |  | 034 - Bridgeports | 0 | E59
Parts |  | 034 - Bridgeports | 0 | F59
Shop |  | 035 - Grand Rapids | 0 | C60
Road |  | 035 - Grand Rapids | 0 | D60
Rental |  | 035 - Grand Rapids | 0 | E60
Parts |  | 035 - Grand Rapids | 0 | F60
Shop |  | 037 - Warehouse Solutions | 0 | C61
Road |  | 037 - Warehouse Solutions | 0 | D61
Rental |  | 037 - Warehouse Solutions | 0 | E61
Parts |  | 037 - Warehouse Solutions | 0 | F61
Shop |  | 039 - Battery | 0 | C62
Road |  | 039 - Battery | 0 | D62
Rental |  | 039 - Battery | 0 | E62
Parts |  | 039 - Battery | 0 | F62
Total