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 Qatar

Wages in Qatar go by bank transfer through the Wage Protection System, since paying them in cash is not allowed, so each month's salary transfers appear on the statement to match against the net pay the payroll run posted. The withholding tax paid to the General Tax Authority, due before the 16th of the month after the supplier was paid, is another line to match, against withholding tax payable. Keep the bank's WPS confirmation with the month's payroll.

Read next for Qatar