Vena provides flexibility to set up budgets, reports and other processes as flexibly as we need.

We were able to streamline and centrally collect data for our budgeting process, which save considerable time for the budget administrator and other admin assistants across our university. We created Board-level reporting templates that can be re-used every year to report the results of the budget process with only changes made as necessary for the format of the current reporting year. We collect forecasting information from over 330 departments and compile all the information within one template to estimate the financial outcome for the fiscal year. We have been able to include data in planning of various kinds in ways that we weren't able to by just using Excel, resulting in better planning results. We can create new planning or reporting processes and have the flexibility to save additional data input that isn't part of our ERP data. Overall, we have saved time, improved processes, created one version of the data visible to all involved in the process and created efficiencies by being able to share data across processes.

Pros

Flexibility to set up whatever process we are working on the way it needs to be set up for our business requirements. Continual improvements being done on the Vena add-in and browser administration interface. Formatting Excel templates and reports exactly as needed. Ability to pull in data from all data versions for any reporting or template. Ability to save non-financial data to use in reporting or calculations. Ability to control user input as needed to better quality data. Prompt customer service responses. Great implementation team. Administrative control over data visible to individual users. Workflows to show status for process steps and email notifications when a workflow step is ready for input or review. Once learned, allows for creation of new processes to collect or report data.

Cons

Having to download each Excel file, but once downloaded, it's easy to select the data we want to see.

Excel based Performance Management Tool

Pros

Our Financial Planning and Analysis team picked Vena from many other tools. The reason for zeroing on this tool, is, it is an excel based tool. We have been doing all this work in excel since years. We have standardized the process and have fixed excel templates. However excel has certain limitations like version control, access control, audit trail etc. With Vena we overcame the limitations of excel while retaining the power, flexibility and ease of use of excel. We have many desperate IT systems some by choice and some by compulsion due to various acquisitions. We import the data from all these systems into vena database. Data is automatically consolidated and aggregated per our requirements for use in advanced management reports as well as ad hoc reports in vena. Vena offers workflow and approval management by project, department etc. Further one can drill up, drill down, slice and dice the data using vena. Variance analysis is a piece of cake in this tool. Vena customer service is good too.

Cons

There is a learning curve like any other tool. There is no drag and drop from a selection of columns, fields etc. However once you learn the tool, reporting becomes easier.

Great software to consolidate numbers from multiple sources

Overall great experience using their spreadsheet templates which saves you a lot of time and helps you avoid errors.

Pros

I used to work at a bank where we had to collect financial information from numerous departments and Vena really helped us reduce the time we spent on consolidating the balances and avoid errors. Overall, a great software package if you need to collect huge amounts of the same data from different sources.

Cons

The only issue I had with this software was updating the template if new requirements were issued. If you contact customer support they can definitely help you but if you decide to do it yourself you need to become an expert in Vena.

Vena

Useful product but hard to use without constant support from their consultants.

Add super powers to your Excel templates

Pros

I don't have to learn SQL programming languages or wait around for my computer department to do something . I can manage everything myself.

Cons

Being a young company, they need more demonstrations, downloaded working files to build users skills.