Auto-Match by Account

In addition to performing the matching process using the transaction ID, you can match the transactions based on specific accounts and matching accounts. The system performs the matching process for the entity and partner that you specify. The transactions to be matched are grouped by transaction currency during the matching process and are assigned a separate match code for each currency group.

For each transaction included in the matching process, the system first translates the transaction currency amount to the application currency, based on the default translation rules set up for the application. The translated amount is added to the total difference amount. The system performs the translation for each transaction in the auto-match process and the difference amount is calculated.

Note:

The conversion rate used in translation is the rate that is stored in the Rate account for the specific currency to the application currency.

After the total difference amount is calculated, this amount is compared to the matching tolerance amount set for the period. The matching tolerance amount is represented in the application currency and the amount should be entered in the scale of the application currency.

If the difference amount is within the tolerance level, the transactions are considered matched and the system assigns a match code to the group of transactions.

If the different amount is not within the tolerance level, the system performs the next step in the translation process by translating the entity currency amount to the application currency. For any transactions without a transaction currency, the system uses the entity currency amount. If the difference amount is within the tolerance level, the transactions are considered matched and the system assigns a match code to the group of transactions.