Can an Excel Journal template be modified to allow upload to multiple periods at once?

kmd
Contributor

Does anyone know whether it's possible to modify the Excel journal upload template to force upload to multiple individual periods from that one file?

If it's possible, can anyone provide a brief how-to for setting something like this up?  The request is to be able to upload this to a forecast scenario so it's really outside the normal parameters of a typical journal.

I know one easier alternative is to create an _ADJ member and just load the data to that but that's not the ask from the team.

Would be grateful for any advice.  Thanks

1 ACCEPTED SOLUTION

lzwebb
New Contributor

It doesn't look like there is a specific template for it.  I created one off the original JE template.  Doesn't look like I can upload it here, but I did a copy/paste below.  Each month would need to have 1 header row and at least 1 Detailed row.  You put the period in the header row.

!H (RowType Header)JournalNameOriginatingTemplateNameJournalDescriptionJournalTypeJournalBalanceTypeIsSingleEntityEntityMemberFilterConsNameWFProfileNameWFScenarioNameWFTimeName        
!D (RowType Detail)JournalNameCubeNameEntityNameParentNameAccountNameFlowNameICNameUD1NameUD2NameUD3NameUD4NameUD5NameUD6NameUD7NameUD8NameDebitAmountCreditAmountLineDescription 
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M7       LineDescription
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M8       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M9       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M10       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M11       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M12       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
 DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TEST

 

View solution in original post

3 REPLIES 3

lzwebb
New Contributor

Yes, there is a template that can be leveraged to load all periods at once.  You have a line for the header and lines for the detail.  

That's great - thanks.  Are you able to provide the name and/or location of that template?  I'm wondering if it's just not yet available in our version of OS.  Thanks very much

lzwebb
New Contributor

It doesn't look like there is a specific template for it.  I created one off the original JE template.  Doesn't look like I can upload it here, but I did a copy/paste below.  Each month would need to have 1 header row and at least 1 Detailed row.  You put the period in the header row.

!H (RowType Header)JournalNameOriginatingTemplateNameJournalDescriptionJournalTypeJournalBalanceTypeIsSingleEntityEntityMemberFilterConsNameWFProfileNameWFScenarioNameWFTimeName        
!D (RowType Detail)JournalNameCubeNameEntityNameParentNameAccountNameFlowNameICNameUD1NameUD2NameUD3NameUD4NameUD5NameUD6NameUD7NameUD8NameDebitAmountCreditAmountLineDescription 
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M7       LineDescription
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M8       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M9       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M10       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M11       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
HMultiPeriod JEMultiPeriod Adjustment StandardUnbalancedFALSE LocalTEST.ADJActual2021M12       MULTIPERIOD_TEST
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_CRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None03159388.2MULTIPERIOD_TEST 
DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TESTMULTIPERIOD_TEST
 DMultiPeriod JETEST_CUBETEST_ENTITY TEST_ACCOUNT_DRFLOW_TESTNoneTEST_UD1TEST_UD2NoneTEST_UD4TEST_UD5TEST_UD6TEST_UD7None3159388.20MULTIPERIOD_TEST