Auto-Match by Transaction ID

Performing the auto-match process using the Transaction ID is the most common and accurate method of matching intercompany transactions. The system performs the auto-match process by Transaction ID using the current filter selected for Entity/Partner/Transaction ID/Transaction Currency. If you filter for Reference ID and perform an auto-match, transactions are matched based on Entity/Partner/Reference ID/ Transaction Currency in the current filter. You cannot filter both Transaction ID and Reference ID at the same time and perform an auto-match

If you want to use a different method of matching, you select the Auto-Match Template option. See Using Auto-Match Templates.

You can specify an ID or use wildcards. If the ID is left blank, the system matches all transactions for the entity and partner.

When matching transactions using the transaction ID or reference ID, the system always uses the transaction currency. There is no need to specify a tolerance amount because the transactions are considered Matched only if the amounts match without error. The system assigns a separate match code to each group of transactions.

If you have transactions with different currencies but the same transaction ID or reference ID, during the auto-match process, the transactions are matched by currency group. If all the transactions in all the currency groups are matched, the system assigns one match code to all the transactions.

Table 10-6 Sample Transactions with Same ID and Different Currencies

Transaction ID	Entity	Partner	Currency
T123	A	B	EUR
T123	B	A	EUR
T123	A	B	USD
T123	B	A	USD

In this example, if the transactions in EUR are matched and the transactions in USD are matched, the system assigns one match code for all four transactions. If the transactions in EUR match but the transactions in USD are not matched, the system considers all of the transactions Mismatched.

The following table shows the rules for matching transactions using IDs:

Table 10-7 Matching Process Using Transaction or Reference ID

Matching Process	Entity’s Transactions	Partner’s Transactions	Comments
Match using Transaction ID	Transaction ID	Transaction ID	The system matches the entity’s transaction ID with the partner’s transaction ID.
Match using Reference ID	Transaction ID Reference ID Reference ID	Reference ID Transaction ID Reference ID	The system first matches the entity’s transaction ID with the partner’s reference ID. If these do not match, the system performs the second test by comparing the entity’s reference ID with the partner’s transaction ID. If still not matched, the system performs the third test by comparing the entity’s reference ID with the partner’s reference ID.

Account Type Groups in the Auto-Match Process

During the auto-match by ID process, the system subdivides all the intercompany transactions with the same transaction or reference ID into separate groups based on their account type. It assigns a separate match code and match status to each group of transactions with the same ID.

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

For each group of transactions, the system assigns a match status and separate match code. For example, the Balance Sheet group of transactions could have a Matched status and be assigned a match code, but the Profit/Loss group of transactions could have a Mismatched status.

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. The system assigned a match code to this group.

PL Group

A, B, Sales, 110, Revenue

B, A, COG, 100, Expense

Subgroup status: Mismatched. No match code is assigned to this group.