Financial master data: what it is and why it decides the accounting close

The month's result changed again, without anyone having sold more or spent less.

I have chased the cause on more than one SAP project over the almost thirty years I have worked with master data, and the end of the story is usually the same: a posting landed on the wrong cost center, a profit center was swapped at allocation time, or a new GL account was born outside the company's chart of accounts. The close runs late, controlling reclassifies everything again, and almost nobody outside the area realizes that the real problem is master data.

That is financial master data. And it is a domain that most companies treat as a system configuration detail, not as data governance.

Financial master data: what it is

Financial master data is the set of records that structures a company's accounting and control: the chart of accounts, the cost center, the profit center, the internal order, the project WBS element (PEP) and the allocation rules between those dimensions. They do not change with every posting. They are the structure where each new posting finds its place.

The difference from the accounting posting itself is simple. The posting is transactional data: it is born and exhausted in the day's operation, in a purchase, a sale, a payment. The cost center and the chart of accounts are master data: they stay there, month after month, giving meaning to every posting that arrives.

When that record is wrong, the error multiplies. A duplicated cost center splits an area's spending across two different places in the management report. A GL account created outside the approved chart of accounts becomes an exception that nobody understands a year later. The director looks at two different numbers for the same result center and does not know which to trust.

How it works in practice: chart of accounts, cost center and profit center

The chart of accounts is the company's official list of GL accounts, organized by nature: revenue, cost, expense, asset, liability. Every company with a relevant ERP, whether SAP, TOTVS or Oracle, has a master chart of accounts that controlling protects as a golden rule. Creating a new account outside that chart, without formal approval, is the most common way for financial master data to break from the inside, without anyone noticing right away.

The cost center organizes spending by responsible area: maintenance, purchasing, logistics, IT. It serves to measure who spent what, and it is the basis of a good part of the corporate budget.

The profit center plays a similar role, but for results: it organizes revenue and cost by business unit, product line or region, so the company can see which part of the operation makes a profit and which has been bleeding cash for months without anyone noticing.

The internal order and the WBS element (PEP) complete this set when control needs to be temporary, as in a project, a campaign or a construction job. They accumulate cost during the life of the initiative and are settled to the permanent cost center or profit center when it ends.

When the hierarchy between these dimensions is poorly designed, with a cost center reporting to the wrong area or a profit center without the corresponding cost center, every management consolidation carries a structural error that no report corrects afterward.

Who looks after financial master data

In most companies, this record is split between controlling, accounting and FP&A, with IT providing technical support for the ERP. The problem is that there is rarely a single owner, a financial data steward, responsible for approving the creation of a new account, a new cost center or a new profit center before it goes into production.

Without that owner, each area that needs a cost center creates its own, similar to another that already exists, and the web of cost centers grows in a disorganized way over the years. The audit usually finds it late, in the annual close reconciliation, when you can no longer simply delete what was created.

Financial master data governance means defining who approves the creation of these records, what the workflow process for that approval is and what the minimum quality rule is, such as a clear description, correct hierarchy and a link to the responsible area, before the record goes into the production system.

Which tools support this record

SAP holds a good part of the Brazilian corporate market in this domain and has a dedicated solution for it, SAP Master Data Governance for Finance (SAP MDG-F), which centralizes the creation and approval of the chart of accounts, cost center and profit center before replicating that data to the connected systems.

Outside the SAP universe, multi-domain MDM platforms such as Informatica, Stibo Systems, Reltio, Semarchy, Profisee and Ataccama also address financial master data, generally as one more domain inside a platform that already handles customer, supplier and material. The advantage of treating finance within the same governance as the other domains is using a single approval process, a single data steward concept and a single catalog of quality rules, instead of reinventing governance for each area of the company.

How to learn about financial master data

Those who want to go deep in this specific domain face a narrower path than general governance, because it mixes two worlds: controlling and master data. It is worth studying in depth the controlling modules of the ERP the company uses, understanding the logic of accounting allocation and, in parallel, studying the MDM fundamentals that apply to any domain: data quality, modeling, approval workflow, metadata.

The DAMA-DMBOK remains the background reference for understanding data governance broadly, and the CDMP certification, from DAMA itself, is recognized in the market for those who want to formalize that knowledge. I recorded a good part of that technical trajectory, including what I learned implementing SAP for almost twenty years, in the book Master Data Management: Fundamentos e Aplicações (book in Portuguese), published by Editora Brasport.

Career opportunities

Controlling and FP&A are among the areas with the most difficulty finding qualified labor, and professionals who understand both management accounting and data governance have a rare combination. That opens room for roles such as financial master data analyst, controlling data steward and SAP MDG-F consultant, generally better paid than the generic master data analyst role, precisely because they require mastery of both sides: the technical and the accounting.

For those already in accounting or controlling, learning data governance is a specialization path that tends to accelerate a career, because few internal colleagues have that repertoire.

Main questions about financial master data

What is financial master data? It is the structural records of a company's accounting and control: chart of accounts, cost center, profit center, internal order and WBS element (PEP), which give meaning to every accounting posting.

What is the difference between a cost center and a profit center? The cost center measures spending by responsible area. The profit center measures results, revenue minus cost, by business unit, product line or region.

Who should approve the creation of a new cost center? Ideally a financial data steward, within controlling, following a formal approval workflow that prevents duplication and incorrect hierarchy.

Does SAP MDG-F replace controlling? No. It centralizes and governs the creation of this record, but the decision on which cost center or GL account makes sense remains with controlling and accounting.

Is it worth having a separate governance process for finance? It depends on the size and complexity of the company. In groups with several business units and a consolidated close, yes. In smaller companies, the same governance used for customer, supplier and material usually already solves it.

MDM Academy: where to go deeper

We created MDM Academy to close exactly this gap: professionals in controlling, accounting and financial IT who need to understand master data governance without depending only on an ERP course or an isolated accounting course. It is 4MDG's school of governance and master data, with practical, direct training, built by someone who has been implementing this for almost thirty years.

If you work with the close, budgeting or financial records and feel that technical repertoire is missing in this area, it is worth getting to know MDM Academy or joining Data Club, where we discuss this kind of problem with people who live the same day-to-day.

Conclusion

Financial master data does not show up on the balance sheet, but it decides whether the balance sheet closes correctly. As long as the company treats the cost center and the profit center as a technical system detail, it will keep explaining result variances that are actually master data errors.

At your company, who approves the creation of a new cost center before it goes into production?