Multi-Subsidiary & Multi-Currency Configuration

HRDC Claimable
Multi-Subsidiary & Multi-Currency Configuration

About this course

African group accounting — configured correctly. Configure NetSuite OneWorld for multi-entity African organisations — subsidiary hierarchy, intercompany transactions, multi-currency management, and consolidated reporting. 9 hrs · 3 sessions · Intermediate. Overview Multi-entity African businesses face a configuration challenge that standard NetSuite training never addresses: the combination of diverse subsidiary currencies, restricted-convertibility currencies in some markets, intercompany service recharges across multiple tax jurisdictions, and consolidated reporting requirements that must satisfy both the group board and the local revenue authority. This course addresses that challenge directly, drawing on MIWA and Sugar Industry implementation experience across entities in multiple African countries. Every configuration decision is explained in terms of its downstream impact on the consolidated P&L, the intercompany reconciliation, and the tax position. Learning outcomes • Set up a subsidiary hierarchy in NetSuite OneWorld for a multi-entity African group • Configure and post intercompany transactions with automatic eliminations • Identify and resolve intercompany reconciliation differences before period close • Manage foreign currency revaluation and understand the P&L impact • Handle the specific multi-currency challenges of African subsidiaries with restricted-convertibility currencies Prerequisites • Chart of Accounts, Accounting Periods & Financial Settings course • Roles, Permissions & Data Access course is helpful but not mandatory • Basic understanding of group accounting and intercompany elimination concepts Modules 1. NetSuite OneWorld — subsidiary setup & the entity hierarchy (3 hours) NetSuite OneWorld: what it enables (multi-subsidiary, multi-currency, multi-book accounting) and what additional licence it requires. The subsidiary hierarchy: parent subsidiary, child subsidiaries, and the elimination subsidiary that exists solely to host the consolidation entries. Setting up a new subsidiary: legal name, registration number, base currency, fiscal calendar (which may differ from the group calendar), and the intercompany accounts that must be configured before any intercompany transactions can post. Subsidiary-specific CoA extensions: how each subsidiary can add accounts to the shared parent CoA without affecting other subsidiaries. Currency setup: adding a foreign currency, choosing between a fixed exchange rate and a daily rate feed, and understanding the impact of rate update timing on transaction values and the consolidated P&L. The consolidated financial report: selecting the consolidation type (total, translated), the base currency for consolidation, and how NetSuite eliminates intercompany transactions and translates subsidiary balances into the parent currency. Topics: OneWorld licence; Subsidiary hierarchy; Elimination subsidiary; Subsidiary setup fields; Fiscal calendar variants; Intercompany accounts; CoA extensions; Currency setup; Fixed vs daily rate; Rate update impact; Consolidated report setup; Consolidation type; Currency translation 2. Intercompany transactions, eliminations & reconciliation (3 hours) Intercompany transactions in practice: the parent company providing a management fee to a subsidiary, a subsidiary borrowing from the parent treasury, and a shared service centre recharging IT costs to multiple subsidiaries. The intercompany journal in NetSuite: creating a journal that posts simultaneously in two subsidiaries — the debit in the recipient and the credit in the provider — and how NetSuite creates the offsetting entry automatically. Intercompany billing: creating a vendor bill in the subsidiary that receives the service and the corresponding intercompany sales invoice in the subsidiary that provides it — the two records that must match for the elimination to work correctly. Elimination entries: what they are, why they are essential for meaningful consolidated accounts, and how NetSuite's automatic elimination works when the intercompany transactions are correctly coded. The intercompany reconciliation report: identifying unmatched intercompany transactions before the period close — the most common source of consolidation differences. Transfer pricing basics for African tax compliance: the documentation requirements, the arm's length principle, and the NetSuite records that support a transfer pricing audit. Topics: Management fee structure; Treasury intercompany lending; Shared service recharges; Intercompany journal; Automatic offset entry; Intercompany billing; Vendor bill and sales invoice matching; Elimination entries; Automatic elimination; Intercompany reconciliation report; Unmatched transaction identification; Transfer pricing documentation; Arm's length principle 3. Multi-currency operations, revaluation & the Africa context (3 hours) Multi-currency transactions in practice: creating a purchase order in USD when the functional currency is KES — the exchange rate applied, the GL posting in both currencies, and the committed exchange rate for the payable. Exchange rate management: the spot rate, the average rate, and the period rate — when each applies in African accounting practice. Foreign currency revaluation at period end: how NetSuite calculates the unrealised gain or loss on open AR, AP, and bank balances, and how to post the revaluation journal. The currency revaluation report: reviewing the unrealised impact before posting and understanding the P&L implications. Realised gains and losses on settlement: how NetSuite posts the exchange difference when a USD invoice is settled at a different rate. Africa-specific currency considerations: restricted-convertibility currencies (where converting to USD requires central bank approval), the practical implications for NetSuite's exchange rate handling, and the workarounds that experienced African Finance consultants use. Multi-currency bank reconciliation: reconciling a USD bank account when the functional currency is MUR or NGN. Topics: Multi-currency PO creation; Committed exchange rate; Exchange rate types; Period-end revaluation; Unrealised gain/loss journal; Revaluation report; Realised gain/loss on settlement; Restricted convertibility currencies; Central bank approval workarounds; Multi-currency bank reconciliation; FX impact on consolidated P&L Delivery Best delivered over three days with homework between sessions — the intercompany configuration decisions in session two depend on having implemented the session one subsidiary hierarchy correctly. Groups of 4–10. The finance director and system administrator should both attend. Certification Certificate of completion Price USD 900 · per participant per person · indicative · group pricing available HRDC eligibility Up to 75% refundable Mauritius-registered employers may claim this training via the HRDC levy. We provide full documentation to support your claim. Languages English Provider reference SIMPLIT-047-NS_MULTI_SUBSIDIARY

Who is this for?

• NetSuite administrators at multi-entity African organisations • Implementation consultants configuring NetSuite for a holding group with subsidiaries • Finance directors of African groups managing consolidated reporting across countries • Tax managers responsible for intercompany transfer pricing compliance • IT leads implementing NetSuite OneWorld for the first time • CFOs who need to understand how consolidation and elimination work in NetSuite

Course Details

Date
To be announced
Duration
9 hours (3 × 3 hrs)
Price
Rs 900
Location
Virtual (live, online) / On-site at client / Individual coaching
Status
Active
Presenter
Simpl'IT Cloud
CategoriesTechnology, Business & Management, Data & Analytics
Tags
Oracle NetSuiteIntermediateOnline AvailableCorporate TrainingIndividual CoachingData Analytics