Spreadsheet: 681782d1591739051-varying-commission-by-sales-and-divisions-sample-commission-file
Sheet: Sheet1

[NAME] | SO Date | Customer PO # | Customer Number | Customer Name | SO Created | Gross Extended | Net Sales Extended | Commission Rep Year | Commission | Extended $ by Gross SO Year | Payment Data | Company Financial Period | Company Financial Year | Commission on Pmt
 | 2019-03-21 00:00:00 | 123456 | 555555 | ABCDE | 2019-03-22 00:00:00 | 30.14 | 30.14 | 2018 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-21 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 77.96 | 77.96 | 2018 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 22.79 | 22.79 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 71.36 | 71.36 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 60.28 | 60.28 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 46 | 46 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 25 | 25 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 25 | 25 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 103 | 103 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555555 | ABCDE | 2019-03-22 00:00:00 | 29.85 | 29.85 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 41 | 41 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 35.68 | 35.68 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 32.88 | 32.88 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 37.38 | 37.38 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 60.28 | 60.28 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 60 | 60 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 555000 | [NAME] | 2019-03-22 00:00:00 | 71.36 | 71.36 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 777000 | ABCDE | 2019-03-22 00:00:00 | 71.36 | 71.36 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 777000 | ABCDE | 2019-03-22 00:00:00 | 5787.3 | 5787.3 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 777000 | ABCDE | 2019-03-23 00:00:00 | 29.85 | 29.85 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 777000 | ABCDE | 2019-03-23 00:00:00 | 14.85 | 14.85 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 777000 | ABCDE | 2019-03-23 00:00:00 | 25 | 25 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 777000 | ABCDE | 2019-03-23 00:00:00 | 29.85 | 29.85 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 777000 | ABCDE | 2019-03-23 00:00:00 | 45.94 | 45.94 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 777000 | ABCDE | 2019-03-23 00:00:00 | 35 | 35 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 888000 | ABCDE | 2019-03-23 00:00:00 | 40.5 | 40.5 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 888000 | ABCDE | 2019-03-23 00:00:00 | 30.85 | 30.85 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-22 00:00:00 |  | 888000 | ABCDE | 2019-03-23 00:00:00 | 35.68 | 35.68 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 888000 | ABCDE | 2019-03-24 00:00:00 | 47.5 | 47.5 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-23 00:00:00 |  | 888000 | ABCDE | 2019-03-24 00:00:00 | 48.6 | 48.6 | 2019 |  |  | 0 | 3 | 2019 | 0
 | 2019-03-24 00:00:00 |  | 888000 | ABCDE | 2019-03-24 00:00:00 | 106.94 | 106.94 | 2019 |  |  | 0 | 3 | 2019 | 0