{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Variances"],"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":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,0,4,7],[19,0,19,2],[21,0,21,2],[0,0,0,10],[27,0,27,2],[29,0,29,2],[31,0,31,2],[10,0,10,2],[12,0,12,2],[14,0,14,2],[17,0,17,2]],"flags":["formulas_cached_only"]}
["Explanation of variances – pro forma "]
["Name of smaller authority: "]
["Upton Snodsbury Parish Council"]
["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• New from 2020/21 onwards: variances of £100,000 or more require explanation regardless of the % variation year on year;\n"]
[]
[]
[null,null,null,"2023/24",null,"2024/25","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,26469,null,62358,{"$nulls":6},"Explanation of % variance from PY opening balance not required - Balance brought forward agrees"]
[]
["2 Precept or Rates and Levies",null,null,7150,null,8000,850,0.11888111888111888,0,1,0,"NO"," "]
[]
["3 Total Other Receipts",null,null,39380,null,57770,18390,0.4669883189436262,0,1,1,"YES"," ","£50,000.00 received from Wychavon District Council as first 1/2 of a Community Legacy Grant payment (application for funding approved in 2023 for village hall & parish car park legacy project.)"]
[{"$nulls":13},"£3,242.00 received from West Merica Police Safer Roads Fund to purchase additional VAS equipment"]
[]
["4 Staff Costs",null,null,3865,null,4051,186,0.048124191461836996,0,0,0,"NO"," "]
[]
["5 Loan Interest/Capital Repayment",null,null,0,null,0,0,0,0,0,0,"NO"," "]
[]
["6 All Other Payments",null,null,6776,null,53482,46706,6.892857142857143,0,1,1,"YES"," ","New VAS equipment purchased @ £4,410.00"]
[{"$nulls":13},"Legacy Project expenditure @ £37,651.00 : New heaters & installation/safety checks, 50% deposit payment for solar panel scheme, 25% deposit for car park construction works, deposit payment for car park resurfacing works."]
[{"$nulls":13},"Purchase of new play area balance equipment @ £1,121.00"]
[{"$nulls":13},"Payment for planning appeal report @ £1,920.00"]
["7 Balances Carried Forward",null,null,62358,null,70595,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["8 Total Cash and Short Term Investments",null,null,62358,null,70595,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["9 Total Fixed Assets plus Other Long Term Investments and Assets",null,null,39772,null,45064,5292,0.13305843306849038,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)"]