WEBVTT

00:00:00.190 --> 00:00:02.450
>> So my name is Joseph Bishop
[assumed spelling].

00:00:02.450 --> 00:00:06.370
I work at a software company
called Quintec [phonetic]

00:00:06.370 --> 00:00:09.950
which was just recently acquired
by the Sol Systems [phonetic].

00:00:09.950 --> 00:00:16.050
So what Quintec is it's a supply
chain management and software company.

00:00:16.050 --> 00:00:22.300
So my role there is I work in the
FP&A team, so I'm a financial analyst.

00:00:22.300 --> 00:00:26.620
My main responsibilities are
managing the [inaudible] results

00:00:26.620 --> 00:00:29.330
and before your estimates for the company.

00:00:29.330 --> 00:00:34.820
So each week we send out a financial
dashboard to the senior management

00:00:34.820 --> 00:00:37.920
and to the business directors there.

00:00:37.920 --> 00:00:44.190
And they kind of glaze over it and
just monitor our progress numbers-wise.

00:00:44.190 --> 00:00:51.980
So we use Meconomy which is a simple ERP
system, enterprise resource planning system,

00:00:51.980 --> 00:00:55.310
that pretty much holds all
of our financial data.

00:00:55.310 --> 00:01:00.250
So we extract that data, and
it's basically just a data dump.

00:01:00.250 --> 00:01:06.110
We just drop the data into an Excel
spreadsheet, and we use various pivot charts

00:01:06.110 --> 00:01:12.320
and different Excel commands
to present the report.

00:01:12.320 --> 00:01:19.230
Typically on Thursdays and Fridays when the
dashboards are generally distributed I come in

00:01:19.230 --> 00:01:26.890
and extract the data from the ERP system, do
some uploading as well as some journal uploads.

00:01:26.890 --> 00:01:33.320
And then I extract the data once more, and then
I would drop it into the financial dashboard.

00:01:33.320 --> 00:01:37.760
And then I would glaze over the current
week versus the prior week because,

00:01:37.760 --> 00:01:40.740
again, it's a week-to-week report.

00:01:40.740 --> 00:01:47.660
So I drop the data in, and then I look
at any variances that are pretty huge.

00:01:47.660 --> 00:01:53.700
And I will call them out in a weekly email
that I send on Thursdays and Fridays.

00:01:53.700 --> 00:01:56.530
We generally send it out on
Thursday so that when we sent it

00:01:56.530 --> 00:02:02.340
out on Thursdays any errors can get correct
for the correct dashboard which goes

00:02:02.340 --> 00:02:03.780
out to the senior team on Fridays.