Spreadsheet: 874695d1721229709-formula-needed-june-deduction-test
Sheet: June Bill

Client ID | Client Name | Invoice Date | Invoice Number | DENTAL PREMIUM | VISION PREMIUM | Total [NAME]
5 | Name 1 | 2024-06-07 00:00:00 | 50975 | 334.11 | 85.18 | 419.29
5 | Name 2 | 2024-06-07 00:00:00 | 50976 | 138.84 | 29.62 | 168.46
5 | Name 3 | 2024-06-21 00:00:00 | 50977 | 334.11 | 85.18 | 419.29
5 | Name 4 | 2024-06-21 00:00:00 | 50978 | 138.84 | 29.62 | 168.46
75 | Name 5 | 2024-06-14 00:00:00 | 50979 | 0 | 0 | 0
75 | Name 6 | 2024-06-28 00:00:00 | 50980 | 35.05 | 10.51 | 45.56
119 | Name 7 | 2024-06-07 00:00:00 | 50981 |  | 0 | 0
119 | Name 8 | 2024-06-21 00:00:00 | 50982 |  | 15.36 | 15.36
124 | Name 9 | 2024-06-13 00:00:00 | 50983 | 0 | 0 | 0
124 | Name 10 | 2024-06-27 00:00:00 | 50984 | 3744.64 | 368.29 | 4112.93
138 | Name 11 | 2024-06-07 00:00:00 | 50985 | 0 | 0 | 0
138 | Name 12 | 2024-06-14 00:00:00 | 50986 | 0 | 0 | 0
138 | Name 13 | 2024-06-21 00:00:00 | 50987 | 0 | 0 | 0
138 | Name 14 | 2024-06-28 00:00:00 | 50988 | 695.49 | 153.78 | 849.27
165 | Name 15 | 2024-06-13 00:00:00 | 50989 | 0 | 0 | 0
165 | Name 16 | 2024-06-27 00:00:00 | 50990 | 327.83 | 75.98 | 403.81
171 | Name 17 | 2024-06-14 00:00:00 | 50991 | 0 | 0 | 0
179 | Name 18 | 2024-06-07 00:00:00 | 50992 | 0 | 0 | 0
179 | Name 19 | 2024-06-14 00:00:00 | 50993 | 0 | 0 | 0
179 | Name 20 | 2024-06-21 00:00:00 | 50994 | 0 | 0 | 0
179 | Name 21 | 2024-06-28 00:00:00 | 50995 | 47.94 | 31.53 | 79.47
182 | Name 22 | 2024-06-13 00:00:00 | 50996 | -49.99 | -10.51 | -60.5
182 | Name 23 | 2024-06-27 00:00:00 | 50997 | 2247.59 | 224.42 | 2472.01
191 | Name 24 | 2024-06-07 00:00:00 | 50998 | 0 | 0 | 0
191 | Name 25 | 2024-06-21 00:00:00 | 50999 | 375.67 | 27.66 | 403.33
205 | Name 26 | 2024-06-14 00:00:00 | 51000 | 305.41 | 80.2 | 385.61
205 | Name 27 | 2024-06-28 00:00:00 | 51001 | 0 | 0 | 0
218 | Name 28 | 2024-06-07 00:00:00 | 51002 | 0 | 0 | 0
218 | Name 29 | 2024-06-14 00:00:00 | 51003 | 0 | 0 | 0
218 | Name 30 | 2024-06-21 00:00:00 | 51004 | 0 | 0 | 0
218 | Name 31 | 2024-06-28 00:00:00 | 51005 | 155.06 | 54.96 | 210.02
227 | Name 32 | 2024-06-14 00:00:00 | 51006 | 0 | 0 | 0
227 | Name 33 | 2024-06-28 00:00:00 | 51007 | 439.92 | 65.81 | 505.73
232 | Name 34 | 2024-06-07 00:00:00 | 51008 | 92.83 | 14.14 | 106.97
232 | Name 35 | 2024-06-14 00:00:00 | 51009 | 92.83 | 14.14 | 106.97
232 | Name 36 | 2024-06-21 00:00:00 | 51010 | 92.83 | 14.14 | 106.97
232 | Name 37 | 2024-06-28 00:00:00 | 51011 | 92.83 | 14.14 | 106.97
260 | Name 38 | 2024-06-07 00:00:00 | 51012 | 0 | 0 | 0
260 | Name 39 | 2024-06-14 00:00:00 | 51013 | 0 | 0 | 0
260 | Name 40 | 2024-06-21 00:00:00 | 51014 | 0 | 0 | 0
260 | Name 41 | 2024-06-21 00:00:00 | 51015 | 0 | 0 | 0
260 | Name 42 | 2024-06-21 00:00:00 | 51016 | 0 | 0 | 0
260 | Name 43 | 2024-06-28 00:00:00 | 51017 | 1287 | 255.94 | 1542.94
264 | Name 44 | 2024-06-07 00:00:00 | 51018 |  | 0 | 0
264 | Name 45 | 2024-06-21 00:00:00 | 51019 |  | 194.36 | 194.36
266 | Name 46 | 2024-06-14 00:00:00 | 51020 | 0 | 0 | 0
266 | Name 47 | 2024-06-28 00:00:00 | 51021 | 160.22 | 10.51 | 170.73
274 | Name 48 | 2024-06-07 00:00:00 | 51022 | -49.99 | -10.51 | -60.5
274 | Name 49 | 2024-06-21 00:00:00 | 51023 | 124.43 | 38.17 | 162.6
276 | Name 50 | 2024-06-07 00:00:00 | 51024 | 601.08 | 190.49 | 791.57
276 | Name 51 | 2024-06-21 00:00:00 | 51025 | 0 | 0 | 0
286 | Name 52 | 2024-06-14 00:00:00 | 51026 | 0 | 0 | 0
286 | Name 53 | 2024-06-28 00:00:00 | 51027 | 160.13 | 27.31 | 187.44
291 | Name 54 | 2024-06-14 00:00:00 | 51028 | 0 | 0 | 0
291 | Name 55 | 2024-06-28 00:00:00 | 51029 | 859.42 | 155.5 | 1014.92
292 | Name 56 | 2024-06-14 00:00:00 | 51030 | 0 | 0 | 0
292 | Name 57 | 2024-06-28 00:00:00 | 51031 | 1198.93 | 175.4 | 1374.33
295 | Name 58 | 2024-06-07 00:00:00 | 51032 |  | 391.12 | 391.12
295 | Name 59 | 2024-06-21 00:00:00 | 51033 |  | 0 | 0
296 | Name 60 | 2024-06-07 00:00:00 | 51034 | 0 | 0 | 0
296 | Name 61 | 2024-06-21 00:00:00 | 51035 | 478.41 | 107.86 | 586.27
297 | Name 62 | 2024-06-13 00:00:00 | 51036 | 0 | 0 | 0
297 | Name 63 | 2024-06-27 00:00:00 | 51037 | 599.68 | 107.51 | 707.19
298 | Name 64 | 2024-06-07 00:00:00 | 51038 | 0 | 0 | 0
298 | Name 65 | 2024-06-14 00:00:00 | 51039 | 0 | 0 | 0
298 | Name 66 | 2024-06-21 00:00:00 | 51040 | 0 | 0 | 0
298 | Name 67 | 2024-06-28 00:00:00 | 51041 | 63.36 | 10.51 | 73.87
300 | Name 68 | 2024-06-07 00:00:00 | 51042 | 2420.14 | 445.05 | 2865.19
300 | Name 69 | 2024-06-21 00:00:00 | 51043 | -35.05 | -10.51 | -45.56
301 | Name 70 | 2024-06-14 00:00:00 | 51044 | 321.9 | 75.64 | 397.54
301 | Name 71 | 2024-06-28 00:00:00 | 51045 | 0 | 0 | 0
303 | Name 72 | 2024-06-07 00:00:00 | 51046 | 128.77 | 21.02 | 149.79
303 | Name 73 | 2024-06-21 00:00:00 | 51047 | 0 | 0 | 0
304 | Name 74 | 2024-06-13 00:00:00 | 51048 | 179.15 | 31.53 | 210.68
304 | Name 75 | 2024-06-27 00:00:00 | 51049 | 0 | 0 | 0
308 | Name 76 | 2024-06-14 00:00:00 | 51050 | 144.1 | 21.02 | 165.12
308 | Name 77 | 2024-06-28 00:00:00 | 51051 | 0 | 0 | 0
313 | Name 78 | 2024-06-26 00:00:00 | 51052 | 0 | 0 | 0
313 | Family & Co. Jewelers | 2024-06-12 00:00:00 | 51004 | 659.25 | 116.22 | 775.47
314 | Name 79 | 2024-06-07 00:00:00 | 51053 | 848.66 | 126.74 | 975.4
314 | Name 80 | 2024-06-14 00:00:00 | 51054 | 0 | 0 | 0
314 | Name 81 | 2024-06-21 00:00:00 | 51055 | 0 | 0 | 0
314 | Name 82 | 2024-06-28 00:00:00 | 51056 | 0 | 0 | 0
320 | Name 83 | 2024-06-06 00:00:00 | 51057 | 0 | 0 | 0
320 | Name 84 | 2024-06-13 00:00:00 | 51058 | -35.05 | -10.51 | -45.56
320 | Name 85 | 2024-06-20 00:00:00 | 51059 | 0 | 0 | 0
320 | Name 86 | 2024-06-27 00:00:00 | 51060 | 394.75 | 134.48 | 529.23
329 | Name 87 | 2024-06-14 00:00:00 | 51061 | 169.25 | 63.06 | 232.31
329 | Name 88 | 2024-06-28 00:00:00 | 51062 | 0 | 0 | 0
332 | Name 89 | 2024-06-14 00:00:00 | 51063 | 553.87 | 135.18 | 689.05
332 | Name 90 | 2024-06-28 00:00:00 | 51064 | 0 | 0 | 0
340 | Name 91 | 2024-06-14 00:00:00 | 51065 | 35.05 | 10.51 | 45.56
340 | Name 92 | 2024-06-28 00:00:00 | 51066 | 0 | 0 | 0
345 | Name 93 | 2024-06-14 00:00:00 | 51067 | 86.26 | 16.8 | 103.06
345 | Name 94 | 2024-06-28 00:00:00 | 51068 | 0 | 0 | 0
349 | Name 95 | 2024-06-07 00:00:00 | 51069 | 117.58 |  | 117.58
349 | Name 96 | 2024-06-21 00:00:00 | 51070 | 0 |  | 0
350 | Name 97 | 2024-06-07 00:00:00 | 51071 | 412.48 | 63.06 | 475.54
350 | Name 98 | 2024-06-21 00:00:00 | 51072 | 0 | 0 | 0
352 | Name 99 | 2024-06-07 00:00:00 | 51073 |  | 27.31 | 27.31
352 | Name 100 | 2024-06-14 00:00:00 | 51074 |  | 0 | 0
352 | Name 101 | 2024-06-21 00:00:00 | 51075 |  | 0 | 0
352 | Name 102 | 2024-06-28 00:00:00 | 51076 |  | 0 | 0
367 | Name 103 | 2024-06-07 00:00:00 | 51077 | 219.39 | 48.67 | 268.06
367 | Name 104 | 2024-06-14 00:00:00 | 51078 | 0 | 0 | 0
367 | Name 105 | 2024-06-21 00:00:00 | 51079 | 0 | 0 | 0
367 | Name 106 | 2024-06-28 00:00:00 | 51080 | 0 | 0 | 0
370 | Name 107 | 2024-06-07 00:00:00 | 51081 | 247.71 | 60.84 | 308.55
370 | Name 108 | 2024-06-14 00:00:00 | 51082 | 0 | 6.91 | 6.91
370 | Name 109 | 2024-06-21 00:00:00 | 51083 | 0 | 6.91 | 6.91
370 | Name 110 | 2024-06-28 00:00:00 | 51084 | 0 | 6.91 | 6.91