Spreadsheet: 221652d1363632086-matching-data-rows-from-one-sheet-to-another-for-a-data-return-data-example
Sheet: Sheet2

Customer No. | Premise No. | District | SAD Stat. | Rev Code | Rate | CD_CRDV | CRDV_OK | Tax Id Code | Acct No. | Id No. | Tempname | Group Name2 | CIS2 Customer / Account Name | Cash-OnHand | NonCash Amt. | Non-Cash Code | Total Deposit | Deposit Guide Estimate | Name DIP | Name FPL | Name OK | FL_ASAC | Assign Acct Flag | Summary [NAME] | Original Open Dt | LOS Months | LOS Grp. | Dep Type | [NAME] | Collection History | OK_Count | [NAME] | Open or Connect Dt | Assign Acct Rep.
552406584 | 1849498 | 73 | 2 | 2 | 68 |  | OK | N | 8795958449 | 0 | 1 HOUR PHOTO OF POMPANO INC |  | 1 HOUR PHOTO OF POMPANO INC | 0 | 0 |  | 0 | 558 | OK | OK | OK | N |  | N | 1990-06-07 | 273 | 192+ | PP | OK | 0 | 12 | 0LL0000000L0 | 1990-06-07
77101028 | 363388101 | 71 | 2 | 2 | 68 |  | OK | T | 5362894387 | 201268352 | 1 ISLE OF VENICE LLC |  | 1 ISLE OF VENICE LLC | 0 | 0 |  | 0 | 26 | OK | OK | OK |  |  | I | 2007-11-13 | 64 | 192+ | DW | OK | 0 | 12 | 0 | 2007-11-13
77101028 | 68603108 | 71 | 2 | 2 | 68 |  | OK | T | 5756663380 | 201268352 | 1 ISLE OF VENICE LLC |  | 1 ISLE OF VENICE LLC | 0 | 0 |  | 0 | 740 | OK | OK | OK |  |  | I | 2007-10-17 | 64 | 192+ | DW | OK | 0 | 12 | 0 | 2007-10-17
21543005 | 567689 | 44 | 2 | 2 | 68 |  | OK | T | 2855244188 | 320238324 | 1 LOVE BARBER SHOP |  | 1 LOVE BARBER SHOP | 338 | 0 |  | 338 | 256 | OK | OK | OK | N |  | N | 2008-03-07 | 60 | 192+ | WP | 1 | N00NENEECERR | 2 | LLLLLLLLLLLL | 2009-03-26
344956732 | 767438758 | 41 | 2 | 2 | 72 |  | OK | T | 1512358324 | 61682749 | 1 N FEDERAL LTD |  | 1 N FEDERAL LTD | 15166 | 0 |  | 15166 | 13880 | OK | OK | OK |  |  | N | 2003-05-02 | 118 | 192+ | WP | 1 | 00RR0R000000 | 9 | L0LLL0LLLLLL | 2003-05-02
344956732 | 385550621 | 41 | 2 | 2 | 72 | 0 | OK | T | 5880277321 | 61682749 | 1 N FEDERAL LTD |  | 1 N FEDERAL LTD | 1692 | 0 |  | 1692 | 1231 | OK | OK | OK |  |  | N | 2003-05-02 | 118 | 192+ | WP | 1 | 00RR0R000000 | 9 | L0LLL0LLLLLL | 2003-05-02
15325930 | 856409721 | 73 | 2 | 2 | 72 |  | OK | T | 6276740336 | 450531239 | 1 OCEAN BOULEVARD CONDO ASSOC INC |  | 1 OCEAN BOULEVARD CONDO ASSOC INC | 0 | 0 |  | 0 | 3056 | OK | OK | OK |  |  | I | 2005-05-16 | 93 | 192+ | DW | OK | 0 | 12 | 00LLL0L00000 | 2005-05-16
15325930 | 623439130 | 73 | 2 | 2 | 72 |  | OK | T | 6402158130 | 450531239 | 1 OCEAN BOULEVARD CONDO ASSOC INC |  | 1 OCEAN BOULEVARD CONDO ASSOC INC | 0 | 0 |  | 0 | 4942 | OK | OK | OK |  |  | I | 2005-05-03 | 94 | 192+ | DW | OK | 0 | 12 | 00LLL0L00000 | 2005-05-03
959295505 | 203095125 | 44 | 2 | 2 | 68 |  | OK | T | 896476058 | 260452514 | 1 ONE PRICE CLEANERS COM LLC |  | 1 ONE PRICE CLEANERS COM LLC | 943 | 0 |  | 943 | 638 | OK | OK | OK |  |  | N | 2007-08-14 | 66 | 192+ | WP | 1 | PEPNEPNPNPPP | 0 | LLLL0LLLLLLL | 2007-08-14
482154153 | 2223195 | 83 | 2 | 2 | 68 |  | OK | T | 8323336357 | 205681407 | 1 SALE A DAY |  | 1 SALE A DAY | 0 | 0 |  | 0 | 0 | OK | OK | OK | N |  | N | 2013-02-14 | 1 | 192+ | WP | 1 | N----------- | 0 |  | 2013-02-14
482154153 | 2836358 | 83 | 2 | 2 | 72 |  | OK | T | 3318741539 | 205681407 | 1 SALE A DAY |  | 1 SALE A DAY | 22566 | 0 |  | 22566 | 19315 | OK | OK | OK | N |  | N | 2011-09-07 | 18 | 192+ | WP | OK | 0 | 12 | 0L0L00000000 | 2011-09-07
482154153 | 276943842 | 83 | 2 | 2 | 72 |  | OK | T | 1966597559 | 205681407 | 1 SALE A DAY |  | 1 SALE A DAY | 1609 | 0 |  | 1609 | 1899 | OK | OK | OK |  |  | N | 2011-11-16 | 15 | 192+ | WP | 1 | 000A000000NE | 10 | L00L00L00LL0 | 2011-11-16
482154153 | 110356834 | 83 | 2 | 2 | 68 |  | OK | T | 1797231055 | 205681407 | 1 SALE A DAY |  | 1 SALE A DAY | 863 | 0 |  | 863 | 768 | OK | OK | OK |  |  | N | 2011-11-16 | 15 | 192+ | WP | OK | 0 | 12 | L000L00L0000 | 2011-11-16
482154153 | 2223196 | 83 | 2 | 2 | 72 |  | OK | T | 6275106505 | 205681407 | 1 SALE A DAY |  | 1 SALE A DAY | 0 | 0 |  | 0 | 0 | OK | OK | OK | N |  | N | 2012-10-05 | 5 | 192+ | DW | 1 | 0000EN------ | 4 | 0 | 2013-02-14
158030054 | 115522521 | 83 | 2 | 2 | 68 |  | OK | T | 1641800543 | 800539196 | 1 SHOT EXPRESS TRANSPORT LLC |  | 1 SHOT EXPRESS TRANSPORT LLC | 319 | 0 |  | 319 | 270 | OK | OK | OK |  |  | I | 2010-06-01 | 33 | 192+ | WP | OK | 0 | 12 | LLLLL0LLL0LL | 2010-06-01
286964247 | 624126404 | 81 | 2 | 2 | 68 |  | OK | T | 1006467474 | 364644475 | 1 SOTHEDYS INTERNATIONAL REALTY |  | 1 SOTHEDYS INTERNATIONAL REALTY | 370 | 0 |  | 370 | 299 | OK | OK | OK |  |  | I | 2011-01-18 | 25 | 192+ | WP | OK | 0 | 12 | 0 | 2011-01-18
286964247 | 484289501 | 81 | 2 | 2 | 68 |  | OK | T | 3731936476 | 364644475 | 1 SOTHEDYS INTERNATIONAL REALTY |  | 1 SOTHEDYS INTERNATIONAL REALTY | 444 | 0 |  | 444 | 674 | OK | OK | OK |  |  | I | 2011-01-18 | 25 | 192+ | WP | OK | 0 | 12 | 0 | 2011-01-18
286964247 | 342292408 | 81 | 2 | 2 | 68 |  | OK | T | 3814973479 | 364644475 | 1 SOTHEDYS INTERNATIONAL REALTY |  | 1 SOTHEDYS INTERNATIONAL REALTY | 370 | 0 |  | 370 | 696 | OK | OK | OK |  |  | I | 2011-01-18 | 25 | 192+ | WP | OK | 0 | 12 | 0 | 2011-01-18
286964247 | 464611304 | 81 | 2 | 2 | 68 |  | OK | T | 8872052470 | 364644475 | 1 SOTHEDYS INTERNATIONAL REALTY |  | 1 SOTHEDYS INTERNATIONAL REALTY | 370 | 0 |  | 370 | 1436 | OK | OK | OK |  |  | I | 2011-01-18 | 25 | 192+ | WP | OK | 0 | 12 | 0 | 2011-01-18
591470018 | 214120 | 22 | 2 | 2 | 68 |  | OK | T | 2605820188 | 593595236 | 1 SOURCE INSURENCE AGENCY INC |  | 1 SOURCE INSURENCE AGENCY INC | 0 | 0 |  | 0 | 160 | OK | OK | OK | N |  | X | 1999-10-01 | 161 | 192+ | DW | OK | 0 | 12 | 0 | 1999-10-01
819075451 | 2270427 | 83 | 2 | 2 | 68 |  | OK | T | 2939264517 | 460625773 | 1 STOP AUTO SHOP OF SOUTH FLORIDA |  | 1 STOP AUTO SHOP OF SOUTH FLORIDA | 66 | 0 |  | 66 | 101 | OK | OK | OK | N |  | N | 2012-08-02 | 7 | 192+ | WP | 1 | NE0N00W----- | 4 | LLLL00 | 2012-08-02
978578611 | 2175584 | 83 | 2 | 2 | 68 |  | OK | T | 7362096112 | 453465885 | 1 STOP CAR CARE INC |  | 1 STOP CAR CARE INC | 264 | 0 |  | 264 | 303 | OK | OK | OK | N |  | I | 2011-11-22 | 15 | 192+ | WP | 1 | EENEPEENENNN | 0 | LLLLLLLLLLLL | 2011-11-22
978578611 | 519538106 | 83 | 2 | 2 | 68 |  | OK | T | 4093725267 | 453465885 | 1 STOP CAR CARE INC |  | 1 STOP CAR CARE INC | 250 | 0 |  | 250 | 200 | OK | OK | OK |  |  | I | 2012-01-10 | 14 | 192+ | WP | 1 | REERENRREN0N | 1 | LLLLLLLL0LL | 2012-01-10
24733344 | 189403 | 21 | 2 | 2 | 68 |  | OK | T | 5609733448 | 461641833 | 1 STOP FOOD MART #2 INC |  | 1 STOP FOOD MART #2 INC | 2346 | 0 |  | 2346 | 955 | OK | OK | OK | N |  | N | 2012-12-14 | 2 | 192+ | WP | 1 | 0W---------- | 2 | 0 | 2012-12-14
48146319 | 333713 | 21 | 2 | 2 | 68 |  | OK | T | 6929614193 | 264702714 | 1 STOP FOOD MART, INC |  | 1 STOP FOOD MART, INC | 0 | 0 |  | 0 | 1794 | OK | OK | OK |  |  | I | 2009-05-01 | 46 | 192+ | DW | OK | 0 | 12 | 0LLLL00L00L0 | 2009-05-01
48146319 | 333712 | 21 | 2 | 2 | 68 |  | OK | T | 7432763196 | 264702714 | 1 STOP FOOD MART, INC |  | 1 STOP FOOD MART, INC | 0 | 0 |  | 0 | 493 | OK | OK | OK | N |  | I | 2009-05-01 | 46 | 192+ | DW | OK | 0 | 12 | 0LLLL00L00L0 | 2009-05-01