A computer monitor with Vena 365 product demonstrating OPEX Reforecast.

How Vena 365 Connect Makes Budgeting Easier for Managers and Cross-Functional Contributors

June 21, 2021 Evan Webster  
LinkedIn Twitter Facebook

When you’re building out or updating your company’s annual budget, getting feedback from cross-functional stakeholders is a crucial part of the process. Regardless of whether your finance team uses a top-down or bottom-up approach, non-finance contributors will always have to make their own budget inputs. 

Vena 365 Connect makes budget inputs a lot easier thanks to a refreshed user interface for contributors from across your business. We’ve improved Vena’s usability so you can collaborate with every department and deliver more reliable budgets—all without the manual effort.

In this article, we’ll walk you through the new contributor and manager experiences in Vena 365 Connect. But first, let’s make it clear what Vena 365 Connect actually is, with some context regarding why we even launched these updates in the first place.

What Is Vena 365 Connect?

Vena 365 Connect is a Complete Planning platform that brings business data from across your organization into a secure, cloud-based environment. It’s an even more user-friendly version of Vena that integrates with Microsoft 365, which means Excel users on both Windows and Mac can create reports and distribute budgeting templates seamlessly.

Why Did We Launch Vena 365 Connect?

We launched Vena 365 Connect for two primary reasons:

  1. To ensure Mac users aren’t limited in their use of our solution.
  3. To provide a seamless, modern, fully integrated and user-friendly experience across all planning processes.

If you’re an existing Vena customer, you already know that our platform leverages a native Excel interface. But you also know cross-functional budget contributors may not be as Excel-savvy as you are—so that’s why we’ve updated the experience with a simpler, more user-friendly interface.

Learn more below!

How Vena 365 Connect Makes Budgeting Easier For Cross-Functional Contributors

In addition to the new Mac compatibility, the most noteworthy feature of Vena 365 Connect is a slick new sidebar contributors can see when they work on a template. Contributors have the option to minimize this sidebar to maximize screen space when entering and analyzing data.

Let’s say, for example, that you’re a marketing manager updating your advertising budget. This is what you would see when you open the OpEx template for your marketing department in Vena:

HubSpot Video


The sidebar is divided into three distinct tabs:

Each of these sections provides a simplified set of functions your contributors can take advantage of as they prepare their budgets for review and approval. Keep on reading for a full breakdown of each one.

1. Instructions and Documents Make It Clear What Contributors Need To Work On

As you open up your marketing department’s OpEx template, everything you need to do is laid out clearly in the Instructions and Documents section. Admins can make the instructions as simple or as detailed as they need to, but they’ll always be displayed here to avoid any confusion for contributors.

This is what you would see when you look at the Instructions and Documents tab in the marketing OpEx template:

HubSpot Video


As you can see, the marketing manager needs to submit all their budget inputs for review and approval. Let’s have a look at what that looks like with Vena 365 Connect.

2. Data Input Tools Make Adjusting Line Item Details Simple

When you open up the Data Input Tools tab, you’ll have the option to add or remove line item details from your budgeted values. So if you need to make a distinction between print and digital spends in your total advertising budget, all it takes is a couple of quick clicks.

HubSpot Video


Once you’ve saved those inputs back to Vena, the new numbers will be applied across your dataset automatically—ultimately sparing you the hassle of copying and pasting those values yourself. Admins will then be prompted to review your work before it’s finalized. 

HubSpot Video

3. Data Analysis Tools Tell the Full Story Behind Each Number

Once your contributors have submitted their budgets for final review, managers can use Vena’s Data Analysis Tools to uncover the story those numbers are telling them. Let’s say you see a particularly large value somewhere and you need to know where it came from. The Drill Saves function brings up a history of all changes to that data intersection so you can see exactly who made the input and when—giving you 100% visibility into everything that’s happening with your numbers.

HubSpot Video


You can also see the individual transactions that roll up to any value with the Drill Transactions function in Vena 365 Connect. The data you’d see here depends on the hierarchy structure in your data model, but all member values would be displayed in a separate Excel tab. 

This is really helpful for explaining discrepancies or variances to your management team, because all the context you’d need is available with the touch of a button. And when you always have reliable data at your fingertips whenever you need it, you’ll always be well-equipped to lead your business in the right direction.

HubSpot Video

How Vena 365 Connect Makes Creating Budget Inputs Easier for Managers

1. Budgets, Forecasts and Reports Built In Seconds

If you need to create a template or report quickly from scratch, the Quick Build feature lets you pull data from your cube—in seconds—through a simple drag-and-drop interface. You can save and share this as a real-time budget, forecast or report that updates automatically based on data in your cube.

HubSpot Video

2. Faster, Intuitive, Automatic Mapping

If you have a pre-existing Excel template you want to connect to Vena’s Complete Planning platform, the Auto-Map feature makes transferring templates easier and faster than ever. Select the cells you want to map and the mapping type and the Auto-Map feature will automatically match your source field to your destination field.

HubSpot Video

3. Easier, Quicker Troubleshooting

Once you’re satisfied with your template or report, the Analyze feature checks for mapping errors. If any numbers appear incorrect, you can use the Cell Info feature to view every specific mapping for a cell to ensure it’s been mapped correctly—saving you time to focus on what really matter—insights and analysis.

HubSpot Video


Experience Vena 365 Connect in Action

Vena 365 Connect is now available to everyone—but only if your team is already using Microsoft 365. To learn more about our platform and to see Vena 365 Connect in action, just check out the link below and take it for a spin yourself!

(Current Vena customers can click here to ask your CSM for more info.)

Woman typing at laptop with graphs on it.
Ready to start your own growth journey?
Try Vena Today

Recommended Posts