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 United Arab Emirates

Reconcile before you prepare the VAT 201, which is due by the 28th day after the period ends, so the cash side of the books agrees before you take figures from them. When the line for your VAT payment to the FTA appears, match it to the payment recorded against that return instead of booking it as an expense, so the VAT accounts clear. Accounts held in other currencies reconcile next to your AED accounts, since the books are multi-currency.

Read next for United Arab Emirates