{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Bank reconciliation"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Bank reconciliation","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[1,0,2,8],[4,1,4,6],[6,3,6,6],[6,10,7,18],[10,1,10,6]]}
["Bank reconciliation"]
["This reconciliation should include all bank and building society accounts, including short term investment accounts. It must agree to Box 8 in the column headed “Year ending 31 March 20xx” in Section 2 of the AGAR – and will also agree to Box 7 where the accounts are prepared on a receipts and payments basis. Please complete the highlighted boxes, remembering that unpresented cheques should be entered as negative figures."]
[]
[]
["Name of smaller authority: ","Smisby Parish Council"]
[]
["County area (local councils and parish meetings only): ",null,null,"Derbyshire"]
[]
["Financial year ending 31 March 2025"]
[]
["Prepared by (Name and Role):","Caroline Crowder, Clerk and Responsible Finance Officer"]
[]
["Date:","2025-04-02"]
[]
[{"$nulls":5},"£","£"]
["Balance per bank statements as at 31/3/25:"]
[null,"Current Account",{"$nulls":3},{"v":11060.08,"d":"11,060.08"}]
[null,"Business Reserves Account",{"$nulls":3},0]
[]
[{"$nulls":6},{"$f":"SUM(F17:F19)","v":{"v":11060.08,"d":"11,060.08"}}]
[]
["Petty cash float (if applicable)",{"$nulls":5},0]
[]
["Less: any unpresented cheques as at 31/3/25 (enter these as negative numbers)"]
[]
[]
[{"$nulls":6},{"$f":"SUM(F25:F26)","v":0}]
["Add: any un-banked cash as at 31/3/25"]
[]
[]
[{"$nulls":6},{"$f":"SUM(F29:F30)","v":0}]
[]
["Net balances as at 31/3/25 (Box 8)",{"$nulls":5},{"$f":"G20+G22+G27+G31","v":{"v":11060.08,"d":"11,060.08"}}]