Vlookup to Find Matches with Negative Numbers

[MacIndy]

I'm attempting to use a Cust Order # to find a monetary value on a different worksheet. I'm only looking for negative values though. This is an accounting audit thing. I'm attempting to find out why a dollar amount on a Customer Order that should have been charged wasn't the final amount that was actually charged. I believe, in many cases this would be due to a credit being applied by Accounting. So, I am attempting to Match the Order # on each worksheet and look to the right for a negative number only.

In other words, a give Customer Order may be listed twice on the spreadsheet I'm doing my lookup to but I only want to see the negative number that offset the original amount. Better yet, if there is more than one negative amount it might also be nice to do a SumIf on the negative amounts so I have the total credits applied.

Here's my current Vlookup:
=VLOOKUP(A4,PostedInv20Jan2023All!C2:E19037,3,FALSE)

Here's a SumIf I tried that does work. Just not sure how to combine the two and only Sun negative numbers to find my credits
=SUMIF($C$2:$C$19037,C338,$E$2:$E$19037)

 

[Sufiyan97]

Try

=SUMIFS($E$2:$E$19037,$C$2:$C$19037,C338,$E$2:$E$19037,"<0")

 

[MacIndy]

Thanks for the quick reply. The data is on two different worksheets. Its two different tables in our ERP system. I have to match the Customer Order# and then lookup values.

 

[Sufiyan97]

Then show some rows of your data, how it looks.

 

[MacIndy]

Here's a sample of the Customer Order Data:

Compare COtoPostedInv.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Order	Freight	Misc Charges	Sales Tax	Total Price	Accum Freight	Freight on Posted?	Matches	Freight Cost	Freight Invoiced	Status	Order Date	If Neg Amt Exists?
2	TRANSFER01	0	0	43,631.88	666,944.48	0	#N/A				Ordered	3/16/2022
3	TaxAdj0002	0	0	0	0	0	#N/A		0	1	Complete	1/4/2023
4	lb00004078	0	0	0	5,085.90	217.22	0	FALSE	217.22	1	Complete	10/26/2022	-217.22
5	RB00000002	0	0	0	500.4	0	#N/A				Complete	3/18/2022
6	RB00000001	0	0	0	3,449.00	0	#N/A		657.88	1	Complete	2/8/2022
7	PM00001432	0	0	1.7	24.41	0	#N/A				Ordered	1/19/2023
8	PM00001431	0	0	21.89	313.82	0	#N/A				Ordered	1/19/2023
9	PM00001430	0	0	0	3,182.72	0	#N/A				Ordered	1/17/2023
10	PM00001429	0	0	0	220.7	0	#N/A				Ordered	1/17/2023
11	PM00001428	0	0	0	718.07	0	#N/A				Ordered	1/17/2023
12	PM00001427	0	0	0	239.77	0	#N/A				Ordered	1/17/2023
13	PM00001426	0	0	0	328.71	0	#N/A				Ordered	1/17/2023
14	pm00001425	0	0	0	341.22	0	#N/A				Ordered	1/17/2023
15	PM00001424	0	0	0	1,134.49	0	#N/A				Ordered	1/17/2023
16	PM00001423	0	0	0	206.84	0	#N/A				Ordered	1/16/2023
17	PM00001422	0	0	0	214.3	0	#N/A				Ordered	1/16/2023
18	PM00001421	0	0	0	488.14	0	#N/A				Ordered	1/16/2023
19	PM00001420	0	0	0	336.29	0	#N/A				Ordered	1/16/2023
20	PM00001419	0	0	12.04	783.92	0	#N/A				Ordered	1/16/2023
21	PM00001418	0	0	0	889.61	0	#N/A				Ordered	1/16/2023
22	PM00001417	0	0	0	182.64	0	#N/A				Ordered	1/16/2023
23	PM00001416	0	0	0	147.47	0	#N/A				Ordered	1/16/2023
24	lb00002989	0	0	0	2,282.00	230	0	FALSE	230	1	Complete	7/19/2022	230.00
25	lb00002127	0	0	0	4,559.96	201.96	0	FALSE			Complete	4/25/2022	201.96
26	PM00001412	0	0	0	1,223.59	0	#N/A				Ordered	1/10/2023
27	PM00001411	0	0	0	1,077.16	0	#N/A				Ordered	1/10/2023
28	PM00001410	0	0	0	1,918.73	0	#N/A				Ordered	1/10/2023
29	PM00001409	0	0	0	169.51	0	#N/A				Ordered	1/10/2023
30	PM00001408	0	0	0	792.27	0	#N/A				Ordered	1/10/2023
31	PM00001407	0	0	0	216.59	0	#N/A				Ordered	1/9/2023
32	PM00001406	0	0	0	530.55	0	#N/A				Ordered	1/9/2023
33	PM00001405	0	0	0	1,123.03	0	#N/A				Ordered	1/9/2023
34	PM00001404	0	0	0	61.95	0	#N/A				Ordered	1/9/2023
35	PM00001403	0	0	0	288.49	0	#N/A				Ordered	1/9/2023
36	PM00001402	0	0	0	538.11	0	#N/A				Ordered	1/9/2023
37	PM00001401	0	0	0	241.44	0	#N/A				Ordered	1/9/2023
38	PM00001400	0	0	0	721.2	0	#N/A				Ordered	1/9/2023
39	PM00001399	0	0	0	107.32	0	#N/A				Ordered	1/9/2023
40	PM00001398	0	0	0	718.99	0	#N/A				Ordered	1/9/2023
41	PM00001397	0	0	0	1,009.31	0	#N/A				Ordered	1/9/2023
42	PM00001396	0	0	0	1,235.00	0	#N/A				Ordered	1/9/2023
43	PM00001395	0	0	0	509.17	0	#N/A				Ordered	1/9/2023
44	PM00001394	0	0	0	1,985.80	0	#N/A				Ordered	1/9/2023
45	PM00001393	0	0	0	662.55	0	#N/A				Ordered	1/9/2023
46	PM00001392	0	0	0	458.62	0	#N/A				Ordered	1/9/2023
47	PM00001391	0	0	0	387.92	0	#N/A				Ordered	1/9/2023
48	PM00001390	0	0	0.81	721.02	0	#N/A		10.81	1	Ordered	1/9/2023
49	PM00001389	0	0	0	1,809.33	0	#N/A				Ordered	1/9/2023
50	PM00001388	0	0	0	376.77	0	#N/A				Ordered	1/9/2023
51	PM00001387	0	0	0	1,069.84	0	#N/A				Complete	1/3/2023
52	PM00001386	0	0	0	364.26	0	#N/A				Complete	1/3/2023
53	PM00001385	0	0	0	149.61	0	#N/A				Complete	1/3/2023
54	PM00001384	0	0	0	676.32	0	#N/A				Complete	1/3/2023
55	PM00001383	0	0	0	377.77	0	#N/A				Complete	1/3/2023
56	PM00001382	0	0	0	1,129.50	0	#N/A				Complete	1/3/2023
57	PM00001381	0	0	0	196.44	0	#N/A				Complete	1/3/2023
58	PM00001380	0	0	0	910.7	0	#N/A				Complete	1/3/2023
59	PM00001379	0	0	0	769.41	0	#N/A				Complete	1/3/2023
60	PM00001378	0	0	0	94.11	0	#N/A				Complete	12/27/2022
61	PM00001377	0	0	0	382.66	0	#N/A				Complete	12/27/2022
62	PM00001376	0	0	0	646.35	0	#N/A				Complete	12/27/2022
63	PM00001375	0	0	0	128.72	0	#N/A				Complete	12/27/2022
64	PM00001374	0	0	0	268.27	0	#N/A				Complete	12/27/2022
65	PM00001373	0	0	0	345.51	0	#N/A				Complete	12/27/2022
66	PM00001372	0	0	0	310.66	0	#N/A				Complete	12/27/2022
67	PM00001371	0	0	0	438.88	0	#N/A				Complete	12/27/2022
68	PM00001370	0	0	0	730.13	0	#N/A				Complete	12/27/2022
69	PM00001369	0	0	0	356.53	0	#N/A				Complete	12/27/2022
70	PM00001368	0	0	0	352.31	0	#N/A				Complete	12/27/2022
71	PM00001367	0	0	0	236.21	0	#N/A				Complete	12/27/2022
72	PM00001366	0	0	0	1,477.01	0	#N/A				Complete	12/27/2022
73	PM00001365	0	0	0	1,564.27	0	#N/A				Complete	12/27/2022
74	PM00001364	0	0	0	750.19	0	#N/A				Complete	12/27/2022
75	lb00002000	0	0	0	4,206.92	331.02	0	FALSE			Complete	4/12/2022	-331.02
76	PM00001362	0	0	0	140.84	0	0				Complete	12/20/2022
77	PM00001361	0	0	0	1,545.14	0	0				Complete	12/20/2022
78	PM00001360	0	0	0	754.21	0	0				Complete	12/20/2022
79	PM00001359	0	0	0	1,333.49	0	0				Complete	12/20/2022
80	PM00001358	0	0	0	157.9	0	0				Complete	12/20/2022
81	PM00001357	0	0	0	318.98	0	0				Complete	12/20/2022
82	PM00001356	0	0	0	539.63	0	0				Complete	12/20/2022
83	PM00001355	0	0	0	184.81	0	0				Complete	12/20/2022
84	PM00001354	0	0	0	1,927.48	0	0				Complete	12/20/2022
85	PM00001353	0	0	0	90.07	0	0				Complete	12/19/2022
86	PM00001352	0	0	0	547.46	0	0				Complete	12/19/2022
87	PM00001351	0	0	0	440.21	0	0				Complete	12/19/2022
88	PM00001350	0	0	0	1,155.74	0	0				Complete	12/19/2022
89	PM00001349	0	0	0	440.06	0	0				Complete	12/19/2022
90	PM00001348	0	0	0	1,237.79	0	0				Complete	12/19/2022
91	PM00001347	0	0	0	941.41	0	0				Complete	12/19/2022
92	PM00001346	0	0	0	323.32	0	0				Complete	12/19/2022
93	LB00000851	0	0	0	9,593.49	273.99	0	FALSE			Complete	12/9/2021	0.00
94	PM00001344	0	0	0	247.3	0	0				Complete	12/13/2022
95	PM00001343	0	0	0	675.05	0	0				Complete	12/13/2022
96	PM00001342	0	0	0	197.1	0	0				Complete	12/13/2022
97	PM00001341	0	0	0	656.84	0	0				Complete	12/13/2022
98	PM00001340	0	0	0	1,381.50	0	0				Complete	12/13/2022
99	PM00001339	0	0	0	767.72	0	0				Complete	12/13/2022
100	PM00001338	0	0	0	197.37	0	0				Complete	12/13/2022
101	PM00001337	0	0	0	827.2	0	0				Complete	12/13/2022
102	PM00001336	0	0	0	168.3	0	0				Complete	12/13/2022
103	PM00001335	0	0	0	675.92	0	0				Complete	12/13/2022
104	PM00001334	0	0	0	1,848.94	0	0				Complete	12/13/2022
105	PM00001333	0	0	0	699.15	0	0				Complete	12/13/2022
106	PM00001332	0	0	0	55.75	0	0				Complete	12/13/2022
107	PM00001331	0	0	0	256.04	0	0				Complete	12/13/2022
108	PM00001330	0	0	0	350.89	0	0				Complete	12/13/2022
109	PM00001329	0	0	0	414.73	0	0				Complete	12/13/2022
110	PM00001328	0	0	0	2,092.30	0	0				Complete	12/13/2022
111	PM00001327	0	0	0	1,268.03	0	0				Complete	12/13/2022
112	PM00001326	0	0	0	921.32	0	0				Complete	12/13/2022
113	PM00001325	0	0	0	325.1	0	0				Complete	12/12/2022
114	PM00001324	0	0	0	439.7	0	0				Complete	12/12/2022
115	PM00001323	0	0	0	238.5	0	0				Complete	12/12/2022
116	PM00001322	0	0	0	124.48	0	0				Complete	12/12/2022
117	PM00001321	0	0	0	462.91	0	0				Complete	12/12/2022
118	PM00001320	0	0	0	368.27	0	0				Complete	12/12/2022
119	PM00001319	0	0	0	312.24	0	0				Complete	12/12/2022
120	PM00001318	0	0	0	935.82	0	0				Complete	12/12/2022
121	PM00001317	0	0	0	692.78	0	0				Complete	12/12/2022
122	PM00001316	0	0	0	52.4	0	0				Complete	12/8/2022
123	CO00007128	0	0	0	5,734.21	411.21	0	FALSE			Complete	11/4/2022	411.21
124	PM00001314	0	0	0	173.01	0	0				Complete	12/6/2022
125	PM00001313	0	0	0	1,455.85	0	0				Complete	12/6/2022
126	PM00001312	0	0	0	673.79	0	0				Complete	12/6/2022
127	PM00001311	0	0	0	220.94	0	0				Complete	12/6/2022
128	PM00001310	0	0	0	830.14	0	0				Complete	12/6/2022
129	PM00001309	0	0	0	855.81	0	0				Complete	12/6/2022
130	PM00001308	0	0	0	807.94	0	0				Complete	12/5/2022
131	PM00001307	0	0	0	381.69	0	0				Complete	12/5/2022
132	PM00001306	0	0	0	626.12	0	0				Complete	12/5/2022
133	PM00001305	0	0	0	115.45	0	0				Complete	12/5/2022
134	PM00001304	0	0	0	780.43	0	0				Complete	12/5/2022
135	PM00001303	0	0	0	160.25	0	0				Complete	12/5/2022
136	PM00001302	0	0	0	109.3	0	0		0	1	Complete	12/5/2022
137	PM00001301	0	0	0	409.89	0	0				Complete	12/5/2022
138	PM00001300	0	0	0	1,050.56	0	0				Complete	12/5/2022
139	PM00001299	0	0	0	230.98	0	0				Complete	11/29/2022
140	PM00001298	0	0	0	462.24	0	0				Complete	11/29/2022
141	PM00001297	0	0	0	407.66	0	0				Complete	11/29/2022
142	PM00001296	0	0	0	570.07	0	0				Complete	11/29/2022
143	PM00001295	0	0	0	3,858.02	0	0				Complete	11/29/2022
144	PM00001294	0	0	0	297.34	0	0				Complete	11/29/2022
145	PM00001293	0	0	0	215.55	0	0				Complete	11/29/2022
146	PM00001292	0	0	0	4,360.35	0	0				Complete	11/29/2022
147	PM00001291	0	0	0	405.8	0	0				Complete	11/29/2022
148	PM00001290	0	0	0	140.75	0	0				Complete	11/29/2022
149	PM00001289	0	0	0	492.31	0	0				Complete	11/29/2022
150	PM00001288	0	0	0	187.91	0	0				Complete	11/29/2022
151	PM00001287	0	0	0	639.19	0	0				Complete	11/29/2022
152	PM00001286	0	0	0	330.64	0	0				Complete	11/29/2022
153	PM00001285	0	0	0	1,074.43	0	0				Complete	11/29/2022
154	PM00001284	0	0	0	364.85	0	0				Complete	11/29/2022
155	PM00001283	0	0	0	2,038.56	0	0				Complete	11/29/2022
156	PM00001282	0	0	0	454.45	0	0				Complete	11/29/2022
157	PM00001281	0	0	0	437.13	0	0				Complete	11/29/2022
158	PM00001280	0	0	0	1,499.77	0	0		0	1	Complete	11/29/2022
159	PM00001279	0	0	0	724.86	0	0				Complete	11/29/2022
160	PM00001278	0	0	0	636.76	0	0				Complete	11/28/2022
161	PM00001277	0	0	0	295.39	0	0				Complete	11/28/2022
162	CO00006396	0	0	0	3,296.22	253.02	0	FALSE	0	0	Complete	8/15/2022	253.02
163	PM00001275	0	0	0	214.35	0	0				Complete	11/22/2022
164	PM00001274	0	0	0	673.96	0	0				Complete	11/22/2022
165	PM00001273	0	0	0	179.51	0	0				Complete	11/22/2022
166	PM00001272	0	0	0	819.71	0	0				Complete	11/22/2022
167	PM00001271	0	0	0	1,269.54	0	0				Complete	11/22/2022
168	PM00001270	0	0	0	554.1	0	0				Complete	11/21/2022
169	PM00001268	0	0	0	283.83	0	0				Complete	11/21/2022
170	PM00001267	0	0	0	360.84	0	0				Complete	11/21/2022
171	PM00001266	0	0	0	725.53	0	0				Complete	11/21/2022
172	PM00001265	0	0	0	802.15	0	0				Complete	11/21/2022
173	PM00001264	0	0	0	275.75	0	0				Complete	11/21/2022
174	PM00001263	0	0	0	550.2	0	0				Complete	11/21/2022
175	PM00001262	0	0	0	276.92	0	0				Complete	11/21/2022
176	PM00001261	0	0	0	155.9	0	0				Complete	11/21/2022
177	PM00001260	0	0	0	939.53	0	0				Complete	11/15/2022
178	PM00001259	0	0	0	601.07	0	0				Complete	11/15/2022
179	PM00001258	0	0	0	2,849.11	0	0				Complete	11/15/2022
180	PM00001257	0	0	0	984.81	0	0				Complete	11/15/2022
181	PM00001256	0	0	0	257.52	0	0				Complete	11/15/2022
182	PM00001255	0	0	0	748.83	0	0				Complete	11/15/2022
183	PM00001254	0	0	0	394.31	0	0				Complete	11/15/2022
184	PM00001253	0	0	0	1,041.50	0	0				Complete	11/15/2022
185	PM00001252	0	0	0	1,025.03	0	0				Complete	11/15/2022
186	PM00001251	0	0	0	538.29	0	0				Complete	11/14/2022
187	PM00001250	0	0	0	899.36	0	0				Complete	11/14/2022
188	PM00001249	0	0	0	2,048.47	0	0				Complete	11/14/2022
189	PM00001248	0	0	0	318.55	0	0				Complete	11/14/2022
190	PM00001247	0	0	0	471.39	0	0				Complete	11/14/2022
191	PM00001246	0	0	0	1,060.11	0	0				Complete	11/14/2022
192	PM00001245	0	0	0	153.6	0	0				Complete	11/14/2022
193	PM00001244	0	0	0	452.2	0	0				Complete	11/14/2022
194	PM00001243	0	0	0	2,225.49	0	0				Complete	11/14/2022
195	PM00001242	0	0	0	773.79	0	0				Complete	11/14/2022
196	PM00001241	0	0	0	335.67	0	0				Complete	11/14/2022
197	PM00001240	0	0	0	2,193.82	0	0				Complete	11/14/2022
198	PM00001239	0	0	0	381.2	0	0		95.89	1	Complete	11/11/2022
199	PM00001238	0	0	0	232.29	0	0				Complete	11/8/2022
200	PM00001237	0	0	0	996.47	0	0				Complete	11/8/2022
201	PM00001236	0	0	0	1,426.81	0	0				Complete	11/8/2022
AllCos_20Jan2023

Cell Formulas
Range	Formula
H4,H162,H123,H93,H75,H24:H25	H4	=F4=G4
M4,M162,M123,M93,M75,M24:M25	M4	=VLOOKUP(A4,PostedInv20Jan2023All!C2:E19037,3,FALSE)
G2	G2	=VLOOKUP(A2,PostedSumIfRef!C1:E5478,3,FALSE)
G3,G5:G23,G26:G74,G76:G92,G94:G122,G124:G161,G163:G201	G3	=VLOOKUP(A3,PostedInv20Jan2023Ref!C339:F17837,4,FALSE)
G4	G4	=VLOOKUP(A4,PostedInv20Jan2023Ref!C2621:F20119,4,FALSE)
G24	G24	=VLOOKUP(A24,PostedInv20Jan2023Ref!C3693:F21191,4,FALSE)
G25	G25	=VLOOKUP(A25,PostedInv20Jan2023Ref!C4552:F22050,4,FALSE)
G75	G75	=VLOOKUP(A75,PostedInv20Jan2023Ref!C4678:F22176,4,FALSE)
G93	G93	=VLOOKUP(A93,PostedInv20Jan2023Ref!C5820:F23318,4,FALSE)
G123	G123	=VLOOKUP(A123,PostedInv20Jan2023Ref!C7356:F24854,4,FALSE)
G162	G162	=VLOOKUP(A162,PostedInv20Jan2023Ref!C8083:F25581,4,FALSE)

 

[MacIndy]

Here's a sample of the Posted Invoice Data:

Compare COtoPostedInv.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Invoice Number	Customer	Order	Amount	Freight	SumIf	Misc Charges	VAT Adjusted Sales Tax	State	Created By	Record Date	Name	Invoice Date	Terms Code
2	CR00000703	ALSA001	TaxAdj0002	51.4	0	0	0	-3.6	AK	sa	1/4/2023	Cintas Corporation	1/11/2019	N60
3	4826598	ALSA001	TaxAdj0002	51.4	0	0	0	3.6	AK	sa	1/4/2023	Generation Tux Inc.	8/31/2021	N30
4	CR00000751	ATLA001	RMA0000304	0	0	0	0	0	KY	ar@indyhanger.com	1/19/2023	Robinson Cleaners-Don't do business with	8/31/2021	N30
5	CR00000749	TDCM002	RMA0000303	128.08	0	0	0	-8.1	OH	ar@indyhanger.com	1/17/2023	Cintas Culpeper VA	8/31/2021	N60
6	CR00000748	COLU001	RMA0000302	62.5	0	0	0	0	OH	ar@indyhanger.com	1/17/2023	Springdale Cleaners-4 Monfort Heights	8/31/2021	CC
7	CR00000747	MILT001	RMA0000301	263.22	0	0	0	-17.22	IN	ar@indyhanger.com	1/10/2023	Cintas Salt Lake City UT (S 4370)	8/31/2021	N60
8	CR00000746	DELU001	RMA0000300	93.25	0	0	0	0	OH	ar@indyhanger.com	1/18/2023	Cintas Vidalia GA	8/27/2021	N60
9	CR00000745	TDCS004	RMA0000299	526.5	0	0	0	0	NJ	ar@indyhanger.com	1/10/2023	Springdale Cleaners-2 Northland	8/31/2021	CC
10	CR00000744	DALE001	RMA0000298	69.5	0	0	0	0	OH	ar@indyhanger.com	1/12/2023	Cj's Dry Cleaning	7/28/2022	DUE
11	CR00000743	SUMM001	RMA0000297	0	0	0	0	0	IN	ar@indyhanger.com	1/10/2023	Clean & Fresh	8/24/2021	CC
12	CR00000736	DELU001	RMA0000296	54	0	0	0	-3.51	OH	ar@indyhanger.com	1/18/2023	A-One Fine Dry Cleaning	8/2/2022	CC
13	CR00000735	PLYM001	RMA0000295	1,167.60	0	0	0	-81.73	IN	ar@indyhanger.com	1/18/2023	American Dry Cleaners	8/2/2022	CC
14	CR00000699	DONE001	RMA0000294	267	0	0	0	-18.69	IN	ar@indyhanger.com	1/4/2023	Classic Cleaners (IN)	8/3/2022	N30
15	CR00000697	MBLE004	RMA0000293	42	0	0	0	-3.28	OH	ar@indyhanger.com	12/29/2022	Pleasant Run Cleaners	8/8/2022	DUE
16	CR00000696	CLAS001	RMA0000292	462	0	0	0	-32.34	IN	ar@indyhanger.com	12/29/2022	Sitex Corp. CSC	8/8/2022	N30
17	CR00000694	TDCG001	RMA0000291	1,462.75	0	0	0	-1.49	OH	ar@indyhanger.com	12/22/2022	Unifirst Indianapolis IN	8/1/2022	N45
18	CR00000693	TDCV001	RMA0000290	541.2	0	0	0	-40.59	FL	ar@indyhanger.com	12/29/2022	Suits 20/20	9/7/2021	CC
19	CR00000692	GRIF001	RMA0000289	49.65	0	0	0	0	OH	ar@indyhanger.com	12/27/2022	Bailey's Cleaners	7/19/2022	N30
20	CR00000691	MILT001	RMA0000288	365	0	0	0	-25.55	IN	ar@indyhanger.com	12/29/2022	Cintas Graham NC	9/8/2021	CIN
21	CR00000687	DELU001	RMA0000287	49.75	0	0	0	0	OH	ar@indyhanger.com	12/20/2022	Continental Linen - CSC	10/1/2021	N30
22	CR00000686	DELU003	RMA0000286	67.89	0	0	0	-5.3	OH	ar@indyhanger.com	12/27/2022	Classic Cleaners (IN)	9/30/2021	N30
23	CR00000685	PIER001	RMA0000285	264.12	0	0	0	-35.07	OH	ar@indyhanger.com	12/12/2022	Tide Cleaners Parkland FL	9/30/2021	N30
24	CR00000685	PIER001	RMA0000285	238.5	0	0	0	-35.07	OH	ar@indyhanger.com	12/12/2022	New Style Cleaners	9/30/2021	CC
25	CR00000684	COLU001	RMA0000284	146.47	0	0	0	-10.22	OH	ar@indyhanger.com	12/12/2022	FDR Services Corp of NY	9/30/2021	N30
26	CR00000683	MORE001	RMA0000283	126	0	0	0	-8.82	IN	ar@indyhanger.com	12/13/2022	Nu-Yale Glacier Cleaners	9/30/2021	N30
27	CR00000682	CRDN001	RMA0000282	42	0	0	0	-2.94	IN	ar@indyhanger.com	12/29/2022	Nu-Yale Glacier Cleaners	9/30/2021	N30
28	CR00000680	SAVE001	RMA0000281	102	0	0	0	0	NV	ar@indyhanger.com	1/6/2023	Classic Cleaners (IN)	9/30/2021	N30
29	CR00000679	TDCA001	RMA0000280	119.98	0	0	0	0	OH	ar@indyhanger.com	12/9/2022	Unifirst Garden City KS	9/26/2021	CC
30	CR00000670	MBLE003	RMA0000279	139.29	0	0	0	-10.08	OH	ar@indyhanger.com	11/30/2022	City Cleaners	7/6/2022	CC
31	CR00000669	EAST002	RMA0000278	59.45	0	0	0	-4.64	OH	ar@indyhanger.com	12/7/2022	Dry Clean City	9/20/2021	CC
32	CR00000667	MILT001	RMA0000277	142.68	0	0	0	-9.99	IN	ar@indyhanger.com	12/19/2022	Carriage Cleaners-Maryland Heights	7/13/2022	CC
33	CR00000653	KRON001	RMA0000276	4.49	0	0	0	0	OH	ar@indyhanger.com	11/28/2022	Laxa Cleaners	7/14/2022	N30
34	CR00000652	DELU001	RMA0000275	431.33	0	0	0	-26.33	OH	ar@indyhanger.com	11/17/2022	Cintas Ladson SC	9/9/2021	CIN
35	CR00000650	WEST002	RMA0000274	-0.29	0	0	0	0	OH	ar@indyhanger.com	11/16/2022	New Style Cleaners	9/9/2021	CC
36	CR00000650	WEST002	RMA0000274	10.29	0	0	0	0	OH	ar@indyhanger.com	11/16/2022	Clean X Press	8/11/2022	CC
37	CR00000649	TDCL001	RMA0000273	206	0	0	0	0	OH	ar@indyhanger.com	12/6/2022	Hamilton Trading Co-Don't Do Business With	8/11/2022	N30
38	CR00000648	TDCL002	RMA0000272	31.2	0	0	0	0	OH	ar@indyhanger.com	12/6/2022	Milto Cleaners	8/12/2021	N30
39	CR00000647	SUIT001	RMA0000271	244	0	0	0	0	IL	ar@indyhanger.com	1/3/2023	Hamilton Trading Co-Don't Do Business With	8/11/2022	N30
40	CR00000646	SNOW002	RMA0000270	212.85	0	0	0	-15.96	OH	ar@indyhanger.com	11/17/2022	Saveon Corp.	9/6/2022	CC
41	CR00000645	HERI001	RMA0000269	61.76	0	0	0	-4.47	OH	ar@indyhanger.com	11/16/2022	Milto Cleaners	7/19/2021	N30
42	CR00000644	CROS001	RMA0000268	0	0	0	0	0	IN	ar@indyhanger.com	12/7/2022	LKH Inc. / Dionne Supply	7/8/2021	N30
43	CR00000643	TDCM002	RMA0000267	141.7	0	0	0	0	OH	ar@indyhanger.com	12/7/2022	Cintas Milford OH	7/8/2021	N60
44	CR00000641	ATLA001	RMA0000266	106.5	0	0	0	0	KY	ar@indyhanger.com	11/11/2022	Dale Cleaners	9/15/2022	CC
45	CR00000640	TDCP003	RMA0000265	21	0	0	0	0	OH	ar@indyhanger.com	11/7/2022	A-One Fine Dry Cleaning	7/7/2021	CC
46	CR00000639	LEGA001	RMA0000264	1,579.50	0	0	0	0	OK	ar@indyhanger.com	12/6/2022	Cintas Olathe KS	9/20/2022	CIN
47	CR00000638	WEST002	RMA0000263	57.29	0	0	0	0	OH	ar@indyhanger.com	11/7/2022	Big Apple Cleaners	9/20/2022	CC
48	CR00000634	MILT001	RMA0000262	135.47	0	0	0	-8.86	IN	ar@indyhanger.com	10/28/2022	Miller Textile Services CSC	7/1/2021	N30
49	CR00000629	DALE001	RMA0000261	155.85	0	0	0	-11.69	OH	ar@indyhanger.com	10/27/2022	Miller Textile Services CSC	7/1/2021	N30
50	CR00000628	APPE002	RMA0000260	106.5	0	0	0	0	OH	ar@indyhanger.com	10/24/2022	Sandy's One Hour Cleaners	9/21/2022	DUE
51	CR00000627	TDCL001	RMA0000259	72.56	0	0	0	0	OH	ar@indyhanger.com	10/24/2022	Wildman Uniforms CSC	6/30/2021	N30
52	CR00000625	SUMM001	RMA0000258	52.88	0	0	0	-3.7	IN	ar@indyhanger.com	1/9/2023	Ontario Inc/JR Holdings 1709107	6/30/2021	N30
53	CR00000624	APPE002	RMA0000257	300.83	0	0	0	-20.83	OH	ar@indyhanger.com	10/19/2022	Wildman Uniforms CSC	6/30/2021	N30
54	CR00000623	MBLE002	RMA0000256	70.5	0	0	0	-4.61	OH	ar@indyhanger.com	10/19/2022	Munro's Uniform Services CSC	6/30/2021	N30
55	CR00000621	ALSL003	RMA0000255	730.1	0	0	0	0	NV	ar@indyhanger.com	10/10/2022	West Chester Cleaner's	7/20/2021	N30
56	CR00000620	PRES002	RMA0000254	67.75	0	0	0	-4.74	IN	ar@indyhanger.com	10/10/2022	Cintas Salt Lake City UT (S 4370)	10/1/2021	CIN
57	CR00000619	YOUR001	RMA0000253	84.03	0	0	0	-5.67	OH	ar@indyhanger.com	10/10/2022	Appearance Plus Cleaners, Inc.	7/27/2021	N30
58	CR00000618	COLU001	RMA0000252	48.38	0	0	0	-3.38	OH	ar@indyhanger.com	10/10/2022	Miller Textile Services CSC	7/27/2021	N30
59	CR00000617	PEER001	RMA0000251	52.43	0	0	0	-3.43	IN	ar@indyhanger.com	10/3/2022	Cintas Sacramento CA National Dr	8/12/2021	N60
60	CR00000616	TRIN001	RMA0000250	29.25	0	0	0	-2.05	IN	ar@indyhanger.com	10/19/2022	Haldur Inc DBA Penn 60 Minute Cleaners	3/23/2022	CC
61	CR00000615	GENE004	RMA0000249	7,879.36	0	0	0	-442.38	KY	ar@indyhanger.com	11/18/2022	Cintas Culpeper VA	8/18/2022	CIN
62	CR00000615	GENE004	RMA0000249	861.64	0	0	0	-442.38	KY	ar@indyhanger.com	11/18/2022	EJ Thomas - Fairfield Oh	8/18/2022	N30
63	CR00000612	TDCB002	RMA0000248	827	0	0	0	0	OH	ar@indyhanger.com	1/11/2023	Groesbeck Cleaners	8/19/2022	DUE
64	CR00000609	MBLE003	RMA0000247	15.63	0	0	0	-1.13	OH	ar@indyhanger.com	9/27/2022	Marion County Auditor's Office	8/19/2022
65	CR00000608	MORE001	RMA0000246	57.29	0	0	0	-4.01	IN	ar@indyhanger.com	10/4/2022	LKH Inc. / Dionne Supply	8/19/2022	N30
66	CR00000606	MBLE003	RMA0000245	64.41	0	0	0	-4.66	OH	ar@indyhanger.com	9/21/2022	Milford Cleaners	8/19/2022	DUE
67	CR00000605	CLAS001	RMA0000244	152.37	0	0	0	-15.54	IN	ar@indyhanger.com	9/21/2022	Jubilee Dry Cleaners North	8/19/2022	DUE
68	CR00000605	CLAS001	RMA0000244	5.72	0	0	0	-15.54	IN	ar@indyhanger.com	9/21/2022	Mr. Kelley's Kleaners	8/4/2021	N30
69	CR00000605	CLAS001	RMA0000244	79.45	0	0	0	-15.54	IN	ar@indyhanger.com	9/21/2022	Marion County Auditor's Office	8/23/2022
70	CR00000601	CANN001	RMA0000243	105	0	0	0	0	GA	ar@indyhanger.com	1/19/2023	Dunhill Tuxedos	8/1/2021	N30
71	CR00000600	MART003	RMA0000242	82.35	0	0	0	-6.18	OH	ar@indyhanger.com	9/26/2022	Save Cleaners	8/1/2021	N30
72	CR00000598	SOUT002	RMA0000241	28.62	0	0	0	-1.62	KY	ar@indyhanger.com	9/14/2022	Fabricare Center Sandy Springs	8/1/2021	N30
73	CR00000597	GRAN001	RMA0000240	42	0	0	0	-2.94	IN	ar@indyhanger.com	9/20/2022	Virginia Linen Petersburg VA CSC	8/30/2022	N30
74	CR00000596	TRIN001	RMA0000239	46.07	0	0	0	-5.29	IN	ar@indyhanger.com	9/13/2022	Appearance Plus Cleaners, Inc.	7/27/2021	N30
75	CR00000596	TRIN001	RMA0000239	34.72	0	0	0	-5.29	IN	ar@indyhanger.com	9/13/2022	Your Cleaners	6/30/2021	N30
76	CR00000593	CAPRI01	RMA0000238	23.85	0	0	0	-1.79	OH	ar@indyhanger.com	9/8/2022	LKH Inc. / Dionne Supply	10/1/2021	N30
77	CR00000592	DELU001	RMA0000237	33	0	0	0	0	OH	ar@indyhanger.com	9/9/2022	A-One Fine Dry Cleaning	10/1/2021	CC
78	CR00000591	APPE002	RMA0000236	213	0	0	0	0	OH	ar@indyhanger.com	9/6/2022	Cintas Salt Lake City UT (S 4370)	11/8/2021	CIN
79	CR00000588	YANK001	RMA0000234	58.75	0	0	0	0	NJ	ar@indyhanger.com	8/30/2022	Cintas Houston TX (Kress)	5/31/2022	CIN
80	CR00000585	TDCP003	RMA0000233	169.69	0	0	0	-7.68	OH	ar@indyhanger.com	9/1/2022	Cintas Houston TX (Kress)	5/31/2022	CIN
81	CR00000584	TDCG001	RMA0000232	168	0	0	0	0	OH	ar@indyhanger.com	9/29/2022	Cintas Corporation	11/7/2021	CIN
82	CR00000582	Hald001	RMA0000231	10.25	0	0	0	-0.72	IN	ar@indyhanger.com	8/24/2022	Haldur Inc DBA Penn 60 Minute Cleaners	6/1/2022	N30
83	CR00000583	TDCL002	RMA0000230	63.89	0	0	0	-3.9	OH	ar@indyhanger.com	8/25/2022	Saveon Corp.	6/2/2022	CC
84	CR00000579	ATLA001	RMA0000229	106.5	0	0	0	0	KY	ar@indyhanger.com	8/26/2022	Cintas Spartanburg SC	11/8/2021	CIN
85	CR00000578	Hald001	RMA0000228	104	0	0	0	-7.28	IN	ar@indyhanger.com	8/19/2022	Fabriclean Supply Lenexa Ks	11/1/2021	N30
86	CR00000573	SUNS002	RMA0000227	225.85	0	0	0	-13.55	KY	ar@indyhanger.com	8/19/2022	A-One Fine Dry Cleaning	11/1/2021	CC
87	CR00000571	LIBE001	RMA0000226	69.5	0	0	0	0	OH	ar@indyhanger.com	8/18/2022	Unifirst Simpsonville SC	6/3/2022	CC
88	CR00000570	MORE001	RMA0000225	52	0	0	0	-3.64	IN	ar@indyhanger.com	8/23/2022	Save Cleaners	10/28/2021	CC
89	CR00000569	CINC012	RMA0000224	50.65	0	0	0	0	VA	ar@indyhanger.com	8/18/2022	EJ/NS Farrington & Co	10/27/2021	N30
90	CR00000566	POIN001	RMA0000223	21.96	0	0	0	-1.54	OH	ar@indyhanger.com	9/26/2022	Unifirst Fort Worth TX	10/19/2021	N45
91	CR00000565	DELU003	RMA0000222	17.1	0	0	0	-1.33	OH	ar@indyhanger.com	8/16/2022	Cintas Normal IL	10/18/2021	CIN
92	CR00000564	SPRI002	RMA0000221	41.95	0	0	0	-3.27	OH	ar@indyhanger.com	8/24/2022	Cintas Pico Rivera CA	6/3/2022	CIN
93	CR00000563	SPRI004	RMA0000220	57.5	0	0	0	-4.49	OH	ar@indyhanger.com	8/19/2022	Big Apple Cleaners	11/8/2021	CC
94	CR00000554	GENE004	RMA0000219	233.2	0	0	0	-13.2	KY	ar@indyhanger.com	8/8/2022	Martinizing Gahanna	11/9/2021	CC
95	CR00000553	ROCK001	RMA0000218	57.15	0	0	0	-4.29	OH	ar@indyhanger.com	8/11/2022	Columbus Lace	11/10/2021	N30
96	CR00000551	GRAN001	RMA0000217	57.29	0	0	0	-4.01	IN	ar@indyhanger.com	8/9/2022	Cintas Gilroy CA	11/19/2021	CIN
97	CR00000548	STER002	RMA0000216	241.54	0	0	0	-18.12	OH	ar@indyhanger.com	11/10/2022	Unifirst Phoenix AZ	5/19/2022	N45
98	CR00000547	SIMP001	RMA0000215	239.96	0	0	0	-16.2	OH	ar@indyhanger.com	9/23/2022	Cintas Gilroy CA	11/19/2021	CIN
99	CR00000545	FRESH01	RMA0000214	105.76	0	0	0	-4.12	OH	ar@indyhanger.com	8/24/2022	Cintas Gilroy CA	11/19/2021	CIN
100	CR00000542	UNIF001	RMA0000213	6,340.50	0	0	0	0	OH	ar@indyhanger.com	7/28/2022	Unifirst Indianapolis IN	5/19/2022	N45
101	CR00000544	MILT001	RMA0000212	1,153.46	0	0	0	-75.46	IN	ar@indyhanger.com	7/28/2022	Wausau Chemical	11/18/2021	N30
102	CR00000543	MART004	RMA0000211	121.5	0	0	0	-8.51	OH	ar@indyhanger.com	7/28/2022	Cintas Lancaster NY	11/18/2021	CIN
103	CR00000541	LAXA001	RMA0000210	64.95	0	0	0	-4.55	IN	ar@indyhanger.com	7/28/2022	Cintas Lancaster NY	11/18/2021	CIN
104	CR00000538	UNIW002	RMA0000209	1,924.20	0	0	0	0	NY	ar@indyhanger.com	7/18/2022	Tide-RDR Family Ventures ZZZ, LLC	11/18/2021	N30
105	CR00000540	BART001	RMA0000208	150.5	0	0	0	-11.29	OH	ar@indyhanger.com	7/28/2022	Tide Cleaners Madison Heights MI	11/17/2021	CC
106	CR00000539	LACL001	RMA0000207	62.01	0	0	0	-4.06	OH	ar@indyhanger.com	7/25/2022	Magic Cleaners and Laundry	5/23/2022	N30
107	CR00000536	UNIS006	RMA0000206	384.65	0	0	0	0	CT	ar@indyhanger.com	7/11/2022	Tide-RDR Family Ventures ZZZ, LLC	11/16/2021	N30
108	CR00000535	GENE004	RMA0000205	10	0	0	0	-0.6	KY	ar@indyhanger.com	7/21/2022	Tide Cleaners Omaha NE	11/16/2021	CC
109	CR00000529	CITY003	RMA0000204	1,040.00	0	0	0	-67.6	OH	ar@indyhanger.com	7/6/2022	Sitex Corp. CSC	5/25/2022	N30
110	CR00000528	Hald001	RMA0000203	58.74	0	0	0	-6.15	IN	ar@indyhanger.com	7/5/2022	Carriage Cleaners-Maryland Heights	5/25/2022	CC
111	CR00000528	Hald001	RMA0000203	35.31	0	0	0	-6.15	IN	ar@indyhanger.com	7/5/2022	Cintas Salt Lake City UT (S 5350)	10/18/2021	CIN
112	CR00000517	DALE001	RMA0000201	79.55	0	0	0	-5.55	OH	ar@indyhanger.com	6/23/2022	Cintas Bedford VA	10/18/2021	CIN
113	CR00000515	FOXC001	RMA0000200	1,169.15	0	0	0	-87.69	OH	ar@indyhanger.com	6/22/2022	Cintas Vidalia GA	10/18/2021	CIN
114	CR00000511	MAMC001	RMA0000199	61.81	0	0	0	-4.31	OH	ar@indyhanger.com	6/16/2022	Unifirst Indianapolis IN	10/18/2021	N45
115	CR00000510	PERF001	RMA0000198	63.67	0	0	0	-4.17	IN	ar@indyhanger.com	6/14/2022	Unifirst Jacksonville FL	10/14/2021	N45
116	CR00000503	UNIN002	RMA0000197	1,371.50	0	0	0	0	TN	ar@indyhanger.com	6/28/2022	Morrell's Cleaners	10/13/2021	CC
117	CR00000499	CAPRI01	RMA0000196	45.8	0	0	0	-3.44	OH	ar@indyhanger.com	6/10/2022	Morellis Cleaners	10/13/2021	CC
118	CR00000498	MILT001	RMA0000195	113	0	0	0	0	IN	ar@indyhanger.com	6/8/2022	Classic Cleaners (IN)	10/13/2021	N30
119	CR00000498	MILT001	RMA0000195	43	0	0	0	0	IN	ar@indyhanger.com	6/8/2022	Cintas Emmaus PA	10/13/2021	CIN
120	CR00000497	SPRI002	RMA0000194	29.25	0	0	0	0	OH	ar@indyhanger.com	6/8/2022	Cintas Tampa FL	10/13/2021	CIN
121	CR00000496	GRAN001	RMA0000193	65	0	0	0	-4.55	IN	ar@indyhanger.com	6/14/2022	Cintas Phoenix AZ (Hadley)	10/13/2021	CIN
122	CR00000487	MILT001	RMA0000192	196	0	0	0	0	IN	ar@indyhanger.com	5/27/2022	Cintas Greenville SC	10/12/2021	CIN
123	CR00000486	CLOT002	RMA0000191	59.99	0	0	0	-4.5	OH	ar@indyhanger.com	5/27/2022	Ajax Linen & Uniform CSC-Out of business	6/22/2022	N30
124	CR00000477	TDCG001	RMA0000190	684	0	0	0	0	OH	ar@indyhanger.com	5/19/2022	Ajax Linen & Uniform CSC-Out of business	6/22/2022	N30
125	CR00000476	TDCL001	RMA0000189	22.63	0	0	0	-1.38	OH	ar@indyhanger.com	5/19/2022	Cintas Decatur GA	10/1/2021	CIN
126	CR00000475	SNOW002	RMA0000188	188.88	0	0	0	-13.18	OH	ar@indyhanger.com	5/19/2022	Cintas Frankfort IN	6/27/2022	CIN
127	CR00000474	YOSE001	RMA0000187	259.5	0	0	0	0	CA	ar@indyhanger.com	5/23/2022	Cintas Midland TX	6/27/2022	CIN
128	CR00000464	TDCI001	RMA0000186	134.82	0	0	0	-8.82	IN	ar@indyhanger.com	5/16/2022	Cintas Tampa FL	6/27/2022	CIN
129	CR00000458	DELU001	RMA0000185	35.08	0	0	0	-2.14	OH	ar@indyhanger.com	5/13/2022	Milford Cleaners	6/27/2022	DUE
130	CR00000457	CRDN001	RMA0000184	57.29	0	0	0	-4.01	IN	ar@indyhanger.com	5/23/2022	Cintas Kennesaw GA	10/15/2021	CIN
131	CR00000456	APPE002	RMA0000183	14.01	0	0	0	-1.01	OH	ar@indyhanger.com	5/13/2022	Fabricare Center Sandy Springs	10/1/2021	N30
132	CR00000454	CRDN002	RMA0000182	35.02	0	0	0	-3.19	OH	ar@indyhanger.com	5/9/2022	Cintas Albany GA	10/15/2021	CIN
133	CR00000454	CRDN002	RMA0000182	10.67	0	0	0	-3.19	OH	ar@indyhanger.com	5/9/2022	Cintas Columbus OH	10/15/2021	CIN
134	CR00000453	ROSS002	RMA0000181	94	0	0	0	-7.05	OH	ar@indyhanger.com	5/20/2022	Cintas Indianapolis IN (Georgetown)	10/18/2021	CIN
135	CR00000452	KRON001	RMA0000180	56.85	0	0	0	0	OH	ar@indyhanger.com	5/9/2022	Cintas Midland TX	10/18/2021	CIN
136	CR00000451	APPE002	RMA0000179	13	0	0	0	0	OH	ar@indyhanger.com	5/9/2022	Cintas Indianapolis IN (Park Davis)	10/18/2021	CIN
137	CR00000430	MART004	RMA0000177	52	0	0	0	-3.64	OH	ar@indyhanger.com	4/22/2022	Cintas Greenville SC	10/18/2021	CIN
138	CR00000421	CRDN001	RMA0000176	148.5	0	0	0	-10.4	IN	ar@indyhanger.com	4/26/2022	Cintas Bossier City LA	10/18/2021	CIN
139	CR00000420	MART004	RMA0000175	17.55	0	0	0	-1.23	OH	ar@indyhanger.com	4/22/2022	Unifirst Brooklyn Heights OH	6/14/2022	N45
140	CR00000419	MART002	RMA0000174	110	0	0	0	-8.25	OH	ar@indyhanger.com	4/19/2022	Eastern Hills Dry Cleaners	6/14/2022	CC
141	CR00000416	TDCM002	RMA0000173	41.5	0	0	0	0	OH	ar@indyhanger.com	4/13/2022	Unifirst Pompano Beach FL	6/14/2022	N45
142	CR00000415	TDCP003	RMA0000172	40	0	0	0	-2.8	OH	ar@indyhanger.com	4/19/2022	Unifirst Amarillo TX	6/14/2022	N45
143	CR00000418	ROBI001	RMA0000171	1,764.48	0	0	0	-137.63	WI	ar@indyhanger.com	4/25/2022	Cintas Midland TX	6/14/2022	CIN
144	CR00000410	GRAN001	RMA0000169	73.83	0	0	0	-4.83	IN	ar@indyhanger.com	3/31/2022	Unifirst Pompano Beach FL	6/14/2022	N45
145	CR00000403	ARMS001	RMA0000168	438.9	0	0	0	-30.72	IN	ar@indyhanger.com	3/28/2022	Cintas Dallas TX	10/15/2021	CIN
146	CR00000402	MILT001	RMA0000167	119.8	0	0	0	0	IN	ar@indyhanger.com	4/25/2022	Cintas Gilroy CA	10/15/2021	CIN
147	CR00000401	Hald001	RMA0000166	25.63	0	0	0	-1.68	IN	ar@indyhanger.com	3/24/2022	Cintas Dallas TX	10/15/2021	CIN
148	CR00000399	TRIN001	RMA0000165	88.28	0	0	0	-5.78	IN	ar@indyhanger.com	3/21/2022	Unifirst Brooklyn Heights OH	10/15/2021	N45
149	CR00000351	APPE002	RMA0000164	287.83	0	0	0	-20.83	OH	Secretary@IndyHanger.com	3/10/2022	Cintas North Jackson OH	10/15/2021	CIN
150	CR00000348	MILT001	RMA0000163	122	0	0	0	0	IN	Secretary@IndyHanger.com	3/9/2022	Get Pressed Drycleaner	11/19/2021	N30
151	CR00000342	CINB004	RMA0000161	4,631.40	0	0	0	0	LA	Secretary@IndyHanger.com	3/2/2022	Kingdom Cleaners	6/30/2021	N30
152	CR00000341	CINP008	RMA0000160	395	0	0	0	0	OR	Secretary@IndyHanger.com	12/29/2022	Appearance Plus Cleaners, Inc.	6/30/2021	N30
153	CR00000328	CLAS001	RMA0000159	171.47	0	0	0	-15.4	IN	Secretary@IndyHanger.com	3/1/2022	Plymate CSC	2/9/2021	N30
154	CR00000328	CLAS001	RMA0000159	63.93	0	0	0	-15.4	IN	Secretary@IndyHanger.com	3/1/2022	Clothes Clinic - CSC	2/9/2021	N30
155	CR00000327	GRAN001	RMA0000158	114.58	0	0	0	-8.02	IN	Secretary@IndyHanger.com	3/3/2022	City Uniforms & Linens CSC	2/9/2021	N30
156	CR00000326	Hald001	RMA0000157	151.85	0	0	0	-9.93	IN	Secretary@IndyHanger.com	3/1/2022	Cintas Corporation	2/9/2021	N60
157	CR00000325	MILT001	RMA0000156	37	0	0	0	0	IN	Secretary@IndyHanger.com	3/1/2022	Cintas Corporation	2/9/2021	N60
158	CR00000320	APPE002	RMA0000155	0.18	0	0	0	-2.57	OH	Secretary@IndyHanger.com	2/25/2022	Cintas Corporation	2/9/2021	N60
159	CR00000320	APPE002	RMA0000155	35.34	0	0	0	-2.57	OH	Secretary@IndyHanger.com	2/25/2022	Ajax Linen & Uniform CSC-Out of business	2/9/2021	N30
160	CR00000319	SPRI002	RMA0000154	92.5	0	0	0	-7.22	OH	Secretary@IndyHanger.com	3/14/2022	Unifirst Indianapolis IN	2/9/2021	N45
161	CR00000318	CINL008	RMA0000153	10,605.60	0	0	0	-636.34	KY	Secretary@IndyHanger.com	2/24/2022	Andy's Cleaners	2/8/2021	N30
162	CR00000314	TDCL002	RMA0000152	51.65	0	0	0	-3.15	OH	Secretary@IndyHanger.com	2/22/2022	Cintas Corporation	2/5/2021	N60
163	CR00000313	ATLA001	RMA0000151	277	0	0	0	-16.62	KY	Secretary@IndyHanger.com	3/1/2022	Cintas Corporation	2/5/2021	N60
164	CR00000312	Hald001	RMA0000150	83.46	0	0	0	-5.46	IN	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/5/2021	N60
165	CR00000317	YOSE001	RMA0000149	216.6	0	0	0	0	CA	Secretary@IndyHanger.com	5/17/2022	Cintas Corporation	2/5/2021	N60
166	CR00000316	YOSE001	RMA0000148	393.2	0	0	0	0	CA	Secretary@IndyHanger.com	5/17/2022	Cintas Corporation	2/5/2021	N60
167	CR00000310	MILT001	RMA0000147	196	0	0	0	0	IN	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
168	CR00000309	ROCK001	RMA0000145	92.45	0	0	0	-6.45	OH	Secretary@IndyHanger.com	2/21/2022	Clean Uniform Highland IL CSC	2/9/2021	N30
169	CR00000308	TDCA001	RMA0000144	48.5	0	0	0	0	OH	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
170	CR00000307	DELU001	RMA0000142	42.6	0	0	0	-2.6	OH	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
171	CR00000306	AONE001	RMA0000141	413.06	0	0	0	-29.56	OH	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/10/2021	N60
172	CR00000306	AONE001	RMA0000141	-4.5	0	0	0	-29.56	OH	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/10/2021	N60
173	CR00000305	TDCA001	RMA0000140	97	0	0	0	0	OH	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/10/2021	N60
174	CR00000304	SPRI005	RMA0000139	48.99	0	0	0	-7.49	OH	Secretary@IndyHanger.com	2/21/2022	Phelps Uniforms CSC	2/10/2021	N30
175	CR00000304	SPRI005	RMA0000139	54.5	0	0	0	-7.49	OH	Secretary@IndyHanger.com	2/21/2022	Sunshine Cleaners IN	2/10/2021	N30
176	CR00000303	UNIM001	RMA0000138	2,940.30	0	0	0	0	IL	Secretary@IndyHanger.com	3/2/2022	Cintas Corporation	2/10/2021	N60
177	CR00000302	UNIM001	RMA0000137	4,943.25	0	0	0	0	IL	Secretary@IndyHanger.com	3/2/2022	Cintas Corporation	2/9/2021	N60
178	CR00000301	CINP003	RMA0000136	3,652.68	0	0	0	0	OH	Secretary@IndyHanger.com	4/8/2022	Cintas Corporation	2/9/2021	N60
179	CR00000300	STAR007	RMA0000135	58.32	0	0	0	-3.82	IN	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
180	CR00000299	APEX001	RMA0000134	109	0	0	0	0	NV	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
181	CR00000298	UNIO002	RMA0000133	1,061.45	0	0	0	0	CA	Secretary@IndyHanger.com	2/21/2022	National Uniform Rentals/National Cleaners	2/9/2021	N30
182	CR00000297	TDCF001	RMA0000132	134.82	0	0	0	-8.82	IN	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
183	CR00000296	TDCF001	RMA0000131	54.57	0	0	0	-3.57	IN	Secretary@IndyHanger.com	2/21/2022	Cintas Corporation	2/9/2021	N60
184	CR00000291	UNIL002	RMA0000130	6,545.00	0	0	0	0	KY	Secretary@IndyHanger.com	2/3/2022	Cintas Corporation	2/9/2021	N60
185	CR00000290	TDCB002	RMA0000129	51	0	0	0	0	OH	Secretary@IndyHanger.com	3/23/2022	Cintas Corporation	2/9/2021	N60
186	CR00000289	MART003	RMA0000128	50.5	0	0	0	0	OH	Secretary@IndyHanger.com	2/1/2022	Cintas Corporation	2/5/2021	N60
187	CR00000288	TDCL001	RMA0000127	44.2	0	0	0	-2.7	OH	Secretary@IndyHanger.com	2/1/2022	Cintas Corporation	2/5/2021	N60
188	CR00000270	LACL001	RMA0000126	119.98	0	0	0	-8.4	OH	Secretary@IndyHanger.com	3/23/2022	Paris Cleaners	2/5/2021	N30
189	CR00000269	TRIN001	RMA0000125	26.26	0	0	0	-1.72	IN	Secretary@IndyHanger.com	1/25/2022	Cintas Corporation	2/5/2021	N60
190	CR00000267	TDCM002	RMA0000124	9.65	0	0	0	0	OH	Secretary@IndyHanger.com	1/27/2022	Cintas Corporation	2/3/2021	N60
191	CR00000266	GEIS001	RMA0000123	69.55	0	0	0	-4.55	IN	Secretary@IndyHanger.com	1/21/2022	Village Cleaners	2/3/2021	N30
PostedInv20Jan2023All

Cell Formulas
Range	Formula
F2:F191	F2	=SUMIF($C$2:$C$19037,C2,$E$2:$E$19037)

 

[MacIndy]

Perhaps it would help if we did this a little differently. Unless you have a simpler way to do it.

The Accum Freight property on the Customer Order is supposed to be dead accurate. It gets updated when a shipment is created.

The Posted Invoices Table is all Invoices and adjustments that have been applied against every order. There can be multiple shipments against the same order and multiple RMAS and credits. So, there is often more than one row with the same order number. So, I tried shrinking it down to one row to make my initial comparisons. This is how I did it:

1. I inserted a column called SumIF with the following formula: =SUMIF($C$2:$C$19037,C2,$E$2:$E$19037) The intent here was to basically turn the One (Customer Orders) to Manay (Posted Invoices) relationship into a One to One by basically giving me a Accum Freight column (SumIf) on Posted Invoices.
2. I then highlighted all data and went to Data --> Filter
3. I then clicked on the column header drop down for the Sumif column and unselected 0 dollar values to remove all the freight options that sum'd as 0

The above allowed me to reduce the total rows I was looking at from 19036 to 5453
4. I then highlighted all data --> Clicked Data --> Remove Duplicates --> Unselected all --> Selected Orders (Needed to do this because I already have a Sumif with the total of all freight costs Invoiced against each order, so I don't need multiple rows for the same order.

Removing duplicates got me down to 3,654 records.

5. I then added a column for VLookup and inserted the following formula: =VLOOKUP(C296, AllCos_20Jan2023All!$A$2:$F$14048,6,FALSE) This allowed me to put the actual Accum Freight from the Customer Orders onto the same worksheet I built the Sumif column (Posted Invoices)
6. I then inserted another column and did a simple match between the Sumif and the Accum Freight I brought in from Customer orders.
7. I then filtered the Match column to only show results of False. These would be the ones where the Accum Freight from the Customer Order Table doesn't match the SumIf result I created on this one. This got me down to 415 records. Now at this point I'm trying to figure out why these 414 discrepancies exist without going through them one at a time.
8. On the 415 discrepancies I noticed I noticed the Accum Freight from Customer Orders is always higher than the Posted Invoice Amounts. So, I inserted another column that subtracts the SumIf column from the Accum Freight column. This is where I discovered, if the Accum Freight information from the Customer Order is correct, then we have undercharged freight to the tune of $197,847.60.

My theory is that the Accum Freight data may not be 100% accurate even though I'm told its supposed to be.

Now I have a list of Customer Orders (414) with discrepancies between Custom Order Accum Freight and Posted Invoice Freight. So...
I'm wondering if the best approach for me now is to do this:
1. Insert at least 10 columns to the right of my data for the 414 records
2. Column 1 - Create a formula that looks at an unaltered original version of the Posted Invoices Dump that still has over 19,000 rows and display the first Freight amount it finds
3. Column 2 - same as above but for the second Freight Amount it finds
4. Column 3-10 - And so on.

Is there a formula that would look for the 1st, 2nd, and 3rd, and so on records it finds that matches a criteria in a separate worksheet?