Skip to main content
TrustRadius
OneStream

OneStream

Overview

What is OneStream?

OneStream Software provides a finance platform that aims to reduce the complexity of financial operations. OneStream™ supports finance by unifying corporate performance management (CPM) processes such as planning, financial close & consolidation, reporting, and analytics through a single, extensible solution.…

Read more
Recent Reviews

OneStream Review

8 out of 10
March 30, 2024
Incentivized
We're in the middle of implementing OneStream for Global Financial Close and Consolidation module as well as Task Manager. We're currently …
Continue reading

The Future of EPM is here!

10 out of 10
March 30, 2024
As a OneStream Diamond Partner, we work with a number of companies who present us with various issues associated with their close or …
Continue reading

OneStream Rocks

10 out of 10
March 30, 2024
OneStream is our financial reporting for the Magnet Wire Northa American Business Unit. Forecasting & Budgeting was time consuming. …
Continue reading

OneStream

10 out of 10
March 30, 2024
OneStream has been a complete game changer for our organization. We were able to move away from very large and complicated excel based …
Continue reading

OneStream Review

10 out of 10
March 29, 2024
OneStream is our global consolidation and budgeting/planning solution. It facilitates a singular environment to enable teams across 50 …
Continue reading

OneStream Review

10 out of 10
March 29, 2024
I have implemented OneStream for many organizations, some small and some large. I have found OneStream to be highly flexible and the …
Continue reading

TrustRadius Insights

OneStream is a versatile software solution that has been utilized by multinational electronics manufacturers, allowing them to streamline …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 46 features
  • Financial data consolidation (44)
    9.5
    95%
  • Financial Statement Reporting (44)
    9.2
    92%
  • Management reporting (44)
    9.1
    91%
  • Management Reporting (44)
    9.0
    90%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is OneStream?

OneStream Software provides a finance platform that aims to reduce the complexity of financial operations. OneStream™ supports finance by unifying corporate performance management (CPM) processes such as planning, financial close & consolidation, reporting, and analytics through a single,…

Entry-level set up fee?

  • Setup fee required
For the latest information on pricing, visithttps://hubs.li/H0MLW9X0

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

52 people also want pricing

Alternatives Pricing

What is Budgyt?

Budgyt is a platform made to simplify business budgeting. With built-in functions designed for data integrity, team collaboration, and scenario planning & analysis, Budgyt is presented as an optimized budgeting experience that rids users of complex, error-prone spreadsheets and the time-consuming…

What is Spoom?

Spoom (formerly Analyza) is a business intelligence solution that is provided by Spoom Software (formerly PIT Business). The vendor provides support services in Luxembourg, Belgium, France, and other parts of Europe. Spoom allows users to: Build several indicators and dashboardsBuild ad-hoc…

Return to navigation

Product Demos

OneStream Live Lifetime Deal and Product Tutorial or Demo ( Christmas New year 2023 Special Offer)

YouTube

Live with OneStream

YouTube

OneStream - A New Way To Share Your Content | OneStream Tutorial | OneStream Demo

YouTube

OneStream Studio Updates

YouTube

OneStream Demo

YouTube

OneStream Live Review & Demo: Live Stream Pre-Recorded Videos on 40+ Platforms [AppSumo Deal]

YouTube
Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

8.6
Avg 8.0

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

7.6
Avg 8.3

Report Output and Scheduling

Ability to schedule and manager report output.

8.7
Avg 8.2

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

7.7
Avg 7.6

Access Control and Security

Access control means being able to determine who has access to which data.

8.9
Avg 8.7

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

6.7
Avg 8.0

Budgeting, Planning, and Forecasting

These activities are designed to assist with both data-driven operational, short-term planning and strategic long term planning

8.3
Avg 8.3

Consolidation and Close

Consolidation of data from multiple entities with currency management, reporting and audit trails.

8.9
Avg 8.0

Financial Reporting and Compliance

Financial statements and regulatory filings

8.7
Avg 8.2

Analytics and Reporting

Dashboards and scorecards for KPI monitoring and benchmarking

8.6
Avg 8.0

Integration

Ability to integrate with external applications.

9.1
Avg 8.3
Return to navigation

Product Details

What is OneStream?

OneStream Software provides a finance platform that aims to reduce the complexity of financial operations. OneStream™ supports finance by unifying corporate performance management (CPM) processes such as planning, financial close & consolidation, reporting, and analytics through a single, extensible solution. The vendor states their goal is to empower the enterprise with financial and operational insights to support faster and more informed decision-making. It is a cloud platform designed to continually evolve and scale with the user's organization.

OneStream Features

Budgeting, Planning, and Forecasting Features

  • Supported: Long-term financial planning
  • Supported: Financial budgeting
  • Supported: Forecasting
  • Supported: Scenario modeling
  • Supported: Management reporting

Consolidation and Close Features

  • Supported: Financial data consolidation
  • Supported: Journal entries and reports
  • Supported: Multi-currency management
  • Supported: Intercompany Eliminations
  • Supported: Minority Ownership
  • Supported: Local and consolidated reporting
  • Supported: Detailed Audit Trails

Financial Reporting and Compliance Features

  • Supported: Financial Statement Reporting
  • Supported: Management Reporting
  • Supported: Excel-based Reporting
  • Supported: Automated board and financial reporting

Analytics and Reporting Features

  • Supported: Personalized dashboards
  • Supported: Color-coded scorecards
  • Supported: KPIs
  • Supported: Cost and profitability analysis
  • Supported: Key Performance Indicator setting
  • Supported: Benchmarking with external data

Integration Features

  • Supported: Flat file integration
  • Supported: Excel data integration
  • Supported: Direct links to 3rd-party data sources

BI Standard Reporting Features

  • Supported: Pixel Perfect reports
  • Supported: Customizable dashboards
  • Supported: Report Formatting Templates

Ad-hoc Reporting Features

  • Supported: Drill-down analysis
  • Supported: Formatting capabilities
  • Supported: Predictive modeling
  • Supported: Report sharing and collaboration

Report Output and Scheduling Features

  • Supported: Publish to Web
  • Supported: Publish to PDF
  • Supported: Report Versioning
  • Supported: Report Delivery Scheduling

Data Discovery and Visualization Features

  • Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)
  • Supported: Location Analytics / Geographic Visualization
  • Supported: Predictive Analytics
  • Supported: Support for Machine Learning models

Access Control and Security Features

  • Supported: Multi-User Support (named login)
  • Supported: Role-Based Security Model
  • Supported: Multiple Access Permission Levels (Create, Read, Delete)
  • Supported: Report-Level Access Control
  • Supported: Table-Level Access Control (BI-layer)
  • Supported: Field-Level Access Control (BI-layer)
  • Supported: Single Sign-On (SSO)

Mobile Capabilities Features

  • Supported: Responsive Design for Web Access
  • Supported: Dashboard / Report / Visualization Interactivity on Mobile

Additional Features

  • Supported: Account Reconciliations
  • Supported: Disclosure Management
  • Supported: Transaction Matching
  • Supported: People Planning
  • Supported: Capital Planning
  • Supported: Sales Planning
  • Supported: Profitability Analysis

OneStream Screenshots

Screenshot of OneStream DashboardScreenshot of Profitability AnalysisScreenshot of Product and Customer ProfitabilityScreenshot of Account ReconciliationsScreenshot of Cash PlanningScreenshot of Financial SignalingScreenshot of Task ManagementScreenshot of Predictive Analytics

OneStream Video

OneStream Software | Company Overview

OneStream Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows
Mobile ApplicationApple iOS, Android, Windows Phone, Blackberry, Mobile Web
Supported CountriesAmericas, EMEA, South Africa, APAC

Frequently Asked Questions

Reviewers rate Flat file integration highest, with a score of 9.7.

The most common users of OneStream are from Enterprises (1,001+ employees).

OneStream Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)0%
Mid-Size Companies (51-500 employees)0%
Enterprises (more than 500 employees)100%
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(70)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

OneStream is a versatile software solution that has been utilized by multinational electronics manufacturers, allowing them to streamline their Balance Sheet Accounts Reconciliation Process. With over 1500 users and 50,000 accounts, OneStream has effectively addressed the challenges associated with the previous manual approach, including disintegrated processes, lack of standardization, and a consolidated list of action items. This software also serves as a budgeting and forecasting solution, enabling better tracking of utilization, billing rates, customer work, and financial impact. By loading data weekly and providing clear visualization of time allocation across customers and resources, OneStream facilitates informed decision-making and analysis capabilities for senior management through monthly reports. The software's continuous improvement through regular feature updates sets it apart from competitors in terms of functionality. CEOs and executives find OneStream valuable in gaining a comprehensive understanding of various fields such as accounting, sales, and collections, leading to quicker and more efficient decision-making. Moreover, OneStream's versatility extends beyond finance and accounting departments with its detailed reporting capabilities that cater to operational needs while also offering marketplace solutions for other business problems. With its scalability and ability to handle growth, OneStream proves to be an invaluable tool for companies of varying sizes and industries including manufacturing, oil & gas, healthcare, and retail. By reducing cycle times and serving as a single source of truth for financial planning and people planning, it saves customers time and money on a monthly basis.

Time-saving Account Reconciliation: Several users have found OneStream's Account Reconciliation solution to be a significant time-saver compared to navigating through spreadsheets. They appreciate being able to see an overview of their reconciliations, which allows them to consolidate data from integrated source systems at a detailed transactional level.

Native Dashboarding Capabilities: Users are impressed by the native dashboarding capabilities of OneStream. They are able to replace their standalone BI tool with dashboards within the platform, streamlining their reporting and providing them with great reports and visualizations.

Easy Data Integration: Many users highlight the easy data integration capabilities of OneStream. They find it convenient to import data from simple CSV files to more complex data sources using API, SQL, etc., making it seamless to bring in data from multiple sources.

Confusing User Interface: Some users have found that the user interface of OneStream is not intuitive, resulting in difficulty learning and using the software effectively. The lack of clear navigation or organization within the interface has been a common complaint among users.

Reliance on Microsoft Technology: Several reviewers have expressed frustration with OneStream's reliance on Microsoft technology. They have encountered compatibility issues with different versions of Microsoft products and limitations imposed by specific browsers, which hindered their overall experience with the software.

Lack of Keyboard Shortcuts: Many users have highlighted a significant drawback regarding OneStream's lack of keyboard shortcuts. This absence slows down their workflow considerably as they are unable to quickly execute commands or perform actions through efficient key combinations. Users believe that incorporating keyboard shortcuts would greatly enhance their productivity while using the software.

When considering the desired scope of functionality, users recommend engaging an implementation consultant and contacting peers on the client reference list for further assistance. Users find the software to be a great tool and are proud of their decision to use it. They advise utilizing the available tutorials for additional support and recommend taking the time to thoroughly analyze all aspects of the software. It is also recommended to settle internal discussions before starting the implementation process. Users find OneStream XF targeted towards finance professionals and highlight the importance of exploring the OneStream XF marketplace for additional solutions. The software is described as a fast and reliable platform that provides agility and flexibility for obtaining homogeneous information. Users find OneStream XF to be an incredible tool that can save time for consolidations, financial reporting, planning, and more. To ensure proper setup and organization of the application, it is suggested to use OneStream personnel and service providers during the initial design and implementation.

Attribute Ratings

Reviews

(1-25 of 45)
Companies can't remove reviews or game the system. Here's why
Tim Vierhout | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are an Onestream implementation partner. At our customers, we implement OneStream for streamlining monthly closes, planning, forecasting, and reporting. We are very happy with OneStream as it provides the platform for us to support our customers optimally. OneStream is a fast, reliable, proven, and flexible platform that allows for an optimal configuration for each of our customers.
  • Consolidation
  • Planning
  • Forecasting
  • Budgetting
  • Workflows
  • Calculations
  • Reporting
  • Web interface
  • Power BI integration
  • Power point integration
OneStream is well suited to support large organizations with the whole finance function. Ideally, starting with the Actual data but building on that to also include budget, forecast and non-financial information to allow for one single platform containing all data and reports required for the finance function in the organization.
March 30, 2024

OneStream Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We're in the middle of implementing OneStream for Global Financial Close and Consolidation module as well as Task Manager. We're currently consolidating in Excel and OneStream should be able to help us to do this in the system. Next phase would include People Planning and Budgeting/Forecasting. We're still evaluating whether Account Reconciliations is something we would implement.
  • Consolidation
  • Workflows
  • Good structure for activities done by the end users
  • Easy to pick up simple task of navigating around
  • The application seems a bit more technical for business users
  • Great structure within the system that's done by using the workflows.
Financial Planning / Forecasting, People Planning, and Financial Close and Consolidation are well suite while we are still evaluating GL Account Reconciliations and other solutions available via the Solution Exchange. Overall, we believe OneStream is going to allow us to "get out of excel" and perform Global Consolidation in the system.
Maret Oosthuizen | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
OneStream (OS) is used for Statutory, Management and Regulatory reporting. For statutory purposes, the need was identified to be able to produce annual financial statements on a consolidation level. OneStream is used to consolidate company data up to a Holdings level. By completing forms in OneStream information is gathered in the system and this is used to produce the disclosures required for statutory reporting.

For Management reporting actual and budget data is available in the system and reports were designed to have a management view.

For Regulatory reporting on the BA100 and BA120, which uses financial data, the regulatory reports had to correspond to the statutory reports. By using OneStream, one source of data is used for reporting, with no discrepancies between for example profit, total assets and total liabilities on the different reports.
  • Roll up of data to a Consolidation level as per structures
  • Linking with Excel and the use of GetCell formulas to create your own reports
  • Easier drill down functionality, one click to take you to the underlying detail.
  • Consolidation within OneStream seems to be a difficult process.
OneStream is well suited for statutory reporting purposes. For Management reporting users tend to require more detailed information. User acceptance of the system is very important
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use OneStream every day, from helping out with our forecasting and planning to solving everyday problems both internally and for several of our clients. As we are a OneStream partner, we also advice our clients in how to best use OneStream for all planning and consolidation needs, as well as help them implement OneStream in their organization.
  • Consolidation
  • AI driven Time series forecasting
  • Planning and budgeting
  • Createing a simple "out-of-the-box" consolidation kit for smaller businesses
  • Simplifying report building with standard reports
  • Increase scalability
To me, it is the best planning, forecasting and consolidation tool on the market for large and medium enterprises. For smaller, less complex entites, implementation can be daunting.
Score 10 out of 10
Vetted Review
Verified User
As a OneStream Diamond Partner, we work with a number of companies who present us with various issues associated with their close or forecast cycles. OneStream gives us the tools to be able to tailor an application and resolve these issues, in some cases expediting their close cycles by automating manual tasks such as a cash flow, consolidation, inter-company, and currency translation.
  • Consolidation
  • People Planning
  • Budgeting and Forecasting
  • Large data analytics
  • Debug feature for VB.net
  • Error Logging
OneStream is best suited as a consolidation application, it brings together TBs from multiple companies and consolidates them with ease. Driver based forecasting is another great use for OneStream as it allows the users to get a jump on keying a forecast based on metrics typically used in Excel models.
March 30, 2024

OneStream Rocks

Score 10 out of 10
Vetted Review
Verified User
OneStream is our financial reporting for the Magnet Wire Northa American Business Unit. Forecasting & Budgeting was time consuming. OneStream helped with this streamline.
  • workflows
  • security
  • account reconciliations.
  • loading actuals
  • parcel post - automatic sending of data
  • more specific training videos
  • easier instructions on implementing an application
  • Excel XfSet and XfGet
Work flows and being able to go from excel to a cube view. the different ways you have to pull data. One of our issues were it does notwork well is drill down and digging into the data, but most of that is on us as our GL System was not able to get the detailed data that we wanted.
Score 8 out of 10
Vetted Review
Verified User
OneStream is used for
- Consolidation of 8 international subsidiaries, based on SAP R/3 local data.
- Monthly detailed financial forecast based S&OP plan data and other transactional data extracted from SAP BW, the forecast calculations include profit and loss details on entity level with IC revenue, raw material cost updates and balance sheet calculations with specific details for working capital and other inputs.
Use case of the forecast is to track results versus target and previous forecast.
- Reporting set was build for management reviews, which can be quickly generated by changing variables.



  • Workflows to have step by step processes
  • Import data from different sources with validation of metadata and extensive transformation rules
  • Consistently calculate all variables
  • Freedom to define cost drivers with member formulas
  • Deploying of market place solutions is cumbersome and often requires external support.
  • Calculation of a planning scenario can take quite some time depending on the data structure.
  • Version upgrades require preparation and resources.
It is good for detailed planning based on workflow. Functionality was added to determine raw material purchases, which works well with details we already used to calculate inventories.
Reporting can be very flexible when metadata naming convention is consistent.
Metadata organization is not straightforward, new items are always added at the bottom and can't be sorted.

March 30, 2024

Review of OneStream

Score 10 out of 10
Vetted Review
Verified User
We use OneStream as our Consolidation tool for collecting our Actuals data from various source ERP systems. We also use an Investment register built into the tool and then also use OneStream for Flash reporting, Annual Plan and quarterly forecasts. We are also considering ESG reporting and expanding our Tax use of the application.
  • Consolidation engine is powerful, we have around 500 entities translating from multiple source currencies into a common currency at good speed.
  • We leverage the Flash and Quarterly forecast providing users with pre seeded data so they only need to make tweaks rather then filling in a lot of manual forms.
  • We use Transaction matching for processing a lot of intercompany matching invoices from the ERP systems which helps end users a lot. Data is fed in from source ERPS and TXM generates the auto matches based on criteria provided.
  • We have a custom Tax module which we use to pull in tax entries from the consolidation side and this gives the Tax teams starting position for their tax calculations and enables them to also do a quarterly forecast estimate.
  • OneStream has great dashboarding capabilities for a whole range of use cases from charts and graphs, to drill-back data to running even steps that users can execute without having access to the source code/rules in the background!
  • Journal copy feature would be good to have
  • The Excel Add in is limited to only one application. Would be good to have the ability to pull from say Dev and Prod so side by side comparisons could be done
  • Better interface to handle metadata changes
I think it is a great platform and so much can be done starting with the core EPM features like Actuals Budget Forecast and then going on with Machine Learning and even AI where it makes sense. Bi Blend is another area I have used in a previous place that seems to work really well.

March 30, 2024

OneStream

Phillip E. Cole, CPA, CGMA | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
OneStream has been a complete game changer for our organization. We were able to move away from very large and complicated excel based consolidations for both internal and external reporting. This improved quality and timeliness of our reporting helped us to finish our annual audit in record time this year. Although the basic consolidation functions have been revolutionary for us, we are now looking forward to further efficiencies that this platform has to offer.
  • Consolidation of multiple entities
  • Connecting to source ERP systems for current data
  • Flexibility in reporting using cube views
  • Flexibilty in ad-hoc reporting using excel based quick views
  • This is such a complex program, it would be nice to have more how-to videos to help users get up to speed.
  • It seems like the support websites change quite often and are not very easy to follow. When we are dealing with complex issues, it would be nice to have a more simple path to support.
  • It would be nice to have a single website launch point for support, knowledge, Champions, Learning, etc. If that could launch from within the application using already provided credentials, that would be even better.
Absolutely 10 out of 10. Could not be happier.
This program is very complex, so it may not be right for small simple companies, but with the proper setup partners and training this program can make huge improvements to current processes for most companies.
Michel Sabourin | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
I am a consultant that implements OneStream at various clients, and that's where I think OneStream's strength lies. It can be adapted to fit any industry from manufacturing to retail to financial services. It also provides functionality to support close/consolidation, budget/planning, and reporting from a single tool and single source of truth.
  • Close/Consolidation
  • Budget/Planning
  • Reporting
  • Account Reconciliations
  • Metadata Management
I haven't come upon a situation or need that we haven't been able to address in OneStream
March 29, 2024

OneStream Review

Score 10 out of 10
Vetted Review
Verified User
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 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.
March 29, 2024

OneStream Review

Score 10 out of 10
Vetted Review
Verified User
I have implemented OneStream for many organizations, some small and some large. I have found OneStream to be highly flexible and the Marketplace solutions that OneStream provides give organizations a jump start that would typically take weeks or even months to get started. Whether companies are doing planning or consolidations or trying to tackle other analytical challenges, OneStream can provide many options.
  • Data Integration
  • Consolidation
  • Planning
  • Reporting
  • Security is flexible, but can be confusing for end users
  • Documentation around internal business rule methods
  • Standards on 3rd party libraries
  • Ability to integrate visual studio with OneStream Cloud for developers
Obviously OneStream's sweet spot is Consolidations and Planning.

OneStream is not well suited for transactional data. this data can be reported on with bi blend, but OneStream is not a transactional system and trying to use it in this type of use case is not appropriate
Score 8 out of 10
Vetted Review
Verified User
We use OneStream for enabling our clients to use CPM systems for planning, Budgeting and Forecasting. Also the OneStream system is used by our clients for consolidations to enable them to have a clear cut insights of their financial data and helps to do better decision making. The financial data analysis helps the organization to better allocation and use of the funds. OneStream is used by us for generating various financial reports such as Income Statement, CashFlow, Balance Sheet etc.
  • Consolidation
  • Planning
  • Eliminations
  • Allocations
  • Better enablement of OneStream excel addin. Every time when we have to fetch data from two different application, we have to log off from one and login to the other. This is very irritating for a developer who do unit testing.
  • More free access to the learning content
  • Better pricing for certification exams
It is a revolutionary product to have all the financial data analysis tools under one blanket. Earlier the planners and the CFOs had to juggle between various financial analytical systems for the analysis of data for better decision making but now their life has become much easy with all the products packaged under one umbrella.
Score 9 out of 10
Vetted Review
Verified User
OneStream is used for consolidated management reporting of actual results, rolling forecasting and reporting processes linked to consolidated reporting results, including financial close accounts reconciliations, task manager, sustainability, Tax, legal entity, Capex and supply chain non-financial reporting.
The business need we address with OneStream is to create a full stack of performance management reports where reported numbers align with the financial management reporting structure and various angles can be created in a consistent manner and additional dimensions can be added to the reported data for the right business insights.
The scope of our use case is full management performance reporting, integrated with our financial planning as well as our operational business planning and supply chain processes.
  • Share reporting dimension hierarchies across reporting processes
  • extend dimensions as needed to the requirements of individual processes
  • provide prebuilt, downloadable solutions allowing for quick time to market of reporting solutions
  • extend reporting beyond traditional financial reporting processes to create in depth business insights
  • Provide some more prebuilt dashboards that serve as reference examples for specific topics, to allow users to gain an idea of all that is possible
  • Provide some clear cut explanations to explain some of the standard concepts, to allow companies that start their implementation to gain a quick understanding of how things work
OneStream is well suited for any level of consolidated financial reporting, but becomes especially strong when adding forecast/planning reporting and integrating with other reporting and analysis processes that need to be aligned and reconciled with the financial reporting structure. For this reason, OneStream supports a wide variety of processes with varying levels of dimensionality. Due to the ability to share reporting and dimension structures where needed, new processes can be deployed quickly without gaps. And the data seeding between scenarios allows for re-purposing one dataload in as many reporting processes as needed, ensuring that everyone works with the same version of the truth. The growing number of prebuilt, downloadable solutions from the Market Place offer options to customers that allow for deploying of new processes quickly, without customers having to invent the solution on their own.
Brian Frederick, MBA | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
We use OneStream for our monthly financial consolidation and reporting. We were able to remove over 20 hours a month from our close process by moving to OneStream. Along with removing hours, we are able to produce better and more accurate results each month. <br>Along with the Consolidation tool, we implemented the Planning/Forecasting tool. For the first time, the company now has budgets for each department that we can track and report against. This has given us even more insight into our spending.
  • Consolidations
  • Ease of use
  • Reporting
  • Driver based forecasting
  • User Interface
  • Excel Add in
OneStream is well suited for producing monthly results and consolidations. It has saved our company hundreds of hours since we went live a year ago. I have more confidence in our results than I had with our prior consolidation tool. We can now produce monthly results in minutes vs hours which allows the finance and operations teams more time to analyze results vs pulling the data.
Score 10 out of 10
Vetted Review
Verified User
We currently use OneStream for financial close process, account reconciliations, transaction matching, task manager, and reporting / analysis. We also have plans to expand on these by utilizing additional Marketplace Solutions such as machine learning, people planning, etc..

So far, OneStream has improved are close process timeline, increased reporting visibility, and is very user friendly.
  • As a global company, we have multiple source systems that are used for financials. OneStream allows us to bring in the financial data from source to a consolidated view for reporting.
  • Ability to blend financial data with operational data.
  • Reporting and analysis. Ability to create a wide range of reports. From standard cube views to intricate dashboards to extensible documents that works with Microsoft Office.
  • The only issues we've experienced are directly with the business end and not with OneStream's capabilities.
  • I would like more advanced learning possibilities.
OneStream has drastically reduced our turnaround time during the month end process. Task manager has kept us on top of each steps within all processes to make sure no steps are missed, and also allows us status updates by viewing completed/open tasks. The reporting capabilities have allowed us to dive deeper into our financial results. Forecasting/budgeting will allow us to more accurately predict our future results using advanced capabilities such as AI and predictive analysis.
Score 8 out of 10
Vetted Review
Verified User
We use OneStream for Financial reporting (consolidation), Tax reporting, and FP&A analysis. In the near future we will also use OneStream for ESG reporting and FP&A forecasting. We are busy with the automation of data flowing in from the source ERP and the possibility to drill back to the source ERP system.
  • Flexibility
  • Consolidation
  • Documentation of all the abilities
OneStream is very well suited for a large range of scenarios. Besides the regular Consolidation engine, you can use OneStream also for reporting on non-financial data like Environmental, Social, & Governance (ESG). And not only on Actuals, but also on Forecasting and Budgeting. Besides that, you can use OneStream for analysis of the financials (FP&A). The reports from OneStream itself are not that good, but exporting them to Excel or in the near future to PowerBI will solve that issue.
Score 8 out of 10
Vetted Review
Verified User
We are using OneStream primarily for the Account Reconciliation program, and it's nice. Also we are extending the same to use as Risk Assessment Tool.
  • Some Standard Reports are too good, which can be easily customized and fulfills the Audit needs.
  • Integration with Excel and Spread sheet component is the best feature, where in you can create dashboards in Excel as well. for Excel lovers it's nice.
  • Consolidation of the data is it's great strength, then comes the XF extensibility.
  • Metadata Upload functionality for one time is nice but if we need to modify and re-upload the same month on month, it's very difficult and needs definitely improvement.
  • Navigation between the tabs is not available which should be there, if a user wants to compare the data for 2 dashboards, it's not possible
  • Drill down feature is nice, but of no use, since to get the source data, we need to click multiple clicks and that too complete information at any point of time cannot be downloaded in an excel or a csv.
  • Work Flow Rename Hierarchy is not available , which can lead in SOX compliance issues.
  • While uploading the files in File Explorer, Multi upload files are not possible via User Interface, so practically to use that feature is a big challenge.
Auto Reconciliation Features are very well integrated and ready to use, it's like a plugin and start using the same. High-level reporting with millions of rows is not that great and OneStream has some limitations.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
OneStream is used as a CPM platform for consolidation, budgeting, disclosure, IFRS reporting, cash flow and other reporting needs. It has been valuable in reducing our reporting time. Our prior application could not handle our growth in size and OneStream has proven to well suite to handle the size and growth of our company. Because OneStream is a platform, it is not only used by our finance department for consolidation, but also by Tax, HR and we are looking into expanding the new use cases like ESG, Pillar 2 etc.
  • Financial Consolidation
  • Calculations using business rules
  • Workflow
  • Reporting and disclosures
  • Data Interfaces
  • Audit trail
  • More/better excel functionalities
  • Better helpdesk support
  • Visualisation (e.g. graphs, charts)
  • Reporting layouts
OneStream is well suited for larger companies who are looking for a platform not only for consolidations but also for a other reporting purposes, for instance, planning, esg, etcetera. As it is a platform with wide range of possibilities, this has also implications on the support. Therefore it is better suited for companies who can ensure they have access to sufficient support, internal or external. For simple reporting OneStream may be to heavy of a package.
Score 10 out of 10
Vetted Review
Verified User
We utilize OneStream for planning, reporting, and dashboarding. Rolling forecast, management reporting, and budgeting are critical uses for us.
  • budgeting
  • dashboarding
  • financial reporting
  • documentation
  • better dashboard visuals similar to PowerBI
  • more blogs, youtube videos, and other resources
a centralized application for financials allowing users in excel but utilizing a centralized data source advanced business rule logic
March 15, 2024

OneStream Wonders

Score 7 out of 10
Vetted Review
Verified User
Incentivized
OneStream provides wide range of facilities for the accounting process where we are able to analyze the past present and future of business trend. we can use it for scenario based analaysis and helpful for management to take decisions on right time and benefits. OneStream is convenient and user friendly to work. for my case its very useful tool which enable us to use single tool for multiple purpose. Fcst budgeting and analysis
  • Accounting Managment
  • Forecast
  • Budget
  • BI
  • Scenario Based Analysis
  • Capex track
  • Management adjustment
  • Need to link on excel based macros
  • Tableau supporting
  • Pagination issue
  • xfget formula examples
  • Pre template of Excel to get meta data
well suited OneStream can pull the multiple dimension data in a single click. we can segregate the data with U1-U8. We can get more info while drilling down the data Improvements. Need improvements on the quick view pagination issues. Also some limited lines to extract the data. cubeviews are static not dynamics.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Currently we are using OneStream for Consolidation, FP&A and Tax. For Consolidation we use a separate cube due to the enormous amount of data. Tax is using a part of this data in its own cube and here a lot of calculations and corrections are taking place. FP&A is mainly using the data from Actuals of the Consolidation cube, but in the future they will also forecast in OneStream.
  • Consolidate
  • Flexibility
  • User interface
  • Some documentation is out of date
OneStream is working very well with large volumes of data, and this improved by version 8 even further. With complex hierarchies or cross sections, I think OneStream is at its best.

For smaller companies, I think OneStream is probably a bit overkill and overwhelming. Also dashboards are nice, but not as beautiful as PowerBI.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Companies recognize their old way of manually consolidating financial data or manually preparing forecasts just isn't efficient. We help them free up time so their employees can work on higher value add items instead of trying to figure out how Excel broke the model. This leads to accountants doing analysis rather than checking for formulas that have hard-keyed amounts or broken cell references.
  • Consolidates complex entity hierarchies
  • Calculates forecasts with many drivers
  • Some improvements on documentation would be helpful.
  • The ability to use keyboard shortcuts is severely lacking.
OneStream is best suited for medium to large companies that find themselves doing a wide variety of manual processes during their financial close cycle will get the most benefit. That does mean a lot of change so there has to be very intentional communication around change management in order to get the buy in that is necessary for success.
Score 8 out of 10
Vetted Review
Verified User
We implemented OneStream's Marketplace solution "Account Reconciliation" 2 years ago. unlike others, our scope of Account reconciliation is not just account-to-substantiation matching, instead, we lead the industry by consolidating the substantiation from the lowest level of the business unit to the top Parent. I would call it an extended version of the Consolidation process. In this process of the build, we have used several Business rules, Transformation rules, custom dimensions, cube view dashboards, SQL editor dashboards etc.,
  • Flexibility to meet client's requirements
  • Transformation Rules
  • Data connectors
  • Customized Confirmation Rules
  • Dashboards
  • APIs
  • Admin Privileges
Using data connectors, we have loaded massive transactional data of Subledgers like AR, AP, Inventory, PPV etc., and built a detailed analysis of risk assessment dashboards for Controllers/ RFDs to take appropriate actions. These dashboards are fully automatic without any manual intervention from users. Yes, you heard it correctly, fully automatic.

Moreover, with single license clients can use multiple applications like FS close, matching modules as plug and play with minimal configurations.
Score 10 out of 10
Vetted Review
Verified User
For Business Planning & Consolidation. - One source of the truth - Integrated business planning from target setting to production - What If scenario planning - Streamlined consolidation processes.
  • Integrating multiple sources
  • End user process
  • Custom made calculations
  • Disclosure Management
  • Standard Calculations
All the clients that I worked for are happy with OneStream, and really using the product. With OneStream it is possible to really digitalize the total Financial Office with one source of the truth. No more discussion about data, its about analyzing not about creating data. Looking forward to integrating ESG within OneStream.
Return to navigation