{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Internal Journal Adjustment","Look Up"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Internal Journal Adjustment","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,2,41,5],[32,1,32,5],[16,3,18,3],[28,1,30,2],[28,3,30,3],[40,2,40,5],[38,1,38,5],[20,1,20,5],[27,1,27,2],[33,1,36,5],[31,4,31,5],[16,1,18,2],[39,2,39,5],[21,1,24,5],[5,1,5,5],[7,1,7,5],[15,1,15,2],[3,2,3,5],[0,1,0,4],[8,1,12,5]]}
[null,"INTERNAL JOURNAL ADJUSTMENT",null,null,null,"FY 26/27"]
[]
[]
[null,"FROM:","Please select school from drop down"]
[]
[null,"Please process the following journal as authorised below"]
[]
[null,"DETAILS OF CHARGE"]
[]
[]
[]
[]
[]
[]
[null,"Credit"," (School receiving income)"]
[null,"School Name",null,"Cost Centre","GL Code","Amount"]
[null,"Please select school from drop down",null,{"$f":"IF($C$4=\"Please select school from drop down\",\"\",VLOOKUP($B$17,'Look Up'!A3:D137,2,FALSE))","v":""}]
[]
[]
[]
[null,"Reference to appear on FMGL01 prints (max 20 letters)"]
[]
[]
[]
[]
[]
[null,"Debit","(School receiving charge)"]
[null,"School Name",null,"Cost Centre","GL Code","Amount"]
[null,"Please select school from drop down",null,{"$f":"IF($B$29=\"Please select school from drop down\",\"\",VLOOKUP($B$29,'Look Up'!A3:B137,2,FALSE))","v":""}]
[]
[]
[null,null,null,null,{"$f":"IF(SUM(F17:F19)=SUM(F29:F31),\"\",\"TOTALS DO NOT MATCH\")","v":""}]
[null,"Reference to appear on FMGL01 prints (max 20 letters)"]
[]
[]
[]
[]
[]
[null,"Certified for Payment (School receiving charge):",null,null,"Date:"]
[null,"Signatory: "]
[null,"Print name:"]
[null,"Date:"]
[]
[null,"Please send completed form to:"]
[]
[null,"Core Finance"]
[null,"Strategic Finance"]
[null,"Block 1, 3rd Floor, Shire Hall"]
[]
[null,"Or alternatively via email:  schools.accountancy@gloucestershire.gov.uk"]

{"sheet":"Look Up","index":1,"n_rows":137,"n_cols":4,"rows_kept":137,"cut":false,"hidden":true,"merged":[]}
[]
["Please select school from drop down"]
["Abbeymead Primary School","107529","Central School","Primary"]
["Alderman Knight School","107125","Central School","Special"]
["Ampney Crucis Church of England Primary School","107531","Central School","Primary"]
["Ann Edwards Church of England Primary School","107786","Central School","Primary"]
["Ashchurch Primary School","107534","Central School","Primary"]
["Ashleworth Church of England Primary School","107535","Central School","Primary"]
["Benhall Infant School","107881","Central School","Primary"]
["Berry Hill Primary School",107546,"Central School","Primary"]
["Bettridge School","107127","Central School","Special"]
["Birdlip Primary School","107551","Central School","Primary"]
["Bisley Blue Coat Church of England Primary School","107553","Central School","Primary"]
["Blakeney Primary School","107558","Central School","Primary"]
["Bledington Primary School","107559","Central School","Primary"]
["Brimscombe Church of England (VA) Primary School","107567","Central School","Primary"]
["Bussage Church of England Primary School","107578","Central School","Primary"]
["Cam Everlands Primary School","107580","Central School","Primary"]
["Cam Hopton Church of England Primary School","107582","Central School","Primary"]
["Cam Woodfield Infant School","107583","Central School","Primary"]
["Cashes Green Primary School","107585","Central School","Primary"]
["Castle Hill Primary School","107579","Central School","Primary"]
["Chalford Hill Primary School","107586","Central School","Primary"]
["Churcham Primary School","107598","Central School","Primary"]
["Churchdown Parton Manor Federation","107610","Central School","Primary"]
["Cirencester Primary School","107603","Central School","Primary"]
["Clearwell Church of England Primary School","107605","Central School","Primary"]
["Coalway Community Infant School","107620","Central School","Primary"]
["Coalway Junior School","107569","Central School","Primary"]
["Coberley Church of England Primary School","107609","Central School","Primary"]
["Coney Hill Community Primary School","107924","Central School","Primary"]
["Coopers Edge School","107958","Central School","Primary"]
["Cranham Church of England Primary School","107616","Central School","Primary"]
["Deerhurst and Apperley Church of England Primary School","107619","Central School","Primary"]
["Dinglewell Infant School","107925","Central School","Primary"]
["Dinglewell Junior School","107926","Central School","Primary"]
["Eastcombe Primary School","107633","Central School","Primary"]
["Eastington Primary School","107635","Central School","Primary"]
["Ellwood Primary School","107640","Central School","Primary"]
["Elmbridge Primary School","107928","Central School","Primary"]
["Finlay Community School","107929","Central School","Primary"]
["Gardners Lane Primary School","107886","Central School","Primary"]
["Gastrells Community Primary School","107781","Central School","Primary"]
["Glebe Infants' School","107726","Central School","Primary"]
["Glenfall Community Primary School","107593","Central School","Primary"]
["Gloucester Road Primary School","107887","Central School","Primary"]
["Gloucestershire Hospital Education Service","101500","Central School","Alternative Provision"]
["Grangefield Primary School","107656","Central School","Primary"]
["Greatfield Park Primary School","107891","Central School","Primary"]
["Haresfield Church of England Primary School","107665","Central School","Primary"]
["Harewood Infant School","107933","Central School","Primary"]
["Hatherop Church of England Primary School","107667","Central School","Primary"]
["Heart of the Forest Community Special School","107145","Central School","Special"]
["Hempsted Church of England Primary School","107936","Central School","Primary"]
["Hesters Way Primary School","107888","Central School","Primary"]
["Hillesley Church of England Primary School","107671","Central School","Primary"]
["Hillview Primary School","107937","Central School","Primary"]
["Holy Trinity Church of England Primary School","107890","Central School","Primary"]
["Horsley Church of England Primary School","107672","Central School","Primary"]
["Huntley Church of England Primary School","107677","Central School","Primary"]
["Innsworth Infant School","107683","Central School","Primary"]
["Innsworth Junior School","107678","Central School","Primary"]
["Isbourne Valley School","107789","Central School","Primary"]
["Kempsford Church of England Primary School","107682","Central School","Primary"]
["King's Stanley CofE Primary School","107686","Central School","Primary"]
["Kingsway Primary School","107817","Central School","Primary"]
["Kingswood Primary School","107691","Central School","Primary"]
["Lakeside Primary School","107892","Central School","Primary"]
["Leonard Stanley Church of England Primary School","107694","Central School","Primary"]
["Linden Primary School","107940","Central School","Primary"]
["Littledean Church of England Primary School","107695","Central School","Primary"]
["Lydbrook Primary School","107709","Central School","Primary"]
["Meadowside Primary School","107816","Central School","Primary"]
["Meysey Hampton Church of England Primary School","107714","Central School","Primary"]
["Mickleton Primary School","107717","Central School","Primary"]
["Miserden Church of England Primary School","107720","Central School","Primary"]
["Mitcheldean Endowed Primary School","107721","Central School","Primary"]
["Nailsworth Church of England Primary School","107724","Central School","Primary"]
["Naunton Park Primary School","107898","Central School","Primary"]
["North Nibley CofE Primary School","107731","Central School","Primary"]
["Northleach Church of England Primary School","107730","Central School","Primary"]
["Norton Church of England Primary School","107733","Central School","Primary"]
["Oakridge Parochial School","107735","Central School","Primary"]
["Oakwood Primary School","107900","Central School","Primary"]
["Park Junior School","107797","Central School","Primary"]
["Parkend Primary School","107743","Central School","Primary"]
["Pauntley Church of England Primary School","107749","Central School","Primary"]
["Picklenash Junior School","107726","Central School","Primary"]
["Pillowell Community Primary School","107558","Central School","Primary"]
["Prestbury St Mary's Church of England Junior School","107754","Central School","Primary"]
["Randwick Church of England Primary School","107759","Central School","Primary"]
["Redbrook Church of England Primary School","107769","Central School","Primary"]
["Rodborough Community Primary School","107763","Central School","Primary"]
["Rodmarton School","107764","Central School","Primary"]
["Ruardean Church of England Primary School","107765","Central School","Primary"]
["Sapperton Church of England Primary School","107771","Central School","Primary"]
["Sharpness Primary School","107775","Central School","Primary"]
["Sheepscombe Primary School","107776","Central School","Primary"]
["Shurdington Church of England Primary School","107779","Central School","Primary"]
["Slimbridge Primary School","107782","Central School","Primary"]
["Soudley School","107784","Central School","Primary"]
["Southrop Church of England Primary School","107787","Central School","Primary"]
["St Briavels Parochial Church of England Primary School","107769","Central School","Primary"]
["St John's Church of England Primary School","107906","Central School","Primary"]
["St Mary's Church of England Infant School","107768","Central School","Primary"]
["St Mark's Church of England Junior School",107907,"Central School","Primary"]
["St Paul's Church of England Primary School","107948","Central School","Primary"]
["St White's Primary School","107767","Central School","Primary"]
["Steam Mills Primary School","107793","Central School","Primary"]
["Stonehouse Park Infant School","107791","Central School","Primary"]
["Stow-on-the-Wold Primary School","107798","Central School","Primary"]
["Stratton Church of England Primary School","107800","Central School","Primary"]
["Stroud Valley Community Primary School","107803","Central School","Primary"]
["Temple Guiting Church of England School","107808","Central School","Primary"]
["Tewkesbury Church of England Primary School","107811","Central School","Primary"]
["The Altus",101520,"Central School","Alternative Provision"]
["The Croft Primary School","107742","Central School","Primary"]
["The John Moore Primary School","107812","Central School","Primary"]
["The Rissington School","107657","Central School","Primary"]
["The Shrubberies School","107139","Central School","Special"]
["Thrupp School","107818","Central School","Primary"]
["Tirlebrook Primary School",107830,"Central School","Primary"]
["Tredworth Junior School","107952","Central School","Primary"]
["Tutshill Church of England Primary School","107825","Central School","Primary"]
["Twyning School","107827","Central School","Primary"]
["Uley Church of England Primary School","107829","Central School","Primary"]
["Uplands Community Primary School","107805","Central School","Primary"]
["Walmore Hill Primary School","107837","Central School","Primary"]
["Warden Hill Primary School","107693","Central School","Primary"]
["Whitminster Endowed Church of England Primary School","107842","Central School","Primary"]
["Willersey Church of England Primary School","107845","Central School","Primary"]
["Withington Church of England Primary School","107851","Central School","Primary"]
["Woodchester Endowed Church of England Aided Primary School","107853","Central School","Primary"]
["Woodmancote School","107547","Central School","Primary"]
["Woodside Primary School","107766","Central School","Primary"]
["Woolaston Primary School","107852","Central School","Primary"]
["Yorkley Primary School","107862","Central School","Primary"]