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 Details

The Journal Details layout and header are very similar to that of a sheet. Like sheet details and the Dimensions pane, Journals have Journal Details 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.

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.

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.