Match Transactions—Key Exercises

Required Data

Voucher Entry. For instructions on how to do this, see the Manual Postings lesson.

Main Exercises

Match Open Items

Purpose: The purpose of this lesson is to show you how to match one or more debit transactions from one specified account with one or more credit transactions from the same account.

Prerequisites: Transactions with debit and credit amounts for the selected account must exist in the general ledger. These transactions must be balanced for the final matching, i.e., the debit amount of all matched transactions must equal the credit amount. If the total is not balanced, the transactions can still be saved temporarily.

Windows:
Account Matching

1. Specify the account for which you want to match transactions.
2. Enter a date or period. All transactions up to and including this date/period are displayed for matching.
3. Click OK. The unmatched transaction rows for the selected account up to and including the specified date are displayed on the screen. The preliminary matched transactions are also displayed.
4. Select the rows that you want to match. You can do this either by selecting the Match Transaction check box for each row or by selecting the appropriate right mouse button option. The selected rows are displayed in the lower part of the window.
5. Save your changes to confirm the matching.

Note: When balanced transactions are matched, they are updated with a matching date and matching number. If the debit and credit amounts are different, i.e., the difference is not zero, the matching can still be saved with a preliminary matching number, i.e., a number starting with PR.

View Unmatched Transactions

Purpose: The purpose of this exercise is to show you how to view the unmatched transactions that should add up to the open account balance.

Windows:
Unmatched Transactions Report

1. Select the period or date through which the report should show the unmatched transactions.

2. Select the accounts. 

3. Preview or print the report.

Note: The report also displays rows that are preliminarily matched.

Cancel Matching

Purpose: The purpose of this exercise is to show you how to cancel a performed matching of transactions.

Prerequisites:Account Matching

Windows:
GL Voucher Rows Analysis
GL Voucher Details Analysis

1. Open either of the general ledger query windows listed above.

2. Select one or more rows that have information in the Matching fields (Matching Date, Matching Period, Matching ID). Right-click and then click View Matched Transaction. The View Account Matching window is displayed on the screen.

3. Select a matching number, right-click, and then click Cancel Matching.

Note: The Matching Date, Matching Period and Matching ID fields are cleared when the matching is canceled.

Enter Account Info 

Purpose: The purpose of this exercise is to show you how to specify whether unmatched transactions should be included when the archiving routine is run. All general-ledger transactions for a specified accounting period can be archived.

Windows:
Account
Accounts

1. Open either of the windows listed above.
2. Find the account where the archive options will be set.
3. Indicate whether all transactions should be archived, or if only matched transactions should be included.

Note: A transaction row in IFS/General Ledger is designated as unmatched if the Matching ID field either is blank or contains a preliminary matching number. Later, as transactions like this are matched, a new archiving is made for these periods to remove them from the active tables.