Vena provides flexibility and efficiency to focus on what actually matters
Updated September 20, 2024

Vena provides flexibility and efficiency to focus on what actually matters

Brendan Eger | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Vena

We use Vena to budget our operational and grant expenses, as well as process our annual compensation planning as part of our summer performance review cycle. We've also used Vena to plan our capital expense budgets and our detailed medical item and equipment procurement budget in the past. We have 200 users across 10 countries contributing to specific portions of the organizational budget. Vena's Excel interface allowed our users to adopt the platform quickly as we were able to build templates that mirrored our existing Excel templates, while also giving them the flexibility to use other Excel functionality that they're familiar with (i.e. using formulas to populate cells). From the administrative side of the platform, we were able to learn how to build and manage data models, templates and user permissions in multiple ways to suit the needs of our specific use cases. The ability to export and upload transactional data, hierarchies, users and user permissions makes things easy to manage as well. Vena also has robust system audit features that allow you to see what information was saved, by who, and when, making it easier to troubleshoot any issues that come up, particularly when multiple users are collaborating on the same data. The platform also allows you to see snapshots of what the data looked like down to 5 minute increments, which we've used a few times to restore data that was mistakenly overwritten in bulk - navigate to a date in the past, add some query language to narrow your search, export the data to confirm it's what you want and then re-upload it to get back to a good starting point. Vena's real time consolidation has also been a major win for us as we previously only updated our budgets once per month because the consolidation process was manual and very tedious. Since we started with Vena, our budgets are consolidated immediately, and we're able to automatically push that data to our data warehouse to be used for broader reporting. What used to be a once every 30 day process to update the organizational budget is now an automated process that happens each day - a user can enter a new budget line today and see it in our reports a day later. While we haven't yet pushed our accounting system's actual data into Vena yet, we see that as an opportunity in the future to allow users to use that information to immediately update their annual forecasts throughout the year. We also lean heavily on our data warehouse to build our broader reports, but are excited to explore Vena's Power BI embedded feature as it matures and once we are pushing accounting data into the platform. Beyond the technical aspects of Vena's platform providing a lot of flexibility and functionality, they've built a customer community that allows customers across different industries to discuss best practices and new ideas, and have built a steady stream of webinars with industry experts.

Pros

  • Flexibility - design the data model, templates, and permissions your organization needs
  • Usability - the Vena web portal is clean and easy to navigate, checking files in and out is straight forward, and users have adopted templates quickly
  • Community - from training, knowledge base, discussion boards, webinars, and repeating Customer Success calls, Vena stays in touch with customers regularly and uses feedback to improve the platform and partnership

Cons

  • Macros to Product features - some customers may need to build VBA macros within their templates to supplement specific actions within a template, though Vena actively reaches out to understand those use cases and considers adding those most common as product features
  • Integrations - Vena has been building native integrations to major systems over the past several years, but my team would have preferred an option to more simply connect to a SQL database and define all of the mapping ourselves (Vena API's were just announced so we might not be far away, but as yet have not been able to implement this type of integration)
  • Workflows - it might just be that my organization doesn't like to adhere to formal workflows processes, but we have yet to adopt them within Vena because the user's changes are committed to the database before approval and we don't want unapproved changes flowing into our data warehouse. If we could easily have unapproved data tagged in a way to keep it filtered out, that would make workflows more enticing
  • Our FP&A team spends far more time doing actual analysis rather than logistical cleanup or consolidation of data
  • Our budget data pipeline process for reports went from a monthly manual process to a daily automated process
  • Vena has set us up to be able to create multi-year budgets which would have been extremely tedious and we likely wouldn't have had the capacity to pursue if we had continued with our pre-Vena budgeting methods, which were focused just on annual planning
Vena quickly understood our needs and after explaining one of our biggest challenges (consolidating a newly awarded grant into our operational budgets), was able to create a mockup of the process and demo it for us within a couple of weeks. They also allowed us to test the platform from various locations where we work (US, Sierra Leone, Malawi, etc.) and speak with client references before we signed a contract. During implementation, we asked to speak to client references that had worked with our assigned consultant as we wanted to build a coaching relationship so that we could have full ownership of the platform after go-live. That consultant honored that desire and was extremely helpful in getting us to learn key functionality of the platform, so much so that 3 months after go-live, we built another template completely independently. Beyond implementation, there was a misunderstanding of the terms of our contract related to the purchase of additional licenses which would have locked us into an additional payment in our second year, but after discussing our misunderstanding, Vena accommodated us without the extra charge - this showed us that they weren't a company that was trying to nickle and dime us.
One of the major benefits of Vena has been the ability to flexibly make changes across a wide range of users, time zones, and types of input, while also still allowing us to see instantly what is changing. We've had insights into the data and been able to collaborate with our budget and organizational leaders to discuss the impacts of certain activities, make edits within templates as necessary, and then move on to the next pressing topic. We've also shifted to a multi-year view which allows our executive leadership to better plan for the future, as they have more insights into when grant funding is ending and which core activities those grants are supporting.
We evaluated several products over a few years and were comparing everything to our existing Excel templates and manual processes. We didn't pull the trigger on any of the others because it didn't feel like it was worth the investment, both funding and organizational change, to adopt a platform that didn't provide us the flexibility and time saved, which we've found with Vena. Other systems were good, but not good enough to get us over the line to commit to purchasing and implementation. Vena demonstrated an ability to understand our needs, provide a flexible platform and partner with us rather than just sell us something.

Do you think Vena delivers good value for the price?

Yes

Are you happy with Vena's feature set?

Yes

Did Vena live up to sales and marketing promises?

Yes

Did implementation of Vena go as expected?

Yes

Would you buy Vena again?

Yes

Vena is great for organizations that are comfortable using Excel and require lots of flexibility as it allows you to design and build your templates in exactly the way that you need. It's also a good match for organizations that have disparate users contributing simultaneously because it's permissions allow for everyone to work in a standard template while only being given access to edit the data for which they're responsible. If you have a team that has internal capacity to manage your systems, Vena as a platform allows you to expand beyond your initial implementation independently without needing to go back to a consultant to make an adjustment or start a new project.

Vena Feature Ratings

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

Vena Solutions Attributes

Vena's support staff are quick to respond and knowledgeable. They also are sure to provide resources by sharing links to their knowledge base articles that are most relevant to the question you raised. They've also build a customer portal where customers can connect to discuss best practices across industries so there's a community of informal support in addition to the more formal support team.
Personally, I'd give it a 10, but I know that some users struggle with the need to install an Excel add-in, which isn't usable on Macs. Vena is pushing more and more to develop and expand Excel online functionality, which is a great way to resolve these issues. They're making steady progress each quarter, rolling out new Excel online features and improving usability, but we aren't quite ready to make the jump yet.

Using Vena

200 - Our users include a lot of Finance users, but also many non-Finance users, with representation from our executive leadership team, HR team, and our program/department managers. The Finance team shepherds others through planning processes and completing their templates, but the input is often done by those who's primary function is not finance related. With that said, adoption has been pretty smooth and those users have responded well to being able to own a portion of the budgeting process.
10 - We have 2 admin users who manage permissions and template updates, and then 8 FP&A team members that make some data model updates (adding new codes within a set structure), but who mostly spend their time supporting end users to login, check out files and complete their inputs. Support is heaviest during our annual planning cycle when the most simultaneous users are in the platform and there are clear deadlines to complete inputs, but there's always opportunities to orient new staff who are hired throughout the year.
  • Grant Budgeting
  • Operational Budgeting (flexible funding not tied to grants)
  • Compensation Planning (related to summer performance cycles)
  • We piloted a use case that collected mental health patient enrollment in Haiti, but ultimately did not fully implement because it strategically made more sense to build that into an Electronic Medical Record system - the goal was achieved though in demonstrating that Vena didn't have to be used just for Finance purposes
  • Forecasting is our next big focus area so that end users can utilize prior period actuals to re-budget future periods within the same template
  • We're considering expanding our user base to an even lower level to democratize the process budget input process more
Vena has been a huge win for us as an organization, as it vastly improved our budgeting process by removing manual consolidation that was incredibly time consuming, and it allows us to see a multi-year view of our organizational budget across all of our funding sources. We've seen Vena's platform grow over the years and we've not yet fully adopted some of them so it feels like there's still potential to get even more value out of the platform.

Evaluating Vena and Competitors

  • Scalability
  • Ease of Use
  • Other
Vena's ability to adapt to our needs and ways of working were critical in convincing us to adopt it. Other budget systems felt like they'd require more changes to our processes and data capture, as well as taking us out of Excel where most of our users were comfortable. With Vena, we were able to design the data model and templates to capture exactly what we needed, which allowed our users across the globe to more seamlessly adopt the tool.
We don't have many regrets with our process and where we landed, given that we're still using the platform 6+ years later, but I think if we re-evaluated, we would try to involve more members of our global Finance teams to weigh into the process and directly compare Vena with other platforms. Our initial evaluation was one vendor at a time over a few years to determine whether it was worth the jump from Excel based budgets, but a more direct comparison might've yielded a different result.

Vena Implementation

We requested a coaching relationship with our implementation consultant with the goal of teaching us how to build out the platform and manage it afterwards. That relationship was very productive with scheduled recurring calls to guide next steps, supported by clear knowledge base articles to refer to, and ad hoc calls as needed to address any errors. By the time of go-live, I felt confident in the templates and being able to support end users.
Yes - Phase 1 was designed to re-create our pre-Vena Excel based budgets, through a coaching relationship with a Vena implementation consultant training us on how to buildout the platform ourselves. This phase took about 3 months and launched our annual budgeting process. The next phase started a few months later and was done independently, focusing on a compensation planning template as part of our performance review cycle. The next year, we introduced a capital planning template and a procurement planning template, again built independently in house. The year after that, we built a dedicated grant budget template on our own as well. The initial implementation gave us the skillset and confidence to expand to additional use cases independently.
Change management was a small part of the implementation and was well-handled - We chose Vena in part because of the familiarity our users had with using Excel. We created training materials and held sessions to demonstrate how to login to the web portal, install the Excel Add-In, and update Excel settings for performance considerations and macros, but we did not face major issues during implementation with getting users to use the platform. We also intentionally focused on a smaller set of users in the first year and expanded in the second year so that each team had a local expert with familiarity to help guide new users.
  • Getting users to enable macros
  • Some concurrent checkout concerns at first, but resolved with education

Vena Training

The training was structured as a group training to learn the basics of creating a data model and mapping a template. While we had nearly 10 participants, I was the only actual implementer so we probably didn't actually need the training and could have just learned the initial skills from the implementation consultant. Two years later, when we hired a new team member, they completed several modules in Vena Academy (a self paced learning course) which allowed them to get up to speed on the basics with just a bit of supplemental guidance from me as our existing admin.

Configuring Vena

At it's core, Vena is a data capture tool through an Excel add-in that has endless use cases, though you'll most often see Finance related processes from their marketing and customer experiences. The configurability to design custom data models and templates, controlling permissions across the web portal and data access, as well as setting up workflows and approvals offers a wide range of customization to make the platform work how you need it to. Additional reporting features like Power BI embedded, or integration channels can expand to wider use cases of making Vena a one-stop shop acting as a data warehouse of sorts and reporting hub for wider users.
Vena as a company and the Vena Community of active customers that they facilitate offer a lot of best practices based on your industry. My biggest recommendation is to be open to taking a new approach given that a new system adoption is a good time to change things you don't like about current processes. We very intentionally created exactly the same data structure and template design of our pre-Vena Excel budget files, and only several years later begun reflecting on whether we could've spoken to peer organizations or other Vena clients to consider alternative approaches. Vena's platform allows you to configure whatever you need, but change management can be harder later.
Some - we have done small customizations to the interface - There is no customization to the user interface in the web portal other than to create tasks and workflows for specific users, which includes Task Binding to ensure that specific data is loaded from a given task even if the user has wider data permissions. Customization comes mostly in template design, which offers a lot of flexibility since the templates are built in Excel. We've built 6 input templates, 7 reports and 1 automation template (for specific data calculations) which has allowed us to collect and visualize data as appropriate for different users.
No - the product does not support adding custom code
Nothing else to add. We chose Vena because of it's ease of configuring data models and templates to meet our needs without locking us into rigid processes. We haven't had a need to configure the Vena web portal because it's simply not where users spend most of their time - they do their work in templates, which we have full control of the design.

Vena Support

ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None
I don't believe we purchased a premium support tier or that one is offered. my understanding is that Vena invests in their support team's capacity to effectively support all of their customers. Over the 6+ years we've been using Vena, every support interaction has had quick responses with knowledgeable guidance supported by knowledge base articles. The team is also quick to offer calls to make sure they understand the issue and resolve things quickly.
We recently had an issue with just one of our templates having intermittent issues loading for four users (out of 200+), where sometimes the template loads perfectly the first time, but sometimes it takes 2-4 tries to open. This felt like a real needle in a haystack type of situation as we couldn't identify a pattern. Vena support provided a series of knowledge base articles to resolve specific error messages, as well as an analysis of the template to identify how the design could be affecting the performance, but also took a deeper look at Event Viewer to see where specifically things were erroring out. This focused on a specific Microsoft DLL file, for which they provide clear instructions on replacing the file and restoring the Vena add-in files. While this was a frustrating error to resolve, Vena support pulled in multiple team members to consider various solutions and provide clear guidance and documentation for how to resolve the error.

Using Vena

ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Convenient
Feel confident using
Familiar
None
  • Audit of data saves across all users and templates
  • Versioning of data to scenarios and years
  • Data Validation in templates, soft and hard with messages
  • Entering Line Item Details to track what drives roll-ups
  • Multiple hierarchies in dimensions
  • Integration with non-pre-configured systems

Vena Reliability

We use Vena across 10 countries and 200 users who are located in a wide range of settings and internet reliability. Even with that wide implementation, the most common issue we run into is a new hire not installing the Vena add-in, which is a super quick fix. Depending on our user's location, the internet can sometimes be spotty, but that is outside of Vena's control and even in those settings, Vena might take a little longer to open a template, but it still does open and the user can complete their work. Over 5 years of using Vena, we've collectively only had 3 issues where we needed Vena support to help look at a specific issue a user was having.
Vena is seemingly always available. They plan maintenance windows well in advance and always off hours (typically over a weekend) and communicate clearly throughout maintenance about what will be affected. Over 5 years of using the product, I can only remember one time when the platform was unavailable (I believe due to an underlying server hosting issue from their provider), and they resolved the issue and had everything up and running again within 8 hours.
Everyone always wants things to be faster, but we also have seen solid performance from Vena templates opening and being usable once opened. There's probably a bit of a gray area here as this ultimately is driven by how complex your template is and how much data you're trying to load. If you need to see a ton of detail in a template that has to process a lot of calculations, then you might run into some issues. In that case, Vena has features like Template Automation which can help you separate out some of those heavy calculations into a behind the scenes template so that it doesn't impact end user experience.

Integrating Vena

For our priorities of getting data out of Vena and into our SQL data warehouse, the process was easy to learn and setup. It has also been easy to modify or expand, and has run consistently without any issues. I don't rate Vena higher currently because ingestion of data to Vena is more complicated. They have prioritized building integrations for specific accounting systems, which I think is probably a good business strategy, but I'd ideally like to more easily push data from a SQL database and map into the Vena data model more easily.
  • Export to SQL
We do not actively push any data into Vena on a recurring basis, other than a once per year upload of payroll data from our ERP. We setup a nightly export to our SQL data warehouse to run on a nightly basis during our initial implementation, and still rely on that today. The process wasn't hard to setup as we just needed to learn the query language and create a script to export the data to a .csv file on the data warehouse server.
  • Microsoft Dynamics
We are on a very outdated version so I don't expect so, but if we upgrade to the modern version, then I expect Vena will plan to support this if they are not already, given their strategic alignment with Microsoft.
  • File import/export
  • ETL tools
No other tools. We use direct file import/export for a couple of small routine tasks, annual upload of payroll information for budget planning, and any ad hoc troubleshooting. We use an ETL tool to run a script on a nightly basis to pull data out of Vena and into our SQL data warehouse.
Vena integration works well for our primary use case of exporting to our SQL data warehouse and I have seen a lot of documentation and talked to other Vena clients that have created more complex workflows to get data into Vena. If integration is important for you, I think Vena has flexibility to build any integration, but the complexity of the process may range depending on whether your source system is one they've pre-configured or not.

Relationship with Vena Solutions

Vena's sales team was very easy to work with during our initial evaluation, answering questions and connecting us with their technical experts as needed, and also allowing us access to a test environment to test connectivity from different locations across the globe. They also helped to coordinate a demo of how the platform could simplify one of our biggest challenges - integrating new funding into our operating budgets.
Since the initial implementation, the sales team helped to resolve a mis-understanding in our initial contract which would have locked us into an additional license cost, which we did not need. Also, each of our 2 renewals since have been discussed with plenty of lead time and clarity to understand our options and make the process simple.
We agreed to an initial 3 year contract with plans to scale up our user license after the first year, as well as discounts on additional consulting hours post implementation. The contract also allowed us to purchase additional licenses as needed, which we decide to do in the first year to expand our user base.
I have found Vena to be a very open and cordial company, with each customer success team member treating me as a partner rather than just a customer. Vena follows through on their marketing of helping to grow your organization by being proactive communicators, asking questions to understand your priorities, linking you with relevant webinars/feature releases and other clients facing similar challenges.

Upgrading Vena

  • Vena's upgrades are behind the scenes and the platform is a living product with no significant versions to maintain/upgrade
  • Cosmetic changes to improve the user interface are well marketed ahead of time and easy to transition to
  • I expect Vena's partnership with Microsoft will continue to create more seamless integration with other Microsoft tools (already Power BI and Copilot)

Comments

More Reviews of Vena