Updating Reconciliation and Profile Attributes

An Administrator or Power User can update attributes manually on reconciliations on the Reconciliation List, either on the list or on the Set User pane in the Actions Panel. See Making Attributes Updates Manually

An Administrator or Power User can also update attributes or workflow using a csv file. See Making Attribute Updates Using a CSV File

An Administrator or Power User can also update Profile attributes. See Updating Profile Attributes

Making Attributes Updates Manually

To make updates to reconciliation attributes manually:

  1. From Home, click Reconciliations.
  2. From the Reconciliation list, click a reconciliation, and then click Edit.
  3. On the Properties tab, make attribute updates following the file format rules. See Reconciliation Attribute File Format Rules

Reconciliation Attribute File Format Rules

The attribute input file is indexed by the segments with one row per reconciliation. The columns may vary depending on which attributes you want to update.

Column (Attribute) UI Export Option Pending Reconciliation Status Open Reconciliation Status Closed Reconciliation Status
Segment <n> <Default> No No No
Account Name Name Yes Yes Yes
Description Description Yes Yes Yes
Process Process Yes Yes Yes
Organizational Unit Organizational Unit Yes Yes Yes
Risk Rating Risk Rating Yes Yes Yes
Account Type Account Type Yes Yes Yes
Instructions Instructions Yes Yes Yes
Normal Balance Normal Balance Yes No No
Auto Recon Method Auto Reconciliation Method Yes No No
Auto Recon Bal Low Auto Reconciliation Method Yes No No
Auto Recon Bal High Auto Reconciliation Method Yes No No
Auto Recon Threshold Number Auto Reconciliation Method Yes No No
Auto Recon Threshold Percent Auto Reconciliation Method Yes No No
Max Age Adjustments Maximum Age Adjustments Yes No No
Max Age Explanations Maximum Age Explanation Yes No Yes
Manual Balance Source System Enter Source System Balances Yes Yes Yes
Manual Balance Subsystem Enter Subsystem Balances Yes Yes Yes
Preparer Preparer Yes Yes Yes
Preparer Backup Preparer Yes Yes Yes
Preparer Require Action By Preparer Yes Yes Yes
Start Date Preparer Yes No No
Duration Preparer Yes Yes Yes
Reviewer <n> Reviewer Yes Yes Yes
Reviewer Backup <n> Reviewer Yes Yes Yes
Reviewer Duration <n> Reviewer Yes Yes Yes
Commentator Commentator Commentator Commentator Commentator
Viewer Viewer Viewer Viewer Viewer
Historical Rate Historical Rate Yes No No
Rate Type Rate Type Yes No No
Attribute 1 <Custom Attribute> Yes Yes Yes
Attribute Value 1 <Custom Attribute> Yes Yes Yes
Attribute Access 1 <Custom Attribute> Yes Yes Yes
Attribute Attachment Access 1 <Custom Attribute> Yes Yes Yes
Attribute Copy To Profile 1 <Custom Attribute> Yes Yes Yes
Enable Currency Bucket 1 Currency Bucket Enabled (Entered) Yes No No
Default Currency Bucket 1 Currency Bucket Default Currency (Entered) Yes Yes Yes
Enable Currency Bucket 2 Currency Bucket Enabled (Functional) Yes No No
Default Currency Bucket 2 Currency Bucket Default Currency (Functional) Yes Yes Yes
Enable Currency Bucket 3 Currency Bucket Enabled (Reporting) Yes No No
Default Currency Bucket 3 Currency Bucket Default Currency (Reporting) Yes Yes Yes

Making Attribute Updates Using a CSV File

Another method of making attribute updates is through use of an import csv file. Here are two examples of how this could be useful to your company:

  • If you are working with data that comes in after a reconciliation has already been deployed but is important to your reconciling process such as percent sales. For example, if a company operates stores in many regions of the country and wants to reconcile at the store level and see percent sales data by store. The advantage of making an attribute update is that it helps make better reconciliation rules resulting in most reconciliations performed through auto submit and auto approve with less manual intervention. In some cases, the data for certain regions or stores is not ready and must be added after the reconciliation is deployed. This procedure gives you the ability to add the new attribute, in this case, percent sales, include the Reconciliation ID in the csv file and the new attribute and import into the system.

  • Another common example is the situation where on a regular basis you need to make Org changes mid cycle for certain reconciliations. Since the reconciliations are already deployed, again you can use the attribute import by using a CSV file to load in the changed values.

These are the high level steps to follow:

  • Export the current attributes to a CSV file - this gives you a starting point
  • Make changes to the file
  • Import the revised attribute file

To update reconciliation attributes using a csv file:

  1. From Home, click Reconciliations.
  2. Select the reconciliations you want to update and under Actions, click Export.
    1. In Format, select Unformatted data for future attribute import and then select the Attributes that need updating from the list.
      Export Reconciliations dialog

      Note that you can export workflow roles (such as Preparer, Reviewer, Commentator for example) and you will get all the information about those roles included in the export file.

    2. Click Export to start the export process.
  3. Make changes to the csv file that you exported.
  4. Now import the revised file. From Reconciliations, click Import and then Import Attributes from the Actions menu.
    Reconciliations Import menu option

    The Update Reconciliations dialog displays.
    Update Reconciliations dialog

    1. In File, browse to the revised csv file.
    2. In Period, select the period (defaults to the most recent you are viewing).
    3. In Date Format, either leave the default or select another format.
    4. Click Import. A background job begins processing.
      Update Reconciliations dialog
    5. Once the import completes successfully, you can see the import changes by going into Edit Reconciliations dialog.

    The optional selections on Update Reconciliations are:

    1. Optionally, use Run Rules- to run rules on reconciliations after you import the changes. The default is None.
    2. Optionally, useReopen on Change - to change the status of reconciliations that have been revised to Open.
    3. Optionally, use File Delimiter - to select a different file delimiter (defaults to comma).

Updating Profile Attributes

If you want to update profile attributes, you follow the same high level steps:

  • Export the current attributes to a CSV file. See Exporting Profiles.
  • Make changes to the file
  • Import the revised attribute file using Import and choose the option Update rather than replace in order to make the changes in the revised attribute file. See Importing Profiles.
Column (Attribute) UI Export Option
Segment <n> <Default>
Account Name Name
Description Description
Process Process
Format Format
Organizational Unit Organizational Unit
Risk Rating Risk Rating
Account Type Account Type
Instructions Instructions
Active Active
Normal Balance Normal Balance
Auto Recon Method Auto Reconciliation Method
Auto Recon Bal Low Auto Reconciliation Method
Auto Recon Bal High Auto Reconciliation Method
Auto Recon Threshold Number Auto Reconciliation Method
Auto Recon Threshold Percent Auto Reconciliation Method
Max Age Adjustments Maximum Age Adjustments
Max Age Explanations Maximum Age Explanation
Manual Balance Source System Enter Source System Balances
Manual Balance Subsystem Enter Subsystem Balances
Preparer Preparer
Preparer Backup Preparer
Preparer Frequency Preparer
Preparer Require Action By Preparer
Start Offset Preparer
Duration Preparer
Reviewer <n> Reviewer
Reviewer Backup <n> Reviewer
Reviewer Frequency Reviewer
Reviewer Duration <n> Reviewer
Commentator Commentator
Viewer Viewer
Historical Rate Historical Rate
Rate Type Rate Type
Attribute 1 <Custom Attribute>
Attribute Value 1 <Custom Attribute>
Attribute Access 1 <Custom Attribute>
Attribute Attachment Access 1 <Custom Attribute>
Attribute Copy To Profile 1 <Custom Attribute>
Enable Currency Bucket 1 Currency Bucket Enabled (Entered)
Default Currency Bucket 1 Currency Bucket Default Currency (Entered)
Enable Currency Bucket 2 Currency Bucket Enabled (Functional)
Default Currency Bucket 2 Currency Bucket Default Currency (Functional)
Enable Currency Bucket 3 Currency Bucket Enabled (Reporting)
Default Currency Bucket 3 Currency Bucket Default Currency (Reporting)