Thursday, May 24, 2012

Financial Dashboards

Over the years, working with Finance people, they constantly ask for these metrics.

They are usually interested in Period to date, Quarter to Date, Year to Date and Trailing 12 months numbers. And they like to know the actuals, budgets, variance between actuals and budgets, Prior year numbers and year over year growth or decline as the case may be.

So when working with these folks, if you can build these metrics proactively, you will win the trust of the teams in accounting and finance.


PeriodMay-12
Actuals-Current YearBudget/Plan-Current YearVariance (Actuals-Plan)
MetricPeriod to DateQuarter to DateYear to DateTrailing 12 MonthsPeriod to DateQuarter to DateYear to DateTrailing 12 MonthsPeriod to DateQuarter to DateYear to DateTrailing 12 Months
Metric1------------
Metric2------------
Metric3------------




PeriodMay-12
Actuals-Current YearActuals-Prior YearYear Over Year
MetricPeriod to DateQuarter to DateYear to DateTrailing 12 MonthsPeriod to DateQuarter to DateYear to DateTrailing 12 MonthsPeriod to DateQuarter to DateYear to DateTrailing 12 Months
Metric1------------
Metric2------------
Metric3------------

No comments:

Post a Comment