Show TOC

Procedure documentationSetting Up Matching Criteria Locate this document in the navigation structure

Procedure

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   Administration   Setup   Banking   Bank Statement Processing  , 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   Administration   Setup   Banking  ). 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 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

End of the note.