Statistical accounts and KPIs for groups: the complete guide
What a statistical account is, which ones a group should keep, and why a group KPI is built by adding the parts and dividing once. A worked month, what Zoho's pages say, and where Finconsol fits.
First published 2 Dec 2026. What changed on 2 Dec
- First published.
In this post 11 sections
In short
A statistical account holds a number that is not money, such as headcount, room-nights or units sold, beside the financial accounts so ratios use the same data. A group rolls a ratio up by adding the top and bottom lines across its companies first and dividing once. Averaging the companies’ ratios gives the wrong answer.
Key takeaways
- A statistic is a number with a unit, held beside the ledger with the same company, month and group structure.
- Roll up the parts, then divide. Revenue per employee for the group is group revenue over group headcount, not the average of the companies’ figures.
- Write each definition down once. Month-end or average headcount, rooms available or rooms open: pick one and use it everywhere.
- Keep statistics in the same place as the money. Then they lock with the month, carry the same history and feed the same board pack.
This guide is the hub for the statistical accounts and KPIs series. The posts that follow cover the KPIs a group should report every month and the monthly board pack. The list of posts appears at the foot of this page as each one is published.
What is a statistical account?
A statistical accountStatistical accountA non-money figure such as headcount, units sold or stores, held alongside the financial accounts so that ratios can be calculated from the same data.Open the glossary entry is an account that holds a quantity instead of an amount of money. Headcount, hours worked, units sold, stores open, rooms available and room-nights sold are the usual examples. It sits alongside the financial accounts, with the same company, the same month and the same place in the group structure, so that a ratio can be built from the ledger and the statistic together.
The reason groups need them is simple. The questions a board asks are rarely answered by money alone. Is revenue growing because we sell more, or because we charge more? Is cost per unit falling? Did a hotel fill its rooms or only raise its prices? Each of those questions divides an amount from the ledger by a quantity that the ledger does not hold.
Which statistics should a group keep?
Start from the ratios the board already asks for and work backwards to the numbers they need. A short list is better than a long one: a figure that nobody can supply on the fourth working day will be missing in the third month.
- Services: headcount, billable hours, available hours. These give revenue per employee, utilisation and revenue per billable hour.
- Hospitality: rooms available, room-nights sold, covers served. These give occupancy, average daily rate and revenue per available room.
- Software and subscriptions: headcount, customers, seats. These give revenue per employee and revenue per customer.
- Retail and distribution: stores open, units shipped, floor area. These give sales per store, cost per unit and sales per square metre.
- Every sector: month-end headcount, because people cost is the largest line in most groups.
Write the definition of each next to its name: what is counted, at what date, and by whom. Headcount is the usual trap. Month-end headcount, average headcount and full-time equivalents give three different answers for the same company, and a group that mixes them has no ratio worth comparing.
Free: KPI library for multi-company groups
This free Excel library holds forty measures for groups of companies in services, hospitality, software, manufacturing and retail. For each it gives the formula, the statistics you need to record, the money accounts it draws on and who it is good for. A calculator works out any measure for up to eight companies and rolls it up correctly for the group.
- Forty measures grouped by sector: services, hospitality, software, manufacturing and retail.
- The formula for each, with its numerator, denominator and multiplier.
How do you roll a ratio up across companies?
Add the numerators, add the denominators, then divide once. This is the rule that the whole subject turns on, and it is the one most often broken in a spreadsheet, where the easy formula is the average of the column.
This example uses three of Zenvara’s five companies and treats them as the group: Zenvara in the United Kingdom, Fernhollow in the United States and Palmridge in the United Arab Emirates. Their September 2026 revenue is translated at each company’s average rateAverage rateThe exchange rate for a period, usually the month, used to translate a foreign subsidiary's income and expenses into the group's presentation currency.Open the glossary entry into pounds sterling, the group’s presentation currencyPresentation currencyThe currency in which the group's financial statements are presented.Open the glossary entry. Zenvara also billed Palmridge AED 400,000 for services, which is group revenue only once, so it comes out before the group figure is divided.
| Company | Revenue | Employees | Revenue per employee |
|---|---|---|---|
| Zenvara (United Kingdom) | 625,000 | 42 | 14,881 |
| Fernhollow (United States)USD 460,000 at 0.7540 | 346,840 | 31 | 11,188 |
| Palmridge (United Arab Emirates)AED 4,800,000 at 0.2025 | 972,000 | 118 | 8,237 |
| Less: Zenvara’s services to PalmridgeAED 400,000 at 0.2025 | (81,000) | ||
| Three companies | 1,862,840 | 191 | 9,753 |
Example group used across Finconsol guides. Revenue as in the group revenue example, for these three companies only; headcount figures are illustrations. Headcount is month-end. Figures rounded to the pound.
The group figure is 1,862,840 divided by 191, which is 9,753 per employee. The average of the three company figures is 11,436, which overstates the group by 1,683, or 17 percent. The error is easy to see once the sizes are in view: Palmridge has 118 of the 191 people and the lowest revenue per head, so it should pull the group figure down far more than a plain average allows.
The same rule governs the intragroup revenue. The standard requires intragroup income and expenses to be eliminated in full1, so the 81,000 comes out of the numerator. Leave it in and revenue per employee rises to 10,177 for no reason except an invoice between sister companies.
| Company | Revenue | Employees | Per employee |
|---|---|---|---|
| Zenvara | 625,000 | 42 | 14,881 |
| Fernhollow | 346,840 | 31 | 11,188 |
| Palmridge | 972,000 | 118 | 8,237 |
| Intragroup revenue | (81,000) | ||
| Three companies | 1,862,840 | 191 | 9,753 |
The same logic applies outside money. Take two hotels in one hospitality group. The first sold 9,000 room-nights for AED 3,708,000, an average daily rate of AED 412. The second sold 6,000 for AED 2,160,000, which is AED 360. Together they sold 15,000 room-nights for AED 5,868,000, so the group rate is AED 391.20. The average of 412 and 360 is 386, which is wrong by more than five dirhams on every night sold.
What happens when the companies report in different currencies?
A ratio that divides money by a quantity needs the money in one currency, and the quantity needs no translation. Translate the numerator the way the statements are translated: income and expenses at the average rate for the month, balances at the closing rate2. Then divide. Palmridge’s revenue per employee of AED 40,678 and its sterling figure of 8,237 are the same fact in two currencies, and the board should know which one it is looking at.
Two cautions follow. A ratio is not translated; the pieces are. And a ratio that rises or falls because a rate moved, not because anything happened in the business, should be shown once at constant rates, usually last year’s. The average rateAverage rateThe exchange rate for a period, usually the month, used to translate a foreign subsidiary's income and expenses into the group's presentation currency.Open the glossary entry and the closing rateClosing rateThe spot exchange rate on the last day of the reporting period, used to translate a foreign subsidiary's assets and liabilities.Open the glossary entry should be the ones the group already sets for its statements, so that the statistics and the accounts agree.
Where should the statistics live?
There are three common answers, and the first two are where most groups begin.
- A spreadsheet beside the accounts. It is quick to start. It breaks when the person who keeps it is away, when a company is added, or when last month’s number is changed after the pack has gone out.
- Dummy accounts in the ledger. Some firms post a statistic as a pair of journal lines that cancel out. It keeps the number in the system, but it adds lines to the trial balance that mean nothing in money terms, and anyone reading the trial balance has to know to ignore them.
- A statistic held as a statistic. A quantity with its own unit, kept by company and month, that can be used in a ratio and never added to an amount of money by mistake.
The third is the one to aim for. A statistic kept apart from the money, but in the same structure, can lock with the month, be corrected with a trail and carry its history without anyone adding it to the profit and loss.
What does Zoho Books offer for statistics and KPIs?
Checked against Zoho’s help centre on 29 Oct 2026. Zoho’s plan comparison page lists the features of each Zoho Books plan3. It has no row for statistical accounts. It has a row “Add and track KPIs for your business”, which it shows as included in the Ultimate plan only. Zoho Books works within one organization at a time, and the pages checked do not describe a view that combines the figures of several organizations4. For a group, then, a headcount or a room-night count still has to be held somewhere outside the books, and the ratios built across companies have to be built outside them too.
This is a statement about what Zoho’s own pages say today, not about what the product cannot be made to do. Anyone running a group on Zoho Books should check the plan page on the day they decide.
How do you set up statistics for a group?
- List the ratios the board asks for. Write each as a fraction: what is on top, what is below.
- Name every statistic those fractions need, with its unit and its definition.
- Decide who supplies each number and by which working day. A site manager can give room-nights on day one; payroll can give headcount on day two.
- Use the same calendar as the accounts. A statistic for a month the books have not closed will change, and so will the ratio.
- Load history. A KPI with no prior year is a number; with twelve months it is a trend.
- Lock the statistics with the month. If a number changes after the pack is out, the change should be recorded, not silent.
Which mistakes come up most often?
- Averaging ratios. Covered above. It is the most common and the most expensive.
- Mixed definitions. One company counts contractors in headcount, another does not.
- Statistics that are not tied to the accounts. If revenue is restated, revenue per employee must move with it, which only happens when both live together.
- Missing months. A statistic that stops in March makes every ratio after March wrong, or quietly blank.
- Too many KPIs. Twelve well-chosen measures are read; forty are filed.
Where does Finconsol fit?
Finconsol is a consolidation product for groups. It reads each company’s books, maps them to one group chart of accounts, translates other currencies, eliminates what the companies owe or sell each other and shows the outside owners’ share. Statistics and KPIs are part of it, not a separate tool.
- Statistics: you create a line for each figure you care about, such as headcount, units, stores or room-nights. Each line holds a figure for every company and month, filled from a grid, a file upload or a one-time history load, and each line carries its own rule for the group total. Nothing is posted to anyone’s ledger.
- KPIs: formulas that mix financial lines and statistics, such as revenue per employee, built by clicking the two lines you want, and shown on dashboards and in your own report layouts. Data Health shows which companies have sent which statistics, so a gap is seen before the report goes out.
- Your systems: Zoho Books is connected directly, read only, with a nightly refresh. Xero and QuickBooks companies come in by trial balance upload today, with a direct connection coming soon, and a company in any other system comes in by trial balance.
- Budgets and latest estimates, board packs, locked months and a change log use the same figures. When the month closes the figures freeze, and a locked board pack keeps the numbers the board read.
A group that is happy with a well-kept spreadsheet can use the KPI library offered with this guide, with its formulas and roll-up rules, without Finconsol.
In this series
- Statistical accounts and KPIs6 min
Revenue per employee, occupancy and cost per unit: KPIs a group should report every month
Three KPI families that cover most groups, a worked month for two hotels, and the rule that stops a group figure being wrong: add the parts, then divide once.
- Group reporting6 min
A monthly board pack for a group of companies: what goes on each page
The ten pages of a monthly group board pack, in the order a board reads them, with a worked income statement page against budget and what to leave out.
Questions
What is a statistical account?
A statistical account holds a quantity, such as headcount, units or room-nights, instead of an amount of money. It is kept beside the financial accounts by company and month so that KPIs such as revenue per employee or occupancy can be worked out from the same data.
How do you calculate a group KPI from several companies?
Add the numerators across the companies, add the denominators, and divide once. Do not average the companies’ own ratios. Take intragroup amounts out of the numerator first, and put money in one currency before dividing.
Does Zoho Books have statistical accounts?
Zoho’s plan comparison page, checked on 29 Oct 2026, has no row for statistical accounts. It lists “Add and track KPIs for your business” as included in the Ultimate plan only. Check the page on the day you decide, because plans change.
Which KPIs should a holding company report monthly?
Start with the ratios the board already asks for: revenue per employee, margin, and the one or two measures specific to the sector, such as occupancy for hotels or utilisation for services. Add one only when someone can supply its numbers by the fourth working day.
Sources
- IFRS 10 Consolidated Financial Statements, paragraph B86(c).
- IAS 21 The Effects of Changes in Foreign Exchange Rates, paragraphs 39 and 40.
- Zoho Books, plan comparison. Checked against Zoho’s help centre on 29 Oct 2026.
- Zoho Books, adding an organization and managing multiple organizations. Checked on 29 Oct 2026.
Prabhu, A. (2026, 2 December). Statistical accounts and KPIs for groups: the complete guide. The Finconsol Blog. https://finconsol.com/blog/statistical-accounts-and-kpis-for-groups/
Amit Prabhu leads Finconsol at Aaxonix Tech, a Zoho and NetSuite implementation partner based in Pune, India. He works with multi-company groups and the accountants who serve them on closing many sets of books into one set of group numbers.