WEBVTT

00:00:00.000 --> 00:00:03.503
Vena takes the best of Microsoft Excel

00:00:03.503 --> 00:00:05.505
and wraps it in the security and power

00:00:05.505 --> 00:00:08.008
of an enterprise FP&A solution,

00:00:08.008 --> 00:00:12.012
allowing business professionals
to budget, forecast, report

00:00:12.012 --> 00:00:16.016
and perform analysis in an
environment that’s already familiar.

00:00:16.016 --> 00:00:19.019
From small organizations,
to growing market players,

00:00:19.019 --> 00:00:22.022
to international industry leaders,

00:00:22.022 --> 00:00:25.025
Vena is designed to suit the
size of your business right now

00:00:25.025 --> 00:00:27.027
and scale with you as you grow.

00:00:27.027 --> 00:00:29.029
Today, let’s explore how Vena can help

00:00:29.029 --> 00:00:32.032
shorten the budgeting cycle for Supercorp.

00:00:32.032 --> 00:00:34.034
Supercorp’s a growing company.

00:00:34.034 --> 00:00:36.036
Their products and services are selling well,

00:00:36.036 --> 00:00:38.038
and customers are coming back for more.

00:00:38.038 --> 00:00:40.040
Life is good for Supercorp…

00:00:40.040 --> 00:00:42.042
until budget season comes around.

00:00:42.042 --> 00:00:45.045
Like many companies,
Supercorp’s budgeting process

00:00:45.045 --> 00:00:47.047
involves sending out an Excel template

00:00:47.047 --> 00:00:50.050
to department heads
and other decision makers.

00:00:50.050 --> 00:00:52.052
And everyone does their best

00:00:52.052 --> 00:00:55.055
to complete their budgets
accurately and on time.

00:00:55.055 --> 00:00:56.056
But when their completed files

00:00:56.056 --> 00:00:58.058
start flowing back in
to the finance department

00:00:58.058 --> 00:01:02.062
well, life starts getting…
a little chaotic.

00:01:02.062 --> 00:01:05.065
To be fair, Supercorp’s
on the right track.

00:01:05.065 --> 00:01:07.067
Everyone does love Excel;

00:01:07.067 --> 00:01:10.070
in fact, 84% of companies
that replace Excel

00:01:10.070 --> 00:01:12.072
for their FP&A processes

00:01:12.072 --> 00:01:15.075
actually end up reverting
back to Excel over time.

00:01:15.075 --> 00:01:17.077
But what’s missing is a way to cut down

00:01:17.077 --> 00:01:19.079
on the frustrating, tedious tasks

00:01:19.079 --> 00:01:21.081
that stretch out budget cycle time

00:01:21.081 --> 00:01:23.083
and take away from value-added work,

00:01:23.083 --> 00:01:25.085
like performing variance analysis

00:01:25.085 --> 00:01:27.087
and building out what-if scenarios.

00:01:27.087 --> 00:01:29.089
That’s where Vena comes in.

00:01:29.089 --> 00:01:32.092
Vena takes the best features of Excel

00:01:32.092 --> 00:01:35.095
and wraps them in an
enterprise FP&A solution,

00:01:35.095 --> 00:01:39.099
with security, control, a
centralized database, and more.

00:01:39.099 --> 00:01:42.102
End-users get to keep using the
familiar environment of Excel,

00:01:42.102 --> 00:01:45.105
but the data can be accessed
anywhere, at any time,

00:01:45.105 --> 00:01:49.109
fully integrated for input,
reporting and analysis.

00:01:49.109 --> 00:01:51.111
If a contributor needs to make revisions,

00:01:51.111 --> 00:01:55.115
those revisions will update
in the database automatically

00:01:55.115 --> 00:01:57.117
and the changes can always be audited.

00:01:57.117 --> 00:01:59.119
Let’s go through the budget process again.

00:01:59.119 --> 00:02:04.124
But this time, with Vena helping Supercorp
to work the way they think

00:02:04.124 --> 00:02:07.127
Frank Smith, in Supercorp’s Department 101,

00:02:07.127 --> 00:02:11.131
has just been notified that next year’s
budget is ready for his input.

00:02:11.131 --> 00:02:14.134
When Frank logs in to Vena,
he sees his Task Workspace,

00:02:14.134 --> 00:02:17.137
and notices that there’s some
work for him in the To Do section.

00:02:17.137 --> 00:02:19.139
He clicks on Department 101,

00:02:19.139 --> 00:02:22.142
and receives a collection of templates
that he needs to complete,

00:02:22.142 --> 00:02:25.145
including a Non-Labor Expense Budget.

00:02:25.145 --> 00:02:29.149
From here, Frank can select which
fiscal year budget needs to be updated,

00:02:29.149 --> 00:02:33.153
create what-if scenarios,
or simply load the budget for input.

00:02:33.153 --> 00:02:36.156
He can also choose between
desktop Excel or online Excel.

00:02:36.156 --> 00:02:39.159
Today, he’ll input the budget
using desktop Excel.

00:02:39.159 --> 00:02:41.161
Supercorp has opted to use a pre-built

00:02:41.161 --> 00:02:44.164
best-practice budgeting template from Vena.

00:02:44.164 --> 00:02:47.167
But if Supercorp wanted to use their
own existing Excel templates,

00:02:47.167 --> 00:02:50.170
Vena could integrate and automate them as well.

00:02:50.170 --> 00:02:53.173
Data is populated based on
each user’s security permissions,

00:02:53.173 --> 00:02:58.178
so in this case, Frank only sees
numbers related to his own department.

00:02:58.178 --> 00:03:00.180
Now, Frank’s working in the
familiar environment of Excel,

00:03:00.180 --> 00:03:04.184
but with the addition of a
Vena menu on the right.

00:03:04.184 --> 00:03:07.187
From here, Frank can insert
or remove line item details,

00:03:07.187 --> 00:03:10.190
drill down into actual transactions
from his source systems,

00:03:10.190 --> 00:03:14.194
add comments for more clarity,
and insert additional files,

00:03:14.194 --> 00:03:16.196
like an invoice or a receipt.

00:03:16.196 --> 00:03:18.198
Later on, Supercorp’s finance team

00:03:18.198 --> 00:03:21.201
can use these same tools to
view transaction history,

00:03:21.201 --> 00:03:25.205
audit changes within the document,
and view commentary for additional context.

00:03:25.205 --> 00:03:27.207
Frank’s unsure of exactly what’s going to

00:03:27.207 --> 00:03:29.209
make up his advertising budget.

00:03:29.209 --> 00:03:31.211
So he jumps over to the Scratch Pad tab

00:03:31.211 --> 00:03:33.213
to double-check some data.

00:03:33.213 --> 00:03:36.216
The Scratch Pad is a sandbox
for free-form modeling,

00:03:36.216 --> 00:03:39.219
additional calculations,
and any other functions

00:03:39.219 --> 00:03:42.222
a contributor might need to make
before saving numbers into the budget.

00:03:42.222 --> 00:03:45.225
Frank adds a PDF for
supporting documentation,

00:03:45.225 --> 00:03:47.227
and then uses a standard Excel formula

00:03:47.227 --> 00:03:49.229
to reference the numbers from his Scratch Pad

00:03:49.229 --> 00:03:52.232
and insert them into the
Advertising cells of the live budget,

00:03:52.232 --> 00:03:55.235
along with a note for the finance team.

00:03:55.235 --> 00:03:58.238
Once he’s done, he’ll save his
budget back to the database.

00:03:58.238 --> 00:04:00.240
This template will retain all of Frank’s formulas,

00:04:00.240 --> 00:04:04.244
comments, and free-form models,
so Finance always has context

00:04:04.244 --> 00:04:07.247
for how those numbers came to be.

00:04:07.247 --> 00:04:09.249
So now, instead of a bunch of Excel files

00:04:09.249 --> 00:04:11.251
being emailed back to headquarters,

00:04:11.251 --> 00:04:13.253
the budget data for each department

00:04:13.253 --> 00:04:16.256
flows back to a central database
through a master template,

00:04:16.256 --> 00:04:19.259
automatically aggregating for
powerful reporting and analysis.

00:04:19.259 --> 00:04:23.263
But Supercorp’s CFO, Sarah, is super busy.

00:04:23.263 --> 00:04:26.266
She doesn’t always have time to
analyze individual budgets.

00:04:26.266 --> 00:04:29.269
So when she logs in,
she sees a series of dashboards

00:04:29.269 --> 00:04:34.274
that allow her to quickly view analytics,
exceptions, anomalies and trends

00:04:34.274 --> 00:04:37.277
for all of Supercorp’s operating divisions.

00:04:37.277 --> 00:04:38.278
If she wants to dive deeper,

00:04:38.278 --> 00:04:40.280
she can access a report package to view

00:04:40.280 --> 00:04:43.283
any department or division’s financials.

00:04:43.283 --> 00:04:48.288
Today, she opens an Expense Variance Analysis
report from Frank’s Department 101.

00:04:48.288 --> 00:04:51.291
From here, she can easily compare

00:04:51.291 --> 00:04:56.296
Department 101’s expenses by month and year,
across any set of scenarios.

00:04:56.296 --> 00:04:59.299
And if she wants to do some quick analysis herself,

00:04:59.299 --> 00:05:02.302
she can open the Ad-Hoc tab to
quickly slice and dice this data.

00:05:02.302 --> 00:05:04.304
Before moving on to her next project,

00:05:04.304 --> 00:05:06.306
Sarah decides to get an overview of how the

00:05:06.306 --> 00:05:08.308
whole company is handling the budget process.

00:05:08.308 --> 00:05:10.310
She opens the online Status Tracker

00:05:10.310 --> 00:05:13.313
to quickly visualize which budgets are complete,

00:05:13.313 --> 00:05:16.316
which ones still need to be done,
and who’s responsible for them.

00:05:16.316 --> 00:05:19.319
Supercorp is used to budgeting nightmares.

00:05:19.319 --> 00:05:23.323
But why dread budgeting season when
there’s a better way to get it done?

00:05:23.323 --> 00:05:27.327
With Vena, the finance team,
and every Supercorp department,

00:05:27.327 --> 00:05:31.331
can keep using the best of Excel
within an enterprise solution.

00:05:31.331 --> 00:05:35.335
Contributors like Frank can
create and modify their budgets

00:05:35.335 --> 00:05:38.338
in a familiar environment, while CFO Sarah
and her finance team

00:05:38.338 --> 00:05:42.342
get to spend more time focusing on review, analysis,

00:05:42.342 --> 00:05:45.345
what-if modeling, and other value-added work.

00:05:45.345 --> 00:05:48.348
Suddenly, everyone’s feeling
pretty good about year-end.

00:05:48.348 --> 00:05:50.350
Budgeting’s a lot better when you’re

00:05:50.350 --> 00:05:53.353
working the way you think,
wouldn’t you say?