Building an accounting system with Excel and AI
Main course, Stage 1: Foundation and planning, Stage 2: Building the core, Stage 3: Modules, Stage 4: Automation and interfaces, Stage 5: Security and operation, Stage 6: Analysis and smart reporting, Specialised applied projects
Main course4 courses
-
Building a Complete Accounting System with Excel and AI Tools
Building a full accounting system in Excel from planning to going live, using AI tools at each stage.
-
From a Blank Sheet to an Accounting System: Excel and AI Step by Step
A graded path that starts with an empty workbook and ends with a working system, explaining each step and why.
-
Design Your Own Accounting System with No Programming Experience
For accountants who do not code: designing a system that fits the business using formulas and built-in tools.
-
The Accountant-Developer: Excel, VBA and AI
Combining advanced Excel, VBA and AI tools to build accounting solutions.
Stage 1: Foundation and planning4 courses
-
Analysing and Designing the Accounting System before Building
Defining the business’s needs and the system’s outputs and inputs, and mapping it out before opening Excel.
-
Building the Chart of Accounts in Excel
Designing a numbered, multi-level chart of accounts that underpins every report in the system.
-
Designing the Data Structure and Excel Tables
Organising data into Excel Tables with fixed columns and clear relationships, so formulas and reports work reliably.
-
Prompt Engineering for Building Accounting Systems
Writing precise prompts for AI tools to get usable formulas, code and designs.
Stage 2: Building the core4 courses
-
Designing an Automated Journal
A journal entry sheet that checks the entry balances and the accounts are valid before saving.
-
Ledger and Trial Balance with Dynamic Formulas
Producing the ledger and trial balance straight from the journal using dynamic array formulas.
-
Automated Posting with AI Assistance
Building automatic posting of entries to accounts, with formulas or code written with AI assistance.
-
Automated Financial Statements: Income, Balance Sheet and Cash Flow
Financial statements that update automatically from the trial balance when the period is selected.
Stage 3: Modules7 courses
-
Sales and Purchase Invoicing Module
An invoice form that records the transaction, updates stock and customer and supplier accounts, and creates the entry.
-
Inventory, Stocktaking and Stock Valuation Module
Item cards, receipts and issues, stock valuation, and stocktaking reports.
-
Customers, Suppliers and Debt Ageing
Customer and supplier statements, the ageing report, and tracking collections and payments.
-
Cash, Banks and Receipt and Payment Vouchers
Receipt and payment vouchers, cash and bank movements, and bank reconciliation.
-
Payroll Module
Employee data, calculating entitlements and deductions, and the payroll sheet and its entry.
-
Fixed Assets and Depreciation Module
A fixed asset register, calculating periodic depreciation by different methods, and its entries.
-
VAT Reports and Returns
Extracting output and input VAT from invoices and preparing the return data.
Stage 4: Automation and interfaces5 courses
-
Writing VBA Code with AI without Learning to Program
Asking AI tools for the code, running it, and understanding it well enough to adjust and fix it.
-
Designing Data Entry Forms (UserForms)
Entry forms with drop-downs and validation that stop errors before they reach the tables.
-
Main Menu, Navigation Buttons and a Professional Interface
A main screen and navigation buttons that make the workbook behave like an application rather than a spreadsheet.
-
Power Query for Linking and Refreshing Data
Linking the system’s tables and external files and refreshing them in one click.
-
Printing Invoices and Reports and Exporting to PDF
Print templates for invoices and reports, and one-button export to PDF.
Stage 5: Security and operation4 courses
-
Users, Permissions and Passwords
A login screen, users with different permissions, and a record of who entered and changed what.
-
Protecting the Workbook and Formulas, and Backups
Protecting sheets and formulas from changes, and backing the file up regularly.
-
Testing the System and Fixing Errors with AI
Testing with sample data, tracing errors, and using AI to help fix them.
-
Closing the Financial Year and Carrying Forward Opening Balances
Closing the year’s accounts and creating the new year’s file with its opening balances.
Stage 6: Analysis and smart reporting3 courses
-
An Interactive Financial Dashboard inside the System
A dashboard showing revenue, expenses, liquidity and profit that updates with the system’s data.
-
Analysing Accounting Data with AI in Excel
Using AI tools to summarise data and spot patterns and outliers.
-
Management Reports and Financial KPIs
Periodic management reports and financial KPIs drawn directly from the system.
Specialised applied projects6 courses
-
An Accounting System for a Retail Shop with Excel and AI
A complete project for a shop: sales, purchases, stock, cash and reports.
-
An Accounting System for a Bookshop or Supermarket with a Point of Sale
A fast barcode sales screen linked to stock, cash and the accounts.
-
An Accounting System for a Contracting Company
Project accounts and progress billings, with each project’s costs, revenue and profitability.
-
An Accounting System for a Clinic or Medical Centre
Income from consultations and services, doctors’ accounts, expenses and income reports.
-
An Accounting System for an Accounting Firm with Several Clients
One workbook managing several clients’ accounts, with a separate chart of accounts and reports for each.
-
Turning the Excel System into a Web App with AI
Moving the system’s logic from Excel into a simple web app, with the help of AI tools.
Start with the course that fits you
Pick your course from the catalogue and register in a minute, or message us on WhatsApp if you would like guidance.