Skip to Content
avatar image
Former Member

Automatic bank reconciliation in SAP Business Bydesign

Hello,

Can we do automatic bank reconciliation using SAP business bydesign

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 17, 2017 at 03:07 PM

    Hello,

    You can use memo lines to allocate the payments automatically for automatic bank reconciliation.

    You can refer to help documents "Memo Line Analysis Rules" and "Creation of Memo Line Analysis Rules for Common Use Cases" for more details.

    Best Regards,

    Annapurna

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      There are different cases, for example for payment advices, where the bank statement item document id is used as a search text to try and complete the allocation. But for invoices etc it is done on the memo line.
      In invoice case, first you need to maintain the memo lines and then need to upload the file and then it will allocate payment automatically.

      Bank Statement upload creates items, these will have payment allocations. Depending on the import format and the file provided, some information will be places in the memo lines of the corresponding payment allocation. Then when the Bank Statement is posted, the payment allocations will try a 'Propose' action. This uses the memo lines provided and cross checks with the memo lines rules that are in the system, it then tries to find a match that corresponds to the rule. If a match is made, then the payment allocation is posted.

      So you need to maintain the memo lines before uploading the file.

      Best Regards,
      Annapurna