How to import a bank statement and reconcile it

Import the statement, accept the matches Aqid ERP suggests, book what has no document, and finish balanced.

Steps

  1. Import the statement

    Choose Banking → Reconcile, then Import statement; drop a CSV, camt.053 or MT940 file. A CSV's columns are mapped once and remembered.

  2. Accept matches

    For each line choose Find match and Accept the payment or document that matches it.

  3. Book the rest

    A bank charge or expense with no document: choose Record as expense and its account; Exclude what does not belong.

  4. Finish balanced

    The workbench shows the difference; at zero every transaction is matched.

Was this guide helpful?

More guides

In Bahrain

Dinar amounts carry three decimals, and the ledger keeps fils too, so each statement line matches its payment to the fil rather than after rounding. Under the enhanced Wage Protection System, salaries go out through the LMRA's WPS portal. Match those debits to the net pay each payroll run posted, so the payroll, the uploaded wage file and the payment can be matched if the LMRA asks. Record bank charges with Record as expense rather than leaving them open.

Read next for Bahrain