Bank Statement Matching & CBE/Telebirr Reconciliation Assistant
AI-driven bank reconciliation for Commercial Bank of Ethiopia (CBE), Awash, and Telebirr statements with intelligent fuzzy matching.
1. Overview & Business Value#
The Bank Reconciliation Assistant matches raw bank statement transactions (CBE, Awash Bank, Dashen Bank, Telebirr SuperApp) with pending customer invoices and vendor payments.
1. Overview & Business Value#
Traditional manual reconciliation of hundreds of retail mobile wallet transactions or inter-bank wire transfers is labor-intensive. This agent utilizes NLP fuzzy matching on transaction descriptions, transaction IDs, and exact amount pairings to achieve an average automated match rate exceeding 92%.
{screenshot:ai-bank-recon-dashboard}
2. Prerequisites & Security Access Groups#
- Required Modules:
account, account_accountant, smarterp_ai_suite - Security Group:
Accountant(Technical ID:account.group_account_user)
3. Step-by-Step Execution Workflow#
Step 1: Uploading Bank Statement#
- Navigate to Accounting → Dashboard → Bank / Telebirr Journal.
- Click Import Statement and upload the standard CBE Excel/CSV or Telebirr merchant export.
Step 2: Executing AI Match Engine#
- In the reconciliation widget, click AI Auto-Match.
- The agent applies tiered matching heuristics:
- Tier 1 (Exact): Exact match on Telebirr Reference ID / CBE Transfer Ref.
- Tier 2 (Partner + Amount): Exact amount match combined with customer name fuzzy string distance.
- Tier 3 (Multi-Line): Lump-sum receipt split across multiple open customer invoices.
{screenshot:ai-bank-recon-matching-view}
Step 3: Validating and Posting Matches#
- High-confidence matches (>95%) are marked in green. Click Post All Confident Matches.
- Review remaining yellow flagged transactions (ambiguous split payments) and manually approve or adjust.
4. Troubleshooting Matrix#
| Issue | Cause | Resolution |
|---|---|---|
Bank charge variance detected (ETB 50) | Bank deducted inter-bank transfer commission fee. | Enable auto-write-off rule to Bank Service Charges account (account.651000). |
Telebirr settlement timing mismatch | Midnight batch settlement posted on next business day. | Configure 24-hour date window tolerance in reconciliation settings. |
2. Prerequisites & Security Access Groups#
- Required Modules:
muk_ai, muk_mcp, smarterp_ai_suite - Security Group:
Ashewa AI / User(Technical ID:muk_ai.group_ai_user) - Master Data Dependencies: Configured AI provider credentials, active system prompts, and departmental cost centers.
3. Step-by-Step UI Execution & Verification#
Step 1: Navigating to the Operational Interface#
- Log into your SmartERP instance at
https://smarterp.et/odoo. - Open the main App Switcher and select Ashewa AI.
- Select the operational workspace corresponding to this agent suite.
{screenshot:48-bank-reconciliation-assistant-step1-navigation}
Step 2: Executing Agent Actions#
- Review agent prompts and execution parameters.
- Trigger the scheduled or on-demand workflow action.
- Validate output in the generated operational log.
{screenshot:48-bank-reconciliation-assistant-step2-execution}
4. Advanced Configuration Points#
- Scheduled Crons:
muk_ai.ir_cron_agent_health_checkruns every 30 minutes. - Multi-Company Isolation: Multi-company record rules ensure agent context is isolated to Company 1 (
Ashewa Technology Solutions S.C.).
5. Comprehensive Troubleshooting Matrix#
| Symptom / Error | Probable Root Cause | Resolution Action |
|---|---|---|
Agent unresponsive or timeout | Network latency or API endpoint outage. | Verify provider connection in Settings → AI Providers. |
Access Denied during agent execution | User lacks assigned operational permissions. | Assign user to the designated operational group. |