Vena Solutions Reviews

26 Ratings
<a href='' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic




Job Type


Reviews (1-22 of 22)

Anonymous | TrustRadius Reviewer
December 11, 2019

BI for Excel Wizards

Score 8 out of 10
Vetted Review
Verified User
Review Source
Vena Solutions is being used as a business intelligence tool at our organization. Vena Solutions automates the production of dashboards, helps us post journal entries, and orchestrates the flow of data from source systems into our final 11-dimension cube. The tool is being used across the entire organization, but the majority of the company are consumers.
  • Vena Solutions does a great job of leveraging the power of Excel.
  • Vena Solutions integration developers are great (specifically, Patrick Gibbs).
  • Accessing Vena Solutions Excel templates requires a lot of clicking. This can deter some consumers from accessing their data.
  • Vena Solutions still needs to work on the build-out of their web-based dashboard offering. They market the product as Excel-based, so the fact that they have any web-based components could be considered a pro.
Vena Solutions is well-suited for a company with at least one analyst who has expert level Excel skills. It is worth noting that the expert does not need any VBA understanding; they need to be fairly adept working with the regular user interface. Vena is much less appropriate for any company that does not have an Excel wizard on staff.
Read this authenticated review
Travis Tingey | TrustRadius Reviewer
January 31, 2019

Vena is the Batman of budgeting.

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Vena across our entire organization for budgeting and forecasting of all financial metrics. Department owners input their budgets, finance reviews inputs and then creates quarterly forecasts based on actuals that roll into Vena. Most recently we have started to use Vena for monthly variance analysis as well as income statement analysis.
  • Integration with Excel is seamless. I can use the newest formulas and functions as well as macros in my workbooks in my workbook without running into vena limitations. In fact, Vena makes excel better with additional easy to use and very powerful functions.
  • Very quick and easy to update with daily accounting software updates.
  • User-friendly process mappings that run the show.
  • Permissions for power users is underdeveloped. For example, no permission for a power user to act as admin in all groups but their own. - you can’t make someone an admin over certain groups without giving them the rights to change their own permissions.
  • Vena is always rolling out new functions and views making it difficult to have consistency in some of the tools you use regularly in Vena. It just requires that you read every update summary.
  • Doesn’t play well with Mac. They are getting better at this but for a long time Vena was inaccessible to Mac users and is really only available on a basic user level for Mac.
Great for budgeting and forecasting and financial metrics. Dashboards for executives are not as robust as Tableau or other visualization tools. I don’t use it for analytics as much as I use it for reporting.
Read Travis Tingey's full review
Anonymous | TrustRadius Reviewer
March 02, 2019

Vena: Welcome Excel Wizards

Score 8 out of 10
Vetted Review
Verified User
Review Source
Vena Solutions is being used by my company as a business intelligence tool. User representatives from every department participate. In most cases, we only make Vena available to department/site leaders. Although, we have made the tool available to all providers/doctors working for the company. Vena helps us automate the Export Transformation Load (ETL) process associated with aggregating our various source systems into a single cube.
  • Degrees of Freedom: Vena is extremely malleable. The majority of reporting/input functionality is orchestrated via MS Excel. If one is fairly well-versed with Excel, they will find Vena to be very powerful.
  • Updates: The Vena team always has new features in the hopper. Furthermore, these features seem to be focused on their points of weakness (e.g., addition of web-based dashboards)
  • Patrick Gibbs: The integration specialist dedicated to my team, Patrick Gibbs, was extremely helpful. While developing business rules surrounding our ETL process, Patrick was very engaged in the process. At times, I expressed the desire to understand the underlying SQL code and Patrick was happy to walk through things with me. Now, when I want to add new features, I am able to step through the code to better understand what I looking to ask the Vena development team.
  • Support: The support team is very responsive.
  • Automation: Vena automates processes that would normally take hours to complete manually. I should note, some of the load processes still take a few hours to complete (due to the size of our data set), but we have stored jobs set to run after-hours.
  • Web-Based Features: Vena still has room for improvement in proliferating their catalog of web-based features. As I write this, I am slightly worried that there are features available that I am unaware of. More modules like their "Dashboard" module would be helpful. Clicking through tasks -> task forms -> opening MS Excel document is too cumbersome for most busy individuals (doctors, executives, etc.).
  • Pricing: For the most part, Vena is much less expensive than most "premier" business intelligence tools on the market. That said, I recently struggled a bit with adding user subscriptions. I was unaware that after we added a certain number of licenses and/or after our initial subscription agreement matured, we would be subject to a SIGNIFICANT price hike. The increase in pricing was steep enough that we are looking currently on the hunt for an alternate solution.
  • Scale: This is probably an unreasonable expectation, but it might be worth including. It would be great if Vena offered to help make sure a project scaled well without charging their consultant fees. In other words, once a data set's size has become an issue (load times exceeding 3-4 hours), it would be nice if they helped to optimize the ETL process. I was able to accomplish much of this by restricting the initial data set, but I am far from an expert.
Vena is well suited for companies that have a population of users that are fairly adept with Microsoft Excel. Ideally, the company would also have an analyst who understands business intelligence, ETL, etc. Without somebody orchestrating the production, I doubt things would run very smoothly. Assuming there is somebody capable of running the software, the tool is awesome. Whenever we discuss investigating new tools, I always say the same thing, "If we switch to another platform, our users may have an easier time. That said, it feels like we can literally do ANYTHING with Vena."
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 25, 2019

Vena is great for budgeting

Score 9 out of 10
Vetted Review
Verified User
Review Source
Vena Solutions is used for budgeting at our company. It is primarily used by the accounting department with a little input from some department heads. I wouldn't say it addresses any problems, but it key in creating our budget for the year.
  • Vena Solutions has completely streamlined our budgeting process. It allows each department to see what was actually spent in a year in their department and plan for the future. I think this is important so each department head can account for what they spend and have a better control on it. I think my favorite part of Vena is just how easy it is to use. The team their was able to design templates perfect for our business and it was simple to update the following year.
  • The greatest strength of Vena Solutions is their customer service. The program alone is easy to use but if we did run into any issues, we had a response that day to help.
  • The only issue I've had with Vena is a few glitches in our templates. The problem was when we went to use it the following year, some of the formulas didn't calculate correctly. I'm not sure how it happened but they were quick to help resolve the issues. I think since we've only had it for a little over a year, it will get better in time and with more use of it.
Vena Solutions is perfect for budgeting. So far, that is all we use it for so I don't have anything to add to this.
Read this authenticated review
Matthew Blickley | TrustRadius Reviewer
September 28, 2018

Flexibility, Performance, and User Adoption

Score 10 out of 10
Vetted Review
Verified User
Review Source
Vena is being used as our annual budgeting, forecasting, consolidation, management reporting and financial analysis tool. Vena is used heavily on a daily basis by the finance team as we perform analysis and drive insights to our business and is the tool the entire business uses to plan on an annual basis and forecast periodically. Vena was implemented to provide a consolidated planning tool where we could eliminate disparate spreadsheets and control the process much easier. In addition, Vena gave us the flexibility in reporting financial results in our business that our ERP system was not well equipped to do. We expanded the use of Vena to consolidations recently given the positive experience we've had with the tool.
  • Flexibility - Vena is incredibly flexible for a changing business environment. The user interface allows the data model to be adjusted to meet the changing needs of thee business. In addition, the ability to create reports and templates and manipulate data is incredibly easy. It has helped us get to insights through analytics much quicker than we have been able to before.
  • Performance - Vena's speed reliability is great. We have several data sources and allocations/calculations we preform in the tool that require a lot of data and power and the tool's ability has not disappointed. One of the projects we implemented required data files with data files that were very large and Vena's performance is top notch.
  • User Acceptance / Adoption - The user interface of native Excel allows for widespread adoption of the tool across a large user base. Because the tool uses a software that nearly everyone in the business world is comfortable with, adopting the tool is easy. By placing a database on top of Excel is nearly invisible to the users of the product, it provides the value of real-time data availability in a comfortable interface.
  • Vena has met my needs all along the way. I've had several requests for development in the tool that I've submitted through the interface that the product team has taken into account and put on their development path. They have taken customer feedback very seriously and improve every day based on the feedback they receive.
Vena has use across several business scenarios. We originally started with some basic planning solution to meet our needs and have significantly expanded the scope of our use of the tool into more sophisticated planning and forecasting and into consolidation based on the experience we've had with the tool. We are considering expanding the use of the tool as we see its ability expand beyond what we are currently using it for.
Read Matthew Blickley's full review
Anonymous | TrustRadius Reviewer
May 29, 2018

A Simply Amazing Consolidation Tool

Score 9 out of 10
Vetted Review
Verified User
Review Source
We acquired a couple of companies in different geographies. Each of these companies' finance departments uses different IT systems, however, the common thing among all finance teams is the use of Excel. We chose Vena Solutions for the very reason, familiar Excel look and feel and its compatibility with Excel. Vena easily integrates with Microsoft Excel. All our finance teams across the world like Vena and import their financial statements from different ERP systems into Vena. The corporate will consolidate all these financial statements, do variance analysis using Vena.

We developed some fancy dashboards using Vena too. Finance controllers are assigned tasks in Vena and they are tracked for timely consolidation of financial reports. The audit trail feature in Vena is robust, if any data is changed, Vena will show the name of the person who updated it.
  • Easy integration with Excel. The tool looks familiar as it looks similar to Excel.
  • Great customer support from Vena support team.
  • It has all the advantages of Excel without the limitations of Excel like the audit trail, version control etc.
  • Audit trail feature helps in identifying the source of updates on the data.
  • Efficient aggregation and consolidation tool. The volume of data we handle could not be handled by Excel efficiently. Vena solved the problem.
  • Like any tool, it takes some time to use the advanced features in the tool. It took me some time to master the report building from scratch.
  • People who know Excel love this product. People who are not familiar with Excel find it difficult.
  • The user experience can be improved. The tool can be made more intuitive.
We use Vena Solutions to consolidate financial statements from various subsidiaries. We use it for variance analysis, budgeting, forecasting. We developed some dashboards, as our CFO likes visuals. We are using to track the tasks by financials controllers to meet the deadlines.
Read this authenticated review
Lori Lambert | TrustRadius Reviewer
March 20, 2017

Harness the Power and Flexibility of Excel with a Vena Solutions Database and Workflows!

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Vena Solutions for budgeting, forecasting and salary increase planning. Vena Solutions allows us manage our spreadsheet distribution and data collection from all departments across our university. We collect department data for each of these processes and save the data into the Vena Solutions database. Data is automatically consolidated and aggregated per our requirements for use in advanced management reports as well as ad hoc reports.
  • Vena's strength is allowing the use of all features and functionality in Excel while also providing workflow and approval processes that can be managed on a department by department basis.
  • Having the database with saved data behind the Excel interface allow for consolidation of data and reporting at multiple organizational levels, along with providing the flexibility needed to build reports exactly as needed for each financial process.
  • Intuitive and powerful workflow functionality allows us to pre-determine our distribution cycle for spreadsheets including managing the review process, which also captures full auditing. As administrators, we can view the status of each department's work and the point at which each is in the workflow using the easily navigated management tools.
  • Version and change control of spreadsheets allows us to track changes made to spreadsheets from one year to the next as new requirements surface.
  • End users who have been accustomed to using Excel for budgeting and other processes required very little training, and we were able to enhance our previous blank Excel templates with pre-filled data for actuals, prior year budgets and personnel budgets. This allows department managers to focus on creating an accurate budget rather than spending time doing data entry and off-system analysis (which they often don't do). Users commented that implementing Vena was the best implementation we've had.
  • Customer support is great and very responsive! The training consultants are also very knowledgeable in Excel functions and provide ways to enhance templates and reporting by providing a combination of Vena and Excel solutions.
  • Vena Solutions provides users with extended Excel functionality and flexibility, especially for spreadsheet-driven processes. Vena can store a wide variety of data, allowing us to use Vena for financial processes, reporting, operations planning and human resource planning.
  • When first learning to use Vena, it may seem that reports can't be created as easily as in other solutions - there's no drag and drop from a selection of fields. However, once the Vena tool is learned, reporting becomes much easier.
  • The flexibility of Vena may also be a downside for some administrators. A vision for what a template or report should look like and do is needed as building a template or report starts with a blank Excel workbook.
  • Vena isn't the flashiest budgeting tool available, but we believe the flexible functionality outweighs the looks of other software.
Vena Solutions is well suited for any business process that can use Excel spreadsheets for data collection and data aggregation and for which approval or process flow workflows are desired. Vena Solutions is also ideal as a CPM product that combines data collection, version controls, reporting capabilities and security controls.
Read Lori Lambert's full review
George Taylor | TrustRadius Reviewer
January 16, 2017

Vena Solutions in Animation Accounting

Score 10 out of 10
Vetted Review
Verified User
Review Source
We utilize Vena for both budgeting/tracking production expenses and managing our monthly financials. Consolidation of several dozen companies is a daunting task (one that we previously attempted only on an annual basis) but Vena enables us to carry out on a timely basis each month. This in turn gets more reliable data to senior management within a short enough time frame that it remains relevant to the current situation of the company.
We also use it to track employee costs in our technical and corporate departments, and currently have a long list of additional endeavors we want to use it to expand into for projections and project capacity management.
  • Monthly financials - Vena accurately ingests numeric totals which you can arrange through templates to quickly process financials in a consistent and timely manner. Through use of scenarios, we can use the same template and data to close out a period or calculate our tax return for the year.
  • Budgeting - The ability to calculate reams of data and move it between templates is hugely beneficial. We can version up, adjust a few line items in a template and then flow those changes back to production within minutes. This helps avoid different versions on separate machines or an employee leaving a file open and locking it for everyone else.
  • Cost reporting - By segmenting division costs in a periodic basis, we can give our managers a living snapshot of a production, allowing them to see the biweekly costs of each employee and budgeted line item.
  • Loading speed - the cloud may be the future, but our #1 user complaint is the time it takes to refresh and get to work.
  • Learning curve - a specialist is certainly recommended to setup and administer Vena, and my colleagues run all requests for changes through me rather than have the confidence and ease to dive it and fix things personally.
  • Tethered by plugin - many users find it cumbersome to use both a web login and configure an excel add-in just to access a report.
Vena is well suited to situations which can be linked to repeating sources such as specific accounts/divisions and financials. Any scenario where you want to combine dozens of numbers and then flow the results into another sheet and then compare across time is very useful, such as cash flows or expense reporting.

It becomes less advantageous when dealing with individuals, or trying to track their data across projects. Modifying templates over time and retaining backwards compatibility can become difficult as well, but that is more a matter of complexity than a failing of the application. Trying to combine entities with radically different charts of accounts would be more time consuming but not impossible.
Read George Taylor's full review
Devendra Kalwani, CPA, CA | TrustRadius Reviewer
January 03, 2017

Vena Solutions Review

Score 7 out of 10
Vetted Review
Verified User
Review Source
Our organization uses Vena solutions for the following:

1) Monthly account reconciliations across all our subsidiaries and assets
2) Consolidation, statement of cash flows and other adhoc reporting requirements.
3) Reporting on standalone financial statements for all our entities
  • Dashboard provides a good summary of report status as well as prompting reviewers when individual reports are ready
  • User-friendly as it integrates Excel in providing database solutions.
  • Workflow tool is extremely helpful, identifying key points in a particular report process
  • Data loading and refreshing - Ultimately Vena was implemented to create capacity for team members performing monthly reconciliations. While the preparation time has gone down with the implementation of Vena, it has been below expectations.
  • Template building - Designing and building a template is time consuming and furthermore advanced reporting requirements will require consultant help.
  • Data issues - there have been months where we have encountered data issues whereby Vena would not pull data from our data warehouse correctly.
Vena integrates workflow and reporting very well. Where it falls short is speed and data integrity (although we have encountered significant improvement [in the] last couple of months).
Read Devendra Kalwani, CPA, CA's full review
Jeff Deane | TrustRadius Reviewer
November 30, 2016

Great product and excellent customer service.

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Vena for budget and forecasting. Vena helps us manage our spreadsheet distribution and data collection. It takes our data and puts it into a database that automatically consolidates and aggregates our data, where we could build advanced management reports as well as easily create ad hoc reports.
  • Vena’s strengths are its power in consolidation and aggregation of data. Vena provides instant visibility into data from multiple business dimension levels.
  • Intuitive and powerful workflow allows us to pre-determine our distribution cycle for spreadsheets including managing the review process, which also captures full auditing.
  • Version and change control of spreadsheets help us feel like we know where all of our spreadsheets are at all times.
  • We have a significant amount of data in our database. In order to increase speed in some of our Excel templates we had to sacrifice a few of our initial requirements.
  • Reaching out to customers to share new features.
Vena is well suited for any business process that uses Excel spreadsheets for data collection and aggregation.
Read Jeff Deane's full review
Michelle Canada, CPA | TrustRadius Reviewer
September 15, 2016

Great cloud based software

Score 9 out of 10
Vetted Review
Verified User
Review Source
It is being used by our accounting and finance departments to manage our entire monthly and quarterly closing process. All our closing schedules are included in Vena Solutions and are submitted and reviewed. It helps us with our SOX controls by showing proof that the schedules have been reviewed.
  • Vena allows you to pull in general ledger data into Excel. This has allowed us to automate many of our spreadsheets and speed up the closing process.
  • The version control is another great feature. It allows you to see what has changed since the last time a spreadsheet was saved.
  • The process audit is great feature. It is used as a SOX control to prove that schedules have been reviewed by the appropriate individual.
  • The speed could be improved. Since we have so many schedules in the workflow it can run slowly at times.
The best use for Vena Solutions is using the mapping function to pull in general ledger data. It has helped us saved time, by not having to run separate reports and key in data.
Read Michelle Canada, CPA's full review
Jay Scheumack | TrustRadius Reviewer
March 23, 2016

Great Product and Amazing Customer Service!!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Vena Solutions is being used agency wide as our primary budgeting tool. Utilizing Vena we have replaced a 24 spreadsheet inter-linked internally developed budget tool. Previously we were unable to allow many users to update our spreadsheets because of the danger of breaking the links but with Vena we are able to include multiple managers in the budget process and allow them to work directly with their people to develop a budget that more accurately reflects reality. To be honest we completed our first budget in Vena this past August. Due to unanticipated funding changes we were notified of in September we had to completely rework the budget in less than a month and were able to do so. Vena allows us to shorten our budget process significantly and produce more dependable and accurate results. We are required to submit budgets with the many funding requests we prepare...mainly to government agencies. Vena will allow us to more easily create these budgets based on our overall agency budget. By using scenarios we can use existing budget data to produce these new and updated funding budgets.
  • Maintains integrity of front end spreadsheets because inter-linking the various templates is done outside of Excel.
  • Allows us to import data directly from our accounting and payroll system to populate templates.
  • Provides flexibility through multiple scenarios ....allowing several versions of a budget to exist concurrently.
  • Template control allows us to engage multiple managers in the process, each working on their own program template without impacting the work of other managers.
  • Sometimes developers do not get a clear idea of what is needed before attempting to design a solution.
  • Because the system design allows for such flexibility it can be difficult for support to fully understand what my issue is. No two budgets are designed exactly alike so it is understandable that troubleshooting can be a challenge. Having said that...I have never encountered a more supportive and helpful support staff.
  • In my opinion the process of rolling forward budget versions and scenarios is not intuitive and seems cumbersome.
Vena Solutions is well suited for multi-faceted and complicated budgets. We love the fact that we can perform the same complex calculations required for our budgeting process in a familiar format/syntax (Excel) but not suffer linkage issues we had grown accustomed to in the pre-Vena days.
Read Jay Scheumack's full review
Teymur Mammadov, CPA, CA, FCCA (UK) | TrustRadius Reviewer
March 15, 2016

A fantastic and cost-effective way to fill in the gaps left by some other large software packages!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Although we are aware of Vena Solutions' capability to support forecasting and budgeting processes (and are looking into that, too), we use the software primarily as month-end close and consolidation tool, as well as for process flow and access control. This software has substituted a series of stand-alone and disjointed Excel files and currently allows us to streamline month-end financial close activities; have "one source of truth" with no risks of corrupt links between files or multiple inconsistent versions. Implementing Vena Solutions software has allowed us to shorten month-end close activities by about 50% - we use it extensively to easily produce comparative financial statements, different management reports, dashboards and even automated sub-ledger reconciliations. It does not substitute, but perfectly complements our core ERP system (primary book of record) and fills in the gaps related to subsequent reporting and analysis in a very cost-effective manner. The ease of use and seamless transition from Excel allows for an in-house template and process development subsequent to initial implementation.
  • Segregation of data from templates (where Excel files serve as a front-end for accessing data saved into a separate database) allows us to implement proper segregation of duties and reuse the same set of data and the same data model in different templates that may refer to the same numbers. Retaining the familiar Excel interface, Vena Solutions software does not impair, but enhances common Excel functionalities to incorporate additional layers of control, traceability and workflow control. We were even able to incorporate Excel VBA/macros that work in synergy with core Vena Solutions functions to take template automation to the next level.
  • Audit Trail is an excellent feature that allows us to compare current and all prior versions of the same templates and highlight changes at the click of a button - in a dynamic environment, where things change and get revised often, this is an immensely useful function to properly keep track of such changes - especially in complex multi-worksheet models with a large number of variables to track.
  • Equally useful is the drag-and-drop WYSIWYG process designer that we use to quickly set up new tasks and activities, branch existing ones and incorporate review activities directly into the process flow, to be controlled automatically behind the scenes. This allows us to always keep track of current status of all activities within the process, make sure that only approved changes go through into the final version of all reports and even provide a good platform to transfer knowledge about a specific task/activity to any new members of the team (given that you can incorporate additional comments and extra attachments - such as process narratives - directly into tasks).
  • We like the flexibility behind the data model. The ability to define your own dimensions (and add future dimensions to the data model as you go along) allows you to adapt the software to your needs, regardless of whether you are looking to use it for working with financial or non-financial measures, or whether you want to work with actual, budgeted or any other information. The hierarchical organization of the data model (which consolidates children items into parent items automatically) allows us to maintain the familiar Financial Statement (and other) roll-ups directly within Vena - all this is an added bonus in making sure all numbers integrate and tie properly.
  • Option to indicate to a manager when a template is open by contributor (or block save for a manager, if a contributor has it open). Currently, simultaneous access by two contributors is restricted, because until the file is checked in by one, edits by the other will not be possible. However, a manager can open the template that is already open by a contributor and modify it at the same time. This may lead to save conflicts and unwanted changes. It would be nice to have some sort of an indication for a manager that the template is being used by a contributor (and vice versa, too – that way a contributor would know to contact the manager if he/she is opening the template that is currently open in the manager’s view)
  • Option to add/remove users to processes that are currently active, to grant on-the-fly permission to view current tasks – i.e., it would be nice to modify access irrespective of the process status. My understanding is that this option has already been implemented in later Cloud versions (our company is currently using OnSite version).
  • When tracing mapped data – ability to focus on the source cell, as opposed to just highlighting it (currently the cell is being highlighted, but it can be in any of the worksheets in the source file and needs to be manually located).
Budgeting/forecasting/planning is an obvious candidate (once again, given the ability to maintain multiple versions of the same template, which is useful in forecasting). We successfully use it for reporting (closing and consolidating) on actual financial numbers and to produce summary flash/dashboard reports. It might be not appropriate as (but then again, it is not intended to be) a substitute for transaction-processing systems with large volumes of data, although such large volumes of data, to my understanding, can be connected to and summarized by Vena
Read Teymur Mammadov, CPA, CA, FCCA (UK)'s full review
Megan Bladen-Blinkoff | TrustRadius Reviewer
March 21, 2016

Work Life Easier

Score 10 out of 10
Vetted Review
Verified User
Review Source
Vena Solutions helps us manage our business. We use Vena for our department budget and monthly outlooks. Vena Solutions is an effective tool which manages the workflow process, updates, collection and storage of changing data. Vena Solutions gives us the advantages of database storage (including easy aggregation) while utilizing the analytical and data visualization power of Excel. Our time turn around for gathering data request from upper management and other departments has improved greatly with the use of Vena.
  • The workflow process simplifies our review and approval process. It also allows one to see immediately at what point the process is and if there is a particular task that is holding up the completion of the process.
  • Visualizations by graphs, charts, tables are easy to set up and maintain while easily keeping the integrity of the data. In addition, using ETL functionality, we can layer on more daily data for the last decade for historical series in graphs.
  • We can easily have an aggregation view or a drill down view which allows for robust reporting.
  • The process is easy to maintain including version control and dynamic updates. Once set up it is not labor intensive.
  • While the customer support is excellent, the only way to contact support is via email or text messages. I would prefer to have a direct line where someone is immediately available. (Unfortunately, the truth is that immediately reaching a support person is become less and less the norm.)
  • It would be helpful if there were hyperlinks to the documentation while in Vena.
  • Another nice feature would be to have more robust functionality with due dates and email notices.
Vena Solutions is well suited for those companies or departments that rely heavily on Excel.
Read Megan Bladen-Blinkoff's full review
Carrie Self, CPA | TrustRadius Reviewer
November 20, 2015

If you can think it in Excel - Vena can make it happen!

Score 10 out of 10
Vetted Review
Verified User
Review Source
We currently use Vena Solutions for our budgeting process for 270 restaurants spread across 4 legal entities. We will begin rolling out reporting processes to executive and other end users soon, but are currently only using them inside our department.
  • Vena Solutions is super flexible - if you can think it in Excel, you can make it happen in Vena.
  • Having an online process and file management system is excellent for keeping everything together and organized. We have cut down the amount of emails back and forth tremendously.
  • User acceptance has been extremely high as people are working in a tool they are familiar with.
  • Support is very responsive and the company seems to truly care about the customer experience.
  • As great as the tool is, there is very little "out-of-the-box" functionality - you and your consultant will have to build everything from scratch (We took an assisted implementation approach, so we did much more of the set up than some companies do from my understanding). The process is quick and helps you understand the product, but it takes a some thinking.
  • The company is relatively small and a relatively new player in the market, so the user community and support forums are not very useful.
  • The developers are constantly updating the product, but the company doesn't do a great job of communicating new features to the users.
  • I would really like to see some more built in calculation features (spread methods and such) without having to build long excel formulas.
Vena Solutions is extremely well suited in instances that necessitate the input of large amounts of information at once. I highly recommend that the implementation team and administrative users be advanced Excel users.
Read Carrie Self, CPA's full review
David Robbins, CPA | TrustRadius Reviewer
March 10, 2016

Friendly, Intelligent, and Prompt customer service

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Vena Solutions as our tool for quarterly global financial data collection from our regional hubs. It coordinates the orderly collection and review of data from our hundreds of subsidiaries in order to prepare consolidated reports which enable us to file our SEC reports in a timely and organized manner.
  • The ability to view the consolidated status of a large amount of data collected at a moments notice.
  • Ability to enforce a workflow, ensuring documentation of review.
  • A centralized consolidated database for all of our disaggregated and consolidated data submissions.
  • We are awaiting our implementation of Vena Solutions' latest version of its software solution which addresses our primary functionality of 'requests' and 'wants'.
Vena Solutions is well suited for any business process that uses spreadsheets for data collection and aggregation.
Read David Robbins, CPA's full review
Dominic Di Bernardo | TrustRadius Reviewer
February 12, 2016

Vena - Best Bang for your buck. You get a Ferrari for the price of a Honda!

Score 10 out of 10
Vetted Review
Verified User
Review Source
We are currently using Vena to Budget, Forecast, and Report. Vena is being used across our organization Domestically, with plans to roll it out to our international team during Q1 of 2016.

Vena has been helped us create a single source of truth and achieve rapid adoption due to the nature of it being a technology stack that sits on top of Excel, a platform that everyone in our organization is familiar with and comfortable using.

The ability to both send and retrieve information through report and input templates has really help streamline and automate many of our core FP&A processes.

  • The ability to to audit changes is a huge help when analyzing multiple iterations of budget submissions. They have built in a really robust audit tool compared to many of the other vendors out there.
  • The workflow and security is absolutely critical. Having the ability to create one template to leverage across 35 different profit centers based on role based security/access is amazing. The last thing you want to do is maintain 35 different templates to ensure people only get access to the data that is applicable to them. Vena solved this with role based security.
  • Instant Aggregation. It is very useful to be able to run reports with instant aggregation to see how things are shaping up during a budget or forecast cycle.
  • I believe it has all the necessities, but of course there are always going to be items on the wishlist. One of the items I recently submitted as a enhancement request is the ability to perform dynamic expansion with nested rows and nested columns.
  • I would also like to see the ability to created automated report blocks.
  • The cascade feature is great for blowing out a report that leverages the same format for has multiple views (i.e. different Business Units or Profit Centers). However, I wish you could cascade on multiple tabs at once instead of one at a time.
We got exactly what we thought and were told we were getting. The best part is that the Vena team is in constant and never ending improvement mode.
Read Dominic Di Bernardo's full review
Anonymous | TrustRadius Reviewer
December 22, 2016

Vena Solutions

Score 6 out of 10
Vetted Review
Verified User
Review Source
We use Vena for budget, forecasting and long-range planning. Vena helps us manage our spreadsheet distribution and data collection. It takes our data and puts it into a database that automatically consolidates and aggregates our data. We also use Vena to track personnel costs and for forecast timing of new hires.
  • Vena’s strengths are its power in consolidation and aggregation of data. Vena provides instant visibility into data from multiple business dimension levels.
  • The workflow functionality allows us to easily manage the ownership and distribution of the spreadsheets supporting our process. The tool is intuitive and the GUI is great.
  • Version and change control of spreadsheets.
  • The tool lacks a true personnel module. We needed to build and rely on complex spreadsheets to capture all calculations and run scripts to cost out our actions. It was time-consuming to build, lacks predictable accuracy and is less flexible than I would have preferred.
  • Vena needs a more mature implementation process and approach. A more formal process and more project management support would be beneficial.
  • The solution build relies too heavily on future consultant involvement to make changes or leverage functionality.
Vena is a good choice if you are a small company who wants to automate your Excel spreadsheets and can benefit from a workflow process. Vena is not a solution if you want to track employee level detail to forecast and budget employee costs.
Read this authenticated review
Anonymous | TrustRadius Reviewer
March 20, 2017

The Vena Queen tells all!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Vena is being used to aggregate data from business lines to be used in reporting to regulators. It is being managed by the reporting department with end users across the company. It systematically aggregates data previously manually aggregated and provides a vehicle for analysis as well as workflow, approval tracking, audit trails and controls.
  • As it uses Excel, it is easy for end users and allows you to use all the functionality Excel has to offer - but makes it better.
  • It provides controls and auditability of data collection.
  • With Vena, users stay in Excel when creating templates and reports. This means that all the flexibility that our employees relied on Excel for in the past is available through Vena, with the added benefit of version control, configurable security settings, and audit trails to enhance accountability.
  • We specifically use the onsite version of Vena and most, if not all of our challenges have been corrected in the VenaCloud.
  • Due to the size of our organization, significant time is spent on workflow maintenance as team members move departments.
Vena is specifically good in situations where a lot of data needs to be collected from various members across an organization and controls and auditability are needed.
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 29, 2016

Using Vena to gather data for FR-14A and create .xml for regulators

Score 10 out of 10
Vetted Review
Verified User
Review Source
Vena is used to gather the data for the FR-14A submission to the Fed. Vena collects the data from the various groups that model the data and creates the xml file for submission to the regulator. I have used Vena in this capacity at two CCAR banks.
  • Vena is excellent at tracking the inputs into the 14A. Vena allows for flexible workstreams to track submissions and approvals. It is very easy to see the status of each input and it is very easy to adjust the process as needed.
  • Vena was developed to be a solution for use within finance with minimal IT support required. A finance analyst can create workflows, add or remove approvers, update data architecture, and roll forward quarterly processes. No IT tickets!
  • Vena integrates seamlessly with Excel. The integration and setup is a lot of work at first but once it is done maintenance is easy.
  • Vena is offered (last I heard) as a stand alone product running on a local server or as a cloud based solution. I've used both and the cloud based version is much better! IT Security doesn't like cloud storage of company data however. It would be nice if the locally installed version had the same updates and features as the cloud version.
  • Updates to the cloud based solution are sometimes a surprise. We never had an issue with an update causing a problem but we were always nervous that the day before our submission was due there would be an update with unintended consequences. I wish Vena had a more formal update process, including the ability of customers to beta test before the update.
Vena is particularly well suited for processes where many small data inputs are consolidated into one large data set. Especially if the sub-processes use Excel to generate the input data. Vena does a great job of gathering all the inputs in a controlled and traceable manner and preparing aggregate reports. CCAR 14-A generation and quarterly 10Q/10K data aggregation are two examples of processes where Vena would do well.
Read this authenticated review
Anonymous | TrustRadius Reviewer
April 11, 2016

Fantastic cost effective product that delivers.

Score 10 out of 10
Vetted Review
Verified User
Review Source

We use Vena Solutions for budgeting, forecasting and reporting of our G&A across our corporate departments.

Vena is currently helping us create a one stop shop of all things related to G&A. We envision Vena being used as the primary tool helping users better analyze their G&A, and assisting in consolidation and aggregation for our reporting purposes.

Additionally, with Vena it is incredibly easy to create both detailed deep dive reports and high level summary reports. The best of both worlds.

  • Vena’s strengths are its power in consolidation and aggregation of data. Vena provides instant visibility into data from multiple business dimension levels.
  • Allowing both in depth and high level summary ad-hoc reports to be built easily.
  • Intuitive and powerful workflow allows us to pre-determine our distribution cycle for spreadsheets including managing the review process, which also captures full auditing.
  • Quick and responsive customer service when issues arise.
  • No available prebuilt templates when building a new report, as each new report/template begins as an empty Excel sheet. Vena does offer an assisted approach where a consultant will work with you to build what you need.
Vena Solutions is well suited for any business process that uses Excel spreadsheets for data collection and aggregation.
Read this authenticated review
Anonymous | TrustRadius Reviewer
November 20, 2015

Vena Solutions - A Solution to our Company's Budgeting and Reporting Problems!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Vena Solutions is being used by our company to help with our annual budgeting process and also our monthly financial reports. The product is primarily used by our finance team, but we publish financial reports that are used by our managers company-wide. Our current ERP is not very functional and we were manually inputting data into Excel spreadsheets for reporting. Additionally, our annual budgeting process was very complex as we own multiple entities and trying to consolidate all the budgets was very tedious and time-consuming.
  • Vena Solutions is able to connect directly to our ERP giving us nearly unlimited potential for customized reports. It has given us a level of functionality we didn't know was possible. We have the ability to manipulate data and reports like we never have before!
  • Prior to using Vena Solutions we spent an entire day each month converting spreadsheets to PDFs and emailing them out to each of our 40 managers. With Vena Solutions this process is completely eliminated. The specific department that each manager needs to view is available for them to view when they log into their Vena Solutions account. No more converting PDFs and sending emails! Additionally, the drill down feature is amazing. Our managers can look at their reports and drill down on a number on their P&L. This will automatically pull a report of what items were allocated to that particular account. If managers had questions prior to Vena Solutions I would have to look up the information manually in our ERP and get back with them. Now the managers can do it themselves!
  • Our annual budgeting process has improved drastically. We are able to provide input templates to our managers for them to enter expense and sales projection data. The information is then sent to the CFO for review and then on to our profit budget.
  • We have only been working with Vena Solutions for a few months but we are very impressed with their customer service and have no complaints or suggestions at this time!
I think Vena Solutions works particularly well with ERPs that offer limited functionality and reporting. This product also works extremely well for the budgeting process.
Read this authenticated review

Feature Scorecard Summary

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

About Vena Solutions

Vena Solutions says it offers intuitive budgeting, planning and forecasting software for medium to large sized organizations. Vena says it embraces Microsoft Excel and turns it into an enterprise cloud solution with a centralized database, sophisticated workflow, powerful reporting and advanced analytics. Unlike traditional software that replaces Excel with rigid, hard-to-use applications with a steep learning curve, Vena promises an easier way for finance and sales professionals to get trusted numbers and insights – fast.

Over 500 companies use Vena to get trusted insights that drive faster, smarter business decisions.

Vena Solutions Features

Budgeting, Planning, and Forecasting Features
Has featureLong-term financial planning
Has featureFinancial budgeting
Has featureForecasting
Has featureScenario modeling
Has featureManagement reporting
Consolidation and Close Features
Has featureFinancial data consolidation
Has featureJournal entries and reports
Has featureMulti-currency management
Has featureIntercompany Eliminations
Has featureMinority Ownership
Has featureLocal and consolidated reporting
Has featureDetailed Audit Trails
FInancial Reporting and Compliance Features
Has featureFinancial Statement Reporting
Has featureManagement Reporting
Has featureExcel-based Reporting
Has featureAutomated board and financial reporting
Has featureXBRL support for regulatory filing
Analytics Features
Has featurePersonalized dashboards
Has featureColor-coded scorecards
Has featureKPIs
Has featureCost and profitability analysis
Has featureKey Performance Indicator setting
Has featureBenchmarking with external data
Integration Features
Has featureFlat file integration
Has featureExcel data integration
Has featureDirect links to 3rd-party data sources
BI Standard Reporting Features
Does not have featurePixel Perfect reports
Has featureCustomizable dashboards
Has featureReport Formatting Templates
Ad-hoc Reporting Features
Has featureDrill-down analysis
Has featureFormatting capabilities
Has featurePredictive modeling
Does not have featureIntegration with R or other statistical packages
Has featureReport sharing and collaboration
Report Output and Scheduling Features
Does not have featurePublish to Web
Has featurePublish to PDF
Has featureReport Versioning
Has featureReport Delivery Scheduling
Data Discovery and Visualization Features
Has featurePre-built visualization formats (heatmaps, scatter plots etc.)
Does not have featureLocation Analytics / Geographic Visualization
Has featurePredictive Analytics
Does not have featureSupport for Machine Learning models
Does not have featurePattern Recognition and Data Mining
Does not have featureIntegration with R or other statistical packages
Access Control and Security Features
Has featureMulti-User Support (named login)
Has featureRole-Based Security Model
Has featureMultiple Access Permission Levels (Create, Read, Delete)
Has featureReport-Level Access Control
Does not have featureTable-Level Access Control (BI-layer)
Does not have featureField-Level Access Control (BI-layer)
Has featureSingle Sign-On (SSO)
Mobile Capabilities Features
Has featureResponsive Design for Web Access
Does not have featureDedicated iOS Application
Does not have featureDedicated Android Application
Has featureDashboard / Report / Visualization Interactivity on Mobile
Additional Features
Has featureEmbrace all the Power and Flexibility of Microsoft Excel
Has featureDrive Powerful CPM Enterprise Functionality
Has featurePowerful Workflow, Audit and Reporting
Has featureIn-memory Computing (IMC) Technology
Has featureMobile & Tablet Accessibility

Vena Solutions Screenshots

Vena Solutions Integrations

Microsoft Dynamics, Oracle, SAP, Sage, Salesforce, Quickbooks, Deltek, FinancialForce

Vena Solutions Competitors


  • Does not have featureFree Trial Available?No
  • Does not have featureFree or Freemium Version Available?No
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?Optional

Vena Solutions Customer Size Distribution

Small Businesses (1-50 employees)
Mid-Size Companies (51-500 employees)
Enterprises (> 500 employees)

Vena Solutions Support Options

 Free VersionPaid Version
Live Chat
Social Media
Video Tutorials / Webinar
Customer Support Portal

Vena Solutions Technical Details

Deployment Types:SaaS
Operating Systems: Unspecified
Mobile Application:You don't need to download an app or change a setting to use Vena on your mobile device: just open your browser, go to Vena (, and log in as you normally do. The Contributor interface is fully responsive, so it can adjust to any size screen, regardless of the type of device you have.
Supported Countries:United States of America, Canada, United Kingdom, Australia, South Africa, Europe
Supported Languages: Vena supports any localization capabilities already native within Excel. Vena Cloud supports English, Spanish, and French. If a specific language is required please don’t hesitate to ask.