Skip to main content

OneStream

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.

Picture1

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

Picture2

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

Picture3

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

Picture4

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

Picture5

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.

Picture6

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

Picture7

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

Picture8

Picture9

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

Picture10

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

Picture11

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.

Picture12

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

Picture13

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

Picture14

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

Picture15

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

Picture16

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.

Picture17

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.

Picture18

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.

Picture19

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.

Picture20

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

Picture21

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).

Picture22

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

Picture23

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

Picture24

Create the journal using the .cvs file.

Picture25

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

Picture26

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

Picture27

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.

Picture29

Click “OK” to confirm the posting.

Picture30

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

Picture31

Reference

  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

Categories
Follow Us