- Home
- Apps
- SaaS Tools
- Group Consolidation & Financial Reports
Illustrative previewA build-to-order ERPNext app that produces consolidated financial statements across your subsidiaries
— trial balance, GL, P&L and balance sheet — with intercompany elimination and multi-currency translation to a single group currency.
ECOSIRE scopes, builds, installs and supports it for your specific company tree.
What is Group Consolidation & Financial Reports?
A build-to-order ERPNext app that produces consolidated financial statements across your subsidiaries — trial balance, GL, P&L and balance sheet — with intercompany elimination and multi-currency translation to a single group currency. ECOSIRE scopes, builds, installs and supports it for your specific company tree. Built to order by ECOSIRE for ERPNext v15, v16 — indicative price from $999.00 USD; request a quote for a scoped proposal.
Key Features
Built to order, done for you
No DIY setup — a working app, built, installed and supported by ECOSIRE.
- 1
You order
Start with a one-time build price. We scope it with you at kickoff.
- 2
We build & install
ECOSIRE builds, configures and installs it on your ERPNext.
- 3
Go live + support
You go live in about one working week, with two weeks of go-live support. Defects in the code we deliver are fixed free of charge.
Technical Specifications
- ERPNext Compatibility
- —
- License
- Licence confirmation required
- Python Requirement
- Python 3.10+
- Database
- MariaDB 10.6+
About this Product
Group CFOs running multiple legal entities in ERPNext hit a wall at consolidation. ERPNext supports a company tree and Multi-Company setups, and its Consolidated Financial Statement report can roll up a parent and its children, but it stops short of what a real group close needs: it does not post or track intercompany elimination entries, it applies limited translation logic when subsidiaries keep different functional currencies, and it gives you little audit trail for the adjustments that turn a stack of standalone ledgers into a defensible group P&L and balance sheet. Finance teams end up exporting each entity to spreadsheets, hand-keying eliminations, and rebuilding the same reconciliation every period — slow, error-prone, and impossible to drill back into ERPNext.
We build a dedicated Frappe app (its own module, installed via bench get-app and bench install-app) that adds a proper consolidation layer on top of your existing ERPNext GL. New DocTypes model the pieces the core is missing: a Consolidation Group (the set of companies and ownership relationships you consolidate), a Consolidation Run (a period-scoped snapshot with status workflow — Draft, Translated, Eliminated, Finalized), an Elimination Rule catalog, and Intercompany Elimination Entry records that store both sides of every knock-out with a full audit trail. The engine reads GL Entries per company for the selected period, translates each subsidiary's balances into the group currency using period-appropriate rates (closing rate for balance-sheet accounts, average rate for P&L, with the residual booked to a currency-translation-adjustment account), applies your elimination rules against tagged intercompany parties, and produces consolidated trial balance, GL, P&L and balance sheet — each with drill-down from the rolled-up group figure to per-entity contribution down to the originating voucher.
Technically, the app is wired the ERPNext-native way. hooks.py doc events keep intercompany transactions tagged as they post; scheduler events can pre-stage nightly rate pulls and balance snapshots so month-end runs are fast; whitelisted server methods expose the consolidation engine over the Frappe REST API so your BI tools or a group reporting portal can pull finalized figures. Consolidated reports are delivered as Query/Script Reports and a workspace, permissions are enforced through role profiles (a Group Finance role sees consolidated output; entity accountants stay scoped to their own company), and client scripts add the run controls and drill-through links in the UI. Everything is compatible with Frappe/ERPNext v15 and v16 and is built to survive upgrades because it extends core through documented hooks rather than patching it.
Because this is build-to-order, we start from your actual company tree, chart-of-accounts mapping, ownership percentages and elimination policies rather than a generic template. After a scoping call we confirm the exact entities, currencies, elimination rules and report layouts in writing, build against that spec, and validate on a staging copy of your data. Typical delivery is one working week from confirmed scope. You receive the installable source, install it (or we install it) on your bench, run UAT on staging with a rollback plan, and go live with a support window and the git repository handed over to you.
What you get
- Installable Frappe app source code for your commissioned version, ready for `bench get-app` / `bench install-app`
- Installation and configuration on your bench (or guided install), including consolidation group, CoA mapping and rate sources
- Technical documentation: DocType reference, hooks and scheduler map, REST endpoints, and elimination-rule configuration
- End-user guide plus a live training session for your group finance team on running and finalizing a consolidation
- UAT on a staging copy of your data with a documented rollback plan before any production change
- Post-go-live support window for defect fixes and configuration adjustments (scope and duration set in the SoW)
- Git repository handover with full commit history and README so your team can maintain or extend it
- Compatibility validation against your target Frappe/ERPNext version (v15 or v16)
Who this is for
Group CFO / Head of Finance
Owns the consolidated numbers for a multi-entity group and needs a defensible, repeatable group close inside ERPNext — with eliminations and currency translation handled correctly — instead of a fragile spreadsheet rebuilt every period.
Group Financial Controller
Runs the actual month-end and year-end consolidation. Needs a status-driven run workflow, an audit trail on every elimination entry, and drill-down from group figures back to source vouchers to answer auditor questions.
ERPNext Systems / Finance Ops Manager
Responsible for the ERPNext instance across subsidiaries. Wants a clean Frappe app that extends core through documented hooks, respects role-based permissions, and survives v15/v16 upgrades rather than an unmaintainable patch.
External Auditor / Group Reporting Analyst
Needs transparent, traceable consolidated statements — every elimination and translation adjustment identifiable and drillable down to the originating entity and voucher for review and sign-off.
How Group Consolidation & Financial Reports Compares
| Criterion | ECOSIRE | Custom Build | Competitor | ERPNext Native |
|---|---|---|---|---|
| Intercompany elimination | Rule-driven elimination engine with audited both-sided entries | Possible but you design and maintain the whole engine | Often manual or limited to simple AR/AP knock-outs | Not posted or tracked by the core report |
| Multi-currency translation | Closing/average rates with CTA residual account | Depends entirely on your build effort | Varies; often single-rate or partial | Limited translation logic for group currency |
| Audit trail & drill-down | Group figure to entity to originating voucher | Only if you build it in | Usually summary-level, shallow traceability | Roll-up totals with minimal adjustment trail |
| Fit to your company tree | Built to your entities, CoA mapping and policies | Fully bespoke but from a blank sheet | Generic template you bend to fit | Assumes standard parent/child structure |
| Version upgrade safety | Extends core via hooks; validated on v15/v16 | Risk depends on developer discipline | Depends on vendor maintenance cadence | Maintained by Frappe as part of core |
| Delivery model | one working week build-to-order, UAT + rollback | Weeks to months; you manage the project | Instant install but no scoping to your data | Already present, configure yourself |
| Ongoing support | Support window + git repo handover | Your team or contractor owns it | Marketplace-level, variable SLAs | Community/self-support |
| REST/BI integration | Whitelisted methods for finalized figures | Build your own endpoints | Rarely exposed cleanly | Generic report export only |
Frequently Asked Questions about Group Consolidation & Financial Reports
How is this different from ERPNext's built-in Consolidated Financial Statement report?
The core report can roll up a parent and its child companies, but it does not post or track intercompany elimination entries, applies limited currency-translation logic, and gives you little audit trail. Our app adds dedicated elimination DocTypes, closing/average-rate translation with a CTA account, a status-driven consolidation run, and full drill-down from group figures to source vouchers — all inside ERPNext.
How long does delivery take?
This is build-to-order. After a scoping call we confirm your entities, currencies, elimination rules and report layouts in writing, then build against that spec. Typical delivery is one working week from confirmed scope, depending on the number of entities, chart-of-accounts complexity and how many elimination rules you need.
Which ERPNext versions do you support?
We build and validate against Frappe/ERPNext v15 and v16. The app extends core through documented `hooks.py` events, whitelisted methods and standard DocTypes rather than patching core, so it is designed to survive version upgrades. We confirm your exact target version during scoping.
How are updates and support handled after go-live?
Every engagement includes a post-go-live support window (duration set in the statement of work) covering defect fixes and configuration adjustments. Because you receive the full git repository, your team can maintain and extend the app independently, or you can retain us for ongoing support and version-upgrade compatibility work.
Can our subsidiaries use different charts of accounts and different currencies?
Yes. The app includes a chart-of-accounts mapping layer so entities on divergent CoAs roll up to a unified group structure, and the translation engine converts each subsidiary's functional currency to your group currency using closing rates for balance-sheet accounts and average rates for P&L, with the residual booked to a currency-translation-adjustment account.
Can we pull the consolidated figures into our BI tool?
Yes. Finalized consolidation runs are exposed through whitelisted Frappe REST API methods, so Power BI, Metabase or a custom group reporting portal can read consolidated trial balance, P&L and balance-sheet figures directly. Access is governed by role profiles so only authorized users retrieve group-level data.
Will entity accountants be able to see the whole group's numbers?
Only if you want them to. We enforce access through ERPNext role profiles and permission rules: a Group Finance role sees consolidated output, while entity accountants remain scoped to their own company. Permission design is confirmed during scoping.
Related Modules

Google Ads Lead Form & Conversion Sync
A build-to-order ERPNext app that captures Google Ads lead-form submissions straight into ERPNext Leads and pushes closed-deal offline conversions back to Google Ads, closing the loop so Smart Bidding optimizes on real revenue.

Google Sheets Two-Way Sync for ERPNext
A no-code, scheduled bridge between Google Sheets and any ERPNext DocType, with insert and upsert modes, incremental sync, and an optional two-way write-back. ECOSIRE builds, installs, and supports it for your v15/v16 site after a scoping call.

Hotel PMS (Property Management) for ERPNext
A full property-management system built as a native Frappe app on ERPNext — reservations, front desk, housekeeping, guest folios and night audit, all inside the same system that runs your accounting and inventory. ECOSIRE scopes, builds, installs and supports it after you request a quotation.

HR Analytics & Workforce Dashboard
Executive HR dashboards for ERPNext that turn Employee, Attendance, Salary Slip and Job Applicant records into headcount, attrition, payroll cost and diversity insight. Built to your definitions, installed on your instance, and supported by ECOSIRE.
Group Consolidation & Financial Reports
A build-to-order ERPNext app that produces consolidated financial statements across your subsidiaries — trial balance, GL, P&L and balance sheet — with intercompany elimination and multi-currency translation to a single group currency. ECOSIRE scopes, builds, installs and supports it for your specific company tree.
- `Consolidation Group` DocType modeling the company tree, ownership percentages and consolidation method (full / proportional) per subsidiary
- Period-scoped `Consolidation Run` DocType with a Draft → Translated → Eliminated → Finalized status workflow and immutable finalized snapshots
- Consolidated trial balance across all in-scope companies, reconciled to the sum of per-entity ledgers before adjustments
- Intercompany elimination engine driven by an `Elimination Rule` catalog (intercompany AR/AP, sales/purchases, loans, and manual eliminations)