Open CAPPS

Import a bank statement

Version 2026.11 Reading time: 5 min Permission required: “Bank reconciliation” accounting permission

Import the statement exported from your bank: its transactions appear in bank reconciliation, and those that clearly match a collection are reconciled automatically.

Accepted formats

  • Branch in Morocco: CSV file exported from your bank (Attijariwafa, BMCE, CIH, Banque Populaire, and others).
  • Other countries: CSV or MT940 file (.sta, .mt940).
  • Maximum size: 5 MB.

The Accepted formats tile on the screen shows your branch's formats and the number of statements already imported.

Steps

  1. Open the Accounting operations menu, Bank reconciliation tab, then click Import a statement.

  2. Check the Branch bank account. CAPPS preselects the account whose RIB appears in the file (label Account recognized in the statement), otherwise the default bank account for the branch's currency. Only active bank accounts are offered. The — (not linked) choice is still available.

  3. Enter the Bank (required) and, if needed, the Account (RIB / IBAN). The RIB key and the IBAN check digits are verified.

  4. Drop the file in the Drop the statement here or click to choose area.

  5. For a CSV file, check the Columns step: Separator, Header rows, Date Format, Decimals, then the Date, Label, Reference (optional) and Amounts columns: One signed column (Amount column) or Debit / Credit (Debit (money out) and Credit (money in) columns). Check the result in the Interpreted preview. For an MT940 file, the step is called Verification and needs no settings.

  6. Leave Remember this profile for this bank selected to reuse these settings at the next import (Saved profile list).

  7. Click Import.

CAPPS shows the number of transactions imported, already known and reconciled automatically. The list then opens on the imported statement, filtered on To reconcile transactions.

If the Import button is grayed out, the reason appears just below it: no file chosen, bank missing, column to choose, or two identical columns (date, label and amount must be in different columns).

What CAPPS refuses

  • “File too large (5 MB maximum).” or “Empty file: no transaction to import.”
  • “Format not recognized”: the file is not a CSV statement (a PDF or Excel file is refused), or no transaction in it can be read. Export the statement in CSV format from your online banking.
  • “This file was already imported on …”: the same file cannot be imported twice.
  • Only the branch's active bank accounts are offered: a cash desk or an inactive account cannot receive a statement.

A transaction already present in a previous statement is not imported a second time: it is counted as “already known”. CAPPS also warns you about possible duplicates within the file, and when the statement shows a different account from the one you chose.

Next step: Reconcile a bank transaction.