{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Bank reconciliation","Bank reconciliation example"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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 reconciliation","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,0,2,8],[10,1,10,6],[4,1,4,6],[6,3,6,6],[6,10,7,18]],"flags":["formulas_cached_only"]}
["Bank reconciliation – pro forma"]
["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: ","Great Comberton Parish Council"]
[]
["County area (local councils and parish meetings only): ",null,null,"Worcestershire"]
[]
["Financial year ending 31 March 2025"]
[]
["Prepared by (Name and Role):","Nicola Harding - Clerk/RFO"]
[]
["Date:","2025-03-31"]
[]
[{"$nulls":5},"£","£"]
["Balance per bank statements as at 31/3/25"]
[null,"account 1",null,null,null,7923]
[{"$nulls":6},7923]
[]
["Petty cash float (if applicable)","N/A",null,null,null,0,0]
[]
["Less: any unpresented cheques as at 31/3/25",{"$nulls":4},0,0]
[]
["Add: any un-banked cash as at 31/3/25"]
[{"$nulls":5},0]
[{"$nulls":6},0]
[]
["Net balances as at 31/3/25 (Box 8)",{"$nulls":5},7923]

{"sheet":"Bank reconciliation example","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,0,42,6],[35,0,36,4],[1,0,2,8],[10,4,10,6],[4,3,4,6],[6,5,6,6]],"flags":["formulas_cached_only"]}
["Bank reconciliation – example"]
["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"]
[]
[]
["Name of smaller authority: ",null,null,"ABC Parish Council"]
[]
["County area (local councils and parish meetings only): ",{"$nulls":4},"ABC County"]
[]
["Financial year ending 31 March 20xx"]
[]
["Prepared by (Name and Role):",null,null,null,"Clerk/ RFO "]
[]
["Date:",null,null,null,"xx/xx/xx"]
[]
[{"$nulls":5},"£","£"]
["Balance per bank statements as at 31/3/xx:"]
["e.g Current Account",{"$nulls":4},1000]
["High Interest Account",{"$nulls":4},3000]
["Building Society Premium Account",{"$nulls":4},10000]
[]
[]
[]
[]
[{"$nulls":6},14000]
[]
["Petty cash float (if applicable)",{"$nulls":5},10]
[]
["Less: any unpresented cheques as at 31/3/xx"]
["(normally only current account)"]
["Cheque number",null,154,null,null,-60]
[null,null,157,null,null,-18]
[null,null,158,null,null,-2]
[]
[{"$nulls":6},-80]
["Add: any un-banked cash as at 31/3/xx"]
["e.g Allotment rents banked 30/3/xx (but not credited unil 2 April)"]
[{"$nulls":5},50]
[]
[{"$nulls":6},50]
[]
["Net balances as at 31/3/xx (Box 8)",{"$nulls":5},13980]
[]
["Note: If you hold investments other than in bank deposit or other short-term savings accounts (i.e. long-term investments) these should be excluded from the bank reconciliation and from Section 2, Boxes 1, 7 and 8. They should be shown in Section 2, Box 9 and recorded in the asset and investment register. Long-term investments will include any shareholdings, such as consolidated stock. Further guidance is included within the ‘Practitioners’ Guide’."]
[]
["Please complete the pro forma template on the other tab for your smaller authority."]