ThinkTWENTY20

  • HOME
  • ERIC'S BLOG
  • FORUM
      • Hey! What's New?
  • ABOUT US
  • REGISTER
      • ThoughtLeader Gateway
  • EVENTS

Should Financial Professionals Know How to Program? or Data Analytics: Accountants Should Understand Them and Have Toolsets to Perform Them

on 21 May 2020

Does every financial professional need programming skills? Some would say yes.

With the release in 2015 of the second series of the American Institute of Certified Public Accountants’ (AICPA) Audit Data Standards, the AICPA asked the question, “Should Accounting Students Learn to Code?” (1) The question, related to new or existing CPAs/CAs, keeps coming up – from the CPA Canada (2), ICAEW (3), and others. 

Now with guidance on the need to up the game in Audit Data Analytics (4), the days of being able to simply create macros in Excel or leverage tools like Tableau (5) may be coming to an end. And it is free software with names like R (6) or Pandas for Python (7) that seem to be leading that pack.

I am not a programmer (although “I play one on tv”.) I cut my modelling teeth with Lotus 1-2-3 nearly 40 years ago. When I was creating forecasts in Lotus, the day flew by. I’ve done some mini-programming here and there: macros, of course; a year developing proprietary point-of-sale integration tools with Basic for Unix; a few years developing VBA solutions in Microsoft Access. Still, I deny being a developer (and developers would say I am an accountant, albeit a “technical” one, and not a developer); however, recapturing that original thrill is something I have felt again recently. 

The University of Illinois at Urbana-Champaign-Urbana offers a course through Coursera called Accounting Data Analytics with Python. Geared toward accountants and not programmers, it introduces an integrated environment for writing, testing and executing programming code, intermixed with documentation, called Jupyter Notebook.

Jupyter Notebook is a coding and documentation tool. Not a hard core programming environment, it lets you document text using a markup method called Markdown and intersperse the text with others “cells” in which you create and run your code. With Python add-ons, you can automate tasks such as pulling information from PDF trade documents, CSV export files from accounting systems, or reading, analyzing, and updating Excel spreadsheets.

Certainly, learning Python or R may not be relevant to everyone. You may have other resources to help you “automate the boring stuff” or do more complex analyses of your clients’ data to be competitive. Artificial intelligence may advance quickly enough that our computers can interpret our interests and code for us. But you, or people in your organization, may take to these free tools and help your organization be more competitive and agile.

(1) https://www.aicpa.org/interestareas/accountingeducation/newsandpublications/should-accounting-students-code.html

(2) https://www.cpacanada.ca/en/business-and-accounting-resources/other-general-business-topics/information-management-and-technology/publications/coding-important-for-cpas

(3) https://ion.icaew.com/technews/b/weblog/posts/should-accountants-be-able-to-code-in-r-and-python

(4) https://www.cpacanada.ca/en/business-and-accounting-resources/audit-and-assurance/canadian-auditing-standards-cas/publications/audit-data-analytics-resources

(5) https://www.journalofaccountancy.com/issues/2020/mar/microsoft-excel-vs-tableau.html

(6) https://www.r-project.org/

(7) https://pandas.pydata.org/

Leave a comment

    Comments

    • No comments found
    Powered by Komento
    Forum Recent Posts
    The Independent Review Committee on Standard Setting in Canada Issues it's Final Report.
    Wednesday, 01 March 2023

    English

    Media Release – Independent review concludes, setting the stage for the future of Canadian accounting, auditing, and sustainability standard setting (frascanada.ca)

    The Independent Review Committee on Standard Setting in Canada issued its final recommendations report. The recommendations aim to ensure Canadian accounting and auditing – and now sustainability reporting and assurance – standard setting continues to be independent and internationally recognized. A summary feedback statement will soon be issued, outlining the feedback the committee received during its consultation process.

    New Limitations for External auditors and Their Reliance on the Work of Internal Auditors
    Monday, 27 February 2023

    The recent proposed rules from the PCAOB updating the confirmation standard, AS2310, caused some ruffled feathers when it added new limitations related to the external auditor and reliance on the work of internal auditors. Where the existing 2310, which was developed in large part by using the AICPA's AU 330 almost verbatim, pointed to existing standards related to the external auditor and their reliance on the internal auditor (AS 2605), the new proposed AS2310 added specific restrictions; these include not letting internal auditors select the population, do the mailings and receive responses.

    ThinkTWENTY20 © 2023. Privacy Policy