View and analyze journal data

User permission: Financial Statements > Manage custom statements

After you publish your first journal, you need to set up your actuals and journals scenario to combine your actuals with those adjustments. You can then view and analyze the journal entry data in Financial Statements or Analytics.

Add the Journals stream to a scenario

Journals are published into two streams: JNL Profit and Loss and JNL Balance Sheet. You need to combine them with other streams in a scenario.

Journal streams (left) and new scenario combining actuals and journals (right)

See Manage streams and scenarios for detailed information, but the summary steps are as follows:

1. Open the financial statement and go to Streams > Manage streams and scenarios.

2. Add a scenario that combines the journal stream with another stream, such as Profit and Loss.

View the journal scenario in Financial Statements

Back in the statement, use the Streams menu to add the new scenario to the grid, where you can view your consolidated results.

Adding the new scenario as a column in statement grid to view the consolidated results

View and analyze the journal data in Analytics

You can drill into transactions to view the journal details.

In the financial statement, right-click a value in the journal scenario column and click the JNL option under Transactions for.

The statement grid converts into the Analytics grid > Transaction mode, where you can see the list of journal entries including details such as the name and number of the journal, when it was published and so on.

You can then use the Analytics tools to analyze the data further.

Drilling into journal transactions

To view both your Profit and Loss and Balance Sheet journals holistically, in Transaction mode, select the JNL Trial Balance Stream.