{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Income","Expenditure","Balance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Income","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,6,37,7],[37,8,37,9],[38,6,38,7],[38,8,38,9],[35,6,35,7],[35,8,35,9],[36,6,36,7],[36,8,36,9],[32,0,32,1],[10,10,11,10],[10,11,11,11],[10,4,10,9],[10,2,11,2],[10,3,11,3],[10,0,11,1],[32,2,33,11],[0,0,0,11],[6,0,6,1],[8,0,9,1],[30,0,30,1],[5,0,5,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[2,2,2,11],[4,2,4,11],[6,2,6,4],[6,9,6,11],[6,6,6,8]]}
["Financial Report"]
[]
["Project number/project title: ",null,"E-UKR-2016-0225  Prevention of HIV and Support of Psychosocial Health in Ukraine - Community-based work with the Stepping Stone program \"15\" "]
[]
["Project partner:",null,"CWBF"]
[]
["Project period:",null,"01.09.2016-31.08.2019",null,null,null,"Reporting period:"]
[]
["I. INCOME/Receipts"]
[]
["Income sources",null,"Total planned income\nin Euro","Total planned income in national currency","Income in national currency",null,null,null,null,null,"Total income\n1st - 6th reporting period","Deviation from the plan (%) based on national currency"]
[null,null,null,null,"1st reporting period","2nd reporting period","3rd reporting period","4th reporting period","5th reporting period","6th reporting period"]
["1.0","Non-Bread for the World - Protestant Development Service funds"]
["1.1","Funds balance from previous project"]
["1.2","Project partner´s own means",null,null,null,null,null,null,null,null,{"$f":"SUM(E15:J15)","v":0},{"$f":"IFERROR(-(100-(K15*100)/D15),0)","v":0}]
["1.3","Domestic funds raised by project partner",null,null,null,null,null,null,null,null,{"$f":"SUM(E16:J16)","v":0},{"$f":"IFERROR(-(100-(K16*100)/D16),0)","v":0}]
["1.4","Foreign funds raised by project partner\n(except 1.6)",null,null,null,null,null,null,null,null,0,0]
["1.5","Project partner´s funds raised by the European Union",null,null,null,null,null,null,null,null,0,0]
["1.6","Other German public funds raised by project partner",null,null,null,null,null,null,null,null,0,0]
["1.7","Interest and exchange gains from non Bread for the World - Protestant Development Service funds",null,null,null,null,null,null,null,null,0,0]
[null,"Total amount source 1.0",{"$f":"SUM(C15:C20)","v":0},{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},0,0,{"$f":"SUM(I15:I20)","v":0},{"$f":"SUM(J15:J20)","v":0},{"$f":"SUM(K14:K20)","v":0},{"$f":"IFERROR(-(100-(K21*100)/D21),0)","v":0}]
["2.0","Funds provided from Bread for the World - Protestant Development Service"]
["2.1","Bank transfers:"]
[null,"Bank transfer"]
[null,"Bank transfer"]
[null,"Bank transfer"]
[null,"Total amount source 2.1",null,null,{"$f":"SUM(E24:E26)","v":0},0,{"$f":"SUM(G24:G26)","v":0},{"$f":"SUM(H24:H26)","v":0},0,0,{"$f":"SUM(E27:J27)","v":0}]
["2.2","Interest",null," ",null,null,null,null,null,null,{"$f":"SUM(E28:J28)","v":0}]
["2.3","Exchange gains",null,null,null,null,null,null,null,null,{"$f":"SUM(E29:J29)","v":0}]
[null,"Total amount source 2.0",{"$f":"C22","v":0},{"$f":"D22","v":0},{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":0},{"$f":"SUM(H27:H29)","v":0},{"$f":"SUM(I27:I29)","v":0},0,{"$f":"SUM(K27:K29)","v":0},{"$f":"IFERROR(-(100-(K30*100)/D30),0)","v":0}]
["Total income",null,{"$f":"C21+C30","v":0},{"$f":"D21+D30","v":0},{"$f":"E30+E21","v":0},0,0,{"$f":"H30+H21","v":0},0,0,{"$f":"K21+K30","v":0},{"$f":"IFERROR(-(100-(K31*100)/D31),0)","v":0}]
[null," "]
["Remarks (if necessary):"]
[null," "]
[]
["Debit notes (considered as income in the project account of Bread for the World - Protestant ",null,null,null,null,null,"Debit note n°.",null,"Amount in nat. currency"]
["Development Service)."]
["Debit notes are also considered as expenditure (see page 2).",null,null,null,null,null,null,null,null,null," "]

{"sheet":"Expenditure","index":1,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,11],[42,0,43,4],[42,8,42,10],[42,5,42,7],[43,5,43,7],[44,5,44,7],[45,5,45,7],[43,8,43,10],[44,8,44,10],[45,8,45,10],[39,2,40,11],[8,0,8,1],[37,0,37,1],[39,0,39,1],[4,0,5,1],[6,11,7,11],[6,2,7,2],[6,3,7,3],[6,4,6,9],[0,2,0,11],[2,2,2,5],[6,0,7,1],[6,10,7,10],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["Project number/project title: ",null,"E-UKR-2016-0225  Prevention of HIV and Support of Psychosocial Health in Ukraine - Community-based work with the Stepping Stone program \"15\" "]
[null,null,null,null,null,null," "]
["Reporting period:"]
[]
["II. EXPENDITURE/Payments",null,null,null,null,null,null,null,null,null,null," "]
[]
["Expenditure items",null,"Total planned expenditure\nin Euro","Total planned expenditure\nin national currency","Expenditure in national currency",null,null,null,null,null,"Total expenditure\n1st - 6th reporting period","Deviation from the plan (%) based on national currency"]
[null,null,null,null,"1st reporting period","2nd reporting period","3rd reporting period","4th reporting period","5th reporting period","6th reporting period"]
["Respective reporting period:",null,null,null,"01.09.2016-28.02.2017","01.03.2017-31.08.2017","01.09.2017-28.02.2018","01.03.2018-31.08.2018","01.09.2018-28.02.2019","01.03.2019-31.08.2019"]
["1.0","Project activities",{"$f":"SUM(C11:C15)","v":0},0,0,0,{"$f":"SUM(G11:G15)","v":0},0,0,0,{"$f":"SUM(E10:J10)","v":0},{"$f":"IFERROR(-(100-(K10*100)/D10),0)","v":0}]
["1.1","Development project materials"]
["1.2","Selecting and training teams of trainers"]
["1.3"," Building up supporting invironment"]
["1.4","Promoting Programme \"15\""]
["1.5","Cycles in 8 cites"]
["2.0","Personnel",{"$f":"SUM(C17:C21)","v":0},{"$f":"SUM(D17:D21)","v":0},{"$f":"SUM(E17:E21)","v":0},{"$f":"SUM(F17:F21)","v":0},{"$f":"SUM(G17:G21)","v":0},{"$f":"SUM(H17:H21)","v":0},0,0,{"$f":"SUM(E16:J16)","v":0},{"$f":"IFERROR(-(100-(K16*100)/D16),0)","v":0}]
["2.1","Project coordinator (including tax)"]
["2.2","Project assistant (including tax)"]
["2.3","Economist (including tax)"]
["2.4","Director (including tax)(proportionate)"]
["2.5","Accountant (including tax)(proportionate)"]
["3.0","Administration",{"$f":"SUM(C23:C25)","v":0},{"$f":"SUM(D23:D25)","v":0},{"$f":"SUM(E23:E25)","v":0},{"$f":"SUM(F23:F25)","v":0},{"$f":"SUM(G23:G25)","v":0},{"$f":"SUM(H23:H25)","v":0},0,0,{"$f":"SUM(E22:J22)","v":0},{"$f":"IFERROR(-(100-(K22*100)/D22),0)","v":0}]
["3.1.","Office  running costs"]
["3.2","Audit"]
["3.3","Bank fee"]
["4.0","Procurement",{"$f":"SUM(C27:C27)","v":0},0,{"$f":"SUM(E27:E27)","v":0},{"$f":"SUM(F27:F27)","v":0},0,0,0,0,{"$f":"SUM(E26:J26)","v":0},{"$f":"IFERROR(-(100-(K26*100)/D26),0)","v":0}]
["4.1","Equipment"]
["5.0","Construction",{"$f":"SUM(C29:C33)","v":0},{"$f":"SUM(D29:D33)","v":0},0,0,0,0,0,0,{"$f":"SUM(E28:J28)","v":0},{"$f":"IFERROR(-(100-(K28*100)/D28),0)","v":0}]
["5.1","Value of site"]
["5.2","Construction works"]
["5.3","Site works"]
["5.4","Equipment"]
["5.5","Professional fees"]
["6.0","Evaluations",{"$f":"SUM(C35:C35)","v":0},0,0,0,{"$f":"SUM(G35:G35)","v":0},0,0,0,{"$f":"SUM(E34:J34)","v":0},{"$f":"IFERROR(-(100-(K34*100)/D34),0)","v":0}]
["6.1","Project monitoring and evaluation "]
[null,"Subtotal ",{"$f":"SUM(C10+C16+C22+C26+C28+C34)","v":0},0,0,{"$f":"SUM(F10+F16+F22+F26+F28+F34)","v":0},{"$f":"SUM(G10+G16+G22+G26+G28+G34)","v":0},0,0,0,{"$f":"K10+K16+K22+K26+K28+K34","v":0},{"$f":"IFERROR(-(100-(K36*100)/D36),0)","v":0}]
["7.0","Reserve*",null,null,null,null,null,null,null,null,{"$f":"SUM(E37:J37)","v":0},{"$f":"IFERROR(-(100-(K37*100)/D37),0)","v":0}]
["Total expenditure",null,{"$f":"SUM(C36+C37)","v":0},{"$f":"SUM(D36+D37)","v":0},{"$f":"SUM(E10+E16+E22+E26+E28+E34+E37)","v":0},0,{"$f":"SUM(G10+G16+G22+G26+G28+G34+G37)","v":0},0,0,0,{"$f":"K36+K37","v":0},{"$f":"IFERROR(-(100-(K38*100)/D38),0)","v":0}]
[]
["Remarks (if necessary):"]
[null," "]
[]
["Debit notes (considered as expenditure in the project account of Bread for the World - Protestant Development Service). ",null,null,null,null,"Debit note n°.",null,null,"Amount in national currency"]
[]
[]
[null,null,null," "]
[]
[]
["* If expenditure is booked under the item \"7. Reserve\", the auditor describes in an explanatory note the nature of expenditure and confirms the consent of Bread for the World. "]

{"sheet":"Balance","index":2,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[48,5,48,10],[36,4,36,6],[36,7,36,9],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[32,7,32,9],[33,7,33,9],[34,7,34,9],[35,7,35,9],[42,2,44,10],[32,0,36,3],[0,0,0,1],[8,0,8,4],[8,6,8,8],[6,6,6,8],[4,0,4,3],[0,2,0,10],[3,0,3,1],[1,0,1,1],[2,0,2,1],[2,2,2,5],[24,0,24,2],[11,6,11,8],[12,1,12,4],[14,6,14,8],[15,1,15,4],[49,5,49,10],[11,0,11,3],[14,0,14,3],[17,0,17,3],[49,0,49,2],[48,0,48,2],[42,0,42,1],[38,0,39,10],[26,6,26,8],[29,0,29,3],[29,6,29,8],[17,6,17,8],[20,0,20,2],[22,6,22,8],[24,6,24,8],[22,0,22,2]]}
["Project number/project title:  ",null,"E-UKR-2016-0225  Prevention of HIV and Support of Psychosocial Health in Ukraine - Community-based work with the Stepping Stone program \"15\" "]
[null,null,null,null,null,null," "]
["Reporting period:",null,"01.03.2018-31.08.2018"]
[]
["III. Balance of the project funds and cash status"]
[]
[null,null,null,null,null,null,"(in national currency)"]
[]
["1. Balance of the project funds at start of the reporting period:"]
[null,null,null,null," "]
[]
["2. Plus total income during the reporting period:",null,null,null,null,"+",{"$f":"Income!H31","v":0}]
[]
[]
["3. Less total expenditure during the reporting period:",null,null,null,null,"-",{"$f":"Expenditure!H38","v":0}]
[]
[]
["4. Balance of the project funds at the end of the reporting period:",null,null,null,null,null,{"$f":"G9+G12-G15","v":0},null,null,"(A)"]
[]
[]
["5. Cash status"]
[]
["Cash in hand:",null,null,null,null,null,0]
[]
["Cash at bank:"]
[]
["6. Balance of cash at the end of the reporting period:",null,null,null,null,null,{"$f":"SUM(G23+G25)","v":0},null,null,"(B)"]
[]
[]
["Reconciliation of differences between (A) and (B), if aplicable:",null,null,null,null,null,{"$f":"SUM(G18-G27)","v":0}]
[]
[]
["6. Detailed information on prepayments and debts\n(structured according to the approved expenditure items):",null,null,null,"Prepayments",null,null,"Liabilities"]
[]
[]
[]
[]
[]
["This is to confirm that the contents of this financial report are in accordance with the information and structure of the expenditure and income plan and with the cooperation agreement between project partner and Bread for the World - Protestant Development Service."]
[]
[]
[]
["Remarks (if necessary):"]
[null," "]
[]
[]
[]
[]
[]
["(Place, date)",null,null,null,null,"(Name and signature of authorised signatory)"]