• Navigate Oracle EBS Financials architecture and understand how GL, Payables, Receivables, and Tax integrate.
• Configure E-Business Tax (EBTax), including Regimes, Taxes, Statuses, Rates, Jurisdictions, and Tax Rules.
• Set up Party Tax Profiles, Tax Registrations, and Tax Exemptions for customers, suppliers, and the bank itself.
• Apply the tax determination hierarchy to real banking transactions, including VAT, WHT, and Excise Duty.
• Design and maintain a banking Chart of Accounts, ledgers, and accounting calendars.
• Create, review, and post manual, recurring, and mass-allocation journals.
• Execute the period-end close process, including reconciliation between Tax and GL.
• Produce management and regulatory reports, including FSG, Trial Balance, and tax liability reconciliations.
• Troubleshoot common tax-calculation and journal-posting issues encountered in banking environments.

Day 1

Oracle EBS Financials & Tax Foundations

Module 1 — Oracle E-Business Suite (EBS) Overview

• EBS architecture: application tiers, responsibilities, and menus
• Overview of the Financials pillar: General Ledger, Payables, Receivables, Fixed Assets, Cash Management
• Navigation, flexfields, profile options, and value sets relevant to Finance users
• Multi-Org structure: Operating Units, Legal Entities, Inventory Organizations — why this matters for a bank with regional subsidiaries

Module 2 — Financials Data Flow in a Banking Environment

• How subledgers (AP, AR, FA, CM) feed the General Ledger via Subledger Accounting (SLA)
• Typical banking transaction flows: supplier invoices, branch expense postings, income and fee recognition
• Introduction to Accounting Flexfield structure and its link to the bank's Chart of Accounts

Module 3 — Introduction to E-Business Tax (EBTax)

• Why a centralized tax engine matters for a multi-country bank (Kenya, Uganda, Tanzania, Rwanda)
• EBTax architecture: Regime-to-Rate flow overview
• Key EBTax entities: Tax Regime, Tax, Tax Status, Tax Rate, Tax Jurisdiction, Tax Rules
• Where EBTax fits relative to Payables, Receivables and Order-to-Cash processes

Module 4 — Legal Entities, Ledgers and Regulatory Context

• Primary Ledger, Secondary Ledger and Reporting Currency concepts
• Mapping Legal Entities to Ledgers for country-level statutory and Central Bank reporting
• Overview of East African regulatory bodies relevant to Finance: KRA, URA, TRA, RRA, and respective Central Banks

DAY 2

E-Business Tax (EBTax) Configuration Deep Dive

Module 1 — Tax Regime, Tax, Status, Rate and Jurisdiction Setup

• Defining a Tax Regime per country (e.g., Kenya VAT Regime, Uganda VAT Regime)
• Creating Taxes, Tax Statuses (Standard-Rated, Zero-Rated, Exempt) and Tax Rates
• Configuring Tax Jurisdictions and effective date management
• Tax Accounts setup — linking tax rates to GL liability and recoverable accounts

Module 2 — Tax Rules and the Determination Hierarchy

• The seven determining processes: Place of Supply, Tax Applicability, Tax Registration, Tax Status, Tax Rate, Taxable Basis, Tax Calculation
• Building Tax Determining Factor Sets and Tax Condition Sets
• Rule precedence and default values — designing rules that are easy to audit
• Guided Tax Rule Entry vs. Expert Tax Rule Entry

Module 3 — Party Tax Profiles & Registrations

• First-Party (the bank) Legal Entity and Legal Reporting Unit tax profiles
• Third-Party (customer/supplier) tax profiles and tax registration numbers (PIN/TIN)
• Tax registration status validation and its effect on tax calculation

Module 4 — Exemptions, Exceptions and Thresholds

• Configuring customer/product-level tax exemptions (e.g., exempt financial services)
• Tax exceptions for special rate products
• Threshold-based tax rules where applicable

Day 3

Banking-Specific Tax Scenarios

Module 1 — VAT Treatment of Banking Services

• Exempt vs. standard-rated financial services under the Kenya, Uganda, and Tanzania VAT Acts
• Partial exemption / input VAT apportionment concepts for banks
• Configuring product/fee-level tax classifications for interest income, fee income, and forex income

Module 2—Withholding Tax (WHT) Configuration

• WHT concepts: withholding on supplier payments, professional fees, rent, interest, and dividends
• Configuring Withholding Tax Types, Rates, and Automatic WHT Calculation in Oracle Payables
• Self-assessed / reverse-charge tax scenarios and manual WHT overrides
• Generating WHT certificate data and reconciling to revenue authority WHT ledgers (KRA iTax, URA, TRA)

Module 3—Excise Duty on Bank Charges & Digital Transactions

• Overview of excise duty on money transfer services, bank charges, and mobile-money-linked transactions (Kenya Excise Duty Act)
• Configuring excise as an additional tax layer alongside VAT on fee-based transactions
• Digital Service Tax / Significant Economic Presence considerations for digital banking channels

Module 4—Withholding VAT & Appointed Tax Agent Scenarios

• Withholding VAT obligations for banks appointed as WHT-VAT agents
• Configuration approach and reporting implications

Module 5—Regulatory Reporting & Reconciliation

• Extracting tax data for KRA iTax, URA, and TRA filings
• Reconciling EBTax reports (Tax Reconciliation Report, Tax Audit Trail Report) to the General Ledger

Day 4

General Ledger Fundamentals

Module 1 — Chart of Accounts (COA) Design for Banking

• Segment design: Company/Legal Entity, Branch/Cost Centre, Natural Account, Product, Inter-company, Future-use
• Balancing segment considerations for multi-entity, multi-country structures
• Cross-Validation Rules and Security Rules to protect account combinations
• Aligning the COA with Central Bank reporting and IFRS disclosure requirements

Module 2 — Ledgers, Calendars and Currencies

• Accounting Calendar and Period Types setup
• Primary Ledger, Secondary Ledger and Reporting Currency for group and regulatory reporting
• Ledger Sets for consolidated reporting across East African subsidiaries
• Multi-currency processing: conversion rates, rate types, and realized/unrealized gains and losses

Module 3 — Journal Entries and Processing

• Journal Sources, Categories, and journal entry methods (manual, spreadsheet upload, interface)
• Recurring Journals and Mass Allocations for period-end accruals and cost distributions
• Journal Approval workflow and segregation-of-duties considerations
• Reversal, correction and adjustment journals

Module 4 — Budgetary Control & Encumbrance Basics

• Overview of budget organizations and budgetary control for capex/opex monitoring
• How encumbrance accounting interacts with actual journals

Day 5

Period Close, Consolidation, Reporting & Integration

Module 1 — Period-End Close Process

• Open/Close Periods, close checklist, and control totals
• Subledger Accounting (SLA) close and reconciliation to GL
• Revaluation and Translation for multi-currency East African entities
• Common close exceptions and how to resolve them

Module 2 — Consolidation for a Regional Bank Group

• Consolidating multiple ledgers/subsidiaries into a group ledger
• Elimination entries for inter-company balances across countries

Module 3 — Integrating Tax with the General Ledger

• How EBTax-calculated amounts post to GL tax liability and recoverable accounts
• Reconciling the Tax Reconciliation Report to GL tax control accounts
• Month-end tax provisioning and its GL treatment

Module 4 — Reporting for Management, Statutory and Regulatory Needs

• Financial Statement Generator (FSG) reports and Trial Balance reporting
• Producing tax summary reports for KRA/URA/TRA filing support
• Introduction to Smart View / OTBI for management reporting (where licensed)

Module 5 — Common Issues, Troubleshooting & Best Practices

• Diagnosing tax calculation discrepancies using the Tax Simulator
• Journal posting errors and suspense account management

Governance practices: change control, periodic tax-rate reviews, and audit trails

5 Days

Course Completion Certificate by Network Binary

• EBS Navigation & Architecture Walkthrough
• Configure a Sample VAT Tax Regime
• WHT Configuration & Live Invoice Test
• Build a COA Segment & Post a Journal
• End-to-End Case Study

• Finance & General Ledger Accountants and Team Leads
• Tax and Statutory Reporting Officers
• Treasury and Financial Control Staff
• ERP / IT Finance-Systems Analysts and Super Users
• Internal Audit and Compliance Staff who review tax and GL controls
• Oracle EBS Functional Consultants supporting the Finance workstream

• Basic understanding of accounting and financial statements
• Familiarity with the bank's finance function is helpful but not mandatory
• Access to an Oracle EBS training/UAT instance for lab exercises (to be arranged with the bank's IT team)