Banking

The Banking area shows your saved bank accounts and all account movements (transactions) in one place. You can import bank statements, match incoming and outgoing payments to orders and invoices automatically or by hand (this matching is called "reconciliation"), and keep track of which payments are already booked and which are still open.

What can I do here?

• View a 30-day overview: number of transactions, reconciled and open transactions, balance
• Create, edit, and delete bank accounts (account name, IBAN, BIC, bank name)
• Check the current balance and transaction count of an account
• Upload or paste bank statements in CSV, MT940, or CAMT.053 format (common bank file formats)
• Filter, sort, and page through transactions by account, date range, status, and search term
• Match a single transaction to an order or invoice — automatically from suggestions, or manually by entering an ID
• Undo a match on a transaction so it becomes open again
• Automatically match all open transactions of an account in one step (batch reconcile)
• Export the transaction list as a CSV file

Step by Step

1. Create a bank account: Open the "Bank Accounts" tab and click "Add Account". Enter an account name, IBAN (International Bank Account Number), and optionally the BIC (Bank Identifier Code) and bank name, then save with "Create".
2. Import a bank statement: Switch to the "Import" tab, choose the bank account and the file format (CSV, MT940, or CAMT.053), drag the file into the drop zone or paste the data into the text field, and click "Start Import". The result shows how many transactions were imported, how many were skipped as duplicates, and how many were auto-reconciled.
3. Match a transaction manually: Open the "Transactions" tab, find an open transaction, and click the link icon. In the panel that opens you see match suggestions with a confidence score (how well the suggestion fits). Click a suggestion, or enter an order ID or invoice ID manually, then confirm with "Assign".
4. Use batch reconcile: On the overview page click "Batch Reconcile" to have all open transactions checked automatically. Only suggestions with a high confidence are applied automatically.

flowchart LR
    A[Import bank statement] --> B[New transactions are saved]
    B --> C{Automatic match<br/>possible?}
    C -->|High confidence| D[Auto-reconciled]
    C -->|No reliable match| E[Marked as open]
    E --> F[Match manually<br/>or batch reconcile]
    F --> D

Fields Explained

Values & Status

Transaction Status

Import Formats

Frequently Asked Questions

What does "reconciled" or "matched" mean for a transaction?
It means a payment on your bank account has been linked to a specific order or invoice in SCS, so you can see at a glance which payments have already been booked.

How does automatic matching work?
During import and batch reconcile, the system checks every open transaction for possible matches with orders or invoices. Only a high-confidence match is applied automatically; lower-confidence matches stay open for manual review.

What is the IBAN, and is it stored securely?
The IBAN is the internationally standardized account number. In SCS it is stored encrypted and automatically validated when you create an account.

Can I undo an incorrect match?
Yes. Open the transaction and click the "undo match" icon. The transaction is then marked as open again.

Which file formats can I use for import?
CSV, MT940, and CAMT.053 — common export formats offered by most banks for statements.

Related Topics

• DATEV Export
• lexoffice