Importing Pre-mapped Balances for Reconciliation Compliance and Transaction Matching

You can import balances into a reconciliation from a flat file where the balances have already been pre-assigned an Account ID. While Administrators can import balances for all reconciliations, Power Users can import for reconciliations included within their security profile. Users can import for reconciliations where the user is assigned the Preparer function. Note the following about importing balances:

  • Importing balances for Transaction Matching uses the same user interface as used for Reconciliation Compliance balance import.
  • Balances are imported using Replace mode, meaning if a balance is imported for the same reconciliation and for the same calendar date, then the new balance will overwrite the old balance.
  • Balances are imported as source system and sub system data sources. When defining the import file for balances, you need to define the balancing attribute. The data source name will display in the Jobs dialog.

This topic covers importing pre-mapped balances for both Reconciliation Compliance and Transaction Matching.

Note:

If you are using a Transaction Matching Only profile, only an Administrator can load balances.
File Format
  • Balance import files are comma-separated value (.csv) files.
  • Balance import files require columns for Reconciliation Account ID, Currency Code, and Amount. The Balance Type and Currency Bucket are specified on the import dialog.

Importing Balances

To import balances from a file:

  1. From Home , select Reconciliations, and then select a reconciliation with the status Open with Preparer for which you are the preparer. The Reconciliation actions menu, is available to Administrators, Power Users, and Users.

    Note:

    You may also access the option to Import Pre-Mapped Data from the Worklist.
  2. Select Actions, and then Import Pre-mapped Data, and then Import Pre-mapped Balances.
    example of import pre-mapped balances dialog
  3. Browse to the flat file of balances you want to add. This is an example of a balances flat file.


    example of balances flat file
  4. Select the balance type: Source System, or Subsystem.

  5. Select the Currency Type: Entered, Functional, or Reporting.
  6. Select a file delimiter for the import file (for example, comma or tab). Or, choose Other to specify any single character as the delimiter.
  7. The Mode field is display only as Snapshot and means that when loading pre-mapped balances, the previously loaded balances will be deleted and replaced with the balances you are loading now.
  8. Click Import.

Pre-mapped balance imports happen behind the scenes and users can leave the page and return to check the results later. To check the results, open the Import Pre-Mapped Balances page and click the View Data Load Results link on the left side of the page.

Note:

You will receive an error message if you try to perform a data load at the same time as another data load to the same period is processing. Data loads cannot be processed in parallel.