Vena

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.

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.

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.

Pros

The Excel interface is my favorite part about Vena. Everyone within our business is familiar with and comfortable using Excel. Therefore, when we started using Vena for budgets, our contributors did not have to learn a completely new interface. However, Vena offers so much more than just Excel. I love how Vena shows you who made changes to the file and what the previous values in the file were. It helps hold people accountable. It is also very easy to make powerful reports using Vena.

Cons

We built a very complicated template which took a long time to open. However, Vena was very helpful in helping us optimize our template and improve the performance drastically.

Pros

I particularly like how easily Vena integrates with my existing software programs (Microsoft Excel based), and the support provided to our business has been second to none!

Cons

There were a few glitches during set-up and installation and there is a bit of a learning curve as we customized the program to fit our particular requirements, however customer support made life as easy as possible.