Spreadsheet: 481786d1474643593-how-to-write-a-macros-to-compare-to-columns-and-match-amounts-but-this-is-a-bit-more-tricky-ap-ar-balancing-test
Sheet: Sheet1

AP SIDE REBATES APPLIED |  |  |  |  |  |  |  |  |  | AR SIDE REBATES APPLIED
GL_BUS_UNIT_I | INVOICE_I | FISCAL_MM_D | DISTR__A | CREATE_YEAR_D | AP_ENTRY_C | GL_ACCT_NBR_I | SPCL_INVOICE_C | GL_LOC5_I |  | CUST_I | CUST1_N | FISCAL_MM_D | [NAME] | CALENDAR_APP_D | CHECK_NBR | BATCH_NBR | TOT_APPLD_A | TOT_GL_A | GL_ACCT1_A | GL_BUS_UNIT1 | GL_LOC1 | GL_DEPT1 | GL_ACCT1_NBR_I | GL_ACCT1_REF | GL_ACCT2_A | GL_BUS_UNIT2 | GL_LOC2 | GL_DEPT2 | [NAME] | GL_ACCT2_REF | GL_ACCT3_A | GL_BUS_UNIT3 | GL_LOC3 | GL_DEPT3 | GL_ACCT3_REF | [NAME] | USERID_I
00001 | 73050657 | 9 | -551.16 | 2016 | 4 | 123990000 | 118 | 00100 |  | 302759 | PINNACLE COMMUNICATION SVCS | 9 | 2016 | 2016-08-29 00:00:00 | 76867 | 20 | -8417.8 | -8417.8 | -7495.08 | 00001 | 00100 | 0000 | 123990000 | [NAME] | -922.72 | 00001 | 00100 | 0000 | 123990000 | [NAME] | 0 |  |  |  |  |  | XX00770
00001 | [PHONE] | 9 | -826 | 2016 | 4 | 123990000 | 118 | 00100 |  | 003188 | SMARTWIRE CORP | 9 | 2016 | 2016-08-29 00:00:00 | CORR 1 | 81 | -2000 | -2000 | -2000 | 00001 | 00100 | 0000 | 123990000 | SIP4001319 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -4268.72 | 2016 | 4 | 123990000 | 118 | 00100 |  | 161668 | AFL NETWORK SERVICES INC | 9 | 2016 | 2016-08-29 00:00:00 | CORR 1 | 81 | -18869.23 | -18869.23 | -909.23 | 00001 | 00100 | 0000 | 123990000 | [NAME] | -803 | 00001 | 00100 | 0000 | 123990000 | 2016-08-45280 | -17157 | 00001 | 00100 | 0000 | 2016-07-45197 | 123990000 | E230297
00001 | [PHONE] | 9 | -1238.98 | 2016 | 4 | 123990000 | 118 | 00100 |  | 168493 | KEARNEY ELECTRIC INC | 9 | 2016 | 2016-08-29 00:00:00 | CORR 1 | 81 | -1883 | -1883 | -1883 | 00001 | 00100 | 0000 | 123990000 | 2016-05-44914 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -2308 | 2016 | 4 | 123990000 | 118 | 00100 |  | 285578 | CLAWSON COMMUNICATIONS | 9 | 2016 | 2016-08-29 00:00:00 | CORR 1 | 81 | -1959.98 | -1959.98 | -1959.98 | 00001 | 00100 | 0000 | 123990000 | PAN-20171-20861 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -3477 | 2016 | 4 | 123990000 | 118 | 00100 |  | 722315 | TEKNON CORP - WASHINGTON ORDER | 9 | 2016 | 2016-08-29 00:00:00 | CORR 1 | 81 | -6128 | -6128 | -3063 | 00001 | 00100 | 0000 | 123990000 | 2016-05-44962 | -3065 | 00001 | 00100 | 0000 | 123990000 | 2016-01-43905 | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -579 | 2016 | 4 | 123990000 | 118 | 00100 |  | 192952 | XZACT TECHNOLOGIES | 9 | 2016 | 2016-08-29 00:00:00 | CORR 3 | 114 | -551.16 | -551.16 | -551.16 | 00001 | 00100 | 0000 | 123990000 | CORNING 735050657 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E101847
00001 | [PHONE] | 9 | -1351 | 2016 | 4 | 123990000 | 118 | 00100 |  | 319327 | ZELLER DIGITAL INNOVATIONS,INC | 9 | 2016 | 2016-08-30 00:00:00 | 30440 | 159 | -2636.09 | -2636.09 | -2636.09 | 00001 | 00100 | 0000 | 123990000 | [NAME] | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00770
00001 | [PHONE] | 9 | -1883 | 2016 | 4 | 123990000 | 118 | 00100 |  | 593631 | LABOURDETTE, A J INC | 9 | 2016 | 2016-08-30 00:00:00 | 43612 | 152 | -3134 | -3134 | -826 | 00001 | 00100 | 0000 | 123990000 | [PHONE] | -2308 | 00001 | 00100 | 0000 | 123990000 | [PHONE] | 0 |  |  |  |  |  | XX00847
00001 | [PHONE] | 9 | -1367 | 2016 | 4 | 123990000 | 118 | 00100 |  | 040590 | BRADLEY W ELECTRIC/KAISER | 9 | 2016 | 2016-08-30 00:00:00 | 666204 | 11 | -11535.89 | -11535.89 | -10148.45 | 00001 | 00100 | 0000 | 123990000 |  | -1387.44 | 00001 | 00100 | 0000 | 123990000 | [NAME] | 0 |  |  |  |  |  | XX00847
00001 | [PHONE] | 9 | -3063 | 2016 | 4 | 123990000 | 118 | 00100 |  | 123040 | COMMUNICATION INNOVATORS | 9 | 2016 | 2016-08-31 00:00:00 | CORR 10 | 625 | -10712.17 | -10712.17 | -10712.17 | 00001 | 00100 | 0000 | 123990000 | PAN-20195-20946 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -1669 | 2016 | 4 | 123990000 | 118 | 00100 |  | 192952 | XZACT TECHNOLOGIES | 9 | 2016 | 2016-08-31 00:00:00 | CORR 10 | 625 | -2000 | -2000 | -2000 | 00001 | 00100 | 0000 | 123990000 | SIP4000862 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -1408 | 2016 | 4 | 123990000 | 118 | 00100 |  | 709400 | R G S COMMUNICATION | 9 | 2016 | 2016-08-31 00:00:00 | CORR 10 | 625 | -500 | -500 | -500 | 00001 | 00100 | 0000 | 123990000 | JB0216-02 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -17157 | 2016 | 4 | 123990000 | 118 | 00100 |  | 010611 | HENKELS & MCCOY NETWORKS | 9 | 2016 | 2016-09-01 00:00:00 | 409716 | 411 | -3477 | -3477 | -3477 | 00001 | 00100 | 0000 | 123990000 | 2016-04-44838 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00845
00001 | [PHONE] | 9 | -144 | 2016 | 4 | 123990000 | 118 | 00100 |  | 663322 | METROPOLITAN ELECTRICAL CONSTR | 9 | 2016 | 2016-09-01 00:00:00 | CORR 1 | 81 | -49505.38 | -49505.38 | -5625.39 | 00001 | 00100 | 0000 | 123990000 | PAN2094624252 | -39825.71 | 00001 | 00100 | 0000 | 123990000 | SIP1012895 | -4054.28 | 00001 | 00100 | 0000 | [NAME] | 123990000 | E230297
00001 | [PHONE] | 9 | -826 | 2016 | 4 | 123990000 | 118 | 00100 |  | 663322 | METROPOLITAN ELECTRICAL CONSTR | 9 | 2016 | 2016-09-01 00:00:00 | CORR 1 | 81 | -606.01 | -606.01 | -606.01 | 00001 | 00100 | 0000 | 123990000 | FLP15-00127 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | [PHONE] | 9 | -803 | 2016 | 4 | 123990000 | 118 | 00100 |  | 108998 | AMERICOM TECHNOLOGY, INC/ | 9 | 2016 | 2016-09-02 00:00:00 | 4546 | 1151 | -144 | -144 | -144 | 00001 | 00100 | 0000 | 123990000 | 2016-07-45235 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00846
00001 | [PHONE] | 9 | -52242 | 2016 | 4 | 123990000 | 118 | 00100 |  | 555470 | [NAME] | 9 | 2016 | 2016-09-02 00:00:00 | 13824 | 685 | -1500 | -1500 | -1500 | 00001 | 00100 | 0000 | 123990000 | SIP4001308 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00845
00001 | 20160244113A | 9 | 3896 | 2016 | 18 | 123990000 | 118 | 00100 |  | 060609 | TRICOMM | 9 | 2016 | 2016-09-06 00:00:00 | 17425 | 685 | -53911 | -53911 | -52242 | 00001 | 00100 | 0000 | 123990000 | 2016-08-45287 | -1669 | 00001 | 00100 | 0000 | 123990000 | 2016-06-45097 | 0 |  |  |  |  |  | XX00845
00001 | 20160244113B | 9 | -3896 | 2016 | 18 | 123990000 | 118 | 00100 |  | 223400 | CONTINENTAL ELECTRICAL CONST | 9 | 2016 | 2016-09-06 00:00:00 | 225834 | 1718 | -9459.66 | -9459.66 | -9459.66 | 00001 | 00100 | 0000 | 123990000 | SIP1012903 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E231417
00001 | 2016084259A | 9 | 826 | 2016 | 4 | 123990000 | 118 | 00100 |  | 158628 | CANEM SYSTEMS LTD | 9 | 2016 | 2016-09-06 00:00:00 | CORR 5 | 2198 | -2585.49 | -2585.49 | -2585.49 | 00201 | 00740 | 0000 | 123990000 | SIP4001183 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E234338
00001 | AVIGEN05271603 | 9 | -317.2 | 2016 | 4 | 123990000 | 118 | 00100 |  | 827343 | IDEA NETWORKS INC | 9 | 2016 | 2016-09-06 00:00:00 | EDI72241 | 877 | -27375.83 | -27375.83 | -27375.83 | 00201 | 00740 | 0000 | 123990000 | [NAME] | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E234338
00001 | AVIGEN06101603 | 9 | -387.5 | 2016 | 4 | 123990000 | 118 | 00100 |  | 122896 | JACOBS TELEPHONE CONTRACTORS | 9 | 2016 | 2016-09-07 00:00:00 | CORR 17 | 2529 | -5822.19 | -5822.19 | -5822.19 | 00001 | 00100 | 0000 | 123990000 | SIP1010978 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E218315
00001 | [NAME] | 9 | -909.23 | 2016 | 4 | 123990000 | 118 | 00100 |  | 272880 | MIDWEST COMMUNICATION SERVICES | 9 | 2016 | 2016-09-08 00:00:00 | 15766 | 1643 | -1408 | -1408 | -1408 | 00001 | 00100 | 0000 | 123990000 | [PHONE] | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00847
00001 | [NAME] | 9 | -1387.44 | 2016 | 4 | 123990000 | 118 | 00100 |  | 485386 | IES COMMERCIAL INC/ | 9 | 2016 | 2016-09-08 00:00:00 | 40885 | 2764 | -5245.36 | -5245.36 | -2584.84 | 00001 | 00100 | 0000 | 123990000 | US-2016-2019-1 | -2660.52 | 00001 | 00100 | 0000 | 123990000 | SIP1012927 | 0 |  |  |  |  |  | XX00844
00001 | AVIGEN06221604 | 9 | -1672.63 | 2016 | 4 | 123990000 | 118 | 00100 |  | 893510 | NETWORK CABLING SVCS | 9 | 2016 | 2016-09-08 00:00:00 | 74571 | 2328 | -2000 | -2000 | -2000 | 00001 | 00100 | 0000 | 123990000 | SIP4001368 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E231417
00001 | [NAME] | 9 | -4054.28 | 2016 | 4 | 123990000 | 118 | 00100 |  | 122896 | JACOBS TELEPHONE CONTRACTORS | 9 | 2016 | 2016-09-08 00:00:00 | CORR 17 | 2529 | -11311.17 | -11311.17 | -3122.96 | 00001 | 00100 | 0000 | 123990000 | SIP1011879 | -2774.01 | 00001 | 00100 | 0000 | 123990000 | SIP1011870 | -5414.2 | 00001 | 00100 | 0000 | SIP1011195-1011196 | 123990000 | E218315
00001 | AVIGEN07051622 | 9 | -350.03 | 2016 | 4 | 123990000 | 118 | 00100 |  | 259846 | [NAME],INC/ GA | 9 | 2016 | 2016-09-08 00:00:00 | CORR 20 | 2992 | -2000 | -2000 | -2000 | 00001 | 00100 | 0000 | 123990000 | SIP4001311 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E230297
00001 | FLP1500117 | 9 | -941.71 | 2016 | 4 | 123990000 | 118 | 00100 |  | 482215 | ELITE CABLE SYSTEMS INC | 9 | 2016 | 2016-09-10 00:00:00 | 4149 | 3482 | -350.03 | -350.03 | -350.03 | 00001 | 00100 | 0000 | 123990000 | AVIGEN07051622 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00847
00001 | FLP1500127 | 9 | -606.01 | 2016 | 4 | 123990000 | 118 | 00100 |  | 029092 | LYNX SYSTEMS LLC | 9 | 2016 | 2016-09-12 00:00:00 | 4559 | 3691 | -2000 | -2000 | -2000 | 00001 | 00100 | 0000 | 123990000 | SIP4001278 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00770
00001 | JB021602 | 9 | -500 | 2016 | 4 | 123990000 | 118 | 00100 |  | 266021 | WORLD TELECOM & SURVEILLANCE | 9 | 2016 | 2016-09-12 00:00:00 | 20792 | 3693 | -1672.63 | -1672.63 | -1672.63 | 00001 | 00100 | 0000 | 123990000 | AVIGEN06221604 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00770
00001 | PAN14831IES1215A | 9 | 11555.36 | 2016 | 4 | 123990000 | 118 | 00100 |  | 541757 | C T S TELECOMMUNICATIONS | 9 | 2016 | 2016-09-12 00:00:00 | 43123 | 2326 | -579 | -579 | -579 | 00001 | 00100 | 0000 | 123990000 | CORNING2016-05-44901 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00770
00001 | PAN14831IES1215B | 9 | -11555.36 | 2016 | 4 | 123990000 | 118 | 00100 |  | 009345 | COMPUTER CABLE INC | 9 | 2016 | 2016-09-12 00:00:00 | CORR 24 | 3741 | -1238.98 | -1238.98 | -1238.98 | 00001 | 00100 | 0000 | 123990000 | CORN2016-02-44066 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E218315
00001 | PAN1995719831 | 9 | -203.44 | 2016 | 4 | 123990000 | 118 | 00100 |  | 070629 | KURE AND ASSOCIATES | 9 | 2016 | 2016-09-14 00:00:00 | 15226 | 2301 | -840.42 | -840.42 | -200 | 00001 | 00100 | 0000 | 123990000 | SIP4001300 | -640.42 | 00001 | 00100 | 0000 | 123990000 | SIP1013043 | 0 |  |  |  |  |  | XX00847
00001 | PAN2017120861 | 9 | -1959.98 | 2016 | 4 | 123990000 | 118 | 00100 |  | 059229 | ADVANCED DATA | 9 | 2016 | 2016-09-15 00:00:00 | 44237 | 3491 | -9816.59 | -9816.59 | -7100 | 00001 | 00100 | 0000 | 123990000 | [NAME] | -1250.22 | 00001 | 00100 | 0000 | 123990000 | SIP1013145 | -1466.37 | 00001 | 00100 | 0000 | SIP1013146 | 123990000 | XX00847
00001 | PAN2019520946 | 9 | -10712.17 | 2016 | 4 | 123990000 | 118 | 00100 |  | 804374 | STURGEON ELECTRIC (W&C) | 9 | 2016 | 2016-09-15 00:00:00 | 2563859 | 4322 | -2720.64 | -2720.64 | -2720.64 | 00001 | 00100 | 0000 | 123990000 | SIP1012069 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00845
00001 | PAN2026121286 | 9 | -120451.83 | 2016 | 4 | 123990000 | 118 | 00100 |  | 150087 | SOUTHWEST CABLE DESIGN | 9 | 2016 | 2016-09-16 00:00:00 | 3217 | 5050 | -387.5 | -387.5 | -387.5 | 00001 | 00100 | 0000 | 123990000 | AVIGEN06101603 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00847
00001 | PAN2094624252 | 9 | -5625.39 | 2016 | 4 | 123990000 | 118 | 00100 |  | 697399 | TCE TECHNOLOGIES INC | 9 | 2016 | 2016-09-16 00:00:00 | 16635 | 5050 | -21082.18 | -21082.18 | -21082.18 | 00001 | 00100 | 0000 | 123990000 | [NAME] | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00847
00001 | PAN2103224617 | 9 | -2636.09 | 2016 | 4 | 123990000 | 118 | 00100 |  | 005016 | ELECTRA LINK  OKC-DEVON TOWER | 9 | 2016 | 2016-09-16 00:00:00 | 28532 | 5050 | -72585.54 | -72585.54 | -24541.83 | 00001 | 00100 | 0000 | 123990000 | SIP1013135 | -24519.96 | 00001 | 00100 | 0000 | 123990000 | SIP1013120 | -23523.75 | 00001 | 00100 | 0000 | SIP10131111 | 123990000 | XX00847
00001 | SIP1010978 | 9 | -5822.19 | 2016 | 4 | 123990000 | 118 | 00100 |  | 005016 | ELECTRA LINK  OKC-DEVON TOWER | 9 | 2016 | 2016-09-16 00:00:00 | 28532 | 5050 | -71956.8 | -71956.8 | -24264.9 | 00001 | 00100 | 0000 | 123990000 | [NAME] | -24213.42 | 00001 | 00100 | 0000 | 123990000 | SIP1013109 | -23478.48 | 00001 | 00100 | 0000 | SIP1013108 | 123990000 | XX00847
00001 | SIP1011195 | 9 | -4082.93 | 2016 | 4 | 123990000 | 118 | 00100 |  | 411723 | SMITH AND LONG LTD | 9 | 2016 | 2016-09-16 00:00:00 | 57563 | 5127 | -1315.86 | -1315.86 | -1315.86 | 00201 | 00740 | 0000 | 123990000 | SIP4001239 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E234338
00001 | SIP1011196 | 9 | -1331.27 | 2016 | 4 | 123990000 | 118 | 00100 |  | 062273 | CACHE VALLEY ELECT/#60995 | 9 | 2016 | 2016-09-16 00:00:00 | CORR 30 | 5186 | -6348.72 | -6348.72 | -2080 | 00001 | 00100 | 0000 | 123990000 | SIP1012425 | -4268.72 | 00001 | 00100 | 0000 | 123990000 | 2015-11-42761 | 0 |  |  |  |  |  | E205090
00001 | SIP1011870 | 9 | -2774.01 | 2016 | 4 | 123990000 | 118 | 00100 |  | 120884 | MELTON ELECTRIC CO | 9 | 2016 | 2016-09-19 00:00:00 | 10796 | 4715 | -17675 | -17675 | -7325 | 00001 | 00100 | 0000 | 123990000 | SIP1013095-1013098 | -10350 | 00001 | 00100 | 0000 | 123990000 | SIP1012934 | 0 |  |  |  |  |  | XX00770
00001 | SIP1011879 | 9 | -3122.96 | 2016 | 4 | 123990000 | 118 | 00100 |  | 072864 | STAFF ELECTRIC | 9 | 2016 | 2016-09-19 00:00:00 | 97385 | 5445 | -6235.86 | -6235.86 | -1691.78 | 00001 | 00100 | 0000 | 123990000 | SIP1013084 | -3680 | 00001 | 00100 | 0000 | 123990000 | SIP1013136 | -864.08 | 00001 | 00100 | 0000 | SIP1013115 | 123990000 | E231417
00001 | SIP1012069 | 9 | -2720.64 | 2016 | 4 | 123990000 | 118 | 00100 |  | 051035 | REYNOLDS, C H ELECTRIC/SJ | 9 | 2016 | 2016-09-19 00:00:00 | 216992 | 5050 | -120451.83 | -120451.83 | -120451.83 | 00001 | 00100 | 0000 | 123990000 | PAN2026121286 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00847
00001 | SIP1012425 | 9 | -2080 | 2016 | 4 | 123990000 | 118 | 00100 |  | 059828 | REDWOOD ELECTRIC GROUP | 9 | 2016 | 2016-09-20 00:00:00 | 421064 | 3909 | -941.71 | -941.71 | -941.71 | 00001 | 00100 | 0000 | 123990000 | FLP15-00117 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00844
00001 | [NAME] | 9 | -21082.18 | 2016 | 4 | 123990000 | 118 | 00100 |  | 560904 | FOREST DATACOM/HOUSE ACCT | 9 | 2016 | 2016-09-21 00:00:00 | 167465 | 6233 | -203.44 | -203.44 | -203.44 | 00001 | 00100 | 0000 | 123990000 | PAN-19957-19831 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00844
00001 | SIP1012895 | 9 | -39825.71 | 2016 | 4 | 123990000 | 118 | 00100 |  | 170353 | MARTELL ELECTRIC | 9 | 2016 | 2016-09-22 00:00:00 | 23280 | 5551 | -2731 | -2731 | -2731 | 00001 | 00100 | 0000 | 123990000 | CORNING2016-04-44841 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00770
00001 | SIP1012903 | 9 | -9459.66 | 2016 | 4 | 123990000 | 118 | 00100 |  | 055984 |  | 9 | 2016 | 2016-09-22 00:00:00 | 55500 | 6519 | -1668.2 | -1668.2 | -1351 | 00001 | 00100 | 0000 | 123990000 | 2016-05-44913 | -317.2 | 00001 | 00100 | 0000 | 123990000 | AVIGEN05271603 | 0 |  |  |  |  |  | XX00846
00001 | SIP1012927 | 9 | -2660.52 | 2016 | 4 | 123990000 | 118 | 00100 |  | 037295 | AMERICAN SYSTEMS CORP / DOC4 | 9 | 2016 | 2016-09-22 00:00:00 | 585291 | 6517 | -1367 | -1367 | -1367 | 00001 | 00100 | 0000 | 123990000 | 2016-05-44934 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00845
00001 | SIP1012934 | 9 | -10350 | 2016 | 4 | 123990000 | 118 | 00100 |  | 058132 | CHERMIK COMMUNICATIONS | 9 | 2016 | 2016-09-22 00:00:00 | CORR 20 | 6876 | -651.41 | -651.41 | -651.41 | 00201 | 00740 | 0000 | 123990000 | 2016-04-44827 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | E234338
00001 | [NAME] | 9 | -7100 | 2016 | 4 | 123990000 | 118 | 00100 |  | 034328 | MILLER ELECTRIC COMPANY | 9 | 2016 | 2016-09-22 00:00:00 | [NAME] | 4932 | -500 | -500 | -500 | 00001 | 00100 | 0000 | 123990000 | SIP4001461 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00844
00001 | [NAME] | 9 | -7495.08 | 2016 | 4 | 123990000 | 118 | 00100 |  | 034328 | MILLER ELECTRIC COMPANY | 9 | 2016 | 2016-09-22 00:00:00 | [NAME] | 4932 | -1000 | -1000 | -1000 | 00001 | 00100 | 0000 | 123990000 | SIP4001475 | 0 |  |  |  |  |  | 0 |  |  |  |  |  | XX00844
00001 | SIP1013043 | 9 | -640.42 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  |  | -592998.7499999999
00001 | [NAME] | 9 | -10148.45 | 2016 | 4 | 123990000 | 118 | 00100
00001 | [NAME] | 9 | -922.72 | 2016 | 4 | 123990000 | 118 | 00100
00201 | [NAME] | 9 | -27377.87 | 2016 | 18 | 123990000 | 118 | 00740 |  |  |  |  |  |  |  |  | 8761.029999999912
00001 | SIP1013084 | 9 | -1691.78 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP1013095 | 9 | -2600 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -2725 | not applied by AP
00001 | SIP1013096 | 9 | -1125 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -3065 | not applied by AP
00001 | SIP1013097 | 9 | -1600 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | 2.04 |  | CAD REBATE  SIP1013076 OFF VARIANCE
00001 | SIP1013098 | 9 | -2000 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -2731
00001 | SIP1013108 | 9 | -23478.48 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | 0.2 |  | CAD REBATE  SIP4001183  OFF VARIANCE
00001 | [NAME] | 9 | -24264.9 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | 1600 |  | not applied by AR
00001 | SIP1013111 | 9 | -23523.75 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -1315.86 | not applied by AP
00001 | SIP1013115 | 9 | -864.08 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -1000 | not applied by AP
00001 | SIP1013120 | 9 | -24519.96 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | 1125 |  | not applied by AR
00001 | SIP1013135 | 9 | -24541.83 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -651.41 | not applied by AP
00001 | SIP1013136 | 9 | -3680 | 2016 | 4 | 123990000 | 118 | 00100 |  |  |  |  |  |  |  |  | -8.833467290969566e-11 | off
00001 | SIP1013145 | 9 | -1250.22 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP1013146 | 9 | -1466.37 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP101319 | 9 | -24213.42 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP4000862 | 9 | -2000 | 2016 | 4 | 123990000 | 118 | 00100
00201 | SIP4001183 | 9 | -2585.69 | 2016 | 18 | 123990000 | 118 | 00740
00001 | SIP4001278 | 9 | -2000 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP4001300 | 9 | -200 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP4001308 | 9 | -1500 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP4001311 | 9 | -2000 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP4001319 | 9 | -2000 | 2016 | 4 | 123990000 | 118 | 00100
00001 | [NAME] | 9 | -500 | 2016 | 4 | 123990000 | 118 | 00100
00001 | SIP4001368 | 9 | -2000 | 2016 | 4 | 123990000 | 118 | 00100
00001 | US20162091 | 9 | -2584.84 | 2016 | 4 | 123990000 | 118 | 00100
 |  |  | -584237.72