Fuel Card Mismatch Report [PUBLIC].xlsx

	A	B	E	F	K	L	M	N	S	T	U	AA
1	**Fuel Card Mismatch		Mar 29, 2017
2	ABC Company
3												**Missing Location Data
4	**Date											**Missing Transaction Data
5	**From	March 19, 2017										**Missing Fuel Data
6	**To	March 25, 2017										**Missing Vehicle Data
7	**Days	7										**Missing Data
8												**TRUE
9	**Distance Unit	km										**FALSE
10	**Fuel Volume Unit	L							**GPS location and transaction location match	**Fuel added does not exceed estimated tank capacity by more than 5%	**Vehicle fill-up detected close to transaction time	**Fuel Card Mismatches
11	**Fuel Economy Unit	L/100 km
12	**Currency	USD
13
14	**Vehicle	**Vehicle Group	**Date	**GPS Location	**Fuel Economy	**Fuel Added	**Odometer	**Cost	**Location Match	**Within Tank Capacity	**Fill-Up Detected

15	Vehile 1	Entire Organization	5/22/18 2:26 PM	123 Road		22.76	49452.4	90.11	**TRUE	**TRUE	**TRUE
16	Vehile 2	Entire Organization	5/25/18 6:22 PM	124 Road	8.35	28.10	9089.8		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
17	Vehile 3	Entire Organization	5/22/18 2:26 PM	125 Road		27.52		97.38	**TRUE	**TRUE	**FALSE
18	Vehile 4	Entire Organization	5/24/18 9:54 AM	126 Road	20.31	14.47	68305.8	55.00	**Missing Location Data	**Missing Fuel Data	**Missing Fuel Data
19	Vehile 5	Entire Organization	5/24/18 9:20 AM	127 Road		13.51	46413.3		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
20	Vehile 6	Entire Organization	5/25/18 2:11 PM	128 Road	14.38	27.96	68824.7		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
21	Vehile 7	Entire Organization	5/23/18 1:14 PM	129 Road	11.51	28.17	1418.6	94.62	**TRUE	**TRUE	**TRUE
22	Vehile 8	Entire Organization	5/22/18 8:06 PM	130 Road	12.84	34.41	58122.7		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
23	Vehile 9	Entire Organization	5/23/18 2:01 PM	131 Road	11.39	5.71	58187.4		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
24	Vehile 10	Entire Organization	5/25/18 11:22 AM	132 Road	12.91	10.57	58323.8		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
25	Vehile 11	Entire Organization	5/21/18 12:29 PM	133 Road	12.16	28.72	53884.8	96.48	**TRUE	**TRUE	**TRUE
26	Vehile 12	Entire Organization	5/21/18 11:26 AM	134 Road	14.50	25.14	1091.3		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
27	Vehile 13	Entire Organization	5/22/18 4:53 PM	135 Road	14.61	26.70	1179.4	89.70	**TRUE	**TRUE	**TRUE
28	Vehile 14	Entire Organization	5/20/18 10:07 PM	136 Road	15.71	21.21	59987.9	71.25	**Missing Location Data	**TRUE	**TRUE
29	Vehile 15	Entire Organization	5/23/18 11:53 PM	137 Road	14.67	23.99	60315.9	80.60	**TRUE	**Missing Fuel Data	**Missing Fuel Data
30	Vehile 16	Entire Organization	5/25/18 12:15 PM	138 Road	15.06	22.89	60660.9		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
31	Vehile 17	Entire Organization	5/26/18 6:20 PM	139 Road	14.49	28.05	61066.6		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
32	Vehile 18	Entire Organization	5/25/18 11:03 AM	140 Road	13.86	21.36	48218.0		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
33	Vehile 19	Entire Organization	5/20/18 10:32 AM	141 Road		10.66	30850.9	39.44	**FALSE	**TRUE	**FALSE
34	Vehile 20	Entire Organization	5/23/18 8:18 AM	142 Road	13.60	25.31	30851.6	85.02	**TRUE	**TRUE	**TRUE
35	Vehile 21	Entire Organization	5/22/18 7:49 AM	143 Road	14.66	9.16	43010.2	30.13	**TRUE	**TRUE	**TRUE
36	Vehile 22	Entire Organization	5/24/18 7:35 AM	144 Road	12.68	22.10	43105.6	72.91	**TRUE	**TRUE	**TRUE
37	Vehile 23	Entire Organization	5/24/18 5:06 PM	145 Road	14.77	11.90	43243.5	39.98	**TRUE	**TRUE	**TRUE
38	Vehile 24	Entire Organization	5/26/18 2:47 PM	146 Road	11.85	10.91	43372.5		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
39	Vehile 25	Entire Organization	5/23/18 9:27 AM	147 Road	10.55	28.95	50088.4	97.24	**FALSE	**TRUE	**TRUE
40	Vehile 26	Entire Organization	5/26/18 7:05 PM	148 Road	9.60	30.34	50379.5		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
41	Vehile 27	Entire Organization	5/23/18 3:18 PM	149 Road	15.04	24.11	139867.7		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
42	Vehile 28	Entire Organization	5/26/18 7:55 AM	150 Road	12.15	8.68	139973.1		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
43	Vehile 29	Entire Organization	5/24/18 8:22 AM	151 Road		25.02		90.06	**TRUE	**TRUE	**TRUE
44	Vehile 30	Entire Organization	5/23/18 8:26 AM	152 Road		11.63	42623.5	39.07	**TRUE	**TRUE	**FALSE
45	Vehile 31	Entire Organization	5/24/18 3:51 PM	153 Road	10.96	27.06	42742.6	89.55	**TRUE	**TRUE	**TRUE
46	Vehile 32	Entire Organization	5/20/18 8:09 AM	154 Road		10.56	126726.9	30.00	**TRUE	**TRUE	**TRUE
47	Vehile 33	Entire Organization	5/22/18 9:29 AM	155 Road		25.82	126726.9	71.23	**TRUE	**TRUE	**TRUE
48	Vehile 34	Entire Organization	5/21/18 5:31 PM	156 Road	6.34	34.23	5290.5	106.75	**TRUE	**TRUE	**TRUE
49	Vehile 35	Entire Organization	5/26/18 9:49 AM	157 Road	13.79	24.08	39406.9		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
50	Vehile 36	Entire Organization	5/21/18 8:50 AM	158 Road	11.43	28.06	60214.9	80.23	**TRUE	**TRUE	**TRUE
51	Vehile 37	Entire Organization	5/24/18 10:06 AM	159 Road	9.29	17.74	60451.8	50.00	**TRUE	**TRUE	**TRUE
52	Vehile 38	Entire Organization	5/23/18 3:25 PM	160 Road		27.73	49906.4		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
53	Vehile 39	Entire Organization	5/23/18 9:24 AM	161 Road	20.52	12.62	43823.8	36.09	**TRUE	**TRUE	**TRUE
54	Vehile 40	Entire Organization	5/22/18 9:24 AM	162 Road	12.96	27.22	51666.7	81.63	**TRUE	**TRUE	**TRUE
55	Vehile 41	Entire Organization	5/25/18 3:16 PM	163 Road	14.42	23.63	52007.3		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
56	Vehile 42	Entire Organization	5/23/18 6:16 AM	164 Road	26.51	10.53	41682.1	30.95	**TRUE	**TRUE	**TRUE
57	Vehile 43	Entire Organization	5/24/18 5:01 PM	165 Road	27.37	26.53	41908.6	75.31	**TRUE	**FALSE	**TRUE
58	Vehile 44	Entire Organization	5/21/18 12:59 PM	166 Road	13.33	28.74	58053.5	80.73	**TRUE	**TRUE	**TRUE
59	Vehile 45	Entire Organization	5/24/18 10:43 PM	167 Road	13.54	26.28	58409.2		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
60	Vehile 46	Entire Organization	5/21/18 5:13 PM	168 Road	8.29	26.86	120992.2	82.34	**TRUE	**TRUE	**TRUE
61	Vehile 47	Entire Organization	5/22/18 9:21 AM	169 Road	6.56	4.45	120996.4	14.26	**TRUE	**TRUE	**FALSE
62	Vehile 48	Entire Organization	5/25/18 10:52 AM	170 Road	12.93	24.11	63927.4		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
63	Vehile 49	Entire Organization	5/23/18 12:32 PM	171 Road	13.86	27.22	58281.7	76.19	**TRUE	**TRUE	**TRUE
64	Vehile 50	Entire Organization	5/24/18 1:52 PM	172 Road	23.42	13.99	36881.8	38.59	**TRUE	**TRUE	**TRUE
65	Vehile 51	Entire Organization	5/23/18 4:25 PM	173 Road		29.27	54214.6	83.12	**TRUE	**TRUE	**TRUE
66	Vehile 52	Entire Organization	5/21/18 2:14 PM	174 Road	9.60	13.16	60692.2		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
67	Vehile 53	Entire Organization	5/24/18 6:04 AM	175 Road	10.54	8.40	60780.6		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
68	Vehile 54	Entire Organization	5/24/18 1:26 PM	176 Road	12.71	4.09	60833.3		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
69	Vehile 55	Entire Organization	5/22/18 7:07 AM	177 Road		20.54	139088.3	57.08	**FALSE	**TRUE	**TRUE
70	Vehile 56	Entire Organization	5/24/18 12:46 PM	178 Road		26.14	139088.3	74.75	**FALSE	**TRUE	**TRUE
71	Vehile 57	Entire Organization	5/22/18 6:02 AM	179 Road	14.69	19.74	102803.8		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
72	Vehile 58	Entire Organization	5/24/18 11:56 AM	180 Road	12.98	25.71	103141.4		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
73	Vehile 59	Entire Organization	5/24/18 8:18 AM	181 Road	13.91	25.34	35760.6	72.46	**TRUE	**TRUE	**TRUE
74	Vehile 60	Entire Organization	5/23/18 5:38 AM	182 Road	10.63	24.71	166441.1	70.65	**TRUE	**TRUE	**TRUE
75	Vehile 61	Entire Organization	5/25/18 7:18 AM	183 Road	13.30	11.24	76747.6		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
76	Vehile 62	Entire Organization	5/25/18 10:15 AM	184 Road	12.00	25.99	92913.1		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
77	Vehile 63	Entire Organization	5/26/18 8:46 AM	185 Road	11.55	8.73	93013.9		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
78	Vehile 64	Entire Organization	5/20/18 12:00 PM	186 Road	23.46	13.35	3638.0	49.40	**TRUE	**TRUE	**TRUE
79	Vehile 65	Entire Organization	5/22/18 11:38 AM	187 Road	24.28	11.96	3900.7	45.44	**TRUE	**TRUE	**TRUE
80	Vehile 66	Entire Organization	5/23/18 5:04 PM	188 Road	24.23	10.58	4157.6	40.00	**TRUE	**TRUE	**TRUE
81	Vehile 67	Entire Organization	5/23/18 7:57 PM	189 Road	23.23	2.50	4215.8		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
82	Vehile 68	Entire Organization	5/25/18 9:55 AM	190 Road	24.22	8.77	4428.2		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
83	Vehile 69	Entire Organization	5/24/18 12:53 PM	191 Road		12.18	1506.7	47.01	**TRUE	**TRUE	**TRUE
84	Vehile 70	Entire Organization	5/21/18 12:10 PM	192 Road	13.29	23.45	74735.2		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
85	Vehile 71	Entire Organization	5/24/18 2:40 PM	193 Road	12.22	25.99	75052.8		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
86	Vehile 72	Entire Organization	5/21/18 10:03 AM	194 Road	19.93	27.55	68581.3	109.08	**TRUE	**TRUE	**TRUE
87	Vehile 73	Entire Organization	5/23/18 4:08 PM	195 Road	15.06	26.67	68963.7	98.65	**TRUE	**TRUE	**TRUE
88	Vehile 74	Entire Organization	5/25/18 3:17 PM	196 Road	23.11	12.10	69243.2		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
89	Vehile 75	Entire Organization	5/20/18 12:47 PM	197 Road	13.78	24.48	17015.5	94.49	**TRUE	**TRUE	**TRUE
90	Vehile 76	Entire Organization	5/24/18 10:40 AM	198 Road	13.98	28.46	17279.7	111.00	**TRUE	**TRUE	**FALSE
91	Vehile 77	Entire Organization	5/25/18 2:30 PM	199 Road	12.24	3.13	17318.1		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
92	Vehile 78	Entire Organization	5/21/18 12:02 PM	200 Road	20.81	23.23	13226.2	92.00	**FALSE	**TRUE	**FALSE
93	Vehile 79	Entire Organization	5/23/18 6:08 PM	201 Road	18.26	9.21	13396.5		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
94	Vehile 80	Entire Organization	5/24/18 10:40 AM	202 Road	17.51	27.36	13486.6	106.69	**FALSE	**TRUE	**TRUE
95	Vehile 81	Entire Organization	5/21/18 9:07 AM	203 Road		25.40	55140.0	95.00	**FALSE	**TRUE	**TRUE
96	Vehile 82	Entire Organization	5/22/18 4:44 PM	204 Road	13.88	19.24	55407.0	75.00	**TRUE	**TRUE	**FALSE
97	Vehile 83	Entire Organization	5/24/18 8:41 AM	205 Road		22.49	55407.0	85.00	**TRUE	**TRUE	**TRUE
98	Vehile 84	Entire Organization	5/24/18 10:30 AM	206 Road	4.65	8.50	55446.5		**Missing Transaction Data	**Missing Transaction Data	**Missing Transaction Data
99	Vehile 85	Entire Organization	5/22/18 5:24 PM	207 Road	14.37	29.23	73228.2	112.81	**TRUE	**TRUE	**TRUE
100	Vehile 86	Entire Organization	5/24/18 7:25 PM	208 Road	16.20	29.19	73462.4	115.57	**TRUE	**TRUE	**TRUE