AI · AIC-25

AI for Accounting & Finance

AI for Accounting & Finance is a course in using AI accurately for accounting and finance, from expense analysis and management reports to extracting data from invoices and contracts, budgeting and working in Excel and Google Sheets. It suits accountants, finance staff, finance managers, CFOs and SME owners who manage their own books.

Updated
From 6,210 THB / person 6,900 −10% excl. VAT 7% · group rates available
PDFDownload the course outline
  • Duration12 hours · 2 days
  • FormatOnsite / live online
  • Next roundOn request
  • CertificateIncluded

Course overview

Accounting and finance work is full of documents and detailed, repetitive tasks: recording and reconciling, preparing monthly financial reports, summarizing statements and analyzing expenses, reading contracts and financial documents, answering executives' questions about the numbers, and budgeting. These tasks are time-consuming and demand high accuracy. Generative AI greatly reduces the time spent on analysis and document work, but because finance work needs especially accurate numbers, the key is using AI the right way with a mechanism to verify the numbers every time before use. This course is designed to help accounting and finance teams use AI in real work confidently and safely, with

a focus on data accuracy, covering analyzing financial data, summarizing and reporting, reading and extracting data from documents (multimodal), budgeting and forecasting, using AI for Excel and Google Sheets, and setting up finance assistants and automation with Custom GPT/Gems and n8n, plus practices for accuracy, security and PDPA for financial data, which is sensitive. All content is taught through workshops on real accounting and finance tasks, finishing with a capstone project where learners set up an end-to-end AI toolkit for their own work. (2 days, 6 hours per day, 12 hours in total, Beginner to Intermediate level, no AI or programming background required.)

What you’ll gain

  • Understand how AI changes accounting and finance work and choose the right AI tool for each task
  • Design prompts for finance work and keep the output accurate and traceable
  • Use AI to analyze financial data, expenses and trends, and verify the numbers before use
  • Use AI to summarize and prepare financial reports for executives and draft financial documents
  • Use AI to read and extract data from financial documents, contracts and invoices (multimodal)
  • Use AI to help with budgeting and basic financial forecasting
  • Use AI for Excel and Google Sheets: creating formulas, explaining formulas and automation
  • Set up accounting/finance assistants and automation with Custom GPT/Gems and n8n
  • Understand AI limits with numbers and set verification mechanisms to prevent errors
  • Set security and PDPA practices for financial and sensitive data

Who this course is for

  • Accountants, accounting staff and finance officers
  • Finance, accounting, costing and budgeting teams
  • Accounting and finance managers and CFOs who want to set up AI use for their team
  • Business owners and SME entrepreneurs who handle accounting and finance themselves
  • Internal auditors and those working with financial data and documents

Prerequisites

  • General computer and internet skills
  • Basic Microsoft Excel or Google Sheets skills, such as opening files and reading data tables
  • Understanding of your accounting or finance work or team process to use as a case study during training
  • No AI or programming background required

Curriculum

Course Details

A 2-day course, 6 hours per day (12 hours in total), delivered as a hands-on workshop with a capstone project. Beginner to Intermediate level, no AI background required. Learners take home a finance prompt library, a finance assistant (Custom GPT/Gem), financial report templates, a number-verification checklist, and a security and PDPA checklist.

Day 1 AI for Financial Analysis and Reporting

Section 1: AI in Accounting and Finance

  • An overview of generative AI in accounting and finance and what changes in the process
  • AI use cases in finance: analysis, reporting, reading documents, budgeting and communication
  • Choosing the right AI tool for each task
  • AI limits with numbers: hallucination, calculation errors and misreading tables

Section 2: Effective Prompts for Finance Work

  • A good prompt structure for finance: role, context, data and output format
  • Instructing AI to show its reasoning and calculation steps so results are traceable
  • Using examples to keep the report format consistent
  • Building a team prompt library for monthly recurring work

Section 3: Analyzing Financial Data with AI

  • Using AI to analyze expense, revenue and trend data
  • Finding anomalies and issues worth checking
  • Comparing data across periods and finding financial insight
  • Workshop: use AI to analyze a sample expense dataset and summarize key points, verifying the numbers

Section 4: Summarizing and Preparing Financial Reports with AI

  • Summarizing statements and performance to be easy to read
  • Preparing monthly financial reports and executive reports
  • Writing clear management commentary alongside the numbers
  • Verifying the accuracy and consistency of reports before presenting
  • Workshop: prepare a one-page financial report from sample data with AI

Section 5: Financial Documents and Communication

  • Using AI to draft financial documents such as reminder letters, statements and clarification letters
  • Explaining finance and numbers to non-finance people
  • Drafting emails and communication with customers, partners and internal units
  • Workshop: draft one financial document or explanation with AI
Day 2 Documents, Budgeting, Assistants and Accuracy Control

Section 6: Reading and Summarizing Financial Documents (Multimodal)

  • Uploading and reading financial documents: invoices, receipts, contracts and financial statements
  • Extracting key data from documents, such as amounts, dates and terms
  • Summarizing the key points of contracts and long financial documents
  • Cautions on reviewing data extracted from documents

Section 7: Budgeting and Financial Forecasting

  • Using AI to help with budgeting and structuring expenses
  • Basic financial forecasting and scenario building
  • Prioritizing and analyzing the impact of assumptions
  • Workshop: build a simple budget or financial forecast outline with AI

Section 8: Accounting/Finance Assistants and Automation

  • Building a Custom GPT or Gem as an organization-specific accounting/finance assistant
  • Embedding policies, the chart of accounts and working guidelines for consistent results shared across the team
  • Automation with n8n, such as payment-due reminders or weekly expense summaries
  • Workshop: build one finance assistant for a task the team repeats every month

Section 9: Excel and Google Sheets with AI

  • Using AI to create and explain complex formulas in Excel and Google Sheets
  • Organizing, cleaning and reconciling data with natural-language commands
  • Creating pivots, data summaries and analysis tables
  • Exporting results as files with real formulas, not static numbers
  • Workshop: use AI to help build formulas and an expense-analysis table in Sheets

Section 10: Accuracy, Security and PDPA

  • Setting number-verification mechanisms and preventing errors from AI
  • Financial data that must not go into AI and protecting sensitive data
  • Personal data and customer data under PDPA for finance work
  • Setting the accounting and finance team's AI usage guideline

Section 11: Capstone Project and Real-world Adoption

  • Task: set up an end-to-end AI toolkit for the learner's accounting and finance work, from data analysis and reporting to a finance assistant
  • Present the work and get feedback from the instructor and peers
  • A first-30-days adoption plan and setting up AI use for the whole accounting and finance team

Schedule & training options

For individuals — public rounds

No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770

For organisations — in-house / private

  • Tailor the content to your team’s tools and projects
  • Your dates, at your office or live online
  • Quotation with tax ID for procurement
Corporate training quote

Instructors

Frequently asked questions

How do you use AI to extract data from invoices into an Excel table?

Define the columns you need first, such as document number, date, supplier name, tax ID, net amount, VAT and total. Upload the invoice PDFs or images to an AI tool that can read images, ask it to extract the data into those columns and leave a field blank when it cannot read it clearly. Put the results into Excel, check that net amount plus VAT equals the total, and spot-check against the originals.

Why does AI sometimes get figures wrong, and how do you prevent this in finance work?

Language models predict text rather than calculate like a calculator, so they can add incorrectly, mix up columns in a table or invent figures when data is missing. Ask the AI to show its working and formulas, have calculations done through Excel formulas or code rather than in its head, reconcile totals with the accounting system or source file, and require a person to review the figures before any report goes out.

How can AI help with budget versus actual variance analysis?

Prepare a table of budget and actual figures by account and month, and calculate the variances in amount and percentage with Excel formulas first. Then ask the AI to flag items beyond your threshold, group the likely causes and draft management commentary to accompany the numbers. Have someone who knows the real context confirm the causes before they go into the report.

Who is the AI for Accounting & Finance course for, and what should I know beforehand?

It suits accountants and finance officers, costing and budgeting teams, finance managers and CFOs who want to set up AI use for their team, internal auditors, and SME owners who keep their own books. You need general computer skills, basic Excel or Google Sheets use and an understanding of your team's accounting or finance work. No AI or programming knowledge is required.

What will I be able to do after the AI for Accounting & Finance course?

You will be able to write traceable finance prompts, use AI to analyse expenses and trends, prepare financial reports for management, read and extract data from invoices and contracts, support budgeting and basic forecasting, build and explain formulas in Excel or Google Sheets, and put number checks and sensitive-data practices in place. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.

Can the AI for Accounting & Finance course be run in-house for our team?

Yes. It can be run in-house for your team, with examples adapted to your own work, such as the report formats and documents your team handles every month, along with number-checking steps that suit your organisation. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.