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 Oman
Amounts are matched to the baisa, since rials carry three decimals. Expect a VAT payment to the Tax Authority each quarter: record it against its return under Reports, Tax, then accept that payment as the match instead of booking the line as an expense. Salary transfers need the same care. The WPS salary file is written from each approved pay run and uploaded to your bank by you, and the bank's lines are matched to the net pay that payroll posted.
Read next for Oman
Aqid ERP in Oman
Set up for Oman's rules from the first day.
- Plans from 8.1 ر.ع. a month
- VAT 5 %
- Tax Authority return
- SPF