Recapitulation of Generative AI Use in Accounting

Main Points Summary Image
Main Points Summary Image, Created by Microsoft Copilot (Powered by DALL-E 3) from Microsoft

Recapitulation of Generative AI Use in Accounting

Over the past seven-series articles, which began on January 5, 2024, we considered generative AI use in accounting: more precisely the promise and the practice of generative AI capabilities, the risks of generative AI use in the accounting practice, accountancy standards and regulatory bodies, the policies of those bodies regarding generative AI, the implementation of a generative AI (LLM system) in the accounting practice, custom API scripts and plugins for generative AI in accounting, for increasing the scope and scale of use, and private database implementation of generative AI in accounting, particularly for obviating the risk of confidential data leakage.

In the initial article “Generative-AI Capabilities, Promise, and Practice” we saw that the range of generative AI capabilities, from routine to sophisticated analyses and decision-making, lend themselves to use in professional services firms like an accounting practice. Consequently, the emergence of these generative AI capabilities is timely to mitigate the current shortages of skilled professionals in professional services industries, including the accounting industry.

In the next article, “The Risks of Generative AI Use in Accounting Practice” we noted that the risks applicable to the use of generative AI systems are the same ones applicable to the accounting practice. But there are specific compliance risks, associated with the practice in the USA, as there are in other jurisdictions, relating to the accounting profession as dictated by the Securities and Exchange Commission (SEC,) the Internal Revenue Service (IRS,) Financial Accounting Standards Board (FASB,) and Public Company Accounting Oversight Board (PCAOB)a scion of the Sarbanes-Oxley Act of 2002. A derivative implication is that only CPAs or a registered public accounting firm can perform audits and prepare financial statements for publicly traded companies:

Then, we noted a substantial number of US standards and regulatory bodies, in the article “Accountancy Standards And Regulatory Bodies,” that can have a say in using generative AI in accounting. Their varied authority are derivatives of the securities acts of the 1930s. But, in the cases of the Internal Revenue Service, an agency of the Department of the Treasury, and the Federal Reserve System, the former manages government revenue, gained its authority from the Act of Congress in 1789, and the latter manages the US money supply, make loans and provide oversight to banks, and serving as a lender of last resort; has its authority from the Federal Reserve Act of 1913 and the Banking Act of 1933 (Glass–Steagall Act).

Following, in “Accountancy Standards and Regulatory Bodies Policies on Generative AI,” we found that “wait and see” can best describe the current policies of accounting regulatory and standards bodies regarding the use of generative AI. This is despite its use by some of these bodies in their operations. It is not required to say, that their delays are due to the limits imposed by the law and want of a full understanding of the technology and its ramifications.

In the article “Implementation of Generative AI (LLM System) in The Accounting Practice” we showed that with manual operations on the LLM, an accountant can complete a large part of his/her routine work, such as data preparation, tax preparation, inference, report composition, &c. Even so, manual operations are cumbersome for large-scale activities such as automatically retrieving journal entries from a database for producing financial statements and other reports. Notwithstanding, improved manual operations in ChatGPT, in general, and in accounting particularly, can be facilitated through the use of WebChatGPT or ChatGPT File Uploader (places a file upload button on the interface, 15,000-character limit/upload, especially useful in ICL or data prep,) or ChatGPT Sidebar & File Uploader extensions for your browsers.

Thereupon, in “Custom API Script and Plugins for Generative AI in Accounting” we noted that custom API scripts, for interacting with the LLM, are generally coded in Python and PHP programming languages; that plugins are off-the-shelf or ready-made API scripts available from various vendors and are accessible from the Plugin Store in the ChatGPT UI. Both API Scripts and plugins advance the use cases of ChatGPT in scope and scale. For example, instead of manual cut-and-paste operations, the accountant can upload complete files of various formats for “processing” via prompting. So, the accountant can build his/her API script that focuses on accounting or enable specialized accounting plugins from ChatGPT UI such as QuickBooks amongst others.

In the penultimate article “Private Database Implementation of Generative AI in Accounting” we introduced practices/solutions, i.e., anonymization, and encryption of data, as well as, vectorization, for use of private databases that protect confidential information with the additional benefit of functioning at scale.

Anonymizing data on the database means removing or replacing personally identifiable information (PII) from the data, such as names, phone numbers, email addresses, &c., during in-context learning with the LLM. Encrypting data from the database means transforming data into an unreadable form using a secret key or algorithm, also, during in-context-learning with the LLM, thus preventing unauthorized access to private data. Only those with the key or algorithm can decrypt the data and restore its original form.

The use of a vectorized database means converting data into numerical vectors that can be used for mathematical operations and machine learning. A vectorized database can also help leverage the general knowledge and information in the data without compromising the data subjects’ identities; and it is used as an adjunct to an LLM, which does not and cannot memorize the vectorized data.

Vectorization is not necessarily superior to anonymization or encryption, but rather a different approach that has its advantages and disadvantages. All accomplish the task of protecting personal identifying information (PII) and, particularly, avoiding data leakage, and misuse. Depending on the use case and the requirements, one may use one or all methods to protect the data.

Undoubtedly, the accountant can benefit from the use of generative AI. Although he/she must be aware of the risks and ensure that their operation complies with established regulations regarding such things as CPA licensing, maintenance of client confidentiality, accuracy, &c. Furthermore, instead of manual engagement with the LLM, which can be tedious, the accountant can choose automation using scripts and plugins whilst engaging with the LLM; and can improve the confidentiality of client data by utilizing anonymization, encryption, and vectorized databases.

Further Resources

A CPA’s Introduction to AI: From Algorithms to Deep Learning, What  You Need to Know: https://us.aicpa.org/content/dam/aicpa/interestareas/frc/assuranceadvisoryservices/downloadabledocuments/cpas-introduction-to-ai-from-algorithms.pdf

How is the accountancy and finance world using artificial intelligence? https://www.icas.com/insight/technology/the-ca-focus/how-accountancy-and-finance-are-using-artificial-intelligence#content-main

The use of Generative AI tools in the Tax Profession — After the initial hype —  Fear, Foe or Friend? https://assets.kpmg.com/content/dam/kpmg/xx/pdf/2023/09/generative-ai-in-the-tax-profession.pdf

What does artificial intelligence mean for accounting? [2:02 min]:  https://youtu.be/oayT6OhEa1E

Managing the Risks of Generative AI: https://hbr.org/2023/06/managing-the-risks-of-generative-ai

Generative AI and risks to CPA firms: https://www.cpai.com/Education-Resources/My-Firm/Data-Security-Risk-Management/Generative-AI-and-risks-to-CPA-firms

Investing in generative AI is a balance between risk and reward: https://www.aicpa-cima.com/professional-insights/article/investing-in-generative-ai-is-a-balance-between-risk-and-reward

9 RISKS you should AVOID using Generative AI at your company [8:31 min]: https://youtu.be/HoHZmPAIyqs

5 strategies to MITIGATE RISKS while using Generative AI at your company [4:53 min]: https://youtu.be/O4ZIcgqgL6w

What are the risks of generative AI? – The Turing Lectures with Mhairi Aitken [48:06 min]: https://youtu.be/si1jcl7UFqU

AI in Accounting: How Accountants and Bookkeepers Can Use ChatGPT in their Firms: https://financial-cents.com/resources/articles/ai-in-accounting-how-accountants-and-bookkeepers-can-use-chatgpt-in-their-firms/

Modern accounting firms run on Copilot: https://www.copilot.com/solutions/accounting-client-portal

Accountants: Here’s How to Use ChatGPT: https://youtu.be/nQ-_u3SFJJ8

ChatGPT in Accounting. Part 1: Answering QuickBooks Questions: https://youtu.be/4VMYJG3GFgU

ChatGPT in Accounting. Part 2: Searching the web in your prompts: https://youtu.be/XMTM7OnyCHM

ChatGPT In Accounting. Part 3: Categorizing Expenses: https://youtu.be/S7MUNoFFmjs

Quickbooks API Integration: Proven Strategies to Avoid: https://www.youtube.com/watch?v=330s8FDfxd0

LangChain Explained in 13 Minutes | QuickStart Tutorial for Beginners: https://youtu.be/aywZrzNaKjs

Using ChatGPT with YOUR OWN Data. This is magical. (LangChain OpenAI API): https://www.youtube.com/watch?v=9AXP7tCI9PI

ChatGPT API documentation: https://stackoverflow.com/questions/23314851/how-to-write-a-python-script-to-recover-files-from-a-formatted-drive

How To Build Your Own AI With ChatGPT API: https://youtu.be/4qNwoAAfnk4

Use OpenAI’s ChatGPT in Python: https://youtu.be/YVFWBJ1WVF8

How To Create Custom GPTs – Build your own ChatGPT: https://youtu.be/5–JexprHuk

Top 10 ChatGPT Plugins You Can’t Miss: https://youtu.be/o2M_paJf48I

ChatGPT Plugins: https://openai.com/blog/chatgpt-plugins

7 AI Apps For Accounting Firms [16:32 min]: https://youtu.be/B7XMIj9TAcI

Introducing GPTs: https://openai.com/blog/introducing-gpts

Do more with GPTs: https://openai.com/chatgpt#do-more-with-gpts

Find Useful GPTs For ChatGPT: https://www.whatplugin.ai/

Content Vector databases are so hot right now. WTF are they?:  https://youtu.be/klTvEwg3oJ4

Vector Embeddings Tutorial – Code Your Own AI Assistant with GPT-4 API + LangChain + NLP: https://youtu.be/yfHHvmaMkcA

Vector Databases simply explained! (Embeddings & Indexes): https://youtu.be/dN0lsF2cvm4

PostgreSQL (2) Database Connection With Python Using “Psycopg2” Module: https://youtu.be/Q8iYj2ypWss

HOW TO TUTORIAL: SENDING DATA FROM PYTHON TO POSTGRESQL with psycopg2: https://youtu.be/453c3iuIU_8?list=PL9hm1VKOqnvOv60uOpHOdxL05gIG3Upt-

Connect ChatGPT to your Database!: https://youtu.be/XlWPzxKn708

Chat with Your SQL Data Using ChatGPT: https://youtu.be/1FeBkAccobY

Part 1 — Use Open AI (ChatGPT) On Your Own Large Data -Part 1: https://www.youtube.com/watch?v=eNKu307k59g&t=0s

Part 2 — Use ChatGPT On Your Own Large Data: https://www.youtube.com/watch?v=RcdqdWEYw2A&t=0s

A Survey on In-context Learning: https://arxiv.org/pdf/2301.00234.pdf

In-context Learning – A New Paradigm in NLP? https://youtu.be/n4HR4_j_xS8?list=PLHgX2IExbFoukiZqU898HKJvmVAYbjQ1i

FACT SHEET: President Biden Issues Executive Order on Safe, Secure, and Trustworthy Artificial Intelligence: https://www.whitehouse.gov/briefing-room/statements-releases/2023/10/30/fact-sheet-president-biden-issues-executive-order-on-safe-secure-and-trustworthy-artificial-intelligence/

United Nations: High-Level Advisory Body on Artificial Intelligence: https://www.un.org/techenvoy/ai-advisory-body

United Nations: Governing AI for Humanity: https://www.un.org/sites/un2.un.org/files/ai_advisory_body_interim_report.pdf

Financial Accounting Standards Board (FASB) [5:47 min]: https://youtu.be/nHM4Y83lWyQ

Introduction to GAAP (Generally Accepted Accounting Principles) [4:54 min]:  https://youtu.be/nqkk9omr3sc?list=PL_KGEFWqEaTBEnaEf98KzlsbVvkPBLIPm

US GAAP vs IFRS [16:32 min]: https://youtu.be/7B96MhOGaqE

International Accounting Standards Board: https://www.ifrs.org/groups/international-accounting-standards-board/

International Accounting Standards Board (IASB) [7:44 min]: https://youtu.be/Z2u5JbzOFbY

What is IFRS? | International Financial Reporting Standards [6:25  min]: https://youtu.be/XhH680AnPO0

What is IFRS? [2:18 min]: https://youtu.be/mvbpTW9WUPk

Securities And Exchange Commission: https://www.sec.gov/

SEC Proposes New Requirements to Address Risks to Investors From Conflicts of Interest Associated With the Use of Predictive Data Analytics by Broker-Dealers and Investment Advisers: https://www.sec.gov/news/press-release/2023-140

SEC Probes Investment Advisers’ Use of AI: https://www.wsj.com/articles/sec-probes-investment-advisers-use-of-ai-48485279

United States: SEC Announces New AI Rules For Financial Services Companies: https://www.mondaq.com/unitedstates/new-technology/1353338/sec-announces-new-ai-rules-for-financial-services-companies-

What is the Securities and Exchange Commission (SEC)? [15:42 min]: https://youtu.be/F7e7EPELWEE

Internal Revenue Service: https://www.irs.gov/

The Internal Revenue Service (IRS): The Origin Story [No. 86] [3:34 min]: https://youtu.be/NLEakPN09K0

PCAOB: https://pcaobus.org/

PCAOB Advisory Panel Highlights AI, Climate Reporting and Talent as Emerging Issues: https://tax.thomsonreuters.com/news/pcaob-advisory-panel-highlights-ai-climate-reporting-and-talent-as-emerging-issues/

PCAOB: Protecting Investors in 2023: Strengthening Our Enforcement: https://youtu.be/HMhYypND73w

Information Systems Audit and Control Association: https://www.isaca.org

A Framework for Picking the Right Generative AI Project: https://hbr.org/2023/03/a-framework-for-picking-the-right-generative-ai-project

ISACA Live: Generative AI: Risks, Opportunities and Critical Next Steps [29:32 min]: https://youtu.be/UEBcphT9lfU

Key Considerations for Developing Organizational Generative AI Policies: https://www.isaca.org/resources/news-and-trends/newsletters/atisaca/2023/volume-44/key-considerations-for-developing-organizational-generative-ai-policies

Artificial Intelligence Resources | ISACA: https://www.isaca.org/resources/artificial-intelligence

–Richard Thomas

Previous, Part VII

Leave a Reply

Your email address will not be published. Required fields are marked *

UPCOMING TRAINING

SHARE TO SOCIAL MEDIA