Spreadsheet: 377029d1423771644-complicated-if-statement-bankstatementrealsample
Sheet: BankStatement Test2

Date | Type | Debit | Credit | Balance |  | INDEX('Lookup Table'!B:B,MATCH("*"&MID(B3,LEN(LEFT(B3,22)),LEN(B3)),'Lookup Table'!A:A,0))
2014-12-31 00:00:00 | WITHDRAW |  |  |  | POS 1231 1340 319625 Marianos FRESH WHEATON IL
2014-12-31 00:00:00 | WITHDRAW |  |  |  | POS 1231 1035 319132 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-31 00:00:00 | DEPOSIT |  |  |  | ZOOMBA GROUP LLCPAYROLL DP123114
2014-12-31 00:00:00 | DEPOSIT |  |  |  | N5740 STRATEGIC DIR DEP 141231
2014-12-31 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02352 WH Wheaton IL 12-30-14 887876
2014-12-31 00:00:00 | DB DEBIT |  |  |  | TORRID.COM [PHONE] CA 12-30-14 378991
2014-12-31 00:00:00 | WITHDRAW |  |  |  | POS 1230 2229 318463 Marianos FRESH WHEATON IL
2014-12-31 00:00:00 | DB DEBIT |  |  |  | NORDSTROM #0220 CHICAGO IL 12-29-14 651796
2014-12-30 00:00:00 | WITHDRAW |  |  |  | POS 1230 1727 317930 Marianos FRESH WHEATON IL
2014-12-30 00:00:00 | WITHDRAW |  |  |  | POS 1230 1654 317869 MENARDS- GLENDALE H GLENDALE HEIGIL
2014-12-30 00:00:00 | DEPOSIT |  |  |  | POS 1230 1632 317823 MENARDS- GLENDALE H GLENDALE HEIGIL
2014-12-30 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 12/28/2014 [PHONE]
2014-12-29 00:00:00 | DB DEBIT |  |  |  | COLLEGE STATION CAT WHEATON IL 12-27-14 698619
2014-12-29 00:00:00 | DB DEBIT |  |  |  | NETFLIX.COM NETFLIX.COM CA 12-27-14 630728
2014-12-29 00:00:00 | DB DEBIT |  |  |  | Amazon Video On Dem [PHONE] WA 12-27-14 315560
2014-12-29 00:00:00 | WITHDRAW |  |  |  | POS 1228 1958 314064 AMAZON.COM SEATTLE WA
2014-12-29 00:00:00 | WITHDRAW |  |  |  | POS 1228 1958 314063 AMAZON.COM SEATTLE WA
2014-12-29 00:00:00 | WITHDRAW |  |  |  | POS 1228 1200 313399 AMAZON.COM SEATTLE WA
2014-12-29 00:00:00 | WITHDRAW |  |  |  | POS 1228 1158 313391 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-29 00:00:00 | WITHDRAW |  |  |  | POS 1227 1736 312789 505 W ARMY TRAIL RD BLOOMINGDALE IL
2014-12-29 00:00:00 | WITHDRAW |  |  |  | POS 1227 1649 312713 505 W ARMY TRAIL BLOOMINGDALE IN
2014-12-27 00:00:00 | WITHDRAW |  |  |  | POS 1227 1221 312093 Marianos FRESH WHEATON IL
2014-12-27 00:00:00 | WITHDRAW |  |  |  | POS 1227 1155 312054 600 OAK CREEK DRIVE LOMBARD IL
2014-12-26 00:00:00 | DB DEBIT |  |  |  | SPEEDWAY 05524 G-3 FLINT MI 12-26-14 118996
2014-12-26 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #08874 FL Flint MI 12-26-14 194605
2014-12-26 00:00:00 | WITHDRAW |  |  |  | POS 1226 1616 [PHONE] EAST HILL RD. GRAND BLANC MI
2014-12-26 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02722 GR Grand Blanc MI 12-25-14 037894
2014-12-26 00:00:00 | DB DEBIT |  |  |  | IPASS AUTOREPLENISH [PHONE] IL 12-24-14 089372
2014-12-24 00:00:00 | WITHDRAW |  |  |  | POS 1224 1710 [PHONE] EAST HILL RD. GRAND BLANC MI
2014-12-24 00:00:00 | DEPOSIT |  |  |  | N5740 STRATEGIC DIR DEP 141224
2014-12-24 00:00:00 | DB DEBIT |  |  |  | PEETS # 29504 WHEATON IL 12-23-14 368568
2014-12-24 00:00:00 | DB DEBIT |  |  |  | CHIPOTLE 0498 ELMHURST IL 12-22-14 470207
2014-12-24 00:00:00 | DB DEBIT |  |  |  | NORDSTROM #0220 CHICAGO IL 12-21-14 243756
2014-12-24 00:00:00 | DB DEBIT |  |  |  | MARATHON PETRO04329 WHEATON IL 12-22-14 179155
2014-12-24 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-23-14 083785
2014-12-24 00:00:00 | WITHDRAW |  |  |  | POS 1223 2100 305613 AMAZON.COM SEATTLE WA
2014-12-23 00:00:00 | WITHDRAW |  |  |  | ATM 1223 1349 304652 133 N. YORK ELMHURST IL
2014-12-23 00:00:00 | WITHDRAW |  |  |  | POS 1223 1346 304648 160 N ROBERT T PALM ELMHURST IL
2014-12-23 00:00:00 | WITHDRAW |  |  |  | LADY VINTAGE LIMIAT PAYPAL
2014-12-23 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-22-14 211999
2014-12-22 00:00:00 | WITHDRAW |  |  |  | POS 1222 1849 302993 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-22 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0836 GLENDALE HEIG IL 12/20/2014 [PHONE]
2014-12-22 00:00:00 | DB DEBIT |  |  |  | NORDSTROM #0220 CHICAGO IL 12-18-14 563210
2014-12-22 00:00:00 | WITHDRAW |  |  |  | POS 1221 1856 300249 Marianos FRESH WHEATON IL
2014-12-22 00:00:00 | WITHDRAW |  |  |  | POS 1221 1839 300225 Marianos FRESH WHEATON IL
2014-12-20 00:00:00 | WITHDRAW |  |  |  | POS 1220 1225 298205 Wal-Mart Super Cent BLOOMINGDALE IL
2014-12-20 00:00:00 | DB DEBIT |  |  |  | CHINA STAR WHEATON IL 12-19-14 939631
2014-12-20 00:00:00 | DB DEBIT |  |  |  | Amazon Video On Dem [PHONE] WA 12-19-14 533842
2014-12-20 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-19-14 101141
2014-12-20 00:00:00 | DB DEBIT |  |  |  | Amazon Video On Dem [PHONE] WA 12-19-14 836917
2014-12-20 00:00:00 | WITHDRAW |  |  |  | POS 1219 2054 296872 AMAZON.COM SEATTLE WA
2014-12-20 00:00:00 | DB DEBIT |  |  |  | WOK N FIRE ELMHURST ELMHURST IL 12-18-14 569233
2014-12-19 00:00:00 | WITHDRAW |  |  |  | POS 1219 2010 296746 360 W ARMY TRAIL RD BLOOMINGDALE IL
2014-12-19 00:00:00 | DB DEBIT |  |  |  | POTBELLY 006 CHICAGO IL 12-17-14 542182
2014-12-19 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 12-18-14 353537
2014-12-19 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-18-14 110790
2014-12-18 00:00:00 | DB DEBIT |  |  |  | SIGNATURE SMILES DE OAK PARK IL 12-17-14 255094
2014-12-18 00:00:00 | WITHDRAW |  |  |  | POS 1218 1923 [PHONE] MAIN ST. WHEATON IL
2014-12-18 00:00:00 | WITHDRAW |  |  |  | POS 1218 1913 293967 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-18 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 12-17-14 273953
2014-12-18 00:00:00 | DB DEBIT |  |  |  | MEATHEADS MANAGEME ELMHURST IL 12-17-14 904045
2014-12-18 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02386 LO Lombard IL 12-17-14 338822
2014-12-18 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-17-14 612718
2014-12-18 00:00:00 | DB DEBIT |  |  |  | LEEVALLEYTLS8002678 OGDENSBURG NY 12-16-14 420383
2014-12-17 00:00:00 | WITHDRAW |  |  |  | POS 1217 1933 291833 Marianos FRESH WHEATON IL
2014-12-17 00:00:00 | WITHDRAW |  |  |  | POS 1217 1903 291775 505 W ARMY TRAIL RD BLOOMINGDALE IL
2014-12-17 00:00:00 | WITHDRAW |  |  |  | MERRICK BANK CORONLINEPYMT141216
2014-12-16 00:00:00 | WITHDRAW |  |  |  | POS 1216 1627 289417 Marianos FRESH WHEATON IL
2014-12-16 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN141215
2014-12-16 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN141215
2014-12-16 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-15-14 749761
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1215 1408 287210 AMAZON.COM SEATTLE WA
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1215 1259 287068 AMAZON.COM SEATTLE WA
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 12/14/2014 [PHONE]
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 12/14/2014 [PHONE]
2014-12-15 00:00:00 | DEPOSIT |  |  |  | ZOOMBA GROUP LLCPAYROLL DP121514
2014-12-15 00:00:00 | DEPOSIT |  |  |  | N5740 STRATEGIC DIR DEP 141215
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1215 0324 286057 AMAZON.COM SEATTLE WA
2014-12-15 00:00:00 | DB DEBIT |  |  |  | [NAME] AND CHICAGO IL 12-11-14 616044
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1215 0320 286047 AMAZON.COM SEATTLE WA
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1215 0320 286046 AMAZON.COM SEATTLE WA
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1215 0320 286045 AMAZON.COM SEATTLE WA
2014-12-15 00:00:00 | DB DEBIT |  |  |  | FEDEX [PHONE] MEMPHIS TN 12-12-14 602500
2014-12-15 00:00:00 | DB DEBIT |  |  |  | STIR CRAZY #001 OAKBROOK IL 12-12-14 555446
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1214 0929 284191 Marianos FRESH WHEATON IL
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1213 2202 283981 142 OAKBROOK CENTER OAKBROOK IL
2014-12-15 00:00:00 | WITHDRAW |  |  |  | POS 1213 1628 283488 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-13 00:00:00 | DEPOSIT |  |  |  | POS 1213 1242 283004 AMAZON.COM SEATTLE WA
2014-12-13 00:00:00 | DB DEBIT |  |  |  | Marianos FRESH00085 WHEATON IL 12-12-14 094513
2014-12-13 00:00:00 | DB DEBIT |  |  |  | MARATHON PETRO04329 WHEATON IL 12-11-14 360201
2014-12-13 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-12-14 456538
2014-12-12 00:00:00 | TRANSFER |  |  |  | From: SAVINGS 1
2014-12-12 00:00:00 | WITHDRAW |  |  |  | POS 1212 1633 281286 AMAZON.COM SEATTLE WA
2014-12-12 00:00:00 | WITHDRAW |  |  |  | POS 1212 1627 281273 AMAZON.COM SEATTLE WA
2014-12-12 00:00:00 | DB DEBIT |  |  |  | [NAME] PA 12-11-14 831148
2014-12-12 00:00:00 | WITHDRAW |  |  |  | ALLSTATE INS CO INS PREM DEC 14
2014-12-12 00:00:00 | DB DEBIT |  |  |  | NORDSTROM #0220 CHICAGO IL 12-09-14 478410
2014-12-12 00:00:00 | WITHDRAW |  |  |  | POS 1211 2356 279579 AMAZON.COM SEATTLE WA
2014-12-12 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 12-11-14 546982
2014-12-11 00:00:00 | WITHDRAW |  |  |  | POS 1211 1914 279163 Marianos FRESH WHEATON IL
2014-12-11 00:00:00 | WITHDRAW |  |  |  | POS 1211 1149 278442 AMAZON.COM SEATTLE WA
2014-12-11 00:00:00 | WITHDRAW |  |  |  | POS 1211 0920 278172 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-11 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #768 ELMHURST IL 12-10-14 895045
2014-12-11 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 12-09-14 572392
2014-12-11 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-10-14 105759
2014-12-10 00:00:00 | DB DEBIT |  |  |  | NORDSTROM #0220 CHICAGO IL 12-09-14 478364
2014-12-10 00:00:00 | WITHDRAW |  |  |  | CITY OF WHEATON UTILITIES 111514
2014-12-10 00:00:00 | DB DEBIT |  |  |  | ETSY.COM BROOKLYN NY 12-09-14 619549
2014-12-10 00:00:00 | DB DEBIT |  |  |  | ETSY.COM BROOKLYN NY 12-09-14 900765
2014-12-10 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-09-14 308428
2014-12-10 00:00:00 | DB DEBIT |  |  |  | SEARS PHARMACY OAK PARK IL 12-08-14 014128
2014-12-09 00:00:00 | WITHDRAW |  |  |  | POS 1209 1829 275503 Marianos FRESH WHEATON IL
2014-12-09 00:00:00 | WITHDRAW |  |  |  | POS 1209 1234 274950 ANTHROPOLOGIE 408 CHICAGO IL
2014-12-09 00:00:00 | TRANSFER |  |  |  | From: SAVINGS 1
2014-12-09 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #768 ELMHURST IL 12-08-14 040219
2014-12-09 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 12/07/2014 [PHONE]
2014-12-09 00:00:00 | DB DEBIT |  |  |  | POTBELLY 006 CHICAGO IL 12-07-14 618251
2014-12-09 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-08-14 060003
2014-12-08 00:00:00 | WITHDRAW |  |  |  | POS 1208 0449 272321 AMAZON.COM SEATTLE WA
2014-12-08 00:00:00 | DB DEBIT |  |  |  | PEETS # 29504 WHEATON IL 12-05-14 834851
2014-12-08 00:00:00 | DB DEBIT |  |  |  | EGG LECTIC CAFE INC WHEATON IL 12-05-14 837673
2014-12-08 00:00:00 | DB DEBIT |  |  |  | 013FBV STUDIO MOVIE WHEATON IL 12-05-14 643869
2014-12-08 00:00:00 | DB DEBIT |  |  |  | 013BOX STUDIO MOVIE WHEATON IL 12-06-14 078052
2014-12-08 00:00:00 | DB DEBIT |  |  |  | COZYMEL S WHEATON # WHEATON IL 12-06-14 750809
2014-12-08 00:00:00 | WITHDRAW |  |  |  | POS 1207 0952 270362 Marianos FRESH WHEATON IL
2014-12-08 00:00:00 | WITHDRAW |  |  |  | POS 1206 2024 [PHONE] BUTTERFIELD RD DOWNERS GROVEIL
2014-12-06 00:00:00 | WITHDRAW |  |  |  | POS 1206 1249 269203 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-06 00:00:00 | DB DEBIT |  |  |  | TIV*TIVO SERVICE [PHONE] CA 12-06-14 497999
2014-12-06 00:00:00 | DB DEBIT |  |  |  | [NAME] AND CHICAGO IL 12-03-14 225092
2014-12-06 00:00:00 | DB DEBIT |  |  |  | POTBELLY 006 CHICAGO IL 12-05-14 094681
2014-12-06 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-05-14 295750
2014-12-05 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-04-14 550702
2014-12-05 00:00:00 | DB CRDT |  |  |  | THE HOME DEPOT 1943 CAROL STREAM IL 12-03-14 556062
2014-12-05 00:00:00 | DB DEBIT |  |  |  | THE HOME DEPOT 1943 CAROL STREAM IL 12-03-14 232375
2014-12-04 00:00:00 | WITHDRAW |  |  |  | POS 1204 1859 265312 Marianos FRESH WHEATON IL
2014-12-04 00:00:00 | TRANSFER |  |  |  | From: SAVINGS 1
2014-12-04 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #768 ELMHURST IL 12-03-14 360800
2014-12-04 00:00:00 | DB DEBIT |  |  |  | BRICKS WOOD FIRED WHEATON IL 12-03-14 147324
2014-12-04 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-03-14 515553
2014-12-04 00:00:00 | DB DEBIT |  |  |  | FOOD BANK OF EASTER FLINT MI 12-03-14 284528
2014-12-04 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 12-03-14 990552
2014-12-03 00:00:00 | WITHDRAW |  |  |  | POS 1203 1931 263494 475 S SCHMALE ROAD CAROL STREAM IL
2014-12-03 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN141202
2014-12-03 00:00:00 | WITHDRAW |  |  |  | STONEGATE MTG ACHPMT
2014-12-03 00:00:00 | WITHDRAW |  |  |  | MERRICK BANK CORONLINEPYMT141202
2014-12-03 00:00:00 | WITHDRAW |  |  |  | NICOR GAS/NCO EPAYMENT 141202
2014-12-03 00:00:00 | DB DEBIT |  |  |  | COAST BURGER CHICAGO IL 11-30-14 717002
2014-12-03 00:00:00 | DB DEBIT |  |  |  | CHICAGO CHRISTMAS M WHITE BEAR LKMN 12-01-14 040765
2014-12-03 00:00:00 | DB DEBIT |  |  |  | WHEATON SANITARY DI [PHONE] IL 11-30-14 945873
2014-12-03 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-02-14 549484
2014-12-02 00:00:00 | DB DEBIT |  |  |  | COLLEGE STATION CAT WHEATON IL 12-01-14 143060
2014-12-02 00:00:00 | WITHDRAW |  |  |  | POS 1202 1920 261705 111 NORTH STATE CHICAGO IL
2014-12-02 00:00:00 | WITHDRAW |  |  |  | POS 1202 1813 261597 716 EDWARD ST SYCAMORE IL
2014-12-02 00:00:00 | WITHDRAW |  |  |  | ATM 1202 1743 261556 SPECIAL EVENTS ATM CINCINNATI OH
2014-12-02 00:00:00 | DB DEBIT |  |  |  | COMCAST CHICAGO CS [PHONE] IL 12-02-14 028348
2014-12-02 00:00:00 | DB DEBIT |  |  |  | TIV*TIVO SERVICE [PHONE] CA 12-02-14 563988
2014-12-02 00:00:00 | DB DEBIT |  |  |  | METRA OGIVIE QPS CHICAGO IL 12-01-14 868492
2014-12-02 00:00:00 | WITHDRAW |  |  |  | ATT Payment 120114
2014-12-02 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 12-01-14 289902
2014-12-01 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #10371 VI Villa Park IL 12-01-14 614621
2014-12-01 00:00:00 | WITHDRAW |  |  |  | ATM 1201 1403 259211 133 N. YORK ELMHURST IL
2014-12-01 00:00:00 | DB DEBIT |  |  |  | ICING #3755 LOMBARD IL 11-30-14 073505
2014-12-01 00:00:00 | DB DEBIT |  |  |  | AMC YORKTOWN 17 #08 LOMBARD IL 11-30-14 197810
2014-12-01 00:00:00 | DB DEBIT |  |  |  | AMC YORKTOWN 17 #08 LOMBARD IL 11-30-14 071464
2014-12-01 00:00:00 | DB DEBIT |  |  |  | TORRID #5118 LOMBARD IL 11-30-14 653860
2014-12-01 00:00:00 | WITHDRAW |  |  |  | PAYPAL INST XFER 141128
2014-12-01 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 11/29/2014 [PHONE]
2014-12-01 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09911 GL [NAME] 11-29-14 957998
2014-12-01 00:00:00 | DB DEBIT |  |  |  | MARATHON PETRO04329 WHEATON IL 11-28-14 576576
2014-12-01 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09911 GL [NAME] 11-28-14 655773
2014-12-01 00:00:00 | DB DEBIT |  |  |  | BINNYS BEVERAGE DEP GLEN ELLYN IL 11-28-14 973297
2014-12-01 00:00:00 | DB DEBIT |  |  |  | COZYMEL S WHEATON # WHEATON IL 11-28-14 591900
2014-12-01 00:00:00 | WITHDRAW |  |  |  | POS 1130 1912 257136 Marianos FRESH WHEATON IL
2015-01-31 00:00:00 | WITHDRAW |  |  |  | POS 0131 1739 377549 WHOLEFDS 151 [NAME]
2015-01-31 00:00:00 | WITHDRAW |  |  |  | ATM 0131 1412 377060 FIRST STATE BANK Geneva IL
2015-01-31 00:00:00 | DB DEBIT |  |  |  | COZYMEL S WHEATON # WHEATON IL 01-30-15 367058
2015-01-31 00:00:00 | DB DEBIT |  |  |  | COMCAST CHICAGO CS [PHONE] IL 01-31-15 666712
2015-01-31 00:00:00 | DB DEBIT |  |  |  | METRA OGIVIE QPS CHICAGO IL 01-30-15 046639
2015-01-31 00:00:00 | DB DEBIT |  |  |  | THE SNUGGERY ELMHUR ELMHURST IL 01-30-15 305786
2015-01-30 00:00:00 | TRANSFER |  |  |  | From: SAVINGS 1
2015-01-30 00:00:00 | DB DEBIT |  |  |  | BRICKS WOOD FIRED WHEATON IL 01-29-15 490545
2015-01-30 00:00:00 | WITHDRAW |  |  |  | PAYPAL INST XFER 150129
2015-01-30 00:00:00 | DEPOSIT |  |  |  | ZOOMBA GROUP LLCPAYROLL DP013015
2015-01-30 00:00:00 | DEPOSIT |  |  |  | N5740 STRATEGIC DIR DEP 150130
2015-01-30 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 01-29-15 497072
2015-01-30 00:00:00 | DB DEBIT |  |  |  | SUSHI NEST RESTAURA ELMHURST IL 01-28-15 898924
2015-01-30 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02386 LO Lombard IL 01-29-15 044650
2015-01-29 00:00:00 | WITHDRAW |  |  |  | POS 0129 1239 371780 AMAZON.COM SEATTLE WA
2015-01-29 00:00:00 | WITHDRAW |  |  |  | POS 0129 1233 371768 AMAZON.COM SEATTLE WA
2015-01-28 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02386 LO Lombard IL 01-28-15 766684
2015-01-28 00:00:00 | WITHDRAW |  |  |  | POS 0128 1559 370264 160 N ROBERT T PALM ELMHURST IL
2015-01-28 00:00:00 | DB DEBIT |  |  |  | NETFLIX.COM LOS GATOS CA 01-27-15 697351
2015-01-27 00:00:00 | WITHDRAW |  |  |  | POS 0127 1850 368976 Marianos FRESH WHEATON IL
2015-01-27 00:00:00 | WITHDRAW |  |  |  | POS 0127 1733 368883 01054--101 North Cl Chicago IL
2015-01-27 00:00:00 | WITHDRAW |  |  |  | GOG LTD. IAT PAYPAL
2015-01-27 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #768 ELMHURST IL 01-26-15 733081
2015-01-26 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-26-15 374849
2015-01-26 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02386 LO Lombard IL 01-26-15 943117
2015-01-26 00:00:00 | WITHDRAW |  |  |  | POS 0126 1808 366835 TRADER JOE S # GLEN ELLYN IL
2015-01-26 00:00:00 | TRANSFER |  |  |  | From: SAVINGS 1
2015-01-26 00:00:00 | DB DEBIT |  |  |  | PEETS # 29504 WHEATON IL 01-23-15 699207
2015-01-26 00:00:00 | WITHDRAW |  |  |  | POS 0124 1908 363468 27W171 GENEVA RD WINFIELD IL
2015-01-26 00:00:00 | WITHDRAW |  |  |  | POS 0124 1842 363419 505 W ARMY TRAIL RD BLOOMINGDALE IL
2015-01-24 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #3734 BATTLE CREEK MI 01-23-15 973968
2015-01-24 00:00:00 | WITHDRAW |  |  |  | POS 0123 2205 361822 SHELL Service S GLEN ELLYN IL
2015-01-24 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09650 FL Flint MI 01-23-15 390027
2015-01-24 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09650 FL Flint MI 01-23-15 933894
2015-01-23 00:00:00 | DB DEBIT |  |  |  | BANGKOK PEPPERS GRAND BLANC MI 01-22-15 254538
2015-01-23 00:00:00 | WITHDRAW |  |  |  | POS 0123 1922 361454 SHELL Service S BATTLE CREEK MI
2015-01-23 00:00:00 | SH DRAFT (# 600) [NAME]
2015-01-23 00:00:00 | DB DEBIT |  |  |  | THE FRENCH LAUNDRY FENTON MI 01-20-15 733040
2015-01-22 00:00:00 | WITHDRAW |  |  |  | POS 0122 1925 [PHONE] EAST HILL RD. GRAND BLANC MI
2015-01-22 00:00:00 | DB DEBIT |  |  |  | SPEEDWAY 02227 FEN FLINT MI 01-21-15 494610
2015-01-21 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09911 GL [NAME] 01-21-15 251613
2015-01-21 00:00:00 | WITHDRAW |  |  |  | POS 0121 1718 [PHONE] E HILL RD GRAND BLANC MI
2015-01-21 00:00:00 | DB DEBIT |  |  |  | COZYMEL S WHEATON # WHEATON IL 01-20-15 814496
2015-01-21 00:00:00 | DB DEBIT |  |  |  | CHICAGO HEALTH MEDI RIVER FOREST IL 01-19-15 721091
2015-01-21 00:00:00 | DB DEBIT |  |  |  | AMELIA'S GOOD FOOD FOREST PARK IL 01-18-15 901548
2015-01-20 00:00:00 | DB DEBIT |  |  |  | SIGNATURE SMILES DE OAK PARK IL 01-19-15 958767
2015-01-20 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 01/18/2015 [PHONE]
2015-01-20 00:00:00 | WITHDRAW |  |  |  | PAYPAL INST XFER 150118
2015-01-20 00:00:00 | WITHDRAW |  |  |  | PAYPAL INST XFER 150118
2015-01-20 00:00:00 | WITHDRAW |  |  |  | MERRICK BANK CORONLINEPYMT150116
2015-01-20 00:00:00 | WITHDRAW |  |  |  | NICOR GAS/NCO EPAYMENT 150116
2015-01-20 00:00:00 | DB DEBIT |  |  |  | MARATHON PETRO04329 WHEATON IL 01-18-15 572991
2015-01-20 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-19-15 400842
2015-01-20 00:00:00 | WITHDRAW |  |  |  | POS 0119 1735 353676 RIVER FOREST TOWN C River Forest IL
2015-01-20 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #10904 BR Broadview IL 01-16-15 900417
2015-01-20 00:00:00 | DB DEBIT |  |  |  | SEARS PHARMACY OAK PARK IL 01-16-15 823059
2015-01-20 00:00:00 | WITHDRAW |  |  |  | POS 0118 1537 351144 Marianos FRESH WHEATON IL
2015-01-20 00:00:00 | TRANSFER |  |  |  | To: SAVINGS 1
2015-01-17 00:00:00 | WITHDRAW |  |  |  | POS 0117 1516 349879 TRADER JOE S # GLEN ELLYN IL
2015-01-17 00:00:00 | DB DEBIT |  |  |  | CHIPOTLE 1466 WHEATON IL 01-16-15 663300
2015-01-17 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-16-15 687003
2015-01-16 00:00:00 | WITHDRAW |  |  |  | POS 0116 2103 348274 475 S SCHMALE ROAD CAROL STREAM IL
2015-01-16 00:00:00 | DB DEBIT |  |  |  | WOK N FIRE ELMHURST ELMHURST IL 01-15-15 366855
2015-01-16 00:00:00 | DB DEBIT |  |  |  | Amazon Services-Kin [PHONE] WA 01-16-15 213333
2015-01-16 00:00:00 | DB DEBIT |  |  |  | BRICKS WOOD FIRED WHEATON IL 01-15-15 917299
2015-01-16 00:00:00 | DB DEBIT |  |  |  | POTBELLY 006 CHICAGO IL 01-15-15 252701
2015-01-16 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 01-14-15 673039
2015-01-16 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-14-15 238825
2015-01-16 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN150115
2015-01-16 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN150115
2015-01-16 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #10371 VI Villa Park IL 01-14-15 159901
2015-01-16 00:00:00 | DB DEBIT |  |  |  | JIMMY JOHNS - 290 CHICAGO IL 01-13-15 191324
2015-01-15 00:00:00 | WITHDRAW |  |  |  | POS 0115 2104 346151 AMAZON.COM SEATTLE WA
2015-01-15 00:00:00 | WITHDRAW |  |  |  | POS 0115 2102 346149 AMAZON.COM SEATTLE WA
2015-01-15 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #768 ELMHURST IL 01-14-15 028172
2015-01-15 00:00:00 | DEPOSIT |  |  |  | ZOOMBA GROUP LLCPAYROLL DP011515
2015-01-15 00:00:00 | DEPOSIT |  |  |  | N5740 STRATEGIC DIR DEP 150115
2015-01-15 00:00:00 | DB DEBIT |  |  |  | FRANK GIRONDA SALON WHEATON IL 01-12-15 575274
2015-01-14 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-14-15 169903
2015-01-14 00:00:00 | WITHDRAW |  |  |  | POS 0114 1428 343764 WALGREENS 160 N ROB ELMHURST IL
2015-01-14 00:00:00 | DB DEBIT |  |  |  | JPW INDUSTRIES INC [PHONE] TN 01-13-15 407314
2015-01-13 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-13-15 317787
2015-01-13 00:00:00 | WITHDRAW |  |  |  | POS 0113 1832 342527 Marianos FRESH WHEATON IL
2015-01-13 00:00:00 | WITHDRAW |  |  |  | ALLSTATE INS CO INS PREM JAN 15
2015-01-13 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-12-15 648192
2015-01-12 00:00:00 | WITHDRAW |  |  |  | POS 0112 1855 341048 Marianos FRESH WHEATON IL
2015-01-12 00:00:00 | WITHDRAW |  |  |  | ANNA BURNS IAT PAYPAL
2015-01-12 00:00:00 | DEPOSIT |  |  |  | C_SCHWAB DEPOSITTRIALCREDT150112
2015-01-12 00:00:00 | DEPOSIT |  |  |  | C_SCHWAB DEPOSITTRIALCREDT150112
2015-01-12 00:00:00 | DB DEBIT |  |  |  | PEETS # 29504 WHEATON IL 01-10-15 133386
2015-01-12 00:00:00 | DB DEBIT |  |  |  | PIONEER GARDEN AND VILLA PARK IL 01-10-15 033048
2015-01-12 00:00:00 | DB DEBIT |  |  |  | OWL HARDWOOD LUMBE LOMBARD IL 01-10-15 861110
2015-01-12 00:00:00 | DB DEBIT |  |  |  | WHEATON CHRISTIAN C CAROL STREAM IL 01-09-15 172331
2015-01-12 00:00:00 | DB DEBIT |  |  |  | Amazon Video On Dem [PHONE] WA 01-10-15 008582
2015-01-12 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09911 GL [NAME] 01-09-15 016241
2015-01-12 00:00:00 | DB DEBIT |  |  |  | COZYMEL S WHEATON # WHEATON IL 01-09-15 127824
2015-01-12 00:00:00 | DB DEBIT |  |  |  | CORNER BAKERY CHICAGO IL 01-09-15 024646
2015-01-12 00:00:00 | WITHDRAW |  |  |  | POS 0111 1250 338184 475 S SCHMALE ROAD CAROL STREAM IL
2015-01-12 00:00:00 | WITHDRAW |  |  |  | POS 0111 1000 338024 Marianos FRESH WHEATON IL
2015-01-12 00:00:00 | WITHDRAW |  |  |  | POS 0110 1943 337701 475 S SCHMALE ROAD CAROL STREAM IL
2015-01-12 00:00:00 | DEPOSIT |  |  |  | POS 0110 1918 337664 475 S SCHMALE ROAD CAROL STREAM IL
2015-01-10 00:00:00 | WITHDRAW |  |  |  | POS 0110 1349 [PHONE] [NAME] DOWNERS GROVEIL
2015-01-10 00:00:00 | WITHDRAW |  |  |  | ATM 0110 1154 336851 US BANK LOMBARD LOMBARD IL
2015-01-10 00:00:00 | DB DEBIT |  |  |  | SEARS ROEBUCK 793 [PHONE] TX 01-08-15 508214
2015-01-09 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-09-15 667218
2015-01-09 00:00:00 | WITHDRAW |  |  |  | POS 0109 1909 335689 Marianos FRESH WHEATON IL
2015-01-09 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 01/07/2015 [PHONE]
2015-01-09 00:00:00 | WITHDRAW |  |  |  | CITY OF WHEATON UTILITIES 121514
2015-01-07 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02352 WH Wheaton IL 01-07-15 504504
2015-01-07 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-07-15 145061
2015-01-07 00:00:00 | WITHDRAW |  |  |  | POS 0107 1853 332377 625 W ROOSEVELT WHEATON IL
2015-01-07 00:00:00 | DB DEBIT |  |  |  | COZYMEL S WHEATON # WHEATON IL 01-05-15 117233
2015-01-07 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-06-15 267180
2015-01-07 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02386 LO Lombard IL 01-06-15 203240
2015-01-06 00:00:00 | WITHDRAW |  |  |  | POS 0106 1742 330812 01054--101 North Cl Chicago IL
2015-01-06 00:00:00 | DB DEBIT |  |  |  | PANERA BREAD #768 ELMHURST IL 01-05-15 302531
2015-01-06 00:00:00 | DB DEBIT |  |  |  | METRA OGIVIE QPS CHICAGO IL 01-05-15 306512
2015-01-06 00:00:00 | DB DEBIT |  |  |  | LAKE STREET KITCHEN OAK PARK IL 01-04-15 986557
2015-01-06 00:00:00 | WITHDRAW |  |  |  | COMMONWEALTH ED ONLINE PMT150106
2015-01-06 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 01-05-15 657630
2015-01-05 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #10371 VI Villa Park IL 01-05-15 332158
2015-01-05 00:00:00 | DB DEBIT |  |  |  | TIV*TIVO SERVICE [PHONE] CA 01-05-15 811486
2015-01-05 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN150102
2015-01-05 00:00:00 | WITHDRAW |  |  |  | STONEGATE MTG ACHPMT
2015-01-05 00:00:00 | DB DEBIT |  |  |  | MILITARY AND POLICE FOREST PARK IL 01-02-15 739020
2015-01-05 00:00:00 | DB DEBIT |  |  |  | ALL CHOCOLATE KITCH GENEVA IL 01-01-15 429835
2015-01-05 00:00:00 | DB DEBIT |  |  |  | BUZZ CAFE OAK PARK IL 01-02-15 505295
2015-01-05 00:00:00 | DB DEBIT |  |  |  | SEARS PHARMACY OAK PARK IL 01-02-15 347694
2015-01-05 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #10959 RI River Forest IL 01-03-15 838022
2015-01-05 00:00:00 | DB DEBIT |  |  |  | FAMILY MEDICAL CARE OAK PARK IL 01-03-15 265444
2015-01-05 00:00:00 | DB DEBIT |  |  |  | MATSURI JAPANESE RE GENEVA IL 01-02-15 572920
2015-01-03 00:00:00 | WITHDRAW |  |  |  | POS 0103 1523 325316 520 S. SCHMALE ROAD CAROL STREAM IL
2015-01-03 00:00:00 | DB DEBIT |  |  |  | Amazon Services-Kin [PHONE] WA 01-03-15 268520
2015-01-03 00:00:00 | WITHDRAW |  |  |  | POS 0103 1037 [PHONE] Lake St River Forest IL
2015-01-03 00:00:00 | WITHDRAW |  |  |  | POS 0103 1006 324756 483 NORTH HARLEM OAK PARK IL
2015-01-03 00:00:00 | WITHDRAW |  |  |  | POS 0102 2331 324140 501 S COUNTY FARM R WHEATON IL
2015-01-03 00:00:00 | DB DEBIT |  |  |  | SUR LA TABLE # 107 OAK BROOK IL 01-01-15 670253
2015-01-03 00:00:00 | DB DEBIT |  |  |  | BARE ESCENTUALS #04 CHICAGO IL 01-01-15 824498
2015-01-02 00:00:00 | DB DEBIT |  |  |  | TIV*TIVO SERVICE [PHONE] CA 01-02-15 564683
2015-01-02 00:00:00 | DB DEBIT |  |  |  | CHINA STAR WHEATON IL 12-31-14 481645
2015-01-02 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 12/31/2015 [PHONE]
2015-01-02 00:00:00 | WITHDRAW |  |  |  | ATT Payment 123114
2015-01-02 00:00:00 | DB DEBIT |  |  |  | WHEATON SANITARY DI [PHONE] IL 12-30-14 348838
2015-01-02 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09354 OA Oak Brook IL 01-01-15 175383
2015-01-02 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #09911 GL [NAME] 01-01-15 973838
2015-01-01 00:00:00 | DB DEBIT |  |  |  | COMCAST CHICAGO CS [PHONE] IL 01-01-15 113974
2015-01-01 00:00:00 | DB DEBIT |  |  |  | PEETS # 29504 WHEATON IL 12-30-14 709183
2015-02-05 00:00:00 | DB DEBIT |  |  |  | TIV*TIVO SERVICE [PHONE] CA 02-05-15 819446
2015-02-05 00:00:00 | DB DEBIT |  |  |  | COAST BURGER CHICAGO IL 02-02-15 642721
2015-02-05 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #00259 EL Elmhurst IL 02-04-15 808242
2015-02-05 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02386 LO Lombard IL 02-04-15 432012
2015-02-04 00:00:00 | WITHDRAW |  |  |  | PAYPAL INST XFER 150203
2015-02-03 00:00:00 | DB DEBIT |  |  |  | STARBUCKS #02213 CH Chicago IL 02-03-15 829567
2015-02-03 00:00:00 | SH DRAFT (# 542) [NAME]
2015-02-03 00:00:00 | DB DEBIT |  |  |  | CVS/PHARMACY #07134 WHEATON IL 02-02-15 634275
2015-02-03 00:00:00 | WITHDRAW |  |  |  | GREAT LAKES STUDENT LN150202
2015-02-03 00:00:00 | WITHDRAW |  |  |  | STONEGATE MTG ACHPMT
2015-02-02 00:00:00 | DB DEBIT |  |  |  | TIV*TIVO SERVICE [PHONE] CA 02-02-15 763419
2015-02-02 00:00:00 | DB DEBIT |  |  |  | STOCKHOLMS GENEVA IL 01-31-15 458609
2015-02-02 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 01/31/2015 [PHONE]
2015-02-02 00:00:00 | WITHDRAW |  |  |  | POS TARGET -0838 WHEATON IL 01/31/2015 [PHONE]
2015-02-02 00:00:00 | WITHDRAW |  |  |  | ATT Payment 013015
2015-02-02 00:00:00 | DB DEBIT |  |  |  | PEETS # 29504 WHEATON IL 01-31-15 823798