{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["JE-AcctCorr_GL","ExceptionsRequest"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"JE-AcctCorr_GL","index":0,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[9,12,9,13],[11,9,14,11],[11,14,15,14],[11,1,11,2],[11,3,11,5],[10,3,10,5],[11,12,11,13],[12,12,13,13],[10,12,10,13],[5,1,5,2],[7,1,7,2],[9,1,9,2],[3,7,3,8],[5,7,7,8],[3,3,3,5],[25,8,25,9],[25,10,25,11],[0,1,0,2],[1,1,1,8],[1,9,1,14],[5,3,5,5],[3,9,3,11],[7,3,7,5],[9,3,9,5],[4,3,4,5],[8,3,8,5],[9,6,13,8],[12,3,15,5],[3,1,3,2],[5,9,7,11],[3,12,7,13]]}
["##","Today's Date: ",null,{"$f":"TODAY()","v":"2020-07-07"},null,null,null,null,null,null,null,null,null,null,true]
["##","CONTROLLER'S OFFICE JOURNAL ENTRY",null,null,null,null,null,null,null,"Email form to controller@udayton.edu. For questions, contact the Controller's Office at 9-2941."]
["##"]
["##","Budget Manager:",null,null,null,null,null,"Document Code:",null,{"$f":"B19","v":2107099},null,null,"For accounting corrections, enter the oldest transaction date of the transactions to be corrected in cell M10. Cell M12 will calculate whether your correction is past 90 days."]
["##"]
["##","Email Address:",null,null,null,null,null,"Document Type:"]
["##"]
["##","Phone Number:"]
["##"]
["##","Department:",null,null,null,null,"Document Description:",null,null,null,null,null,"2020-07-01"]
["##",null,null,null,null,null,null,null,null,null,null,null,"2019-06-10"]
["##","Control Total:   ",null,{"$f":"$K$25","v":435},null,null,null,null,null,"Test upload for new journal entry template",null,null,{"$f":"IF(M10=\"\",\"\",CONCATENATE(\"Your correction is\",\" \",D1-M10,\" days old\"))","v":"Your correction is 6 days old"},null,"Click on the red-bordered cells for instructions"]
["##",null,null,{"$f":"IF(K25<>L25,\"Try Again!  Total Debits MUST = Total Credits\",\"Debits and Credits are Currently In Balance\")","v":"Debits and Credits are Currently In Balance"},null,null,null,null,null,null,null,null,{"$f":"IF(M10=\"\",\"\",IF((D1-M10)>90,\"You Must Complete the Exceptions Request Form\",\"\"))","v":""}]
["##"]
["##"]
["##"]
["REC_TYPE","DOC_CODE","TRANS_DATE","COAS_CODE","FUND_CODE","ORGN_CODE","ACCT_CODE","PROG_CODE","ACTV_CODE","LOCN_CODE","DEBIT_AMT","CREDIT_AMT","TRANS_DESC","RUCL_CODE","REC_COUNT"]
[1,2107099,20200731]
[2,2107099,null,"F","BK0000",999990,100001,999999,999999,999999,10,null,"New JV Template Test File","FT01"]
[2,2107099,null,"F",100000,999990,125100,999999,999999,999999,null,10,"New JV Template Test File","FT01"]
[2,2107099,null,"F","BK0000",999990,100001,999999,999999,999999,150,null,"New JV Template Test File","FT01"]
[2,2107099,null,"F",100000,999990,125100,999999,999999,999999,null,150,"New JV Template Test File","FT01"]
[2,2107099,null,"F","BK0000",999990,100001,999999,999999,999999,275,null,"New JV Template Test File","FT01"]
[2,2107099,null,"F",100000,999990,125100,999999,999999,999999,null,275,"New JV Template Test File","FT01"]
["3",2107099,null,null,null,null,null,null,null,null,{"$f":"SUM(K18:K24)","v":435},{"$f":"SUM(L18:L24)","v":435},null,null,{"$f":"COUNT(K18:L24)","v":6}]
["##",null,null,null,null,null,null,null,"Imbalance",null,{"$f":"L25-K25","v":0}]

{"sheet":"ExceptionsRequest","index":1,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[47,0,49,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[42,0,42,9],[37,8,37,9],[39,8,39,9],[37,6,37,7],[39,6,39,7],[41,8,41,9],[37,2,37,5],[39,2,39,5],[37,0,37,1],[39,0,39,1],[23,0,31,9],[0,0,0,9],[2,6,2,8],[4,0,5,9],[2,1,2,3],[12,0,20,9]]}
["CONTROLLER'S OFFICE JOURNAL ENTRY EXCEPTIONS REQUEST FORM"]
[]
["Form #",{"$f":"'JE-AcctCorr_GL'!$J$4","v":2107099},null,null,null,"Date",{"$f":"+'JE-AcctCorr_GL'!D1","v":"2020-07-07"}]
[]
["REQUEST FOR EXEMPTION FROM 90 DAY RULE"]
[]
[]
["No need to send form through Campus Mail.  Submit via email to controller@udayton.edu."]
["Answer the following questions:"]
[]
["1)  Accounting corrections over 90 days old are not processed by the Division of Finance.  What unusual "]
["circumstances exist that justify exception from this 90 day rule?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2)  What action will be taken to eliminate future need for corrections of this type?  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I certify that the cost to be corrected is an appropriate expenditure for the department, grant, or contract charged."]
["The expenditure complies with University policy and with any terms and restrictions governing any sponsored"]
["grant or contract involved."]
[]
["Budget Manager",null,null,null,null,null,"Department"]
[]
["Phone Number",null,null,null,null,null,"Email address"]
[]
[]
["Finance Area Use Only"]
[]
[null,"Approve",null,"Disapprove"]
[null,null,null,null,null,"Signature                                                                    Date"]
["Comments:"]