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 Saudi Arabia
Some lines on a Saudi company's statement belong to filings, not to customers or suppliers. Match the VAT paid to ZATCA by recording it against its return rather than as an expense, so the VAT accounts clear. GOSI contributions are due within the first 15 days of the following month, and salaries follow the pay run whose Mudad file went to the bank; accept each against its posting. Bank charges with no document go through Record as expense.
Read next for Saudi Arabia
Aqid ERP in Saudi Arabia
Set up for Saudi Arabia's rules from the first day.
- Plans from 79 a month
- ZATCA Phase 2
- VAT 15 %
- GOSI & Mudad WPS