Skip to main content


How to Post a Multiperiod Journal in OneStream

Business People Discussing Strategy With A Financial Analyst

One of our client requirements was to post a multiperiod journal. In the Consolidation process, this kind of request is uncommon; however, this request was from a Planning process perspective. In the following document, I describe the steps to create a multiperiod journal with OneStream XF.

Create a Journal Template

Navigate to and select Application -> Data Collection -> Journal Template and create a journal template.


The first step is creating a Journal Group to organize the journals better. Click on the two blue dots to create a Group.


Add a name and description, define the security (Access Group and Maintenance Group), and save.


Then, we need to create the journal template. Click on the “Create Journal template” icon.


Add a name and description, and fill out the journal template depending on the requirements. Choose the journal template type. “A Journal template can either be a Standard or Auto Approved. If it is auto-approved, a user can create a Journal from the template with limited editing ability, meaning permission to change name, description, and so forth.1


For illustration purposes, we left the journal template Type as “Auto Approved.”

To add a dimension, go to the Point of View section. Select the dimension you want to add, and click on the ellipsis.


Select (Default) member and click “OK,” and repeat for each dimension.


After the selections, you can see the dimensions displayed in each journal line.



Once we have created the Journal template, we must create a Journal Profile. For that, click on the three dots icon.


Add a name and description, define the security (Access Group and Maintenance Group), and save.


Once we have created the Journal Template profile, we need to add the journal template to the Journal profile. Select the Profile and click the “Manage Profile Members” icon to do so.


In the profile builder, select the group you want to add to the Profile and click “Add item.”

Onestream - Modern Accounting: How to Overcome Financial Close Challenges
Modern Accounting: How to Overcome Financial Close Challenges

Improvements in each of the following period-close core tasks can provide transformative change and are reviewed in this guide include closing the books and external reporting, periodic reconciliations, and managing the period-close process.

Get the Guide


Once you have added the group, click “OK.”


Now, you will see the journal template in the Profile.


Navigate to and select Application -> Workflow -> Workflow profile and select the Workflow “WF” where you want to create the journal template profile.


Once you select the WF, activate the step by selecting TRUE in “Profile Active.”  In the Setting section of the WF, assign the Journal Template Profile Name to the WF on the “Journal Template Profile Name” line in the Journal Settings section.


Create a Journal CVS Template

Open an MS Excel file. In the first two rows of Column A, create two Row Type Parameters specifying the Header and the Detail !RowType (H=Header) and !RowType (D=Detail). These tags the corresponding rows with H or D, identifying the Header and Detailed information in the CSV file.


Then, we need to enter the Journal Column Headers. The required headers are the following (make sure you put each title in one specific cell):

JournalName, OriginiatingTemplateName, JournalDescription, JournalType, JournalBalanceType, IsSingleEntity, EntityMemberFilter, ConsName, WFProfileName, WFScenarioName, WFTimeName, and CubeTimeName.


Add the detail in row two, and enter the Journal Detail Headers. The required Journal Detail Headers are:

JournalName, CubeName, EntityName, ParentName, AccountName, FlowName, ICName, all UDNames, DebitAmount, CreditAmount, and LineDescription.


The file will identify the rows depending on the first column tags. H = Header or D = Detail.


NOTE: You must add an H Row (Header) for each journal you want to post.

In this case, I want to affect two periods (2021M6 and 2021M7).


Once you have created the MS Excel file, save it as CVS (Comma Delimited).


Load the Journal via WF

Go to OnePlace and select the WFProfile, Scenario, and Time member to load the journal. In this case, FIN_Admin, Budget2021, 2021


Create the journal using the .cvs file.


Select the journal CSV file to load (make sure you can see “All files.) and click Open.


Once you load the .cvs file in the journal step, OneStream creates two journals.


Click the check box to Select ALL journals, and click on post.  Picture28

You will be able to post all the journals with a single post.

Note: Depending on security, you could create, upload, and post the journal, or different persons can manage this separately, e.g., one can upload, and another can post it.


Click “OK” to confirm the posting.


Create a CubeView “CV” or QuickView to validate data. In this case, I used a CV.



  1. Design and Reference > Data Collection > Journal Templates > Journal Template Properties

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Luis Mandujano

Luis is a passionate and results-oriented Lead Business Consultant at Perficient, leveraging his OneStream Certified Associate (OCA) expertise to add significant value to clients. Beyond his professional endeavors, Luis is a husband. He finds balance by exploring new destinations and engaging in his favorite sports.

More from this Author

Follow Us