Bank Statement Processing – Documents Not Displayed i...

[#1]

We are using the Bank Statement Processing functionality in SAP Business One to perform automatic bank reconciliation by importing bank statements in CSV format.

The bank statement is imported successfully without any errors. However, after the import, when we click Posting Proposal for Uncleared Rows, the corresponding SAP Business One documents (such as Incoming Payments, Outgoing Payments, or other relevant transactions) that should be available for reconciliation are not displayed.

As a result, we are unable to proceed with the automatic reconciliation process.

Could you please guide us on the following:

• What are the prerequisites for documents to appear in the Posting Proposal window?
• What matching criteria does SAP Business One use to identify and display documents for automatic reconciliation?
• Are there any mandatory configuration settings or mapping requirements that need to be completed before using this functionality?
• Are there any mandatory fields in the imported CSV file that are required for the posting proposal to identify the corresponding SAP Business One documents?

Please let us know if there are any additional settings or checks that we should perform to resolve this issue.

[hdolenec]

I think you might be using BSP the wrong way. When you import bank statement, the idea is that you have open invoices for which you will generate payments and reconcile them.

So when you click on Posting Proposal, the system should match bank statement line to some open invoice. After that, you Finalize the bank statement, which will generate payment document with postings and reconciliation between invoice and payment.

So now you need to set bank statement matching criteria so that Posting Proposal can match statement line with open invoice (by using payment reference most commonly).