Vena provides flexibility and efficiency to focus on what actually matters
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 Feature Ratings
Vena Solutions Attributes
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
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
- Implemented in-house
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
Configuring Vena
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
Pros | Cons |
---|---|
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
Pros | Cons |
---|---|
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
Integrating Vena
- 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
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
Please log in to join the conversation