Transaction Matching

If you want to allocate transactions on an account without entering any transactions to the ledger, you can use Transaction Matching (TRM). This automates the allocation process within the criteria you specify.

Transaction Matching is similar to Account Allocations (ACA) and the online allocation function in Ledger Entry. It allows you to allocate or match transactions. However, Transaction Matching goes a step further by enabling you to automate the allocation/matching process.

An account type and range of account codes are entered, and depending on other criteria specified, matching debit and credit transactions on an account are selected and matched. During the matching process, settlement discount, tax on settlement discount, and currency exchange gain and loss transactions, can be generated.

Note:  If the Allocations Locking Allowed option on Business Unit Setup is set to lock at transaction level, any transactions that are locked by another user will not be matched. If these transactions were eligible for matching they are identified on the matching report.

Selecting Transaction and Matching Criteria

You can select transactions for matching by transaction analysis code, currency code, transaction reference, and allocation marker.

You can also choose up to three match criteria. The same options are available as for selecting transactions. If you specify three match criteria, all three transaction values must be the same for the transactions to match.

Note:  You cannot match transactions purely on amount; you must enter some additional sort of selection/matching criterion.

Discounting

If you are matching debtor/receivables, creditor/payables, or client accounts, Transaction Matching generates any settlement discount and tax on settlement discount postings for you. You can specify the account to which discounts must be posted and discount tolerance limits. If the discount falls outside the tolerance limit, the transactions are not matched.

Matching Currency Transactions

You can match transactions using either the base currency amount or the transaction currency amount. You can also choose to match on the memorandum amount.

If you want to match on the transaction currency amounts, you must enter currency code as one of your match criteria. When you match by transaction currency amount, currency gains or losses may be generated.

Posting and Reporting Transactions

You can choose to post the allocations or simply to report on the allocations. If you choose to post, the allocated transactions are assigned account specific allocation references.

You can choose to report on any transactions that fall within your selection criteria but remain unmatched after running Transaction Matching. You can report on all unmatched transactions, unmatched debits, unmatched credits, or you can specify that no report is required. Additionally you can produce a report of your matched transactions.

Exclusive functions

Several SunSystems modules may cause locking of the application, when run concurrently. For data integrity reasons, these modules cannot be run at the same time with the Transaction Matching (TRM) module:
  • Business Unit Create
  • Daybook Listing
  • Ledger Revaluation
  • Ledger Cleardown
  • Post Withheld Taxes
  • Payment Voiding
  • Calculate Depreciation
  • Asset Disposal Selection
  • Business Unit Setup
  • Payment Collection Run
  • Payment Run