Configuring Balance Load Templates

A balance load template defines the properties that will be used to import balances that are set up using Data Integration.

Defining a balance load template is useful when you want to import balances multiple times, which is usually the case. Once a balance load template is defined, you can run a balance load to load balances using this template, view the results, and correct any errors.

To create a balance load template:

  1. From Home in Account Reconciliation, select Application, then Configuration.
  2. Select the Balance Load Templates tab and select + (New).
  3. In the Properties tab, enter a Name for the balance load.
  4. Optionally, enter a Description.
  5. Select the Mode used to import balances. See About Modes of Importing Data in Administering Account Reconciliation for a description of the import modes.
  6. In Date Format, select the date format (including the time format) used in the source file. The supported data formats are:
    • MM/dd/yyyy
    • dd/MM/yyyy
    • MM-dd-yyyy
    • dd-MMM-yy
    • MMM d, yyyy
  7. In Decimal Separator, select the character (comma or period) that indicates the decimal separator.

    The Decimal Separator and Date Format options are meant for use with balance attributes.

  8. Decide whether to select the Allow Blank Segment Values check box.

    Note:

    When mapping to a Reconciliation Account ID within Account Reconciliation, there are considerations for blank target segments. If there are blank segments in between two populated segments in the target reconciliation, Account Reconciliation treats each blank/null segment values in the middle of a Reconciliation Account ID as three blank spaces. Account Reconciliation also trims off the trailing NULL segments after the last populated segment.

    For example, a Group Reconciliation with the following Reconciliation ID: "001-null-null-1925 XXX" (the "null" in Account Reconciliation would be non-existent (void of characters) when viewing the Reconciliation/Profile.) The design of Account Reconciliation replaces the "null" at the database tier with three spaces for each blank/null segment in between the populated segments. The Target Mapped Profile in Data Management needs the following: "ACCOUNT ID 001- - -1925 XXX" to align with Account Reconciliation.

  9. Decide whether to select the Execute data integration in parallel check box to run all balance load rules in parallel instead of the default which is to run one at a time.

  10. To translate source system balances to any configured higher currency buckets, select Translate balances to higher currency buckets. From the list adjacent to this option, select the Rate Type.

    This option is not displayed if there is only one currency bucket configured in System Settings.

  11. Select Create Missing Profiles to automatically create new profiles for balances that don’t have a matching profile. To automatically create new profiles for all balances with missing profiles in this balance load, select All. When you select Within Saved Filter, new profiles are automatically created for balances whose attributes match the criteria specified in the selected saved filter.

    For information about the rules that are used when automatically creating profiles, see Configuring Profile Creation Rules to Automatically Create Missing Profiles in Administering Account Reconciliation.

  12. In the Location tab, select the Data Management or Data Integration location from which balances must be imported.

  13. Select Save.