Spreadsheet: 779401d1651759409-dynamic-formula-duplicate-single-id-into-2-rows-but-split-account-and-amount-expenses
Sheet: 04.22

 |  |  |  |  |  |  |  |  |  |  | 2022-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  | External id | ACCOUNT | DEBIT | CREDIT | DEPARTMENT | Vendor ID | MEMO | [NAME] | Currency
 | ILS
 |  |  |  |  |  |  | 30.04.22
 | Account | Vendor ID | Department | MEMO | Currency | Amount in ILS | Exchange rate | Amount in USD | JE
 | 610040.02 | 201370 | G&A : Accounting & Finance | Accrued  vendor A 04.22 | ILS | 52000 | 0.314861
 | 611000.32 | 2252883 | [NAME] : People | Accrued  vendor B 04.22 | ILS | 31000 | 0.301477 |  | yes
 | 616150 | 252001 | People | Accrued  vendor C 04.22 | ILS | 14850 | 0.301477 |  | yes
 | 611020 | 252907 | Engineering : Engineering. | Accrued  vendor D 04.22 | ILS |  | 0.301477 |  | yes
 | 610090.03 | 253159 |  | Accrued  vendor D 04.22 |  | 50000 | 0.301477
 | 616250 |  | G&A : Accounting & Finance | Accrued  vendor H 04.22 | ILS | 120000 | 0.301477
 | 607000.02 |  | People | Accrued  vendor I 04.22 |  |  | 0.301477
 | 612000.67 |  | G&A : Accounting & Finance | Accrued  vendor J 04.22 |  |  | 0.301477
 | 618350 | 2252922 | G&A : Accounting & Finance | Accrued  vendor K 04.22 | ILS | 5200 | 0.301477 |  | yes
 | 620100 | 251927 | G&A : Accounting & Finance | Accrued  vendor L 04.22 | ILS | 3400 | 0.301477 |  | yes
 | 611020 | 2252935 | Engineering : Engineering. | Accrued  vendor M 04.22 | ILS | 15000 | 0.301477 |  | yes
 | Total
 | USD
 | Account |  | Department | Details |  | Amount in ILS | Exchange rate | Amount in USD
 | 501300 | 201040 | [NAME] | Accrued  vendor N 04.22 | USD |  | 3.317 | 1430000 | yes
 | 501300 | 201040 | [NAME] | Accrued  vendor O 04.22 | USD |  | 3.238 | 318888.75 |  |  |  | 611000.32 | 9345.787 |  | [NAME] : People | 2252883 | Accrued  vendor B 04.22 | Accrued  vendor B 04.22 | ILS
 | 610070 |  | G&A : Accounting & Finance | Accrued  vendor P 04.22 | USD |  | 3.317 |  | yes |  | 1Acrrued30.04.22 | 204000 |  | 9345.787 | [NAME] : People | 2252883 | Accrued  vendor B 04.22 | Accrued  vendor B 04.22 | ILS
 | 505200.01 | 253193 | [NAME] | Accrued  vendor Q 04.22 | USD |  | 3.317 | 170000 | yes |  | 2Acrrued30.04.22 | 616150 | 4476.93345 |  | People | 252001 | Accrued  vendor C 04.22 | Accrued  vendor C 04.22 | ILS
 | 612000.84 | 201250 | Engineering : Engineering. | Accrued  vendor R 04.22 | USD |  | 3.317 |  | yes |  | 2Acrrued30.04.22 | 204000 |  | 4476.93345 | People | 252001 | Accrued  vendor C 04.22 | Accrued  vendor C 04.22 | ILS
 | Total |  |  |  |  |  |  |  |  |  | 3Acrrued30.04.22 | 611020 | 79589.928 |  | Engineering : Engineering. | 252907 | Accrued  vendor D 04.22 | Accrued  vendor D 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 3Acrrued30.04.22 | 204000 |  | 79589.928 | Engineering : Engineering. | 252907 | Accrued  vendor D 04.22 | Accrued  vendor D 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 4Acrrued30.04.22 | 618350 | 1567.6804 |  | G&A : Accounting & Finance | 2252922 | Accrued  vendor K 04.22 | Accrued  vendor K 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 4Acrrued30.04.22 | 204000 |  | 1567.6804 | G&A : Accounting & Finance | 2252922 | Accrued  vendor K 04.22 | Accrued  vendor K 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 5Acrrued30.04.22 | 620100 | 1025.0218 |  | G&A : Accounting & Finance | 251927 | Accrued  vendor L 04.22 | Accrued  vendor L 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 5Acrrued30.04.22 | 204000 |  | 1025.0218 | G&A : Accounting & Finance | 251927 | Accrued  vendor L 04.22 | Accrued  vendor L 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 6Acrrued30.04.22 | 611020 | 4522.155 |  | Engineering : Engineering. | 2252935 | Accrued  vendor M 04.22 | Accrued  vendor M 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 6Acrrued30.04.22 | 204000 |  | 4522.155 | Engineering : Engineering. | 2252935 | Accrued  vendor M 04.22 | Accrued  vendor M 04.22 | ILS
 |  |  |  |  |  |  |  |  |  |  | 7Acrrued30.04.22 | 501300 | 1430000 |  | [NAME] | 201040 | Accrued  vendor N 04.22 | Accrued  vendor N 04.22 | USD
 |  |  |  |  |  |  |  |  |  |  | 7Acrrued30.04.22 | 204000 |  | 1430000 | [NAME] | 201040 | Accrued  vendor N 04.22 | Accrued  vendor N 04.22 | USD
 |  |  |  |  |  |  |  |  |  |  | 8Acrrued30.04.22 | 610070 | 60833 |  | G&A : Accounting & Finance | 0 | Accrued  vendor P 04.22 | Accrued  vendor P 04.22 | USD
 |  |  |  |  |  |  |  |  |  |  | 8Acrrued30.04.22 | 204000 |  | 60833 | G&A : Accounting & Finance | 0 | Accrued  vendor P 04.22 | Accrued  vendor P 04.22 | USD
 |  |  |  |  |  |  |  |  |  |  | 10Acrrued30.04.22 | 612000.84 | 14000 |  | Engineering : Engineering. | 201250 | Accrued  vendor R 04.22 | Accrued  vendor R 04.22 | USD
 |  |  |  |  |  |  |  |  |  |  | 10Acrrued30.04.22 | 204000 |  | 14000 | Engineering : Engineering. | 201250 | Accrued  vendor R 04.22 | Accrued  vendor R 04.22 | USD