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 Oman

Amounts are matched to the baisa, since rials carry three decimals. Expect a VAT payment to the Tax Authority each quarter: record it against its return under Reports, Tax, then accept that payment as the match instead of booking the line as an expense. Salary transfers need the same care. The WPS salary file is written from each approved pay run and uploaded to your bank by you, and the bank's lines are matched to the net pay that payroll posted.

Read next for Oman