{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MENU","Macro Guidance","FINANCIAL CERTIFICATE","Non sch COMFORTS FUND_UMM ACCT","Non Sch float reconciliations","DATA","Locked"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"MENU","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Petty Cash Reconciliation Form"]
[null,"Please Left Click on the Macro Button below to continue."]
[null,"If the Button does not function, please consult the Macro Guidance Worksheet Tab."]
[null,"Should the Protected View message be visible on the Toolbar, click on Enable Editing."]

{"sheet":"Macro Guidance","index":1,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Macro Guidance"]
[]
["If the Macro button is not functioning, this is because the Macro Settings of your PC are not setup correctly.  Follow the steps below for the version of Excel you are using:"]
[]
["Excel 2003 and earlier"]
["Open Microsoft Excel"]
["From the Toolbar, select Tools>Macro>Security, choose Medium, Click OK and then Close Microsoft Excel"]
["Open the Workbook Enabling the Macros when prompted."]
[]
["Excel 2007"]
["Open Microsoft Excel"]
["From the Toolbar, select Developer (if this is not visible, click on the Office Button, choose Excel Options and then Show Developer tab in the Ribbon before finally clicking OK)"]
["then Macro Security, followed by Macro Settings.  Then choose Enable all Macros and click OK.  The Links below explain both of these Procedures if you require further help."]
["Close Microsoft Excel"]
["Open this Workbook again."]
["Show the Developer Tab"]
["Macro Security Settings"]
[]
["Excel 2010"]
["Open Microsoft Excel"]
["From the Toolbar, click on the File tab, choose Options from the left sidebar.  In Options, select Trust Center and then Macro Settings, followed by Enable all Macros and click OK."]
["The Link below explains this Procedure if you require further instruction:"]
["Macro Security Settings"]
["Close Microsoft Excel"]
["   Now Open the Workbook ensuring you always Enable the Macros when prompted."]
[]
["If you are encountering any issues with the links hold down the CTRL key, hover the cursor over the link and left click the link while the CTRL key is held down."]

{"sheet":"FINANCIAL CERTIFICATE","index":2,"n_rows":78,"n_cols":17,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,5],[12,1,12,8],[52,3,52,6],[32,3,32,7],[33,3,33,7],[34,3,34,7],[21,2,21,10],[31,3,31,7],[50,3,50,6],[41,8,41,12],[42,8,42,12],[40,2,40,7],[51,3,51,6],[4,1,4,15],[27,3,27,7],[28,3,28,7],[74,1,74,14],[63,2,63,6],[63,9,63,13],[71,2,71,6],[71,9,71,14],[68,2,68,6],[68,9,68,14],[65,1,66,17],[72,9,72,16],[29,3,29,7],[30,3,30,7],[7,6,7,15],[61,1,61,15],[63,15,63,16],[35,3,35,7],[38,3,38,7],[36,3,36,7],[37,3,37,7],[40,8,40,12],[48,2,48,15]]}
["Petty Cash Journal number",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($G$8,DATA!$A$2:$Z$236,2,0)),0,VLOOKUP($G$8,DATA!$A$2:$Z$236,2,0))","v":0}]
[null,"ANNUAL PETTY CASH ACCOUNT FINANCIAL CERTIFICATE "]
[]
[]
[null,"THIS CERTIFICATE MUST BE COMPLETED ON THE LAST DAY OF FEBRUARY "]
[null,"(Must be returned by 3rd March for non-schools, and 3rd Friday in March for schools)"]
[null,"Please complete/select blue boxes only"]
[null,null,null,null,null,"ESTABLISHMENT/CENTRE: ","Select establishment from drop down list"]
[null,"NB. As it appears on your bank statement"]
["1)","All financial records and inventories must  still be completed for the year ended 31st March ."]
[]
["2)","Barclays Bank A/c No: "]
[null,{"$f":"IF(M14=\"ERROR\",\"****\"&RIGHT(J14,4),IF(M14=\"OK\",J14))","v":"****0"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($G$8,DATA!$A$2:$Z$236,4,0)),0,VLOOKUP($G$8,DATA!$A$2:$Z$236,4,0))","v":0},7,{"$f":"(LEFT(J14,4))+0","v":0},{"$f":"IF(K14=L14,\"ok\",\"error\")","v":"error"}]
[]
["3)","The balance of Petty Cash at the end of February was made up as follows and this is the statement of my imprest:-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£     p"]
[null,"3.1)","My petty cash imprest level is:",null,null,null,null,null,null,null,null,null,null,null,null,"(A)",{"$f":"IF(ISNA(VLOOKUP($G$8,DATA!$A$2:$Z$236,3,0)),0,VLOOKUP($G$8,DATA!$A$2:$Z$236,3,0))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"dd","mm","yyyy",null,null,"£     p"]
[null,"3.2)","Balance in Bank – per latest statement available dated:",null,null,null,null,null,null,null,null,null,null,null,null,"(B)"]
[null,null,"(Please attach a copy of the bank statement to this form, when returning to the finance section)"]
[]
[null,"3.3)","Less cash drawings not yet reflected in bank statement (entered as a minus figure) :"]
[]
["LESS","3.4)","Less any unpresented cheques (entered as a minus figure) :"]
[null,null,null,null,null,null,null,null,null,null,"dd","mm","yyyy",null,"£   .  p"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:"]
[null,null,"Chq No.:",null,null,null,null,null,null,"Dated:",null,null,null,null,null,null,{"$f":"SUM(O28:O39)","v":0}]
[]
["ADD","3.5)","Schools, claims not yet submitted or Non Schools, claims not yet recouped/entered on system"]
[]
[null,null," (Please Specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O41:O43)","v":0}]
[]
[null,null,"SUB TOTAL (3.3 + 3.4+3.5)",null,null,null,null,null,null,null,null,null,null,null,null,"(C)",{"$f":"Q43+Q39+Q24","v":0}]
[null,null,"    "]
["ADD","3.6)","Balance of cash in hand (e.g. petty cash box) at end of February:"]
[]
["ADD","3.7)","Outstanding claims submitted by schools or recouped by non schools but not yet received in the bank at end of February "]
[null,null,"(Please attach photocopies/screenprints of details, not the backing documents)"]
[null,null,"No:"]
[null,null,"No:"]
[null,null,"No:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O51:O53)","v":0}]
[]
[null,null,"SUB TOTAL (3.6 + 3.7)",null,null,null,null,null,null,null,null,null,null,null,null,"(D)",{"$f":"Q53+Q47","v":0}]
[]
[null,null,"Calculated imprest balance as at end of February (B + C + D)",null,null,null,null,null,null,null,null,null,null,null,null,"(E)",{"$f":"Q21+Q45+Q55","v":0}]
[]
[null,null,"Agreed Imprest Level less Calculated Imprest Balance (A-E)",null,null,null,null,null,null,null,null,null,null,null,null,"(F)",{"$f":"Q18-Q57","v":0}]
[null,null,"(NB Total F should be zero, if this is not the case, please provide details of discrepancy)"]
[]
["4)","Name and Telephone number of Officer to be contacted after in March in case of queries arising in respect of this certificate."]
[]
[null,"Name:",null,null,null,null,null,null,"Designation:",null,null,null,null,null,"Tel. No.:"]
[]
["5)","I CERTIFY THE ABOVE DETAILS ARE CORRECT, THAT I HAVE CARRIED OUT A REVIEW OF THE EXPENDITURE, THAT  ANY FLOATS FOR OTHER ESTABLISHMENTS OPERERATED VIA THIS PETTY CASH ACCOUNT ARE RECONCILED, THAT THE PETTY CASH ACCOUNT IS STILL REQUIRED AND THE ACCOUNT CANNOT BE REPLACED BY ALTERNATIVE PAYMENT METHODS eg PURCHASE CARDS"]
[]
[]
[null,"Name:",null,null,null,null,null,null,"Designation:"]
[]
[]
[null,"Date:",null,null,null,null,null,null,"Signature:"]
[null,null,null,null,null,null,null,null,null,"This must be signed by Manager/Admin. Manager for Non schools and Head Teacher for school"]
[]
[null,"This certificate must be returned by email with scanned supporting documents to:  Non schools petty cash: support@birmingham.gov.uk for Non Schools and Schools petty cash: admin@birmingham.gov.uk for schools.\n\nThen post the original to -  Adults and Children Finance Coordination Team (for Non Schools) or School Finance Team - Petty Cash (for Schools), City Finance (WS), PO Box 16306, Birmingham, B2 2XR."]
[]
[]
[null,"NB. If you have Comforts Funds/User Money Management A/Cs or Floats please complete the other tabs"]

{"sheet":"Non sch COMFORTS FUND_UMM ACCT","index":3,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[[30,0,30,1],[39,0,39,1]]}
["NON SCHOOLS ONLY"]
["COMFORTS FUNDS/USER MONEY MANAGEMENT ACCOUNTS"]
[]
["Where applicable if your site has a a Comfort Fund or User Money Mangement Account"]
["the following information should be provided."]
[]
["Bank Account Name:"]
["Bank Account Number:"]
["Date of most recent bank statement:"]
["Bank balance:"]
["Cash In Hand:"]
["Total Balance:",{"$f":"+B11+B10","v":0}]
[]
["Current Signatories:"]
[]
[]
[]
[]
[]
[]
["Date account was last reviewed by"]
["the Team Manager:"]
[]
["Name of officer to be contaced after"]
["3rd March in case of queries:"]
[]
["Designation"]
[]
["Telephone Number"]
[]
["I CERTIFY THE ABOVE DETAILS ARE CORRECT."]
[]
["Manager/Admin Manager"]
[]
["Date"]
[]
["Signature"]
["NB. An email from the manager with the completed form will suffice as signature."]

{"sheet":"Non Sch float reconciliations","index":4,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,6],[30,2,30,6],[30,9,30,14],[13,18,13,19],[15,15,15,16],[17,15,17,16],[19,18,19,19],[22,18,22,19],[4,1,4,15],[24,1,24,12],[7,3,7,9],[27,2,27,6],[27,9,27,14]]}
["NON SCHOOLS ONLY"]
[]
[null,"ANNUAL PETTY CASH ACCOUNT FLOAT FINANCIAL CERTIFICATE "]
[]
[null,"THIS CERTIFICATE MUST BE COMPLETED AS AT 28th or 29th FEBRUARY ."]
[null,"(Must be returned by 3rd March )"]
[]
[null,"FLOAT NAME"]
[]
["1)","All financial records and inventories must  still be completed for the year ended 31st March."]
[]
["2)","The balance of Petty Cash Float on 28/29th February is made up as follows and this is the statement of my float:-"]
[]
[null,"2.1)","My petty cash Float is:"]
[]
[null,"2.2)","Balance of cash in hand (e.g. petty cash box) at 28/29th February:"]
[]
[null,"2.3)","Outstanding claims not yeat recouped"]
[]
[null,"2.4)","Calculated imprest balance as at 28/29th February (2.2 + 2.3)"]
[]
[]
[null,"Actual Float Level less Calculated Float Balance (2.1-2.4)",null,null,null,null,null,null,null,null,"(Should be nil)",null,null,null,null,null,null,null,{"$f":"S14-S20","v":0}]
[]
[null,"I CERTIFY THE ABOVE DETAILS ARE CORRECT"]
[]
[]
[null,"Name:",null,null,null,null,null,null,"Designation:"]
[]
[]
[null,"Date:",null,null,null,null,null,null,"Signature:"]
[null,null,null,null,null,null,null,null,null,"This must be signed by Manager/Admin. Manager"]

{"sheet":"DATA","index":5,"n_rows":237,"n_cols":6,"rows_kept":237,"cut":false,"hidden":true,"merged":[]}
["Select establishment from drop down list","Barclays PC Journal No","Imprest","Barclays Account No"]
["Abbey Primary","REAAA",42000,"63151492","****1492","Schools"]
["Adderley Childrens Centre","REAYW",40000,"40684201","****4201","Schools"]
["Adderley Primary","REAAD",70000,"90201286","****1286","Schools"]
["Al Furqan","REAAE",1000,"10954071","****4071","Schools"]
["Al Hijrah Secondary","REAZZ",2000,"30094676","****4676","Schools"]
["Allens Croft Primary","REAAH",50000,"00276006","****6006","Schools"]
["Anglesey Primary","REAAM",80000,"03849791","****9791","Schools"]
["Arden J&I","REAAN",90000,"20618799","****8799","Schools"]
["Aston Office",529,45000,"43919307","****9307","Non-Schools"]
["Banners Gate Junior","REAAV",60000,"40356891","****6891","Schools"]
["Barford J&I (NC)","REAAW",1000,"73556565","****6565","Schools"]
["Baskerville","REAXL",10000,"13946967","****6967","Schools"]
["Beaufort","REAXM",2000,"13062872","****2872","Schools"]
["Beeches Gold & Adv Enablement Ldr",535,800,"60070505","****0505","Non-Schools"]
["Bellfield Infant","REAAY",60000,"33344193","****4193","Schools"]
["Bellfield Junior","REAAZ",800,"53986675","****6675","Schools"]
["Bells Farm J & I","REABA",2000,"80189863","****9863","Schools"]
["Benson Primary","REABB",80000,"70241393","****1393","Schools"]
["Birches Green Infant","REABE",3200,"90658170","****8170","Schools"]
["Birches Green Junior","REABF",1400,"13282678","****2678","Schools"]
["Birchfield J&I Commu","REABG",4380,"63626865","****6865","Schools"]
["Birmingham Register Office",565,1200,"13918297","****8297","Non-Schools"]
["Bloomsbury","REAYY",500,"83954560","****4560","Schools"]
["Bordesley Green East Nursery ","REAYZ",65000,"60822566","****2566","Schools"]
["Bordesley Village","REAKZ",1000,"13621065","****1065","Schools"]
["Bournville Infants","REABQ",50000,"73552713","****2713","Schools"]
["Bournville Junior","REABR",1500,"03655768","****5768","Schools"]
["Braidwood Special","REAXN",50000,"10859494","****9494","Schools"]
["Brearley Street","REAZA",750,"70615463","****5463","Schools"]
["Brook House L D RespitePC A/C",553,400,"83928705","****8705","Non-Schools"]
["Brookfields Junior &","REABY",450,"23313174","****3174","Schools"]
["Calshot Primary","REACB",40000,"80772593","****2593","Schools"]
["Camborne Road PC Ac",525,2500,"33686205","****6205","Non-Schools"]
["Castle Vale Nursery","REAZB",20000,"33430596","****0596","Schools"]
["Chad Vale Primary","REACD",60000,"90994294","****4294","Schools"]
["Charles House P/C Acct",559,1000,"90617903","****7903","Non-Schools"]
["Cherry Orchard Primary","REACF",65000,"00936898","****6898","Schools"]
["Children With Disabilities P/C",563,2000,"93665909","****5909","Non-Schools"]
["Clifton Primary School","REACN",100000,"23218597","****8597","Schools"]
["Colebourne Primary School","REACQ",120000,"13612007","****2007","Schools"]
["Colmers Farm Infant","REACR",500,"60121274","****1274","Schools"]
["Coppice J&I","REACY",60000,"53761789","****1789","Schools"]
["Corpus Christi RC Ju","REACZ",700,"80144371","****4371","Schools"]
["Cotteridge Junior &","READA",1000,"80829161","****9161","Schools"]
["Court Farm Junior &","READD",1000,"70470570","****0570","Schools"]
["Dame Ellen Pinsent","REAXV",1000,"93165868","****5868","Schools"]
["Deykin Avenue Junior","READG",800,"60932167","****2167","Schools"]
["Disabled Childrens Service PC",562,1000,"93261204","****1204","Non-Schools"]
["Ebrook Resource Centre PC A/C",528,400,"43682293","****2293","Non-Schools"]
["Edgewood Rd P/C A/C",510,1500,"13938204","****8204","Non-Schools"]
["Edith Cadbury Nursery","REAYF",20000,"63850978","****0978","Schools"]
["Elms Farm Junior & I","READJ",2700,"20667978","****7978","Schools"]
["Elwood Centre PC A/C",515,200,"23418502","****8502","Non-Schools"]
["English Martyrs","READK",30000,"50748110","****8110","Schools"]
["ESF Advance",536,6700,"63564223","****4223","Non-Schools"]
["Fairway D C Petty Cash A/C",527,300,"43659143","****9143","Non-Schools"]
["Featherstone Junior","READN",500,"20520276","****0276","Schools"]
["Featherstone Nursery","REAZC",500,"13788369","****8369","Schools"]
["Forrestdale JI","READY",1600,"20135976","****5976","Schools"]
["Four Oaks Primary","READX",40000,"63059596","****9596","Schools"]
["Fox Hollies Special","REAXW",75000,"60121282","****1282","Schools"]
["Frankley Community H/Balaam  Wood","REATX",3000,"53340279","****0279","Schools"]
["Funerals/Protection Of Property PC",558,300,"90458902","****8902","Non-Schools"]
["Garretts Green","REAZD",1000,"33044769","****4769","Schools"]
["George Dixon","READZ",1000,"50597228","****7228","Schools"]
["Gilberstone Primary","REAEA",65000,"93564797","****4797","Schools"]
["Glenmead Primary","REAEB",40000,"53608980","****8980","Schools"]
["Goodway Nursery","REAZE",300,"03693058","****3058","Schools"]
["Gossey Lane Junior &","Academy",500,"18927868","****7868","Schools"]
["Gracelands","REAZF",600,"73131963","****1963","Schools"]
["Grendon Junior & Inf","REAEH",1000,"50351865","****1865","Schools"]
["Grove J&I  (NC)","REAEK",1900,"33834573","****4573","Schools"]
["Guardian Angels RC J","REAEL",1000,"70188271","****8271","Schools"]
["Gunter Junior & Infa","REAEM",685,"30765473","****5473","Schools"]
["Hamilton","REAXZ",1000,"70762679","****2679","Schools"]
["Harborne JI","REAER",2000,"63978761","****8761","Schools"]
["Harborne Resource Centre PC A/C",552,1500,"83903591","****3591","Non-Schools"]
["Hawthorn J&I","REAEW",60000,"83811794","****1794","Schools"]
["Heartlands Resource Centre PC A/C",530,1500,"50021997","****1997","Non-Schools"]
["Heath Mount Primary","REAEX",140000,"43076652","****6652","Schools"]
["Highfield Nursery","REAZG",2700,"70294756","****4756","Schools"]
["Highters Heath","REAFB",20000,"63205207","****5207","Schools"]
["Highters Heath Nrsry","REAZH",500,"53258661","****8661","Schools"]
["Hockley Day Centre P C A/C",544,2000,"80054992","****4992","Non-Schools"]
["Holland House Infant","REAFG",35000,"53760286","****0286","Schools"]
["Holly Hill Methodist","REAFH",600,"53457370","****7370","Schools"]
["Hollyfield JI","REAFK",700,"33678970","****8970","Schools"]
["Holy Trinity RC","REAVL",2000,"33087271","****7271","Schools"]
["Holyfamily RC Junior","REAFP",1300,"83594564","****4564","Schools"]
["Holysouls RC Junior","REAFQ",1000,"30164461","****4461","Schools"]
["Hunters Hill Special","REAYA",100000,"03653102","****3102","Schools"]
["International School","Academy",4500,"20149373","****9373","Schools"]
["Jakeman Nursery","REAZJ",900,"60865060","****5060","Schools"]
["John Wilmott School","REAVN",120000,"93878015","****8015","Schools"]
["Kings Heath Boys","REAVW",1000,"83225771","****5771","Schools"]
["Kings Heath JI","REAFY",1000,"23345572","****5572","Schools"]
["Kings Norton JI","REAFZ",600,"03136868","****6868","Schools"]
["Kings Norton Nursery","REAZK",600,"80985864","****5864","Schools"]
["Kingsland Junior & I","REAGB",1000,"30633275","****3275","Schools"]
["Kingsthorne Junior &","REAGC",1000,"73417875","****7875","Schools"]
["Kitwell Junior & Inf","REAGD",500,"70799572","****9572","Schools"]
["Ladypool Primary","REAGE",2000,"33304965","****4965","Schools"]
["Lakey Lane Primary","REAGF",30000,"63747190","****7190","Schools"]
["Langley Special","REAYD",50000,"23831191","****1191","Schools"]
["Lifford House",516,16000,"23474208","****4208","Non-Schools"]
["Lillian De Lissa Nsy","REAZL",600,"90135658","****5658","Schools"]
["Lindsworth Centre","REAYE",3000,"73082067","****2067","Schools"]
["Longwill Special","REAYG",50000,"53487997","****7997","Schools"]
["Maney Hill Primary","REAGP",60000,"50391697","****1697","Schools"]
["Mapledene JI","REAGV",750,"40965170","****5170","Schools"]
["Marlborough Infant","REAGW",600,"40740268","****0268","Schools"]
["Marlborough Junior","REAGX",750,"83496562","****6562","Schools"]
["Marsh Hill Nursery","REAZM",200,"40340960","****0960","Schools"]
["Maryvale RC Junior &","Cheque Book School",450,"13859673","****9673","Schools"]
["Mayfield","REAYH",5000,"63555585","****5585","Schools"]
["Meadows Junior & Inf","REAHA",550,"53279774","****9774","Schools"]
["Minworth Junior & In","REAHC",1500,"80693278","****3278","Schools"]
["Moor Hall Junior & I","REAHG",1600,"13176185","****6185","Schools"]
["Moseley CE Junior &","REAHH",500,"23799174","****9174","Schools"]
["Moseley Day Centre Petty Cash A/C",549,500,"83302695","****2695","Non-Schools"]
["Nelson Junior & Infa","REAHL",1500,"50338060","****8060","Schools"]
["Nelson Mandella Juni","REAHM",1000,"70016969","****6969","Schools"]
["New Hall J I School","REAHN",2000,"33186768","****6768","Schools"]
["New Oscott Primary","REAHQ",1500,"30773972","****3972","Schools"]
["New Roots P/C A/C",518,500,"30848808","****8808","Non-Schools"]
["Newtown Nursery","REAZN",600,"80951064","****1064","Schools"]
["North Adults Petty Cash A/C",543,4000,"80050008","****0008","Non-Schools"]
["Oratory Primary","REAHX",30000,"53317293","****7293","Schools"]
["Osborne J&I","REAHY",40000,"23950298","****0298","Schools"]
["Osborne Nursery","REAZP",1000,"53180964","****0964","Schools"]
["Our Lady & St Rose of Lima","REAHZ",20000,"40292583","****2583","Schools"]
["Our Lady of Lourdes Primary","REAJB",30000,"43569896","****9896","Schools"]
["Our Lady's RC Junior","REAJC",1000,"40642878","****2878","Schools"]
["Paganel Primary","REAJE",100000,"70731013","****1013","Schools"]
["Paget Primary  (NC)","REAJF",1000,"63751872","****1872","Schools"]
["Park Hill Junior & I","REAJG",500,"93183572","****3572","Schools"]
["Penns Junior & Infan","REAJK",500,"83872572","****2572","Schools"]
["Perry Beeches Infant","REAJM",800,"17740860","****0860","Schools"]
["Perry Beeches Junior","REAJN",1000,"50301779","****1779","Schools"]
["Perry Beeches Nrsy","REAZQ",200,"43389162","****9162","Schools"]
["Priestley Smith","REAYK",2000,"33422585","****2585","Schools"]
["Princethorpe Junior","REAJV",650,"93353761","****3761","Schools"]
["Queensbury","REAYL",6680,"90094277","****4277","Schools"]
["Raddlebarn Junior","REAJX",500,"13611264","****1264","Schools"]
["Rea Meadow D N Petty Cash A/C",524,75,"33652645","****2645","Non-Schools"]
["Redhill Junior & Inf","REAJZ",450,"13634175","****4175","Schools"]
["Rednal Hill Infant","REAKA",400,"30967475","****7475","Schools"]
["Rednal Hill Junior","REAKB",1000,"50194778","****4778","Schools"]
["Regents Park Primary","REAKC",70000,"03078094","****8094","Schools"]
["Rosary RC Junior & I","REAKH",600,"50880566","****0566","Schools"]
["Rubery Nursery","REAZT",1600,"23800253","****0253","Schools"]
["Selly Oak Nursery","REAZU",500,"70369764","****9764","Schools"]
["Severne Junior & Inf","REAKK",2000,"43417468","****7468","Schools"]
["Shaw Hill Primary","REAKL",90000,"03913902","****3902","Schools"]
["Shenley Fields Nrsry","REAZV",800,"03134962","****4962","Schools"]
["Sommerville Primary","REAKT",150000,"73473902","****3902","Schools"]
["South Access Centre",532,10000,"50763705","****3705","Non-Schools"]
["South Adults PC A/C",541,5000,"73547507","****7507","Non-Schools"]
["Spark Hill Adult Educ Ctr",511,2000,"13939707","****9707","Non-Schools"]
["Springfield House","REAYP",2000,"30512966","****2966","Schools"]
["Springfield JI","REAKW",600,"40175374","****5374","Schools"]
["SS John & Monica RC","REAMB",30000,"73229262","****9262","Schools"]
["SS Peter & Paul RC","REAND",45000,"93378578","****8578","Schools"]
["St Albans RC Junior","REAKX",1000,"43106160","****6160","Schools"]
["St Ambrose Barlow Primary","REAKY",25000,"90777897","****7897","Schools"]
["St Anne's RC Junior","REALA",350,"80324361","****4361","Schools"]
["St Augustines RC Jun","REALB",600,"23515273","****5273","Schools"]
["St Barnabas CE Junio","REALC",400,"43418375","****8375","Schools"]
["St Benedicts Infant","REALD",1800,"83326462","****6462","Schools"]
["St Bernadetts RC Primary","REALE",120000,"00349399","****9399","Schools"]
["St Bernard's RC Juni","REALF",1000,"23917479","****7479","Schools"]
["St Catherine's Of Si","REALH",600,"73438368","****8368","Schools"]
["St Chads RC Junior &","REALJ",300,"60743275","****3275","Schools"]
["St Clares RC Junior","REALK",800,"63475867","****5867","Schools"]
["St Cuthbert's RC Jun","REALN",300,"30776165","****6165","Schools"]
["St Edmund Campion Sec","REAWT",120000,"30365092","****5092","Schools"]
["St Edmund's RC Junio","REALQ",1000,"33998436","****8436","Schools"]
["St Edward's RC Junio","REALR",800,"03662152","****2152","Schools"]
["St Francis RC Junior","REALV",1000,"93697878","****7878","Schools"]
["St Gerard's Primary","REALY",60000,"83628396","****8396","Schools"]
["St James CE Jun & In","REALZ",2000,"43242072","****2072","Schools"]
["St John Fisher's RC","REAMC",2450,"70026174","****6174","Schools"]
["St John Wall RC","REAWV",1500,"50976679","****6679","Schools"]
["St Joseph's RC (B7)","REAMG",500,"83878074","****8074","Schools"]
["St Laurence CE Infan","REAMK",750,"70430277","****0277","Schools"]
["St Laurence CE Junio","REAML",1000,"03822079","****2079","Schools"]
["St Margaret Mary","REAMN",50000,"60473618","****3618","Schools"]
["St Marks Catholic Primary","REAMP",40000,"30210595","****0595","Schools"]
["St Martin De Porres","REAMQ",1435,"53599361","****9361","Schools"]
["St Mary & St John RC","REAMR",450,"20001376","****1376","Schools"]
["St Mary's CE (B29) J","REAMV",1000,"10700169","****0169","Schools"]
["St Mary's RC (B17)","REAMW",80000,"40995789","****5789","Schools"]
["St Patrick's RC (B18","REANB",300,"73364879","****4879","Schools"]
["St Peter's RC Primary","REANG",60000,"30383392","****3392","Schools"]
["St Saviour's CE Juni","REANH",1000,"80743461","****3461","Schools"]
["St Teresa's RC Junio","REANJ",1000,"63860779","****0779","Schools"]
["St Thomas EYC Nsry","REAZR",350,"10212660","****2660","Schools"]
["St Thomas More's RC","REANL",450,"50861871","****1871","Schools"]
["St Vincent's RC Juni","REANM",600,"00042366","****2366","Schools"]
["St Wilfreds Primary","REANN",40000,"23043797","****3797","Schools"]
["Stanville Primary","REANP",50000,"10074896","****4896","Schools"]
["Starbank Primary","REANQ",300000,"10293199","****3199","Schools"]
["Stechford Junior & I","REANR",500,"10587079","****7079","Schools"]
["Substance Misuse Recovery Services",509,4000,"13791009","****1009","Non-Schools"]
["Summerfield Junior &","REANV",2500,"80759368","****9368","Schools"]
["Sundridge Primary","REANW",50000,"93032787","****2787","Schools"]
["The City of Birmingham School","REAAB",245000,"13236609","****6609","Schools"]
["The Laurels L D H P/C A/C",540,400,"73453995","****3995","Non-Schools"]
["The Oaks JI","REAKP",500,"80937568","****7568","Schools"]
["The Pines Special","REAYJ",40000,"93081990","****1990","Schools"]
["Thornton Junior","REANY",1000,"23777774","****7774","Schools"]
["Turves Green Boys","REAXE",2000,"90690678","****0678","Schools"]
["Turves Green Girls","REAXF",2000,"60167673","****7673","Schools"]
["Uffculme Special","REAYQ",60000,"33096785","****6785","Schools"]
["Viscount House Petty Cash",566,400,"23897028","****7028","Non-Schools"]
["Warwick House Petty Cash Account",531,1000,"50637602","****7602","Non-Schools"]
["Washwood Heath Nursery","REAZW",60000,"23912876","****2876","Schools"]
["Watermill Junior & I","REAPM",500,"03972569","****2569","Schools"]
["Wattville Primary","REAPP",50000,"73003493","****3493","Schools"]
["Welsh House Farm Community","REAPR",50000,"40658197","****8197","Schools"]
["Weoley Castle Nursry","REAZX",1000,"60539368","****9368","Schools"]
["West Area - BAES",500,5000,"00051292","****1292","Non-Schools"]
["West Heath Nursery","REAZY",500,"30269468","****9468","Schools"]
["West Heath Primary","REAPV",2000,"03614476","****4476","Schools"]
["Whitehouse Com JI","REAPZ",800,"03397262","****7262","Schools"]
["Wilkes Green  Infant","REAQC",400,"90060070","****0070","Schools"]
["Wilkes Green Infants","REAQC",50000,"03669181","****9181","Schools"]
["Woodcock Hill","REARC",20000,"80699861","****9861","Schools"]
["Woodgate Primary","REARD",20000,"80426091","****6091","Schools"]
["Woodthorpe Junior &","REARF",300,"23823164","****3164","Schools"]
["Worlds End Infant","REARG",40000,"10174688","****4688","Schools"]
["Wylde Green Primary","REARL",60000,"83743195","****3195","Schools"]
["Yardley Area CYP&F Petty Cash A/C",503,20000,"03137619","****7619","Non-Schools"]
["Yardley Primary","REARQ",100000,"40179590","****9590","Schools"]
["Yenton Primary","REARW",50000,"63691497","****1497","Schools"]
["Yorkmead Junior & In","REARY",500,"10566578","****6578","Schools"]

{"sheet":"Locked","index":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Petty Cash Reconciliation Form"]
[null,"This Workbook is now Locked.  Please close the File."]