Manually Matching Transactions with Tolerance Amount

At times, you might need to manually match the transactions with the partner’s transactions because of discrepancies in the recording of the transaction ID or small discrepancies in the amounts. When you perform the manual matching process, the system updates the transaction status to Match and generates a match code for the transactions.

To match a transaction manually, you must be assigned the Intercompany Transaction Manual Match with Tolerance security role.

To perform the manual match process, you can use filter options to display only the unmatched transactions for a specific entity and partner pair. You can select the group of transactions and perform the manual match process.

The system must first check if any transactions have a Mismatched status before you perform the manual match process. During the manual match process, the system checks to see if the transactions are a valid pair of transactions. For example, if you select transactions between A and B, and transactions between B and A, the transactions are considered a valid pair. If you select transactions between A and B, then select transactions between B and C, the transactions are not considered a valid transaction pair.

You cannot use single-sided transactions without the valid partner transactions for the Manual Match process. For example, you cannot select two transactions of A with B, A with B.

If you have the Manual Match with Tolerance security role when you perform the matching process, the system also checks if the amounts are matched for the transactions. The system performs the translation process to the application currency. For each transaction included in the matching process, the system first tries to match the transaction using the translation currency amounts by translating the transaction amount to the application currency, based on the default translation rules set up for the application, and applies the amount to the difference. If the difference amount is not within the matching tolerance, the system then translates the entity currency amount into the application currency and compares the difference amount to the Matching Tolerance that you specified for the period.

If the amount is within the tolerance level, the transactions are considered Matched and the system assigns a match code to the group of transactions. See Matching Status and Match Code.

If you have the Manual Match security role, the system does not check the tolerance amount. See Manually Matching Transactions without Tolerance Amounts.

During the manual match process, transactions are not grouped by transaction currency. Therefore, you can select transactions in different transaction currencies and the system translates each transaction separately.

Account Type Groups in the Manual Match Process

During the manual match process, the system subdivides all the intercompany transactions with the same transaction or reference ID into separate groups based on their account type. The entire group of transactions within the manual match process must be matched before the transactions can be assigned a Matched status and a match code.

If both subgroups are matched, the system assigns all of the transactions the Matched status and assigns them one match code. If only one subgroup is matched, but the other is not, all of the transactions are considered mismatched.

The transactions are grouped by their Balance Sheet or Profit/Loss account type as follows:

Balance Sheet group

• Asset

• Liability

• Balance

• Balance Recurring

Profit/Loss group

• Revenue

• Expense

• Flow

Example

In the following example, the intercompany transactions all have the same transaction ID 123:

Entity	Partner	Account	Amount	Account Type
A	B	Recltic	100	Asset
A	B	Sales	110	Revenue
B	A	Payltic	100	Liability
B	A	Cog	100	Expense

The system subdivides the transactions into the BS and PL groups as follows:

BS Group

A, B, Recltic, 100, Asset

B, A, Payltic, 100, Liability

Subgroup status: Matched.

PL Group

A, B, Sales, 110, Revenue

B, A, COG, 100, Expense

Subgroup status: Mismatched.

The result is that because only one subgroup is matched and the other is not, the system considers all transactions mismatched, and assigns all transactions in this manual match process a Mismatched status and no match code.

To match intercompany transactions manually:

1. Select Consolidation, then Intercompany, and then Manage.
2. From the transactions list, select the checkbox next to the transactions that you want to match.
3. Click Manual Match, or select Actions, and then Manual Match.