{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Reconciliation","Payments"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":11,"comments":7,"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":"Reconciliation","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,2,18,3],[25,2,25,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[7,4,7,5],[7,1,7,2],[6,1,6,2],[6,4,6,5]],"flags":["formulas_cached_only"]}
["Financial Year 2016-17"]
["RECONCILIATION"]
["Period  01/04/2016 - 31/03/2017"]
[]
[null,"Reconciliation for the period: "]
[]
[null,"Date",null,null,"Date"]
[null,"1st April 2016",null,"to ","31st March 2017"]
[]
[null,null,"Current a/c at end of period:",null,null,8389.75]
[null,"add","Deposit a/c at end of period: ",null,null,5000]
[null,"add","Other a/c at end of period",null,null,0]
[null,"less","cheques paid uncleared:",null,null," "]
[null,null,"Cheque No.",1062,1266.8]
[null,null,"Cheque No.",1063,700]
[null,null,"Cheque No.",1064,500]
[null,null,"Cheque No.",1051,44.47]
[null,null,"Cheque No.",1058,90]
[null,null,"TOTAL UN-PAID",null,2601.27]
[{"$nulls":5},10788.48]
[null,"add","cheques rec'd not paid in:"]
[null,null,"Payee Details",null,0]
[null,null,"Payee Details",null,0]
[null,null,"Payee Details",null,0]
[null,null,"Payee Details",null,0]
[null,null,"TOTAL UN-RECEIVED",null,0]
[]
[null,"equ","Balance C/F",null,null,10788.48]
[]
[null,"Opening Balance",null,null,null,11222.16]
[null,"Add receipts for period",null,null,null,13227.619999999999,null,0]
[null,"Less payments for period",null,null,null,-13661.299999999994]
[null,"Equ closing balance",null,null,null,10788.480000000005]
[]
[]
[null,"Chairman",null,null,"Date"]
[]
[]
[null,"RFO ",null,null,"Date"]

{"sheet":"Payments","index":1,"n_rows":74,"n_cols":25,"rows_kept":74,"cut":false,"hidden":false,"merged":[[11,4,11,5],[27,4,27,6],[25,4,25,6],[47,23,47,24],[43,23,43,24],[44,23,44,24],[45,23,45,24],[46,23,46,24],[18,23,18,24],[19,23,19,24],[0,0,0,3],[69,4,69,5],[70,4,70,5],[71,4,71,5],[6,4,6,6],[7,4,7,6],[19,4,19,6],[18,4,18,6],[20,4,20,6],[21,4,21,6],[72,4,72,5],[68,3,68,5],[1,0,1,3],[64,4,64,5],[68,0,68,2],[5,4,5,6],[14,4,14,6],[15,4,15,6],[2,0,2,3],[3,0,3,3],[4,4,4,6],[23,4,23,6],[24,4,24,6],[10,4,10,6],[12,4,12,6],[16,4,16,6],[17,4,17,6],[22,4,22,5],[9,4,9,6],[13,4,13,6],[4,9,4,18],[41,4,41,6],[36,4,36,6],[37,4,37,6],[34,4,34,6],[35,4,35,6],[28,4,28,6],[29,4,29,6],[31,4,31,6],[33,4,33,6],[4,23,4,24],[7,23,7,24],[8,23,8,24],[9,23,9,24],[5,23,5,24],[6,23,6,24],[10,23,10,24],[11,23,11,24],[16,23,16,24],[17,23,17,24],[12,23,12,24],[13,23,13,24],[14,23,14,24],[15,23,15,24],[24,23,24,24],[25,23,25,24],[27,23,27,24],[20,23,20,24],[21,23,21,24],[22,23,22,24],[23,23,23,24],[26,23,26,24],[28,23,28,24],[29,23,29,24],[31,23,31,24],[33,23,33,24],[30,23,30,24],[32,23,32,24],[38,4,38,6],[40,23,40,24],[67,4,67,5],[66,3,66,5],[42,4,42,6],[39,4,39,6],[38,23,38,24],[39,23,39,24],[41,23,41,24],[42,23,42,24],[36,23,36,24],[34,23,34,24],[35,23,35,24],[37,23,37,24]],"flags":["formulas_cached_only"]}
["Financial Year 2016-17"]
["PAYMENTS"]
["Period  01/04/2016 - 31/03/2017"]
[]
["Date","Cheque","Minute","Payee Details","Invoice Details",null,null,"Value","VAT","Payments excluding VAT",{"$nulls":9},"Status","Cleared","UnCleared","Check","Comments"]
["cheque ","Number","Ref",{"$nulls":5},"Element","Staff ","Loan","Other","Insurance","Other Grants","Subs","Lengthsman","Grass ","Maintain","Fees",null,null,null,"for"]
["issued",{"$nulls":8},"Costs","interest","Admin",null,"Donations",null,null,"Cutting","Improve",{"$nulls":4},"Errors"]
["12.04.14",982,null,"Beoley Village Hall","Rent (April)",null,null,30,{"$nulls":10},30,"CASHED",30,"",""]
["12.04.15",983,null,"K Dawe","Parish Clerk",null,null,242.8,9.16,132.52,null,101.12,{"$nulls":7},"CASHED",242.8,"",""]
["12.04.16",984,null,"Beoley Football CANCELLED",{"$nulls":15},"CANCELLED","",0,""]
["10.05.16",985,null,"CALC","Subscription",null,null,492.52,73.55,{"$nulls":5},418.97,{"$nulls":4},"CASHED",492.52,"",""]
["10.05.16",986,null,"Miller ","Footpath Warden expenses",null,null,23.52,3.92,{"$nulls":8},19.6,null,"CASHED",23.52,"",""]
["10.05.16",987,null,"Rudge","Grass cutting",null,null,485,{"$nulls":8},485,null,null,"CASHED",485,"",""]
["10.05.16",988,null,"Beoley Football","Replacement chq (payee change)",null,null,200,{"$nulls":5},200,{"$nulls":5},"CASHED",200,"",""]
["10.05.16",989,null,"K Dawe","Parish Clerk",null,null,306,7.65,288.25,null,10.1,{"$nulls":7},"CASHED",306,"",""]
["10.05.16",990,null,"A Brown","Parish Lengthsman",null,null,286.14,1.33,{"$nulls":6},284.81,null,null,null,"CASHED",286.14,"",""]
["27.05.16",991,null,"Zurich Insurance","Annual BPC insurance",null,null,452.26,{"$nulls":4},452.26,{"$nulls":6},"CASHED",452.26,"",""]
["14.06.16",992,null,"Trevor Bland","Jim Yuill plaque cost",null,null,35,{"$nulls":5},35,{"$nulls":5},"CASHED",35,"",""]
["14.06.16",993,null,"P Rudge","Grass cutting",null,null,485,{"$nulls":8},485,null,null,"CASHED",485,"",""]
["14.06.16",994,null,"A Brown","Parish Lengthsman",null,null,158.09,1.33,{"$nulls":6},156.76,null,null,null,"CASHED",158.09,"",""]
["14.06.16",995,null,"K Dawe","Parish Clerk",null,null,253.06,null,250,null,3.06,{"$nulls":7},"CASHED",253.06,"",""]
["12.07.16",996,null,"Beoley First School CANCELLED",{"$nulls":15},"CANCELLED","",0,""]
["12.07.16",997,null,"A Brown","Lengthsman",null,null,156.19,{"$nulls":7},156.19,null,null,null,"CASHED",156.19,"",""]
["12.07.16",998,null,"N Power","Street Lighting",null,null,200.99,{"$nulls":10},200.99,"CASHED",200.99,"",""]
["12.07.16",999,null,"K Dawe","Parish Clerk (June)",null,null,256.6,null,256.6,{"$nulls":9},"CASHED",256.6,"",""]
["12.07.16",1000,null,"P Rudge","Grass cutting",null,null,650,{"$nulls":8},650,null,null,"CASHED",650,"",""]
["13.09.16",1001,null,"Beoley Village Hall","Hall Hire",null,null,90,{"$nulls":10},90,"CASHED",90,"",""]
["13.09.16",1002,null,"P Rudge","Grass cutting (July) 4143",null,null,565,{"$nulls":8},565,null,null,"CASHED",565,"",""]
["130.9.16",1003,null,"P Rudge","Grass Cutting (August) 4157",null,null,505,{"$nulls":8},505,null,null,"CASHED",505,"",""]
["13.09.16",1004,null,"A. Brown","Lengthsman",null,null,304.75,null," ",null," ",null,null,null,304.75,null,null,null,"CASHED",304.75,"",""]
["13.09.16",1005,null,"P. Rudge","Grass Cutting (Sept) 4169",null,null,505,{"$nulls":8},505,null,null,"CASHED",505,"",""]
["13.09.16",1006,null,"K Dawe","Parish Clerk (August)",null,null,250,null,250,{"$nulls":9},"CASHED",250,"",""]
["13.09.16",1007,null,"k. Dawe","Parish Clerk (July)",null,null,257.99,null,257.99,{"$nulls":9},"CASHED",257.99,"",""]
["11.10.16",1008,null,"K.Dawe","Parish Clerk (September)",null,null,284.39,null,250,null,34.39,{"$nulls":7},"CASHED",284.39,"",""]
["11.10.16",1009,null,"A. Brown","Lengthsman",null,null,154.48,{"$nulls":7},154.48,null,null,null,"CASHED",154.48,"",""]
["11.10.16",1010,null,"A.Hall","Garden Comp",null,null,279,6.36,{"$nulls":4},272.64,{"$nulls":5},"CASHED",279,"",""]
["11.10.16",1011,null,"J.Merrell","Expenses",null,null,75,null,null,null,75,{"$nulls":7},"CASHED",75,"",""]
["08.11.16",1012,null,"K. Dawe","Parish Clerk (October)",null,null,264.4,null,250,null,14.4,{"$nulls":7},"CASHED",264.4,"",""]
["08.11.16",1013,null,"Beoley Village Hall","Hall Hire",null,null,90,{"$nulls":10},90,"CASHED",90,"",""]
["08.11.16",1014,null,"L.Stewart","Clerks Expenses",null,null,53.46,null,null,null,53.46,{"$nulls":7},"CASHED",53.46,"",""]
["08.11.16",1015,null,"L.Stewart","Parish Clerk (October)",null,null,187.5,null,187.5,{"$nulls":9},"CASHED",187.5,"",""]
["08.11.16",1017,null,"P.Rudge","Grass Cutting (October) 4180",null,null,505,{"$nulls":8},505,null,null,"CASHED",505,"",""]
["09.11.16",1018,null,"Royal British Legion","Remembrance Sunday? ",null,null,50,{"$nulls":5},50,{"$nulls":5},"CASHED",50,"",""]
["09.11.16",1019,null,"Trevor Bland","Expenses ",null,null,35,null,null,null,35,{"$nulls":7},"CASHED",35,"",""]
["08.11.16",1020,null,"A. Brown","Lengthsman",null,null,197.55,{"$nulls":7},197.55,null,null,null,"CASHED",197.55,"",""]
["10.01.17",1021,null,"Grant Thornton","Auditors",null,null,150,25,{"$nulls":9},125,"CASHED",150,"",""]
["10.01.17",1022,null,"P.Rudge","Grass Cutting (November)",null,null,20,{"$nulls":8},20,null,null,"CASHED",20,"",""]
["10.01.17",1023,null,"P.Miller","Pathswarden",null,null,12.99,0.66,null,null,12.33,{"$nulls":7},"CASHED",12.99,"",""]
["10.01.17",1024,null,"A. Brown","Lengthsman",null,null,245.14,6.79,{"$nulls":6},238.35,null,null,null,"CASHED",245.14,"",""]
["10.01.17",1025,null,"S. Whittaker","Clerk",null,null,197.97,null,187.5,null,10.47,{"$nulls":7},"CASHED",197.97,"",""]
["14.02.17",1051,null,"C.A Hall","Purchase of new maple tree",null,null,44.47,7.41,{"$nulls":4},37.06,{"$nulls":7},44.47,""]
["14.02.17",1052,null,"A. Brown","Lengthsman",null,null,219.74,{"$nulls":7},219.74,null,null,null,"CASHED",219.74,"",""]
["14.02.17",1053,null,"S. Whittaker","Clerk",null,null,187.5,null,187.5,{"$nulls":9},"CASHED",187.5,"",""]
["14.02.17",1054,null,"D.Barry","Expenses",null,null,23.3,null,null,null,23.3,{"$nulls":7},"CASHED",23.3,"",""]
["14.03.17",1055,null,"Worcs CALC","Clerks Training ",null,null,40,null,null,null,40,{"$nulls":7},"CASHED",40,"",""]
["14.03.17",1056,null,"K. Hawkesford","Removal of moles",null,null,70,{"$nulls":9},70,null,"CASHED",70,"",""]
["14.03.17",1057,null,"A. Brown","Lengthsman",null,null,189.14,1.33,{"$nulls":6},187.81,null,null,null,"CASHED",189.14,"",""]
["14.03.17",1058,null,"Beoley Village Hall","Hall Hire",null,null,90,{"$nulls":10},90,null,null,90,""]
["14.03.17",1059,null,"P. Miller","Pathswarden",null,null,37.71,6.29,{"$nulls":8},31.42,null,"CASHED",37.71,"",""]
["14.03.17",1060,null,"S. Whittaker","Clerks & expenses ",null,null,274.85,null,274.85,{"$nulls":9},"CASHED",274.85,"",""]
["14.03.17",1061,null,"J. Merrell","War Memorial Cleaning",null,null,25,{"$nulls":9},25,null,"CASHED",25,"",""]
["14.03.17",1062,null,"Carpenter Landscapes","Church Footpaths",null,null,1266.8,327.8,{"$nulls":8},939,null," ","",1266.8,""]
["14.03.17",1063,null,"Cll. Mrs. Hall","Replacement Planters",null,null,700,95.8,{"$nulls":8},604.2,null," ","",700,""]
["14.03.17",1064,null,"Beoley First School","Beoley First School",null,null,500,{"$nulls":5},500,{"$nulls":6},"",500,""]
[{"$nulls":4},"Total payments ISSUED    ",null,null,13661.299999999994,574.38,2772.7099999999996,0,412.63000000000005,452.26,1094.7,418.97,1900.4399999999998,3720,1689.22,625.99,13661.3,11060.029999999995,2601.27,4.092726157978177e-12,"CheckSum",13661.3]
[{"$nulls":19},13661.3]
[null,null,null,"Closing Bank Balance Carried Forward    ",null,null,null,10788.480000000005,{"$nulls":9},10888.589999999995]
[]
[null,null,null,"Bank Balance as at current Cheque Status  ",null,null,null,8187.210000000005]
[]
[{"$nulls":7},13661.299999999994,null,"Split screen presentation"]
[{"$nulls":9},"Use scroll bars to see all entries"]
[]
[{"$nulls":9},"Petty cash is not recommended/included"]