Mapping Attributes to Journal Attributes

After you create the necessary journal columns, you need to map your attributes to journal attributes using the Journal Attribute Mapping option on Edit Match Type

For adjustments, you work on a per Match Type basis, and you map the journal columns to the Reconciliation Account and Offset Account.

For transactions you work on a data source basis, and map the data source attributes to journal attributes.

To map adjustment attributes to journal attributes:

1. From Home, select Applications, then Match Types.
2. From the Actions menu of the match type you want to work on, select Edit.
3. In the Edit Match Type dialog, select Journal Attribute Mapping.
4. Under Mapping for, select either Adjustment or one of the data sources displayed in the drop-down.
5. For each Journal Column, select the attributes from the drop down list for Reconciliation Account and Offset Account.
6. Once you have made all selections, click Save.

   Note:

   You need to save the mapping for Adjustments before continuing on to save your mapping for each data source.

Example 1. Journal Attribute Mapping for Adjustments

Here is an example of attribute mapping for Adjustments.

The mappable attributes include Match ID and Reverse Status. The Reverse Status attribute is empty for regular adjustments and is Reverse Adjustment for reverse adjustments. Service Administrators can differentiate between an adjustment and reverse adjustment by mapping the Reverse Status attribute to either or both of the Reconciliation and Offset Account sides. By mapping the Match ID attribute through to the journal adjustment, you can trace it back to the original adjustment's Match Id. Note that the Reverse Status attribute is applicable only for adjustments, not for transactions.

Example 2. Journal Attribute Mapping for Data Source Accounts Payable

Here is an example of attribute mapping for a data source Accounts Payable.