{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["template","tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":"template","index":0,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[31,1,31,13],[2,3,2,5],[3,3,3,5]]}
["Journal Entry Template"]
[]
["Transaction Group:"]
["Transaction Type:",null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(transaction_type,t_comments,2,FALSE),\"\")","v":""}]
[]
[null,null,"Correcting JE Original Entry Search Parameters:",null,null,null,null,"Correcting Voucher JE Original Entry Search Parameters:"]
[null,null,"Business Unit",null,null,null,null,"Business Unit"]
[null,null,"Fund Code",null,null,null,null,"Voucher ID"]
[null,null,"Fund Source",null,null,null,null,"Related Voucher ID"]
[null,null,"Department",null,null,null,null,"Invoice Number"]
[null,null,"Journal ID",null,null,null,null,"Invoice Date"]
[null,null,"From Date",null,null,null,null,"Vendodr ID"]
[null,null,"To Date",null,null,null,null,"Vendor Name (Name 1)"]
[null,null,"Source",null,null,null,null,"Voucher Line Number"]
[null,null,"Amount",null,null,null,null,"Amount"]
[]
[null,"Line #","Unit","Amount","Fund","Source","Account","Dept","PC Bus Unit","Project ID","Activity","Cost Code 1","Cost Code 2","Cost Code 3"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[null,null,"Balance",{"$f":"SUM(D18:D27)-D15-J15","v":0},{"$f":"IF(balance<>0,\"Please ensure journal balances\",\"\")","v":""}]
[]
[null,"Comments: In order to enter comments, you need to attach a document to your journal."]

{"sheet":"tables","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["i_type/ t_type",null,null,"t_comments"]
["Billing","t_billing","t_billing","Billing","To invoice another campus department (e.g. for recharge center services rendered.)"]
["Correcting JE","t_correctingJE","t_correctingJE","Correcting JE","To correct General Journals entered in ConnectCarolina or any transaction converted from FRS"]
["Correcting Voucher JE","t_correctingvoucherJE","t_correctingvoucherJE","Correcting Voucher JE","To correct Vouchers created in ConnectCarolina (includes ePro, Purchase Orders, WebTravel)"]
["Deposits & Accounts Receivable","t_deposits","t_deposits","Department One Card Deposit","Department One Card Deposit"]
["Office of Sponsored Research","t_OSR",null,"Departmental One Card Purchase","Departmental One Card Purchase"]
["Other Campus JE","t_other",null,"Print Plan Deposit","Print Plan Deposit"]
["Trust & Special Funds Transfer","t_trust","t_OSR","Residual Funds Transfer","To transfer surplus funds from an OSR project into residuals fund"]
[null,null,"t_other","Other Campus JE-INTERUnit","(Generally not used) Freeform journal between business units (e.g. between UNCCH and CHPHF)"]
[null,null,null,"Other Campus JE-INTRAUnit","(Depts should use this one) Freeform journal within a single business unit (e.g. UNCCH)"]
[null,null,"t_trust","Agency End Income to Principal","To transfer funds from agency endowment income to principal "]
[null,null,null,"Fdn Allocation to University","Foundation allocation to university"]
[null,null,null,"Gift to Gift","To transfer from an expendable gift to another expendable gift"]
[null,null,null,"Univ Endow Income to Income","To transfer university endowment income to another income fund"]
[null,null,null,"Univ Endow Income to Principal","To transfer university endowment income to principal"]