Two Companies, One Dashboard: Why Adding the Numbers Is Not Enough

A second company often arrives before a second reporting process. One spreadsheet is copied, totals are added and the group dashboard looks finished.

But two accurate sets of accounts do not automatically produce an accurate group view. Internal charges can inflate revenue, different account mappings can hide costs and a combined cash balance can conceal pressure in one company.

A group total needs a defined perimeter and an explainable reconciliation. It is not just a larger sum.

Define what belongs in the report

List the legal entities in scope, reporting dates, currencies and accounting basis. Distinguish the entity that owns a record from a brand, trading name or operational division. A brand label is useful for analysis but does not by itself define a legal reporting group.

This article addresses a simplified management-reporting example. Statutory consolidation, control assessments and accounting policies require professional judgement; do not treat the example as a conclusion about which companies must be consolidated.

Begin with a common account mapping and a consistent cut-off. Preserve each company's source accounts and record the mapping and adjustments separately so the combined view can be explained.

Watch what an internal charge does

Illustrative example. Company A earns A$200,000 from external customers and charges Company B a A$30,000 management fee. Company B earns A$150,000 externally. A has A$100,000 of expenses; B has A$110,000, including the management fee.

The example is in one currency, ignores tax and other adjustments, and assumes the two entities are appropriately included in the same management group.

Illustrative revenue and expense reconciliation — A$000

Item	Company A	Company B	Simple total	Group adjustment	Group view
Revenue	230	150	380	−30	350
Expenses	100	110	210	−30	180
Profit	130	40	170	0	170

Adding the companies gives revenue of A$380,000. Only A$350,000 comes from outside the group. Removing the internal A$30,000 from revenue and the matching expense leaves group profit unchanged at A$170,000.

That is why an apparently sensible profit total does not prove every group measure is right. Revenue, expense ratios and growth comparisons can still be distorted.

Fathom's eliminations guide explains the removal of intercompany transactions, including management fees and loans, and describes different implementation methods. The arithmetic here is an original simplified example of the underlying issue.

Reconcile both sides before eliminating

Match the entity pair, amount, period and account. A charge recognised in one company but missing from the other needs investigation, not a convenient balancing entry.

Similarly, if A records an intercompany receivable of A$20,000 and B records the matching payable, those reciprocal balances are removed from the combined view in this simplified example. The adjustment does not move money between their bank accounts.

Maintain an adjustment record with the reason, preparer, supporting reference and review status. Keep external transactions out of an elimination intended only for internal amounts. Mixed accounts need more care than dedicated intercompany accounts.

Keep entity cash visible alongside group cash

Suppose A has A$100,000 in cash and B has A$10,000. The arithmetic group total is A$110,000, but it does not establish that B can meet a A$25,000 payment when due.

Do not assume cash can move freely between legal entities. Availability, restrictions, approvals, agreements and legal obligations need to be considered by the relevant advisers and decision-makers.

Show each entity's expected receipts and payments before relying on the combined cash outlook. Our 13-week cash guide can be applied to each defined cash perimeter.

Compare like with like

Group growth can result from adding a company rather than improving the existing operations. Separate changes in reporting scope from underlying performance. State when an entity enters or leaves the comparison.

For different currencies, use a documented translation approach appropriate to the report and its purpose. Do not apply a single unexplained exchange rate to every statement and assume it resolves all differences.

Keep account mappings, reporting periods and adjustment methods stable enough for a meaningful comparison. Record the effect of any change rather than quietly rewriting the history.

Make the dashboard a starting point

A useful group dashboard lets the reviewer move from the combined total to the contributing entities, source records and adjustments. It should also make missing or unreconciled inputs obvious.

Connect the resulting view to the monthly business review and the forward financial model. Explore MagicHub for our approach to connected business planning; verify the precise multi-entity capabilities required for your circumstances in a product demonstration.

General business education only, not accounting, tax, legal or financial advice. Worked examples are fictional and simplified, not customer results or industry benchmarks. Confirm the assumptions and obligations that apply to your business with your adviser.