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 Kuwait

Dinar amounts carry three decimals across the ledger, so a statement line matches to the fils. Reconciling also evidences payroll: an employer with five or more workers must pay wages into their accounts at local financial institutions, no later than the seventh day after they fall due, and the Public Authority for Manpower suspends the file of an employer whose salary transfers are missing. Aqid ERP does not yet produce a WPS salary file for Kuwait's banks, so pay net salaries from your bank and match each transfer here.

Read next for Kuwait