Spreadsheet: 753537d1635504222-sumifs-function-issues-sample
Sheet: Transaction Liste 20102021

Table of Contents
Voucher no. | Voucher date | Posting date | Project no. | budget line | posting text | Currency | amount LC | amount € | pos. | Indiv. structure | cost element | SAP Account | Recip./Partner no. | Recip./Partner name | Recip./Partner | Reference/Supplier | TA | posted by | target account | target SWIFT | Cost element number | Reversal voucher no. | Reason for reversal | Reversal voucher | Reporting currency | Rate | Amount RC | Budget draft no. | Reference voucher loan | reference voucher | Reference voucher # | Reference posting key | Inventory no. | row type | Status voucher position | Status voucher | Month ID
124102496 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.1.6 | PB to COD 1159 : 07/2021 ; Sal. 8043 | EUR | -3254.41 | -3254.41 | 001 |  | salaries expat staff |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102524 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.1.6 | PB to COD 1159 : 08/2021 ; [NAME]. 8043 | EUR | -2983.27 | -2983.27 | 001 |  | salaries expat staff |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700801 | 2021-09-16 00:00:00 | 2021-10-12 00:00:00 | 001042 | 1.1.6 | R&R | USD | -413.5 | -353.42 | 001 |  | salaries expat staff | 043155 |  |  |  | [NAME] | 00 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | K
203700817 | 2021-09-17 00:00:00 | 2021-10-13 00:00:00 | 001042 | 1.1.6 | Règlement d'une avance,Vo 203700740 | USD | -93 | -79.49 | 001 |  | salaries expat staff |  |  |  | CPDSTAFF | DGM | 08 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
197102613 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 001042 | 1.2.12 | Salaire 00003217/9/2021 | USD | -1598.43 | -1366.18 | 001 |  | salaries nat. staff | 043141 |  |  |  | [NAME] | 80 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
124102419 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 001042 | 1.3.1 | PB to  COD 1159 : 06/2021 ; [NAME]. 2135 | EUR | -784.79 | -784.79 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] | 124102423 | Vo 124102419 annullé car erreur posting date |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102423 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 001042 | 1.3.1 | Vo 124102419 annullé car erreur posting date | EUR | 784.79 | 784.79 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] | 124102419 | Vo 124102419 annullé car erreur posting date | X |  |  |  | 00001059 |  |  |  | 000 |  | F
124102426 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.1 | PB to COD 1159 : 06/2021 ; [NAME]. 2135 | EUR | -784.79 | -784.79 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102457 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.1 | PB to COD 1159 : 07/2021 ; Sal. 2135 | EUR | -784.79 | -784.79 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102462 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.1 | PB to COD 1159 : 08/2021 ; [NAME]. 2135 | EUR | -784.79 | -784.79 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102467 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.2 | PB to COD 1159 : 07/2021 ; [NAME]. 8511 | EUR | -671.38 | -671.38 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102543 | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 | 001042 | 1.3.3 | PB to COD 1159: 09/2021, Sal.1446 | EUR | -690.24 | -690.24 | 001 |  | DON-MO operational c |  |  |  |  | COD 1159 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102413 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 001042 | 1.3.4 | PB to  COD 1159 : 06/2021 ; [NAME]. 8950 | EUR | -565.49 | -565.49 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] | 124102421 | Annullation 124102413 Erreur posting date |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102421 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 001042 | 1.3.4 | Annullation 124102413 Erreur posting date | EUR | 565.49 | 565.49 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] | 124102413 | Annullation 124102413 Erreur posting date | X |  |  |  | 00001059 |  |  |  | 000 |  | F
124102424 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.4 | PB to COD 1159 : 06/2021 ; [NAME]. 8950 | EUR | -565.49 | -565.49 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102447 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.4 | PB to COD 1159 : 07/2021 ; Sal. 8950 | EUR | -559.34 | -559.34 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
124102452 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 001042 | 1.3.4 | PB to COD 1159 : 08/2021 ; [NAME]. 8950 | EUR | -600.89 | -600.89 | 001 |  | DON-MO operational c |  |  |  |  | COD 1141 | 83 | PolepoleKa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
[PHONE] | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 001042 | 1.3.5 | Reb sal 06/2021 | EUR | -551.18 | -551.18 | 003 |  | DON-MO operational c | 004443 |  |  |  |  |  | JAYATCE |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000
[PHONE] | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 001042 | 1.3.5 | [NAME] | EUR | -551.18 | -551.18 | 003 |  | DON-MO operational c | 004443 |  |  |  |  |  | JAYATCE |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000
203700806 | 2021-08-24 00:00:00 | 2021-10-12 00:00:00 | 001042 | 1.4.3 | Paie 2chauff,transpor machine à Mambasa,12-19.7.21 | USD | -431 | -368.38 | 001 |  | other prog. costs |  | 203700046 | Benoit-Kalembe | CPDCONTR | Benoit-Kalembe | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700807 | 2021-07-22 00:00:00 | 2021-10-12 00:00:00 | 001042 | 1.4.3 | [NAME],gardienage de Kiwanja-Butembo | USD | -60 | -51.28 | 002 |  | other prog. costs |  | 203700047 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700808 | 2021-07-12 00:00:00 | 2021-10-12 00:00:00 | 001042 | 1.4.3 | Reglement  d'avance vo 203700747 | USD | -105 | -89.74 | 003 |  | other prog. costs |  | 203700047 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700809 | 2021-07-12 00:00:00 | 2021-10-12 00:00:00 | 001042 | 1.4.3 | Paie chauff,transport machine à Mambasa,12-28.7.21 | USD | -216 | -184.62 | 001 |  | other prog. costs |  | 203700048 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700828 | 2021-10-06 00:00:00 | 2021-10-15 00:00:00 | 001042 | 1.4.3 | Honor journalier,,fix échafau6/10/21/DA1205 | USD | -5 | -4.27 | 001 |  | other prog. costs | 043155 |  |  |  | Muhindo-Mumbere | 00 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | K
203700807 | 2021-07-22 00:00:00 | 2021-10-12 00:00:00 | 001042 | 2.1 | Perdiem,4 Chauffeurs,transport 3 machine à Mambasa | USD | -1360 | -1162.39 | 001 |  | per diems staff |  | 203700047 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700808 | 2021-07-12 00:00:00 | 2021-10-12 00:00:00 | 001042 | 2.1 | Reglement  d'avance vo 203700747 | USD | -870 | -743.59 | 001 |  | per diems staff |  | 203700047 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
[PHONE] | 2021-09-23 00:00:00 | 2021-10-08 00:00:00 | 001042 | 2.2 | Raptim Paron | EUR | -422.6 | -422.6 | 002 |  | travel costs staff | 004415 |  |  |  |  |  | SEILEROL |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000
203700789 | 2021-09-27 00:00:00 | 2021-10-08 00:00:00 | 001042 | 2.2 | Test covid,logement/voya Italy-Gom,50% 1144,Corrad | USD | -152.5 | -130.34 | 001 |  | travel costs staff | 043155 |  |  |  | Centro medic Esperia | 00 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | K
203700804 | 2021-08-27 00:00:00 | 2021-10-12 00:00:00 | 001042 | 2.2 | [NAME] voyage,test [NAME],PA,,50% | USD | -99 | -84.62 | 001 |  | travel costs staff |  | 203700045 | Prudence Wongbi | CPDCONTR | DHL Express | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
197102611 | 2021-09-09 00:00:00 | 2021-09-27 00:00:00 | 001042 | 2.3 | Logement Prudence, PA, 50% du 19/8-10/9/21 | USD | -550 | -470.09 | 001 |  | travel costs staff | 043141 |  |  |  | Centre d'Acc Caritas | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
203700820 | 2021-10-06 00:00:00 | 2021-10-14 00:00:00 | 001042 | 3.1 | Achat matériel,fabrication table bureau,50%,DA 468 | USD | -127 | -108.55 | 001 |  | Other Equipment | 043155 |  |  |  | Ets Kavumu City | 00 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | K
203700807 | 2021-07-22 00:00:00 | 2021-10-12 00:00:00 | 001042 | 5.1 | Achat pièces des véhicules | USD | -30 | -25.64 | 003 |  | veh. running cost |  | 203700047 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
203700808 | 2021-07-12 00:00:00 | 2021-10-12 00:00:00 | 001042 | 5.1 | Reglement  d'avance vo 203700747 | USD | -15 | -12.82 | 002 |  | veh. running cost |  | 203700047 | [NAME] | CPDCONTR | [NAME] | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
197102610 | 2021-08-17 00:00:00 | 2021-08-31 00:00:00 | 001042 | 5.10 | [NAME] bancaire impression chequiers et OP/ 8/2021 | USD | -60 | -51.28 | 001 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
197102612 | 2021-09-09 00:00:00 | 2021-09-30 00:00:00 | 001042 | 5.10 | [NAME] banacaire 1er fonds recu du siège 8/9/21 | USD | -35 | -29.91 | 001 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
197102612 | 2021-09-09 00:00:00 | 2021-09-30 00:00:00 | 001042 | 5.10 | [NAME] banacaire impression 1 OP/2/9/21 | USD | -30 | -25.64 | 002 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
197102612 | 2021-09-09 00:00:00 | 2021-09-30 00:00:00 | 001042 | 5.10 | [NAME] banacaire transfert salaire 9, log  [NAME] | USD | -50 | -42.74 | 003 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
197102612 | 2021-09-09 00:00:00 | 2021-09-30 00:00:00 | 001042 | 5.10 | Frs bancaire correction compte, moins de 23 chiffr | USD | -25 | -21.37 | 004 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
197102612 | 2021-09-09 00:00:00 | 2021-09-30 00:00:00 | 001042 | 5.10 | [NAME] bancaire retrait chèques  27/9/21 | USD | -21.75 | -18.59 | 005 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
197102614 | 2021-09-22 00:00:00 | 2021-09-27 00:00:00 | 001042 | 5.10 | [NAME] bancaire salaire 9/2021 | USD | -34.34 | -29.35 | 001 |  | bank fees | 043141 |  |  |  | Rawbank | 00 | RubengaJu |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | B
203700803 | 2021-10-01 00:00:00 | 2021-10-12 00:00:00 | 001042 | 5.9 | Achat,crédit d'appel,staffs,Octobre 2021,DA no 859 | USD | -410 | -350.43 | 001 |  | office runn. costs |  | 203700009 | BOLA TUNAVE | CPDCONTR | Ets Bahati notezbien | 07 | MatemaneCa |  |  | [PHONE] |  |  |  |  |  |  | 00001059 |  |  |  | 000 |  | F
Total