{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Invoice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Invoice","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,5,0,9],[1,0,5,3],[1,4,6,4],[1,5,1,7],[2,5,2,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[30,8,30,9],[21,0,21,3],[17,5,17,9],[6,1,6,3],[7,0,7,9],[8,0,9,4],[8,5,8,9],[9,5,9,9],[10,0,15,3],[10,5,10,7],[11,5,11,7],[16,5,16,9],[6,5,6,7],[6,8,6,9],[12,5,12,7],[15,5,15,9],[25,0,25,9],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,6,26,7],[21,5,21,9],[22,5,22,9],[24,5,24,9],[23,5,23,9],[19,0,19,1],[19,2,19,3],[32,2,32,4],[27,2,27,3],[27,6,27,7],[28,0,28,5],[28,6,28,7],[29,6,29,7],[31,0,31,1],[31,2,31,4],[30,5,30,7],[30,0,30,1],[30,2,30,3],[27,4,27,5],[29,4,29,5],[29,0,29,3],[43,0,43,2],[43,3,43,4],[41,0,41,1],[40,3,40,4],[33,2,33,4],[33,0,33,1],[37,0,37,1],[35,0,35,1],[36,0,36,1],[51,0,56,5],[49,0,49,3],[34,0,34,1],[35,3,35,4],[37,3,37,4],[34,3,34,4],[41,3,41,4],[36,3,36,4],[42,3,42,4],[40,0,40,1],[38,0,38,1],[42,0,42,1],[39,3,39,4],[38,3,38,4],[39,0,39,1],[46,0,46,3]]}
["Contractor (Please take the adress from your contract)",null,null,null,null,"Bank details"]
[null,null,null,null,null,"Name of bank",null,null,"Please enter your "]
[null,null,null,null,null,"Account no.:",null,null,"bank data here"]
[null,null,null,null,null,"Bank Code:"]
[null,null,null,null,null,"IBAN:"]
[null,null,null,null,null,"BIC /Swift-Code for foreign):"]
["E-Mail:",null,null,null,null,"Tax/VAT ID No.:"]
[]
[null,null,null,null,null,"For GIZ use only"]
[]
["Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 36\n53113 Bonn\nGermany",null,null,null,null,"VR",null,null,null,"1 1"]
[null,null,null,null,null,"LR",null,null,null,"1 1"]
[null,null,null,null,null,"KR   4 7"]
[]
[]
[null,null,null,null,null,"Eingang OE 5230"]
[null,"Please select here"]
[null,"Interim Invoice",null,null,null,"Basis"]
[null,"Final Invoice",null,null,null,"Kto.",null,"Kst."]
["Sequential invoice no."]
[null,null,null,null,null,null,null,"Gesamt"]
["Please choose between interim and final invoice",null,null,null,null,"Leistungsbestätigung"]
[null,null,null,null,null,"OE                 Datum                  Name"]
["Please select here",null,null,null,null,"Sachl. rechn. richtig   (Freigabe)"]
[null,null,null,null,null,"OE                 Datum                  Name"]
[]
["Contract number",null,"Project number / Cost Centre",null,null,null,"Accounting period",null,null,"Date of invoice"]
[]
["Brief project title",null,null,null,null,null,"Country",null,null,"Place of performance"]
[]
[null,null,"Currency",null,"……","For GIZ use only",null,null,"Rechnung vollst. am:"]
["Amount of the current total costs according to the auditor's report"]
["Of which public contribution in the amount of (%)",null,{"$f":"C32*B33","v":0}]
["Already proven costs from previous audit report(s) (GIZ share only)"]
["Costs still to be settled",null,"excl. VAT",{"$f":"C33-C34","v":0}]
["+ VAT (%)",null,null,{"$f":"D35*C36","v":0}]
["Invoice amount",null,"incl. VAT",{"$f":"D35+D36","v":0}]
["Payments already received",null,"excl. VAT"]
["+ VAT (%)",null,null,{"$f":"D38*C39","v":0}]
["Invoice amount",null,"incl. VAT",{"$f":"D38+D39","v":0}]
[{"$f":"IF(A24=\"Interim Invoice\",\"Deduction in the amount of the costs incurred (line 35)\",IF(A24=\"Final Invoice\",\"Deduction of the outstanding advance payments\",\"Please select above\"))","v":"Please select above"},null,"excl. VAT",{"$f":"IF(A24=\"Final Invoice\",D38-C34,IF(A24=B17,\"Please select above\",IF(A24=\"Interim Invoice\",D35,\"\")))","v":"Please select above"}]
["+ VAT (%)",null,null,{"$f":"D41*C42","v":{"$error":"#VALUE!"}}]
["Invoice amount",null,"incl. VAT",{"$f":"D41+D42","v":{"$error":"#VALUE!"}}]
["PAYMENT AMOUNT",null,null,{"$f":"D37-D43","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["Signature"]
[]
["I hereby confirm that all the information provided is truthful and declare that the expenditures and costs billed to the Client have neither been or will be settled with not billed to any third party. "]
[]
["* Please note that there will be no payment/ repayment in the case of partial invoices. Accordingly, the deduction of the advance payment is made in the amount of the costs now invoiced. This settlement is purely for cost posting in the GIZ system. Payments are only made via \"advance payment requests\". \nThe exception is the final invoice. Here, a final payment/ repayment can be made after reconciliation of all costs and payments.\n"]