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 Saudi Arabia

Some lines on a Saudi company's statement belong to filings, not to customers or suppliers. Match the VAT paid to ZATCA by recording it against its return rather than as an expense, so the VAT accounts clear. GOSI contributions are due within the first 15 days of the following month, and salaries follow the pay run whose Mudad file went to the bank; accept each against its posting. Bank charges with no document go through Record as expense.

Read next for Saudi Arabia