SmartERP Documentation An Ashewa Technology Solutions Platform

Track uncleared cheques

Monitor unpresented vendor cheques, uncleared deposits in transit, stale cheques, and generate the formal bank reconciliation statement.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Track uncleared cheques within SmartERP.

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

Uncleared Cheque Suspense Ledger and Aging Report

This guide is for Treasury Officers and Auditors reviewing uncleared banking transactions.

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 → Reporting → Uncleared Cheques Ledger.

Uncleared Cheque Suspense Ledger and Aging Report

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 Auditor, Senior Cashier).
  • 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 Uncleared Cheques Register#

  1. Open Accounting → Vendors → Payments.
  2. In the search filter, select Payment Delivery Type: CPV and Status: Uncleared / Outstanding.
  3. The list shows all physical cheques issued that have not yet cleared on imported bank statements.

The Bank Reconciliation Statement equation#

SmartERP computes the monthly Bank Reconciliation Statement automatically:

$$\text{Balance per Bank Statement} + \text{Deposits in Transit} - \text{Outstanding Unpresented Cheques} = \text{Balance per General Ledger}$$

Handling stale and cancelled cheques#

Under Ethiopian commercial practice, cheques not presented within 6 months become legally stale:

  1. Locate the stale cheque in the payments list.
  2. Press Cancel Cheque & Reopen Bill.
  3. Enter the cancellation reason: e.g. Cheque expired / unpresented after 180 days.
  4. The system posts a reversing journal entry crediting Accounts Payable and debiting the Bank Account.
  5. Reissue a replacement CPV if the commercial debt remains valid.

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