✨ Practical AI for Finance Professionals

Learn AI for Accountants

Practical AI tools, prompt engineering and automation for modern accountants, auditors and ICAB students.

হিসাববিজ্ঞান, নিরীক্ষা, আয়কর ও এক্সেল কাজের জন্য কৃত্রিম বুদ্ধিমত্তার বাস্তবসম্মত ব্যবহার।

Structured learning

Curriculum: AI for Accounting & Audit

6 core modules

From foundational large language model concepts and data privacy to advanced Excel automation and IFRS research.

01
Beginner ⏱ 45 mins

AI Foundations & Data Ethics for Accountants

হিসাববিদ্যায় এআই-এর ভিত্তি ও ডাটা নিরাপত্তা

Understand how Generative AI and Large Language Models (LLMs) process financial information, where calculations fail, and the non-negotiable rules of client confidentiality under the IESBA Code of Ethics.

Key topics covered:

  • How LLMs process language vs. mathematical calculations (probabilistic text vs. exact arithmetic)
  • Hallucination risks: why AI invents standard references or balances, and how to verify them
  • Client confidentiality & data privacy: strict rules against uploading unredacted client financials or PII to public clouds
  • ICAB & IESBA Code of Ethics implications: integrity, professional competence and due care when using AI assistants
  • Human-in-the-loop principle: why the Chartered Accountant remains legally and professionally responsible
Core Takeaway: Never input real client names, tax numbers or unredacted ledgers into public AI models, and never trust AI math without spreadsheet recalculation.
02
Intermediate ⏱ 60 mins

Financial Prompt Engineering & CLEAR Framework

ফাইন্যান্সিয়াল প্রম্পট ইঞ্জিনিয়ারিং ও ক্লিয়ার ফ্রেমওয়ার্ক

Master the CLEAR framework designed specifically for accounting and finance professionals to get precise, structured, audit-ready outputs from ChatGPT and Claude.

Key topics covered:

  • The CLEAR Framework: Context, Limits, Execution format, Audience, Review criteria
  • Drafting executive variance commentary (Budget vs. Actuals) with root-cause breakdowns
  • Converting complex trial balance data into structured management briefing memos
  • Drafting audit query letters and client PBC (Provided by Client) requirement lists
  • Zero-shot vs. Few-shot prompting: teaching the AI your firm's specific reporting format
Core Takeaway: High-quality financial outputs require strict role specification, clear output constraints (e.g. Markdown tables), and explicit forbidden terms.
03
Intermediate ⏱ 60 mins

AI + Excel & Financial Modeling

এআই এবং এক্সেল: ফর্মুলা ও মডেলিং গতি বৃদ্ধি

Supercharge your daily Excel work: write complex dynamic array formulas, debug stubborn errors, and generate Power Query M code in seconds.

Key topics covered:

  • Microsoft Copilot in Excel: generating calculated columns, conditional highlighting and summary charts
  • Prompting AI for advanced formulas: XLOOKUP, INDEX/MATCH, nested IFS, LET and LAMBDA functions
  • Instant formula debugging: diagnosing and fixing #VALUE!, #REF!, #N/A and circular reference errors
  • Power Query M code generation: automated unpivoting, date parsing and cleaning messy exported ERP reports
  • Python in Excel prompt strategies: running financial variance clustering and basic cash flow forecasting
Core Takeaway: Use AI to write and explain formulas; test them in Excel against known test cases before applying to production workbooks.
04
Advanced ⏱ 75 mins

IFRS & Bangladesh Tax Research with AI

এআই দিয়ে আইএফআরএস ও বাংলাদেশ আয়কর গবেষণা

How to use AI search and grounded document tools (like Google NotebookLM) to navigate IFRS standards and the Bangladesh Income Tax Act 2023 with verified citations.

Key topics covered:

  • Grounding AI tools on official IFRS standards and the Bangladesh Income Tax Act 2023 without hallucination
  • Using Google NotebookLM with official NBR gazettes, SROs and ICAB manuals for cited question answering
  • Researching complex IFRS 15 5-step revenue recognition criteria and IFRS 16 lease classification
  • Formulating tax queries: individual salary tax, investment rebate ceiling and TDS deduction under Section 86
  • The Verification Protocol: always confirming section numbers, tax rates and effective dates against the official Gazette
Core Takeaway: AI is an index and synthesis assistant. Never rely on an AI-cited tax section or tax rate without cross-checking the actual Act.
05
All Levels ⏱ 50 mins

AI as a 24/7 ICAB CA Study Mentor

আইসিএবি সিএ পরীক্ষার প্রস্তুতিতে এআই গৃহশিক্ষক

Transform AI into an interactive tutor for Certificate, Professional and Advanced Level exams: generate active-recall quizzes, explain tough past questions, and structure study timetables.

Key topics covered:

  • Building customized study schedules based on ICAB syllabus weightings (e.g. CL-ACC, CL-TX1)
  • Active recall & spaced repetition: prompting AI to quiz you on standard definitions and journal entries
  • Breaking down difficult past-paper questions into step-by-step conceptual walkthroughs
  • Summarizing bulky chapter texts into high-yield exam revision bullet points
  • Simulating the ICAB examiner mindset: identifying common student traps in multiple-choice and scenario questions
Core Takeaway: Treat AI like a study partner who can ask questions and clarify concepts, but always check answers against your ICAB study manual.
06
Advanced ⏱ 60 mins

Accounting Workflow Automation & AI Agents

অ্যাকাউন্টিং অটোমেশন ও ভবিষ্যৎ এআই এজেন্টস

Explore the cutting edge of finance automation: bank reconciliation matching, document data extraction, and autonomous agent workflows.

Key topics covered:

  • Automated bank reconciliation logic: using AI to match descriptions, fuzzy vendor names and dates
  • Document intelligence: extracting invoice numbers, VAT amounts and line items from scanned PDF receipts
  • Automating recurring financial communications: vendor balance confirmations and overdue invoice reminders
  • Introduction to AI agents: how autonomous agents can run multi-step reporting workflows
  • The Future Accountant: moving from manual data entry to AI supervisor and strategic business advisor
Core Takeaway: The accountants who thrive will not be replaced by AI, but by accountants who know how to work seamlessly with AI tools.

Ready-to-use templates

Accounting Prompt Library

8 tested prompts

Copy and paste these audited prompt templates directly into ChatGPT, Claude or Copilot for instant, professional accounting workflows.

Financial Reporting

Financial Statement Variance Analysis Commentary

When to use: When you have monthly Budget vs. Actual numbers and need professional, board-ready commentary explaining the variances.

Act as a Senior Financial Controller. Analyze the following budget vs. actual financial data:
[PASTE DATA: Account Name, Budget, Actual, Variance $ / %]

Instructions:
1. Identify the top 3 favorable and unfavorable material variances (materiality threshold: 5% and $10,000).
2. Write concise, executive-level commentary for each material variance explaining potential operational drivers (volume vs. price vs. timing).
3. Recommend 2 actionable management next steps to address negative cost overruns.
4. Format the output in a clean Markdown table followed by bullet points. Do not invent facts not present in the data.

💡 Pro tip: Always paste the data with clear column headers. You can specify whether to emphasize cash impact or EBITDA impact.

Excel & Formulas

Dynamic Excel Formula & LAMBDA Generator

When to use: When you need a robust, non-volatile formula to solve a complex lookup, multi-condition sum, or reconciliation.

Act as an Excel Financial Modeling Expert.
I need an Excel formula for Microsoft 365 on Windows.

Objective: [DESCRIBE EXACT GOAL, e.g., 'Find the latest invoice date for a given Customer ID where Status is Paid, and return the Amount']
Table Structure:
- Sheet name: [Sheet1]
- Customer ID: Column A (Range A2:A5000)
- Invoice Date: Column B (Range B2:B5000)
- Status: Column C (Range C2:C5000)
- Amount: Column D (Range D2:D5000)

Requirements:
1. Use modern dynamic array functions (e.g. XLOOKUP, FILTER, SORT, LET) if applicable. Avoid volatile functions (INDIRECT, OFFSET).
2. Handle errors gracefully (return 'Not Found' if no match exists).
3. Explain how the formula works step-by-step and provide a sample implementation.

💡 Pro tip: Providing exact column letters and row ranges ensures the generated formula can be pasted directly into Excel without editing.

Audit & Standards

Technical Accounting Position Paper (IFRS/IAS)

When to use: When evaluating a complex transaction (e.g., software contract under IFRS 15 or lease modification under IFRS 16) for audit documentation.

Act as a Technical Accounting Specialist under IFRS.
Prepare a technical accounting memorandum on the following transaction:
[DESCRIBE TRANSACTION: e.g., 'Company A signed a 3-year contract delivering software licenses, ongoing cloud hosting, and implementation consulting.']

Structure of the memo:
1. Issue Statement: What accounting question must be resolved?
2. Authoritative Standard & Guidance: Cite the relevant IFRS/IAS standard and specific paragraphs (e.g. IFRS 15 step 2 on distinct performance obligations).
3. Technical Analysis: Evaluate the facts against each recognition/measurement criterion.
4. Conclusion & Recommended Journal Entries: Provide debit/credit accounts and timing of recognition.
5. Financial Statement Disclosures: List mandatory disclosure notes.

💡 Pro tip: Always double-check the paragraph citations against the authoritative IFRS Blue Book or official standard PDF.

Bangladesh Tax

Bangladesh Income Tax & Salary Slabs Computation

When to use: When calculating individual taxable salary income, allowable deductions and investment tax rebate under the Income Tax Act 2023.

Act as a Bangladesh Income Tax Practitioner familiar with the Income Tax Act 2023 (আয়কর আইন ২০২৩) and current fiscal budget rules.
A resident individual employee in Bangladesh has the following compensation details for the income year:
- Basic Salary: ৳ [AMOUNT]
- House Rent Allowance: ৳ [AMOUNT]
- Medical Allowance: ৳ [AMOUNT]
- Festival Bonus: ৳ [AMOUNT]
- Eligible Investment (DPS / Mutual Funds / Govt Securities): ৳ [AMOUNT]

Instructions:
1. Calculate Total Gross Salary and Taxable Salary Income, applying the statutory exemption rules (e.g. one-third of salary or ৳4,50,000, whichever is less).
2. Compute Gross Tax Liability using the applicable individual tax slabs.
3. Calculate the Allowable Investment Tax Rebate under the current statutory formula.
4. Determine Net Tax Payable.
5. State any assumptions and remind the user to cross-check with the latest SRO / Finance Act.

💡 Pro tip: Always verify whether the taxpayer is male, female, senior citizen (65+), or third gender, as the initial tax-free threshold differs.

Audit & Standards

Audit Risk Assessment & Substantive Testing Matrix

When to use: When planning audit fieldwork for revenue, inventory or trade payables under International Standards on Auditing (ISA).

Act as an Audit Manager under International Standards on Auditing (ISA).
I am conducting the audit risk assessment for:
- Client Industry: [e.g. Manufacturing / Retail]
- Financial Statement Area: [e.g. Trade Receivables & Revenue]
- Key Inherent Risks: [e.g. Slow-moving balances, disputed invoices, cut-off errors near year-end]

Provide:
1. Relevant Financial Statement Assertions at risk (Existence, Completeness, Valuation, Cut-off).
2. Inherent Risk & Control Risk ratings with justification.
3. Recommended Key Internal Control inquiries & Walkthrough test steps.
4. 4 detailed Substantive Audit Procedures (including sampling method and documentation required).
5. Specific red flags / fraud indicators that auditors should look out for during field testing.

💡 Pro tip: Mentioning the client's industry helps the AI tailor realistic control risks and testing procedures.

Financial Reporting

Bank Reconciliation Difference Investigator

When to use: When the general ledger cash account and the bank statement don't balance and you need to diagnose potential causes.

Act as a Senior Financial Accountant.
My General Ledger cash balance is [GL_BALANCE] and the Bank Statement balance is [BANK_BALANCE], leaving an unexplained difference of [DIFFERENCE_AMOUNT].

Here is the list of recent unusual transactions or pending items:
[PASTE BRIEF TRANSACTION LIST OR NOTES]

Instructions:
1. Categorize common reconciliation timing differences that could explain this variance (unpresented cheques, uncredited deposits, direct debits, bank charges).
2. Check for common clerical error patterns (transposition error: test if the difference is divisible by 9; slide error: test if divisible by 10; sign reversal: test if half of the difference matches a specific transaction).
3. Provide a step-by-step diagnostic checklist to trace and resolve the difference in the ERP.

💡 Pro tip: The test for divisibility by 9 instantly detects transposition errors like writing ৳54,000 instead of ৳45,000.

Excel & Formulas

Power Query M Code for Messy Report Cleanup

When to use: When you export a report from Tally, SAP or QuickBooks that has merged cells, empty header rows, or unpivoted columns.

Act as an Excel Power Query & M Language Specialist.
I need to transform a messy raw accounting export into a clean, flat tabular dataset suitable for Pivot Tables.

Current Raw Format:
- First 4 rows contain report titles, date stamps and empty blank cells.
- Column A contains Branch names, but only on the first row of each group (blank underneath).
- Columns C through N contain monthly amounts (Jan to Dec) that need to be unpivoted into a single 'Month' column and 'Amount' column.
- Dates are formatted as text like 'DD-MMM-YYYY'.

Provide:
1. The complete Power Query M code step-by-step (with comments).
2. Explanation of each transformation applied (Fill Down, Remove Top Rows, Unpivot Other Columns).
3. Instructions on how to paste this into Excel Advanced Editor.

💡 Pro tip: Mentioning the exact ERP or system source often allows the AI to anticipate quirky formatting quirks.

ICAB CA Exam

ICAB CA Exam Tutor & Conceptual MCQ Generator

When to use: When studying an ICAB module (e.g. Assurance, Accounting, Business Law) and you want active recall practice with examiner-level feedback.

Act as an experienced ICAB Chartered Accountancy Tutor.
I am preparing for the ICAB [LEVEL, e.g. Certificate Level] exam in [MODULE, e.g. Assurance / Accounting].
Topic for this session: [TOPIC, e.g. ISA 500 Audit Evidence / IAS 2 Inventories]

Instructions:
1. Give a crisp 3-paragraph executive summary of the core concepts, common examiner pitfalls, and key journal entries or rules.
2. Generate 3 challenging multiple-choice questions matching the ICAB exam style, including plausible distractors.
3. Do NOT reveal the answers immediately. Wait for me to answer, then provide detailed feedback, mark allocation, and reference to the study manual.

💡 Pro tip: Ask the AI to test you one question at a time so you don't accidentally read the answer beforehand.

Comparison guide

The Modern Accountant's AI Toolkit

Updated 2026

An objective comparison of the top AI platforms for accounting, spreadsheets, auditing and tax research.

Tool & Model Best Used For Key Strengths for Finance Pricing Watch Out For
Claude 3.5 & 3.7 Sonnet Anthropic Top for Analysis Complex accounting memos, reading lengthy financial statements, drafting audit memos, and nuanced technical interpretation.
  • 200,000 token context window (can read entire annual reports or standard manuals in one prompt)
  • Superior logical precision with minimal fluff or overconfidence
  • Artifacts feature allows real-time interactive preview of financial models and tables
Free tier available; Pro at $20/month Verify all mathematical totals and avoid uploading sensitive non-public client financial records without enterprise privacy agreements.
ChatGPT Plus (o1 & GPT-4o) OpenAI Top for Reasoning Advanced Data Analysis, debugging complex Excel Python scripts, multi-step math reasoning, and custom accounting GPTs.
  • Advanced Data Analysis can upload real .xlsx files and execute Python code to calculate exact figures
  • o1 reasoning model excels at multi-step tax math and audit logic
  • Custom GPTs allow building dedicated bots with uploaded company accounting policies
Free tier (GPT-4o mini); Plus at $20/month Turn off 'Improve the model for everyone' in Data Controls settings before working on sensitive company data.
Microsoft 365 Copilot Microsoft Best Excel Integration Direct in-app Excel, Word and PowerPoint workflow integration without leaving the Microsoft Office ecosystem.
  • Native integration into Excel ribbon: creates formulas, highlights rows, and creates pivot charts
  • Drafts management reports in Word directly from Excel table inputs
  • Enterprise security boundary respects corporate data governance and does not train on tenant data
Enterprise add-on ($30/user/month); Copilot Pro for personal ($20/month) Works best with clean Excel Tables (Ctrl + T); struggles with merged cells or complex irregular layouts.
Google NotebookLM Google Zero-Hallucination Research Grounding research strictly in official PDFs (IFRS Standards, Bangladesh Income Tax Act 2023, ICAB Study Manuals).
  • 100% grounded in your uploaded source documents — every sentence has clickable footnote citations
  • Generates comprehensive study guides, FAQ sheets, and audio podcast discussions from course material
  • Zero risk of external hallucinations because it only queries the uploaded PDF files
Completely Free Cannot browse the live web; its answers are only as good as the PDF documents you upload into the notebook.
Perplexity Pro Perplexity Best for Web Research Finding live regulatory updates, NBR circulars, SRO numbers, exchange rates, and business news with direct source URLs.
  • Real-time web search with linked citations for every sentence
  • Pro Search breaks down complex queries into multiple search steps for thoroughness
  • Allows toggling between Claude, GPT-4o, and Sonar reasoning engines
Free basic search; Pro at $20/month Always click the source link to verify the original gazette or newspaper article for accuracy.

Professional Standards & Ethics

The 5 Golden Rules of AI in Accounting

IESBA Code Compliance

Artificial intelligence is an extraordinary cognitive accelerator, but Chartered Accountants and auditors are held to strict standards of competence, confidentiality and due care.

Rule 1

Never Paste Unredacted Client Data

Never input real client names, Tax Identification Numbers (TIN), employee salaries, or proprietary bank account numbers into public AI tools. Always anonymize data (e.g. replace 'XYZ Ltd' with 'Company A', scale numbers by 10x).

Rule 2

Trust But Recalculate

LLMs are probabilistic language models, not calculators. Never accept financial totals, tax liabilities, or amortization schedules generated by AI without verifying the math in an Excel spreadsheet.

Rule 3

Cite the Authoritative Standard

AI is a drafting assistant, not an authoritative auditor or NBR gazette. Every accounting decision must cite the official standard (IAS/IFRS) or Act (Income Tax Act 2023), verified against the official text.

Rule 4

Document AI Use in Workpapers

Under evolving ISA and quality management standards, professional audit and consulting documentation should note where AI was utilized for drafting, summarization or data cleansing.

Rule 5

The Human Holds Professional Responsibility

The Chartered Accountant or finance professional signs the balance sheet, tax return or audit report — not the AI model. Professional skepticism and accountability always remain with you.

Video Tutorials & Shorts

Learn AI Video Lessons

Filter all videos →
Practical AI tutorial videos and Shorts are currently being produced. Subscribe on YouTube to get notified.

Educational content only. AI generated calculations or memos should always be verified by a qualified accounting professional before being used in formal reporting or filings.