{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Waived Fee Release","Example","Journal entry","Expired Fees Journal","5.5 Opening balance rec"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"comments":1,"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":"Waived Fee Release","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Waived Fee Release",null,null,null,"Instructions :"]
[{"$nulls":4},"1. Enter your Name and College in Cells B3 and B4."]
["Name:","G Oneill",null,null,"2. Start completing your waived fee transfers in Cell A14 beginning with the period in which you want the transfer to happen. Complete all highlighted cells within this row. "]
["College:","US",null,null,"3. Complete additional lines as required."]
["School:",901,null,null,"4. Ensure that all monetary values are to no more than 2 decimal places. "]
["Extension:",9999,null,null,"5. Ensure that journal total nets off to nil.  "]
[{"$nulls":4},"6. Ensure that you have used the correct sub project numbers and that sub projects are currently active."]
[{"$nulls":4},"8. E-mail completed template to mailto:finance-mact@glasgow.ac.uk"]
[]
[]
[]
["Period","Account","Sub Project","Waived Fee Description","Amount"]

{"sheet":"Example","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Waived Fee Release",null,null,null,"Instructions :"]
[{"$nulls":4},"1. Enter your Name and College in Cells B3 and B4."]
["Name:","G Oneill",null,null,"2. Start completing your waived fee transfers in Cell A14 beginning with the period in which you want the transfer to happen. Complete all highlighted cells within this row. "]
["College:","US",null,null,"3. Complete additional lines as required."]
["School:",901,null,null,"4. Ensure that all monetary values are to no more than 2 decimal places. "]
["Extension:",9999,null,null,"5. Ensure that journal total nets off to nil.  "]
[{"$nulls":4},"6. Ensure that you have used the correct sub project numbers and that sub projects are currently active."]
[{"$nulls":4},"8. E-mail completed template to mailto:finance-mact@glasgow.ac.uk"]
[]
[]
[]
["Period","Account","Sub Project","Waived Fee Description","Amount"]
[201305,17608,"402890-01","Waived fee - F Smith - 64707",599.75]
[201305,8240,"459810-01","Waived fee - F Smith - 64707",-599.75]

{"sheet":"Journal entry","index":2,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,"Journal Entry Sheet"]
[]
[null,"Transaction No",{"$nulls":10},"Transaction",{"$nulls":4},"Control Totals:",null,"Net (£0)",0]
[null,"Number",{"$nulls":10},"Date",{"$nulls":4},"Debit total",1499.88,"Credit Total",-1499.88]
[null,"Line",null,"Account",null,null,null,"Project ",{"$nulls":4},"Fac Ref 1*",{"$nulls":6},"Debit","Credit"]
[null,"No",null,"Number",{"$nulls":15},"Amount","Amount"]
[{"$nulls":19},"£","£","resno"]
[null,1,1,7,6,0,8,4,0,2,9,0,"Description",{"$nulls":6},1499.88]
[null,null,7,1,7,0,null,1,3,0,9,4,"Description",{"$nulls":7},-1499.88]
[]
[null,2,1,7,6,0,8,4,0,2,9,0,"Description"]
[{"$nulls":12},"Description",{"$nulls":7},0]
[]
[null,3,{"$nulls":10},"Description"]
[{"$nulls":12},"Description",null,0,{"$nulls":5},0]
[]
[null,4,{"$nulls":10},"Description"]
[{"$nulls":12},"Description",null,0,{"$nulls":5},0]
[]
[null,5,{"$nulls":10},"Description"]
[{"$nulls":12},"Description",null,0,{"$nulls":5},0]
[{"$nulls":12},"Description"]
[]
[null,"Signature ",{"$nulls":17},"Date: ","2015-06-22"]
[null,"Please print name",{"$nulls":12},"Dawn Buchanan"]

{"sheet":"Expired Fees Journal","index":3,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,"Journal Entry Sheet"]
[]
[null,"Transaction No",{"$nulls":10},"Transaction",{"$nulls":4},"Control Totals:",null,"Net (£0)",0]
[null,"Number",{"$nulls":10},"Date","2015-06-22",null,null,null,"Debit total",0,"Credit Total",0]
[null,"Line",null,"Account",null,null,null,"Project ",{"$nulls":4},"Fac Ref 1*",{"$nulls":6},"Debit","Credit"]
[null,"No",null,"Number",{"$nulls":15},"Amount","Amount"]
[{"$nulls":19},"£","£"]
[null,1,1,7,6,0,8,4,0,2,9,0,"Description"]
[null,null,8,2,4,0,null,3,5,9,1,1,"Description",{"$nulls":6},0,0]
[]
[null,3,{"$nulls":10},"Description"]
[{"$nulls":12},"Description",{"$nulls":6},0,0]
[]
[null,4,{"$nulls":10},"Description"]
[{"$nulls":12},"Description",{"$nulls":6},0,0]
[]
[null,5,{"$nulls":10},"Description"]
[{"$nulls":12},"Description",{"$nulls":6},0,0]
[]
[null,"Signature ",{"$nulls":17},"Date: ","2015-06-22"]
[null,"Please print name",{"$nulls":12},"Dawn Buchanan"]

{"sheet":"5.5 Opening balance rec","index":4,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Opening Balance Agresso 5.5"]
[]
["Faculty","TT","TransNo","tra/inv date","Period","Account","Costc","Project","TC",null,"Text","Amount"]
["CMED","OB",5400000036,"2006-08-01",200700,2260,91103,40290,0,null,"OPENING BALANCE 1/8/06",-41937.03]
[]
[]
["Waived fees released from opening balance only 05/06"]
[]
["Faculty","TT","TransNo","tra/inv date","Period","Account","Costc","Project","TC",null,"Text","Amount"]
["CMED","GL",3000002876,"2006-12-11",200704,2280,91103,40290,0,null,"WAIVED FEES T MCMILLAN TRS TO 13094",2624]
["CMED","GL",3000006959,"2007-04-17",200709,2280,91103,40290,0,null,"A BRIGGS WAIVED FEE 010606 TO 14905",1718]
["CMED","GL",3000008537,"2007-05-25",200710,2280,91103,40290,0,null,"C Hankey Waived Fee Trs to 10133",990]
["CMED","GL",3000010676,"2007-07-13",200712,2280,91103,40290,0,null,"Prof J McMurray waived fee 200706 trs to 39082",11826.64]
["CMED","GL",3000010676,"2007-07-13",200712,2280,91103,40290,0,null,"Prof J McMurray waived fee 260706 trs to 39082",9211.08]
[{"$nulls":11},26369.72]
[]
[{"$nulls":10},"Dept 913 Agreement to trs Aug07 PMF CM0976",13800]
[]
[{"$nulls":10},"Balance",-1767.3099999999977]
[]
[]
["History Agresso 5.4"]
[]
["T","TT","TransNo","Tra/Inv date","Period","Account","Dept","Budcent","TC","Cat3","Text","Amount"]
["B","AC",63112140,"2006-05-23",200610,4112,"BSH","BALSH",0,"A1299","waived fee T Mcmillan 186428 FR5661 from bc 38386",-2624]
["B","GF",63112215,"2006-06-01",200611,4112,"BSH","BALSH",0,"A1299","Waived Fee A Briggs 220097 from 38745",-1718.31]
["B","GF",63112216,"2006-06-01",200611,4112,"BSH","BALSH",0,"A1299","Waived Fee C Hankey FR6268 (135862) from 27382",-660]
["B","GF",63009083,"2006-07-03",200612,4112,"BSH","BALSH",0,"A1299","TRANS OF PROF LOWE FEE WAIVERS FROM 913 18790",-13800]
["B","GF",63112493,"2006-07-04",200612,4112,"BSH","BALSH",0,"A1299","Waived Fee C Hankey FR6358 from 27382",-330]
["B","GF",63112635,"2006-07-20",200612,4112,"BSH","BALSH",0,"A1299","waive fee j mcmurray FR6279 consult from bc 39018",-11826.64]
["B","GF",63112662,"2006-07-26",200612,4112,"BSH","BALSH",0,"A1299","Waived Fee J McMurray from bc 39018",-9211.08]
["B","GF",63112697,"2006-07-28",200612,4112,"BSH","BALSH",0,"A1299","Secwork waived J Finlayson from 36262",-1767,"Trs to 916 13094"]
["B","CR",64043279,"2006-07-31",200612,4112,"BSH","BALSH",0,"A1299","andrew briggs-consultancy fee",-1341.2]
["B","GF",63200661,"2006-09-04",200613,4112,"BSH","BALSH",0,"A1299","Trs Andrew Briggs Consultancy fee to correct budce",1341.2]
[]
[{"$nulls":11},-41937.03]
[]
[]
[null,null,null,"30/08/2007 email sent to John for general funds project to trs outstanding waived fees"]