cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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.

0 Likes
View Entire Topic
Maya_Shiff
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi,

Thank you for your inquiry, please check out the following guides:

Working with Bank Statement Processing | SAP Help Portal

External Reconciliation | SAP Help Portal

Regards,

Maya