Bank Statement Import → SAP B1 BSP + Reconciliation

Bank → SAP B1. Fetch MT940 / camt.053 (SFTP or bank API) → parse → post to SAP B1 Bank Statement Processing (BankStatements). Auto-match rules on amount + reference + BP; unmatched lines go to a suspense account. When the reference contains an invoice number, alternatively post as IncomingPayments matched via NumAtCard. Duplicate statement detection on statement number + account.

Steps in this flow

  1. Bank: Statement File Available
  2. Fetch Statement File (SFTP)
  3. Parse MT940 / camt.053
  4. Guard: Statement No + Account
  5. SL Login (B1SESSION)
  6. Reference Has Invoice No?
  7. SL: Match Invoice by NumAtCard
  8. SL: POST /IncomingPayments
  9. SL: POST /BankStatements (unmatched→suspense)
  10. Log Reconciliation Result

All templates