An Argument for Techie Accountants
My one piece of advice for the next generation of accountants right now is, enroll in some Computer Science courses. Learn to code. Learn how to manage a small server farm. Learn APIs, SQL, HTML5, JAVA, etc.
Drop that Poli-sci course right now.
Technical ntant’s best friend nowadays. It should be self-evident as to why. Data. Data. Data.
My first accounting gig was in a tax firm. We had an old mainframe crunching numbers and all the programming was in COBOL. In industry, reports would have all been generating output as text files; but who cares, there’s no ‘export to file’ function anyways.
Actually, that’s a good test. If you want to know whether your current software vendor is investing in the future of their product, look at the file output from your reports. If they come out as text files (you open Excel and each line of output is just one cell), this means the reporting architecture is really, really old.
It’s kind of like when you and your friends one-time go for an afternoon horseback ride. Inevitably, one person gets plunked on the beatest, tired old nag you ever seen. Yeah, technically she still rides but she ain’t even long in the tooth. All the teeth, they fell out.
Consider it the carbon dating of your accounting system.
You see, just because there has been consolidation in the ownership of companies in the enterprise software space does not mean the units have consolidated their products. Most units (purchased or raised) continue to operate independently. Revenues are generated from new sales obviously; but equally important, from a big, juicy installed base of maintenance contracts within the business units. You know that. And it’s fine. The amount of new investment in the product however, would be a corporate management decision from head office. Some products are the equivalent of that tired old nag.
Back to the point on technical skills though. Unlike back in the day, technology is no longer just auxiliary to what we do. It’s central and 100% pervasive. A commenter last week summed it up really well when I talked about the accounting tools:
“Three letters for you bitches, S to the Q to the mofo L.”
Getting a bit more techie will help you appreciate the humor in this quote. It’ll also help you recognize the tired old nag before you saddle up and ride.
In practice, normally we’re simply subject to whatever system happens to be installed. You deal with it, right? And that’s fine too. Recognition goes hand in hand with acceptance.
The reports kick out to Excel in text files; you find the delimiters, execute a ‘text-to-columns’ command, split up what you can and do your reporting. In the past, I’ve also had to occasionally create an Excel formula for pulling out text that’s really buried using the LEFT, RIGHT, functions. Then, I write a macro to automate as much as possible. Poor tired old nag.
Technology and data are just like riding a horse. With the correct instruction, you can get the horse to do what you want. But you’ll always be limited by what the horse is physically able to do.
If you don’t know anything about horses, this analogy might not make much sense at all. Which, I would say, just proves my initial point. Learn your technical skills now while you’re still in school. Leave all the fluffy horsebackriding and philosophy courses to the guys who’ll be serving you coffee after graduation.
In my view, technology skills are just as important for accountants as debits and credits. You may or may not like it, but it’s time to see how the dog food is made.
Enjoy.
Old farm adage: “If you’re going to have livestock,… you’re going to have deadstock.”
Geoff Devereux as been active in Vancouver’s technology start-up community for the past 5 years. Prior to getting lured into tech start-ups, Geoff worked in various fields including a 5 year stint in a tax accounting firm. You can see more of his posts for GC here.
Credentials for Accountants – Your Wheelbarrow Barrel Needs Tech Tools
Over the last couple months, GC has been profiling various accounting-related credentials. CPA, CFP, CMA, CIA, CFE, CVA, CFA… it’s a veritable alphabet soup of designations and employers are more and more likely to ask for a second helping these days. And you might want to pick up an MBA while you’re at it too. Y’know, in your spare time. In Canada, you can go ahead an //www.cga-canada.org/en-ca/Pages/default.aspx”>CGA, CA, and CBV to the mix as well.
Another day, another designation for yet another self-regulating body.
We’ve all heard of “grades inflation.” Well, in my view, we’re currently subject to “credentials inflation” at a rate that would make a Banana Republic cringe. In contrast, Zimbabwe Ben would likely nod in approval.
Beyond credentials though, there’s another critical piece in the employment puzzle that you would be well advised to consider as you venture into the field. Tools.
What are an accountant’s tools?
I’m not talking about the wheel barrel you’ll need to cart all those credentials to your job interview. I’m talking about the business software that more and more employers want pre-installed on their prospective employees.
At the entry level, it tends to be more of a ‘nice to have’ than a ‘must have’. But more and more, your progressive career path is affected by the type of tools you learn early in your career. There’s just no way to separate accounting and finance from the technology that facilitates accounting and finance work.
In the small business space, this is less of an issue. One small business accounting package is much like another. The “canned” reports (built in) will largely suffice, point and click. Just get yourself a healthy functional skill level with MS Excel and you’re ready to go.
Moving up into the enterprise, it’s a different story. The difference between having experience with Quickbooks versus SAP is akin to the difference between a degree from Eastern Michigan University and Princeton.
Think about that when you are venturing out into the job market for the first time. What are your aspirations? Where do you want your career to take you?
It’s difficult to blame employers for this predilection. Enterprise software is complex, subject to cryptic reporting languages, and training is expensive. The expertise is seldom institutionalized within the enterprise instead residing in the head’s of one or two key people. The “gurus.” Sometimes the expertise just walks right out the front door. It’s just way, way easier for everyone when “the new guy” can hit the ground running.
We may see this sad reality change in time.
Marc Benioff, CEO of Salesforce.com, is a key person leading the charge for change. He is an out-spoken advocate of the “consumerization” of enterprise software. In Benioff’s view, enterprise software should be as easy to use as Facebook and we’re seeing this manifest with every iteration of the Salesforce.com platform.
Unfortunately, Salesforce is the exception rather than the rule and the incumbent systems are deeply rooted in business. The technology “stack” as it’s called is built up over time and choices of enterprise systems are traditionally big, capex decisions. Change is rarely proactive and technology is normally kept well beyond the end of its useful life.
The complex enterprise systems will continue to be persistent for sometime to come. So be prepared to factor this into your career calculations. When you’re out there looking for work, ask the question of prospective employers. What systems do you use? Then, research that system to figure out its prevalence in the market: Are they using some niche software product built upon an ancient architecture? Is it a proprietary system that you’ll never see again? Is it a “legacy system”? Is it vertical specific?
Don’t underestimate the importance of these questions. No one has the bandwidth to learn all the tools currently offered. Examine your career aspirations carefully within the context of these technology tools because it can be difficult to backpedal. The tools you learn have just as much bearing on your career as the credentials you chose.
And inflation is a fact of life.
Geoff Devereux as been active in Vancouver’s technology start-up community for the past 5 years. Prior to getting lured into tech start-ups, Geoff worked in various fields including a 5 year stint in a tax accounting firm. You can see more of his posts for GC here.
Cautionary Tales: Enterprise Software Edition
A few weeks ago, I was talking about CRM (Customer Relationship Management) software. Essentially, CRM should help a company (as Dennis Howlett – business software blogger put it), “sell more stuff.”
I don’t have a problem with that result. We can argue all day long abo really “needed” as opposed to “pushed”. That’s a philosophical debate, indeed, it’s a MORALISTIC debate. In Obama’s address to the USA (re: BP oil sands) he prayed for a “hand to guide us.” Was he talking about the hand of god, or the invisible hand? … But I digress.
My point about CRM was much less lofty. CRM systems are simply about attempting to know your customer. How much data can we collate and analyze in order to maximize our value proposition? Or, if you’re a cynic – how can we, as Homer Simpson would say, “cram one more salty treat into America’s already bloated snack hole?”
Sidenote: Back in the heyday of the SUV craze, there was a great interview on 60 Minutes with some analyst/pundit who described the motivation that seemed to underlie the populating of these beasts. He described it as “reptilian.” The term stuck with me and I find it helpful to think about in around any purchasing decision of consequence. A well executed CRM can create a veritable “Jurassic Park” of suckers if that is what one is so inclined to create. Although, it doesn’t have to be that way. It doesn’t have to be evil.
My point this week though is less about CRM per se and more about what happens when an enterprise software implementation goes awry. A different kind of evil. There have been two big stories recently detailing lawsuits being leveled against firms who had been contracted to install an enterprise system and had allegedly failed to deliver on the contract.
In one case, EDS (now owned by Hewlett Packard) just agreed to pay British Sky Broadcasting $460 million for a failed CRM implementation. This was from a project undertaken in the year 2000 and abandoned two years later. The settlement is four times the value of the budgeted project cost.
In a second case, Marin County, CA is suing Deloitte Consulting for an alleged failure in rolling out an ERP (Enterprise Resource Planning) system. Marin County is seeking $30 million. Their contention is that Deloitte didn’t have the technical skills on the software in question. That’s an important point. This type of technical skill is of the “use it or lose it” variety.
So, is that the answer? When a software implementation goes awry, you sue everyone? Well, sometimes.
You see, buying an enterprise software system isn’t like buying a vehicle. You can’t just hand the wheel over to your reptilian brain and pray for the invisible hand to hook up financing and you’re on your way.
There’s work involved, normally a third party, that is paid to configure the software and integrate it into your organization’s existing infrastructure. In a complex business model, the process of defining and integrating all the business rules, data flows, and connections can be daunting… sometimes, impossible. Failure, unfortunately, is always an option.
These recent examples deal with alleged failures on the part of the third party implementers, but failures can occur anywhere within “hell’s half-acre.”
I’ve seen examples where it was clearly a management failure to provide project leadership that created an implementation failure. The example I am thinking about resulted in the company taking a $2 million dollar charge then having to start over. When I went to see them, it looked like they were heading right back down the same road. Making the same mistakes. Me? I can’t help someone who doesn’t want to be helped.
Some folks point to Saas products as a way to alleviate these nightmare scenarios. If only it was that easy. Wherever a business has an existing IT architecture, there is the possibility of an integration problem (assuming you want integrated systems which I have to believe that you’ll want). There is another company I can think of who, when I met them, had been working for at least 6 months on an integration with a Saas ERP system and their back office. For a number of reasons, it really just didn’t seem like it was going to work. And the red flag for me was that the CFO and the Director of Finance had vastly different views as to how the project was going.
These are just a couple examples I can name from my own experiences and I’m not even in the software implementation game!
The moral of the story is know the statement of work inside out. Understand the terms of the contract. Technical skills are finite. Be very clear on the desired outcomes.
And beware of the reptilian brain.
Geoff Devereux as been active in Vancouver’s technology start-up community for the past 5 years. Prior to getting lured into tech start-ups, Geoff worked in various fields including a 5 year stint in a tax accounting firm. You can see more of his posts for GC here.
The Technology Productivity Bureau Accounts for All Stakeholders
We all know about getting a credit rating. Whether it’s for a personal credit card, a supply chain vendor authorization, or the much maligned oligarchy who rate public companies and entire nations. Based on al ion, a score is developed that (attempts) to capture the inherent risk of a credit failure.
How much could firms benefit from getting a Technology Productivity Rating?
What is the risk of a technology failure?
If an objective ratings agency existed that scored a company’s use of technology, how well would other people score your company? Who is the ‘Greece’ of technology?
To rate technology productivity, the rating has to encompass the entire organization and the way in which technology extends to external stakeholders (customers, suppliers, staff, etc). Optimal productivity from technology doesn’t simply mean newest technology. It’s not just about what technology a company uses that matters. It’s about how the technology is used. I met with a colleague in the technology industry recently who went so far as to say there’s still times when a FAX is the optimal technology for a task. It depends on the potential outcomes and workflows.
To date, I think the focus of technology productivity has been too inwardly focused in companies. Companies say, ‘How can this technology benefit us?’ instead of looking at the workflow effects for external stakeholders too. Granted, most organizations are completely overwhelmed simply by this one-sided approach. But if you look closely at some productivity software, part of the “technology” benefit is actually a workflow transfer to external parties. If I had to rate the technology, the score would decline in the event of workflow transfer being masqueraded as technology.
For example, look at productivity tools around supply chain management and recruitment:
Supply Chain Management
As a means to increase productivity, big companies implement supply chain management systems that effectively transfer the burden for account administration to the vendor companies (sometimes they even charge a fee!). For the implementing company, it is great. All the vendor information is keypunched and filed away into the database for free.
The system integrates with the ERP for invoice approvals all the way to point of payment. The internal technology productivity score is high. For the vendor, every new customer could conceivably mean a similar routine resulting is a productivity loss and therefore would rate the technology lower. A vendor with a lot of customers practically needs a Mechanical Turk just for the data entry!
Seeing these scores could be really beneficial when vendors are choosing what customers to prioritize.
Recruitment
Recruitment technology can be burdensome to external stakeholders while being helpful to internal stakeholders in a similar way. The key to recruitment technology is capturing candidate data to enable filtering and search. Some technology in this field is simply transferring the data entry task to the candidate. Each candidate types out their life story field by field, row by row. From the company standpoint, they see the output of the technology. It is good. From the candidate standpoint, they see a time sink.
Taken in isolation, this candidate time commitment is not a big deal. One candidate typing their qualifications one time in response to one job posting is fine. But what happens when the candidate is applying at a dozen jobs? Two dozen? At what point does the opportunity cost of doing a whole bunch of data entry deter the brightest candidates from these particular employers?
The brightest candidates will apply to the companies that DON’T require a massive typing drill first, selecting away from this less productive technology until it’s unavoidable. The overall technology productivity score would take this into account.
For a company purchasing new technology, understanding the opportunity costs both from your perspective and that of external stakeholders and developing a Technology Productivity Rating may not become a formal process. There is no Technology Productivity Bureau, or least, there isn’t anymore. There was… for a short time… an idea before its time… may it rest in peace.
Perhaps it’s enough to look at it from a more macro-level. Ask yourself, is my business technology liberating for stakeholders or, or are they being repressed? Then, act accordingly.
Geoff Devereux as been active in Vancouver’s technology start-up community for the past 5 years. Prior to getting lured into tech start-ups, Geoff worked in various fields including a 5 year stint in a tax accounting firm. You can see more of his posts for GC here.
Customer Relationship Management – Know Your Customer, Know Yourself
The first rule of business is “know your customer.” So, how do you do that?
This is the question that brings you into the field of CRM (Customer Relationship Management). I remember working in a tax firm back in the early 2000s and all client correspondence was hardcopy in the file. Our “CRM system” was rows of filing cabinets.
A sales forecast? rked at a company where the sales forecast was an excel spreadsheet that physically gave me vertigo just looking at it. Updating that thing was like a game of Tetris.
A “real” CRM system consolidates all of your company’s customer interactions and sales activities into one database. It enables sales and marketing to detail the entire sales process from Lead to Close. And now it’s the difference between “knowing your customer” and living in the dark ages.
I only started seeing these systems spring up in mid-sized businesses a few years ago. How much are you guys seeing CRM out there now? Does your CRM system integrate with your other business systems? Or is it more of a Contact Manager?
For example, I have seen an instance where the CRM software operated as its own sphere of information. Then, we had the company financial information as its own separate sphere. To connect the sales pipeline info (from the CRM) to the financial results was a manual task.
I’m throwing it out there because my own experience with CRM in the SMB/SME space is limited to using Salesforce.com. I spoke about them briefly when I introduced Saas and Cloud Computing a few weeks ago. I must sound like a Salesforce salesperson but I’m not. I just found that Salesforce 1) put CRM on the radar for the SME I was working for at the time and 2) was inexpensive and easy to deploy.
The other main Saas CRM play is Sugar CRM. Both Salesforce and Sugar CRM have free versions. A very small business could probably operate on the free version for ever. Most mid-sized businesses could use the free version to test the fit of the product’s process flows before committing to rolling it out throughout the business.
In large enterprise, the CRM is probably big enough to just be called “the system”. Let’s say you are working for a bank or an insurance company. “The system” knows things. Next time you are speaking to a call center representative, ask for a summary of your own history. You might be surprised what details are lurking within the system. These can be simply contact histories or can also incorporate decision-making capabilities (i.e. loan or credit card approvals).
Retailers capitalize on this technology through the use of Loyalty Programs.
The real power behind CRM, for those not currently using this type of software, is the ability to clarify the sales pipeline and to consolidate customer interaction. You can detail right from Cold Call to Close and you can get the analytics to visualize the process too.
We’re right on the cusp of even bigger innovations in this field. Just look at some of the things Google is doing right now with respect to data and data visualizations (Google Trends – Google public data – Google Analytics). Sentiment analysis is appearing to gain traction as well. To blow all that out into the CRM realm means really powerful insight into customer behavior.
The success or failure of the CRM is linked directly to the quality of data in the system. This is where the “know yourself” bit comes into play. Where you can automate, do so. Trusting a salesperson to voluntarily do data entry is like trusting your road-trip navigation to a poet. Not good. Again, great strides continue to be made here. Between the increasing migration of transactions and activities online, and the tools allowing for Salesforce Automation (SFA), the direct maintenance on this type of system can be minimized.
For those of you unfamiliar with CRM technology, maybe you’re working in smaller companies or companies with a legacy of paper-based CRM, Saas solutions like Salesforce and Sugar CRM are worth checking out. It’s a place to start. And it’s free to start.
We would really like to hear from you on this issue as well. What has your experience been with CRM?
Geoff Devereux as been active in Vancouver’s technology start-up community for the past 5 years. Prior to getting lured into tech start-ups, Geoff worked in various fields including a 5 year stint in a tax accounting firm. You can see more of his posts for GC here.
Cloudsplitting: Recognizing the Tech and Business Cloud Narratives
Cloud Computing can be an intimidating subject area simply due to the sheer number of articles, blogs, conferences, and information on the matter. My goal in this post is to split the discussion based on the perspective of the writer.
While researching this post on “Cloudsplitting”, I became formally acquainted to the concept of an unreliable narrator:
“a narrator, whether in literature, film, or theatre, whose credibility has been seriously compromised.”
The nature of the narrator may be immediately clear or it may be revealed later in the story. Sometimes it is revealed at the very end, at which point you find out your narrator has been totally unreliable! This makes yo story… which you should…. the guy was unreliable.
I think it’s a great concept! The first example that jumps to mind would be Kevin Spacey’s character in The Usual Suspects (Warning: Swears… Gonzalez sized swears).
I stumbled on the concept, the actual term, thanks to Cloudsplitter, the book. It’s a fictional retelling of Harper’s Ferry from the FICTIONALIZED point of view of John Brown’s son.
The author, Russell Banks, creates new context around the real events through his imagining of what Owen Brown’s views might have been. In this case, John Brown comes off as a lot less crazy than he may have come off otherwise.
(It’s also a hill in upstate NY near Bank’s home – ‘Tahawus‘ is the native Algonquin name for Mt. Marcy – the highest peak in the Adirondacks. It translates to ‘Cloudsplitter.’)
Emotional attachment and years of hermit-like isolation warp the perspective of our fictional version of Owen Brown. Unreliable. Quite frankly, I’ve seen the same in business.
I don’t want to fall for the same mistake.
We’re not hermits holed up in a cabin somewhere living on bottled water and beef jerky.
That’s one of the biggest differences between the introduction of Cloud technology and the introduction of previous computing technology. This time around information abounds. Whereas in the past, information about new technology was carried through very limited channels. And even then, it may have traveled indirect routes.
With our proliferation of information, it’s more important than ever to consider the source of the information. After all, the greatest trick the narrator ever pulled was convincing the world he didn’t exist…. or something.
Be it me and my Cloud Computing story or the guy at your office who waves his arms and decries this “parlour trick” technology.
Where is your information coming from?
I’ll point you to a few resources in a minute that, hopefully, will pass the narrator reliability test. First, if I may, I want to take the opportunity to split Cloud Computing into two separate camps.
In one camp, we’ll have Techie Cloud. In the other, we’ll have Business Cloud.
Techie Cloud:
This is the stuff relating to the functioning of a cloud environment. What’s the architecture? Where’s the data? How do I manage it?
It’s the kind of stuff your Systems Administrators and DBAs and IT Managers would want to know. For instance, I want to play around with Amazon Web Services to create a new computing environment. Do I need any special tools to work there?
Yes, there’s a front-end tool called Rightscale that makes creating a computing environment easy.
While interesting from an academic perspective, your average business user will probably get limited value from seeking out tonnes of information about Techie Cloud. Recognize it when you see it.
Business Cloud:
This is the stuff relating to using cloud-based software. The business user who is looking for a “consumerized” web experience. What does it do? Is it easy to learn? What’s the cost? How do I sign up?
It’s the kind of stuff the accountants, marketers, and salespeople would want to know. For instance, I want to find a way to manage my team’s projects. Can I get going with something quickly?
Yes, try Basecamp.
And Business Cloud is separate from the business of cloud which we’ll get into later.
The reason I am going around Cloudsplitting is because the content I’ve been finding lately doesn’t discriminate with respect to audience. You are as likely to jump into an article that’s geared toward IT as you are to find an article for a Business User’s perspective.
Forward the Techie Cloud articles on to your IT departments. There’s a view out there that Cloud is going to make IT deparments obsolete. I disagree. I think Cloud will free up IT from the mundane custodial services of server maintenance becoming a more strategic partner with management. I’ve written before about accountants being the dishwashers of business. We’re the dishwashers and IT are the custodians (or janitors if you want to be unkind about it).
And remember:
Evaluate the reliability of the source. Evaluate for audience.
Techie Cloud
8 Tips for Getting Started in Cloud Computing (by Rackspace)
What Does the Future Hold for IT? (Bloomberg)
Cloudcamp – formed to provide a common ground for the introduction and advancement of cloud computing
Business Cloud
ICPA Trusted Business Solutions (CPA2Biz) – all of these are Saas offerings
Tourist in Techie Land: Reporting from Cloudcamp Vancouver (me)
IBM CTO at Interop: Consumerization of IT is a Driving Force (ZDNet)
Geoff Devereux works in a marketing/social media role with Indicee, a Saas Business Intelligence company, bringing B.I. to mere mortals. You can see more of his posts for GC here. H/t to Jesse from Cloudsplitter Mountain Guides for the translation and Greg_Smith for the pic.
It Was a Dark and Stormy Night…or: Cloud Computing and SaaS Briefly Explained
Figuring out how to sum up Cloud Computing and Software as a service (SaaS) in the space of ~800 words would absolutely require the biggest, puffiest, most cumulus metaphor that ever precipitated understanding over the dry, barren plains of ignorance EVER! Something like….