Steps to Create and Save a Balance Load Template

Use the Balance Loads tab in the Balance Loads card to create and save a balance load template.

To create a new balance load:

  1. From Home in Account Reconciliation, select Application, then Configuration, then Balance Loads.
  2. On Balance Loads tab, select + (New).

    Optionally, you can use a balance load template that was configured as described in Configuring Balance Load Templates in Setting Up and Configuring Account Reconciliation . Select Use balance load template, then select the balance load template from the drop-down, and click OK.

  3. For a new balance load, 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 Balances 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. See Using Balance Attributes for details.

  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 loaded 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.

  12. Select the Location which is the Data Management or Data Integration location to import.

Note:

A Power User can only view balance load templates that they create.