Vena - Excel Modeling's Partner
May 14, 2022

Vena - Excel Modeling's Partner

Choy Chu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Vena

We currently use Vena for only our extensively detailed global recurring revenue model in the finance dept. Our model has always been very detailed, one of which excel alone can no longer handle. We moved the model onto Vena platform and resolved the file size issue by storing the data used in the cloud instead of on the spreadsheet. Vena's capability to dynamically expand wherever there is need to made maintenance of the model, reports, and templates much easier.
  • Dynamic expansion and mapping.
  • Integrations with other tools.
  • Data and file storage in the cloud.
  • Versatile
  • Template automation encountering issues due to certain excel functions used.
  • Mac users often have issues.
  • There should be a built-in option to automatically overwrite actual periods with actual data in forecast scenarios.
  • Users must be proficient in Excel to use Vena to its full potential.

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

  • Excel only model stopped functioning due to file size and formula errors, Vena allowed us to continue the core of the model while storing the data in cloud and dynamically expanding to accommodate the growing price plans of our product.
Vena sales team connected us to the customer services team. We were onboarded with training and assigned with an implementation specialist. Implementation was done by an extremely intelligent excel expert who incorporated complex formulas to make our model better than the previous excel-only model.
The actual data from the data warehouse is automatically loaded into our model, eliminating the need to manually feed the actuals. We therefore only focus on the projections.
Different software has different pros and cons. The pros of Vena is that it is Excel-based. One can do a lot in Excel if the user is already Excel-proficient. Other software may be better for those who are less Excel-proficient.
Current forecasting models using only Excel should move on to use a cloud-based forecasting platform. Vena should be considered if the core of the team using the software is Excel proficient. Expert services are recommended for engagement if forecasting model setup changes frequently. Not recommended for Mac users.

Vena Feature Ratings

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