{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Variances","Reserves"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Variances","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[29,0,29,2],[10,0,10,2],[12,0,12,2],[14,0,14,2],[16,0,16,2],[4,0,4,7],[18,0,18,2],[20,0,20,2],[0,0,0,10],[25,0,25,2],[27,0,27,2]],"flags":["formulas_cached_only"]}
["Explanation of variances – pro forma "]
["Name of smaller authority: ",null,"HONEYBOURNE PARISH COUNCIL"]
["County area (local councils and parish meetings only): ",null,"WORCESTERSHIRE"]
["Insert figures from Section 2 of the AGAR in all Blue highlighted boxes "]
["Next, please provide full explanations, including numerical values, for the following that will be flagged in the green boxes where relevant:\n• variances of more than 15% between totals for individual boxes (except variances of less than £200); \n• a breakdown of approved reserves on the next tab if the total reserves (Box 7) figure is more than twice the annual precept/rates & levies value (Box 2).\n"]
[]
[]
[null,null,null,"20xx/xx",null,"20xx/xx","Variance","Variance",null,null,null,"Explanation Required?","Automatic responses trigger below based on figures input, DO NOT OVERWRITE THESE BOXES","Explanation from smaller authority (must include narrative and supporting figures)"]
[null,null,null,"£",null,"£","£","%"]
[]
["1 Balances Brought Forward",null,null,98901,null,108442,{"$nulls":6},"Explanation of % variance from PY opening balance not required - Balance brought forward does not agree, query this"]
[]
["2 Precept or Rates and Levies",null,null,81527,null,83527,2000,0.02453175021771928,0,1,0,"NO"," "]
[]
["3 Total Other Receipts",null,null,40047,null,246515,206468,5.155642120508403,0,1,1,"YES","The council were the transfer agent for £63,780 and  a further  £150,000 NHB legacy fund paid by the District Council to fund the new Honeybourne Village Hall  this = £213,780. In 2018-19 the council received £10,000 NDP funding which was not repeated in 2019-20 making the difference £203,780"]
[]
["4 Staff Costs",null,null,15174,null,17046,1872,0.12336892052194544,0,1,0,"NO"," "]
[]
["5 Loan Interest/Capital Repayment",null,null,0,null,0,0,0,0,0,0,"NO"," "]
[]
["6 All Other Payments",null,null,96858,null,285551,188693,1.948140576927048,0,1,1,"YES","The council were the transfer agent for £63,780 and  a further  £150,000 NHB legacy fund paid by the District Council to  the parish council to fund the new Honeybourne Village Hall  this = £213,780 in 2018/19 the council's expenditure on the village hall services costs and fees was £24,674  which was not repeated in 2019-20 equating to a difference of £189,106"]
[]
["7 Balances Carried Forward",null,null,108443,null,135887,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[{"$nulls":11},"NO"," "]
[]
["8 Total Cash and Short Term Investments",null,null,108442,null,135887,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["9 Total Fixed Assets plus Other Long Term Investments and Assets",null,null,389658,null,389934,276,0.0007083134440971314,0,1,0,"NO"," "]
[]
["10 Total Borrowings",null,null,0,null,0,0,0,0,0,0,"NO"," "]
[]
[null,null,"Rounding errors of up to £2 are tolerable"]
[]
[null,null,"Variances of £200 or less are tolerable"]
[]
[null,null,"BOX 10 VARIANCE EXPLANATION NOT REQUIRED IF CHANGE CAN BE EXPLAINED BY BOX 5 (CAPITAL PLUS INTEREST PAYMENT)"]

{"sheet":"Reserves","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Explanation for ‘high’ reserves"]
["(Please complete the highlighted boxes.)"]
["Box 7 is more than twice Box 2 because the authority held the following breakdown of reserves at the year end:"]
[]
[null,null,null,"£","£","£"]
["Earmarked reserves:"]
[null,"Reserve 1"]
[null,"Reserve 2"]
[null,"Reserve 3"]
[null,"Reserve 4"]
[null,"Reserve 5"]
[null,"Reserve 6"]
[null,"Reserve 7"]
[{"$nulls":4},0]
[]
["General reserve"]
[{"$nulls":4},0]
["Total reserves (must agree to Box 7)",{"$nulls":4},0]