Selecting Accounts and Transactions for Matching

Transaction Matching (TRM) uses match criteria to try to match transactions automatically. You can determine the accounts and transactions to be considered for matching.

To select the transactions for matching you must first identify the accounts you wish to process. You can select the accounts by account type and/or account range.

Selecting the Account Type

You can only choose one account type per run. This can be either debtor, creditor, client, profit and loss, memo, or balance sheet.

If you choose client accounts and you are posting discounts, the system ensures that the larger value is an invoice and the smaller value a payment. Discount percentages and tolerances are applied to try and match the transactions.

For debtor accounts, no match is made if a credit value is larger than a debit value. For creditor accounts, no match is made if a debit value is larger than a credit value.

Selecting the Accounts

You can select a range of account codes within your chosen account type. For example, you may only want to match transactions for a group of debtors or creditors. Closed and suspended account codes are excluded from Transaction Matching.

Selecting the Transactions

Within the account type and account range specifications, you can choose up to three additional selection criteria to restrict the transactions selected for matching, for the accounts.

You must choose at least one selection criterion. A transaction must meet all of the selection criteria to be considered for matching.

The following selection options are available:

Currency code
Transaction reference
Allocation marker
Ledger transaction analysis dimension codes 1 to 10
Link Reference 1 (Billing Link)
Link Reference 3 (Accounting Link)
Signing Details
Posting Reference
General Description 1 to 25 (Additional Fields)
General Date 1 to 5 (Additional Fields)

A cutoff period can also be defined, beyond which transactions are not selected.