• Contact Us
  • E-Learning
  • Online Store
  • Log In
Chartered Accountants Worldwide Network USAChartered Accountants Worldwide Network USAChartered Accountants Worldwide Network USAChartered Accountants Worldwide Network USA
  • About
    •  
      • About Us
    •  
      • Chapters
    •  
      • About Us
      • Practice Team Leads
      • Chapters
      • Reciprocity
      • Partners & Sponsors
  • Member Organizations
    •  
      • Member Organizations
      • Institute of Chartered Accountants in England and Wales (ICAEW)
      • Institute of Chartered Accountants Scotland (ICAS)
      • Chartered Accountants Ireland (CAI)
      • South African Institute of Chartered Accountants (SAICA)
      • Chartered Accountants Australia & New Zealand members in the United States
      • The Institute of Singapore Chartered Accountants
    •  
      •  
      • The Institute of Chartered Accountants of Bangladesh
      • The Institute of Chartered Accountants of India
      • Institute of Indonesia Chartered Accountants
      • Chartered Institute of Accountants in Malawi
      • The Institute of Chartered Accountants of Nigeria
      • CPA Canada
    •  
      •  
      • The Institute of Chartered Accountants of Pakistan
      • The Institute of Chartered Accountants of Sri Lanka
      • Zambia Institute of Chartered Accountants
      • The Institute of Chartered Accountants of Zimbabwe
  • Beyond Accounting
    •  
      • Highlights From the Past Beyond Accounting Events
    •  
      • Beyond Accounting Webinars on Demand
    •  
      • Beyond Accounting Series
      • Upcoming Events
      • Highlights From the Past Events
      • Recorded Webinars
  • What’s on
    •  
      • Upcoming Events
    •  
      • Webinars on Demand
    •  
      • Podcasts
  • Insights
    •  
      • Beyond Accounting
      • Climate Change
    •  
      • Sustainability & SDGs
      • Wellness
    •  
      • Explore all Insights
      • Covid-19 – Global Recovery
      • Digital Disruption
      • Diversity & Inclusion
      • Economics
      • Ethics
      • Global Trade
      • Leadership
      • Philanthropy
      • News
      • Polls
  • Jobs
  • Contact us
  • E-Learning
  • Online Store
  • Log in
  • About Us
    • Practice Team Leads
    • Chapters
    • Reciprocity
    • Partners & Sponsors
  • Member Organizations
    • Home Institutes
    • CA Institutes
  • Beyond Accounting
    • Upcoming Events
    • Highlights from the Past Events
    • Webinars On Demand
  • What’s on
    • Upcoming Events
    • Webinars on Demand
    • Podcasts
  • Insights
    • Beyond Accounting
    • Climate Change
    • Covid-19 – Global Recovery
    • Diversity & Inclusion
    • Economics
    • Ethics
    • Global Trade
    • Leadership
    • Philanthropy
    • Sustainability & SDGs
    • Wellness
    • News
    • Polls
  • Jobs
  • Contact us
  • E-Learning
  • Online Store
  • Log In
0

$0.00

✕

CPAs, find your own fit with coding, experts say

acaus-feat-004

By SOPHIE NICHOLLS JONES

Expertise will depend on your role, level of seniority and career trajectory.

Coding may one day be as synonymous with accounting as Excel.

According to a recent CPA Canada report, Why Should CPAs Code, skill requirements for current finance job postings include: the ability to promote automation; using basic programming and advanced data analysis tools; collecting, manipulating and interpreting data to isolate key trends and summarize findings; and a strong knowledge of programming languages, including Visual Basic for Applications (VBA), Python, R and SQL.

“While Excel will also remain near and dear to the hearts of CPAs, increasingly, the focus on data-driven decision making has necessitated the shift to collecting and analyzing as much data as possible,” says Michael Wong, principal, technology, research, guidance and support at CPA Canada

Excel may no longer be the only tool CPAs may need to work with.

As CPA Canada points out in its latest Mastering Data Series, Canada’s economy and society are becoming more digital, as part of its Foresight: Reimagining the Profession initiative, organizations are now managing and overseeing data and digitization policies and strategies, where CPA competencies are valued and necessary. “CPAs must use their foundational proficiencies in business expertise, judgment, skepticism, analysis and systems to be a part of that [transformation],” it says.

With that in mind, CPAs must embrace a skillset evolution, establishing how their roles will change and any adjustments they’ll need to make.

Below are four tips to help the hesitant CPA hop on board this inevitable career development.

1. EMBRACE NEW TOOLS

With the shift to data-driven decision making and as finance functions increasingly automate, CPAs will need to acquire knowledge of data analysis and programming tools.

“There is no shortage of tools out there to help with data analysis and visualization,” says Wong. “Tools like Tableau and PowerBI are great for data visualization, while Python scripts are much more efficient working with huge datasets.”

Alan Huang, associate professor of finance at the University of Waterloo and contributor to the Why Should CPAs Code report, recommends CPAs start the journey by exploring these various tools, familiarizing themselves with their purpose and attributes before doing a deeper dive into coding.

“If you come down to the stage where you need to write some code, there are lots of options,” he says.

2. TAKE IT SLOW AND STEADY

When it comes to learning code, CPAs should start small and find their bearings where they are most comfortable, recommends Wong. This may initially be via Excel, automating tasks using formulas, then moving to programming languages including Macros and VBA for more complex tasks, he explains. [Look to the Why Should CPAs Code report for some starter course options.]

“Start by finding small pieces of a larger process to automate. Once you are successful in those, then look to go bigger,” he says. “The basic logic around coding is very similar across different programming languages, so once you’ve developed an understanding of how to code certain logic, it can be applied to other broad-based languages like Python or R.”

There’s a misconception that coding equals software development, says Wong. Remember, accountants aren’t expected to also be computer engineers.

Coding used from a CPA’s perspective is far simpler, he explains, adding to the arsenal of skills they already have. Automation reduces monotony from the daily grind, saving time and leaving accountants free to focus on meeting an organization’s or client’s needs but through more in-depth data visualization and analytics.

“CPAs have an opportunity to leverage coding to improve their everyday work, and it has nothing to do with writing apps,” says Wong. “It will free up time spent on repetitive tasks and help CPAs better achieve their role as a trusted financial adviser for their business partners.”

3. KNOW YOUR STRENGTHS

Coding skills won’t take over a CPA’s traditional role.

Competencies such as technical accounting expertise, financial knowledge, professional judgment, skepticism, and ethics will continue to drive roles and the profession. The accelerated use of AI and automation, producing more data for a lower cost than ever before, will also fuel the need for strong judgment to make sense of the assumptions.

“Accountants don’t necessarily need to be defined differently, they’ll just do their job even better than they do today,” says Wong. “Our traditional skills will complement our new skills around data analysis [of which coding will be part].”

Wong also points out that many CPAs are well-prepped to learn these new skills, as they have a degree of coding knowledge from using Excel in more complex ways via sum products and other VBA and Macros functions.

Huang agrees, adding that a CPA’s core knowledge, combined with the use of more advanced tools, is what will drive efficiency.

“You have this domain knowledge and now you have better tools that can enhance your productivity and abilities to help the profession move forward,” he says. “Within a firm, you can now store all the automation process, get rid of a lot of repetitive work and focus on your client needs.”

4. ADOPT A GROWTH MINDSET

Though the CPA role doesn’t disappear, a shift in mindset is necessary to keep up with the pace of technological change as financial functions automate, reminds Wong.

“We all need to have a growth mindset these days,” he says. “The world is changing faster than ever before and it’s impossible to be taught everything you need to know.”

There’s no room for stagnancy. CPAs must take the time to define what “coding” means for them. How much they need to know will be determined by what role they occupy, their level of seniority and career trajectory. For example, explains Wong, a partner at a firm, where soft skills reign, may not need to know how to code extensively but, for the mid-level CPA involved in data preparation and analysis, more advanced coding skills may be required.

“Having an understanding of what coding is and what it can do for a CPA is important for all CPAs, regardless of level,” says Wong. “The key is the ability to identify gaps in your knowledge and to have the determination to fill that gap through self-learning.”

TOWARDS A DIGITAL FUTURE

Discover what key role CPAs can play as their organizations transition to the digital economy with CPA Canada’s Mastering Data Series, Canada’s economy and society are becoming more digital and using these tech resources. Prep your organization for the next industrial revolution with these digital transformation tips.

Also, delve into insights emerging from CPA Canada’s strategic initiative, Foresight: Reimagining the Profession, and learn what the future holds for accounting.

 

This article was first published on 1.4.2021 by CPA Canada.

Newsletter Subscription

  • About Us
  • Member Organizations
  • Membership
  • Contact
  • E-Learning
‘Chartered Accountants Worldwide’ ® is a registered US trademark number 4705697, and ‘CAW’™ is an unregistered mark, in each case used under license from Chartered Accountants Worldwide Limited (England).

Privacy Policy | Chartered Accountants Worldwide
✕

Login

Lost your password?

Cookie Policy
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT