What it means
Imagine a group that owns two businesses with different ledger codes for delivery expense. To prepare one management report, finance maps each local code to a shared reporting category.
The report can then compare like with like. A chart of accounts is the list of categories used to record transactions, while a report usually has fewer lines.
Mapping states how detailed accounts roll up into that structure. A source account can map to one target, several sources can roll into one broader line, and more complex rules may depend on entity, cost centre or product.
Classification needs judgement, not just matching names. Five separate bank accounts can feed a cash and cash equivalents report line if each qualifies, but a restricted deposit or long-term investment should not be added merely because it also appears in a bank account list.
Group policies can also differ from local ones, so a mapping alone does not resolve differences in recognition or measurement. Account mapping is used in consolidations (combining the accounts of a group into one set), system migrations, budgets and dashboards.
The same code may need one mapping for statutory accounts and another for internal analysis, so label each map with its purpose and effective period. Start with active accounts and their balances, define the target structure, and assign an owner to each rule.
The controls matter as much as the rules. Test that debits and credits remain balanced after the transformation, review accounts with unusual balances first, and include new codes in a monthly change check so they do not slip into an other expenses line by default.
Limit who can edit rules, record every change and have a second reviewer check material reclassifications. Compare periods using stable definitions.
If freight moves from overhead to cost of sales, gross margin changes even though profit does not, so explain the reclassification to avoid mistaking a reporting change for operating improvement. For owners, mapping is the bridge between bookkeeping and the numbers used to make decisions.
In practice
Real-world examples.
Example
Five qualifying bank balances map into a group cash line, while a restricted deposit is assessed separately. The group report shows only genuinely available cash, and the restricted deposit is disclosed in its own line.
Example
A subsidiary's local expense code maps to the group chart during consolidation. The parent can then add up like items across all its companies, even though each subsidiary keeps its own local codes.
Example
A new ledger code is held in an exception report until finance approves its reporting destination. It never reaches the management accounts by default. The exception clears only when a named person signs off the mapping.
Formula
Calculation
Unmapped active accounts = active accounts in scope - accounts with a valid target mapping
Reconciliation difference = source total - mapped total
Worked example. A ledger has 320 active accounts and 316 have been assigned a target.
Unmapped accounts = 320 - 316 = 4
Those four need review before the report is relied on. Separately, the source trial balance totals $2,450,000 and the mapped report also totals $2,450,000.
Reconciliation difference = $2,450,000 - $2,450,000 = $0
A zero difference shows nothing was lost or duplicated, but it does not prove every account sits on the correct line.Case study
Seen in the real world.
This entirely fictional example follows Sand Peak Group, an invented group with two trading companies, each with $1,000,000 of revenue. One subsidiary mapped $150,000 of freight into overhead, while the other placed comparable freight in cost of sales, so reported gross margins were 55% and 40% even though both businesses performed alike.
Finance reviewed the transactions, agreed a group policy and revised the rule with an audit trail. With freight mapped to cost of sales in both companies, each showed a 40% gross margin. Profit did not change simply because a report line moved, but the margin comparison became meaningful.
The group also added a monthly report listing any new account code and its proposed destination. That control caught two codes in the following quarter before they distorted a board pack.
Watch out
Common mistakes.
- Mapping by code name without checking the transactions and reporting definition.
- Allowing new accounts to fall into an unreviewed catch-all line.
- Changing a classification without reconciling totals or explaining prior-period comparisons.
Questions
People also ask.
What is account mapping?
It is the link between ledger accounts and another chart of accounts or reporting line. Each rule says which source account feeds which target line, and under what conditions.
When is it used?
It is used during reporting, consolidation, budgeting and moves between accounting systems. Any time two structures must be compared, a map is needed, and the quality of the map decides the quality of the comparison.
What goes wrong?
Amounts may land in the wrong line, giving misleading margins or trends even when the total still balances. The risk is silent, which is why reconciliation and review of new codes are essential. A quarterly sample of mapped transactions, traced back to source, is a simple extra check.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related