Chart of Accounts Design

A numbering scheme, clear rules for accounts versus tracking categories, clean-ups, monthly and yearly checks, so the chart of accounts gives owners and managers reports they can actually use.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Chart of Accounts Design, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🧾 Finance & Accounting

Chart of Accounts Design

Designing, cleaning up and extending the chart of accounts, tracking categories and classes so reports answer the questions owners and managers actually ask.

  1. Ten questions the reports must answer
  2. Account usage census of the current chart
  3. Tax return and statutory accounts line requirements
  4. Account numbering scheme with room to grow
  5. Account naming and description standard
  6. Balance sheet control accounts set
  7. Revenue accounts by income stream
  8. Cost of sales and overheads boundary
  9. Account or tracking category decision rule
  10. Chart change owner and approval rule
  11. Monthly misused account check
  12. New account request log
  13. Tracking option list upkeep
  14. Monthly tagging completeness check
  15. Year-end chart of accounts review
  16. Chart of accounts master document and change log
  17. Report line mapping table upkeep
  18. Connected app posting map check
  19. Quarterly report test against the ten questions
  20. Budget lines matched to the chart each year
  21. Five account types and how they reach the statements
  22. Reading a trial balance by account range
  23. How larger systems split accounts and dimensions
  24. Charts of accounts compared across three industries
  25. Equity accounts for your legal form
  26. Header, total and posting accounts in report layouts
  27. Accruals, prepayments and deferred income accounts explained
  28. Duplicate account merge
  29. Dormant account archive
  30. Breaking up the sundry expenses account
  31. Restating or moving forward decision
  32. Payroll cost account structure
  33. Marketing spend accounts or channel tags
  34. Location or department tag rollout
  35. Customer and product reporting without extra accounts
  36. Grouping overheads for a one-page profit and loss
  37. Old to new account mapping for a software move
  38. Chart redesign cutover at the start of a financial year
  39. Chart readiness for investor due diligence
  40. Audit lead schedule mapping for the first audit
  41. Accounts set up for a new revenue stream launch
  42. Sole trader to company chart conversion
  43. Lean first chart for a newly incorporated startup
  44. Inheriting a chart as a new finance manager
  45. Second brand or business line in one set of books
  46. Multi-site retail or hospitality chart
  47. SaaS chart for recurring revenue and hosting costs
  48. Standard group chart across several companies
  49. Multi-segment account string for an ERP
  50. Metric definitions locked to account ranges

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Ten questions the reports must answer

Most charts of accounts grow one account at a time as bills arrive, so nobody can say which questions the reports were meant to answer. Writing down the ten questions owners and managers ask most, such as margin by service line, payroll as a share of revenue or spend by site, gives every later design choice a test to pass.

First tasks

  • Write down the five questions you ask most often about the numbers
  • Ask each manager and the accountant for their top two questions
  • Mark which questions today's reports cannot answer
  • Agree the final ten and save them with the chart notes

Account usage census of the current chart

Before changing anything, you need to know what is in the chart now: how many accounts exist, which carry most of the transactions and which have not been touched in a year. An export with twelve months of transaction counts and balances per account shows where the clutter, duplicates and overloaded catch-all accounts really are.

First tasks

  • Export the full chart of accounts from the accounting software
  • Run an account transactions summary for the last twelve months
  • Join the counts and balances to the exported chart in one sheet
  • Mark accounts with no postings, under five, or over five hundred

Tax return and statutory accounts line requirements

Your accountant has to turn the ledger into the annual accounts and the tax return, and every account that does not map cleanly to a line costs them time and you fees. Asking them once which lines they need, and which costs the tax authority treats differently, such as entertaining, fines or private use, means the chart separates what the year end needs separated.

First tasks

  • Email the accountant asking for a short meeting on the chart of accounts
  • Send them the account usage census before the meeting
  • Ask which costs the tax return needs kept in separate accounts
  • Write up their recommended changes and reasons the same day

Make it yours.

Install Chart of Accounts Design, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.