Automatically Creating Incoming Payments to Reconcile Bank Statements

In the Process External Bank Statement window, if the amount recorded in a row is a credit amount and represents an incoming payment from a customer using a bank transfer, SAP Business One can create the relevant incoming payment document automatically.

Procedure

From the SAP Business One Main Menu, choose Banking Bank Statements and External Reconciliations Process External Bank Statement .
From the G/L Account dropdown list, select G/L Account and specify the code of the G/L account for which you want to record the incoming payment.
Move the cursor to the first empty row and specify the details as they appear on the statement you received from the bank. For more information, see Recording Transactions from External Statements.
To create an automatic incoming payment, select the Create Payment checkbox and specify the remaining information
To save the information, choose the Update button.

Result

SAP Business One creates an incoming payment using a bank transfer. Then SAP Business One creates two reconciliations:

Internal reconciliation for the incoming payment with the invoice of the customer. The reconciliation type set for this reconciliation is Payment.
External reconciliation for the incoming payment with the transaction from the bank statement. The reconciliation type set for this reconciliation is Manual.

More Information

Process External Bank Statement Window