{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Module1","Template","Field Help Info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":0,"reason":"part_missing"}],"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":1,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,7],[9,8,9,18],[7,0,7,18],[2,0,5,11]]}
[]
[]
["University of Massachusetts Lowell e*mpac"]
[]
[]
[]
[]
["Budget Journal Entry"]
[]
["HEADER DETAIL",null,null,null,null,null,null,null,"LINE DETAIL"]
["Business Unit","Journal ID","Journal    Date","Ledger","Budget Type","Header Description",null,"Alternate Description","Account","DeptID","Fund Code","Project ","Budget Period","Class Field","Program Code","Amount","Journal Class","Line Description","Journal Line Reference"]
["UMLOW",null,null,null,null,null,null,null,700899]

{"sheet":"Field Help Info","index":2,"n_rows":50,"n_cols":32,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["The following instructions apply to Header Detail:",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,"UMAMH","ORIG",null,"UMAFN",null,"Original"]
["Column A - Business Unit",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,"UMAMH","BASE",null,"UMAMH",null,"Adjustment"]
["Use DropDown List for available Business Units to post Budget.",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,"UMAMH","NON_BASE",null,"UMBLD",null,"Closing"]
[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,"UMAMH","QUASI",null,"UMBOS",null,"Roll Forward"]
["Column B - Journal ID ",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,"UMCEN"]
[" If you want the system to create your Journal ID then enter \"NEXT\", otherwise the length of Journal ID must be 1-10. ",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,"UMDAR"]
[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,"UMDFN"]
["Column C - Journal Date ",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,"UMELM"]
["The Date Format needs to be MM/DD/YYYY.",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,"UMBOS","BASE",null,"UMFND"]
[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,"UMBOS","NON_BASE",null,"UMLOW"]
["Column D - Ledger ",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,"UMBOS","ORIG",null,"UMWOR"]
["Use DropDown List for available Ledgers to post Budget.",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,"UMBOS","QUASI",null,"WCCCP"]
[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,"WUMMF",null,"APPROP"]
["Column E - Budget Type ",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,"ORG"]
["Use DropDown List for available Budget Types.",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,"REVEST"]
[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,"PROJ_GRT"]
["Column F - Header Description ",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,"UMDAR","ADJSTMTS"]
["The length is 30 characters.  Characters over 30 will be truncated in the Budget Upload.",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,"UMDAR","ARRA"]
[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,"UMDAR","CARRYFWD"]
["The following instructions apply to Line Detail:",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,"UMDAR","GB_SAV_PTL"]
["Column G: Account - It needs to be 6 characters in length.",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,"UMDAR","ONE-TIME"]
["Column H: DeptID - It needs to be 10 characters in length.",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,"UMDAR","ORIGINAL"]
["Column I: Fund Code - It needs to be 5 characters in length"]
["Column J: Project - It needs to be 15 characters in length."]
["Column K: Budget Period - Enter a four digit fiscal year (YYYY) that the journal is being posted. "]
["Note: Leave Budget Period blank if Project is filled in."]
["Column L: Class Field - It needs to be 4 or 5 characters in length.",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,"UMLOW","ORIG"]
["Column M: Program Code - It needs to be 3 characters in length.",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,"UMLOW","BASE"]
["Column N: Amount - This field cannot be blank, or the upload file will ignore this and all rows followed it. ",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,"UMLOW","NON_BASE"]
["Column O: Journal Class - This field has valid values for UMAMH, UMBOS, and UMDAR only.  All other campuses should be blank.",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,"UMLOW","QUASI"]
["Column P: Line Description - The length is 30 characters. All characters over 30 will be truncated in the Budget Upload."]
["Column Q: Line Reference  - The length is 10 characters. All characters over 10 will be truncated in the Budget Upload."]
[]
["To create a new Header, fill in on the Header part with the Business Unit, Journal ID, Journal Date, Ledger, Budget Type information.  "]
["For Line detail be sure you enter Chartfield information and Amount. Fill in remaining columns as appropriate for your campus."]
[]
["Once you have finished entering all the information, follow these steps to create the Budget Journal Upload file:"]
[]
["1. Click on the Create Journal Upload File box. A dialogue box will appear asking you where you want to save the journal."]
[]
["2. Fill in the name of your local drive, name of folder and name of upload file  i.e c:\\temp\\BudJrnl.txt – Click on OK"]
[]
["Message appears telling you the file has been successfully saved, or if there is an error. "]
["Note:you will get an error if your type in the name of an existing file."]
[]
["Go into PeopleSoft  - and navigate to Commitment Control > Budget Journals > Import Budget Journals"]
[]
["Once you’ve entered a run control and clicked ok – click on the Add button and add the name and path of your file, or browse to the "]
["location of your file.  Next time you upload a journal with the same run control ID, you need to click on the 'Delete' button to "]
["delete the existing journal before you add your new one."]