{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BneLog","BneWorkBookProperties","Instructions","Journal"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":27,"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":"BneLog","index":0,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Date","Time","Log Level","Source","Description","Action"]
["2015-09-16","13:59:44","ERROR","Workbook_Activate","Error: 438 Object doesn't support this property or method"]
["2015-09-16","14:12:29","ERROR","Workbook_Activate","Error: 438 Object doesn't support this property or method"]
["2015-09-16","14:13:21","ERROR","Workbook_Activate","Error: 438 Object doesn't support this property or method"]
["2015-09-16","14:13:21","ERROR","Workbook_Activate","Error: 438 Object doesn't support this property or method"]
["2015-09-16","14:14:16","ERROR","Workbook_Activate","Error: 438 Object doesn't support this property or method"]

{"sheet":"BneWorkBookProperties","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions","index":2,"n_rows":69,"n_cols":2,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[]
["The GL Journal template may be used to record transactions or corrections to GL directly. Examples of transactions posted via this journal are Approved \nTransfers, corrections of CORE receipts between object codes or accounts, inter-departmental revenue."]
[]
[]
["Cell Reference","Action"]
["Macros","Enable the macros by clicking Enable Content; and YES on the message 'Do You want to make this file a Trusted Document?'… Refer to screen shot below"]
["G9","Enter Accounting Date (Double click to select from calendar)"]
["K4","Enter Your Name as preparer of the journal"]
["K5","Enter the Date you are requesting the journal to be posted in GL"]
["K6, K7 & K8","To be completed by Accounting staff"]
["C16  thru H16","This is the beginning of the body for your balanced journal (replace values from example journal):"]
[null,"    > Enter the segment account values for your Journal (i.e., fund, funding source, etc.)"]
["I13","Enter the amount for the debit (charge)"]
["J13","Enter the amount for the credit"]
["C13","Contains a flag to allow the upload to Oracle G; copy this down to fill your journal lines"]
["Body of JE","Add additional rows as needed within the body of the journal; before you reach the Totals row"]
[]
["Save File","Save the file as a macro; refer to the third screen shot below.  The macro file version will allow Accounting to upload to Oracle."]
[]
["Routing","Once completed, validate all lines, and email to the Accounting Office for processing.  Your email to Accounting should include any support documentation you want uploaded to Oracle."]
[]
[]
[]
["Screen shot for Security Alert:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Save File","From the Office button, select Save As, and Excel Macro-Enabled Workbook. "]

{"sheet":"Journal","index":3,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,5],[3,6,3,8],[5,1,5,4],[5,6,5,8],[6,1,6,4],[6,6,6,8],[7,1,7,4],[7,6,7,8],[8,1,8,4],[8,6,8,8],[11,2,11,7]]}
[]
["CC-LDBORAC3.UTPA.MGMT.NEB","UTPA Accounting Flexfield","UTPA SET OF BOOKS","UTRGV Data Access"]
[]
[null,"Balance Type",null,null,null,null,"Actual",null,null,"Prepared By:"]
[null,null,null,null,null,null,null,null,null,"Date Prepared:"]
[null,"Source",null,null,null,"* List - Text","Spreadsheet",null,null,"Approved By:"]
[null,"Category",null,null,null,"* List - Text","UTRGV Journal",null,null,"Date Approved:"]
[null,"Currency",null,null,null,"* List - Text","USD",null,null,"GL Batch Date: "]
[null,"Accounting Date",null,null,null,"* List - Date"]
[]
[null,"Upl","Fund","Funding Source","Organization","Project","Object","Future","Debit","Credit","Line Description",null,null,"Messages"]
[null,null,"* List - Text",null,null,null,null,null,"* Number","* Number","Text"]
[null,"O","31","A6500",73350,365000010,43905,0,50,null,"Example "]
[null,"O","31","A6500",73350,365000010,43910,0,null,50,"Example "]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,""]
[null,"Totals:",null,null,null,null,null,null,{"$f":"SUM(I13:I22)","v":50},{"$f":"SUM(J13:J22)","v":50}]
[null,"Tip: This is not the end of the Template.  Unprotect the sheet and insert as many rows as needed."]