Import/Export Functionality for Journals

The journal import and export functionality enables users to import and export journal entries using Excel files, streamlining journal management across environments. This feature supports both exporting journals for backup, review, or migration purposes, and importing journal entries in bulk using a structured Excel template.

The journal import and export functionality enables users to export journal entries to Excel for backup, review, or migration, allows bulk import of journal entries using a structured Excel template, and ensures traceability by requiring a unique Import ID for each uploaded entry. It simplifies template preparation by making Journal ID optional during import, validates imported data with clear error messaging for missing or incorrect fields, supports both standard and adjusting journal types for comprehensive coverage, and preserves all journal attributes including attachments and approval status.

Exporting Journals

Users can export one or multiple journals from the Journal Management interface. The export includes system-generated Journal IDs for reference, ensuring that all journal attributes are preserved in the Excel file.

Export Process

1. Navigate to the Journal Management interface
2. Select the journal or journals you want to export
3. Click the export option
4. The system generates an Excel file containing the selected journals with all attributes including Journal IDs

Export Uses - Export journal entries to Excel for backup purposes, review and analysis outside of JustPerform, or migration to other environments or systems.

Importing Journals

Journal entries can be imported in bulk using a structured Excel template. The import process validates required fields during upload and provides clear error messages for missing or incorrect data.

Template Structure - A structured Excel template is used for import. The template includes fields for all journal attributes to ensure imported journals retain their complete information.

Import ID Requirement - While Journal ID is optional during import, a unique Import ID is mandatory. The Import ID ensures traceability and prevents duplication of journal entries during the upload process.

Import Process

1. Prepare your Excel file using the structured template
2. Ensure each journal entry has a unique Import ID
3. Navigate to the Journal Management interface
4. Select the import option
5. Upload your Excel file
6. The system validates required fields and displays error messages if data is missing or incorrect
7. Review validation results and correct any errors
8. Complete the import to add journals to the system

Field Requirements

Journal ID - Optional during import. The system can generate new Journal IDs automatically for imported entries. When exporting, Journal IDs are always included.

Import ID - Mandatory during import. Each journal entry must have a unique Import ID to ensure traceability and prevent duplicate entries from being uploaded.

Required Fields - The system validates required fields during upload. If required fields are missing or contain incorrect data, the system provides clear error messages indicating what needs to be corrected.

Data Preservation

Imported journals retain all attributes from the Excel template:

Journal Attributes - All journal characteristics including debit, credit, balance, remarks, and status are preserved during import.

Attachments - Any attachments associated with journal entries are maintained through the import process.

Approval Status - The approval status of journals is retained, allowing imported journals to maintain their workflow state.

Journal Types - The feature supports both standard and adjusting journal types for comprehensive coverage.

Validation and Error Handling

The system validates imported data to ensure quality and completeness:

Field Validation - During upload, the system checks that all required fields contain valid data. Missing or incorrect field values trigger validation errors.

Error Messages - Clear error messages indicate which fields are missing or incorrect, allowing users to quickly identify and resolve issues in the Excel file.

Duplicate Prevention - The unique Import ID requirement prevents duplicate journal entries from being uploaded in the same import session.

Note: Review validation error messages carefully before correcting your Excel file. The system provides specific guidance about which fields need attention.

Use Cases

Bulk Journal Entry - Import multiple journal entries prepared offline in Excel, streamlining the process of recording large volumes of adjustments, corrections, or reclassifications needed during consolidation.

Environment Migration - Export journals from one JustPerform environment and import them into another, facilitating movement between development, testing, and production environments.

Backup and Recovery - Export journal entries to Excel for backup purposes, enabling recovery of journal data if needed.

External Preparation - Prepare journal entries in Excel using familiar spreadsheet tools, then import them into JustPerform for processing and approval within the workflow.

Periodic Adjustments - Import recurring period-end adjustments that have been prepared and reviewed in Excel, reducing manual data entry during the financial close process.