Import electronic bank statement

1. Overview & Business Value#

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

This guide is for Treasury Officers importing electronic bank statement files into SmartERP.

{screenshot:import-electronic-bank-statement-overview-dashboard}

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 Module 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. Select the Accounting app icon.
4. From the top navigation bar, open Accounting → Customers / Vendors / Accounting / Configuration.

{screenshot:import-electronic-bank-statement-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Name / Reference (Mandatory): Unique identifier or auto-generated voucher sequence number
   • Accounting Date (Mandatory): Effective posting date falling within an open fiscal period
   • Journal (Mandatory): Designated financial journal (Cash, Bank, Customer Invoices, Vendor Bills, Miscellaneous)
   • Partner / Entity (Mandatory): Registered customer, vendor, or employee partner record (res.partner)
3. Configure optional operational parameters and localized tags as required:
   • Analytic Distribution (Optional): Cost center or project allocation percentage
   • Tax Treatment (Optional): Statutory withholding tax or VAT exemption certificate
   • Payment Reference (Optional): Commercial bank transaction reference or cheque number
4. Click the Save icon in the control bar to commit the record.

{screenshot:import-electronic-bank-statement-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Draft → In Payment / Confirmed → Posted / Reconciled).
• Ledger & System Impact: Generates immutable double-entry journal items (account.move.line) updating general ledger balances, trial balance, and statutory tax registers.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:import-electronic-bank-statement-transaction-processing-state}

Prepare the statement file#

SmartERP accepts standard statement exports from Ethiopian commercial banks:

• Commercial Bank of Ethiopia (CBE): Internet banking CSV or Excel statement.
• Awash Bank: Corporate online banking export.
• Dashen Bank / Amole: Transaction export format.
• Telebirr Merchant: SuperApp settlement export.

Ensure the file includes: Date, Transaction Reference / Narration, Debit Amount, Credit Amount, and Running Balance.

Import the statement#

1. Open Accounting → Accounting → Bank and Cash and locate your Bank Journal card.
2. Press Import Statement.
3. In the upload dialog, select the bank file from your computer.
4. Select the matching Bank Journal (e.g. CBE Main Account).
5. Map column headers if prompted (Date -> Date, Description -> Label, Amount -> Amount).
6. Press Import & Review.
7. The system creates statement transaction lines in Unreconciled state.

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#

Next#

• Match statement lines: Reconcile bank statement lines.
• Track uncleared cheques: Track uncleared cheques.