Calculate and deduct withholding tax

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Calculate and deduct withholding tax within SmartERP.

This guide is for Accountants and Tax Officers calculating and deducting statutory withholding tax under Ethiopian Proclamation No. 979/2016.

[finance-wht-vat-engine]

{screenshot:calculate-and-deduct-withholding-tax-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:calculate-and-deduct-withholding-tax-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:calculate-and-deduct-withholding-tax-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:calculate-and-deduct-withholding-tax-transaction-processing-state}

Statutory withholding thresholds#

Apply Withholding Tax during payment#

1. Open Accounting → Vendors → Bills and open the confirmed vendor bill.
2. Press Register Payment.
3. In the payment modal:
   • Check Deduct Withholding Tax (WHT).
   • In WHT Category, choose Goods (2%) or Non-TIN Services (30%).
4. The system calculates:
   • Taxable Base (Excluding VAT): ETB 50,000.00
   • WHT Amount (2%): ETB 1,000.00
   • Net Settlement to Vendor: Gross Bill - ETB 1,000.00
5. Press Create Payment.
6. The General Ledger records:
   • Debit: Accounts Payable (210100) for gross settlement.
   • Credit: Bank Account (110200) for net disbursement.
   • Credit: Withholding Tax Payable to MOR (220200) for ETB 1,000.00.

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#

• Print the tax receipt: Print and issue withholding receipt.
• Export monthly MOR tax file: Export monthly withholding declaration.