Show TOC

Procedure documentationPerforming Manual Reconciliation Locate this document in the navigation structure

 

When you generate a posting proposal, it is likely that some of the bank statement rows will not be automatically matched. For example, if you cannot identify which business partner an unmatched payment relates to, you will not be able to assign a business partner code. You cannot finalize a bank statement until every bank statement row is cleared.

Bank statement rows are only automatically matched if the posting proposal returns an unambiguous result. To reconcile any unmatched or inadequately matched rows, you need to perform manual reconciliation.

Note Note

Manual reconciliation is not available for payments to account, but you can still enter or change payment accounts in the Bank Statement Row - Details Expanded window.

End of the note.

Prerequisites

At least 1 posting proposal has been defined in the Bank Statement Details window under   Banking   Bank Statement and External Reconciliation   Bank Statement Processing   Bank Statement Summary  .

Procedure

  1. In the Bank Statement Details window, double-click the row number of a bank statement row. The Bank Statement Row - Details Expanded window appears.

  2. In the general area and in the table area, specify the required information. You can add further documents or transactions as possible matches for reconciliation as follows:

    • To access a list of open sales and purchasing documents, choose the Add Open Documents button. The Add Open Documents window appears.

    • To access a list of open journal entry transactions by business partner, choose the Add Open BP JEs button. The Add Open BP JEs window appears.

    • To access a list of open transactions, choose the Add Open Transactions button. The Add Open Transactions window appears.

  3. Select a document or journal entry row and choose the OK button.

  4. In the Bank Statement Row - Details Expanded window, select document or journal entry rows as required. To prevent unselected rows appearing in the Bank Statement Details window, select the Discard Unselected Rows checkbox.

  5. Choose the Update button.

Result

The selected document or journal entry is matched to the relevant bank statement transaction row in the Bank Statement Details window.