Bank accounts and reconciliation
Adding accounts, importing statements and matching lines to the ledger.
Add an account
- Open Bank and choose Bank account (people with approval rights).
- Enter the account name, bank, account number and opening balance.
Only the last four digits of the account number are shown on screen.
Import a statement
Choose Import CSV and pick your bank's statement file. The first row must name the columns. ERP Kanyange looks for a date, a description, an optional reference, and either debit and credit columns, or one amount column where a negative amount is money out.
- Dates can be 2026-10-25, 25/10/2026 or 25 Oct 2026.
- Lines already imported are skipped, so importing the same file twice is safe.
- A line with a bad date or amount is reported by line number and skipped. It is never guessed.
Match, ignore, undo
For each unmatched line choose Match and pick the posted ledger voucher it belongs to; vouchers with the same amount are listed first. Choose Ignore for lines that do not belong in the books. Undo returns a line to Unmatched.
The book balance is the opening balance plus money in minus money out across every line.