Back to Tutorials
Financials•3 min read
TUTORIAL • FREE MEMBER

Bank Reconciliation in SAP B1: Importing Statements & External Reconciliation Done Right

Stop ticking bank lines by hand. Set up bank statement import, matching rules, and a clean reconciliation routine your auditors will love.

SB1

SAP B1 Academy Editorial

Published • 3 min read

Save
Matching bank statement lines to ERP payments.
Matching bank statement lines to ERP payments. (Image source: SAP B1 Academy Lab)

Reconciling the bank is the single most valuable control in a small finance team, yet many SAP Business One companies still tick off statement lines on paper. The Bank Statements and Reconciliations module can do most of the matching for you once it is configured properly.

Two Ways to Reconcile

  • Manual Reconciliation (External Reconciliation): you enter or import statement lines, then match them against G/L journal lines on the bank account. This is the classic method and works in every localization.
  • Bank Statement Processing: an end-to-end flow where imported statement lines can create incoming and outgoing payments directly, then reconcile them in one step.

Prerequisites Checklist

  1. Each bank account in Administration → Setup → Banking → House Bank Accounts points to the correct G/L account.
  2. The G/L account is flagged as a Cash Account so it appears in bank reports.
  3. Your bank statement format (MT940, CAMT.053, or CSV via the Bank Statement Format setup) is assigned to the house bank account.
  4. The opening balance in SAP matches the bank's opening balance for the first statement you import.
Free Member Content

Create a free account to unlock the full step-by-step guide & copy the production SQL script.

Join SAP Business One consultants and key users worldwide. Free forever, no credit card required.

or use a magic link