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 Bahrain
Dinar amounts carry three decimals, and the ledger keeps fils too, so each statement line matches its payment to the fil rather than after rounding. Under the enhanced Wage Protection System, salaries go out through the LMRA's WPS portal. Match those debits to the net pay each payroll run posted, so the payroll, the uploaded wage file and the payment can be matched if the LMRA asks. Record bank charges with Record as expense rather than leaving them open.
Read next for Bahrain
Aqid ERP in Bahrain
Set up for Bahrain's rules from the first day.
- Plans from 7.9 د.ب a month
- VAT 10 %
- NBR return
- SIO