Sage Intacct Multi-Entity Accounting and Consolidation Training Course

Course overview

Multi-entity finance teams need a close process that produces reliable consolidated results without exporting trial balances, rebuilding eliminations in spreadsheets, or losing sight of intercompany balances. This five-day Sage Intacct Multi-Entity Accounting and Consolidation Training Course addresses the configuration and operating decisions behind that process: entity structures, shared dimensions, inter-entity transactions, ownership models, currency translation, and consolidation reporting. Participants learn how to diagnose the causes of mismatched due-to/due-from accounts, incomplete eliminations, and reporting inconsistencies before they delay close.

The course develops practical capability in Sage Intacct’s multi-entity architecture. Participants configure entities and entity groups; apply top-level and entity-specific dimensions; establish inter-entity relationships and clearing accounts; process automated and manual inter-entity entries; configure consolidation books; manage exchange rates and currency translation; and build consolidated financial reports using the Financial Report Writer. They also work with ownership percentages, minority interest considerations, elimination entries, audit trails, period controls, and close checklists. Reporting exercises focus on consolidated income statements, balance sheets, cash flow views, and entity-level variance analysis.

Instruction combines guided system demonstrations with structured exercises in a Sage Intacct training environment. Each day uses a connected case involving a growing group with domestic and international subsidiaries, shared services charges, intercompany trading, and month-end reporting requirements. Participants finish by producing a multi-entity close design pack: an entity and dimension map, inter-entity workflow, elimination approach, consolidation reporting specification, and a practical month-end control checklist they can adapt to their own organisation.

The course is suited to finance professionals who already work with core accounting processes and need to administer, operate, review, or improve Sage Intacct consolidation processes across a group structure.

Course objectives

By the end of this course, participants will be able to:

• Configure Sage Intacct entities, entity groups, and shared dimensions for a multi-entity chart of accounts structure
• Design inter-entity relationship rules, due-to/due-from accounts, and clearing account workflows
• Process automated and manual inter-entity transactions and reconcile reciprocal balances before close
• Set up consolidation books, reporting entities, and period controls for group reporting
• Apply exchange-rate tables and currency translation methods to foreign-entity balances
• Create elimination entries for intercompany revenue, expenses, receivables, payables, and investment balances
• Build consolidated financial statements and entity comparison reports with Sage Intacct Financial Report Writer
• Produce a documented multi-entity month-end close checklist and consolidation control matrix

Benefits of attending

Target competencies

Who should attend

• Group Financial Controllers — who own consolidated reporting, close governance, and finance control design
• Finance Managers — who coordinate entity-level close activities and review group results
• Sage Intacct Administrators — who configure entities, dimensions, workflows, and reporting access
• Senior Accountants — who prepare intercompany journals, reconciliations, and consolidation support schedules
• Consolidation Accountants — who manage eliminations, foreign-currency translation, and group reporting packs
• Finance Systems Analysts — who translate accounting policy and reporting requirements into Sage Intacct configuration

Requirements and prerequisites

Participants should understand double-entry bookkeeping, the month-end close, trial balances, balance sheets, income statements, and basic intercompany accounting concepts. Prior hands-on use of Sage Intacct for general ledger, journal entries, dimensions, and standard reporting is strongly recommended; participants should be able to navigate the application and locate entity-level financial data. Familiarity with consolidation concepts such as eliminations, foreign-currency translation, and group reporting is helpful but not essential. Advanced spreadsheet modelling, scripting, database skills, or prior Sage Intacct implementation experience are not required.

Training methodology

The programme is delivered through instructor-led configuration briefings, live Sage Intacct demonstrations, and hands-on work in a structured training tenant. Participants follow one connected group-finance case from entity setup through intercompany processing, currency translation, eliminations, and consolidated reporting. Exercises require participants to configure records, post and review transactions, investigate reconciliation exceptions, and build reports rather than simply observe system features. Facilitated peer reviews compare design choices for different group structures. The final workshop converts the case work into an application plan, close checklist, and control matrix for each participant’s workplace.

Course outline

Day 1: Multi-Entity Architecture and Financial Data Design

• Sage Intacct multi-entity architecture, top-level access, and entity security
• Legal entities, reporting entities, entity groups, and shared services structures
• Shared chart of accounts versus entity-specific account design
• Top-level and entity-level dimensions for departments, locations, projects, and classes
• Entity restrictions, user roles, and reporting permissions
• Period management and close calendars across multiple entities
• Multi-entity configuration decisions that affect consolidation reporting

Workshop: Participants map a sample corporate group into entities, entity groups, dimensions, roles, and close calendars, producing an approved multi-entity configuration blueprint.

Day 2: Intercompany Processing and Reciprocal Reconciliation

• Inter-entity relationships and reciprocal entity pair setup
• Due-to and due-from account design and account mapping
• Automated inter-entity transaction creation in Sage Intacct
• Manual intercompany journal entries and supporting documentation
• Shared service allocations, management fees, and cross-charge processing
• Intercompany accounts receivable and accounts payable settlement workflows
• Reciprocal balance reconciliation and exception investigation

Workshop: Participants process service charges and inventory-related intercompany entries, then produce a reciprocal balance reconciliation identifying and correcting mismatches.

Day 3: Consolidation Books, Ownership, and Currency Translation

• Consolidation books and reporting book configuration
• Reporting entities, consolidation hierarchies, and entity inclusion rules
• Ownership percentages and investment account considerations
• Foreign currency entities, transaction currency, and base currency settings
• Exchange-rate types, rate tables, and rate maintenance controls
• Current-rate and historical-rate translation treatment
• Cumulative translation adjustment analysis and review

Workshop: Participants configure a consolidation hierarchy for a domestic parent and overseas subsidiaries, load exchange rates, and produce a translated trial balance with CTA analysis.

Day 4: Eliminations and Consolidated Financial Reporting

• Intercompany elimination principles for revenue, expense, receivables, and payables
• Elimination journals, elimination entities, and audit trail requirements
• Investment and equity elimination concepts in group reporting
• Minority interest and non-controlling interest reporting considerations
• Financial Report Writer columns for entities, groups, and consolidation views
• Consolidated income statement, balance sheet, and cash flow report design
• Entity comparison, drill-down analysis, and report validation procedures

Workshop: Participants prepare elimination entries for a case group and build a consolidated income statement and balance sheet with entity-level comparison columns.

Day 5: Close Governance, Controls, and Workplace Application

• Multi-entity month-end close sequence and dependency management
• Intercompany cutoff, accrual, and settlement controls
• Consolidation review procedures and materiality-based exception handling
• Journal approval workflows and segregation of duties
• Audit evidence from Sage Intacct transaction history and report drill-down
• Consolidation control matrix and issue escalation routes
• Implementation roadmap for improving an existing Sage Intacct close process

Workshop: Participants complete a capstone close simulation and produce a multi-entity close design pack containing workflows, controls, reports, and a 90-day improvement plan.

Tools & standards covered

Sage Intacct, Microsoft Excel, US GAAP, ASC 830

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions