Updating Reconciliation Attributes Using a CSV File

You can make reconciliation attribute updates through the use of an import CSV file.

Here are two examples of how using an import CSV file 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.

The high level steps for updating reconciliation attributes through a CSV file are:

1. Export the current reconciliation attributes to a CSV file - this gives you a starting point.
2. Make changes to the file.
3. Import the revised reconciliation attribute file.

See About Reconciliation Attribute File Format Rules.

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. The Export Reconciliations dialog displays.
   1. In Format, select Unformatted data for future attribute import.
   2. In Attributes, select the reconciliation attributes that need to be updated.

      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.

   3. Click Export to start the export process.
3. Make the required changes to the csv file that you exported.
4. Now import the revised file. In the Reconciliation List, click Actions, then Import, and then Import Attributes.

   The Update Reconciliations dialog displays.

   1. In File, browse and select 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.
   5. Once the import completes successfully, you can see the import changes by going into Edit Reconciliations dialog.

   The optional selections that you can use in the Update Reconciliations dialog are:

   • Run Rules- runs rules on reconciliations after you import the changes. The default is None.
   • Reopen on Change - changes the status of reconciliations that have been revised to Open.
   • File Delimiter - selects a different file delimiter (defaults to comma).