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
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
- Each bank account in Administration → Setup → Banking → House Bank Accounts points to the correct G/L account.
- The G/L account is flagged as a Cash Account so it appears in bank reports.
- Your bank statement format (MT940, CAMT.053, or CSV via the Bank Statement Format setup) is assigned to the house bank account.
- The opening balance in SAP matches the bank's opening balance for the first statement you import.
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