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
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.
Accept matches
For each line choose Find match and Accept the payment or document that matches it.
Book the rest
A bank charge or expense with no document: choose Record as expense and its account; Exclude what does not belong.
Finish balanced
The workbench shows the difference; at zero every transaction is matched.
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
Aqid ERP in the UAE
Set up for the UAE's rules from the first day.
- Plans from 77 د.إ a month
- UAE e-invoicing (2027)
- VAT 5 %
- Corporate tax
- WPS