{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Control","Favs","Notes","Logs","Options","Template","Template_H","ReclassJournal","ReclassJournal_H"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":0,"defined_names":79,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Options","index":4,"reason":"not_a_worksheet"}],"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":"Control","index":0,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,null,null,null,null,null,"Spreadsheet Journal Import"]

{"sheet":"Favs","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Sheet Name","Favorite","SheetNo"]
["ReclassJournal","N",2]

{"sheet":"Notes","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Notes"]
[]
[]
[]
[null,"15100","ACTUALS","101010",null,null,"01000",null,"95200"]
[null,"15100","ACTUALS","101010",null,null,"01000",null,"95400"]

{"sheet":"Logs","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Import Logs"]
["Workbook","Sheet","UserID","Date / Time","Status","Log message"]
["JRNL1_WS.xlsm","fghf","VP1","2025-09-05T18:21:51","Import failed","The URL is invalid\r\nhttps://<server>/"]
["JRNL1_WS.xlsm","fghf","VP1","2025-09-05T18:22:32","Import failed","The URL is invalid\r\nhttps://<server>/"]
["JRNL1_WS.xlsm","fghf","VP1","2025-09-05T18:32:30","Import failed","The URL is invalid\r\nhttps://<server>/"]
["JRNL1_WS.xlsm","fghf","VP1","2025-09-05T18:32:45","Import failed","The URL is invalid\r\nhttps://<server>/"]
["JRNL1_WS.xlsm","fghf","VP1","2025-09-05T18:38:10","Import failed","The URL is invalid\r\nhttps://<server>/"]
["JRNL1_WS.xlsm","TEST","VP1","2025-09-05T18:42:16","Import failed","The URL is invalid\r\nhttps://<server>/"]
["JRNL1_WS.xlsm","Test","PPS_ADRIAN.SAUNDERS","2026-03-31T11:30:13","Import failed","The URL is invalid\r\nhttps://<server>/"]

{"sheet":"Template","index":5,"n_rows":11,"n_cols":47,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[6,1,6,7]]}
[null,null,"%,OS",null,"JOURNAL_ID","JOURNAL_DATE","UNPOST_SEQ","JOURNAL_LINE","BUSINESS_UNIT","LEDGER","ACCOUNT","SPEEDTYPE_KEY","ACCOUNT_CODE","FUND_CODE","CHARTFIELD2","DEPTID","CHARTFIELD1","PRODUCT","CLASS_FLD","OPERATING_UNIT","CHARTFIELD3","BUDGET_REF","BUSINESS_UNIT_PC","PROJECT_ID","ACTIVITY_ID","ANALYSIS_TYPE","RESOURCE_TYPE","RESOURCE_CATEGORY","RESOURCE_SUB_CAT","AFFILIATE","AFFILIATE_INTRA1","MONETARY_AMOUNT","STATISTICS_CODE","STATISTIC_AMOUNT","JRNL_LN_REF","LINE_DESCR","RT_TYPE","RATE_MULT","FOREIGN_AMOUNT","PIID","PIID_PARENT","FOREIGN_CURRENCY","FAIN","URI","EXCLUDE","OPEN_ITEM_KEY","REFERENCE5"]
[null,"Journal Entry Sheet"]
[null,"Journal Header"]
[null,null,null,null,null,"Date",null,"   Sys ID  Unit     Journal ID  Date       Description     Source"]
[]
[null,null,null,null,100,null,null,null,5,10,10,10,null,5,10,10,10,6,5,8,10,8,5,15,15,3,5,5,5,5,10,null,1,null,10,30,5,17,null,null,null,3,null,null,null,30,240]
[null,"Journal Lines"]
[null,"Sys ID",null,null,"Journal ID",null,null,"Line #","Unit","Ledger","Account","Speed Type","Accounting Tag","Fund","Program","Department","Cost Center","Task","FIPS","Asset","Agency Use 1","Agency Use 2","PC Bus Unit","Project","Activity","AN Type","Source Type","Category","Sub Cat.","Affiliate","Fund Aff","Amount","Stat","Stat Amount","Reference","Description","Rate Type","Rate","Amount","PIID","Parent PIID","Currency","FAIN","URI","Exclude from Rpt","Open Item Key","Reference5"]
[null,null,null,"Hunit",null,"Date","Seq #"]
["%,OH",null,null,null,null,null,null,null,"Select fields to copy from a previous line by marking the checkboxes under each field.  "]
["%,OA",null,"U"]

{"sheet":"Template_H","index":6,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"%,OS","SEQNO","BUSINESS_UNIT","JOURNAL_ID","JOURNAL_DATE","DESCR254","LEDGER_GROUP","LEDGER","SOURCE","OPRID","FOREIGN_CURRENCY","CUR_EFFDT","RT_TYPE","RATE_MULT","REVERSAL_CD","REVERSAL_DATE","AUTO_GEN_LINES","ADJUSTING_ENTRY","ACCOUNTING_PERIOD","GL_ADJUST_TYPE","JOURNAL_CLASS","IU_TRAN_CD","ALC","DOC_TYPE","DOC_SEQ_NBR","FISCAL_YEAR","KK_AMOUNT_TYPE","TRANS_REF_NUM","JRNL_STATUS"]
["%,OH","Control Code","System ID","Unit","Journal ID","Date","Descr","Ledger Grp","Ledger","Source","Operator","Currency","Effective Date","Rate Type","Rate","Reversal","Reversal Date","AutoGenLines","Adj Entry","Period","Adj type","Journal Class","Transaction Code","Agency Location Code","Doc Type","Doc Seq Nbr","Fiscal Year","KK Amount Type","Reference Number","Journal Status"]

{"sheet":"ReclassJournal","index":7,"n_rows":14,"n_cols":47,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[6,1,6,7]]}
[null,null,"%,OS",null,"JOURNAL_ID","JOURNAL_DATE","UNPOST_SEQ","JOURNAL_LINE","BUSINESS_UNIT","LEDGER","ACCOUNT","SPEEDTYPE_KEY","ACCOUNT_CODE","FUND_CODE","CHARTFIELD2","DEPTID","CHARTFIELD1","PRODUCT","CLASS_FLD","OPERATING_UNIT","CHARTFIELD3","BUDGET_REF","BUSINESS_UNIT_PC","PROJECT_ID","ACTIVITY_ID","ANALYSIS_TYPE","RESOURCE_TYPE","RESOURCE_CATEGORY","RESOURCE_SUB_CAT","AFFILIATE","AFFILIATE_INTRA1","MONETARY_AMOUNT","STATISTICS_CODE","STATISTIC_AMOUNT","JRNL_LN_REF","LINE_DESCR","RT_TYPE","RATE_MULT","FOREIGN_AMOUNT","PIID","PIID_PARENT","FOREIGN_CURRENCY","FAIN","URI","EXCLUDE","OPEN_ITEM_KEY","REFERENCE5"]
[null,"Journal Entry Sheet"]
[null,"Journal Header"]
[null,null,null,null,null,"Date",null,"   Sys ID  Unit     Journal ID  Date       Description     Source"]
[null,null,null,null,null,null,null,1691," 15100     NEXT       7/27/2026  Reclass         SPJ"]
[null,null,null,null,100,null,null,null,5,10,10,10,null,5,10,10,10,6,5,8,10,8,5,15,15,3,5,5,5,5,10,null,1,null,10,30,5,17,null,null,null,3,null,null,null,30,240]
[null,"Journal Lines"]
[null,"Sys ID",null,null,"Journal ID",null,null,"Line #","Unit","Ledger","Account","Speed Type","Accounting Tag","Fund","Program","Department","Cost Center","Task","FIPS","Asset","Agency Use 1","Agency Use 2","PC Bus Unit","Project","Activity","AN Type","Source Type","Category","Sub Cat.","Affiliate","Fund Aff","Amount","Stat","Stat Amount","Reference","Description","Rate Type","Rate","Amount","PIID","Parent PIID","Currency","FAIN","URI","Exclude from Rpt","Open Item Key","Reference5"]
[null,null,null,"Hunit",null,"Date","Seq #"]
["%,OH",null,null,null,null,null,null,null,"Select fields to copy from a previous line by marking the checkboxes under each field.  "]
["%,OA",null,"U"]
[null,1691,"U"]
[null,1691,"C","15100","NEXT","2026-07-27",0,1,"15100","ACTUALS","101010",null,null,"01000",null,"95200",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[null,1691,"C","15100","NEXT","2026-07-27",0,2,"15100","ACTUALS","101010",null,null,"01000",null,"95400",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1000]

{"sheet":"ReclassJournal_H","index":8,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"%,OS","SEQNO","BUSINESS_UNIT","JOURNAL_ID","JOURNAL_DATE","DESCR254","LEDGER_GROUP","LEDGER","SOURCE","OPRID","FOREIGN_CURRENCY","CUR_EFFDT","RT_TYPE","RATE_MULT","REVERSAL_CD","REVERSAL_DATE","AUTO_GEN_LINES","ADJUSTING_ENTRY","ACCOUNTING_PERIOD","GL_ADJUST_TYPE","JOURNAL_CLASS","IU_TRAN_CD","ALC","DOC_TYPE","DOC_SEQ_NBR","FISCAL_YEAR","KK_AMOUNT_TYPE","TRANS_REF_NUM","JRNL_STATUS"]
["%,OH","Control Code","System ID","Unit","Journal ID","Date","Descr","Ledger Grp","Ledger","Source","Operator","Currency","Effective Date","Rate Type","Rate","Reversal","Reversal Date","AutoGenLines","Adj Entry","Period","Adj type","Journal Class","Transaction Code","Agency Location Code","Doc Type","Doc Seq Nbr","Fiscal Year","KK Amount Type","Reference Number","Journal Status"]
[null,"C",1691,"15100","NEXT","2026-07-27","Reclass","ACTUALS","","SPJ","CURRENT_USER","","2026-07-27","",0,"N",null,"N","N",null,"","","","","","",null,"","",""]