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 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
Aqid ERP in Qatar
Set up for Qatar's rules from the first day.
- Plans from 77 ر.ق a month
- No VAT
- Withholding tax
- End of service (Art. 54)