OneStream Review
March 29, 2024

OneStream Review

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with OneStream

OneStream is our global consolidation and budgeting/planning solution. It facilitates a singular environment to enable teams across 50 countries to report actuals and enter quarterly forecasts and budgets. It also has enabled our growth strategy and maintained our reporting standards across the group as we have tripled in size over 3 years from 200 entities to 600+ entities. OneStream is used as the entry and consolidation point for all global requirements including models on IFRS15, IFRS 16, Business Combination, Deferred Consideration, Payroll Reporting, Financial Attestations, Statutory Note Gathering, Share Scheme Calculations, Investment Case Monitoring, Quarterly Rolling Forecasts and Annual Budget process as well as our standard Actual Month End process.
  • Consolidation of Group Results across 600 Entities
  • Flexibility of Reporting through Dashboard Reporting Suite and Excel Interface
  • Ability to create Bespoke Models for specific requirements. (Ifrs15/16/BC/DC/Payroll, Covenance Reporting, etc.)
  • Singular Cube for One source of the Truth
  • Customisable Maintenance Platform to facilitate high growth strategy
  • Automated Calculation/Aggregation in Budgeting Applications
  • Maintenance of Solutions across Production and Development Environments
  • More Flexibility in the way workflows are implemented in Models
  • OneStream has facilitated the growth strategy of the Company, Growing from 200 entities to 600 Entities, (600 to 2500 Reporting Units) managed by a team of 3 Admin
  • Month End Close has remained at 10 Days despite additional 400 entities in size with minimal change to FTE heads
OneStream offers a comprehensive toolset to facilitate most modeling requirements. Our primary focus for selecting onestream was to facilitate a fast, robust and fully auditable consolidation tool that would meet our growing business requirements. OneStream has delivered on all fronts and has facilitated a complete reporting solution across Dashboarding, Management Packs and Excel analysis.

As an audit trail we are able to provide a complete end to end view for both auditors and end users of calculated and imported data in the system linked all the way back to our source ledgers.

As a growth business it was critical that we had a tool that would scale up with the business without creating a system or performance burden.

Do you think OneStream delivers good value for the price?

Yes

Are you happy with OneStream's feature set?

Yes

Did OneStream live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of OneStream go as expected?

No

Would you buy OneStream again?

Yes

OneStream is perfectly suited for Global Consolidation and Reporting Requirements.
Where users require the flexibility of both custom reporting through Excel and structured reporting packs built in System where a singular source of the truth is a requirement.
As a tool for consolidating Global Budgeting and Planning Requirements and facilitating a fully fledged Income Statement to Cashflow Forecast with Intercompany activity.

It is probably less appropriate as a standard transactional Operational Forecasting tool but through Machine Learning functions these capabilities can easily be covered.

OneStream Feature Ratings

Long-term financial planning
10
Financial budgeting
8
Forecasting
8
Scenario modeling
8
Management reporting
10
Financial data consolidation
10
Journal entries and reports
10
Multi-currency management
10
Intercompany Eliminations
10
Minority Ownership
10
Local and consolidated reporting
10
Detailed Audit Trails
10
Financial Statement Reporting
10
Management Reporting
10
Excel-based Reporting
10
Automated board and financial reporting
10
Personalized dashboards
10
Color-coded scorecards
8
KPIs
10
Cost and profitability analysis
10
Key Performance Indicator setting
10
Benchmarking with external data
10
Flat file integration
10
Excel data integration
10
Direct links to 3rd-party data sources
10
Pixel Perfect reports
7
Customizable dashboards
10
Report Formatting Templates
10
Drill-down analysis
10
Formatting capabilities
8
Report sharing and collaboration
10
Publish to Web
5
Publish to PDF
10
Report Versioning
5
Report Delivery Scheduling
10
Pre-built visualization formats (heatmaps, scatter plots etc.)
9
Location Analytics / Geographic Visualization
9
Predictive Analytics
9
Multi-User Support (named login)
10
Role-Based Security Model
10
Multiple Access Permission Levels (Create, Read, Delete)
10
Report-Level Access Control
10
Single Sign-On (SSO)
10
Responsive Design for Web Access
8
Dashboard / Report / Visualization Interactivity on Mobile
5

Using OneStream

500 - Global Finance Teams, Covering both Management Accountants, Financial Accountants, Reconciliation Teams and Financial Planning an Analysis

All Month End Actual Submission and Budget and Forecasting Submissions are entered in OneStream.

Local Financial Teams also record all balance sheet reconciliations and supporting documentation in OneStream.

Management Reports are live and Interactive and widely used across the finance community.
8 - 2 Administrators to handle the normal BAU Activity
1 Admin Manager/technical accountant to supervise BAU activity and oversee all Audit processes M&A Administrators to handle the ongoing M&A activity in the business - onboarding circa 15 new entities per month (400 entities between 2020 and 2023)
2 Developers with strong code writing and application design skills to cover all Model Development
1 Development Manager with advanced technical accounting and system skills to Supervise all system dev and new entity onboard
1 Team Manager to support team across all activities and project manager deliveries.
Note - there is no external 3rd party support - all activity is 100% delivered by the in house team
  • Actual Month End Financial Consolidation
  • Budgeting and Forecasting
  • Lender Reporting
  • Balance Sheet Reconciliations
  • All IFRS Modelling to bring group in line with IFRS Standards (15/16/Business Combinations/Deferred Consideratinos)
  • Enhancing Payroll Reporting by Individual from Workday to tie back to actual Income Statement postings in OneStream
  • Share Scheme Models to facilitate the calculation of Vesting shares for new Shareholders through business acquisitions
  • In the process of developing a Machine Learning Solution to facilitate an automated income by policy forecast
  • ESG data capture across the group
OneStream has delivered on all the core requirements we had at the point of implementation. Auditability has improved. Data is more secure and user security is auditable, Reporting is greatly improved and easily maintained whilst remaining flexible for end user analysis.
The system has scaled up as the business has expanded with little additional resource and has facilitated us a platform to deliver 30 models across finance allowing us to expand functionality without having to invest in new tool sets.