በኢትዮጵያ የባንክ ማመሳከሪያ፦ የወር መዝጊያን በራስ ሰር ማድረግ

Why bank reconciliation is the slowest part of period close

In most Ethiopian finance teams, the period-close routine looks like this: book the transactions, run the trial balance, print the bank statement, sit down with a pencil, tick off each statement line against the cash book, identify the unmatched items, chase them down, reconcile to zero. For a single bank account with two hundred transactions, this takes most of a day. For five bank accounts across three branches, it takes the better part of a week — every month.

Bank reconciliation is one of the longest-running, lowest-leverage tasks in Ethiopian finance. It is also the task most commonly mishandled — silently — when finance teams are stretched. Errors compound across periods. Aged unreconciled items get written off without investigation. Audit finds the discrepancy the following year.

A reconciliation engine doesn't just save time. It enforces the discipline that the old paper-and-pencil method depends on but can't guarantee.

The three buckets every reconciliation produces

Every bank reconciliation produces three buckets of items:

1. Items in both — bank and books agree, no further action.
2. Items in books, not in bank — typically outstanding cheques, in-flight transfers, or post-statement-date entries.
3. Items in bank, not in books — typically bank fees, interest credits, supplier payments not yet posted, customer receipts not yet booked.

A working reconciliation explains every item in buckets 2 and 3, resolves the explainable ones with journal entries, and carries forward the legitimately-outstanding ones (e.g. cheques not yet presented). The total of unresolved items must reconcile to the difference between bank balance and book balance.

Statement formats

Ethiopian banks provide bank statements in several formats:

• PDF — readable, painful to import. Some tools OCR-extract; others require manual entry.
• Excel / CSV — common, structure varies bank to bank. A reconciliation engine must adapt to each bank's column layout.
• OFX — standard format used by some banks; clean for automated import.
• MT940 — SWIFT statement format used by some banks for corporate accounts.
• API — direct programmatic access where the bank exposes it (a growing minority of banks).

A compliant tool ingests at least the CSV/OFX/MT940 formats from every major Ethiopian bank. NYLOS Finance & Accounting includes import templates pre-configured for CBE, Awash, Dashen, Abyssinia, Hibret, Cooperative Bank of Oromia and others.

The matching engine

Once the statement is imported, the matching engine attempts to pair each bank statement line with a GL transaction. Matching uses three signals:

1. Amount — primary signal; exact match preferred, near-match flagged for human review.
2. Date — preferred match within a tolerance window (commonly ±3 days, to handle weekend posting delays).
3. Reference — bank reference, cheque number, transaction ID; valuable secondary signal when the bank provides it.

The matching engine typically reconciles 70–90% of transactions automatically, depending on data quality. The remaining transactions surface for human review through a side-by-side interface: bank line on the left, candidate book entries on the right, with confirm / unmatch / create-journal actions.

Resolving unmatched items

The most valuable feature of a good reconciliation engine is the workflow for resolving the unmatched. NYLOS supports five resolution paths:

1. Mark as outstanding — legitimately not yet processed; carries forward to next period.
2. Create journal entry — bank fee or interest credit not yet booked; reconciliation engine prefills the journal from the bank line.
3. Match to existing entry — manual override when the engine missed a match (often because of a typo or duplicate entry).
4. Investigate — flag for the AP/AR officer to chase down; remains unresolved until investigation closes.
5. Adjust — when small differences need write-off after approval.

Every resolution is logged with the user, timestamp and reason. Years later, an auditor can reconstruct exactly how each anomaly was handled.

The audit dimension

A reconciliation engine is also an audit artifact. Auditors want to see:

• The exact bank statement balance and book balance at period end.
• The list of outstanding items reconciling the two.
• The journal entries created during reconciliation (and their approval).
• The trend of unreconciled balances across periods.
• Any aged unreconciled items still outstanding.

NYLOS preserves the full reconciliation history. Re-opening a closed period reconciliation requires authorization and logs the reason.

Common pitfalls

Five pitfalls we watch Ethiopian finance teams avoid:

1. Reconciling only the totals, not the lines — totals can match while individual transactions are misposted; audit finds it the next year.
2. Writing off aged unreconciled items without investigation — common in stretched teams; produces audit findings.
3. Reconciling once a quarter instead of monthly — the longer the gap, the harder the resolution.
4. Holding the reconciliation in a spreadsheet outside the accounting tool — destroys the audit trail.
5. Re-opening reconciled periods without logging the reason — leaks audit integrity.

How NYLOS handles bank reconciliation

NYLOS Finance & Accounting includes a built-in reconciliation engine: import statements via CSV / OFX / MT940 (or pull via API where available), automated matching by amount / date / reference, side-by-side resolution interface, structured workflow for the five resolution paths, and full audit trail preserved indefinitely. Reconciliation is locked at period close; reopening requires authorization with a logged reason.

The output is a finance team that closes the books in days, not weeks — and an audit trail that survives every annual review.

Read more

• [NYLOS Finance & Accounting](/modules/finance-and-accounting) — the platform implementation.
• [Building an IFRS-Aligned Chart of Accounts](/blog/ifrs-chart-of-accounts-ethiopia).
• [MOR-Compliant Invoicing in Ethiopia](/blog/mor-compliant-invoicing-ethiopia).
• [NYLOS Compliance posture](/security/compliance).