{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions-LoadedToMPathways","Data","Errors","Print View","Local Variables","ErrorCodes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"comments":1,"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":"Instructions-LoadedToMPathways","index":0,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,4,24,8],[2,1,2,9],[5,3,5,9],[10,4,10,8],[3,1,3,9],[12,1,13,1]]}
[]
[]
[null,"Journal Upload Procedures:"]
[]
[]
[null,"Step 1",null,"~Open the Excel upload loader file located on Financial Services website."]
[null,null,null,"~When prompted select ' Enable Macros', this will enable you to use the features of the template for creating a load file (*.dat file type)."]
[]
[null,"Step 2",null,"~Begin the journal by completing the Journal Header information on the first available row in the Excel upload template (Row 3).  Please note that the grayed area should not be filled. "]
[]
[null,null,null,"Column Name","Field Instructions",null,null,null,null,"Sample Content"]
[null,null,null,"Record Type:      (H)  ","This field tells the loader program that the row contains either header information (H) or line information (L).  For the header, we populate the field with the letter 'H'.",null,null,null,null,"H"]
[null,"Required fields are in bold",null,"Journal ID","Contact DbnAccounting@umich.edu for a Journal ID.",null,null,null,null,"JUDBxxxxxx"]
[null,null,null,"Journal Date","The date of the journal transaction in MM/DD/CCYY format. This date should be for the current open period.",null,null,null,null,"2008-02-08"]
[null,null,null,"Source","A code used to identify the source of the Journal Entry. Dearborn source is DBN.",null,null,null,null,"DBN"]
[]
[null,null,null,"Transaction Reference Number","A 10 character alphanumeric value representing a user defined reference to the transaction. ",null,null,null,null,"PCARD"]
[null,null,null,"Journal Description","A description of the journal transaction.  This line allows 254 characters.  ",null,null,null,null,"Tsf Lab Supplies to correct transposition error."]
[null,null,null,"Journal Requester Uniqname","This is the uniqname of the person that requested the journal entry and can answer questions regarding this Journal.",null,null,null,null,"mmmi"]
[]
[null,"Step 3",null,"~Continue to the next available row in the Excel upload template (Row 4).  For each line of the journal  entry, you have to place a 'L' for line in column A and complete a new row according to the field instructions below. Please note that the gray area should not be filled."]
[]
[]
[]
[null,null,null,"Column Name","Field Instructions",null,null,null,null,"Sample Content"]
[null,null,null,"Record Type: (L)","This field tells the loader program that the row contains either header information (H) or line information (L).  For each line, populate the field with the letter 'L'.",null,null,null,null,"L"]
[null,"Required fields are in bold",null,"Account","A code used to record and summarize financial transactions such as assets, liabilities, fund balances, revenues, expenses, statistics or budget accounts.",null,null,null,null,616650]
[null,null,null,"Fund Code","A code used to identify the source of funds and intended use of the funds.",null,null,null,null,52000]
[null,null,null,"Department","A code that identifies each academic or administrative unit that has programmatic, operational and fiscal (including budgetary) responsibility.",null,null,null,null,688180]
[null,null,null,"Program Code","A code identifying a group of related activities, cost centers, revenue centers, responsibility centers and academic programs.  These activities may occur within a single department or across multiple departments.",null,null,null,null,13321]
[null,null,null,"Class","A code used to group related activities directed towards the accomplishment of a set of common identifiable objectives or purposes.",null,null,null,null,92320]
[null,null,null,"Project/Grant","A code used to accumulate financial information on a set of activities over a limited time span.  Used for contracts and grants, construction projects and unit-defined projects.",null,null,null,null,"C459157"]
[null,null,null,"Monetary Amount","The dollar amount associated with a financial transaction or chart of account balance.",null,null,null,null,7404.35]
[null,null,null,"Journal Line Reference","A 10 character alpha numeric reference for a journal line assigned by a user.",null,null,null,null,"P1234567"]
[null,null,null,"Line Description","A textual description of the journal line. Cannot be more than 30 characters.",null,null,null,null,"Tsf PCD1234567 12/07"]
[]
[null,"Step 4 - Multiple Journals",null,"~For Multiple Journals, simply start the next journal under the previous one by placing a 'H' and following it with the 'L' s for the lines you have. There is no limit to how many Journals you have on one file."]

{"sheet":"Data","index":1,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,7,0,16]]}
[null,"HEADER(S)",null,null,null,null,null,"LINE(S)"]
["Record Type \n(H or L)","Journal ID","Journal Date","Source","Transaction Reference Number","Journal Description","Journal Requester Uniqname","Account","Fund","Department","Program","Class","Project/Grant","Monetary Amount","Journal Line Reference","Line Description","Stat Amount"]
["H",null,{"$f":"NOW()","v":"2026-04-08T15:40:57.890"},"DBN"]
["L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Errors","index":2,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Validation Results",null,null,null,{"$f":"NOW()","v":"2026-04-08T15:40:57.890"}]
[null,"Error Code","Error Description","Error Type","Cell Value","Cell Address"]

{"sheet":"Print View","index":3,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[10,4,11,14]]}
[]
[null,"Control Record:"]
[null,null,null,null,"Journal Lines:",2,null,null,10000,null,-10000,null,null,"Journal Author:","seglinto"]
[null,null,null,null,null,null,null,null,"Total Debits",null,"Total Credits"]
[null,"Header:"]
[]
[null,null,"Journal ID:",null,"",null,null,"Journal Date:","2026-04-07T14:50:57.950",null,"Source:","FO",null,"Authorization:"]
[]
[null,null,"Transaction Reference:"]
[]
[null,null,"Description:",null,"khines: recharge expense"]
[]
[null,null,"This document represents a draft version of the journal entry.  For a final, posted version of this journal entry, obtain a printed version from M-Pathways or the Datawarehouse."]
[null,"Lines:"]
[null,null,null,"Account","Fund","DeptID","Program","Class","Project/Grant",null,"Monetary Amount","Journal Line Reference","Line Description",null,"Stat Amount"]
[null,null,1,"410000","52000","688180","RCHRG","92320","U012356",null,-10000,"","Recharge expense",null,0]
[null,null,2,"615560","10000","688100","10000","62000","U051272",null,10000,"","Recharge expense",null,0]

{"sheet":"Local Variables","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["User Information:"]
["Uniqname:","dhovey"]
["Phone Number:","647-3499"]
[]
[]
["File Information:"]
["Import File Location:","\\\\its-users.m.storage.umich.edu\\its-users\\HomeFolders\\jeffgree\\Desktop\\BCjournal_upload.dat"]
[]
["Control Debits",{"$f":"SUMIF(JournalAmounts, \">0\")","v":0}]
["Control Credits",{"$f":"SUMIF(JournalAmounts, \"<0\")","v":0}]
["Header Count",{"$f":"COUNTIF(Data!$A$3:$A$65536,\"H\")","v":1}]
["Line Count",{"$f":"COUNTIF(Data!$A$3:$A$65536,\"L\")","v":2}]

{"sheet":"ErrorCodes","index":5,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Error Code","Error Description","ErrorType","Tip"]
[100,"Invalid Journal ID","Critical","A valid Journal ID is 10 characters in length or 'NEXT'"]
[110,"Invalid Journal Date","Critical","Enter a valid date in MM/DD/CCYY format"]
[120,"Excess Field Length","Warning","Field length exceeds maximum allowed"]
[130,"Journal Unbalanced","Critical","Journal debits must equal journal credits"]
[140,"Journal ID and Journal Date Duplicated","Critical","Journal id and date must be a unique combination"]
[150,"Journal Description is required","Critical","Enter a complete description of the journal entry"]
[160,"Journal Unbalanced","Warning","Journal debits do not equal journal credits"]
[200,"Invalid Field Length","Critical","Account value must be 6 numeric characters or 'SHR'"]
[210,"Invalid Field Length","Critical","Fund Code value must be 5 numeric characters"]
[220,"Invalid Field Length","Critical","Department value must be equal to 6 characters"]
[230,"Invalid Field Length","Critical","Program Code value must be 5 characters in length"]
[240,"Invalid Field Length","Critical","Class value must be 5 character in length"]
[250,"Invalid Field Length","Critical","Project/Grant must be between 7 and 15 characters"]
[260,"Invalid Monetary Amount","Critical","Monetary Amount must be a valid numeric amount"]
[270,"Invalid Monetary Amount","Critical","If Account is 'SHR', Monetary Amount must be $0"]
[280,"Invalid Statistics Amount","Critical","If Acct is 'SHR', Stat Amt must be valid numeric amt"]
[290,"Invalid Field Length","Critical","Source must be 2 or 3 characters in length"]
[300,"Invalid Fund/Project Combination","Critical","Fund Codes 20000 and 25000 require a valid P/G"]
[310,"Invalid Field Length","Critical","Transaction Reference Number has a max length of 8"]
[320,"Invalid Field Length","Critical","Journal Authorizer (uniqname) has a max length of 8"]
[330,"Invalid Field Length","Warning","Journal Line Reference has a max length of 10."]
[340,"Invalid Monetary Amount","Critical","If not Stat acct, Monetary Amount may not be $0"]
[350,"Invalid Monetary Amount","Critical","If not Stat acct, Stat Amount must be $0 or blank"]
[360,"Journal Authorizer Missing","Critical","Enter a valid University Uniqname of the Journal's Authorizer"]
[370,"Invalid Monetary Amount","Critical","You may only have 2 digits after the decimal point."]
[380,"Invalid (Zero) Monetary Amount","Critical","The monetary amount on a journal line may not be zero."]
[400,"Invalid Selection","Critical","Type must be either 'H' or 'L'"]