{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Deposit Form","Addt'l GL Accts","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Deposit Form","index":0,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[[13,1,13,3],[13,5,13,8],[14,1,14,3],[1,5,1,10],[16,11,16,12],[2,6,2,9],[16,1,16,3],[10,10,10,12],[8,10,8,12],[25,2,25,3],[26,2,26,3],[31,2,31,3],[41,4,41,5],[27,2,27,3],[32,2,32,3],[33,2,33,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[17,1,17,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[55,4,55,5],[6,11,6,12],[6,4,6,7],[8,4,8,7],[10,4,10,7],[45,11,45,12],[40,11,40,12],[17,11,17,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[13,11,13,12]]}
[]
[null,null,null,null,null,"Departmental Deposit Form",null,null,null,null,null,null,"Office Use Only"]
[null,null,null,null,null,null,"Office of the Bursar - NIU",null,null,null,null,"Receipt No: "]
[null,null,null,null,null,null,null,null,null,null,null,"Initials: ",""]
[]
[]
[null,null,null,"Department:  ",null,null,null,null,null,null,"Date:  "]
[]
[null,null,null,"Prepared By:  ",null,null,null,null,null,"Phone:  "]
[]
[null,null,null,"Signature:  ",null,null,null,null,null,"Email Address:  "]
[null,null,null,null,null,null,null,null,null,"(For receipt copy)     "]
[]
[null,"Dep. Description:",null,null,null,"",null,null,null,null,"Department:"]
[null,"(30 characters max)",null,null,null,null,null,null,null,null,"(i.e. AA00000)"]
[]
[null,"Service Period:",null,null,null,"",null,null,null,""]
[null," (e.g. FY18, FY19 or FY20) "]
[]
[null,"G/L ACCOUNT INFO"]
[]
[null,null,"Speed Type",null,null,"Account","Department","Project/","Fund","Class","Cost Center",null,"Amount"]
[null,null,"(if applicable)",null,null,"(six digit)","(i.e. AA00000)","Grant","(two digit)","(i.e. 01E)","(i.e. AA12345)"]
[null,1,null,null,null,"","","","","",""]
[null,2,null,null,null,"","","","","",""]
[null,3,null,null,null,"","","","","",""]
[null,4,null,null,null,"","","","","",""]
[null,5,null,null,null,"","","","","",""]
[null,6,null,null,null,"","","","","",""]
[null,7,null,null,null,"","","","","",""]
[null,8,null,null,null,"","","","","",""]
[null,9,null,null,null,"","","","","",""]
[null,10,null,null,null,"","","","","",""]
[null,null,null,null,null,null,"",null,null,null,null,"Addt'l G/L Subtotal:",{"$f":"IF(OR('Addt''l GL Accts'!M52=\"\", 'Addt''l GL Accts'!M52=0),\"\",'Addt''l GL Accts'!M52)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total G/L:",{"$f":"SUM(M24:M34)","v":0}]
[]
[]
[null,"TENDER DETAIL"]
[]
[null,null,"Cash Summary",null,null,null,null,null,null,"Tender Detail"]
[null,null,null,"#","Amount",null,null,null,null,null,"#","Amount"]
[null,null,100,null,null,{"$f":"IF(OR(D43=\"\", D43=0),\"\",D43*100)","v":""},null,null,null,"Cash","see left column",{"$f":"E56","v":0}]
[null,null,50,null,null,{"$f":"IF(OR(D44=\"\", D44=0),\"\",D44*50)","v":""},null,null,null,"Checks"]
[null,null,20,null,null,{"$f":"IF(OR(D45=\"\", D45=0),\"\",D45*20)","v":""},null,null,null,null,"TOTAL"]
[null,null,10,null,null,{"$f":"IF(OR(D46=\"\", D46=0),\"\",D46*10)","v":""},null,null,null,null,"Tender:",{"$f":"SUM(L43:L44)","v":0}]
[null,null,5,null,null,{"$f":"IF(OR(D47=\"\", D47=0),\"\",D47*5)","v":""}]
[null,null,2,null,null,{"$f":"IF(OR(D48=\"\", D48=0),\"\",D48*2)","v":""}]
[null,null,1,null,null,{"$f":"IF(OR(D49=\"\", D49=0),\"\",D49)","v":""}]
[null,null,"50¢",null,null,{"$f":"IF(OR(D50=\"\", D50=0),\"\",D50*0.5)","v":""}]
[null,null,"25¢",null,null,{"$f":"IF(OR(D51=\"\", D51=0),\"\",D51*0.25)","v":""}]
[null,null,"10¢",null,null,{"$f":"IF(OR(D52=\"\", D52=0),\"\",D52*0.1)","v":""}]
[null,null,"5¢",null,null,{"$f":"IF(OR(D53=\"\", D53=0),\"\",D53*0.05)","v":""}]
[null,null,"1¢",null,null,{"$f":"IF(OR(D54=\"\", D54=0),\"\",D54*0.01)","v":""}]
[null,null,null,"Total"]
[null,null,null,"Cash:",{"$f":"SUM(F43:F54)","v":0}]
[]
[]
[null,null,null,{"$f":"IF(M36 <> L46, \"**GL AMOUNT DOES NOT EQUAL TENDER AMOUNT!!!**\", \" \")","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVISION OF ADMINISTRATION AND FINANCE"]

{"sheet":"Addt'l GL Accts","index":1,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,11,5,12],[5,4,5,8],[28,2,28,3],[27,2,27,3],[26,2,26,3],[25,2,25,3],[24,2,24,3],[23,2,23,3],[22,2,22,3],[13,2,13,3],[10,2,10,3],[11,2,11,3],[19,2,19,3],[49,2,49,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[30,2,30,3],[29,2,29,3],[47,2,47,3],[21,2,21,3],[40,2,40,3],[39,2,39,3],[18,2,18,3],[38,2,38,3],[42,2,42,3],[41,2,41,3],[20,2,20,3],[48,2,48,3],[46,2,46,3],[45,2,45,3],[44,2,44,3],[43,2,43,3],[1,5,1,10],[2,5,2,10],[12,2,12,3],[37,2,37,3],[36,2,36,3],[35,2,35,3],[34,2,34,3],[33,2,33,3],[32,2,32,3],[31,2,31,3],[8,2,8,3],[9,2,9,3]]}
[]
[null,null,null,null,null,"Departmental Deposit Form"]
[null,null,null,null,null,"Office of the Bursar - NIU",null,null,null,null,null,null,""]
[]
[]
[]
[null,"ADDITIONAL G/L ACCOUNT INFO"]
[]
[null,null,"Speed Type",null,null,"Account","Department","Project/","Fund","Class","Cost Center",null,"Amount"]
[null,null,"(if applicable)",null,null,"(six digit)","(i.e. AA00000)","Grant","(two digit)","(i.e. 01E)","(i.e. AA12345)"]
[null,11,null,null,null,"","","","","",""]
[null,12,null,null,null,null,null,"",""]
[null,13,null,null,null,null,null,"",""]
[null,14,null,null,null,null,"","",""]
[null,15,null,null,null,null,null,"",""]
[null,16,null,null,null,null,null,"",""]
[null,17,null,null,null,null,null,"",""]
[null,18,null,null,null,null,"","",""]
[null,19,null,null,null,null,null,"",""]
[null,20,null,null,null,null,null,"",""]
[null,21,null,null,null,null,null,"",""]
[null,22,null,null,null,null,null,"",""]
[null,23,null,null,null,null,null,"",""]
[null,24,null,null,null,null,null,"",""]
[null,25,null,null,null,null,null,"",""]
[null,26,null,null,null,null,null,"",""]
[null,27,null,null,null,"",null,"",""]
[null,28,null,null,null,null,null,"",""]
[null,29,null,null,null,null,null,"",""]
[null,30,null,null,null,null,null,"",""]
[null,31,null,null,null,null,null,"",""]
[null,32,null,null,null,null,null,"",""]
[null,33,null,null,null,null,null,"",""]
[null,34,null,null,null,null,null,"",""]
[null,35,null,null,null,null,null,"",""]
[null,36,null,null,null,null,null,"",""]
[null,37,null,null,null,null,null,"",""]
[null,38,null,null,null,null,null,"",""]
[null,39,null,null,null,null,null,"",""]
[null,40,null,null,null,null,null,"",""]
[null,41,null,null,null,null,null,"",""]
[null,42,null,null,null,null,null,"",""]
[null,43,null,null,null,null,null,"",""]
[null,44,null,null,null,null,null,"",""]
[null,45,null,null,null,null,null,"",""]
[null,46,null,null,null,null,null,"",""]
[null,47,null,null,null,null,null,"",""]
[null,48,null,null,null,null,null,"","",""]
[null,49,null,null,null,null,null,"",""]
[null,50,null,null,null,null,null,"",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M11:M50)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVISION OF ADMINISTRATION AND FINANCE"]

{"sheet":"Instructions","index":2,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,1,13,11],[15,1,15,11],[19,1,19,11],[30,1,30,11]]}
["Instructions"]
[]
["General Information Section"]
[1,"Fill out the top portion of the form with your Department Name, Date, Preparer, and contact phone number."]
[]
[2,"Fill out the Description as you would like it on the receipt (you are limited to 30 characters)"]
[]
[3,"Type in your Department ID in the format provided.  If not known, please contact the Accounting Office or HR."]
[]
[4,"Enter the fiscal year of the service period for this deposit."]
[]
["G/L Account Info Section"]
[4,"Enter the G/L account information."]
[null,"If you have a 10-character speed type from the Bursar's Office, enter it in the Speed type column.  Note: You do not need to enter any of the G/L information to the right of the speed type."]
[]
[null,"If you do not have a speed type, leave the Speed type column blank.  You must, then, enter the appropriate G/L information to the right of the speed type column.  This includes Account Numer, Department, Fund, Class, and Cost Center."]
[]
[5,"Enter the dollar amount $$ (in the Amount column) to be deposited into the specified G/L account."]
[]
[6,"Repeat steps 4 and/or 5 if you have multiple G/L entries.  Note: If you require more than 10 G/L entries, you must use the \"Addt'l GL Accts\" tab below."]
[]
[]
["Tender Detail Section"]
[7,"Enter the count # for each tender (cash and/or check) in the Cash Summary and Tender Details areas."]
[]
[null,"Note: The total tender to be deposited must equal the total amounts in the G/L Account Info Section."]
[]
[]
[8,"Print the page(s)"]
[]
[null,"Please Note:  If your department requires a signed copy of this deposit form in addition to the printed receipt that you will receive, then you must print an additional copy.  The Cashiering Office must keep the original copy for reconciling purposes."]
[]
[9,"Sign the form"]