Please ensure Javascript is enabled for purposes of website accessibility

An Argument for Techie Accountants

Posted on by GoingConcern

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 skills are an accountant’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.

Related Posts

The Future of Forensic Accounting is Now

Ed. note: Welcome to the first edition of Going Concern’s Guest Blogger series. We’ll be featuring both seasoned and new bloggers to share their views on various accounting topics. If you’re interested in participating, email us your submission to [email protected]. Please include “Guest Blogger Submission” in the subject line.

Imagine being able to take tens of thousands of pages of financial data and get it into a database in a matter of hours. Those mounds of paper are quickly turned into something useful to the forensic accountant, without spending hundreds of hours manually inputting the data. Financial data is suddenly transformed and the forensic accountant can quickly map the flow of funaction patterns, create charts and graphs that show entities and transactions of interest, and create customized reports.

Doing things the old way, such a result is only a fantasy. For decades, forensic accountants have spent their time manually sorting documentation, deciding which transactions are important, and doing data entry.

It sounds painful because it is. It takes a long time, there is a high risk of inaccuracy, and there is a great chance that an important transaction will be overlooked.

So if there is technology out there to change all of this (and yes, there is!), why aren’t forensic accountants using it?


The only real answer is that they’re afraid of changing their business model. Most accounting firms charge their clients hourly fees, so they are invested in a business model that is dependent on forensic accountants taking more time to perform work which results in more revenue.

Technology that nearly eliminates the need for teams to spend hundreds of hours analyzing financial documentation is not a welcome addition to the firm; it just causes them to lose money.

Of course, it’s not really true that such advances really cause forensic accountants to lose money. All that needs to happen is firms have to find different ways to bill their clients, rather than simply adding up the time of staff and multiplying by a big number.

In addition to this paradigm shift related to billing clients, technological advances also fundamentally change the way forensic accountants investigate fraud. That makes lots of them (especially the old timers) uneasy. After all, we’ve always done it this way! How can we rely on technology over our own hands and eyes?

Here’s the thing…. those forensic accountants who resist embracing technological changes are going to be left behind. I currently use a proprietary system to complete large forensic accounting engagements, making it possible for me to single-handedly do more investigative work in a few days than a team of 4 or 5 investigators can do in several weeks or months.

This is not a fantasy; it is my reality. And my clients are getting better results much faster, allowing them to plan their litigation strategy much sooner, and ultimately be more successful in finding fraud, defending regulatory actions, and competing in litigation.

Yet I am currently the only forensic accountant in the private sector using this system, or anything like it. The government has been using a similar system for years, and if a client is being investigated by a federal agency in a financial matter, there’s a good chance the government is using the latest technology to aid in their investigation.

The future is not going to wait just because so many forensic accountants don’t want to change how they investigate fraud or earn their money. Those who are unwilling to change are going to be left behind. Those, like me, who want to be on the cutting edge, will make more money and win more interesting engagements that previously may have been too large or complex for me to handle alone.

Tracy L. Coenen, CPA, CFF is a forensic accountant and fraud investigator with Sequence Inc. in Milwaukee and Chicago. She has conducted hundreds of high-stakes investigations involving financial statement fraud, securities fraud, investment fraud, bankruptcy and receivership, and criminal defense. Tracy is the author of Expert Fraud Investigation: A Step-by-Step Guide and Essentials of Corporate Fraud, and has been qualified as an expert witness in both state and federal courts. She can be reached at [email protected] or 312.498.3661.

Automation Will Replace Accountants Who Don’t Even Want Their Jobs, Says Guy

Although the show ended seven years ago (yeesh, where has the time gone?), I regularly […]

Do You Want Your CPA Filing Tax Returns From an iPad?

Technology is a beautiful thing. It makes our lives easier, including work. It gives us supremacy over our late-to-adopt friends and colleagues who are still stuck with clunky old company laptops. And apparently it makes it easier to lug around several devices than just sit at our desk with one. Somehow this is more convenient, but we’ll get to that in a minute.

Check out this revolutionary, wielding his iPad as a weapon in the war against April 15th 18th:

With the 2011 tax season in full swing, accountants and CPAs are searching for ways to save time and service geographically separated clients. A popular solution, QuickBooks hosting, allows for CPAs to securely access QuickBooks and client data remotely from any computer, phone or tablet with an internet connection. Recently, NovelASPect’s client, Scott Sanders, CPA, took QuickBooks hosting to the next level. Scott added his tax software to his QuickBooks hosting account on a NovelASPect virtual server. Using the Citrix receiver, Scott can now access his tax software from anywhere with his iPad. He then paired his iPad with his iPhone via Bluetooth to use the iPhone as a mouse for the iPad.

“Accessing my tax software and QuickBooks via my iPad has been a tremendous time saver,” says Scott Sanders. “Clients can review and sign their tax documents at their location. I can then efile the return with the government and email a copy of the tax return immediately to the client. I also have access to client financial information in Quickbooks anytime / anywhere.”

Quick question: can’t a laptop do the same exact thing?

Remember last June when 114,000 iPad user accounts were exposed by rogue Internet security group Goatse Security? Not to mention the fact that the iPad is not only a target of hacktivists looking to prove a point but also thieves who would love to get their hands on that overpriced toy you insist on playing with on the subway.

Here’s the issue I see with on-the-run tax preparers MacGyvering their iPads to shoot the data off to the client and then to the government from just about anywhere: WiFi is not always secure. We assume Scott Sanders knows a thing or two about protecting sensitive data if he’s knowledgeable enough to figure out how to use his iPhone as a mouse for his iPad (and what’s wrong with using a laptop and a, oh I don’t know, mouse?) but I would not want my tax preparer sending me my 1040 to sign; he can barely wash his grungy white dress shirt separate from his red socks.

I’m all for convenience but there’s a point when the work required to make it safe for all involved parties becomes inconvenient.