Using power query to analyze data

You are auditing BCGG’s revenue cycle for th
e fiscal year ended 3/31/2023 and have requested the client’s sales data for the 4th quarter of the fiscal year. The client has provided you with a data set, which is a listing of all of BCGG’s sales orders from the quarter.

Using the SalesDiscounts2023 file and the Discount Approval File, determine if sales discounts were properly approved. Discounts given to customers who pay within the first twelve days after delivery can be approved by Dallas Cantlin. Discounts given to customers after the twelfth day should be approved by Ali Sullivan.

You are auditing BCGG’s revenue cycle for the fiscal year ended 3/31/2023 and have requested the
client’s sales data for the 4th quarter of the fiscal year. The client has provided you with a data set,
which is a listing of all of BCGG’s sales orders from the quarter.
Using the SalesDiscounts2023 file and the Discount Approval File, determine if sales discounts were
properly approved. Discounts given to customers who pay within the first twelve days after delivery can
be approved by Dallas Cantlin. Discounts given to customers after the twelfth day should be approved
by Ali Sullivan.
The following is a data dictionary listing the column names, descriptions and field types in the
SalesDiscounts2023 file are.
Column Name
ORDERNO
ORDERDATE
Column description
Customer order number
Date the customer order was received
PRODNO
CUSTNO
AMT
UNITPRICE
ORDERPRICE
CREDAPR
SHIPDATE
Product Number
Customer Number
Amount Ordered
Price per case
Total price of order
Credit Approval
Date the order was shipped
FRGHTCOST
INVAMT
INVDATE
Shipping Cost
Invoice Amount
Invoice Date
DISC
Discount provided to customer for fast
payment
Amount of Payment Received
Date of Customer Payment
PAYMENT
PAYDATE
Field type
Numeric
Date
DD/MM/YYYY
Character
Numeric
Numeric
Numeric (dollars)
Numeric (dollars)
Character
Date
DD/MM/YYYY
Numeric (dollars)
Numeric (dollars)
Date
DD/MM/YYYY
Numeric
Numeric (dollars)
Date
DD/MM/YYYY
Here is the data dictionary for the Discount Approval File.
Column Name
CUSTNO
ORDERNO
Approver
Column description
Customer Number
Customer order number
Person who approved the discount
Field type
Numeric
Numeric
Character
Project 3 – Risk Screening Revenue Analysis
Test Performed by: Your answer here…
Date of the Test: Your answer here…
Name of the Test Performed: Your answer here…
Purpose of the Test: Your answer here…
Please note: Not all the steps will be applicable for every project. For example, if you perform
population testing, you are not sampling. In this instance, you write “Not applicable because…”
STEP 1) Assertion Level Correctness & Test Design
1- Assertion level risk assessment and documentation of performance materiality for the
assertion.
Your answer here…
2- Objective of the test
Your answer here…
3- Define the deviation.
Your answer here…
4- Define the population/data to be examined and/or sampled, including steps to verify and
validate data.
Your answer here…
5- Define the sampling units.
Your answer here…
6- Choose a sampling technique.
Your answer here…
7- Determine the sample size:
•
•
•
•
•
Determine the acceptable level of sampling risk or the confidence level–Risk of incorrect
rejection (Type I) and Risk of incorrect acceptance (Type II).
Determine the tolerable error (percentage of materiality).
Determine the expected error (based on prior tests and your understanding of the control
structure).
Consider the variation in the population.
Consider the effect of the population size.
Your answer here…
8- Determine the method of selection (haphazard, random, systematic).
Your answer here…
STEP 2) Audit Test(s) Procedures and Reproducibility
9- Select the audit procedures to perform: inquiry, observation, confirmation, analytical
procedures (including data analytics), reperformance or recalculation, physical inspection of
documents, or physical inspection of assets. You will need to document the procedures
completely so the procedures could be replicated by another reasonably trained auditor.
Your answer here…
STEP 3) Technology Application
10- Document the details of the procedures. For Data Analytics, include the business
intelligence tool (Alteryx or PowerBI) Script.
Your answer here…
STEP 4) Interpretation of Results and Conclusion
Depending on whether you can execute the audit procedure above, the following may or may
not be included.
11- Perform the procedures and accumulate the results.
Your answer here…
12- Perform error analysis, including whether errors are systemic or idiosyncratic.
Your answer here…
13- Determine the root cause of systemic errors.
Your answer here…
14- Draw conclusions about BCGG’s compliance with auditing standards.
Your answer here…
ORDERNO ORDERDATE
PRODNO
CUSTNO
AMT UNITPRICE
ORDERPRICE
CREDAPR SHIPDATE
FRGHTCOST
17001
1/3/2023 SP001
21893
5
120.00
600.00
Y
1/6/2023
15.36
17002
1/3/2023 SP001
41845
30
120.00
3,600.00
Y
1/6/2023
34.73
17003
1/5/2023 HB005
63492
200
276.00
55,200.00
Y
1/11/2023
187.22
17004
1/9/2023 CB008
47542
10
1,164.00
11,640.00
y
1/11/2023
27.69
17005
1/9/2023 SP001
69311
520
120.00
62,400.00
Y
1/11/2023
412.33
17006
1/10/2023 SP001
50647
45
120.00
5,400.00
y
1/13/2023
46.25
17007
1/10/2023 CB008
45455
10
1,164.00
11,640.00
Y
1/13/2023
21.36
17008
1/10/2023 SP001
57852
35
120.00
4,200.00
Y
1/13/2023
36.23
17009
1/10/2023 SP001
27651
3
120.00
360.00
Y
1/13/2023
21.36
17010
1/11/2023 HB005
32681
8
120.00
960.00
Y
1/18/2023
18.91
17011
1/11/2023 SP001
37789
4
120.00
480.00
Y
1/18/2023
14.27
17012
1/12/2023 SP001
23657
2
120.00
240.00
Y
1/18/2023
12.61
17013
1/12/2023 SP001
45455
36
120.00
4,320.00
Y
1/18/2023
38.26
17014
1/15/2023 CB008
57852
12
1,164.00
13,968.00
Y
1/18/2023
22.03
17015
1/15/2023 SP001
22569
3
120.00
360.00
Y
1/18/2023
15.86
17015
1/15/2023 HB005
31026
4
276.00
1,104.00
Y
1/18/2023
18.24
17016
1/15/2023 HB005
12532
2
276.00
552.00
Y
1/18/2023
13.63
17017
1/16/2023 CB008
27651
1
1,164.00
1,164.00
Y
1/20/2023
10.36
17018
1/16/2023 SP001
15632
3
120.00
360.00
Y
1/20/2023
14.68
17019
1/17/2023 SP001
28659
4
120.00
480.00
Y
1/20/2023
18.52
17020
1/17/2023 HB005
77545
522
276.00
144,072.00
y
1/23/2023
443.21
17021
1/17/2023 SP001
59147
42
120.00
5,040.00
y
1/25/2023
44.69
17022
1/18/2023 SP001
33982
12
120.00
1,440.00
y
1/25/2023
26.25
17023
1/18/2023 SP001
16844
4
120.00
480.00
Y
1/25/2023
16.95
17023
1/18/2023 SP001
65238
87
120.00
10,440.00
y
1/25/2023
57.25
17025
1/18/2023 HB005
76415
321
276.00
88,596.00
y
1/26/2023
443.21
17026
1/18/2023 SP001
12546
3
120.00
360.00
Y
1/25/2023
12.43
17027
1/19/2023 SP001
35124
5
120.00
600.00
Y
1/26/2023
13.52
17028
1/19/2023 SP001
54782
26
120.00
3,120.00
Y
1/26/2023
32.21
17029
1/20/2023 CB008
52147
14
1,164.00
16,296.00
Y
1/26/2023
25.76
17030
1/23/2023 HB005
43562
8
276.00
2,208.00
y
1/26/2023
443.21
17031
1/23/2023 SP001
76415
442
120.00
53,040.00
Y
1/31/2023
485.31
17032
1/23/2023 CB008
63492
85
1,164.00
98,940.00
y
1/31/2023
54.63
17033
1/23/2023 CB008
53627
25
1,164.00
29,100.00
y
1/31/2023
34.51
17034
1/23/2023 SP001
41845
8
120.00
960.00
Y
1/30/2023
15.10
17035
1/23/2023 SP001
45455
14
120.00
1,680.00
Y
1/30/2023
18.96
17036
1/23/2023 SP001
55692
24
120.00
2,880.00
Y
1/30/2023
32.51
17037
1/23/2023 SP001
37789
2
120.00
240.00
Y
1/30/2023
10.31
17038
1/24/2023 HB005
47542
16
276.00
4,416.00
y
1/30/2023
20.11
17039
1/24/2023 HB005
35124
9
276.00
2,484.00
y
1/30/2023
15.62
17040
1/24/2023 SP001
57852
10
120.00
1,200.00
Y
1/30/2023
21.36
17041
1/25/2023 CB008
59147
12
1,164.00
13,968.00
y
2/15/2023
23.61
17042
1/25/2023 SP001
21192
4
120.00
480.00
1/30/2023
14.65
17043
1/26/2023 SP001
69311
48
120.00
5,760.00
Y
1/30/2023
45.98
17044
1/26/2023 HB005
63492
34
276.00
9,384.00
y
2/3/2023
37.96
17045
1/26/2023 SP001
35698
4
120.00
480.00
Y
1/30/2023
15.04
17046
1/27/2023 CB008
12532
2
1,164.00
2,328.00
y
1/30/2023
23.61
17047
1/27/2023 SP001
25192
1
120.00
120.00
Y
1/30/2023
10.32
17048
1/27/2023 SP001
15682
3
120.00
360.00
Y
1/30/2023
21.36
17049
1/30/2023 SP001
41845
10
120.00
1,200.00
Y
2/3/2023
21.65
17050
1/30/2023 HB005
63492
84
276.00
23,184.00
y
2/3/2023
55.34
17051
1/30/2023 SP001
27651
2
120.00
240.00
Y
2/3/2023
19.52
17052
1/30/2023 HB005
32681
2
120.00
240.00
Y
2/3/2023
18.91
17053
1/30/2023 SP001
36258
5
120.00
600.00
Y
2/3/2023
14.27
17054
1/30/2023 CB008
45235
12
1,164.00
13,968.00
y
2/3/2023
24.52
17055
1/30/2023 SP001
45455
25
120.00
3,000.00
Y
2/3/2023
32.51
17056
1/31/2023 HB005
32681
4
276.00
1,104.00
Y
2/3/2023
20.13
17057
1/31/2023 SP001
50647
21
120.00
2,520.00
y
2/3/2023
36.31
17058
1/31/2023 SP001
12369
2
120.00
240.00
y
2/3/2023
36.31
17059
1/31/2023 CB008
75213
123
1,164.00
143,172.00
y
2/3/2023
98.21
17060
2/1/2023 SP001
23657
2
120.00
240.00
Y
2/3/2023
12.61
17061
2/1/2023 SP001
21192
6
120.00
720.00
2/3/2023
16.22
17062
2/1/2023 CB008
63492
64
1,164.00
74,496.00
y
2/10/2023
74.96
17063
2/1/2023 SP001
27651
4
120.00
480.00
Y
2/3/2023
21.54
17064
2/2/2023 SP001
46321
8
120.00
960.00
Y
2/3/2023
20.36
17065
2/2/2023 CB008
59147
15
1,164.00
17,460.00
y
2/7/2023
26.31
17066
2/3/2023 SP001
33982
4
120.00
480.00
Y
2/7/2023
19.63
17067
2/3/2023 SP001
69311
32
120.00
3,840.00
Y
2/10/2023
36.51
17068
2/3/2023 HB005
63492
48
276.00
13,248.00
y
2/10/2023
28.63
17069
2/3/2023 HB005
57852
16
276.00
4,416.00
y
2/10/2023
28.63
17069
2/6/2023 SP001
16950
2
120.00
240.00
Y
2/8/2023
11.28
17070
2/6/2023 CB008
12532
2
1,164.00
2,328.00
y
2/8/2023
11.54
17071
2/6/2023 SP001
25192
1
120.00
120.00
Y
2/8/2023
10.32
17072
2/6/2023 CB008
15682
3
1,164.00
3,492.00
y
2/8/2023
13.67
17073
2/6/2023 SP001
41845
8
120.00
960.00
Y
2/8/2023
21.65
17074
2/6/2023 HB005
63492
35
276.00
9,660.00
y
2/10/2023
44.62
17075
2/7/2023 SP001
27651
4
120.00
480.00
Y
2/9/2023
19.52
17076
2/7/2023 CB008
12532
2
1,164.00
2,328.00
y
2/9/2023
11.54
17077
2/7/2023 HB005
69311
140
276.00
38,640.00
y
2/15/2023
85.63
17078
2/7/2023 SP001
50647
30
120.00
3,600.00
y
2/13/2023
46.25
17079
2/8/2023 CB008
45455
6
1,164.00
6,984.00
Y
2/10/2023
36.21
17080
2/8/2023 SP001
12369
2
120.00
240.00
y
2/10/2023
19.54
17081
2/8/2023 CB008
75213
123
1,164.00
143,172.00
y
2/13/2023
109.58
17083
2/1/2023 SP001
23657
2
120.00
240.00
Y
2/13/2023
12.61
17084
2/8/2023 SP001
54211
38
120.00
4,560.00
Y
2/13/2023
37.63
17085
2/8/2023 SP001
27651
2
120.00
240.00
Y
2/10/2023
16.52
17086
2/9/2023 HB005
32681
8
120.00
960.00
Y
2/13/2023
18.91
17087
2/9/2023 SP001
37789
4
120.00
480.00
Y
2/13/2023
14.27
17088
2/9/2023 SP001
23657
2
120.00
240.00
Y
2/13/2023
12.61
17089
2/9/2023 SP001
45455
22
120.00
2,640.00
Y
2/13/2023
38.26
17091
2/10/2023 CB008
57852
8
1,164.00
9,312.00
Y
2/15/2023
20.05
17092
2/10/2023 HB005
31026
6
276.00
1,656.00
Y
2/15/2023
14.52
17093
2/10/2023 HB005
12532
2
276.00
552.00
Y
2/15/2023
11.57
17094
2/10/2023 CB008
27651
1
276.00
276.00
Y
2/15/2023
10.36
17095
2/10/2023 SP001
15632
3
120.00
360.00
Y
2/13/2023
10.57
17096
2/10/2023 SP001
28659
4
120.00
480.00
Y
2/13/2023
12.62
17097
2/10/2023 HB005
77545
522
276.00
144,072.00
y
2/16/2023
443.21
17098
2/13/2023 SP001
59147
42
120.00
5,040.00
y
2/16/2023
44.69
17099
2/13/2023 SP001
33982
12
120.00
1,440.00
y
2/16/2023
26.25
17100
2/13/2023 SP001
65238
87
120.00
10,440.00
y
2/16/2023
57.25
17101
2/13/2023 HB005
76415
321
276.00
88,596.00
y
2/17/2023
443.21
17102
2/13/2023 SP001
12546
3
120.00
360.00
Y
2/16/2023
12.43
17103
2/13/2023 SP001
33982
5
120.00
600.00
Y
2/16/2023
13.52
17104
2/13/2023 SP001
54782
26
120.00
3,120.00
Y
2/16/2023
32.21
17105
2/14/2023 CB008
52147
14
1,164.00
16,296.00
Y
2/16/2023
25.76
17106
2/14/2023 HB005
43562
8
1,164.00
9,312.00
y
2/16/2023
443.21
17107
2/14/2023 SP001
76415
442
120.00
53,040.00
Y
2/21/2023
485.31
17108
2/14/2023 CB008
63492
85
1,164.00
98,940.00
y
2/21/2023
54.63
17109
2/14/2023 SP001
43258
5
120.00
600.00
Y
2/17/2023
16.35
17110
2/15/2023 SP001
45455
14
120.00
1,680.00
Y
2/17/2023
18.96
17111
2/15/2023 SP001
37789
2
120.00
240.00
Y
2/17/2023
10.31
17112
2/15/2023 HB005
47542
16
276.00
4,416.00
y
2/20/2023
20.11
17113
2/15/2023 HB005
35124
9
276.00
2,484.00
y
2/17/2023
15.62
17114
2/15/2023 SP001
57852
10
120.00
1,200.00
Y
2/20/2023
21.36
17115
2/16/2023 CB008
59147
12
1,164.00
13,968.00
y
2/22/2023
23.61
17116
2/16/2023 SP001
21192
4
120.00
480.00
2/22/2023
14.65
17117
2/16/2023 SP001
69311
48
120.00
5,760.00
Y
2/22/2023
45.98
17118
2/16/2023 HB005
63492
34
276.00
9,384.00
y
2/22/2023
37.96
17119
2/16/2023 SP001
35698
4
120.00
480.00
Y
2/22/2023
15.04
17120
2/16/2023 SP001
69311
48
120.00
5,760.00
Y
2/22/2023
58.61
17121
2/16/2023 HB005
63492
34
276.00
9,384.00
y
2/22/2023
38.05
17122
2/16/2023 SP001
35698
4
120.00
480.00
Y
2/20/2023
19.50
17123
2/17/2023 SP001
12369
2
120.00
240.00
y
2/20/2023
14.61
17124
2/17/2023 CB008
56707
10
1,164.00
11,640.00
2/22/2023
19.65
17125
2/17/2023 HB005
60056
35
276.00
9,660.00
y
2/22/2023
37.96
17126
2/17/2023 SP001
35698
2
120.00
240.00
Y
2/22/2023
12.68
17127
2/17/2023 HB005
63492
21
276.00
5,796.00
y
2/22/2023
29.64
17128
2/17/2023 CB008
59147
6
1,164.00
6,984.00
y
2/22/2023
23.61
17129
2/20/2023 CB008
76223
156
1,164.00
181,584.00
y
2/23/2023
254.82
17130
2/20/2023 SP001
45632
26
120.00
3,120.00
Y
2/23/2023
152.36
17131
2/20/2023 HB005
63251
55
276.00
15,180.00
y
2/23/2023
57.54
17132
2/20/2023 SP001
36951
3
120.00
360.00
Y
2/22/2023
15.04
17133
2/20/2023 SP001
57852
15
120.00
1,800.00
y
2/22/2023
25.01
17134
2/20/2023 SP001
69311
40
120.00
4,800.00
Y
2/24/2023
51.32
17135
2/20/2023 SP001
12546
2
120.00
240.00
Y
2/22/2023
13.21
17136
2/20/2023 HB005
32681
8
120.00
960.00
y
2/22/2023
37.96
17137
2/20/2023 SP001
12532
2
120.00
240.00
Y
2/22/2023
12.56
17138
2/20/2023 HB005
45455
5
276.00
1,380.00
y
2/22/2023
17.25
17139
2/20/2023 SP001
21893
5
120.00
600.00
Y
2/22/2023
15.04
17140
2/21/2023 SP001
21192
2
120.00
240.00
2/24/2023
12.59
17141
2/21/2023 SP001
35698
4
120.00
480.00
Y
2/24/2023
14.63
17142
2/21/2023 SP001
12546
1
120.00
120.00
Y
2/24/2023
10.23
17143
2/21/2023 SP001
50647
32
120.00
3,840.00
Y
2/24/2023
49.21
17144
2/22/2023 HB005
15682
4
276.00
1,104.00
y
2/27/2023
11.19
17145
2/22/2023 SP001
45455
8
120.00
960.00
2/27/2023
16.95
17146
2/22/2023 CB008
27651
3
1,164.00
3,492.00
y
2/27/2023
12.93
17147
2/22/2023 HB005
32681
4
276.00
1,104.00
y
2/27/2023
11.62
17148
2/22/2023 HB005
54782
22
276.00
6,072.00
y
2/27/2023
37.96
17149
2/22/2023 SP001
35698
5
120.00
600.00
Y
2/27/2023
12.84
17150
2/23/2023 SP001
12532
2
120.00
240.00
Y
2/27/2023
11.67
17151
2/23/2023 SP001
35124
3
120.00
360.00
Y
2/27/2023
10.96
17152
2/23/2023 SP001
54782
30
120.00
3,600.00
Y
2/28/2023
24.63
17153
2/23/2023 HB005
76415
145
276.00
40,020.00
y
2/27/2023
189.57
17154
2/23/2023 HB005
12546
1
276.00
276.00
y
2/28/2023
11.69
17155
2/23/2023 CB008
50647
22
1,164.00
25,608.00
y
2/28/2023
38.39
17156
2/23/2023 SP001
45236
8
120.00
960.00
Y
2/28/2023
22.54
17157
2/23/2023 SP001
16951
2
120.00
240.00
Y
2/28/2023
12.69
17158
2/23/2023 CB008
69311
80
1,164.00
93,120.00
y
2/28/2023
126.82
17159
2/24/2023 CB008
45455
7
1,164.00
8,148.00
y
2/28/2023
21.94
17160
2/24/2023 SP001
65238
136
276.00
37,536.00
y
2/28/2023
174.24
17161
2/24/2023 HB005
63492
122
276.00
33,672.00
y
2/28/2023
166.58
17162
2/24/2023 SP001
59147
31
120.00
3,720.00
Y
2/28/2023
51.28
17163
2/24/2023 SP001
27651
3
120.00
360.00
Y
2/28/2023
14.58
17164
2/24/2023 SP001
77545
129
120.00
15,480.00
Y
2/28/2023
171.52
17165
2/24/2023 SP001
33982
6
120.00
720.00
Y
2/28/2023
21.07
17166
2/24/2023 HB005
43258
9
276.00
2,484.00
y
2/28/2023
37.96
17167
2/27/2023 SP001
45632
4
120.00
480.00
Y
3/1/2023
14.58
17168
2/27/2023 CB008
63492
52
120.00
6,240.00
Y
3/1/2023
74.68
17169
2/27/2023 HB005
59147
54
276.00
14,904.00
y
3/1/2023
62.84
17170
2/27/2023 SP001
76223
125
120.00
15,000.00
Y
3/2/2023
126.53
17171
2/27/2023 SP001
23764
3
120.00
360.00
Y
3/1/2023
14.58
17172
2/27/2023 HB005
63251
84
276.00
23,184.00
y
3/1/2023
95.51
17173
2/27/2023 HB005
36951
2
276.00
552.00
y
3/2/2023
37.96
17174
2/28/2023 SP001
35124
4
120.00
480.00
Y
3/3/2023
14.58
17175
2/28/2023 SP001
52147
36
120.00
4,320.00
Y
3/3/2023
14.93
17176
2/28/2023 HB005
76415
205
276.00
56,580.00
y
3/6/2023
214.85
17177
2/28/2023 SP001
12546
5
120.00
600.00
Y
3/3/2023
21.02
17178
2/28/2023 SP001
43562
6
120.00
720.00
Y
3/3/2023
23.41
17179
2/28/2023 HB005
16847
2
276.00
552.00
y
3/3/2023
16.21
17180
2/28/2023 SP001
54782
21
120.00
2,520.00
Y
3/6/2023
38.54
17181
3/1/2023 SP001
12546
2
120.00
240.00
Y
3/6/2023
12.51
17182
3/1/2023 SP001
21893
6
120.00
720.00
Y
3/6/2023
26.57
17183
3/1/2023 CB008
21192
4
1,164.00
4,656.00
3/6/2023
20.54
17184
3/1/2023 HB005
69311
78
276.00
21,528.00
y
3/7/3017
86.24
17185
3/1/2023 SP001
57852
20
120.00
2,400.00
Y
3/6/2023
36.21
17186
3/1/2023 SP001
32681
8
120.00
960.00
Y
3/6/2023
31.23
17187
3/1/2023 CB008
45455
8
1,164.00
9,312.00
y
3/6/2023
37.69
17188
3/1/2023 HB005
32681
3
276.00
828.00
17189
3/2/2023 SP001
21192
3
120.00
360.00
17190
3/2/2023 CB008
76415
130
1,164.00
151,320.00
17191
3/2/2023 SP001
23657
1
120.00
17192
3/2/2023 SP001
45455
30
120.00
17193
3/2/2023 CB008
57852
15
1,164.00
17194
3/2/2023 SP001
22569
3
17195
3/2/2023 HB005
31026
4
17196
3/2/2023 HB005
12532
17197
3/2/2023 SP001
17198
3/2/2023 HB005
17199
17200
y
3/6/2023
18.65
3/6/2023
31.23
y
3/8/2023
149.58
120.00
Y
3/6/2023
12.61
3,600.00
Y
3/8/2023
38.26
17,460.00
Y
3/8/2023
22.03
120.00
360.00
Y
3/6/2023
15.86
276.00
1,104.00
Y
3/6/2023
18.24
2
276.00
552.00
Y
3/6/2023
13.63
27651
8
120.00
960.00
Y
3/7/2023
18.51
54782
18
276.00
4,968.00
y
3/7/2023
35.14
3/2/2023 HB005
50647
28
276.00
7,728.00
y
3/8/2023
42.57
3/3/2023 SP001
62855
60
120.00
7,200.00
Y
3/7/2023
72.86
17201
3/3/2023 CB008
45455
12
1,164.00
13,968.00
3/8/2023
41.56
17202
3/3/2023 SP001
45455
9
120.00
1,080.00
Y
3/7/2023
29.92
17203
3/3/2023 HB005
35698
4
276.00
1,104.00
y
3/7/2023
16.73
17204
3/3/2023 HB005
12546
2
276.00
552.00
y
3/7/2023
14.59
17205
3/3/2023 SP001
12532
4
120.00
480.00
Y
3/7/2023
21.76
17206
3/3/2023 SP001
35698
5
120.00
600.00
Y
3/8/2023
28.46
17207
3/3/2023 CB008
35124
8
1,164.00
9,312.00
y
3/8/2023
29.86
17208
3/6/2023 SP001
31026
4
120.00
480.00
Y
3/8/2023
16.01
17209
3/6/2023 SP001
46321
12
120.00
1,440.00
Y
3/8/2023
42.86
17210
3/6/2023 CB008
59147
38
1,164.00
44,232.00
y
3/10/2023
60.75
17211
3/6/2023 SP001
33960
4
120.00
480.00
Y
3/8/2023
19.53
17212
3/6/2023 SP001
69311
125
120.00
15,000.00
Y
3/10/2023
150.69
17213
3/6/2023 HB005
63492
85
276.00
23,460.00
y
3/10/2023
96.46
17214
3/6/2023 SP001
14820
2
120.00
240.00
Y
3/8/2023
12.37
17215
3/6/2023 CB008
69311
68
1,164.00
79,152.00
y
3/10/2023
79.54
17216
3/6/2023 SP001
50647
15
120.00
1,800.00
Y
2/8/2023
45.21
17217
3/6/2023 CB008
15682
3
1,164.00
3,492.00
y
3/8/2023
14.22
17218
3/6/2023 SP001
41845
12
120.00
1,440.00
Y
3/8/2023
43.55
17219
3/6/2023 HB005
63492
52
276.00
14,352.00
y
3/10/2023
67.00
17220
3/7/2023 SP001
27651
4
120.00
480.00
Y
3/9/2023
19.52
17221
3/7/2023 CB008
57852
20
1,164.00
23,280.00
y
3/9/2023
11.54
17222
3/7/2023 HB005
37789
6
276.00
1,656.00
y
3/9/2023
85.63
17223
3/7/2023 SP001
68951
90
120.00
10,800.00
y
3/10/2023
46.25
17224
3/7/2023 CB008
45455
8
1,164.00
9,312.00
Y
3/9/2023
17.52
17225
3/7/2023 SP001
54211
38
120.00
4,560.00
Y
3/10/2023
37.63
17226
3/7/2023 SP001
27651
2
120.00
240.00
Y
3/9/2023
16.52
17227
3/7/2023 HB005
32681
5
120.00
600.00
Y
3/9/2023
18.91
17228
3/7/2023 SP001
16584
2
120.00
240.00
Y
3/9/2023
14.27
17229
3/8/2023 SP001
23657
3
120.00
360.00
Y
3/10/2023
12.61
17230
3/8/2023 SP001
45455
32
120.00
3,840.00
Y
3/14/2023
46.91
17231
3/8/2023 CB008
36520
5
1,164.00
5,820.00
Y
3/10/2023
18.98
17232
3/9/2023 CB008
15635
2
1,164.00
2,328.00
y
3/13/2023
24.15
17233
3/9/2023 SP001
25192
1
120.00
120.00
Y
3/13/2023
11.54
17234
3/9/2023 SP001
15682
3
120.00
360.00
Y
3/13/2023
16.54
17235
3/9/2023 SP001
41845
10
120.00
1,200.00
Y
3/13/2023
22.65
17236
3/9/2023 HB005
63492
86
276.00
23,736.00
y
3/13/2023
68.41
17237
3/9/2023 SP001
16655
2
120.00
240.00
Y
3/13/2023
16.32
17238
3/9/2023 HB005
32681
2
120.00
240.00
Y
3/13/2023
18.91
17239
3/9/2023 SP001
36258
5
120.00
600.00
Y
3/13/2023
20.36
17240
3/9/2023 CB008
45874
16
1,164.00
18,624.00
y
3/13/2023
37.21
17241
3/9/2023 SP001
45455
25
120.00
3,000.00
Y
3/13/2023
41.89
17242
3/9/2023 HB005
32681
4
276.00
1,104.00
Y
3/13/2023
19.55
17243
3/9/2023 SP001
50647
21
120.00
2,520.00
y
3/13/2023
56.21
17244
3/9/2023 SP001
12369
2
120.00
240.00
y
3/13/2023
16.87
17245
3/9/2023 CB008
75213
136
1,164.00
158,304.00
y
3/13/2023
152.88
17246
3/9/2023 SP001
23657
2
120.00
240.00
Y
3/13/2023
12.61
17247
3/9/2023 SP001
16584
6
120.00
720.00
3/13/2023
16.22
17248
3/10/2023 CB008
63492
60
1,164.00
69,840.00
y
3/14/2023
74.96
17249
3/10/2023 SP001
27651
4
120.00
480.00
Y
3/13/2023
21.54
17250
3/10/2023 SP001
46321
8
120.00
960.00
Y
3/13/2023
20.36
17251
3/10/2023 CB008
59147
15
1,164.00
17,460.00
y
3/14/2023
26.31
17252
3/10/2023 SP001
33982
4
120.00
480.00
Y
3/13/2023
19.63
17253
3/10/2023 SP001
69311
32
120.00
3,840.00
Y
3/14/2023
36.51
17249
3/10/2023 HB005
63492
16
276.00
4,416.00
y
3/14/2023
28.63
17250
3/10/2023 SP001
16950
2
120.00
240.00
Y
3/13/2023
11.28
17251
3/10/2023 CB008
12532
2
1,164.00
2,328.00
y
3/13/2023
11.54
17252
3/10/2023 SP001
25192
1
120.00
120.00
Y
3/13/2023
10.32
17253
3/13/2023 CB008
23656
3
1,164.00
3,492.00
y
3/15/2023
13.67
17254
3/13/2023 SP001
41845
8
120.00
960.00
Y
3/15/2023
21.65
17255
3/13/2023 HB005
63492
35
276.00
9,660.00
y
3/15/2023
44.62
17256
3/13/2023 SP001
26547
4
120.00
480.00
Y
3/15/2023
19.52
17257
3/13/2023 CB008
12532
2
1,164.00
2,328.00
y
3/15/2023
12.10
17258
3/13/2023 HB005
69311
142
276.00
39,192.00
y
3/17/2023
160.54
17259
3/13/2023 SP001
50647
30
120.00
3,600.00
y
3/17/2023
47.84
17260
3/13/2023 CB008
45455
6
1,164.00
6,984.00
Y
3/15/2023
17.52
17261
3/13/2023 SP001
54211
26
120.00
3,120.00
Y
3/17/2023
37.63
17262
3/14/2023 SP001
27651
2
120.00
240.00
Y
3/16/2023
15.52
17263
3/14/2023 HB005
32681
8
120.00
960.00
Y
3/16/2023
21.54
17264
3/14/2023 SP001
37789
5
120.00
600.00
Y
3/16/2023
18.63
17265
3/14/2023 SP001
23657
2
120.00
240.00
Y
3/16/2023
13.51
17266
3/14/2023 SP001
45455
28
120.00
3,360.00
Y
3/17/2023
41.87
17267
3/14/2023 HB005
21192
3
120.00
360.00
Y
3/16/2023
18.91
17268
3/14/2023 HB005
35698
8
120.00
960.00
Y
3/16/2023
29.66
17269
3/14/2023 SP001
12546
4
120.00
480.00
Y
3/16/2023
19.95
17270
3/14/2023 HB005
32681
8
120.00
960.00
Y
3/16/2023
21.87
17271
3/14/2023 CB008
45455
10
1,164.00
11,640.00
Y
3/16/2023
39.58
17272
3/14/2023 HB005
50647
7
120.00
840.00
Y
3/16/2023
26.51
17273
3/14/2023 SP001
37789
4
120.00
480.00
Y
3/16/2023
20.11
17274
3/15/2023 SP001
41845
10
120.00
1,200.00
Y
3/17/2023
41.58
17275
3/15/2023 HB005
63492
42
276.00
11,592.00
y
3/22/2023
60.22
17276
3/15/2023 SP001
27651
4
120.00
480.00
Y
3/17/2023
19.52
17277
3/15/2023 SP001
31026
8
120.00
960.00
Y
3/17/2023
21.85
17278
3/15/2023 HB005
12532
5
276.00
1,380.00
y
3/17/2023
19.62
17279
3/15/2023 SP001
27651
4
120.00
480.00
Y
3/17/2023
18.56
17280
3/15/2023 CB008
17559
5
1,164.00
5,820.00
Y
3/17/2023
20.24
17281
3/16/2023 HB005
75213
85
276.00
23,460.00
y
3/22/2023
78.42
17282
3/16/2023 SP001
23657
4
120.00
480.00
Y
3/20/2023
18.44
17283
3/16/2023 HB005
54211
25
276.00
6,900.00
y
3/20/2023
63.48
17284
3/16/2023 SP001
27651
3
120.00
360.00
Y
3/20/2023
17.86
17285
3/16/2023 SP001
32681
4
120.00
480.00
Y
3/20/2023
18.96
17286
3/16/2023 SP001
36683
6
120.00
720.00
Y
3/20/2023
21.57
17287
3/16/2023 SP001
23657
4
120.00
480.00
Y
3/20/2023
19.28
17288
3/16/2023 SP001
45455
15
120.00
1,800.00
Y
3/22/2023
45.61
17289
3/16/2023 SP001
57852
4
120.00
480.00
Y
3/20/2023
22.56
17290
3/16/2023 CB008
31026
5
1,164.00
5,820.00
Y
3/20/2023
20.24
17291
3/16/2023 HB005
25192
5
276.00
1,380.00
y
3/20/2023
21.34
17292
3/17/2023 HB005
69311
26
276.00
7,176.00
y
3/20/2023
40.63
17293
3/17/2023 SP001
35698
6
120.00
720.00
Y
3/24/2023
21.54
17294
3/17/2023 SP001
16950
4
120.00
480.00
y
3/20/2023
18.56
17295
3/17/2023 CB008
56707
12
1,164.00
13,968.00
3/24/2023
30.89
17296
3/17/2023 HB005
60056
38
276.00
10,488.00
y
3/24/2023
54.84
17297
3/17/2023 SP001
35698
3
120.00
360.00
Y
3/20/2023
12.68
17298
3/17/2023 HB005
63492
24
276.00
6,624.00
y
3/24/2023
65.81
17299
3/17/2023 CB008
59147
8
1,164.00
9,312.00
y
3/20/2023
23.61
17300
3/17/2023 HB005
76223
180
276.00
49,680.00
y
3/24/2023
265.27
17301
3/20/2023 SP001
45632
28
120.00
3,360.00
Y
3/22/2107
152.36
17302
3/20/2023 HB005
63251
60
276.00
16,560.00
y
3/24/2023
57.54
17303
3/20/2023 SP001
36951
3
120.00
360.00
Y
3/22/2107
15.04
17304
3/20/2023 SP001
57852
16
120.00
1,920.00
y
3/24/2023
25.01
17305
3/20/2023 HB005
32681
4
276.00
1,104.00
Y
3/22/2107
20.13
17306
3/20/2023 SP001
50647
25
120.00
3,000.00
y
3/27/2107
36.31
17307
3/20/2023 SP001
15682
2
120.00
240.00
y
3/22/2107
36.31
17308
3/20/2023 CB008
75213
144
1,164.00
167,616.00
y
3/27/2107
98.21
17309
3/20/2023 SP001
23657
2
120.00
240.00
Y
3/22/2107
12.61
17310
3/20/2023 SP001
21192
6
120.00
720.00
3/22/2107
16.22
17311
3/21/2023 HB005
15632
4
276.00
1,104.00
Y
3/23/2023
20.13
17312
3/21/2023 SP001
32681
7
120.00
840.00
Y
3/23/2023
18.63
17313
3/21/2023 SP001
31026
5
120.00
600.00
Y
3/23/2023
21.74
17314
3/21/2023 SP001
23657
3
120.00
360.00
Y
3/23/2023
15.87
17315
3/21/2023 SP001
45455
15
120.00
1,800.00
Y
3/24/2023
28.65
17316
3/22/2023 CB008
45235
36
1,164.00
41,904.00
y
3/28/2023
42.51
17317
3/22/2023 SP001
45455
12
120.00
1,440.00
Y
3/28/2023
25.62
17318
3/22/2023 HB005
32681
8
276.00
2,208.00
y
3/24/2023
17.54
17319
3/22/2023 SP001
27651
4
120.00
480.00
Y
3/24/2023
15.86
17320
3/22/2023 SP001
57852
20
120.00
2,400.00
Y
3/28/2023
33.44
17321
3/22/2023 SP001
26547
3
120.00
360.00
Y
3/24/2023
14.78
17322
3/22/2023 SP001
37789
8
120.00
960.00
Y
3/24/2023
17.53
17323
3/22/2023 HB005
26574
4
276.00
1,104.00
y
3/24/2023
15.89
17324
3/22/2023 SP001
27651
4
120.00
480.00
Y
3/24/2023
15.24
17325
3/22/2023 HB005
28659
2
276.00
552.00
y
3/24/2023
11.56
17326
3/22/2023 SP001
77545
122
120.00
14,640.00
Y
3/28/2023
85.48
17327
3/22/2023 SP001
59147
16
120.00
1,920.00
Y
3/28/2023
30.87
17328
3/22/2023 SP001
33982
5
120.00
600.00
Y
3/24/2023
18.55
17329
3/23/2023 SP001
65238
60
120.00
7,200.00
Y
3/28/2023
29.61
17330
3/23/2023 SP001
76415
4
276.00
1,104.00
y
3/27/2023
16.21
17331
3/23/2023 HB005
12546
2
276.00
552.00
y
3/27/2023
11.54
17332
3/23/2023 SP001
35124
5
120.00
600.00
Y
3/27/2023
22.04
17333
3/23/2023 CB008
54782
32
1,164.00
37,248.00
y
3/28/2023
38.49
17334
3/23/2023 HB005
52147
20
276.00
5,520.00
y
3/28/2023
35.61
17335
3/23/2023 HB005
43562
10
276.00
2,760.00
y
3/27/2023
24.86
17336
3/23/2023 SP001
76415
126
120.00
15,120.00
Y
3/28/2023
91.65
17337
3/23/2023 SP001
63492
65
120.00
7,800.00
Y
3/28/2023
33.68
17338
3/23/2023 CB008
41845
8
1,164.00
9,312.00
y
3/27/2023
25.80
17339
3/23/2023 SP001
45455
16
120.00
1,920.00
Y
3/28/2023
30.58
17340
3/23/2023 SP001
37789
6
120.00
720.00
Y
3/27/2023
24.15
17341
3/24/2023 CB008
47542
8
1,164.00
9,312.00
y
3/28/2023
24.56
17342
3/24/2023 SP001
35124
5
120.00
600.00
Y
3/28/2023
19.69
17343
3/24/2023 SP001
57852
32
120.00
3,840.00
Y
3/28/2023
39.92
17344
3/24/2023 CB008
59147
20
1,164.00
23,280.00
y
3/28/2023
32.59
17345
3/24/2023 SP001
12546
5
120.00
600.00
Y
3/28/2023
19.22
17346
3/24/2023 SP001
50647
18
120.00
2,160.00
Y
3/29/2023
29.86
17347
3/24/2023 HB005
45236
10
120.00
1,200.00
Y
3/29/2023
25.02
17348
3/24/2023 SP001
16951
3
120.00
360.00
Y
3/28/2023
15.27
17349
3/24/2023 CB008
37789
5
1,164.00
5,820.00
y
3/28/2023
18.62
17350
3/24/2023 SP001
23657
4
120.00
480.00
Y
3/28/2023
15.36
17351
3/27/2023 CB008
12369
4
1,164.00
4,656.00
y
3/29/2023
16.54
17352
3/27/2023 SP001
75213
116
120.00
13,920.00
Y
3/31/2023
88.62
17353
3/27/2023 HB005
23657
3
276.00
828.00
y
3/29/2023
14.87
17354
3/27/2023 SP001
21192
6
120.00
720.00
Y
3/29/2023
20.05
17355
3/27/2023 SP001
63492
85
120.00
10,200.00
Y
3/31/2023
72.66
17356
3/27/2023 HB005
27651
5
276.00
1,380.00
y
3/29/2023
18.11
17357
3/27/2023 SP001
15682
8
120.00
960.00
Y
3/29/2023
21.17
17358
3/27/2023 CB008
41845
12
1,164.00
13,968.00
y
3/31/2023
28.78
17359
3/27/2023 SP001
63492
58
120.00
6,960.00
Y
3/31/2023
59.96
17360
3/27/2023 CB008
27651
2
120.00
240.00
Y
3/29/2023
12.58
17361
3/27/2023 SP001
32681
6
120.00
720.00
Y
3/29/2023
20.34
17362
3/27/2023 SP001
36258
10
120.00
1,200.00
Y
3/31/2023
26.93
17363
3/27/2023 SP001
21192
2
120.00
240.00
Y
3/29/2023
15.46
17364
3/27/2023 HB005
69311
96
276.00
26,496.00
y
3/31/2023
79.62
17365
3/28/2023 SP001
63492
125
120.00
15,000.00
Y
3/31/2023
102.35
17366
3/28/2023 HB005
69311
56
276.00
15,456.00
y
3/31/2023
57.24
17367
3/28/2023 CB008
63492
48
120.00
5,760.00
Y
3/31/2023
52.83
17368
3/28/2023 SP001
35698
6
120.00
720.00
Y
3/30/3017
20.84
17369
3/28/2023 SP001
12532
2
120.00
240.00
Y
3/30/3017
14.27
17370
3/28/2023 HB005
25192
1
276.00
276.00
y
3/30/3017
10.34
17371
3/28/2023 SP001
15682
4
120.00
480.00
Y
3/30/3017
20.14
17372
3/29/2023 SP001
41845
8
120.00
960.00
Y
3/31/2023
30.64
17373
3/29/2023 SP001
63492
85
120.00
10,200.00
Y
3/31/2023
68.97
17374
3/29/2023 HB005
27651
2
276.00
552.00
y
3/31/2023
15.01
17375
3/29/2023 SP001
32681
6
120.00
720.00
Y
3/31/2023
21.56
17376
3/29/2023 SP001
36258
5
120.00
600.00
Y
3/31/2023
21.31
17377
3/29/2023 SP001
45235
15
120.00
1,800.00
Y
3/31/2023
38.55
17378
3/29/2023 CB008
45455
12
120.00
1,440.00
Y
3/31/2023
31.81
17379
3/29/2023 HB005
32681
4
276.00
1,104.00
y
3/31/2023
20.38
17380
3/29/2023 SP001
50647
20
120.00
2,400.00
Y
3/31/2023
42.59
17381
3/29/2023 CB008
27651
2
1,164.00
2,328.00
y
3/31/2023
14.53
17382
3/29/2023 SP001
12532
5
120.00
600.00
Y
3/31/2023
21.47
17383
3/29/2023 SP001
69311
86
120.00
10,320.00
Y
3/31/2023
70.23
17384
3/30/2023 SP001
50647
25
120.00
3,000.00
Y
17385
3/30/2023 SP001
33982
6
120.00
720.00
Y
17386
3/30/2023 SP001
69311
72
120.00
8,640.00
Y
17387
3/30/2023 HB005
63492
48
276.00
13,248.00
y
17388
3/30/2023 SP001
16950
3
120.00
360.00
Y
17389
3/30/2023 SP001
12532
4
120.00
480.00
Y
17390
3/30/2023 HB005
25192
2
120.00
240.00
Y
17391
3/31/2023 SP001
63492
50
120.00
6,000.00
Y
17392
3/31/2023 SP001
27651
6
120.00
720.00
Y
17393
3/31/2023 HB005
32681
8
276.00
2,208.00
y
17394
3/31/2023 HB005
36258
12
276.00
3,312.00
y
17395
3/31/2023 SP001
45229
15
120.00
1,800.00
Y
17396
3/31/2023 HB005
23657
3
276.00
828.00
y
17397
3/31/2023 CB008
75213
130
1,164.00
151,320.00
y
17398
3/31/2023 HB005
23657
2
276.00
552.00
17399
3/31/2023 SP001
54211
12
120.00
1,440.00
17400
3/31/2023 SP001
27651
4
120.00
480.00
17401
3/31/2023 HB005
25192
6
276.00
1,656.00
17402
3/31/2023 SP001
15682
3
120.00
360.00
17403
3/31/2023 SP001
41845
12
120.00
1,440.00
17404
3/31/2023 SP001
63492
48
120.00
5,760.00
17405
3/31/2023 HB005
27651
2
276.00
552.00
INVAMT
INVDATE
DISC
PAYMENT
PAYDATE
615.36
1/9/2023
0%
615.36
2/1/2023
3,634.73
1/10/2023
2%
3,562.73
1/20/2023
55,387.22
1/13/2023
4%
53,179.22
1/23/2023
11,667.69
1/13/2023
2%
11,434.89
1/20/2023
62,812.33
1/13/2023
4%
60,316.33
1/25/2023
5,446.25
1/17/2023
3%
5,284.25
1/30/2023
11,661.36
1/17/2023
2%
11,428.56
1/30/2023
4,236.23
1/17/2023
2%
4,236.23
1/30/2023
381.36
1/17/2023
3%
370.56
1/30/2016
978.91
1/20/2023
0%
494.27
1/23/2023
0%
494.27
2/21/2023
252.61
1/23/2023
0%
252.61
2/23/2023
4,358.26
1/23/2023
2%
4,271.86
1/30/2023
13,990.03
1/23/2023
3%
13,570.99
2/8/2023
375.86
1/23/2023
0%
375.86
2/23/2023
1,122.24
1/23/2023
0%
565.63
1/23/2023
0%
250.57
2/20/2023
1,174.36
1/25/2023
0%
1,174.36
2/23/2023
374.68
1/23/2023
0%
370.57
2/20/2023
498.52
1/23/2023
0%
492.62
2/23/2023
144,515.21
1/25/2023
2%
141,633.77
2/6/2023
5,084.69
1/25/2023
3%
4,933.49
2/9/2023
1,466.25
1/25/2023
0%
1,466.25
3/5/2023
496.95
1/30/2023
0%
496.95
3/2/2023
10,497.25
1/26/2023
3%
10,184.05
2/6/2023
89,039.21
1/30/2023
2%
87,267.29
2/6/2023
372.43
1/30/2023
0%
372.43
3/3/2023
613.52
1/30/2023
0%
613.52
3/1/2023
3,152.21
1/30/2023
3%
3,152.21
2/3/2023
16,321.76
1/30/2023
3%
15,832.88
2/3/2023
2,651.21
1/30/2023
2%
2,607.05
2/6/2023
53,525.31
2/1/2023
5%
50,873.31
2/9/2023
98,994.63
2/1/2023
4%
95,037.03
2/10/2023
29,134.51
2/1/2023
3%
28,261.51
2/10/2023
975.10
2/1/2023
2%
1,698.96
2/1/2023
2%
1,665.36
2/9/2023
2,912.51
2/1/2023
3%
2,826.11
2/9/2023
250.31
2/1/2023
0%
250.31
2/10/2023
4,436.11
2/1/2023
2%
4,347.79
2/9/2023
2,499.62
2/1/2023
0%
2,499.62
3/2/2023
1,221.36
2/1/2023
3%
1,185.36
2/10/2023
13,991.61
2/20/2023
3%
13,572.57
3/1/2023
494.65
2/1/2023
0%
5,805.98
2/1/2023
4%
5,575.58
2/10/2023
9,421.96
2/7/2023
4%
9,046.60
2/20/2023
495.04
2/2/2023
0%
495.04
3/1/2023
2,351.61
2/2/2023
3%
2,281.77
2/14/2023
130.32
2/2/2023
0%
130.32
3/1/2023
381.36
2/2/2023
0%
381.36
3/1/2023
1,221.65
2/7/2023
0%
1,221.65
3/6/2023
23,239.34
2/7/2023
4%
22,311.98
2/17/2023
259.52
2/7/2023
0%
259.52
3/6/2023
258.91
2/7/2023
0%
258.91
3/2/2023
614.27
2/7/2023
0%
614.27
3/6/2023
13,992.52
2/7/2023
2%
13,713.16
3/7/2023
3,032.51
2/8/2023
2%
2,972.51
2/20/2023
1,124.13
2/8/2023
4%
1,079.97
2/17/2023
2,556.31
2/8/2023
3%
2,480.71
2/17/2023
276.31
2/8/2023
0%
276.31
3/6/2023
143,270.21
2/8/2023
5%
136,111.61
2/20/2023
252.61
2/8/2023
0%
252.61
3/6/2023
736.22
2/8/2023
0%
736.22
3/14/2023
74,570.96
2/14/2023
4%
71,591.12
2/20/2023
501.54
2/8/2023
0%
501.54
3/6/2023
980.36
2/8/2023
2%
961.16
2/20/2023
17,486.31
2/9/2023
3%
16,962.51
2/20/2023
499.63
2/9/2023
0%
499.63
3/14/2023
3,876.51
2/14/2023
4%
3,722.91
2/21/2023
13,276.63
2/14/2023
4%
12,746.71
2/20/2023
4,444.63
2/14/2023
4%
4,267.99
2/24/2023
251.28
2/10/2023
0%
251.28
3/6/2023
2,339.54
2/10/2023
3%
2,269.70
2/28/2023
130.32
2/10/2023
0%
130.32
3/13/2023
3,505.67
2/10/2023
0%
3,505.67
3/10/2023
981.65
2/13/2023
0%
981.65
3/6/2023
9,704.62
2/14/2023
4%
9,318.22
2/24/2023
499.52
2/13/2023
0%
499.52
3/14/2023
2,339.54
2/13/2023
3%
2,269.70
3/10/2023
38,725.63
2/17/2023
4%
3,646.25
2/15/2023
3%
3,538.25
2/27/2023
7,020.21
2/15/2023
2%
6,880.53
2/28/2023
259.54
2/15/2023
0%
259.54
3/10/2023
143,281.58
2/15/2023
5%
136,122.98
3/3/2023
252.61
2/15/2023
0%
252.61
3/6/2023
4,597.63
2/15/2023
3%
4,236.23
2/24/2023
256.52
2/15/2023
3%
249.32
2/27/2023
978.91
2/17/2023
0%
978.91
3/10/2023
494.27
2/17/2023
0%
494.27
3/14/2023
252.61
2/17/2023
0%
252.61
3/10/2023
2,678.26
2/17/2023
2%
2,625.46
3/1/2023
9,332.05
2/17/2023
3%
9,052.69
2/27/2023
1,670.52
2/17/2023
0%
563.57
2/17/2023
0%
250.57
3/15/2023
286.36
2/17/2023
0%
286.36
3/13/2023
370.57
2/16/2023
0%
370.57
3/16/2023
492.62
2/16/2023
0%
492.62
3/13/2023
144,515.21
2/20/2107
2%
141,633.77
2/28/2023
5,084.69
2/20/2107
3%
4,933.49
3/6/2023
1,466.25
2/20/2107
0%
1,466.25
3/17/2023
10,497.25
2/20/2107
3%
10,184.05
3/2/2023
89,039.21
2/20/2107
2%
87,267.29
3/3/2023
372.43
2/20/2107
0%
372.43
3/28/2023
613.52
2/20/2107
0%
613.52
3/30/2023
3,152.21
2/21/2023
3%
3,152.21
3/2/2023
16,321.76
2/21/2023
3%
15,832.88
3/3/2023
9,755.21
2/21/2023
2%
9,568.97
3/6/2023
53,525.31
2/23/2023
5%
50,873.31
3/6/2023
98,994.63
2/23/2023
4%
95,037.03
3/2/2023
616.35
2/21/2023
2%
604.35
3/2/2023
1,698.96
2/20/2107
2%
1,665.36
3/20/2023
250.31
2/20/2107
0%
250.31
3/3/2023
4,436.11
2/20/2107
2%
4,347.79
3/6/2023
2,499.62
2/20/2107
0%
2,499.62
3/20/2023
1,221.36
2/23/2023
3%
1,185.36
3/3/2023
13,991.61
2/27/2023
3%
13,572.57
3/6/2023
494.65
2/27/2023
0%
5,805.98
2/27/2023
4%
5,575.58
3/7/2023
9,421.96
2/27/2023
4%
9,046.60
3/3/2023
495.04
2/27/2023
0%
495.04
3/8/2023
5,818.61
2/27/2023
4%
5,588.21
3/7/2023
9,422.05
2/27/2023
4%
9,046.69
3/28/2023
499.50
2/27/2023
0%
499.50
3/31/2023
254.61
2/27/2023
0%
254.61
3/27/2023
11,659.65
2/27/2023
3%
11,310.45
3/6/2023
9,697.96
2/27/2023
4%
9,311.56
3/7/2023
252.68
2/27/2023
0%
252.68
3/28/2023
5,825.64
2/27/2023
4%
5,593.80
3/8/2023
7,007.61
2/27/2023
3%
6,798.09
3/7/2023
181,838.82
2/27/2023
3%
176,391.30
3/7/2023
3,272.36
2/28/2023
2%
3,209.96
3/6/2023
15,237.54
2/28/2023
4%
14,630.34
3/7/2023
375.04
2/28/2023
0%
375.04
3/27/2023
1,825.01
2/28/2023
3%
1,771.01
3/13/2023
4,851.32
3/1/2023
4%
253.21
2/28/2023
0%
253.21
3/24/2023
997.96
2/28/2023
4%
959.56
3/7/2023
252.56
2/28/2023
0%
252.56
3/27/2023
1,397.25
2/28/2023
2%
1,369.65
3/20/2023
615.04
2/28/2023
0%
615.04
3/28/2023
252.59
2/28/2023
0%
494.63
2/28/2023
0%
494.63
3/27/2106
130.23
3/1/2023
0%
130.23
3/29/2023
3,889.21
3/1/2023
3%
3,774.01
3/10/2023
1,115.19
3/1/2023
0%
1,115.19
3/24/2023
976.95
3/1/2023
2%
957.75
3,504.93
3/1/2023
0%
3,504.93
3/29/2023
1,115.62
3/1/2023
0%
1,115.62
3/20/2023
6,109.96
3/1/2023
3%
5,927.80
3/10/2023
612.84
3/1/2023
0%
612.84
3/29/2023
251.67
3/1/2023
0%
251.67
3/30/2023
370.96
3/1/2023
0%
370.96
3/29/2023
3,624.63
3/2/2023
3%
40,209.57
3/1/2023
5%
38,208.57
3/13/2023
3/20/2023
287.69
3/2/2023
0%
287.69
3/30/2023
25,646.39
3/2/2023
3%
24,878.15
3/14/2023
982.54
3/2/2023
2%
963.34
3/13/2023
252.69
3/2/2023
0%
252.69
3/30/2023
93,246.82
3/3/2023
4%
89,522.02
3/14/2023
8,169.94
3/3/2023
2%
8,006.98
3/14/2023
37,710.24
3/2/2023
4%
36,208.80
3/13/2023
33,838.58
3/2/2023
4%
32,491.70
3/14/2023
3,771.28
3/2/2023
3%
3,659.68
3/14/2023
374.58
3/2/2023
0%
374.58
3/30/2023
15,651.52
3/2/2023
5%
14,877.52
3/14/2023
741.07
3/2/2023
0%
2,521.96
3/2/2023
2%
2,521.96
3/15/2023
494.58
3/3/2023
2%
484.98
3/14/2023
6,314.68
3/3/2023
4%
6,065.08
3/15/2023
14,966.84
3/3/2023
3%
14,519.72
3/14/2023
15,126.53
3/6/2023
5%
14,376.53
3/12/2023
374.58
3/3/2023
0%
23,279.51
3/9/2023
4%
22,352.15
3/19/2023
589.96
3/3/2023
0%
589.96
3/31/2023
494.58
3/6/2023
0%
4,334.93
3/6/2023
3%
4,205.33
3/16/2023
56,794.85
3/8/2023
5%
53,965.85
3/15/2023
621.02
3/7/2023
0%
621.02
3/30/2023
743.41
3/7/2023
2%
729.01
3/12/2023
568.21
3/7/2023
0%
568.21
3/31/2023
2,558.54
3/8/2023
3%
2,482.94
3/16/2023
252.51
3/8/2023
0%
746.57
3/30/2023
746.57
3/8/2023
0%
4,676.54
3/8/2023
0%
21,614.24
3/10/2023
4%
20,753.12
3/20/2023
2,436.21
3/8/2023
3%
2,364.21
3/21/2023
991.23
3/8/2023
3%
962.43
3/16/2023
9,349.69
3/9/2023
2%
9,163.45
3/14/2023
846.65
3/8/2023
0%
391.23
3/8/2023
0%
151,469.58
3/10/2023
5%
143,903.58
3/20/2023
132.61
3/8/2023
0%
132.61
3,638.26
3/10/2023
2%
3,566.26
3/21/2023
17,482.03
3/10/2023
3%
16,958.23
3/20/2023
375.86
375.86
3/8/2023
0%
1,122.24
3/8/2023
0%
565.63
3/8/2023
0%
250.57
978.51
3/8/2023
2%
959.31
3/30/2023
5,003.14
3/10/2023
3%
4,854.10
3/21/2023
7,770.57
3/10/2023
3%
7,538.73
3/21/2023
7,272.86
3/8/2023
0%
14,009.56
3/10/2023
2%
13,730.20
3/21/2023
1,109.92
3/9/2023
2%
1,088.32
3/20/2023
1,120.73
3/10/2023
0%
566.59
3/10/2023
0%
501.76
3/10/2023
0%
501.76
3/30/2023
628.46
3/10/2023
2%
616.46
3/21/2023
9,341.86
3/10/2023
2%
9,155.62
3/20/2023
496.01
3/10/2023
0%
496.01
3/21/2023
1,482.86
3/10/2023
0%
1,482.86
44,292.75
3/13/2023
3%
42,965.79
3/20/2023
499.53
3/10/2023
0%
499.53
3/30/2023
15,150.69
3/13/2023
4%
14,550.69
3/24/2023
23,556.46
3/13/2023
4%
22,618.06
3/23/2023
252.37
3/10/2023
0%
252.37
3/6/2023
79,231.54
3/13/2023
4%
76,065.46
3/30/2023
1,845.21
3/13/2023
3%
3,506.22
3/10/2023
0%
1,483.55
3/13/2023
2%
1,454.75
3/24/2023
14,419.00
3/13/2023
4%
13,844.92
3/23/2023
499.52
3/13/2023
0%
499.52
23,291.54
3/13/2023
3%
22,593.14
3/24/2023
1,741.63
3/13/2023
2%
1,708.51
3/25/2023
10,846.25
3/14/2023
4%
10,414.25
3/24/2023
9,329.52
3/13/2023
3%
9,050.16
4,597.63
3/14/2023
3%
4,236.23
3/24/2023
256.52
3/13/2023
0%
618.91
3/13/2023
0%
254.27
3/13/2023
0%
3,810.11
3/1/2023
2,282.31
3/27/2023
372.61
3/13/2023
0%
3,886.91
3/13/2023
2%
5,838.98
3/13/2023
0%
2,352.15
3/15/2023
3%
131.54
3/15/2023
0%
376.54
3/15/2023
0%
1,222.65
3/15/2023
0%
23,804.41
3/15/2023
4%
256.32
3/15/2023
0%
258.91
3/15/2023
0%
620.36
3/15/2023
0%
18,661.21
3/15/2023
3,041.89
1,123.55
22,854.97
3/27/2023
2%
18,288.73
3/27/2023
3/15/2023
2%
2,981.89
3/28/3017
3/15/2023
4%
1,079.39
3/25/2023
2,576.21
3/15/2023
3%
2,500.61
3/24/3017
256.87
3/15/2023
0%
158,456.88
3/15/2023
5%
150,541.68
3/31/2023
252.61
3/15/2023
0%
252.61
3/25/2023
736.22
3/15/2023
0%
69,914.96
3/16/2023
4%
67,121.36
3/27/2023
501.54
3/15/2023
0%
980.36
3/15/2023
2%
961.16
3/27/2023
17,486.31
3/16/2023
3%
16,962.51
3/27/2023
499.63
3/15/2023
0%
3,876.51
3/16/2023
4%
3,722.91
3/27/2023
4,444.63
3/16/2023
4%
4,267.99
3/27/2023
251.28
3/16/2023
0%
2,339.54
3/16/2023
3%
2,269.70
3/31/2023
9,318.22
3/27/2023
130.32
3/16/2023
0%
3,505.67
3/17/2023
0%
981.65
3/17/2023
0%
9,704.62
3/17/2023
4%
499.52
3/17/2023
0%
2,340.10
3/17/2023
0%
39,352.54
3/20/2023
4%
37,784.86
3/27/2023
3,647.84
3/20/2023
3%
3,539.84
3/27/2023
7,001.52
3/17/2023
2%
6,861.84
3/29/2023
3,157.63
3/21/2023
3%
4,236.23
3/31/2023
255.52
3/20/2023
3%
981.54
3/20/2023
0%
618.63
3/20/2023
0%
253.51
3/20/2023
0%
3,401.87
3/21/2023
2%
4,236.23
3/30/2023
378.91
3/20/2023
0%
989.66
3/20/2023
0%
499.95
3/20/2023
0%
981.87
3/21/2023
0%
11,679.58
3/21/2023
2%
866.51
3/21/2023
0%
500.11
3/21/2023
0%
1,241.58
3/21/2023
0%
11,652.22
3/24/2023
4%
499.52
3/21/2023
0%
981.85
3/21/2023
0%
1,399.62
3/21/2023
4%
498.56
3/21/2023
0%
5,840.24
3/21/2023
2%
23,538.42
3/28/2023
4%
498.44
3/24/2023
0%
6,963.48
3/28/2023
4%
377.86
3/23/2023
0%
498.96
3/23/2023
0%
741.57
3/23/2023
0%
499.28
3/23/2023
0%
1,845.61
3/23/2023
0%
502.56
3/23/2023
0%
5,840.24
3/23/2023
2%
1,401.34
3/23/2023
4%
7,216.63
3/23/2023
4%
741.54
3/24/2023
0%
498.56
3/24/2023
0%
13,998.89
3/24/2023
3%
10,542.84
3/24/2023
4%
372.68
3/24/2023
0%
6,689.81
3/28/2023
4%
9,335.61
3/23/2023
3%
49,945.27
3/28/2023
3%
3,512.36
3/24/2023
2%
16,617.54
3/28/2023
4%
375.04
3/24/2023
0%
1,945.01
3/28/2023
3%
1,124.13
3/29/2023
4%
3,036.31
3/29/2023
3%
276.31
3/29/2023
0%
167,714.21
3/29/2023
5%
252.61
3/29/2023
0%
736.22
3/29/2023
0%
1,124.13
3/27/2023
0%
858.63
3/27/2023
0%
621.74
3/27/2023
0%
375.87
3/27/2023
0%
1,828.65
3/28/2023
2%
41,946.51
3/30/2023
2%
1,465.62
3/30/2023
0%
2,225.54
3/27/2023
4%
495.86
3/27/2023
0%
2,433.44
3/30/2023
0%
374.78
3/27/2023
0%
977.53
3/27/2023
0%
1,119.89
3/27/2023
0%
1,344.42
3/31/2023
10,123.32
3/31/2023
495.24
3/27/2023
0%
563.56
3/27/2023
0%
14,725.48
3/30/2023
5%
1,950.87
3/30/2023
3%
618.55
3/27/2023
0%
7,229.61
3/30/2023
4%
1,120.21
3/29/2023
5%
563.54
3/29/2023
2%
622.04
3/29/2023
0%
37,286.49
3/30/2023
5%
5,555.61
3/30/2023
3%
2,784.86
3/29/2023
2%
15,211.65
3/30/2023
5%
7,833.68
3/30/2023
4%
9,337.80
3/30/2023
5%
1,950.58
3/30/2023
2%
744.15
3/30/2023
0%
9,336.56
3/29/2023
2%
619.69
3/30/2023
0%
3,879.92
3/30/2023
4%
23,312.59
3/29/2023
3%
619.22
3/30/2023
0%
2,189.86
3/31/2023
3%
1,225.02
3/31/2023
2%
375.27
3/30/2023
0%
5,838.62
3/29/2023
5%
495.36
3/30/2023
0%
4,672.54
3/29/2023
5%
14,008.62
3/30/2023
0%
842.87
3/27/2023
4%
740.05
3/30/2023
0%
10,272.66
3/30/2023
0%
1,398.11
3/27/2023
4%
981.17
3/30/2023
0%
1,192.78
179.96
132.58
140.34
146.93
135.46
355.62
222.35
333.24
172.83
140.84
134.27
286.34
140.14
150.64
188.97
291.01
141.56
141.31
158.55
151.81
296.38
162.59
1,178.53
141.47
190.23
Project 3 – Evaluation of the Test of Controls for Anomalous Sales
Test Performed by: Your answer here…
Date of the Test: Your answer here…
Name of the Test Performed: Your answer here…
Purpose of the Test: Your answer here…
Please note: Not all the steps will be applicable for every project. For example, if you perform
population testing, you are not sampling. In this instance, you write “Not applicable because…”
STEP 1) Assertion Level Correctness & Test Design
1- Assertion level risk assessment and documentation of performance materiality for the
assertion.
Your answer here…
2- Objective of the test
Your answer here…
3- Define the deviation.
Your answer here…
4- Define the population/data to be examined and/or sampled, including steps to verify and
validate data.
Your answer here…
5- Define the sampling units.
Your answer here…
6- Choose a sampling technique.
Your answer here…
7- Determine the sample size:
•
•
•
•
•
Determine the acceptable level of sampling risk or the confidence level–Risk of incorrect
rejection (Type I) and Risk of incorrect acceptance (Type II).
Determine the tolerable error (percentage of materiality).
Determine the expected error (based on prior tests and your understanding of the control
structure).
Consider the variation in the population.
Consider the effect of the population size.
Your answer here…
8- Determine the method of selection (haphazard, random, systematic).
Your answer here…
STEP 2) Audit Test(s) Procedures and Reproducibility
9- Select the audit procedures to perform: inquiry, observation, confirmation, analytical
procedures (including data analytics), reperformance or recalculation, physical inspection of
documents, or physical inspection of assets. You will need to document the procedures
completely so the procedures could be replicated by another reasonably trained auditor.
Your answer here…
STEP 3) Technology Application
10- Document the details of the procedures. For Data Analytics, include the business
intelligence tool (Alteryx or PowerBI) Script.
Your answer here…
STEP 4) Interpretation of Results and Conclusion
Depending on whether you can execute the audit procedure above, the following may or may
not be included.
11- Perform the procedures and accumulate the results.
Your answer here…
12- Perform error analysis, including whether errors are systemic or idiosyncratic.
Your answer here…
13- Determine the root cause of systemic errors.
Your answer here…
14- Draw conclusions about BCGG’s compliance with auditing standards.
Your answer here…
CUSTNO
ORDERNO
Approver
12369
17058 None
12369
17080 None
12369
17123 None
12369
17244 None
12369
17351 Ali Sullivan
12532
17016 None
12532
17046 Dallas Cantlin
12532
17070 Ali Sullivan
12532
17076 Ali Sullivan
12532
17093 None
12532
17137 None
12532
17150 None
12532
17196 None
12532
17205 None
12532
17251 Dallas Cantlin
12532
17257 None
12532
17278 Dallas Cantlin
12532
17369 None
12532
17382 None
12532
17389 None
12546
17026 None
12546
17102 None
12546
17135 None
12546
17142 None
12546
17154 None
12546
17177 None
12546
17181 None
12546
17204 None
12546
17269 None
12546
17331 Ali Sullivan
12546
17345 None
14820
17214 None
15632
17018 None
15632
17095 None
15632
17311 None
15635
17232 Dallas Cantlin
15682
17048 None
15682
17072 None
15682
17144 None
15682
17217 None
15682
17234 None
15682
17307 None
15682
17357 None
15682
17371 None
15682
17402 None
16584
17228 None
16584
17247 None
16655
17237 None
16844
17023 None
16847
17179 None
16950
17069 None
16950
17250 None
16950
17294 None
16950
17388 None
16951
17157 None
16951
17348 None
17559
17280 Ali Sullivan
21192
17042 None
21192
17061 None
21192
17116 None
21192
17140 None
21192
17183 None
21192
17189 None
21192
17267 None
21192
17310 None
21192
17354 None
21192
17363 None
21893
17001 None
21893
17139 None
21893
17182 None
22569
17015 None
22569
17194 None
23656
17253 None
23657
17012 None
23657
17060 None
23657
17083 None
23657
17088 None
23657
17191 None
23657
17229 None
23657
17246 None
23657
17265 None
23657
17282 None
23657
17287 None
23657
17309 None
23657
17314 None
23657
17350 None
23657
17353 Ali Sullivan
23657
17396 None
23657
17398 None
23764
17171 None
25192
17047 None
25192
17071 None
25192
17233 None
25192
17252 None
25192
17291 Ali Sullivan
25192
17370 None
25192
17390 None
25192
17401 None
26547
17256 None
26547
17321 None
26574
17323 None
27651
17009 Ali Sullivan
27651
17017 None
27651
17051 None
27651
17063 None
27651
17075 None
27651
17085 Dallas Cantlin
27651
17094 None
27651
17146 None
27651
17163 None
27651
17197 Ali Sullivan
27651
17220 None
27651
17226 None
27651
17249 None
27651
17262 Ali Sullivan
27651
17276 None
27651
17279 None
27651
17284 None
27651
17319 None
27651
17324 None
27651
17356 Ali Sullivan
27651
17360 None
27651
17374 None
27651
17381 None
27651
17392 None
27651
17400 None
27651
17405 None
28659
17019 None
28659
17096 None
28659
17325 None
31026
17015 None
31026
17092 None
31026
17195 None
31026
17208 None
31026
17277 None
31026
17290 Ali Sullivan
31026
17313 None
32681
17010 None
32681
17052 None
32681
17056 Dallas Cantlin
32681
17086 None
32681
17136 Dallas Cantlin
32681
17147 None
32681
17186 Dallas Cantlin
32681
17188 None
32681
17227 None
32681
17238 None
32681
17242 Dallas Cantlin
32681
17263 None
32681
17270 None
32681
17285 None
32681
17305 Ali Sullivan
32681
17312 None
32681
17318 Ali Sullivan
32681
17361 None
32681
17375 None
32681
17379 None
32681
17393 None
33960
17211 None
33982
17022 None
33982
17066 None
33982
17099 None
33982
17103 None
33982
17165 None
33982
17252 None
33982
17328 None
33982
17385 None
35124
17027 None
35124
17039 None
35124
17113 None
35124
17151 None
35124
17174 None
35124
17207 Dallas Cantlin
35124
17332 None
35124
17342 None
35698
17045 None
35698
17119 None
35698
17122 None
35698
17126 None
35698
17141 None
35698
17149 None
35698
17203 None
35698
17206 Dallas Cantlin
35698
17268 None
35698
17293 None
35698
17297 None
35698
17368 None
36258
17053 None
36258
17239 None
36258
17362 None
36258
17376 None
36258
17394 None
36520
17231 None
36683
17286 None
36951
17132 None
36951
17173 None
36951
17303 None
37789
17011 None
37789
17037 None
37789
17087 None
37789
17111 None
37789
17222 Dallas Cantlin
37789
17264 None
37789
17273 None
37789
17322 None
37789
17340 None
37789
17349 Ali Sullivan
41845
17002 Dallas Cantlin
41845
17034 Ali Sullivan
41845
17049 None
41845
17073 None
41845
17218 Dallas Cantlin
41845
17235 None
41845
17254 None
41845
17274 None
41845
17338 Ali Sullivan
41845
17358 None
41845
17372 None
41845
17403 None
43258
17109 Dallas Cantlin
43258
17166 Dallas Cantlin
43562
17030 Dallas Cantlin
43562
17106 Dallas Cantlin
43562
17178 Dallas Cantlin
43562
17335 Ali Sullivan
45229
17395 None
45235
17054 Ali Sullivan
45235
17316 Ali Sullivan
45235
17377 None
45236
17156 Dallas Cantlin
45236
17347 Ali Sullivan
45455
17007 Dallas Cantlin
45455
17013 Dallas Cantlin
45455
17035 Dallas Cantlin
45455
17055 Dallas Cantlin
45455
17079 Dallas Cantlin
45455
17089 Dallas Cantlin
45455
17110 Ali Sullivan
45455
17138 Ali Sullivan
45455
17145
45455
17159 Dallas Cantlin
45455
17187 Dallas Cantlin
45455
17192 Dallas Cantlin
45455
17201 Dallas Cantlin
45455
17202 Dallas Cantlin
45455
17224
45455
17230 Ali Sullivan
45455
17241 Ali Sullivan
45455
17260 Dallas Cantlin
45455
17266 Dallas Cantlin
45455
17271 Ali Sullivan
45455
17288 None
45455
17315 Ali Sullivan
45455
17317 None
45455
17339 Ali Sullivan
45455
17378 None
45632
17130 Dallas Cantlin
45632
17167 Dallas Cantlin
45632
17301 Ali Sullivan
45874
17240 Dallas Cantlin
46321
17064 Dallas Cantlin
46321
17209 None
46321
17250 Dallas Cantlin
47542
17004 Dallas Cantlin
47542
17038 Dallas Cantlin
47542
17112 Ali Sullivan
47542
17341 Ali Sullivan
50647
17006 Dallas Cantlin
50647
17057 Dallas Cantlin
50647
17078 Dallas Cantlin
50647
17143 Dallas Cantlin
50647
17155 Dallas Cantlin
50647
17199 Dallas Cantlin
50647
17216
50647
17243 Ali Sullivan
50647
17259 Dallas Cantlin
50647
17272 None
50647
17306 Ali Sullivan
50647
17346 Ali Sullivan
50647
17380 None
50647
17384 None
#VALUE!
#VALUE!
#VALUE!
52147
17029 Dallas Cantlin
52147
17105 Dallas Cantlin
52147
17175 Dallas Cantlin
52147
17334 Ali Sullivan
53627
17033 Dallas Cantlin
54211
17084 Dallas Cantlin
54211
17225 Dallas Cantlin
54211
17261 Dallas Cantlin
54211
17283 Ali Sullivan
54211
17399 None
54782
17028 Dallas Cantlin
54782
17104 Dallas Cantlin
54782
17148 Dallas Cantlin
54782
17152 Dallas Cantlin
54782
17180 Dallas Cantlin
54782
17198 Dallas Cantlin
54782
17333 Ali Sullivan
55692
17036 Dallas Cantlin
56707
17124 Dallas Cantlin
56707
17295 Ali Sullivan
57852
17008 Dallas Cantlin
57852
17014 Ali Sullivan
57852
17040 Dallas Cantlin
57852
17069 Dallas Cantlin
57852
17091 Dallas Cantlin
57852
17114 Dallas Cantlin
57852
17133 Dallas Cantlin
57852
17185 Dallas Cantlin
57852
17193 Dallas Cantlin
57852
17221 Dallas Cantlin
57852
17289 None
57852
17304 Ali Sullivan
57852
17320 None
57852
17343 Ali Sullivan
59147
17021 Dallas Cantlin
59147
17041 Dallas Cantlin
59147
17065 Dallas Cantlin
59147
17098 Ali Sullivan
59147
17115 Dallas Cantlin
59147
17128 Dallas Cantlin
59147
17162 Dallas Cantlin
59147
17169 Dallas Cantlin
59147
17210 Dallas Cantlin
59147
17251 Dallas Cantlin
59147
17299 Ali Sullivan
59147
17327 Ali Sullivan
59147
17344 Ali Sullivan
60056
17125 Dallas Cantlin
60056
17296 Dallas Cantlin
62855
17200 None
63251
17131 Dallas Cantlin
63251
17172 Dallas Cantlin
63251
17302 Ali Sullivan
63492
17003 Dallas Cantlin
63492
17032 Dallas Cantlin
63492
17044 Dallas Cantlin
63492
17050 Dallas Cantlin
63492
17062 Dallas Cantlin
63492
17068 Dallas Cantlin
63492
17074 Dallas Cantlin
63492
17108 Dallas Cantlin
63492
17118 Dallas Cantlin
63492
17121 Ali Sullivan
63492
17127 Dallas Cantlin
63492
17161 Dallas Cantlin
63492
17168 Dallas Cantlin
63492
17213 Dallas Cantlin
63492
17219 Dallas Cantlin
63492
17236 Dallas Cantlin
63492
17248 Dallas Cantlin
63492
17249 Dallas Cantlin
63492
17255 Dallas Cantlin
63492
17275 Ali Sullivan
63492
17298 Ali Sullivan
63492
17337 Ali Sullivan
63492
17355 None
63492
17359 None
63492
17365 None
63492
17367 None
63492
17373 None
63492
17387 None
63492
17391 None
63492
17404 None
65238
17023 Dallas Cantlin
65238
17100 Ali Sullivan
65238
17160 Dallas Cantlin
65238
17329 Ali Sullivan
68951
17223 Dallas Cantlin
69311
17005 Dallas Cantlin
69311
17043 Dallas Cantlin
69311
17067 Dallas Cantlin
69311
17077 Ali Sullivan
69311
17117 Dallas Cantlin
69311
17120 Dallas Cantlin
69311
17134
69311
17158 Dallas Cantlin
#VALUE!
69311
17184 Dallas Cantlin
69311
17212 Dallas Cantlin
69311
17215 Ali Sullivan
69311
17253 Dallas Cantlin
69311
17258 Dallas Cantlin
69311
17292 Ali Sullivan
69311
17364 None
69311
17366 None
69311
17383 None
69311
17386 None
75213
17059 Dallas Cantlin
75213
17081 Ali Sullivan
75213
17245 Ali Sullivan
75213
17281 Ali Sullivan
75213
17308 Ali Sullivan
75213
17352 None
75213
17397 None
76223
17129 Dallas Cantlin
76223
17170 Dallas Cantlin
76223
17300 Ali Sullivan
76415
17025 Dallas Cantlin
76415
17031 Dallas Cantlin
76415
17101 Ali Sullivan
76415
17107 Dallas Cantlin
76415
17153 Ali Sullivan
76415
17176 Dallas Cantlin
76415
17190 Dallas Cantlin
76415
17330 Ali Sullivan
76415
17336 Ali Sullivan
77545
17020 Dallas Cantlin
77545
17097 Ali Sullivan
77545
17164 Dallas Cantlin
77545
17326 Ali Sullivan