Consolidated Reporting for Groups Operating in Several EAC Countries
The owner of a regional group wants one honest answer to one question: how did the whole group do? Getting there without a quarterly spreadsheet ritual — the monthly group pack, currency policy that holds, and the clear line between management consolidation the system produces and statutory consolidation your auditor signs.
Every regional group eventually hits the same wall. Each country closes its own books, in its own currency, on its own calendar — and then someone spends the last week of every quarter pulling four exports into a master spreadsheet, converting currencies by hand, and producing a group number that the owner half-trusts and no one else can reproduce. The consolidation works right up until the person who built it leaves. This guide is about replacing that ritual with a consolidated view that is a filter over one dataset — and being honest about where that view stops and your auditor begins.
Two different things people call "consolidation"
Most confusion in this area comes from one word doing two jobs. Separating them is the whole game:
- Management consolidation — the group view leadership runs to make decisions: combined revenue, margin, cash and burn across entities, refreshed continuously, in a chosen reporting currency. This is what a good operations system produces from one dataset.
- Statutory consolidation — the audited group accounts your jurisdiction requires: intercompany revenue and balances eliminated, minority interests handled, the applicable accounting standard applied. This is prepared with your auditor.
The relationship between them is the point: clean management consolidation, built on records that already agree from both sides — the intercompany discipline — turns statutory consolidation from a three-week reconstruction into a reviewed afternoon. The system does the first and makes the second fast; it does not sign the second.
The currency policy that makes a group number trustworthy
A consolidated figure is only as trustworthy as the exchange policy behind it, and the failure mode is never the method — it is three offices using three methods nobody wrote down. A defensible policy states, in writing: which reporting currency the group consolidates into, which rate applies to activity (commonly transaction-date rates), and which method applies to consolidation (average or closing, stated and consistent). Applied the same way every period, the group number stops depending on who ran the report — the multi-currency discipline at the reporting layer.
The consolidation test
Ask one question of any regional structure: can you produce the group report and each country's statutory report from the same dataset, without a manual bridge? If the honest answer involves a quarter-end spreadsheet and one person who "knows how the consolidation works," the structure is one resignation away from failing — regardless of how good the software underneath looks.
The monthly group pack: what leadership should actually read
A consolidated report that is a wall of numbers gets skimmed. The group pack that gets used is a short, consistent set per entity, comparable because every entity shares one chart-of-accounts structure.
| What leadership reads | Per entity | At group level |
|---|---|---|
| Revenue & margin | In home currency, this month vs plan | Consolidated in reporting currency, by policy |
| Cash position | Bank and mobile-money by account | Group cash, converted consistently |
| Inter-entity balances | Current, reconciled, settling on schedule | Net to zero on consolidation — the health check |
| Shared-cost allocations | Posted per policy, the month they belong to | Fully allocated, nothing sitting in a holding pot |
| FX differences | By source: purchases, sales, balances | Group exposure, explicit not buried |
The single most revealing line is inter-entity balances: if they are reconciled and net to zero on consolidation, the group's books are healthy; if they do not, the group total is fiction until they do. That is why the reporting discipline and the transaction discipline are the same discipline seen from two ends.
The honest boundary, stated plainly
AWRA produces management consolidation across your EAC entities from one dataset — combined and per-entity, in a policy currency, refreshed continuously — and it keeps the underlying records (intercompany postings, allocations, inter-office balances) clean and two-sided so they reconcile. It does not produce your audited statutory group accounts on its own: the eliminations, minority-interest treatment and standards compliance are your auditor's work, done from the clean records the system hands them. And it is not tax advice — how group results are treated for tax in each country is confirmed with your accountant. Buy it to end the spreadsheet ritual and to give your auditor a trustworthy starting point, not to replace them.
See the whole group on one screen
Management consolidation across every EAC entity from one dataset, a currency policy applied consistently, and inter-office balances that reconcile — so the audited accounts start from clean numbers, not a scramble.
Talk to us about group reportingFrequently asked questions
Does the system produce our audited consolidated financial statements?
No — it produces management consolidation from one dataset, which is most of the work, and keeps the underlying records clean and two-sided. The audited statutory group accounts, with intercompany eliminations and the standard your jurisdiction requires, are prepared and signed by your auditor using those records as the source. The value is turning consolidation from a reconstruction into a review.
What reporting currency does the group consolidate into?
Whichever you choose — commonly the home-market currency or a hard currency your investors expect — applied through a declared conversion policy. Each entity keeps its own home-currency books; the group view converts them consistently every period. You set the currency and method once, in writing, and the system applies it the same way each time so the figure is reproducible.
How do we know the consolidated number is trustworthy?
The health check is inter-entity balances: reconciled and netting to zero on consolidation means the entities agree with each other and the group total is real. If those balances are one-sided or stale, the consolidation is fiction until they are fixed — which is why reconciling them monthly, in their original currency, is non-negotiable for a trustworthy group report.
Can we still see each country on its own?
Yes — the same dataset produces each entity's standalone view for local management and statutory reporting, and the group view for leadership, without re-keying. Country is a dimension, so a report is just a filter: one country, a region, or the whole group, all from the records the offices are already keeping day to day.
How often is the consolidated view available?
Continuously — because it is a filter over live records rather than a period-end assembly, leadership can look at the group position whenever they need it, not only after a quarter-end close. Formal reporting still follows your close calendar, but the ability to see where the group stands does not have to wait for a spreadsheet to be built.
