Transactions - Journal

Journals allow users to efficiently capture and manage financial adjustments needed during consolidation. They 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 Layout

The Journal Layout and header are very similar to that of a sheet. Like sheet details and the Dimensions pane, Journals have Journal Layout and Dimensions.

Name: Name of the Journal.

Title: Title of the Journal.

Functional Area: Functional Area to which the Journal belongs.

Layout Type: Dropdown section currently allows Journal Form.

Layout: The Journal Layout contains Journal List and Line Items.

Each of these sections has default dimensions and metrics. The dimensions and metrics can be accessed from the Dimensions pane.

Journal List

Metrics: Description and Status.

Dimensions: Journal ID.

Line Items

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

Dimensions: 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: Open/Posted/Unposted).

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

Remarks: Description of line item (Text).

Balance: Debit - Credit (Number).

New dimensions and metrics can be added to further customize the Journal template. After the Journal template is created, users can navigate between multiple screens in the Journal.

• Default screen: Journal List which shows all created Journals by filter and displays all the details from the Journal Header as per user configuration in Layout.

• Journal Document screen: Individual Journal Data - Navigate by clicking on an individual Journal or click Create New Journal.

• Journal Metric List and Explore Page: To edit Journal metrics and apply formulas for Journal metrics.

v26.05: Data Protection Rule

Journal-Level Data Protection Rule Configuration

When working with Journals, Data Protection Rules can be configured directly at the Journal level instead of being defined separately for each metric. This change simplifies setup and ensures consistent data protection behavior.

• A configuration option, Data Protection Rule, is available in the Journal Layout.

• Users can select one Data Protection Rule from the list of existing Data Protection Rules configured in the system.

• The selected rule automatically applies to all metrics within the Journal.

• Only one Data Protection Rule can be assigned per Journal.

Migration Notice: Any journal metric-level Data Status configurations and their associated Data Protection Rules will be automatically removed. No action is required, but previously saved metric-level settings will not be retained.

Journal Status Behavior When No Journal-Level Rule Is Configured

If no Data Protection Rule is configured at the Journal level:

• The system follows the existing Journal Status behavior.

• Editability and locking are determined solely by Journal Status.

• This ensures full backward compatibility for existing Journals.

Journal Status Behavior

• Open or Unposted

  Users can change and modify values in both the Journal List and Journal Line Items.

• Posted

  Users cannot update or modify any values in the Journal List or Line Items. All fields are locked.

Combined Evaluation of Data Status and Journal Status

When a Journal-level Data Protection Rule is configured, the system evaluates both Data Status and Journal Status to determine whether the Journal document is editable or locked.

Evaluation Logic

Key rule:

When Data Status is set to Lock, it takes precedence and locks the Journal regardless of the Journal Status.

When Data Status rules mark a data intersection as locked or protected, JustPerform will block the following journal actions and display a validation message:

• Interacting with or editing journal line items and header selections

• Creating or saving a journal

• Copying a journal — including copies triggered by automated scheduled tasks (these will be marked as Warning in the Task Monitor)

Whole Journal Selection for Sheet-Level Data Status

When configuring Data Status at the Sheet level for Journals, users can apply the rule to the entire Journal instead of configuring it by individual metric.

Whole Journal Option

• Selecting Whole Journal applies the Data Status rule uniformly to:

  • All metrics

  • All journal lines

  • All attributes within the Journal

• For Journals, metric selection is disabled at the Data Status level.

• For Sheets, metric configuration is applied at the individual metric level.

• All other object types continue to use metric‑level configuration, preserving existing behavior and backward compatibility.

Navigation

Sheet → Data Status Metric Details → Specific Metrics → Filter

• For Journal Sheets, you can select Journal level.

• Metric-level selection is not supported for Journals.

Journal Header

Refresh: To refresh the Journal.

Selection: To add dimensions and metrics to the selection.

Edit Mode: To open the Detail pane to edit the Journal.

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

Search: To search for a particular entry.

Metric List: Go to the metric page.

Snippet: To view and create snippets.

More: This contains options to import and export.

Import/Export Functionality for Journals

A new enhancement has been introduced to streamline journal entry management in JustPerform: users can now import and export journal entries using Excel files. Previously, journal creation was a manual process, limiting scalability and increasing the risk of data entry errors. With this new functionality, users can efficiently manage large volumes of journal data across environments, improving accuracy, traceability, and operational speed.

Key Benefits

• Enables users to export journal entries to Excel for backup, review, or migration

• Allows bulk import of journal entries using a structured Excel template

• Ensures traceability by requiring a unique Import ID for each uploaded entry

• Simplifies template preparation by making Journal ID optional during import

• Validates imported data with clear error messaging for missing or incorrect dimensions

• Supports both standard and adjusting journal types for comprehensive coverage

• Preserves all journal attributes, including attachments and approval status

Exporting Journals

Users can export one or multiple journal entries directly from the Journal interface. The exported Excel file includes all journal details, including system-generated Journal IDs. These IDs serve as internal references and are not required for re-importing entries. Instead, a unique Import ID is mandatory for each journal entry during import to ensure traceability and prevent duplication. This export capability supports use cases such as data backup, audit preparation, and migration between environments.

To export journals:

1. Navigate to the Journal interface

2. Select the journal entries to export

3. Click Export to download the file

The exported file includes system-generated Journal IDs.

Importing Journals

Users can now import journal entries in bulk using a structured Excel template, streamlining the creation of multiple entries at once. Each imported journal must include a unique Import ID, which serves as a mandatory identifier to ensure traceability and prevent duplication. While the system-generated Journal ID is optional during import, the Import ID is strictly required and validated during the upload process. If any mandatory dimensions are missing or incorrectly formatted, the system provides clear error messages to guide users in resolving issues before confirming the import. This ensures that all imported data meets system standards and integrates seamlessly into existing workflows.

Imported journals retain all attributes, including attachments, approval status, and journal type (standard or adjusting). Once uploaded, these entries remain fully editable and follow the same approval workflows as manually created journals, ensuring consistency and compliance.

When importing journals, the system always creates new entries and does not overwrite any existing journals.

To import journals:

1. Prepare your Excel file using the provided template.

2. Ensure each entry includes a unique Import ID (mandatory).

3. Navigate to Journal Management and select Import.

4. Upload the file and review validation results.

5. Resolve any errors (e.g., missing Import ID) and confirm the import

This feature streamlines journal management, improves data accuracy, and enhances operational efficiency across financial workflows.