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