What it means
A company report adds revenue from a parent account and all subsidiaries, but one subsidiary's sale appears twice. Revenue operations account hierarchy revenue rollup accuracy checks whether group totals reflect the intended legal and reporting structure without duplicate value.
A parent-child relationship is a CRM association, not automatically proof of accounting consolidation or legal obligation. HubSpot supports parent and child company labels, but the organisation still needs a rule for which entities and transactions belong in each rollup.
Define the report purpose (sales pipeline, bookings, billings, recognised revenue or customer lifetime value), because the same group can have different valid totals for different purposes. Identify each legal customer entity and stable account ID, decide which account owns a sale that is booked to a parent but invoiced to a child, and use a dated hierarchy snapshot for period comparisons.
Do not sum a parent's already-consolidated total with its children again, and do not let a reseller account and its end customer both count the same vendor sale. If a subsidiary is acquired mid-period, record the date it enters the hierarchy, and if one is sold, preserve historical views and define how current reports treat its earlier revenue.
For a joint venture, an account relationship does not establish the share recognised by the reporting company, and a transaction covering several subsidiaries should be allocated under the published rule, with the rule and percentages retained so the group total still equals the original source amount. For multi-currency groups, use the report's stated exchange-rate convention, and if a duplicate CRM company is merged, map its old ID and transactions before refreshing the rollup.
Define accurate as a group total that can be rebuilt from distinct in-scope transactions assigned once under the effective hierarchy, and count each group-period rollup due for review, including ones with missing entity mappings. Show value differences and affected accounts, not just the share of totals matching, because an exact total match can conceal two offsetting errors and component transactions should be sampled.
A dashboard filter that drops a child account may understate group value without an obvious error, and a group with several contract parties needs each source agreement retained for reconciliation. For a shared contract, the legal party and delivery sites should stay traceable even if the dashboard shows only the parent name, and a renewal should avoid double-counting the old and new contract in the overlapping transition period.
An annual recurring value and a one-time setup fee should not be added without a clear metric definition, and a report that combines bookings and billing should separate those columns rather than calling the total revenue. Keep finance consolidation rules separate from sales territory ownership, pair rollup accuracy with invoice entity and account assignment measures, and disclose whether a child linked for relationship management only is excluded from revenue grouping; where relationships are disputed, place the group total under review rather than guessing; if the parent name changes, the stable relationship ID should preserve history.
Restricted customer pricing should be visible only to permitted reviewers, exports to finance should use the same account mappings, hierarchy rules should be reviewed after mergers and product migrations, and each monthly close should reconcile new child accounts and deactivated entities against the mapping table because a one-time clean-up can drift. A correction should preserve the published earlier report and mark the revised total, so group-level numbers can be trusted without erasing the entities behind them.
In practice
Real-world examples.
Example
A parent and two subsidiaries' distinct bookings appear once each in the group total.
Example
The parent already includes a child's sale, but the dashboard adds the child again. The rollup fails.
Example
A subsidiary acquired midyear enters the report from the stated effective date.
Formula
Calculation
Illustrative accuracy = defined group-period rollups matching the rebuilt transaction total / all group-period rollups reviewed x 100; show value variance.
Worked example: a fictional reviewer rebuilds 40 group-period rollups from their distinct transactions, and 36 match the reported totals. Accuracy is 36 / 40 x 100 = 90%. The 4 failing rollups overstate group revenue by $120,000 in total against $4,000,000 of reported group revenue, so the value variance is $120,000 / $4,000,000 x 100 = 3%. Reporting both figures shows that most rollups are right while the errors are few but still worth fixing.Case study
Seen in the real world.
This fictional case follows Cedar Grove Analytics. A new account hierarchy import linked a subsidiary to its parent while the parent's existing total already included that subsidiary. Revenue operations removed the duplicate and saved both the original and corrected report.
The case is invented. Cedar Grove then added a monthly check that rebuilds each group total from its distinct transactions before the report is shared. It also recorded the effective date each subsidiary joined the hierarchy, so later period comparisons used the correct structure.
Watch out
Common mistakes.
- 1. Treating a CRM parent-child label as a legal consolidation rule.
- 2. Counting one transaction under both parent and child.
- 3. Comparing different revenue measures as if they were one total.
Questions
People also ask.
Does a parent account always include child revenue?
No. Define the report scope and effective hierarchy.
Can exact totals still be wrong?
Yes, offsetting errors can cancel. Sample the component records.
What if a company is acquired midyear?
Use the stated effective date and preserve historical snapshots.
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
