Import of adjustments

Through the Import Adjustments page, you can import adjustments from an external source into the application.

To access the Import Adjustments page, click Transfers > Adjustments > Import Adjustments.

 Note:

For accounts requiring a flow, the same logic used for manual data entry without a specified flow also applies when importing adjustments.

The updated logic works as follows:

  • If a flow is not specified, the system automatically assigns a specific flow when saving:

    • “Unexplained Variation” (typically coded as "999") for accounts with manual flows.

    • “Net Variation” for accounts with automatic flows.

During the validation process, if a required flow is missing for an account, an error message will indicate this. However, the file can still be imported, and the system will automatically add the appropriate flows.

Import adjustments

 Note:  During import any data in the Carried Forward column is ignored.. The system keeps the existing carried forward status already saved, and users cannot change this value through the import.

  1. In the File type field, select the file type you want to import. The available file types are CSV, Excel or HUB. The file type you select determines the supplementary parameters to specify.

    • For XLS file type, you specify the following:

    • Sheet Name: Sheet from which you want to import the adjustments data.

    • For CSV file type, you specify the following:

      • CSV Separator, Decimal Separator, and Thousand Separator, to determine the character to use for each of the separator.

      • Text delimiter: This determines the character to signify text data.
        For more information, see CSV File Format.

    • For HUB file type, you specify:

      • Package ID: package identifier. Enter the package ID or click to search for one.

  2. In the Upload file field (CSV and XLS file type only), click to open file explorer and navigate to the file you want to upload and select it.

  3. For Overwrite Options - indicate how you want to overwrite the existing data:

    • Overwrite Journals known in file - if selected, imported files overwrites only the adjustments that are available in the file.

    • Overwrite Journals of Period - if selected, imported file overwrites all existing journals.

    • Use journal entries from the import file - if selected, the journal entries from imported file will be used. No new ones will be generated.

    • Generate extra rows - if selected, automatically adds two balancing rows when importing adjustments that impact P&L. This helps to ensure consistency with manual entries.

  4. Click to start the import.

Import file required structure

Refer to the Import Adjustments File Structure article.