{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","DropDown"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Import Cash Flows"]
[]
[null,"Action","Account","Flow Status","Date","Currency","Amount","Flow Code","Flow Code Name","Budget Code","Budget Code Name","SAP ID","Description"]
["expample","Creation","CIT1004BNL1","Confirmed Forecast","2021-03-01","EUR",6982.44,"DPAYROLL",{"$f":"IF(ISERROR(VLOOKUP(H6,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H6,DropDown!D:E,2,FALSE))","v":"Payroll Payment"},"WAGES",{"$f":"IF(ISERROR(VLOOKUP(J6,DropDown!F:G,2,FALSE)),\"\",VLOOKUP(J6,DropDown!F:G,2,FALSE))","v":"Salary"},null,"payroll june"]
["expample","Creation","CIT1004BNL1","Confirmed Forecast","2023-12-01","HUF",238000,"CDOMTR","VAT payment December 2023","VAT","VAT payment",null,"VAT declaration payment 12.2023"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[null,null,null,null,null,"EUR"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H48,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H48,DropDown!D:E,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H49,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H49,DropDown!D:E,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H50,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H50,DropDown!D:E,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H51,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H51,DropDown!D:E,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H52,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H52,DropDown!D:E,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H53,DropDown!D:E,2,FALSE)),\"\",VLOOKUP(H53,DropDown!D:E,2,FALSE))","v":""}]

{"sheet":"DropDown","index":1,"n_rows":126,"n_cols":7,"rows_kept":126,"cut":false,"hidden":true,"merged":[[0,3,0,4],[0,5,0,6]]}
["Action","Flow Status","Currency","Flow Code",null,"Budget Code"]
["None"]
["Creation","Actual","EUR","BEGBAL","Begining Balances","BTB","Bank to Bank"]
["Modification","Estimated Forecast","ARS","CBANCOM","Bancomat Receipts","CAPEX","Capex Payments"]
["Deletion","Confirmed Forecast","BRL","CBBTRF","Urgent Bank to Bank Transfer","CINTFIN","Loan Interest Collection"]
[null,null,"CHF","CBKARRLE","Bank Fees Arranging Loan Expenses","CIT","CIT"]
[null,null,"CLP","CBKFEE","Bank Fees Received","CLOANFIN","Loan Investment"]
[null,null,"COP","CBKREJ","Bank Transfer Rejected","COLLECT","Collection A.R."]
[null,null,"CZK","CBKTAX","Tax on Bank Transactions Received","CZBA","ZBA Collection"]
[null,null,"DOP","CCAMEWEB","Amex Web Receipts","DBKFE","Bank Fees"]
[null,null,"GBP","CCAMEX","Credit Card Amex Receipt","DINSFIN","Financial Instruments Disbursment"]
[null,null,"HUF","CCASH","Cash In","DIVEST","Desinvestment Collections"]
[null,null,"MXN","CCCCO","Credit Card Commission Refund","DIVIDEND","Dividend"]
[null,null,"PAB","CCCUP","Credit Card CUP Receipt","DOTHFIN","Other Funding Disbursment"]
[null,null,"PLN","CCDINE","Diners Cards Receipt","DZBA","ZBA Disbursment"]
[null,null,"RON","CCDRDEB","Cancellation Direct Debit","FEES","Management Fees"]
[null,null,"USD","CCEUROCO","Euroconex Receipts","ICCO","Interco Collection"]
[null,null,"UYU","CCHECKF","Receipt Check Foreign","ICCOFIN","Interco Financial Collection"]
[null,null,"VEF","CCHEKD","Receipt Check Domestic","ICPAY","Interco Payments"]
[null,null,"ZAR","CCJCB","Credit Card JCB Receipt","ICPAYFIN","Interco Financial Payments"]
[null,null,"DKK","CCKUNP","Check Unpaid","INSFIN","Financial Instruments Collection"]
[null,null,null,"CCMAS","Master Card Receipt","INTFIN","Loan Interest Payments"]
[null,null,null,"CCONFI","Confirming Receipt","LOANFIN","Loan Repayment"]
[null,null,null,"CCOTH","Credit Cards Other Type","OTAX","Other Taxes"]
[null,null,null,"CCVISA","Visa Card Receipt","OTHFIN","Other Funding Collection"]
[null,null,null,"CDBTB","Domestic Bank to Bank","OTHOC","Other Operating Collections"]
[null,null,null,"CDC","Debit Card (maestro)","OTHOP","Other Operating Payments"]
[null,null,null,"CDCC","DCC Receipts","RENTS","Rents"]
[null,null,null,"CDCOTH","Local Debit Card (national)","SUPPLIER","Suppliers"]
[null,null,null,"CDOIBB","Domestic Intercompany Financial Receipts","VAT","VAT"]
[null,null,null,"CDOMTR","Domestic Transfer Receipt","VATR","VAT Refund"]
[null,null,null,"CDRCRE","Direct Credit","WAGES","Salary"]
[null,null,null,"CFACTO","Factoring","WAGTAX","Payroll Taxes"]
[null,null,null,"CFBTB","Foreign Bank to Bank"]
[null,null,null,"CFOIBB","Foreign Intercompany Financial Receipts"]
[null,null,null,"CFORTR","Foreign Transfer Receipt"]
[null,null,null,"CFRCST","Automated Forecast Receipts"]
[null,null,null,"CFXFW","FX Forward Sale"]
[null,null,null,"CHISLOAN","Collection Historical LOAN"]
[null,null,null,"CICT","Intercompany Credit Transfer (AR)"]
[null,null,null,"CIICLO","Receipt Interest Interco Credit/Loan"]
[null,null,null,"CILTLO","Intragroup Principal Long Term Credit/Loan"]
[null,null,null,"CINHBANK","SAP Movements In House Bank"]
[null,null,null,"CINTBANK","Interest on Bank account Receipt"]
[null,null,null,"CINTDEP","Interest in Time Deposit"]
[null,null,null,"CINTFAC","Factoring Interest"]
[null,null,null,"CINTINV","Interest Financing Investments"]
[null,null,null,"CINVEST","Investment Securities Sell"]
[null,null,null,"CLTLOAN","L/T Loan Financing"]
[null,null,null,"CMIS","Miscellaneous Receipt"]
[null,null,null,"COINT","Other Interest"]
[null,null,null,"CPAGAR","Pagares Receipt"]
[null,null,null,"CPAYROLL","Payroll Refund"]
[null,null,null,"CSTLOAN","S/T Loan Domestic Financing"]
[null,null,null,"CTAXOM","Taxes on Movements"]
[null,null,null,"CTIMDEP","Time Deposit  Expired"]
[null,null,null,"CVOUCH1","Voucher 1 Receipts"]
[null,null,null,"CVOUCH10","Voucher 10 Receipts"]
[null,null,null,"CVOUCH11","Voucher 11 Receipts"]
[null,null,null,"CVOUCH12","Voucher 12 Receipts"]
[null,null,null,"CVOUCH13","Voucher 13 Receipts"]
[null,null,null,"CVOUCH2","Voucher 2 Receipts"]
[null,null,null,"CVOUCH3","Voucher 3 Receipts"]
[null,null,null,"CVOUCH4","Voucher 4 Receipts"]
[null,null,null,"CVOUCH5","Voucher 5 Receipts"]
[null,null,null,"CVOUCH6","Voucher 6 Receipts"]
[null,null,null,"CVOUCH7","Voucher 7 Receipts"]
[null,null,null,"CVOUCH8","Voucher 8 Receipts"]
[null,null,null,"CVOUCH9","Voucher 9 Receipts"]
[null,null,null,"CWHTOM","Witholding Tax on Movements"]
[null,null,null,"CXSPOT","FX Spot Currency Sale"]
[null,null,null,"CZBA","Zba Automatic Cash Pooling"]
[null,null,null,"CZBASAP","SAP Movements ZBA"]
[null,null,null,"DBBTRF","Urgent Bank to Bank Transfer"]
[null,null,null,"DBKARRLE","Bank Fees Arranging Loan Expenses"]
[null,null,null,"DBKCOM01","Bank Commission Taxes Excluded"]
[null,null,null,"DBKCOM02","Bank Commission Taxes included"]
[null,null,null,"DBKCOM03","Bank Commission not submitted to Taxes"]
[null,null,null,"DBKCOM4","Taxes on Commission"]
[null,null,null,"DBKCOMFO","Commission for Foreign Transaction"]
[null,null,null,"DBKFEE","Bank Fees Paid"]
[null,null,null,"DBKGRCOM","Bank Commission on Guarantees"]
[null,null,null,"DBKTAX","Tax on Bank Transactions Paid"]
[null,null,null,"DCASH","Cash Out"]
[null,null,null,"DCCADJ","Credit Card Adjustment"]
[null,null,null,"DCCCO","Credit Card Commission"]
[null,null,null,"DCDRCRE","Cancellation of Direct Credit"]
[null,null,null,"DCHECKD","Domestic Check Payment"]
[null,null,null,"DCHECKF","Foreign Check Payment"]
[null,null,null,"DCONFI","Confirming Payments"]
[null,null,null,"DDBTB","Domestic Bank to Bank"]
[null,null,null,"DDCC","DCC Repaid"]
[null,null,null,"DDOIBB","Domestic Intercompany Financial Payments"]
[null,null,null,"DDOMTR","Domestic Transfer Payment"]
[null,null,null,"DDRDEB","Direct Debit"]
[null,null,null,"DFACTO","Factoring"]
[null,null,null,"DFBTB","Foreign Bank to Bank"]
[null,null,null,"DFOIBB","Foreign Intercompany Financial Payments"]
[null,null,null,"DFORTR","Foreign Transfer Payment"]
[null,null,null,"DFRCST","Automated Forecast Payments"]
[null,null,null,"DFXFW","Fx Forward Purchase"]
[null,null,null,"DICT","Intercompany Debit Transfer (AP)"]
[null,null,null,"DIICLO","Disbursment Interest Interco Credit/Loan"]
[null,null,null,"DILOALT","Disbursment Interest Loan Long Term (Debt)"]
[null,null,null,"DILOST","Interest Loan Short Terms"]
[null,null,null,"DILTLO","Intragroup Maturity Long Term Credit/Loan"]
[null,null,null,"DINHBANK","SAP Movements In House Bank"]
[null,null,null,"DINTBANK","Interest on Bank account Payment"]
[null,null,null,"DINVEST","Financial Investment Security buy"]
[null,null,null,"DLTLOAN","L/T Loan Repayment"]
[null,null,null,"DLTSTP","L/T Loan S/T Part Repayment"]
[null,null,null,"DMISC","Miscellaneous Disbursement"]
[null,null,null,"DPAGAR","Pagares Payment"]
[null,null,null,"DPAYROLL","Payroll Payment"]
[null,null,null,"DRETRF","Bank Transfer Rejected"]
[null,null,null,"DSTLOAN","S/T Loan Repayment"]
[null,null,null,"DTAXOM","Taxes on Movements"]
[null,null,null,"DTAXPAY","Tax payments"]
[null,null,null,"DTIMDEP","Investment on Time Deposit"]
[null,null,null,"DUNCHK","Check Unpaid"]
[null,null,null,"DURPTRF","Urgent Payment Transfer"]
[null,null,null,"DWHTOM","Witholding Tax on Movements"]
[null,null,null,"DXSPOT","Fx Spot Currency Purchase"]
[null,null,null,"DZBA","Zba automatic Cash Pooling"]
[null,null,null,"DZBASAP","SAP Movements ZBA"]
[null,null,null,"PHISLOAN","Disbursments Historical LOAN"]