Show TOC

Object documentationExternal Reconciliation - Selection Criteria Window Locate this document in the navigation structure


Use this window to define the criteria for selecting transactions for external reconciliations.

To open the window, choose   Banking   Bank Statements and External Reconciliations   External Reconciliation  .

Select Source

To specify whether to reconcile transactions of a business partner or G/L account, from the dropdown list, select Business Partner or G/L Account.

From... To...

In the From field, specify one business partner or one G/L account code you want to reconcile. This field is mandatory.

Due Date To

Displays by default the current date; specify a different date if required. Transactions with a due date earlier or equal to the displayed date are reconciled.


Choose to start the reconciliation.

Reconcile by Totals Only

Selecting this radio button:

  • Enables the reconciliation of transactions with matched amounts.

  • Displays the Variation in Days checkbox.

    If you want SAP Business One to tolerate due-date differences between transactions with matching amounts, select the Variation in Days checkbox. Then specify the number of days SAP Business One uses to consider whether reconciliation takes place; the difference must be equal to or below the value you specify here. When left empty, this field is considered to have a zero value.

    Example Example

    You selected Due Date as a matching rule and specified the Variation in Days as 3. The due date of an invoice is October 1, 2009, and there is a payment for the exact amount with the posting date of October 6, 2009. The difference is five days. In this case reconciliation does not take place.

    End of the example.
Totals with Restrictions

Selecting this radio button:

  • Enables the reconciliation of transactions with matching amounts that also comply with additional conditions based on reference and date.

  • Displays the Reference checkbox. If you select this checkbox:

    You can define additional conditions based on one of the references. From the dropdown list, select Ref. 1, Ref. 2, and Ref. 3, which are fields in the Journal Entry window.

    The Relate to .... Last Characters appears. Specify a number to indicate how many alphanumeric characters of the selected reference are to be used an additional condition for matching during automatic reconciliation. The alphanumeric characters are counted from right to left, and 0 (zero) is considered in the same way as other digits. For example, if the reference is AZ2010ETL and the Relate to…Last Characters field is set to 4, then 0ETL is used for matching.

  • Displays the Date checkbox. Selecting this checkbox applies the posting date or due date as a condition for automatic reconciliation.

Reconciliation Difference

Note Note

The field is active only when you have defined the automatic reconciliation difference account.

End of the note.

Enables reconciliation of transactions with nonidentical amounts. In this field, specify the difference amount that should be considered when automatic reconciliation is performed. Differences found during reconciliation are posted to the automatic reconciliation difference account. For more information, see Defining an Automatic Reconciliation Difference Account.


SAP Business One can take into account certain parameters when preparing the recommendation for reconciliation. You can define the following parameters:

  • Amount – Enables SAP Business One to include transactions with different amounts in the reconciliation recommendations. Enter the amount in the Max. Deviation column.

    Note Note

    This parameter influences the recommendation results only. If you choose to reconcile transactions with an amount difference (based on the recommendations), you must create the corresponding balancing transaction to complete the reconciliation.

    End of the note.
  • Date – Select the date on which reconciliation recommendations should be based: either the due date or the posting date. See also the Max. Deviation field.

  • Reference – Select the reference according to which you want the reconciliation recommendations to be made.

Priority Weighting

Determines the priority order in which each parameter is used by SAP Business One when ranking the generated recommendations. Specify the weighting for each parameter: high, medium, low, or skip.

If you choose Skip, SAP Business One ignores the parameter when it is generating the reconciliation recommendations. For more information, see Calculation of Ranking for Reconciliation Recommendations.

Note Note

Skip is not available for the Amount parameter.

End of the note.
Max. Deviation

Specify the maximum deviation SAP Business One should consider when generating the reconciliation recommendations for the following parameters:

  • Amount

    Specify the maximum difference between transaction amounts above which SAP Business One does not recommend reconciliation. If you do not specify an amount, SAP Business One includes transactions with no amount differences in the reconciliation recommendations.

  • Date

    Specify the difference in number of days between the dates assigned to the transactions above which SAP Business One does not recommend reconciliation. If you choose to consider this parameter and you do not specify any value, SAP Business One includes transactions with no date differences in the reconciliation recommendations.