SmartERP Documentation An Ashewa Technology Solutions Platform

Reconcile bank statement lines

Execute 3-tier automated reconciliation matching, resolve bank charges and interest, and validate bank statements.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Reconcile bank statement lines within SmartERP.

This guide is for Treasury Accountants executing monthly bank reconciliations.

Bank reconciliation 3-tier matching engine and exception resolution workflow.
3-tier electronic bank reconciliation matching and exception clearance.

2. Prerequisites & Security Access Groups#

  • Required Modules: account, smarterp_finance, smarterp_ethiopian_payroll
  • Security Groups:
    • Show Full Accounting Features (Technical ID: account.group_account_user)
    • Billing Administrator / Financial Controller (Technical ID: account.group_account_manager)
    • Chief Financial Officer / Auditor (Technical ID: account.group_account_readonly)
  • Master Data Dependencies: Chart of accounts, statutory tax definitions (VAT 15%, WHT 2%/30%), payment terms, and open fiscal periods for Company 1 (Ashewa Technology Solutions S.C.).

3. Step-by-Step Configuration & Execution#

Step 1: Navigating to the Financial Interface#

  1. Log into your SmartERP instance at https://smarterp.et/odoo.
  2. Open the main App Switcher (grid icon in the top-left corner).
  3. Navigate to Accounting → Dashboard → Bank Journal → Reconcile.

Interactive Bank Reconciliation Widget and Transaction Matching

Step 2: Financial Parameters & Statutory Controls#

Ensure all mandatory accounting parameters conform to statutory fiscal regulations:

  • Designated Authority / Role: Action authorized by verified financial role (Treasury Specialist, Senior Accountant).
  • Fiscal Period & Journal Integrity: Bound to an open, unlocked fiscal period adhering to the Ethiopian financial calendar.
  • Statutory Tax & Regulatory Validation: Compliant with Ethiopian Proclamation No. 979/2016 (Withholding Tax 2%/30%) and Proclamation No. 1157/2019 (VAT 15%).

Step 3: Transaction Posting & General Ledger Impact#

  • State Progression Gate: Advance record from Draft through Audited to Posted / Reconciled.
  • Double-Entry General Ledger Impact: System automatically generates immutable journal items (account.move.line) updating real-time trial balances and customer/vendor sub-ledgers.
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

Open the reconciliation dashboard#

  1. Open Accounting → Accounting → Bank and Cash.
  2. On the Bank Journal card, press Reconcile (n Items).

The 3-tier automated matching engine#

SmartERP executes automated rule-based matching:

  1. Tier 1 (Exact Match): Cheque number, payment reference, and exact amount match -> highlighted in green.
  2. Tier 2 (Partner & Amount Match): Same partner TIN and identical currency amount within 3 business days -> suggested match.
  3. Tier 3 (Open Invoice Matching): Customer invoice or vendor bill number detected in the bank memo narration.

Resolve exceptions and bank fees#

For statement lines without pre-existing accounting payments (e.g. monthly bank ledger service fees, wire transfer commissions, or credit interest):

  1. Select the unmatched statement line.
  2. In the bottom action panel, select Preset Rule:
    • For wire fees: choose Bank Service Charges (650100).
    • For interest earned: choose Interest Revenue (430200).
  3. Press Create & Reconcile. The system posts the offsetting entry automatically.
  4. When all lines are reconciled, the computed balance equals the physical bank statement ending balance.
  5. Press Validate Statement.

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • Account: Automatic reconciliation (account.ir_cron_auto_reconcile): Runs nightly to match open ledger transactions
    • Asset: Compute depreciation lines (account_asset.ir_cron_compute_depreciation): Runs monthly on the 30th to compute fixed asset depreciation schedules
    • Tax: Generate VAT and WHT schedules (smarterp_finance.ir_cron_tax_schedules): Runs monthly to prepare MOR tax return summaries
  • Custom Print Templates & Reports:
    • Official Cash Receipt Voucher (CRV)
    • Bank Payment Voucher (BPV) & Cheque Payment Voucher (CPV)
    • Withholding Tax Certificate (Form 3.4)
    • General Ledger & Trial Balance Audit Schedules
  • Multi-Company Rules: Record-level security isolation under Company 1 (Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.

5. Comprehensive Troubleshooting Matrix#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
Access Rights Error: Operation not allowed on account.moveUser account lacks accounting operator privileges.Assign the user to account.group_account_user or account.group_account_manager under Settings → Users.
Validation Error: Missing analytic distributionSelected general ledger account mandates cost center allocation for IFRS compliance.Populate the analytic distribution column on all debit and credit lines before posting.
Posting Blocked: Fiscal period closedTransaction date falls within an immutable locked accounting period.Select a transaction date within the open fiscal year or request an authorized period reopening under Accounting Settings.
Tax Imbalance: WHT withholding varianceWithholding deduction does not match statutory 2% goods or 30% service rate.Verify vendor TIN registration status in partner master and recalculate statutory tax lines.

Next#

Last updated: 2026-11-15