Building the Chart of Accounts in Excel
Designing a numbered, multi-level chart of accounts that underpins every report in the system.
Course contents
- 1Levels and numbering of the chart
- 2Main and sub-accounts
- 3Mapping accounts to the financial statements
- 4Adding an account without breaking reports
- 5Selection lists
What you gain from the course
You can design a flexible chart of accounts that underpins every report in the system.
Other courses in the same track
Stage 1: Foundation and planning
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.
12 training hours
Designing the Data Structure and Excel Tables
Organising data into Excel Tables with fixed columns and clear relationships, so formulas and reports work reliably.
12 training hours
Prompt Engineering for Building Accounting Systems
Writing precise prompts for AI tools to get usable formulas, code and designs.
12 training hours