OneStream Financial Consolidation and Reporting Training Course

Course overview

Finance teams using OneStream are expected to produce a controlled consolidated result while handling intercompany activity, multiple entities, local statutory adjustments, currency translation, ownership changes and late close-cycle corrections. Errors in data loads, workflow status, elimination logic or Cube View design can delay the close and create reporting that controllers cannot reconcile. This course addresses the practical configuration and operating knowledge needed to run reliable financial consolidation and management reporting processes in OneStream.

Participants work through the OneStream structures that underpin consolidation: applications, dimensions, entities, accounts, scenarios, time periods, workflows and data integration rules. They learn to load and validate trial balance data, manage foreign exchange translation, process intercompany eliminations, apply ownership and consolidation methods, post journals, and investigate consolidation exceptions. The course also develops reporting skills using Cube Views, XF/OneStream reporting functions, Excel integration and dashboard-ready management outputs.

Instructor-led demonstrations are followed by guided exercises in a realistic multi-entity group close case. Participants configure a portion of a consolidation model, execute a close workflow, resolve validation failures, review translated and eliminated balances, and create a management reporting pack. They leave with a documented consolidation-and-reporting workbook containing process steps, reconciliation checks, report specifications and an action plan for applying the methods in their own OneStream environment.

The course is designed for finance professionals who already work with group reporting, consolidation or close activities and need practical capability in OneStream rather than general accounting theory. It is equally relevant to organisations implementing OneStream, extending an existing application, or reducing reliance on manual Excel-based consolidation controls.

Course objectives

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

• Configure core OneStream consolidation dimensions, entity hierarchies, scenarios and time structures for a group reporting model
• Load and validate trial balance data using OneStream workflows, transformation rules and validation checks
• Execute currency translation using rate types, translation methods and foreign exchange adjustment logic
• Process intercompany matching and elimination entries across legal entities and partner dimensions
• Apply ownership percentages, consolidation methods and proportionate consolidation calculations to group structures
• Post, approve and audit consolidation journals with supporting documentation and workflow controls
• Build Cube Views and Excel-based management reports with drill-down, variance analysis and reconciliation detail
• Produce a documented close-cycle control plan covering data status, exceptions, reconciliations and sign-off responsibilities

Benefits of attending

Target competencies

Who should attend

• Group Financial Controllers — who own consolidated results, close governance and management reporting quality
• Consolidation Accountants — who prepare entity submissions, eliminations, journals and consolidation reconciliations
• Finance Systems Managers — who administer OneStream processes and translate finance requirements into application controls
• FP&A Managers — who need trusted actuals, scenario comparisons and drillable group reporting from OneStream
• Financial Reporting Managers — who prepare statutory or management reporting packs from consolidated data
• OneStream Power Users — who support finance users with workflows, Cube Views, data validation and report troubleshooting

Requirements and prerequisites

Participants should understand the monthly or quarterly financial close, trial balance structures, chart of accounts, intercompany transactions, consolidation adjustments and basic foreign currency translation concepts. Prior exposure to group reporting under IFRS or US GAAP is useful, particularly eliminations and ownership structures. Attendees should be comfortable navigating Windows, using Microsoft Excel formulas and reviewing financial statements. Some experience as a OneStream end user, such as entering workflow data or running reports, is strongly recommended. Programming, SQL, OneStream business-rule development and prior application-administration experience are not required.

Training methodology

The five-day programme combines instructor-led walkthroughs of OneStream configuration and close processing with hands-on work in a multi-entity training application. Each module starts with a finance scenario—such as a late entity submission, unmatched intercompany balance or foreign exchange variance—then participants complete the relevant workflow, validation, consolidation or reporting task. Small-group reviews compare reconciliation approaches and reporting design choices. On the final day, participants assemble a close and management-reporting pack and identify the controls, reports and operating steps they will apply in their own environment.

Course outline

Day 1: OneStream application foundations and close workflow

• OneStream application architecture for financial consolidation
• Dimensions, members and chart-of-accounts design
• Entity hierarchies, alternate hierarchies and reporting units
• Scenario, time, view and origin dimensions
• Workflow profiles, units and submission responsibilities
• Data status, certification and close-cycle governance
• Navigation through Cube Views, dashboards and workflow pages

Workshop: Participants map a sample group structure, assign workflow responsibilities and create a close-cycle workflow map for a multi-entity reporting group.

Day 2: Data integration, validation and reconciliation

• Trial balance source-file design and load sequencing
• Import workflows and data management processes
• Transformation rules and account mapping logic
• Data validation rules and confirmation checks
• Forms for controlled data entry and supplemental adjustments
• Data status review and exception investigation
• Entity-level reconciliation to source general ledger balances

Workshop: Participants load entity trial balances, correct mapping and validation failures, and produce a submitted-versus-source reconciliation.

Day 3: Currency translation, ownership and eliminations

• Local currency, reporting currency and translated views
• Exchange-rate tables, rate types and rate assumptions
• Translation methods and cumulative translation adjustments
• Intercompany partner dimensions and matching requirements
• Intercompany elimination rules and residual-balance analysis
• Ownership management and consolidation methods
• Minority interest and proportionate ownership considerations

Workshop: Participants translate a foreign subsidiary, resolve unmatched intercompany balances and review the resulting elimination and exchange-difference entries.

Day 4: Journals, reporting and management analysis

• Consolidation journal types and journal-entry workflow
• Journal approval, supporting evidence and audit trail review
• Cube View construction for financial statements
• Row, column and point-of-view design in Cube Views
• Excel Add-In retrievals and ad hoc report refreshes
• Variance analysis by entity, account, scenario and period
• Drill-down paths from management report to transaction-level support

Workshop: Participants post and approve a consolidation journal, then build a drillable management variance report in a Cube View and Excel.

Day 5: Controlled close execution and reporting pack design

• End-to-end group close sequence in OneStream
• Close dashboard design and operational KPI selection
• Consolidation reconciliation checkpoints and evidence retention
• Exception management for late loads and post-close adjustments
• Management reporting pack structure and narrative requirements
• Access controls, segregation of duties and audit readiness
• OneStream operating model and continuous-improvement backlog

Workshop: Participants complete a simulated group close and produce a documented reporting pack, reconciliation checklist and improvement plan for their own finance process.

Tools & standards covered

OneStream, OneStream Excel Add-In, Microsoft Excel, IFRS

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