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 Kuwait
Dinar amounts carry three decimals across the ledger, so a statement line matches to the fils. Reconciling also evidences payroll: an employer with five or more workers must pay wages into their accounts at local financial institutions, no later than the seventh day after they fall due, and the Public Authority for Manpower suspends the file of an employer whose salary transfers are missing. Aqid ERP does not yet produce a WPS salary file for Kuwait's banks, so pay net salaries from your bank and match each transfer here.
Read next for Kuwait
Aqid ERP in Kuwait
Set up for Kuwait's rules from the first day.
- Plans from 6.5 د.ك a month
- No VAT
- PIFSS
- Indemnity (Art. 51)