No. Every calculation is a formula you can trace. There is no VBA in the file.

Which Excel versions does it work in?

It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.

At the proportionate share of identifiable net assets. Version 1.0 does not offer the fair value option.

Can it handle a subsidiary acquired during the year?

Yes. Paste the subsidiary's trial balance for the period since acquisition and enter its net assets at the acquisition date. Pre-acquisition profit stays out of group profit, and check C11 confirms the inputs are complete.

Is my data uploaded anywhere?

No. The workbook runs on your computer. We never see your ledgers.

Why not ask an AI assistant to build the consolidation?

You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.

What does the licence allow?

Pro: one named user, up to 10 entities, for their own group. Team: up to 10 named users in one organisation, up to 25 entities, for its own group. Practice: up to 5 named users in one accounting or audit firm, up to 25 entities per file, for any number of client groups. You may give completed files to your auditors and reviewers.

When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.

What if it does not work for me?

Ask within 14 days of purchase for a full refund, for any reason.

Multi-Entity Consolidation and FX Translation Workbook

Consolidate up to 25 entities, with a CTA backed by a separate rollforward for every subsidiary.

Translate each subsidiary under IAS 21, eliminate intercompany balances, trading, dividends and unrealised profit, and carry NCI and goodwill through. Every check shows PASS or FAIL.

Translation at closing, average and historical rates, with the CTA backed by a separate rollforward for every subsidiary.
An eliminations journal that balances, an intercompany matrix by pair, and NCI rolled forward from acquisition.
Consolidated SoFP, P&L and OCI, statement of changes in equity, and an entity-column view. No macros.

See pricing Sample output (PDF)

Who it is for

Group accountants consolidating 3 to 25 entities in Excel.
GCC groups with subsidiaries in SAR, AED, EUR or other currencies.
Family groups and portfolio companies that need a consolidation file a reviewer can follow.

Who it is not for

Groups with sub-groups (subsidiaries held through another subsidiary): version 1.0 consolidates direct subsidiaries.
Disposals, step acquisitions and subsidiaries in hyperinflationary economies (IAS 29).
NCI at fair value, and put options over NCI.
Equity-accounted associates and joint ventures.
Anyone looking for judgements on control or fair values: those stay yours.

Tab by tab

Group Structure: Entities, functional currencies, ownership, acquisition dates, consideration and net assets at acquisition.
Rates: Opening, closing, average and dividend rates per currency.
Entity TBs: Paste every entity's trial balance in its own currency, with a counterparty column for intercompany lines.
Mapping: Map each account once to a group line.
Translation: IAS 21 translation per subsidiary, the CTA as the balancing figure, and the rollforward that backs it.
Intercompany Matrix: Receivables against payables, sales against purchases, and dividends, by pair, with differences flagged.
Unrealised Profit: Unsold intra-group inventory and the seller's margin; upstream profit shared with NCI.
Eliminations Journal: Investment against equity with goodwill, goodwill retranslation, intercompany balances, trading, dividends, unrealised profit and NCI.
NCI: Non-controlling interest from acquisition through the year's profit, OCI and dividends, tied to the closing net assets.
Consolidated FS: SoFP, P&L and OCI with attribution, statement of changes in equity, and the entity-column view.
Checks: Every check visible, PASS or FAIL, with one cell that tells you whether everything passes.

The checks

Every check is visible on the Checks tab and shows PASS or FAIL.

C01Every entity trial balance balances in its own currency.
C02Opening translated equity for each subsidiary agrees with last year's closing figure.
C03The Adjustments journal balances, in total and per entry.
C04For each subsidiary, the CTA rollforward ties to the translation balancing figure.
C05For each subsidiary with NCI, the NCI rollforward ties.
C06The consolidated balance sheet balances and every line agrees with the entity-column view.
C07Intercompany differences are within tolerance.
C08Every ownership percentage is valid.
C09Every account with a balance is mapped.
C10The group structure is valid: one parent, in the presentation currency, with direct subsidiaries.
C11Acquisition inputs are complete and the acquisition date is on or before the reporting date.
C12The parent's investment is fully eliminated.
C13Goodwill is zero or more for every subsidiary.
C14Goodwill impairment never exceeds gross goodwill.
C15Tolerance, unrealised profit margins and counterparties are valid.

How we test each release

How it compares

Typical setups, not a review of any one product.

	Free template	Consolidation software	This workbook
CTA backed by a separate rollforward	Varies by template	Varies, often inside the system	Yes, per subsidiary
Unrealised profit with NCI share	Varies by template	Usually	Yes
Checks you can show a reviewer	Varies by template	Varies, often inside the system	Every check visible, PASS or FAIL
Where your data lives	Your machine	Usually cloud hosted	Your machine
Price	Free	Usually a subscription	From USD 149, once

Sample output

Download the sample output (PDF): the Checks summary and headline consolidated figures from the sample group.

Pricing

Pro

USD 149

USD 111.75 with code FOUNDING25 until 1 December 2026.

Up to 10 entities, one named user

Choose this if your group has up to 10 entities and one person runs the consolidation.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Team

USD 299

USD 224.25 with code FOUNDING25 until 1 December 2026.

Up to 25 entities, up to 10 named users in one organisation

Choose this if your group has more than 10 entities, or several colleagues need the file.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Practice

USD 449

USD 336.75 with code FOUNDING25 until 1 December 2026.

Up to 25 entities per file, up to 5 named users in one accounting or audit firm, any number of clients

Choose this if your firm prepares or reviews consolidations for client groups.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

One-time price. Updates within the same major version are free for as long as we sell it.

You can ask for a full refund for any reason within 14 days of purchase. This is our own promise. The statutory withdrawal right you give up at checkout is a separate legal right.

Prices are in USD. Depending on your country, sales tax is either included in the price or added at checkout, and Paddle shows the total before you pay. Your checkout may show a local price.

After a purchase we may email you tips for your tool and about similar Hayatiq tools; every email has an unsubscribe link.

This is a tool, not tax, accounting or financial advice.

Questions

Does it need macros?: No. Every calculation is a formula you can trace. There is no VBA in the file.
Which Excel versions does it work in?: It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.
How is NCI measured?: At the proportionate share of identifiable net assets. Version 1.0 does not offer the fair value option.
Can it handle a subsidiary acquired during the year?: Yes. Paste the subsidiary's trial balance for the period since acquisition and enter its net assets at the acquisition date. Pre-acquisition profit stays out of group profit, and check C11 confirms the inputs are complete.
Is my data uploaded anywhere?: No. The workbook runs on your computer. We never see your ledgers.
Why not ask an AI assistant to build the consolidation?: You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.
What does the licence allow?: Pro: one named user, up to 10 entities, for their own group. Team: up to 10 named users in one organisation, up to 25 entities, for its own group. Practice: up to 5 named users in one accounting or audit firm, up to 25 entities per file, for any number of client groups. You may give completed files to your auditors and reviewers.
How do updates work?: When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.
What if it does not work for me?: Ask within 14 days of purchase for a full refund, for any reason.

Who built it

Omer Hayat Khan, FCCA. 8 years in Big Four audit. Every workbook is generated from source code written for Hayatiq and checked by an independent test suite before release.

How we test | About

Changelog

v1.0.0 (2026-10): First release.

Full changelog