Export monthly withholding declaration

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Export monthly withholding declaration within SmartERP.

This guide is for Tax Accountants and CFOs preparing monthly statutory tax filings for the Ministry of Revenues (MOR).

{screenshot:export-monthly-withholding-declaration-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:export-monthly-withholding-declaration-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:export-monthly-withholding-declaration-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:export-monthly-withholding-declaration-transaction-processing-state}

Open the Withholding Declaration Export tool#

1. Open Accounting → Reporting → Financial Reports → Tax Report.
2. Select Ethiopian Withholding Declaration Export (wht.declaration.export).
3. Choose the Fiscal Month (e.g. Meskerem 2019 / September 2026).
4. Select the Tax Authority Office (e.g. Large Taxpayers Office - LTO or Medium Taxpayers Office - MTO).
5. Press Compute Declaration Lines.

Review the declaration schedule#

The system displays the aggregated list of all withholding transactions executed during the month:

• Supplier Name and Trade Name.
• 10-Digit Supplier TIN.
• WHV Receipt Number and Date.
• Nature of Supply (Goods or Services).
• Gross Invoice Value, Taxable Base, and Withholding Tax Deducted.

Export for MOR e-Tax Portal#

1. Verify that the total tax payable matches the General Ledger balance in 220200 Withholding Tax Payable.
2. Press Export MOR Excel File.
3. The system generates the standardized multi-column spreadsheet required by the Ethiopian Ministry of Revenues e-Tax online declaration portal.
4. Submit the declaration online and initiate the settlement BPV to the MOR tax collection bank account.

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#

• Manage VAT: Manage VAT declarations and withholding.
• Reconcile bank payments: Reconcile bank statement lines.