Designing a Chart of Accounts That Actually Reports
A chart of accounts is a decision you make once and live with for years. Designed well, profit by product or branch is two clicks away. Designed badly, every management report becomes a spreadsheet project. This covers the four-level structure, the tax-driven accounts, and how to rebuild without losing history.
The four levels
- Group — the top classification, mapping directly to the financial statements: current assets, current liabilities, revenue, and so on.
- General — the main headings within each group: cash, trade receivables, inventory.
- Subsidiary — the level that identifies the nature of the item: rial bank account, foreign-currency account, petty cash.
- Detail (floating) — the counterparties: customers, suppliers, employees, projects, cost centres.
The governing rule is simple: keep the upper levels few and fixed, and let the detail level float without limit. Every time you are tempted to create a subsidiary account for a new customer, you are damaging your own reporting structure.
In companies that come to me for a rebuild, the diagnosis is nearly always the same: the subsidiary level has grown until the trial balance runs to hundreds of lines and nobody can make a decision from it.
A workable group structure
| Group | Title | Example general accounts |
|---|---|---|
| 1 | Current assets | Cash, trade receivables, inventory, prepayments |
| 2 | Non-current assets | Property and equipment, accumulated depreciation, intangibles |
| 3 | Current liabilities | Trade payables, tax payable, payroll payable, advances received |
| 4 | Non-current liabilities | Long-term borrowings, termination benefit provision |
| 5 | Equity | Capital, legal reserve, retained earnings |
| 6 | Revenue | Product sales, service revenue, returns and discounts |
| 7 | Cost of sales | Cost of goods sold, materials, direct labour, overhead |
| 8 | Operating expenses | Administrative, selling and distribution |
| 9 | Other and memorandum | Other income and expense, guarantees |
This is not the only valid split, but it aligns with conventional statement structure, which turns preparing a balance sheet into a summation rather than a reconstruction.
Accounts tax compliance demands
Separate these from the beginning or pay for it every quarter:
- Input VAT separate from output VAT, so the periodic return needs no manual rebuild.
- Withholding tax deducted, in its own account, split by payment type.
- Payroll tax and insurance payable, separate from other staff liabilities.
- Non-deductible expenses in dedicated accounts — penalties, gifts, excess entertainment — so the tax adjustment working paper builds itself.
- Owner drawings and partner current accounts, kept out of company expenses.
- Prepaid and on-account tax in independent accounts.
Complete every counterparty detail record with its economic code and national ID. That single habit cuts preparation of quarterly transaction reports from days to hours.
Cost centres and projects
Modern systems let one subsidiary account carry several floating dimensions, so freight can post against supplier, cost centre and project at once. Use it:
- Cost centres for organisational units: production, sales, administration, warehouse.
- Projects or contracts for contractors and made-to-order businesses; without it, contract-level profitability is guesswork. See contractor accounting.
- Branches or stores for multi-location retail.
Manufacturers need cost accounts that separate direct materials, direct labour and overhead, or product costing becomes an estimate.
Numbering rules
- Fix code length at the outset and keep it for the whole life of the system.
- Leave gaps — number subsidiary accounts 10, 20, 30 so later additions do not break the logic.
- Apply one logic across all groups, so the same suffix means the same kind of thing everywhere.
- Avoid reusing a code with different meanings in different groups.
- Keep titles short, with no personal abbreviations and no individuals' names.
- Write a one-line definition for each subsidiary account; that short document prevents the next accountant from reinventing it.
Frequent design errors
| Error | Practical effect |
|---|---|
| A subsidiary account per customer | Unusable trial balance, cluttered statements |
| No prepayment or advances-received accounts | Early recognition of income and expense |
| Deductible and non-deductible costs merged | Hours of extra work at filing time |
| No cost centres | No unit-level profitability analysis |
| A busy "sundry" account | Material items hidden from view |
| Restructuring mid-year | Comparative figures no longer reconcile |
Rebuilding without losing history
- Extract the current four-level trial balance and flag dormant accounts.
- Design the new structure on paper against the reports management actually needs.
- Build an old-to-new mapping table; every old account gets exactly one destination.
- Clean the detail level: merge duplicate counterparties, complete identity data.
- Migrate balances through a new opening entry and agree them to last year's statements.
- Test key reports on the new data before current-period posting begins.
- Publish the documented chart and require approval for any new account.
Migration mechanics between systems are in moving to new accounting software.
Key takeaways
- Keep upper levels fixed and few; push counterparties into the floating detail level.
- Separate the tax-driven accounts on day one; it pays back every quarter.
- Cost centres and projects are the difference between real reporting and guessing.
- Leave numbering gaps so future growth does not break the structure.
- Rebuild only at the start of a financial year, and only with a mapping table.
Frequently asked questions
How many levels should a chart of accounts have?
Why not create a general account for each customer?
Should we use a ready-made coding structure?
Can the structure be changed mid-year?
Have a question? Just ask
One short call is usually enough to know where you stand. If I miss you, I will call back.