Value Proposition: A workpaper for consolidating financial statements at the group level: Entity TBs + Mapping + FX Rates → Eliminations + NCI + Consolidation JEs → Consolidated TB → Consolidation Pack with clear tie-outs and a JE Log for adjustments and eliminations.

In 20 Seconds: What Will You Get?

• Import template to import TB for each entity and establish a reference version for the period.
• Mapping from company COA to Group COA (even if the chart of accounts differs).
• FX Translation schedule: Specify the type of exchange rate (Closing/Average/Historical) and link the output to TB.
• Eliminations templates for intercompany transactions (IC AR/AP + IC Sales/COGS + Loans/Interest + Dividends… based on your scope).
• NCI schedule (Non-controlling Interest): Ownership + Period result allocation + NCI balance in Equity.
• Consolidation JE Log for each elimination/modification entry: Reason + Support + Approval + Impact on Consolidated TB.
• Consolidation Pack Index for indexing deliverables: TBs + Schedules + JE Log + Tie-outs within a single file.

CTA related to outputs: Receive Consolidated TB + Eliminations/FX/NCI Schedules + JE Log as a reviewable delivery package (Consolidation Pack).

Suitable For

• Group Financial Controller needs a Consolidated TB and a unified delivery for auditors with Schedules and Tie-outs.
• Reporting / Consolidation Accountant executes Eliminations and FX and NCI and needs a JE Log and indexing of documentation.
• Group of Companies (HoldCo + Subs) with more than one entity needing routine Month-End or Year-End consolidation.

Not Suitable For

• Those looking for Consolidation Software that automatically operates on ERP databases and executes eliminations automatically without workpapers.
• Groups with very high complexity (frequent M&A, complex PPA/Goodwill, or thousands of IC transactions) without organized IC data availability.

Without the Program / With the Program (Quick Comparison)

Before Use: 5 Symptoms in Financial Statement Consolidation

• Every period starts with manually merging TBs, and the result varies by person/file version.
• Intercompany balances (AR/AP/Loans) are not fully closed due to lack of a unified listing or matching templates.
• Currencies are translated at different rates among entities or without specifying (Closing/Average/Historical) for each item.
• NCI is treated as a fixed number without movement (Opening/Profit share/Other movements/Closing).
• When requested by auditors: there is no JE Log for eliminations and no index linking each entry/number to its source within the Pack.

Consolidation Program: Implementation Method (3 Steps Without Gaps)

Step 1: Preparation and Report Collection

• Gather Trial Balance for each entity for the period + determine the functional currency/group presentation currency.
• Prepare Group COA Mapping (or update it) and link each company’s accounts to group items.
• Prepare mandatory inputs: Ownership % (and effective dates) + FX Rates + Intercompany Listing (AR/AP, Sales/COGS, Loans… based on your scope).

Step 2: FX + Eliminations + NCI + Consolidation JE Log

• Execute FX Translation according to rate settings and link the output to Entity TBs (before any Eliminations).
• Run Eliminations using IC templates: match balances between two parties + record variances as Variance/Notes + prepare elimination entries.
• Calculate NCI: determine minority percentage + allocate period result + movement of non-controlling interests within Equity.
• Record all consolidation entries in the Consolidation JE Log (Reason + Support + Approval + Impact).

Step 3: Consolidated TB + Financial Statements + Consolidation Pack

• Output Consolidated TB after FX/Eliminations/NCI (reference version for the period).
• Prepare consolidated financial statements (P&L/BS/CF/Equity as per your requirements) based on Consolidated TB and Mapping.
• Compile Consolidation Pack: TBs + Mapping + FX + Eliminations + NCI + JE Log + Tie-outs + Sign-off with a single index.

Program Components (Clear Inventory)

1. Entity TB Import Sheets
   • Practical Purpose: Establish TB for each company as an official input for the period (with extraction date and reference version).
   • When Used: Every Month-End/Year-End when starting the consolidation cycle.
   • Resulting Documentation: Archived TBs for each entity + Version control log.
2. Group COA Mapping
   • Practical Purpose: Standardize different chart of accounts under one Group COA to enable Consolidated TB and financial statements.
   • When Used: During initial setup + update when adding new accounts/entities.
   • Resulting Documentation: Mapping Sheet showing the linkage of each account from each company to group items.
3. FX Rates & Translation Schedule
   • Practical Purpose: Apply exchange rates based on item type (Closing/Average/Historical) and output clearly translated TB.
   • When Used: Every period when there are entities with different currencies or when presenting statements in group currency.
   • Resulting Documentation: FX table + Translation schedule + Tie-out between TB before/after translation.
4. Intercompany Matching & Eliminations Templates
   • Practical Purpose: Match IC AR/AP and IC Revenue/COGS and IC Loans/Interest and Dividends (based on your scope) and generate elimination entries.
   • When Used: Month-End to adjust IC balances + Year-End to compile a unified audit file.
   • Resulting Documentation: Matching reports + Eliminations entries + Variance notes for unmatched items.
5. NCI Schedule
   • Practical Purpose: Calculate NCI based on Ownership % and allocate period result and movement of non-controlling interests in Equity.
   • When Used: Every period when there are companies not 100% owned.
   • Resulting Documentation: NCI rollforward: Opening + Share of profit + Other movements = Closing.
6. Consolidation JE Log + Approval
   • Practical Purpose: Document all FX/Eliminations/NCI entries in one log (Reason + Support + Approval + Impact).
   • When Used: Throughout the consolidation cycle before finalizing the Consolidated TB.
   • Resulting Documentation: Completed JE Log that can be presented to auditors as a reference for entries.
7. Consolidated TB Output
   • Practical Purpose: Finalize consolidated figures after translation, eliminations, and NCI as a starting point for statements.
   • When Used: End of the consolidation cycle (Month-End/Year-End).
   • Resulting Documentation: Final Consolidated TB linked to JE Log and Schedules (Traceability).
8. Consolidation Pack Index + Sign-off
   • Practical Purpose: Turn consolidation into a delivery file: indexing + reference version + internal approval.
   • When Used: At the end of the period and before sending consolidated statements to auditors/management.
   • Resulting Documentation: Index + Sign-off specifying the reference version for the period and its contents.

CTA related to outputs: Consolidated TB + Eliminations/FX/NCI Schedules + Consolidation JE Log with an index and sign-off.

What Should Be Included in the Delivery?

• 01 – Entity TBs: File/Report TB for each company (Excel/PDF export) + extraction date + entity currency.
• 02 – Mapping: Group COA Mapping file showing the linkage of each company’s accounts to group items + any exceptions.
• 03 – FX: Schedule of exchange rates used (Closing/Average/Historical) + Translation schedule + documentation of rate sources.
• 04 – Intercompany Listings: IC reports for each party (AR/AP + Sales/COGS + Loans/Interest + Dividends based on your scope) or a unified listing.
• 05 – Eliminations: Matching files + Entries + Variance notes for unmatched items + what was closed and how.
• 06 – NCI: Ownership schedule + NCI rollforward + allocation of period result + any ownership change (if any) with documentation.
• 07 – Consolidation JE Log: Log of consolidation entries (FX/Elim/NCI/Other) with reason, support, and approval for each entry.
• 08 – Outputs: Final Consolidated TB + Draft FS (if included in the delivery) + any key Tie-outs.
• 09 – Pack Index & Sign-off: Index of files + reference version for the period + who reviewed/approved + date of approval.

After Implementation (Two Points Only)

• Operational Outcome for the Team: The consolidation cycle becomes repeatable: defined inputs (TB/FX/IC/Ownership) then Schedules then Consolidated TB, instead of an aggregation file that changes format each period.
• Control/Audit Outcome (Evidence & Traceability): Every number in the Consolidated TB can be traced back to (Entity TB + Mapping) then to (FX/Eliminations/NCI schedule) then to Consolidation JE Log within an indexed Pack.

FAQ — Questions Before Purchase

Is the program actual “Software” or an Excel Workpaper?

It is a Workpaper/Workbook for consolidation (Templates + Schedules + JE Log). It does not automatically connect to ERP or pull data from databases—TBs are imported and FX/IC/Ownership are entered based on available reports.

Does it work with any accounting system?

Yes, provided it can extract Trial Balance for each entity and basic IC reports (or a manual listing from the system).

Does it support multiple currencies?

Yes. There is an FX schedule that specifies the type of exchange rate used (Closing/Average/Historical) and outputs a clearly translated TB with a clear Tie-out.

Does it support Non-controlling Interest (NCI)?

Yes. There is an NCI schedule that outlines group ownership, period result allocation, and movement of non-controlling interests within Equity (Opening/Movement/Closing).

What is the minimum data required to get started?

TB for each company + Ownership % + FX rates + Intercompany listing (at least IC AR/AP). The more IC data (Sales/COGS/Loans/Dividends) available, the better the quality of eliminations.

Is it suitable for monthly consolidation or only annual?

For both. Monthly for groups that close Month-End at the group level, and annually for preparing the consolidated financial statements and audit (Consolidation Pack).

Does it cover Acquisition Accounting, Goodwill, and PPA?

It manages TB merging, Eliminations, FX, and NCI. However, PPA/Goodwill/Impairment and complex acquisition treatments require a custom template based on the deal (results can be included as Consolidation JEs within the JE Log).

Is there a delivery template for auditors?

Yes. The Consolidation Pack Index + Sign-off + JE Log + Schedules prepare an organized delivery file that links each number to its source.

Ready to finalize the Consolidated TB with documented Eliminations, FX, and NCI?

You will receive: Consolidation Workbook + Eliminations/FX/NCI Schedules + Consolidation JE Log + Pack Index to prepare Month-End/Year-End at the group level.