Blog · MIS and management reporting

Your MIS chart of accounts is not your statutory one, and that is fine

The board wants the business cut, the filing wants the statutory cut, and the same ledgers must produce both. How to hold two views, one set of books.

Short answer: keep one set of ledgers and two mappings over them. The statutory view groups by nature because a filing format says so. The management view groups by how the business is actually run. Neither is the “real” one, and neither should be typed twice.

Why the two views diverge

A statutory line says employee benefits expense. A business head asks what the sales team costs, which is some of that line plus some of travel plus some of a recharge from a shared services entity. Both are correct answers to different questions.

The problem is never the difference. It is that the management answer usually gets built in a spreadsheet, from an export, by one person โ€” and from that moment the two views can drift without anyone noticing.

What an MIS chart of accounts actually is

A mapping, held once, from every ledger in every entity to the management line it belongs to. Not a second ledger. Not a copy of the data. If the management pack and the books ever disagree, the mapping is wrong, and that is a much easier thing to fix than a reconciliation between two sets of numbers.

The test: can you take any figure in a management pack and open it out to the ledgers underneath? If not, the pack is an assertion.

The three places it breaks

A new ledger opened mid-year. Somebody opens a ledger in one entity in August. It belongs somewhere in the management view, but nobody maps it, so the pack for September is quietly short. Nothing errors โ€” the number is just smaller than it should be.

An entity that names things differently. An acquisition arrives with its own naming. Mapping it to the group’s management lines is a day’s work that nobody schedules, so for two quarters that entity is reported at a level of detail nobody else is.

A line that means two things. Other expenses in one entity is the bin for anything uncategorised; in another it is a real category. Mapped as one management line, it produces a number that is meaningless in a board pack and impossible to question.

How to hold it

  • One mapping, versioned. When a line moves, the change is dated. A board asking why a figure moved between quarters deserves an answer better than “we changed the pack”.
  • Nothing unmapped. A ledger with no management line is a hole in the pack, so it should be visible as one rather than silently excluded.
  • Both views from the same read. The management cut and the statutory cut come from one pass over the ledgers, so the totals cannot drift apart between them.

FINK holds the MIS chart of accounts as a mapping over the same data the books are on, with dimensional reporting for the cuts underneath it. If you want a sense of what slow management reporting is costing your group today, the value calculator works it out from your own answers.

Part of MIS and management reporting. Management reporting that does not agree with the statutory numbers is the commonest argument in a monthly review. These posts are about closing that gap.

Questions

Commonly asked

Why not just use the statutory chart of accounts for management reporting?

Because it is built for a filing format, not for how the business is run. A statutory line groups by nature; a business head wants it by product, region or channel. Forcing one to serve both usually means the management pack gets rebuilt by hand every month.

Does a second chart of accounts mean a second set of books?

No, and it should not. An MIS chart of accounts is a mapping over the same ledgers, not a parallel ledger. If the two ever disagree, the mapping is wrong rather than the books.

What happens when a new ledger is opened mid-year?

It has to be mapped before it can appear in a pack. An unmapped ledger silently dropping out of a management report is how a month's numbers quietly stop tying to the books.

Related

More on this

What is this worth to you?

Answer questions about your entities, your systems and the days your close takes today, and get a report with the working shown.

Arjun Parthasarathy, CA

Chartered accountant. Builds the reporting systems he wanted when he was closing the books by hand.

See what this is worth to you