Transform Accounting with AI: Opportunities and Practical Applications
Background
The accounting profession is undergoing a significant transformation due to the rapid advancement of artificial intelligence (AI) presenting both challenges and opportunities requiring Chartered Accountants (CA) to adapt and acquire new skills.
This article first appeared in the Namaskar Newsletter ICAI Singapore Chapter H2 2024.Â
Thanks to the editor Ms. Kinnari Doshi and the Managing Committee of ICAI Singapore Chapter for the their support and cooperation.Â
AI is not intended to replace CAs, but rather to act as a complementary tool[1] that enhances their capabilities by automating routine tasks & freeing up time to focus on higher-value activities such as data interpretation, predictive analytics, and providing strategic financial advice & deeper insights to clients.
https://ai.icai.org/cagpt/Proficiency in AI is crucial for CAs and The Institute of Chartered Accountants of India (ICAI) is actively integrating AI into the profession through initiatives such as CA GPT (https://ai.icai.org/cagpt/ ) & dedicated training programs (https://ai.icai.org/aica.php ).
The digital transformation in India, characterized by widespread adoption of digital payment systems, is generating vast amounts of data. This data requires expert analysis and ethical reporting, making data analytics a pivotal aspect of the CA’s role while also maintaining ethical standards.
This article explores the impact of AI on various functions within the accounting profession, highlighting practical examples, a case study for AI used in compliance and provides a demo tool for data analysis & visualization leveraging the capability of AI.
Functional areas where AI is being used, with practical examples:
Finance:
- Enhanced Security of Financial Documents: AI can generate VBA code to lock Excel files to a specific hard drive, preventing unauthorized access.[1]
- Automation of Financial Forecasting: AI can project balance sheets for the next three years in Excel format using uploaded financial statements and user prompts. (footnote no. 2)
- Financial Proofreading: AI can automatically compare two versions of a financial document to detect numerical and textual discrepancies. (footnote no. 2)
- Data Analysis and Consolidation: AI can extract data from multiple sources, like employee reimbursement sheets, into a single Excel sheet using Power Query for reporting purposes. (footnote no. 2)
- Automated Invoice Generation: AI can generate invoices and annexures from consolidated data, including extracting data for specific date ranges and downloading invoices in PDF format. (footnote no. 2)
- Streamlining Data Input: AI tools can automate data entry from bills and link to trial balances and financials, potentially allowing one person to handle 1,000 vouchers daily.[2]
- Financial Data Analysis: AI can quickly analyze financial data such as competitor information by summarizing data from PDF files. (footnote no. 3)
- Financial Statement Automation: AI can automate the creation of financial statements by extracting data from various sources. (footnote no. 3)
- Automation of tasks: AI can manage income tax return preparation using a customized checklist and folder management system, loading client data from Excel, creating subfolders, and updating the status of tasks.[3]
- Advanced tax calculator: AI can instantly compute income tax under old and new tax regimes using VBA code. (footnote no. 4)
- Data analysis: AI tools can analyze large volumes of data for better financial insights using machine learning to identify key factors contributing to loan defaults. (footnote no. 4)
- Financial Statement Preparation: AI can assist in the preparation of financial statements in the required format, such as Schedule III.[4]
- Materiality Calculation: AI can automate materiality calculations based on the type of entity being audited. (footnote no. 5)
[1] https://ai.icai.org/articles_details.php?id=146
[2] https://youtu.be/FKNuUAy_lnE (ICAI AI Marathon Hackathon 2024 – 1)
[3] https://youtu.be/sD45NrCUZKg (ICAI AI Marathon Hackathon 2024 – 2)
[4] https://youtu.be/HAlm5qOLZ9I (ICAI AI Marathon Hackathon 2024 – 3)
[5] https://youtu.be/DH43eXFVKlw (ICAI AI Marathon Hackathon 2024 – 4)
Compliance:
- Chatbots for Client Support: AI-powered chatbots can provide 24/7 client support, answer queries, accept document uploads, and support multiple languages. (footnote no. 2)
- AI-Powered Audit Assistance: AI can generate draft audit opinions based on user prompts. (footnote no. 2)
- Automated Ratio Analysis: AI can automate financial ratio analysis using Python scripts generated by ChatGPT, extracting data from financial statements to calculate key ratios and displaying them in a user-friendly interface. (footnote no. 2)
- Document Processing: AI can process large volumes of documents, including judgements and circulars, and extract relevant information. (footnote no. 2)
- Checklists for Compliance: AI can generate checklists based on accounting and auditing standards to ensure all compliance requirements are met. (footnote no. 2)
- Automating Repetitive Tasks: AI can automate repetitive tasks such as allocating receipts and invoices using RPA tools like Power Automate, reducing manual intervention and errors. (footnote no. 3)
- Automated Audit Report Creation: AI can automate the creation of independent audit reports by linking data from financial statements with a Word template using tools like Power Automate. (footnote no. 3)
- CSR Compliance: AI can assist in creating CSR utilization certificates by transcribing data from various documents. (footnote no. 3)
- Audit report generation: AI can assist in generating draft audit reports, including CARO reports, using specific and detailed prompts. (footnote no. 4)
- Risk assessment: AI can provide step-by-step guidance on performing risk assessments using simple language and practical examples, based on auditing standards. (footnote no. 4)
- Document processing: AI can process scanned PDFs, audio files, and images, and extract relevant information. It can also transcribe audio files and translate text, even from Arabic. (footnote no. 4)
- Transfer Pricing Documentation: AI can assist in preparing transfer pricing documentation, including industry analysis, functional analysis, and economic analysis. (footnote no. 4)
- GST Compliance: AI can be used to reconcile GSTR 2A/2B data with books data, identify mismatches, and calculate eligible Input Tax Credit (ITC). AI can also check if suppliers have filed their returns on time. (footnote no. 5)
- Audit Documentation: AI tools can generate audit documentation, such as independence confirmations and confidentiality undertakings. (footnote no. 5)
- Internal Audit: AI can assist in internal audits by structuring unstructured data from accounting systems to identify areas for further scrutiny, like high-value transactions. (footnote no. 5)
- Financial Instrument Compliance: AI tools can help classify financial assets and liabilities as per Indian Accounting Standards (Ind AS), and calculate fair value and Effective Interest Rate (EIR). (footnote no. 5)
- Detection of Errors: AI tools can detect errors in financial statements, especially those related to financial instruments. (footnote no. 5)
[1] https://ai.icai.org/articles_details.php?id=146[2] https://youtu.be/FKNuUAy_lnE (ICAI AI Marathon Hackathon 2024 – 1)
[3] https://youtu.be/sD45NrCUZKg (ICAI AI Marathon Hackathon 2024 – 2)
[4] https://youtu.be/HAlm5qOLZ9I (ICAI AI Marathon Hackathon 2024 – 3)
[5] https://youtu.be/DH43eXFVKlw (ICAI AI Marathon Hackathon 2024 – 4)
Investment Management:
- Annual Report Analysis: AI can analyze annual reports using descriptive, diagnostic, predictive, prescriptive, and cognitive analytics to gain a deeper understanding of a company’s financial health. (footnote no. 3)
- Fraud Detection: AI can be used to identify anomalies in financial data to reduce the risk of fraud. (footnote no. 4)
- The data analysis capabilities of AI tools like Power BI and Power Pivot can be used to understand investment patterns and trends.
Business:
- Team Management: AI can allocate tasks, track performance, and automate scheduling for office teams. (footnote no. 2)
- Employee Onboarding Automation: AI can automate the employee onboarding process, including storing employee data, managing documents, generating ID cards, and sharing employee rules. (footnote no. 3)
- Office Automation: AI can categorize, correct, and organize files without uploading the files themselves to AI, using AI to tag files with client names, service types and years, and then using the AI output to automatically rename and organize files into folders. (footnote no. 3)
- Enhanced Client Communication: AI-powered chatbots can provide instant responses, personalized services, and 24/7 availability for clients. (footnote no. 5)
- Executive Assistance: AI can analyze business performance, identify trends, forecast, and assess risk. (footnote no. 2)
- Contract Management: AI can streamline contract management by automating the contract review and drafting process. (footnote no. 4)
- Website Development: AI can assist in creating professional websites with minimal effort and technical knowledge. (footnote no. 5)
- Task Management: AI can assist with task management by tracking pending lists, updating statuses, and creating travel planners. (footnote no. 3)
- Improved Data Management: AI tools help in data transformation, cleansing, and organizing for better use in business analysis. (footnote no. 5)
Other Areas:
- Customized Software Solutions: AI can help create customized software solutions without coding knowledge. (footnote no. 3)
- Data Import to Accounting Software: AI tools can be combined with other tools to import data into accounting software, such as Tally, from Excel using XML files created with macros and AI assistance. (footnote no. 3)
- AI Skills Enhancement: Chartered Accountants can enhance their AI skills by enrolling in courses, watching videos, and learning how to give effective prompts to AI. (footnote no. 3)
- Accessibility: AI tools are becoming more accessible for CAs and other professionals, even without having in-depth programming knowledge. AI tools like ChatGPT, Cloud AI and Co-pilot can help with code generation and error debugging. (footnote no. 4)
[1] https://ai.icai.org/articles_details.php?id=146
[2] https://youtu.be/FKNuUAy_lnE (ICAI AI Marathon Hackathon 2024 – 1)
[3] https://youtu.be/sD45NrCUZKg (ICAI AI Marathon Hackathon 2024 – 2)
[4] https://youtu.be/HAlm5qOLZ9I (ICAI AI Marathon Hackathon 2024 – 3)
[5] https://youtu.be/DH43eXFVKlw (ICAI AI Marathon Hackathon 2024 – 4)
Case Study of AI for compliance in Financial services industry
Challenge: Financial services companies face a rapidly evolving regulatory environment, with laws and enforcement patterns frequently changing. Traditional manual processes for managing regulatory changes are slow and error-prone, leading to inefficiencies and high compliance costs.
Solution: https://www.compliance.ai/ implemented an AI-powered RegTech solution that automates regulatory change management processes by:
- Filtering out 94% of irrelevant regulatory documents from an average dataset of 25,537, reducing the manual workload to just 585 documents.
- Normalizing content from various regulatory sources, tagging and classifying documents, and extracting key information, including obligations and constraints.
- Offering real-time alerts and expert insights to enhance decision-making and minimize compliance risks.
Outcomes:
- Reduced document processing time, saving compliance teams an average of 87 days every six months.
- Lowered compliance operational costs by over 30%.
- Streamlined onboarding and setup, completed within five business days, compared to months with traditional solutions.
- Enabled scalability without increasing resources, even as organizations expanded to new jurisdictions or introduced new products.
- Enhanced regulatory risk management, preventing sanctions and safeguarding reputations.
[1]Â https://www.compliance.ai/wp-content/uploads/2020/11/ComplianceAI-Case-Study-Financial-Services.pdf
Demo
Please see a simple app created using https://vectorshift.ai/ (a no code/low code automations platform funded by YCombinator ) (YC S23) for contract review based on commercial risk management policy of a enterprise engaged in execution of construction contract for real estate developers.
https://elevatespot.sg/contract-review/
To see it in action, just upload the draft contract from the below Microsoft One Drive link.
Construction_Contract_Draft_ABC_XYZ.docx
It automatically provides a risk review vis-Ã -vis the commercial risk management policy (which can be viewed from the below Microsoft one drive drink) for each department to review & modify/seek approval. Â
ABC Contractors Pty Ltd – Commercial Risk Management Policy.pdf
Summary
AI’s impact spans various functions, including enhanced financial document security, automated financial forecasting, and streamlined data input, enables 24/7 client support, generates draft audit opinions, and automates repetitive tasks, such as allocating receipts and invoices, ultimately reducing manual errors and intervention.
AI also aids in enhancing accessibility to tools for CAs and it is imperative for us to embrace the adoption of AI to stay competitive in our respective fields.
But we must remember that AI tools are assistive, and human judgment remains essential; AI-generated information should not be relied upon 100%.
