Journal

Journal allows users to efficiently capture and manage financial adjustments needed during consolidation. Journals enable users to log changes, corrections, or reclassifications accurately, ensuring that consolidated financial reports reflect up-to-date and accurate data.

With Journals, users can:

  • Record essential adjustments easily.

  • Maintain clear documentation for audit purposes.

  • Ensure accuracy and consistency in consolidated reports.

Journal Details

The Journal Details layout and header are very similar to that of a sheet. Like sheet details and Fields pane, Journal has Journal Details and Fields.

Journal Details

Name : Name of the Journal

Title : Title of the Journal

Functional Area : Functional Area to which Journal belongs

Layout Type : dropdown section currently allows Journal Form

Layout : The Journal Layout contains Journal List and Line Items

Each of these section have default fields and metrics. The fields and metrics can be accessed from the fields pane.

Journal List

Metrics : Description and Status

Fields : Journal ID

Line Items

Metrics : Debit ( Number ), Credit ( Number ), Remarks ( Text ), Balance ( Number )

Fields : Line Items ID

The purpose of each of these is :

Description: Information to explain the document entry ( Text )

Status: Status of Journal (Data Status metric with Allowed members as : Open/Posted/UnPosted)

Debit/Credit: Debit/Credit amount in line item ( Number )

Remarks: Description of line item ( Text )

Balance: Debit - Credit ( Number )

New fields and metrics can be added to further customize the Journal template. After Journal Template is created, user can navigate between multiple screen in Journal.

  • Default screen: Journal List which show all created Journal by filter and show all the detail from Journal Header as per user configuration in Layout

  • Journal Document screen: Individual Journal Data - Navigate by clicking to individual Journal or click Create new Journal

  • Journal Metric List and Explore Page: To edit Journal metric and apply formula for Journal Metric

Journal Header

Journal Header

Refresh : to Refresh Journal

Selection : To add fields and metrics to selection

Edit mode : To open Detail pane to edit Journal

Journal Details : Open Journal template in new tab to enable data entry

Search : to search for a particular entry

Metric List : Go to metric page

Snippet : To view and create snippets

More : This contains options to Import and Export

Last updated