{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Statement","Bank Rec","Variance"],"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":"Statement","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"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 2022      £","31 March 2023           £","Varience £"," + 15% explanation"]
[1,"Balances brought forward",null,69618,72928,3310,4.75451750983941]
[2,"(+) Annual Precept",null,22000,22000,0,0]
[3,"(+) Total other Receipts",null,1193,11719,10526,882.3134953897737]
[4,"(-) Staff costs",null,4895,5834,939,19.182839632277833]
[5,"(-) Loan interest/capital repayments",null,"NIL","NIL"]
[6,"(-) All other payments",null,14988,37262,22274,148.61222311182277]
[7,"(=) Balances carried forward",null,72928,63551,-9377,-12.857887231241772]
[]
[8,"Total cash and short term investments",null,72928,63551,-9377,-12.857887231241772]
[9,"Total fixed assets and long term assets",null,25500,39300,13800,54.11764705882353]
[10,"Total borrowings",null,"NIL","NIL"]
[11,"Trust funds (including charitable) disclosure note",null,"No","No"]
[]
[]
[]
[]
[]
[3]

{"sheet":"Bank Rec","index":1,"n_rows":40,"n_cols":249,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,8,0,15],[0,16,0,23],[0,24,0,31],[0,32,0,39],[0,40,0,47],[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,248,0,255],[0,0,0,3],[27,1,27,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]],"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  - Prepared by Rebecca Abunassar Clerk & RFO",{"$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 2023","£"]
["A","Current Account",11973.8]
[null,"Business 30 day",52096.79]
["B","Less unpresented cheques/Payments",969.78]
["C","Payments not cleared",450]
["D","Petty Cash",0]
["E","Balance as at 31st March 2023",63550.81]
[]
[]
[]
["B","Chairman's Allowance",75]
[null,"Silva Timber (Duckhouse)",174.99]
[null,"Bradford Screws for Duck Houses",51.46]
[null,"March Duties",506.2]
[null,"Q3&Q4",61.33]
[null,"Boards Direct Noticeboard",100.8]
[null,null,969.78]
[]
["C","Pathways Clearance Payment",450]
[]
[]
[]
[]
[]
[null,"Reserves Break Down",63550.81]
[]
[null,"CIL Payment*",16900]
[null,"Play field ground works",5000]
[null,"Speed reduction Initiatives ",12000]
[null,"Hanley Carbon Reduction Project",7000]
[null,"Total Ear Marked Reserves",40900]
[]
[null,"Remaining Reserves (1 year running costs)",22650.809999999998]
[]
[]
[null," *Projects being planned as 5 years to spend Cycle Path Improvement most likely "]

{"sheet":"Variance","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Hanley Castle Parish Council Explanations of Significant Variances 2022-2023"]
[{"$nulls":8},"Figure in 2022 Column"]
["Box No 3 Total Receipts","£",null,"Box No 4 Staff Costs","£",null,"Box No 6  All other Payments","£","Figure in 2023 Column","Box No 9 Fixed Assets","£"]
["Figure in 2022 Column",1193,null,"Figure in 2022 Column",4895,null,"Figure in 2022 Column",14988,null,"Figure in 2022 Column",25500]
["Figure in 2023 Column",11719,null,"Figure in 2023 Column",5834,null,"Figure in 2023 Column",37262,null,"Figure in 2023 Column",39300]
["Variance",10526,null,"Variance",939,null,"Variance",22274,null,null,13800]
[]
["Reasons","Amount £",null,"Reasons","Amount £",null,"Reasons","Amount £",null,"Reasons","Amount £"]
["Duck House Donantions",7900,null,"Additional Hours & Payrise",939,null,"Pond Works & Duck Houses",10600,null,"VAS & Road Safety",4120]
["Legal payment",890,{"$nulls":4},"Speed Reduction Project",4120,null,"Duck Houses",9680]
["Interest",100,{"$nulls":4},"Tree safety works",3500]
["County & District Donations",1600,{"$nulls":4},"Jubilee ",700]
["Unexplained",36,null,"Unexplained",0,null,"Laptop",795,null,"Unexplained",0]
["Unexplained %",0.030176026823134954,null,"Unexplained %",0,null,"Donation for Parish Church Grass Cutting",2400,null,"Unexplained %",0]
[{"$nulls":6},"Unexplained",159]
[{"$nulls":6},"Unexplained %",0.010608486789431545]