Accounting4 min read2 views

Account Mapping

Account mapping links the account codes in a ledger to another chart of accounts or to a line in a report. It lets a company combine balances from different systems and present them consistently. A mapping rule must preserve the meaning of the account, not merely move its number into any available row.

From the Money Master HQ dictionary, founded by Shihan Sheriff (FCMA, CGMA, CPA (Australia), MBA (General), MBA (Data Science & AI), UAECA, CAAB, CAIS; VP of Finance at Nomod, CFO at Esanjo Ventures). How these definitions are written.

Last updated 8 Oct 2026

On this page

This term

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 1

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 2

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 3

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

Unmapped active accounts = active accounts in scope - accounts with a valid target mapping

Note

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.

Sources and further reading

Was this helpful?
Report an error
Disclaimer. The information provided in this finance dictionary is for educational and informational purposes only. It should not be construed as financial, investment, legal, or tax advice. Always consult with a qualified professional before making any financial decisions. Money Master HQ makes no representations or warranties about the accuracy, completeness, or suitability of this information. Use of this content is at your own risk.

Browse all terms