{"text_format":"5","workbook":"xls","n_sheets":3,"sheets":["Community Account","Business Money Manager Account","Lloyds Bank"],"props":{"creator":"Wolverley","last_modified_by":"Beverley Drew"},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Community Account","index":0,"n_rows":111,"n_cols":5,"rows_kept":111,"flags":["formulas_cached_only"]}
["BANK RECONCILIATION - BROOME PARISH COUNCIL 2022/2023"]
["HSBC COMMUNITY ACCOUNT: 90186481"]
[]
["APRIL"]
[{"$nulls":4},"£"]
["Balance Brought Forward",{"$nulls":3},14172.29]
["Receipts"]
["2022-03-29",null,"WCC Lengthsman",{"v":45,"d":"45.00"}]
["2022-04-05",null,"WCC Lengthsman",{"v":30,"d":"30.00"}]
[null,"Chq. No."]
["Payments"]
["2022-04-01",100511,"Mr W Waldron - Lengthsman Feb",{"v":30,"d":"30.00"}]
["2022-04-07",100513,"Mrs B J Drew - Expenses",81.95]
["2022-04-07",100512,"Print Serve",{"v":25,"d":"25.00"}]
["2022-04-12",100516,"Transfer to Lloyds",{"v":2000,"d":"2000.00"}]
["2022-04-19",100515,"Mr W Waldron - Lengthsman March",{"v":120,"d":"120.00"}]
["2022-04-19",100514,"Mr W Waldron - Litter",{"v":360.1,"d":"360.10"}]
["2022-04-18","DR","Bank Charges",{"v":5.4,"d":"5.40"}]
[]
["Closing Balance",{"$nulls":3},11624.84]
[]
["MAY"]
[]
["Receipts"]
["2022-05-09",null,"WCC Lengthsman",{"v":120,"d":"120.00"}]
["2022-05-20",null,"WCC Lengthsman",{"v":90,"d":"90.00"}]
[]
["Payments"]
["2022-05-19","DR","Bank Charges",{"v":7.4,"d":"7.40"}]
[]
[]
["Closing Balance",{"$nulls":3},11827.44]
[]
["JUNE"]
["Receipts"]
[]
["Payments"]
["2022-06-18","DR","Bank Charges",{"v":5,"d":"5.00"}]
[]
["Closing Balance",{"$nulls":3},11822.44]
[]
["JULY"]
["Receipts"]
["2022-07-01",null,"WCC Lengthsman",{"v":30,"d":"30.00"}]
[]
["Payments"]
["2022-07-19","DR","Bank Charges",{"v":5,"d":"5.00"}]
[]
["Closing Balance",{"$nulls":3},11847.44]
[]
[]
["AUGUST"]
["Receipts"]
["2022-08-05",null,"WCC Lengthsman",{"v":105,"d":"105.00"}]
[]
["Payments"]
["2022-08-08","DR","Bank Charges",{"v":5,"d":"5.00"}]
[]
["Closing Balance",{"$nulls":3},11947.44]
[]
["SEPTEMBER"]
["Receipts"]
["2022-09-13",null,"WCC Lengthsman",{"v":88,"d":"88.00"}]
[]
["Payments"]
["2022-09-18","DR","Bank Charges",{"v":5,"d":"5.00"}]
[]
["Closing Balance",{"$nulls":3},12030.44]
[]
["OCTOBER"]
["Payments"]
["2022-10-19","DR","Bank Charges",{"v":5,"d":"5.00"}]
[]
["Closing Balance",{"$nulls":3},12025.44]
[]
["NOVEMBER"]
["Receipts"]
["2022-11-23",100517,"Unpaid Cheque",{"v":5000,"d":"5000.00"}]
[]
["Payments"]
["2022-11-23","DR","Bank Charges",{"v":5,"d":"5.00"}]
["2022-11-23",100517,"Lloyds Bank",{"v":5000,"d":"5000.00"}]
[]
["Closing Balance",{"$nulls":3},12020.44]
[]
["DECEMBER"]
["Payments"]
["2022-12-09",100518,"Lloyds Bank",{"v":5000,"d":"5000.00"}]
["2022-12-19","DR","Bank Charges",{"v":5.4,"d":"5.40"}]
[]
["Closing Balance",{"$nulls":3},7015.04]
[]
["JANUARY"]
["Payments"]
["2023-01-18","DR","Bank Charges",{"v":5.4,"d":"5.40"}]
[]
["Closing Balance",{"$nulls":3},7009.64]
[]
["FEBRUARY"]
["Payments"]
["2023-02-03",100519,"Lloyds Bank",{"v":6800,"d":"6800.00"}]
["2023-02-18","DR","Bank Charges",{"v":5,"d":"5.00"}]
["2023-02-24","DD","ICO",{"v":35,"d":"35.00"}]
[]
["Closing Balance",{"$nulls":3},169.64]
[]
["MARCH"]
["Payments"]
["2023-03-21","DR","Bank Charges",{"v":5.4,"d":"5.40"}]
[]
["Closing Balance",{"$nulls":3},164.24]

{"sheet":"Business Money Manager Account","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"flags":["formulas_cached_only"]}
["BANK RECONCILIATION - BROOME PARISH COUNCIL 2022/2023"]
["HSBC BUSINESS MONEY MANAGER ACCOUNT: 71736213"]
[]
["APRIL"]
[]
["Balance Brought Forward",{"$nulls":4},954.14]
[]
["2022-04-28",null,"Interest",0.04,null,954.18]
["2022-05-28",null,"Interest",0.04,null,954.22]
["2022-06-28",null,"Interest",0.04,null,954.26]
["2022-07-28",null,"Interest",0.06,null,954.32]
["2022-08-28",null,"Interest",0.12,null,954.44]
["2022-09-28",null,"Interest",0.23,null,954.67]
["2022-10-28",null,"Interest",0.29,null,954.96]
["2022-11-28",null,"Interest",0.45,null,955.41]
["2022-12-28",null,"Interest",{"v":0.6,"d":"0.60"},null,956.01]
["2023-01-28",null,"Interest",0.75,null,956.76]
["2023-02-28",null,"Interest",0.85,null,957.61]
["2023-03-28",null,"Interest",0.91,null,958.52]
[]
["Closing Balance",{"$nulls":4},958.52]

{"sheet":"Lloyds Bank","index":2,"n_rows":133,"n_cols":6,"rows_kept":133,"flags":["formulas_cached_only"]}
["BANK RECONCILIATION - BROOME PARISH COUNCIL 2022/2023"]
["LLOYDS BANK TREASURERS ACCOUNT: 79300260"]
[]
["APRIL"]
[{"$nulls":5},"£"]
["Balance Brought Forward",{"$nulls":4},{"v":0,"d":"0.00"}]
["Receipts"]
["2022-04-01","FPI","Don Billington",null,{"v":10,"d":"10.00"}]
["2022-04-11","DEP","Transfer from HSBC",null,{"v":2000,"d":"2,000.00"}]
["2022-04-29","BGC","WFDC 1st Precept",null,{"v":3000,"d":"3,000.00"}]
["2022-04-29","FPI","Don Billington",null,{"v":10,"d":"10.00"}]
[]
["Payments"]
["2022-04-04","FPO","Repay Don Billington",null,{"v":5,"d":"5.00"}]
["2022-04-29","FPO","Repay Don Billington",null,{"v":5,"d":"5.00"}]
["2022-04-29","FPO","Repay Don Billington",null,{"v":5,"d":"5.00"}]
["2022-04-29","FPO","Repay Don Billington",null,{"v":5,"d":"5.00"}]
[]
["Closing Balance",{"$nulls":4},{"v":5000,"d":"5000.00"}]
[]
["MAY"]
["Receipts"]
["2022-05-09","BGC","WFDC Litter Picking",null,{"v":371,"d":"371.00"}]
[]
["Payments"]
["2022-05-05","FPO","BHIB Insurance",null,261.79]
["2022-05-05","FPO","DM Payroll Services",null,{"v":60,"d":"60.00"}]
["2022-05-05","FPO","Mr W Waldron - Lengthsman",null,{"v":90,"d":"90.00"}]
["2022-05-05","FPO","Worcestershire CALC Annual Subs",null,241.71]
["2022-05-09","FPO","House of Flags - Union Jack",null,{"v":69.6,"d":"69.60"}]
["2022-05-09","FPO","Broadcast Magazine Donation",null,{"v":40,"d":"40.00"}]
[]
["Closing Balance",{"$nulls":4},{"v":4607.9,"d":"4607.90"}]
[]
["JUNE"]
["Payments"]
["2022-06-06","FPO","Mr W Waldron - Lengthsman",null,{"v":30,"d":"30.00"}]
[]
["Closing Balance",{"$nulls":4},{"v":4577.9,"d":"4577.90"}]
[]
["JULY"]
["Payments"]
["2022-07-06","FPO","Mr W Waldron - Lengthsman",null,{"v":105,"d":"105.00"}]
["2022-07-27","FPO","Broome Village Hall",null,{"v":250,"d":"250.00"}]
["2022-07-27","FPO","St Peters Church Broome",null,{"v":250,"d":"250.00"}]
[]
["Closing Balance",{"$nulls":4},{"v":3972.9,"d":"3972.90"}]
[]
["AUGUST"]
["Payments"]
["2022-08-01","FPO","Mr W Waldron ",null,{"v":88,"d":"88.00"}]
[]
["Closing Balance",{"$nulls":4},{"v":3884.9,"d":"3884.90"}]
[]
["SEPTEMBER"]
["Payments"]
["2022-09-12","FPO","Mr W Waldron",null,{"v":32,"d":"32.00"}]
["2022-09-13","FPO","Mrs B J Drew",null,{"v":73.6,"d":"73.60"}]
[]
["Receipts"]
["2022-09-30","BACS","WFDC 2nd Instalment Precept",null,{"v":3000,"d":"3,000.00"},{"v":6779.3,"d":"6779.30"}]
[]
["OCTOBER"]
["Payments"]
["2022-10-04","FPO","Mrs B J Drew (HP Laptop)",null,688.87]
["2022-10-04","FPO","Westcotec (Speed Sign)",null,{"v":4510.8,"d":"4,510.80"}]
["2022-10-12","FPO","Mr W Waldron",null,{"v":32,"d":"32.00"}]
[]
["Receipts"]
["2022-10-14","BGC","WCC",null,{"v":32,"d":"32.00"}]
["2022-10-21","BGC","WCC",null,{"v":32,"d":"32.00"}]
["2022-10-26","TFR","Compensation from Lloyds",null,{"v":100,"d":"100.00"}]
[]
["Closing Balance",{"$nulls":4},1711.63]
[]
["NOVEMBER"]
["Payments"]
["2022-11-08","FPO","Mr W Waldron - Litter",null,{"v":360.1,"d":"360.10"}]
["2022-11-08","FPO","Mr W Waldron ",null,{"v":64,"d":"64.00"}]
["2022-11-23","PAY","Unpaid Cheque",null,{"v":5000,"d":"5,000.00"}]
[]
["Receipts"]
["2022-11-07","BGC","VAT Repayment",null,129.87]
["2022-11-22","DEP","Transfer from HSBC",null,{"v":5000,"d":"5,000.00"}]
[]
["Closing Balance",{"$nulls":4},{"v":1417.4,"d":"1417.40"}]
[]
["DECEMBER"]
["Payments"]
["2022-12-06","FPO","Mr W Waldron",null,{"v":80,"d":"80.00"}]
["2022-12-16","FPO","Mrs B J Drew - Salary 22/23 plus Moffice",null,{"v":2032.76,"d":"2,032.76"},"(2006.10/26.66)"]
["2022-12-16","FPO","House of Flags",null,{"v":105,"d":"105.00"}]
["2022-12-16","FPO","Print-Serve Ltd",null,{"v":20,"d":"20.00"}]
["2022-12-23","CHQ 000001","HMRC",null,{"v":501.4,"d":"501.40"}]
[]
["Receipts"]
["2022-12-08","DEP","Transfer from HSBC",null,{"v":5000,"d":"5,000.00"}]
["2022-12-13","BGC","WCC",null,{"v":64,"d":"64.00"}]
[]
[]
["Closing Balance",{"$nulls":4},3742.24]
[]
["JANUARY"]
["Payments"]
["2023-01-09","FPO","Mr W Waldron",null,{"v":56,"d":"56.00"}]
[]
["Receipts"]
["2023-01-05","BGC","WCC",null,{"v":80,"d":"80.00"}]
[]
["Closing Balance",{"$nulls":4},3766.24]
[]
["FEBRUARY"]
["Payments"]
["2023-02-03","FPO","Broome Village Hall",null,{"v":250,"d":"250.00"}]
["2023-02-03","FPO","St Peters, Broome",null,{"v":250,"d":"250.00"}]
["2023-02-03","FPO","Mr W Waldron",null,{"v":48,"d":"48.00"}]
[]
["Receipts"]
["2023-02-02","DEP","Transfer from HSBC",null,{"v":6800,"d":"6,800.00"}]
["2023-02-15","BGC","WCC",null,{"v":56,"d":"56.00"}]
[]
["Closing Balance",{"$nulls":4},10074.24]
[]
["MARCH"]
["Payments"]
["2023-03-07","FPO","Mr W Waldron",null,{"v":32,"d":"32.00"}]
["2023-03-10","FPO","Leedan Packaging Limited",null,21.29]
["2023-03-29","FPO","Mr W Waldron",null,{"v":414.1,"d":"414.10"}]
[]
["Receipts"]
["2023-03-28","BGC","WCC",null,{"v":32,"d":"32.00"}]
[]
["Closing Balance",{"$nulls":4},9638.85]