ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DateCustomerOrder #
Revenue
CostSales Rep
Commission Rate
Commission Amount
Deductions
Payout
2
1/1/2019Alpha Software
i-100001
$202.33 $11.32 Jimena Carrillo4%$7.64 $0.00$7.64
3
1/2/2019Soul Solutions
i-100002
$592.22 $14.42 Emma Ford4%$23.11 $0.00$23.11
4
1/3/2019Ironavigation
i-100003
$59.44 $13.03 Lily Grant6%$2.78 $0.00$2.78
5
1/4/2019Ironavigation
i-100004
$283.33 $6.94 Jamie Webb5%$13.82 $0.00$13.82
6
1/5/2019Soul Solutions
i-100005
$19.00 $7.63 Jamie Webb4.50%$0.51 $0.00$0.51
7
1/6/2019Alpire
i-100006
$43.03 $12.68 Emma Ford5%$1.52 $0.00$1.52
8
1/7/2019Oystertainment
i-100007
$23.34 $11.95 Jimena Carrillo5%$0.57 $0.00$0.57
9
1/8/2019
Titanium Systems
i-100008
$230.30 $24.41 Lily Grant6%$12.35 $0.00$12.35
10
1/9/2019Surprise Media
i-100009
$430.33 $42.03 Lily Grant4%$15.53 $5.25$10.28
11
1/10/2019Apexshow
i-100010
$492.32 $39.95 Emma Ford4%$18.09 $0.00$18.09
12
1/11/2019Oystertainmenti-100011$230.23 $15.49 Lily Grant4%$8.59 $0.00$8.59
13
1/12/2019Rush Inc.
i-100012
$85.44 $8.92 Jimena Carrillo6%$4.59 $0.00$4.59
14
1/13/2019
Titanium Systems
i-100013$79.92 $9.94 Emma Ford5%$3.50 $0.00$3.50
15
1/14/2019Apexshow
i-100014
$82.99 $7.49 Jimena Carrillo5%$3.78 $0.00$3.78
16
1/15/2019Ironavigationi-100015$72.02 $5.04 Lily Grant5%$3.35 $0.00$3.35
17
1/16/2019Oystertainment
i-100016
$84.95 $12.45 Emma Ford4.50%$3.26 $0.00$3.26
18
19
20
Sales RepSum of Payout
21
Emma Ford$49.49
22
Jamie Webb$14.33
23
Jimena Carrillo$16.58
24
Lily Grant$37.36
25
Grand Total$117.75
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100