Matching criteria are sets of rules that let SAP Business One match transactions in the manually entered bank statement to existing transactions, for internal reconciliation.
SAP Business One uses these matching criteria based on the posting methods specified in the Posting Method
column in the Internal Bank Operation Codes
window under , or in the bank statement row.
Documents – rules for when the specified posting method is Business Partner from/to Bank Account
for reconciling the following:
Sales – A/R documents, such as invoices issued to customers and the related incoming payments.
Purchasing – A/P documents, such as invoices received from vendors and the related outgoing payments.
BP Journal Entries – rules for when the specified posting method is Business Partner from/to Bank Account
. Since journal entries have different matching parameters from those of sales and purchasing documents, there is a separate set of matching criteria for journal
entries.
Interim Account – matching criteria to be used for automatic internal reconciliation of the G/L bank interim account (defined in the G/L Interim Account column in the House Bank Accounts – Setup
window under ). The interim account matching criteria are used when the selected posting method is Bank Interim Account from/to Bank Account
.
External Reconciliation – matching criteria to be used for performing automatic external reconciliation when the specified posting method is External Reconciliation
.
You can define up to 3 successive rounds for the matching criteria, as needed. When automatic selection of transactions for reconciliation takes place, SAP Business One first selects transactions according to the rules defined in round 1, then selects the transactions that were not compliant with round 1 but comply with round 2, and finally selects the transactions that comply with the rules defined in round 3 only.
If transactions are selected in round 1 for a specific bank statement row, then rounds 2 and 3 are not performed. When transactions are selected in round 2, then round 3 is not performed.
If no transactions are selected, then internal reconciliation cannot take place automatically, but the bank statement row can still be processed and the relevant associated transaction (as per the associated posting method) created. This transaction can then be internally reconciled using the manual internal reconciliation screen, after the bank statement is finalized.
Note
Since there is a dependency between the rounds (round 2 is applied only after round 1 has been applied and transactions have not been discovered, and round 3 is applied only after rounds 1 and 2 have not discovered transactions), only the following combinations of rounds are available:
Round 1 and round 2 and round 3
Round 1 and round 2
Round 1
The following combinations are not available:
Round 1 and round 3
Round 2 and round 3
Round 2
Round 3