Spreadsheet: 673817d1587554043-match-positive-and-negative-amount-to-get-zero-balance-excel-matchning-zero-balance
Sheet: SAP

Assignment | Document Number | Business Area | Account | Document type | Year/month | Document Date | Posting Date | Posting Key | Amount in local currency | Clearing Document | Text | Profit Center | Document Header Text | PO Name | Profit Center POS |  | 2020-01-10 00:00:00
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2021/02 | 2020-02-11 00:00:00 | 2020-02-11 00:00:00 | 50 | -5037.95 |  | ALLIANCE CC-1002;1102 | 10541093 |  | ALAMANDA - COUNTER | 10541093
20200211 | [PHONE] | 1005 | 273625 | XN | 2021/02 | 2020-02-11 00:00:00 | 2020-02-11 00:00:00 | 40 | 1517.8 |  | [PHONE] 00000 Credit Card | 10541093 |  | ALAMANDA - COUNTER | 10541093
20200210 | [PHONE] | 1005 | 273625 | XN | 2021/02 | 2020-02-10 00:00:00 | 2020-02-10 00:00:00 | 40 | 3520.15 |  | [PHONE] 00000 Credit Card | 10541093 |  | ALAMANDA - COUNTER | 10541093
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2020/08 | 2019-11-10 00:00:00 | 2019-11-10 00:00:00 | 50 | -4949.08 |  | ALLIANCE CC-1011 | 10541093 |  | ALAMANDA - COUNTER | 10541093
20191110 | [PHONE] | 1005 | 273625 | XN | 2020/08 | 2019-11-10 00:00:00 | 2019-11-10 00:00:00 | 40 | 4949 |  | [PHONE] 00000 Credit Card | 10541093 |  | ALAMANDA - COUNTER | 10541093
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2020/08 | 2019-11-06 00:00:00 | 2019-11-06 00:00:00 | 50 | -1924.25 |  | ALLIANCE CC-0611 | 10541093 |  | ALAMANDA - COUNTER | 10541093
20191106 | [PHONE] | 1005 | 273625 | XN | 2020/08 | 2019-11-06 00:00:00 | 2019-11-06 00:00:00 | 40 | 1902.45 |  | [PHONE] 00000 Credit Card | 10541093 |  | ALAMANDA - COUNTER | 10541093
20200420 | [PHONE] | 1006 | 273625 | XN | 2021/04 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 40 | 63.45 |  | [PHONE] 00000 Credit Card | 10641049 |  | AMPANG-COUNTER | 10641049
[PHONE] | [PHONE] | 1006 | 273625 | ZT | 2021/04 | 2020-04-18 00:00:00 | 2020-04-18 00:00:00 | 50 | -376.1 |  | ALLIANCE CC-1804;1704 | 10641049 |  | AMPANG-COUNTER | 10641049
20200418 | [PHONE] | 1006 | 273625 | XN | 2021/04 | 2020-04-18 00:00:00 | 2020-04-18 00:00:00 | 40 | 49.4 |  | [PHONE] 00000 Credit Card | 10641049 |  | AMPANG-COUNTER | 10641049
20200417 | [PHONE] | 1006 | 273625 | XN | 2021/04 | 2020-04-17 00:00:00 | 2020-04-17 00:00:00 | 40 | 326.7 |  | [PHONE] 00000 Credit Card | 10641049 |  | AMPANG-COUNTER | 10641049
[PHONE] | [PHONE] | 1006 | 273625 | ZT | 2021/04 | 2020-04-15 00:00:00 | 2020-04-15 00:00:00 | 50 | -1045.6 |  | ALLIANCE CC-1903;1504 | 10641049 |  | AMPANG-COUNTER | 10641049
20200415 | [PHONE] | 1006 | 273625 | XN | 2021/04 | 2020-04-15 00:00:00 | 2020-04-15 00:00:00 | 40 | 786.3 |  | [PHONE] 00000 Credit Card | 10641049 |  | AMPANG-COUNTER | 10641049
20200319 | [PHONE] | 1006 | 273625 | XN | 2021/03 | 2020-03-19 00:00:00 | 2020-03-19 00:00:00 | 40 | 259.3 |  | [PHONE] 00000 Credit Card | 10641049 |  | AMPANG-COUNTER | 10641049
20200420 | [PHONE] | 1003 | 273625 | XN | 2021/04 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 40 | 261.05 |  | [PHONE] 00000 Credit Card | 10341041 |  | B.BARU AYER ITAM-COUNTER | 10341041
20181031 | [PHONE] | 1003 | 273625 | XN | 2019/07 | 2018-10-31 00:00:00 | 2018-10-31 00:00:00 | 40 | 1151.95 |  | [PHONE] 00000 Credit Card | 10341041 |  | B.BARU AYER ITAM-COUNTER | 10341041
20200420 | [PHONE] | 1004 | 273625 | XN | 2021/04 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 40 | 1060.7 |  | [PHONE] 00000 Credit Card | 10441005 |  | BAGAN SERAI-COUNTER | 10441005
20200420 | [PHONE] | 1005 | 273625 | XN | 2021/04 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 40 | 1469.6 |  | [PHONE] 00000 Credit Card | 10541074 |  | BALAKONG-COUNTER | 10541074
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2021/01 | 2020-01-28 00:00:00 | 2020-01-28 00:00:00 | 50 | -2044.55 |  | ALLIANCE CC-2801;2401 | 10541074 |  | BALAKONG-COUNTER | 10541074
20200128 | [PHONE] | 1005 | 273625 | XN | 2021/01 | 2020-01-28 00:00:00 | 2020-01-28 00:00:00 | 40 | 1752.05 |  | [PHONE] 00000 Credit Card | 10541074 |  | BALAKONG-COUNTER | 10541074
20200124 | [PHONE] | 1005 | 273625 | XN | 2021/01 | 2020-01-24 00:00:00 | 2020-01-24 00:00:00 | 40 | 292.5 |  | [PHONE] 00000 Credit Card | 10541074 |  | BALAKONG-COUNTER | 10541074
20200420 | [PHONE] | 1003 | 273625 | XN | 2021/04 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 40 | 727.85 |  | [PHONE] 00000 Credit Card | 10341004 |  | BALIK PULAU-COUNTER | 10341004
20200420 | [PHONE] | 1005 | 273625 | XN | 2021/04 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 40 | 946.6 |  | [PHONE] 00000 Credit Card | 10541056 |  | [NAME] | 10541056
[PHONE] | [PHONE] | 1000 | 273625 | SH | 2021/03 | 2020-03-17 00:00:00 | 2020-03-17 00:00:00 | 50 | -1648.55 |  | CARD & PAYMENT SERVICES MC PYMT TO MERCHANT | 10002010 | [PHONE] | [NAME] | 10541056
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2021/03 | 2020-03-16 00:00:00 | 2020-03-16 00:00:00 | 40 | 1648.55 |  | ALLIANCE CC-1603;0703 | 10541056 |  | [NAME] | 10541056
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2021/03 | 2020-03-16 00:00:00 | 2020-03-16 00:00:00 | 40 | 94.9 |  | ALLIANCE CC-1603;0703 | 10541056 |  | [NAME] | 10541056
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2021/03 | 2020-03-09 00:00:00 | 2020-03-09 00:00:00 | 50 | -1296.3 |  | ALLIANCE CC-0703;0903 | 10541056 |  | [NAME] | 10541056
20200309 | [PHONE] | 1005 | 273625 | XN | 2021/03 | 2020-03-09 00:00:00 | 2020-03-09 00:00:00 | 40 | 1201.4 |  | [PHONE] 00000 Credit Card | 10541056 |  | [NAME] | 10541056
[PHONE] | [PHONE] | 1005 | 273625 | ZT | 2021/02 | 2020-02-05 00:00:00 | 2020-02-05 00:00:00 | 50 | -1033.4 |  | ALLIANCE CC-0502 | 10541056 |  | [NAME] | 10541056
20200205 | [PHONE] | 1005 | 273625 | XN | 2021/02 | 2020-02-05 00:00:00 | 2020-02-05 00:00:00 | 40 | 1033.6 |  | [PHONE] 00000 Credit Card | 10541056 |  | [NAME] | 10541056