Skip to main content
K
kmd
Newcomer
October 27, 2023
Solved

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

  • October 27, 2023
  • 1 reply
  • 0 views

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

Best answer by lzwebb

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

 

1 reply

L
lzwebb
Newcomer
October 30, 2023

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.  

K
kmdAuthor
Newcomer
October 30, 2023

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

L
lzwebbAnswer
Newcomer
October 30, 2023

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

 

    Terms & ConditionsAccessibility statement