It would seem self-evident that accountants enjoy dealing with numbers, but those who may not have worked in large corporations would be shocked by the number of meetings that occur arguing over whose version of data is correct. Just answering a simple question like “how profitable is customer x to us” is a nightmarish task in large companies, because business to business enterprises have data about customers scattered throughout a raft of different computer systems, and may not account for costs uniformly across the enterprise. This is not isolated to a few backward companies: a friend of mine who used to work for Goldman Sachs confirmed that if they wanted to know how much business they did with a major corporate client then it was a significant project to gather this information from around the corporation. This is especially a problem with global companies, whose operating subsidiaries and structure may be opaque. For example, Calvin Klein is owned by Unilever, but how many people know that? Consequently it is easy to see how a company supplying Calvin Klein may not necessarily record that information as actually being linked to Unilever. There are many, many examples like this, which would cause issues even without the problem of uniformity of cost allocation across an enterprise.
An article in Accounting and Finance mentions the notion of the “data driven CFO”, which alludes to the notion that CFOs these days really need to get to grips with this kind of issue. Not only are they under pressure to answer questions from their business colleagues about corporate performance (such as “how profitable is customer x to us”) but they also have to contend with increasing regulation such as Sarbanes Oxley and various industry specific rules such as Basel 2 in banking, or FDA rules within life sciences. People often gripe about such regulations, but there are some sound reasons for them. An amusing example of the need for the latter was a discussion my wife (who worked at Smith Kline Beecham at the time) shared with me. SKB had an anti-worming drug which they decided was not worth marketing to humans for technical reasons, but were pondering whether it could be usefully put into pet food, since dogs in particular have a lot of problems with worms. After much ferreting around, it turned out that this could not actually be done because in fact a scary percentage of people actually eat dog food, and so it would have to go through the same regulatory regime as if it was for humans (as an aside, I found this quite surreal, but when I mentioned it at lunch that day at Shell, two of the five people at the table admitted to having eaten dog food; if you think I am joking see the internet for recipes involving pet food).
The point is that the regulations are a fact of life and are increasingly specific about the auditability of reported data. Much of which may involve reconstructing past history at some point a few years back. Now if a company can’t tell how profitable a customer is without a significant effort, just how easy will it be for them to answer a question regarding profitability four years ago, since when the business has probably restructured a couple of times? I suspect that there are a lot of increasingly nervous CFOs out there, who my be sorely tested if they actually have to go back and reconstruct historical data. Yet even apart from regulatory compliance, for departments such as marketing really need to understand trends over time in order to be effective. How many of these are getting the trend data that they need from their finance groups? As pressures increase for performance improvement, more and more CFO departments are going to have to become more data driven in years to come, like it or not. Let’s hope their suporting systems can deal with such requests, or they will spend a long time barking up the wrong tree.
Spot on Chris. Conventional technologies do not make it at all easy to do the “time variant” analysis which business increasingly demands.
One of the major problems with finance departments is that they do have a lot of data, but it is backward looking and often in a management accounting format that may once have been relevant to the way the business was run, but is no longer. Trying to get from this “accounting data set” to a forward looking data set that can be used to support commercially focussed activities such as planning, doing what-ifs and looking at different options is always a struggle. And unfortuantely the effect of SoX seems to be an enormous increase in the size of most firms accounting data sets at the expense of their commercial useful data.