The Indicee Blog

Accounting for I.T. in the Finance Department

by Geoff Devereux on March 10th, 2010

An Interview with Wendy Van Donkelaar; CFO at MAKE Technologies

Last week, we were talking with Cheni Yerushalmi, co-counder of Sunshine Suites, about Measuring What Matters.  I think the main takeaway, from an Indicee point of view, is that the company’s Financial Reports were deemed much less important to the running of the business than were Operational Measures.

Today, we’ll move away from some of the broad philosophical implications of the question, “How do you measure success?” that we tackled with Cheni and move into the practical side of what measurement tools are being employed in mid-sized businesses and what measures are considered important in a conversation with MAKE Technologies CFO, Wendy Van Donkelaar.

MAKE Technologies Inc. is a Vancouver based software solution provider that analyzes and modernizes all three aspects of legacy enterprise applications: business processes, source code and data. MAKE’s modernization platform, TLM, helps their global customer base to reduce the cost & risk required to maintain and modernize their mission critical systems.

Wendy Van Donkelaar is a Financial Executive and Chartered Accountant with over 20 years experience in the technology sector.

I was interested in getting her take on the role of I.T. Systems for keeping tabs on the health of the business through the use of reports and KPIs.  What I found was, 1) she is strapped for time just like every other Finance Manager I’ve met over the past 10 years, and 2) she employs a number of tools to get the answers she needs to effectively manage the company’s finances.

So, here’s the Q & A:

1. How do you analyze operational performance? We use SFA [Salesforce Automation], SA [Simply Accounting] and excel spreadsheets to analyze performance.
2. What are the critical operations KPIs? Net new license and services revenues, Sales Funnel growth, Professional services utilization and G/M [Gross Margin], # of partner deals, # of presales presentations per quarter.
3. Do you analyze results on a project-by-project basis? Yes using an excel spreadsheet we are currently evaluating project management systems.
4. How is the Finance function changing/evolving with the onset of new technologies? The function has changed from one of historic information gathering to one of predictive analysis.
5. How do you view the role of spreadsheets in your line of work? Used for summarizing weekly Dashboard metrics and Board reporting.
6. Has your view of spreadsheets changed over time? How so? In my past, spreadsheets where often used for gathering and collating data so that analysis could then be performed.  It now seems like that step has been taken care of by SFA, SA or ERP [Enterprise Resource Planning] tools and I focus on smaller sets of data for analysis.

What does it all mean, man?

I’d like to highlight a few things in Wendy’s responses that, in my view, have a profound impact on all of us.  Call them sweeping generalizations if you must, but I see these responses as indicative of the typical situation for those of us working in mid-sized companies doing the accounting.

First, we’re living in a multiple-systems world.  By and large, when we are producing reports we are doing so by gathering data from various systems and collating that data into a cohesive picture of the enterprise.  The systems tend to operate independently of each other.  And inevitably, excel becomes the default aggregator.  Is this your experience? Make a comment!  What systems are you running and how do the systems integrate?

Second, inside the business, operations reports trump financial reporting any day of the week!  Check out the answer to question #2.  Of seven measures given, only one is truly a GAAP number.  Compliance dictates spending a great deal of time on Financial Reports, but these don’t provide actionable data in the same way that things like capacity utilization, or net new business, or sales pipeline does.  Share some of your operational measures in the comments!  What’s the focus in your workplace?

Third, predictive analysis has become mainstream.  There was a time that this topic was reserved for B.I. technicians, I.T. analysts, and academics.  More and more it’s becoming a practical requirement from management.  So, how do you management your predictions?  What oracle are you consulting? How many tea leaves must be read?  How can we know the future?

Let’s get some comments going!

  • Share/Bookmark

The Importance of Stories

by Geoff Devereux on December 23rd, 2009

This time of year provides tremendous illustrations of the power and importance of stories.  From the stories that constitute our most core personal beliefs of the holiday season to those that detail running the gauntlet of inclement weather and travel delays to get “home for the holidays”, we define ourselves and others by the stories we tell.

As George Akerlof and Robert Shiller discuss in their widely acclaimed book, Animal Spirits (How Human Psychology Drives The Economy, and Why It Matters for Global Capitalism),

“The human mind is built to think in terms of narratives, of sequences of events with an internal logic and dynamic that appear as a unified whole.  In turn, much of human motivation comes from living through a story of our lives, a story we tell to ourselves and that creates a framework for motivation.  Life could be just ‘one damn thing after another’ if it weren’t for such stories…. Great leaders are first and foremost creators of stories.”

Think about the stories that define your life.  How do these stories influence your perspective?  How do they influence how you see yourself?  What are the stories that resonate most strongly in your life?  What stories do you choose to relate to other people?  There’s a growing body of knowledge, that aligns with the passage above, saying these stories are fundamental to the formation of our identities.  This is a powerful thought.

Yet, traditionally in accounting and finance, stories are an afterthought.  We are taught to focus on the numbers.  We create the balance sheet, income statement, and cash flow statement in accordance with GAAP, leaving storytelling to the sales and marketing departments.  My experience has been that it’s very difficult to generate engagement through the use of the financial reports, and in retrospect, I think it’s for this reason.

There’s a reason why people say the Notes To The Financial Statements will tell you “where the bodies are buried”.  The reason is that only in The Notes do we find stories.

From a regulatory perspective, for external reporting we’re fairly hog-tied as to what we can do.  GAAP is king.  These constraints are institutionalized and provide a structural grounding for capital markets that is required for a host of reasons.

Internal reports, on the other hand, present a tremendous opportunity to begin using stories to provide context and colour to business results.  This is the area of accounting and finance where we can really affect some change NOW by bringing life to the numbers.

In the following clip, Ira Glass (son of an accountant and award winning host of This American Life on Chicago Public Radio) describes using anecdotes to convey ideas and says,

“the power of the anecdote is so great, no matter how boring the material is, if it’s in a story form where there’s an anecdote happening,  it has a momentum in and of itself… like being on a train that has a destination”

(hat tip to Presentation Zen blog for a good post on this same clip)

Ira Glass summarizes the process of telling a story as:

1. Start with an action

2. Raise a question from the beginning (the bait)

3. Answer the question

4. Repeat

5. Moment of Reflection (the “why”)

Enjoy!

  • Share/Bookmark

Running the gauntlet of Year End Business Reporting

by Geoff Devereux on December 9th, 2009

Last week, as I was attending the annual IDC Predictions Telebriefing for 2010, I think I finally realized the true difference between Accounting and Marketing.  The difference is that while Marketing is already thinking well into 2010, the Accounting Department is just gearing up for 2009 Year End activities.  IDC, as you may or may not know, is one of a handful of extortionist trusted prognosticators on all things technology related and indeed on most topics of interest related to business trends, market dynamics and analysis in general (others include Gartner, Aberdeen, Forrester).  These guys are to the Marketing Department what the Ratings Agencies are to the Finance Department.  There’s a certain obligation to include these guys… for good or ill.

“Buy the ticket, take the ride” – Hunter S. Thompson

Now, this isn’t a critique of the inevitable conflicts (real and perceived) inherent between these various groups.  Nor is it a post about the differences between Accounting and Marketing.  In order to do that, I am missing one critical piece.  My good friend Dan’s “Top Ten Differences between Accounting and Marketing List“.  Maybe with your help, readers, we can convince him to give it up.  Add your thoughts in the comments section!

NO.  This post is about posing a simple question:

How are your Year End spreadsheets doing?

Year End is upon us!  Everyone knows, thanks to these accounting blogs:

Everyone knows that Audit Professionals have been raked over the coals of more stringent regulation and oversight the past few years (for all the good it’s done!).  And, if my experience is at all representative of our collective experience on the industry side, the auditors have been passing all of that regulation onto you!

Preferred method of passing = The Paddlethe paddle

The paddle will be heading your way again soon enough.  Time to rollover all those Year End files and clean up for prepping 2009’s close.  The rigors of financial reporting compliance are staring us right in the face once again.  Oh, and Merry Christmas by the way.

Of course, I think that if the past 2 year’s have taught us anything, it’s that regulation is ineffective in preventing fraud.  I would like to know where Frank Abagnale jr. stands on this issue.  Abagnale is the character upon which the movie Catch Me If You Can is based and for the past 35 years he’s been helping the FBI, businesses, and government cope with matters of fraudulent activity.  I highly recommend his book, Art of The Steal, for anyone interested in learning more about specific industry-related fraud risk.art of the steal

  • Share/Bookmark

SaaS…The Holy Grail?

by Mark Cunningham on January 19th, 2009

During my daily Twitter feed scan I came across a poll published by Shawn Rogers (@shawnrog – Editorial Director of the Business Intelligence Network) on what technology will impact business intelligence the most in 2009. At first, I was most intrigued with the post because I wanted to see how he created a poll on Twitter!  Turns out that @twtpoll has created a cool little application for creating these types polls.  But after following the poll for a week I became more interested in the results. As of January 19 the clear leader was Software as a Service(SaaS).

  • Share/Bookmark

Indicee and Excel

by Mark Cunningham on September 23rd, 2008

I often get asked how we position ourselves with respect to applications that live in the office suite (i.e. Excel or Access). After years of developing Business Intelligence (BI) tools and applications this topic comes up continuously.  The simple answer is that we are really a complementary application.

  • Share/Bookmark
RSS Twitter