{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Bank Rec","Variance","Statement"],"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":"Bank Rec","index":0,"n_rows":34,"n_cols":249,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,248,0,255],[0,0,0,3],[22,1,22,4],[0,192,0,199],[0,200,0,207],[0,208,0,215],[0,216,0,223],[0,224,0,231],[0,232,0,239],[0,152,0,159],[0,160,0,167],[0,168,0,175],[0,176,0,183],[0,184,0,191],[0,240,0,247],[0,48,0,55],[0,144,0,151],[0,56,0,63],[0,64,0,71],[0,72,0,79],[0,80,0,87],[0,88,0,95],[0,96,0,103],[0,104,0,111],[0,112,0,119],[0,120,0,127],[0,128,0,135],[0,136,0,143],[0,8,0,15],[0,16,0,23],[0,24,0,31],[0,32,0,39],[0,40,0,47]],"flags":["formulas_cached_only"]}
["Hanley Castle Parish Council",{"$nulls":143},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council",{"$nulls":7},"Hanley Castle Parish Council"]
[]
["Bank Reconciliation ",{"$nulls":143},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation ",{"$nulls":7},"Bank Reconciliation "]
[]
[null,"Bank Statements as at 31st March 2024","£"]
["A","Current Account",2403.9]
[null,"Business 30 day",50056.04]
["B","Less unpresented cheques/Payments",3534.6]
["C","Payments not cleared",2522]
["D","Petty Cash",0]
["E","Balance as at 31st March 2021",51447.340000000004]
[]
[]
[]
["B","Clerks March Salary",606.4]
[null,"HMRC PAYE",45.2]
[null,"Playing Field Repair",155]
[null,"March Lengthsman",728]
[null,"Electric Bike",2000]
[]
["C","Lengthsman's Reimbursement WCC",2072]
[null,"Pathway Clearance WCC",450]
[]
[null,"Reserves Break Down",51447.34]
[]
[null,"Speed reduction Initiatives ",8000]
[null,"Playground Refurbishment",10000]
[null,"Hanley Carbon Reduction Project",4000]
[null,"Total Ear Marked Reserves",22000]
[]
[null,"Remaining Reserves (1 year running costs)",29447.339999999997]
[]
[null," *Unplanned and received at the end of the Financial Year"]
[null," - Projects being planned as 5 years to spend Cycle Path Improvement most likely "]

{"sheet":"Variance","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Hanley Castle Parish Council Explanations of Significant Variances 2023-2024"]
[]
["Box No 3 Total Receipts","£",null,"Box No 4 Staff Costs","£",null,"Box No 6  All other Payments","£",null,"Box No 9 Fixed Assets","£"]
["Figure in 2023 Column",11719,null,"Figure in 2023 Column",5834,null,"Figure in 2023 Column",37262,null,"Figure in 2023 Column",39300]
["Figure in 2024 Column",4262,null,"Figure in 2024 Column",6795,null,"Figure in 2024 Column",31662,null,"Figure in 2024 Column",48556]
["Variance",-7457,null,"Variance",961,null,"Variance",-5600,null,null,9256]
[]
["Reasons","Amount £",null,"Reasons","Amount £",null,"Reasons","Amount £",null,"Reasons","Amount £"]
["No Duck House Donations",-7845,null,"Pay rise and additional hours",961,null,"Last Year's Duck House Expenditure",-5600,null,"2 x VAS",4400]
["received this year",{"$nulls":8},"Electric Bike",2000]
[{"$nulls":9},"Benches",2000]
[{"$nulls":9},"projector & Laptop",856]
["Unexplained",388,null,"Unexplained",0,null,"Unexplained",0,null,"Unexplained",0]
["Unexplained %",0.033108627015956994,null,"Unexplained %",0,null,"Unexplained %",0,null,"Unexplained %",0]

{"sheet":"Statement","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,3,1,4],[0,0,0,5]],"flags":["formulas_cached_only"]}
["Accounting Statements for Hanley Castle Parish Council"]
[null,null,null,"Year ending "]
[null,null,null,"31 March 2023      £","31 March 2024        £","Varience £"," + 15% explanation"]
[1,"Balances brought forward",null,72928,63551,-9377,-12.857887231241772]
[2,"(+) Annual Precept",null,22000,22000,0,0]
[3,"(+) Total other Receipts",null,11719,4262,-7457,-63.63170919020394]
[4,"(-) Staff costs",null,5834,6795,961,16.472403153925267]
[5,"(-) Loan interest/capital repayments",null,"NIL","NIL"]
[6,"(-) All other payments",null,37262,31662,-5600,-15.02871558155762]
[7,"(=) Balances carried forward",null,63551,51447,-12104,-19.046120438702772]
[]
[8,"Total cash and short term investments",null,63551,51447,-12104,-19.046120438702772]
[9,"Total fixed assets and long term assets",null,39300,48556,9256,23.552162849872772]
[10,"Total borrowings",null,"NIL","NIL"]
[11,"Trust funds (including charitable) disclosure note",null,"No","No"]