Tabellab
Accounting Intermediate

Chart of Accounts Design & Mapping: Number Ranges, Account Types, Code Segments, Old-to-New Mapping, Mapped Trial Balances, Report Lines, Validation Rules, Cut-Over & a Migration Dashboard

Work through 20 hands-on labs at a fictional wholesale and service group – classify accounts by number range, check normal balances and code segments, find duplicates and dormant accounts, map old accounts to a new six-digit chart, roll a mapped trial balance into report lines, validate journal lines, carry opening balances across the cut-over and build a migration dashboard – with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

In 20 hands-on labs you redesign the chart of accounts of a fictional wholesale and service group. You classify accounts by number range with approximate lookups, check normal balances and signed amounts, split full codes into entity, account and cost-centre segments, and find duplicate and dormant accounts. Then you map old accounts to a new six-digit chart, handle split and merged mappings, roll a mapped trial balance with SUMIFS, prove control totals and build P&L and balance-sheet lines. Validation rules, cost-centre combinations, intercompany pairs, opening balances at cut-over, restated comparatives and chart health KPIs lead to a final migration dashboard.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. Trial Balance at a Glance: Types, Sides and TotalsLabFree
  2. Number Ranges: Classes, Gaps and StraysLab Locked
  3. Account Types, Normal Balances and SignsLab Locked
  4. Account Code Anatomy: Segments and Format ChecksLab Locked
  5. Duplicates and Dormant AccountsLab Locked
  6. Level of Detail: Busy, Thin and Merge CandidatesLab Locked
  7. The Mapping Table: Old to New with XLOOKUPLab Locked
  8. One-to-Many and Many-to-One MappingsLab Locked
  9. The Mapped Trial Balance and the Control TotalLab Locked
  10. Reporting Hierarchy: Report Lines and a P&LLab Locked
  11. Balance-Sheet Lines and the Balance CheckLab Locked
  12. Cost Centres: Allowed CombinationsLab Locked
  13. Validation Rules for Journal LinesLab Locked
  14. Multi-Entity Charts: Local to Group AccountsLab Locked
  15. Intercompany Account PairsLab Locked
  16. Opening Balances at Cut-OverLab Locked
  17. Comparatives: Restating Last YearLab Locked
  18. Change Requests: Days to Decide and Chart GrowthLab Locked
  19. Chart Health KPIs Against TargetsLab Locked
  20. Final Project: Chart of Accounts Migration DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy