An Introduction
An Introduction
T
T
o
o
Hyperion Financial
Hyperion Financial Management
Management
By Amit Sharma
By Amit Sharma
Agenda
Agenda
:
:
Fundamenta
Fundamenta
ls of
ls of
Financial Consolidation
Financial Consolidation
Describe the features of Financial Management
Describe the features of Financial Management
Describe the Hyperion products bundled with
Describe the Hyperion products bundled with
Financial Management
Financial Management
Describe the product architecture
Describe the product architecture
Hyperion Financial Management
Hyperion Financial Management
H
Hy
yp
pe
er
ri
io
on
n
F
Fi
in
na
an
nc
ci
ia
al
l
M
Ma
an
na
ag
ge
em
me
en
nt
t
i
is
s
a
a
financial
financial
consolidation
consolidation
and
and
repor
repor
ting
ting
appli
appli
cation
cation
buil
built
t
wit
wit
h
h
advanced
advanced
Web
Web
techn
techn
olog
olog
y
y
,
,
b
bu
ut
t
u
us
se
ed
d
an
a
nd
d
m
ma
ai
in
nta
tain
ined
ed
b
by
y
t
the
he
finance
finance
team
team
.
.
It
It
pr
prov
ovid
ides
es
fi
fina
na
nc
ncia
ial
l
mana
ma
nage
gers
rs
th
the
e
ab
abil
ilit
ity
y
to
to
ra
rapi
pidl
dly
y
cl
cl
os
ose
e
an
and
d
re
re
po
po
rt
rt
fi
fi
na
na
nc
nc
ial
ial
re
re
su
su
lt
lt
s
s
,
,
m
me
ee
et
t
glo
glo
bal
bal
regu
regu
lat
lat
ory
ory
requirements
requirements
,
,
r
red
edu
uce
ce
the
t
he
c
co
ost
st
o
of
f
co
com
mp
pl
li
ia
an
nc
ce
e
a
an
nd
d
de
deli
live
ver
r
confidence in the numbers.
W
W
hat is Financial Consolidation
hat is Financial Consolidation
Financia
Financiall ConsolidConsolidationation[[ ThThee MMerergegerr ofof TTwowo EnEnteterrprprisiseses]]
:: ThThee cocombmbininededfifinanancnciaiall ststatatememenenttss ofof aa paparerentnt cocompmpananyy anandd ititss susubsbsididiaiaririeses.. or or Be Beccaauusese ccoonnssoollididaatteedd fifinnaanncciaiall ssttaatteememennttss pprreesseenntt aann aaggggrreeggaatteedd llooookk aatt t thhee ffiinnaanncciiaall ppoossiittiioonn ooff aa ppaarreenntt aanndd iittss ssuubbssiiddiiaarriieess,, tthheeyy eennaabbllee yyoouu ttoo g gaauuggee tthhee oovveerraallll hheeaalltthh ooff aann eennttiirree ggrroouupp ooff ccoommppaanniieess aass ooppppoosseedd ttoo oonnee co
compampanyny's's ststanandd alalononee poposisitiotion.n.
CCoonnssoolliiddaattiinngg ffiinnaanncciiaall ddaattaa ffrroomm ddiivveerrssee llooccaattiioonnss aanndd aaccrroossss mmuullttiippllee ge genenerarall leledgdgerers,s, peperfrforormimingng mumultlti-i-cucurrrrenencycy coconvnverersisionons,s, ununtatangnglilingng ououtmtmododeded s spprreeaaddsshheeeett bbaasseedd ddaattaa ccoolllleeccttiioonn pprroocceesssseess,, iinnccoorrppoorraattiinngg cchhaannggeess ffrroomm reo
reorgarganiznizatiationsons,, mergmergersers,, andand acqacquisuisitiitions.ons.
Business Intelligence
Business Intelligence
In another accounting context, financial consolidation refers to various
In another accounting context, financial consolidation refers to various
processes that will streamline the internal financial reporting of
processes that will streamline the internal financial reporting of a singlea single
company
W Whehenn dodo wewe neneeded FiFinanancnciaiall CoConsnsololididatatioionn:: CCoonnssoolliiddaatteedd ffiinnaanncciiaall ssttaatteemmeennttss aarree rreeqquuiirreedd wwhheenn tthheerree aarree ttwwoo oorr mmoorree af affifililiatateded cocompmpananieies.s. WWhheenn aa ppaarreenntt ccoommppaannyy eeiitthheerr ddiirreeccttllyy oorr iinnddiirreeccttllyy c coonnttrroollss aa mmaajjoorriittyy iinntteerreesstt ooff aa ssuubbssiiddiiaarryy,, ccoonnssoolliiddaatteedd ffiinnaanncciiaall ssttaatteemmeennttss mu mustst bebe prpresesenenteted.d. (C(Caashsh flflowows,s, aandnd fifinanancnciaiall poposisititionon ofof ththee cocombmbininededenentitityty)) WWhheenn oonnee ccoommppaannyy aaccqquuiirreess aannootthheerr ccoommppaannyy,, aa ccoonnssoolliiddaatteedd bbaallaannccee s shheeeett nneeeeddss ttoo bbee pprreeppaarreedd.. TThhee ffiirrsstt sstteepp iiss ttoo eelliimmiinnaattee tthhee eeffffeeccttss ooff aannyy inter
inter-compan-companyy transatransactionsctions..
CCoonnssoolliiddaattee ddaattaa qquuiicckkllyy ffrroomm mmuullttiippllee ggeenneerraall lleeddggeerrss aanndd mmuullttiippllee ch charartsts ofof acaccocoununt?t? CCoonnssoolliiddaattee ddaattaa frfroomm vvaarriioouuss bbuussiinneessss ppeerrssppeectctiivveess aanndd bbyy mmuultltiipplele st struructctururee veversrsioionsns (t(thihiss yeyearar,, lalastst yeyearar,, prpropopososeded)?)? SuSupppporortt lolocacall anandd mumultltipiplele babasese cucurrrrenencycy rerepoportrtining?g? RReeppoorrtt oonn tthhee iimmppaacctt ooff ccuurrrreennccyy fflluuccttuuaattiioonnss ((aaccttuuaall,, ffoorreeccaasstt aanndd bud
T
T
h
h
e
e
p
p
r
r
o
o
b
b
l
l
e
e
m
m
s
s
-
-
c
co
on
ns
so
ol
li
id
da
at
ti
in
ng
g
f
fi
in
na
an
nc
ci
ia
al
l
d
da
at
ta
a
f
fr
ro
om
m
diverse
diverse
locations
locations
a
an
nd
d
a
ac
cr
ro
os
ss
s
m
m
ul
ul
t
t
ip
ip
le
le
ge
ge
ne
ne
ra
ra
l
l
le
le
dg
dg
er
er
s
s
,
,
p
pe
er
rf
fo
orm
rmin
ing
g
multi-
multi-c
c
u
u
r
r
r
r
e
e
n
n
cy
cy
c
c
on
on
v
v
e
e
r
r
si
si
o
o
ns
ns
,
,
a
an
nd
d
un
u
nt
ta
an
ng
gl
li
in
ng
g
o
o
u
u
td
td
a
a
te
te
d
d
sp
sp
re
re
a
a
d
d
sh
sh
ee
ee
t
t
b
ba
as
se
ed
d
d
da
at
ta
a
c
co
ol
ll
le
ec
ct
ti
io
on
n
p
pr
ro
oc
ce
es
ss
se
es
s,
,
i
in
nc
co
or
rp
po
or
ra
at
ti
in
ng
g
c
ch
ha
an
ng
ge
es
s
f
fr
ro
om
m
reorganizations
reorganizations
,
,
mergers
mergers
,
,
a
an
nd
d
acquisitions
acquisitions
.
.
F
F
i
i
n
n
a
a
n
n
c
c
i
i
a
a
l
l
D
D
a
a
t
t
a
a
Q
Q
u
u
a
a
l
l
i
i
t
t
y
y
M
M
a
a
n
n
a
a
g
g
e
e
m
m
e
e
n
n
t
t
:F
:Fin
inan
anci
cial
al
co
con
nso
sol
lid
idat
ati
ion
on
s
so
ol
lu
ut
ti
io
on
ns
s
c
ca
an
n
m
me
ee
et
t
t
th
hi
is
s
c
ch
ha
al
ll
le
en
ng
ge
e
b
by
y
st
st
re
re
am
am
li
li
ni
ni
ng
ng
da
da
ta
ta
co
co
ll
ll
ec
ec
ti
ti
on
on
and
and
integration
integration
f
fr
ro
om
m
m
mu
ul
lt
ti
ip
pl
le
e
s
so
ou
ur
rc
ce
es
s,
,
m
ma
ak
ki
in
ng
g
t
th
he
e
mo
m
on
nt
th
hl
ly
y
c
cl
lo
os
se
e
f
fa
as
st
te
er
r
a
an
nd
d
m
mo
or
re
e
ef
e
ff
fi
ic
ci
ie
en
nt
t
w
wh
hi
il
le
e
t
tu
ur
rn
ni
in
ng
g
d
di
is
sp
pa
ar
ra
at
te
e
da
d
at
ta
a
i
in
nt
to
o
u
us
se
ef
fu
ul
l,
,
bu
Financial Consolidation types
Financial Consolidation types
The Consolidation ModThe Consolidation Module enables the ule enables the user to generate tuser to generate the followinghe following
Consolidated
Consolidated
Financial Statements:
Financial Statements:
Consolidated Balance SheetConsolidated Balance Sheet
A bala
A balance sheet in nce sheet in which assets and liabilities of a which assets and liabilities of a parent company and itsparent company and its
controlled subsidiaries are combined, thereby presenting balance sheet
controlled subsidiaries are combined, thereby presenting balance sheet
items for the parent and its subsidiaries as if t
items for the parent and its subsidiaries as if they were a single firm.hey were a single firm.
Consolidated Trial Balance
Consolidated Trial Balance
Consolidated Profit & Loss
Spreadsheets Spreadsheets W Whheenn tthhee sspprreeaaddsshheeeett aapppprrooaacchh iiss uusseedd,, sspprreeaaddsshheeeett tteemmppllaatteess aarree c crreeaatteedd bbyy cceennttrraall hheeaaddqquuaarrtteerrss aanndd ee--mmaaiilleedd ttoo rreemmoottee llooccaattioionnss.. ThTheenn,, oonn aa m moonntthhllyy oorr qquuaarrtteerrllyy bbaassiiss,, tthheessee sspprreeaaddsshheeeettss aarree uuppddaatteedd aanndd ee--mmaaiilleedd b baacckk ttoo cceennttrraall hheeaaddqquuaarrtteerrss,, wwhheerree tthheeyy aarree ccoonnssoolliiddaatteedd iinnttoo aa mmaasstteer r s spprreeaaddsshheeeett²²uussuuaallllyy wwiitthh ccoommpplleexx mmaaccrrooss.. TThhee oonnllyy aaddvvaannttaaggee ooff tthhiiss a apppprrooaacchh iiss llooww ccoosstt bbeeccaauussee tthheerree iiss nnoo ssooffttwwaarree oorr hhaarrddwwaarree ttoo bbuuyy.. E Evveerryyoonnee iinn tthhee oorrggaanniizzaattiioonn aallrreeaaddyy hhaass ee--mmaaiill aacccceessss aanndd aa sspprreeaaddsshheeeett ap applplicicatatioionn onon ththee dedesksktotop.p.
Financial Consolidation, Reporting, and Analysis
Financial Consolidation, Reporting, and Analysis
Financial Management enables highly efficient collection and
Financial Management enables highly efficient collection and
consolidatio
consolidation of
n of
data from diverse sources. It includes these
data from diverse sources. It includes these
features:
features:
Process manage
Process management
ment for tight control of the review
for tight control of the review
and approval
and approval
processData validation
processData validation
Currency translation to support multiple local currencies
Currency translation to support multiple local currencies
Automatic eliminations for
Automatic eliminations for
intercompa
intercompany
ny transactions
transactions
F
Fi
in
na
an
nc
ci
ia
al
l
Ma
M
an
na
ag
ge
em
me
en
nt
t
is
i
s
d
de
es
si
ig
gn
ne
ed
d
f
fo
or
r
large-scale
large-scale
,
,
centralized
centralized
W
W
e
e
b
b
d
d
e
e
p
p
l
l
o
o
y
y
m
m
e
e
n
n
t
t
.
.
Y
Y
o
ou
u
c
ca
an
n
u
us
se
e
F
Fi
in
na
an
nc
ci
ia
al
l
M
Ma
an
na
ag
ge
em
me
en
nt
t
t
to
o
consolidate
consolidate
d
da
at
ta
a
f
fr
ro
om
m
d
d
i
i
v
v
e
e
r
r
s
s
e
e
g
g
e
e
n
n
e
e
r
r
a
a
l
l
l
l
e
e
d
d
g
g
e
e
r
r
s
s
y
y
s
s
t
t
e
e
m
m
s
s
and
and
l
KEY FEATURES
KEY FEATURES
Global consolidation featuresGlobal consolidation features
Scalable web architectureScalable web architecture
Smart dimensionalitySmart dimensionality
Complete audit trailsComplete audit trails
Powerful reporting and analysis toolsPowerful reporting and analysis tools
Financial Compliance
Financial Compliance
In Sarbanes Oxley 404 scenario, it is important to keep some things in mind
In Sarbanes Oxley 404 scenario, it is important to keep some things in mind
which help in the overall controls in the financial closing process.
which help in the overall controls in the financial closing process.
1. Has the m
1. Has the management documented the entire financial closing process inanagement documented the entire financial closing process in
sufficient detail from data collection to final report making.
sufficient detail from data collection to final report making.
2. Have control activities been docum
2. Have control activities been documented which define the controls realtingented which define the controls realting
to the financial closure process.
to the financial closure process.
3. Has a risk assessment been conducted to assess the inherent risks in the
3. Has a risk assessment been conducted to assess the inherent risks in the
closure processs.
closure processs.
4 How and by whom is the f
4 How and by whom is the financial closure process monitored. How isinancial closure process monitored. How is
completeness of the process determined.
completeness of the process determined.
5. How are com
5. How are communication procedures defined wmunication procedures defined which ensure a hich ensure a smoothsmooth
financial closure in a tim
financial closure in a timely mannerely manner..
The users of a
The users of a company¶scompany¶s financialfinancial statements ²investors, lenders, andstatements ²investors, lenders, and
management²wish
management²wish to see accurate results to see accurate results from the latest reporting period asfrom the latest reporting period as
soon as possible
HFM Lifecycle Overview
HFM Lifecycle Overview
Loading « Loading « 33 33 55 55 77 77 22 22 44 44 66 66 11 11 11 11 11 11 22 22 44 44 66 66 Server Server Calculate Calculate Adjust data Adjust data Translate & Translate & Consolidate Consolidate Lock data Lock data Approve data Approve data Load & Add dataLoad & Add data
Run & Publish Reports Run & Publish Reports
Financial Management
Financial Management
W
W
hat are the challenges we are facing?
hat are the challenges we are facing?
±
±
An incr
An incr
easi
easi
ng desi
ng desi
re to ha
re to ha
ve contin
ve contin
uou
uou
s,
s,
comprehensive planning and reporting
comprehensive planning and reporting
±
±
The chall
The chall
eng
eng
es/st
es/st
rugg
rugg
les of
les of
making (ex
making (ex
tern
tern
al)
al)
GAAP-based financial reporting
GAAP-based financial reporting
mesh with
mesh with
(internal) fund accounting-based reporting
(internal) fund accounting-based reporting
±
±
The sy
The sy
stems we
stems we
have/are
have/are
putting
putting
in are
in are
not all
not all
that conducive to this
that conducive to this
type of reporting
type of reporting
(for fund
(for fund
accounting, for higher education)
Financial Management
Financial Management
Financial Management comes bundled with three products that extend its
Financial Management comes bundled with three products that extend its
capabilities:
capabilities:
Financial Reporting is a reporting and charting tool for Financial Reporting is a reporting and charting tool for WWeb or printeb or print
distribution of financial reports.
distribution of financial reports.
Smart View for Office is a spreadsheet add-in based on Smart View for Office is a spreadsheet add-in based on Excel for reportingExcel for reporting
and analysis.
and analysis.
Shared Services enables user provisioning and sharing of Shared Services enables user provisioning and sharing of metadata andmetadata and
data among Financial Management applications or between Financial
data among Financial Management applications or between Financial
Management and other products.
Management, legal, and tax reporting
Management, legal, and tax reporting
Complex currency translations
Complex currency translations
Intercompany and minority interest eliminations
Intercompany and minority interest eliminations
Complete audit trails
Complete audit trails
Journal adjustments
Journal adjustments
Multidimensional analysis
Multidimensional analysis
Cash flow reporting
Cash flow reporting
Extensible Business Reporting Language (XBRL)
Extensible Business Reporting Language (XBRL)
reporting
reporting
HFM Artifacts
HFM Artifacts
Hyperion Hyperion Strategic Strategic Finance Finance Hyperion Hyperion Financial Financial Management Management Hyperion Hyperion Planning Planning Automated Automated Data Data Integration Integration
Between the Systems
Between the Systems
Using Hyperion
Using Hyperion
T
T
ools
ools
to Inte
to Inte
grate
grate
Detailed Detailed Budgeting Budgeting Strategic Strategic Modeling Modeling Financial Financial Reporting Reporting Distributed and Distributed and Customizable Customizable Modeling; Modeling; Real-time Access time AccessDifferent Levels of
Different Levels of
Data Detail as Data Detail as Relevant to the Relevant to the Different Needs Different Needs
