A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Date | Description | Amount | Running Bal. | ВЫВЕДЕМ ТО, ЧТО ПОСЛЕ COMPANY: и до первого пробела (или до конца строки) | ВЫВЕДЕМ СУММУ ИЗ "С:C", ЕСЛИ В "B:B" СЛОВО WIRE |
2 | =ARRAYFORMULA(ifna( REGEXEXTRACT(B3:B18;"COMPANY:([^ ]+)"))) | =ARRAYFORMULA( if(REGEXMATCH(B3:B19;"(?i)wire");C3:C19;)) | ||||
3 | 10/01/2021 | Beginning balance as of 10/01/2021 | 310420,82 | |||
4 | 10/01/2021 | Online Banking transfer to CHK Confirmation# 5308506223 | -$1 050,00 | 309370,82 | ||
5 | 10/01/2021 | Online Banking transfer to CHK Confirmation# 7208510957 | -$174,13 | 309196,69 | ||
6 | 10/01/2021 | Online Banking transfer to CHK Confirmation# 5308513228 | -$35,00 | 309161,69 | ||
7 | 10/01/2021 | . CO ID:1492934832948 CCD PMT INFO:SETTLE 9/29/21 COMPANY:GKL | -$21 726,41 | 287435,28 | GKL | |
8 | 10/04/2021 | Online Banking transfer from CHK 7019 Confirmation# 5217215917 | $2 895,00 | 290330,28 | ||
9 | 10/04/2021 | CO ID:1471426777 CCD PMT INFO:SETTLE COMPANY:FGK 9/30/21 | -$27 774,36 | 262555,92 | FGK | |
10 | 10/05/2021 | WIRE TYPE:WIRE IN DATE: 211005 TIME:1134 ET TRN:2021100500322503 SEQ:2021100500078578/342376 ORIG:ADCOMBO LP ID:4122526254 SND BK:WELLS FARGO B ANK NA ID:0407 PMT DET:100191024750751 PAYOUTS TO AFFILIATES | $69 985,00 | 332540,92 | $69 985,00 | |
11 | 10/05/2021 | WIRE TYPE:WIRE IN DATE: 211005 TIME:1134 ET TRN:2021100500322504 SEQ:2021100500078579/342384 ORIG:ADCOMBO LP ID:4122526254 SND BK:WELLS FARGO B ANK NA ID:0407 PMT DET:100191024750764 PAYOUTS TO AFFILIATES | $29 985,00 | 362525,92 | $29 985,00 | |
12 | 10/05/2021 | WIRE TYPE:WIRE IN DATE: 211005 TIME:0537 ET TRN:2021100500123504 SEQ:S06127806BFC01/092929 ORIG:ADCOMBO LP ID:DK20890000905864 SND BK:CITIBAN K, N.A. ID:0008 PMT DET:DIGITAL MARKETING SERVICES ,INV GGT.04/10/2021., DD 04.10.2021 | $3 475,00 | 366000,92 | $3 475,00 | |
13 | 10/05/2021 | Online Banking transfer from CHK Confirmation# 14432 | $1 930,00 | 367930,92 | ||
14 | 10/05/2021 | WIRE TYPE:INTL OUT DATE:211005 TIME:1348 ET TRN:2021100500377583 SERVICE REF:381194 BNF COMPANY:ABC LP ID BNF BK:BANKING PMT DET:358082126 REFUND DEPOSIT FOR MARKETING SERVI POP SERVICES | -$4 115,00 | 363815,92 | ABC | -$4 115,00 |
15 | 10/05/2021 | PAY DES:. COMPANY:DFV 7 CCD PMT INFO:SETTLE 10/01/21-10/03/21 | -$63 271,15 | 300544,77 | DFV | |
16 | 10/05/2021 | Prfd Rwds for Bus-Wire Fee Waiver of $15 | $0,00 | 300544,77 | 0 | |
17 | 10/05/2021 | Prfd Rwds for Bus-Wire Fee Waiver of $15 | $0,00 | 300544,77 | 0 | |
18 | 10/05/2021 | Prfd Rwds for Bus-Wire Fee Waiver of $15 | $0,00 | 300544,77 | 0 | |
19 | ||||||
20 | ||||||
21 |