Updating Reconciliation Attributes Using a Delimited File

You can make reconciliation attribute updates by importing a delimited file.

Here are two examples of how using a delimited import file could be useful to your company:

• If you are working with data that comes in after a reconciliation has already been created but is important to your reconciling process such as percent sales.

  For example, 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. If the final sales data is not ready and must be added after the reconciliation is created, this procedure gives you the ability to add the sales data later.

• Another example is when you need to make Org changes mid cycle for certain reconciliations. Since the reconciliations are already created, you can use the attribute import by using a delimited file to load in the changed values.

The high level steps for updating reconciliation attributes through a delimited 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 Rows, select Selected reconciliations to export details of the reconciliation.
   2. In Format, select Unformatted data for future attribute import.
   3. 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.

   4. 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 Import Attributes 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 Reconciliations dialog or by adding the attributes to the reconciliation list view.

   The optional selections that you can use in the Import Attributes 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).