search icon

Sage Intacct Consolidations Reporting

Consolidate hundreds of entities in minutes, not days—and boost productivity by more than 50%.

Trusted by

White Ribbon Alliance

Automation and productivity highlights

Go global with robust, accurate, and easy multi-currency consolidations.
Simplify complex multi-entity, multi-currency, and multi-level consolidations to expedite month-end close.
Increase visibility with flexible, easy-to-build domestic and global reports.
Save days of time from managing inter-entity transactions and eliminations.
More actions Done Duplicate Edit Book Setup Book information Entities to consolidate Journals Accounts to override Elimination accounts Multi-currency Currency GBP Currency exchange gain/loss 
account on Net income 3600 Ending spot rate Translation method for 
Balance sheet accounts Exchange rate table lntacct Daily Rate Net assets 3600 Weighted average rate Income statement accounts General information Book name CUUK Accounting method Accrual CUUK__SJ Statistical journal symbol Description UK Consolidation Default department CUUK statistical journal Statistical journal name Book status Active Budget

Easily configurable for consolidation

Discover the power of customization with an intuitive consolidation setup from Sage Intacct.

  • Quickly add new or existing entities to model organizational structure based on how you report results.
  • Define multi-leveled ownership structures by period with reporting books generated for each reporting level and parent entity.
  • Set up eliminations, currency translation rules, and dimensions to consolidate and create detailed reports.

Auto-Eliminations based on reporting requirements

Minimize complexity and avoid time-wasting corrections with automated entries.

  • Enhance reporting periods with formalized, audit-ready elimination entries for local compliance with traceability.
  • Reduce time-wasting manual checks and corrections with a consolidation process that prioritizes accuracy.
  • Auto-generate non-controlling interest based on varying ownership percentages for simplified compliance.
Account Posted date Description Entity Currency Txn amt Debit (USD) Credit (USD) 1312 - Inter-entity Receivable 1801 - Investment in Subsidiary 2105 - Inter-entity Payable 3301 - Contributed Capital 3601 - Elim Variance 3601 - Elim Variance 3601 - Elim Variance 3700 - Non-controlling Interest Equity 8900 - Net Income Attributable to NCI 1/31/24 1/31/24 1/31/24 1/31/24 1/31/24 1/31/24 1/31/24 1/31/24 1/31/24 Auto-elimination Auto-elimination Auto-elimination Auto-elimination Auto-elim: Adjustment for entity E_200 Auto-elim: Adjustment for entity E_201 Auto-elim: Adjustment for entity E_202 Income attributed to NCI for entity E_201 Income attributed to NCI for entity E_201 Elimination Elimination Elimination Elimination Elimination Elimination Elimination Elimination Elimination USD USD USD USD USD USD USD USD USD 5,000.00 150,000.00 5,000.00 150,000.00 150,000.00 155,000.00 155,000.00 55,000.00 100,000.00 20,000.00 20,000.00 20,000.00 330,000.00 5,000.00 150,000.00 5,000.00 55,000.00 100,000.00 20,000.00 330,000.00 Journal Entry
Consolidate Global Apr 2024 Ownership percent 100 100 80 100 100 75 40 100 100 100 90 60 100 100 100 100 Ending spot rate 1.0000 0.7972 1.0000 1.0000 1.0000 1.0000 0.8406 0.8406 1.0000 1.0000 0.7822 1.0000 1.0000 1.0000 1.0000 1.0000 Ending spot rate 1.0000 0.7914 1.0000 1.0000 1.0000 1.0000 0.8364 0.8364 1.0000 1.0000 0.7930 1.0000 1.0000 1.0000 1.0000 1.0000 Entity Cubit Group [Parent] (GBP) Cubit UK Holding (GBP) Cubit NA Holding (USD) Elimination Entity GBP [Elimination] (GBP) Cubit UK Holding [Parent] (GBP) Cubit UK (GBP) Cubit IRE (EUR) E106 EUR (EUR/ Elimination Entity GBP [Elimination] (GBP) Cubit NA Holding [Parent] (USD) CUBIT Canada (CAD) CUBIT USA (USD) Elimination Entity [Elimination] (USD) CUBIT Canada [Parent] (CAD) CA1 (CAD) Elimination Entity CAD [Elimination] (CAD) Level 1 2 2 3 Book CUGroup (GBP) CUGroup (GBP) CUGroup (GBP) CUGroup (GBP) CUUK (GBP) CUUK (GBP) CUUK (GBP) CUUK (GBP) CUUK (GBP) CUNA (USD) CUNA (USD) CUNA (USD) CUNA (USD) CUCA (CAD) CUCA (CAD) CUCA (CAD)

Simplified multi-currency for consolidations

Tackle global consolidation with confidence. Sage Intacct translates and consolidates financial data across currencies with precision.

  • Automate cumulative translation adjustments (CTAs) for ASC 830/FAS- 52-compliant multi-currency consolidation accounting.
  • Generate reports in the currency that best suits your needs, whether it's for headquarters, subsidiaries, or parent company local currencies.
  • Automatically-computed OANDA live exchange rates eliminate the need for manual exchange rate management, saving time and reducing manual error.

Robust consolidation reporting

Dive deep into your consolidated data with Sage Intacct's powerful reporting tools.

  • Utilize the financial report writer to easily generate flexible management and compliance reports based on consolidated data.
  • Ensure accurate and transparent financial reporting, giving stakeholders a big-picture view of your organization's consolidated financial health.
  • Drill down into consolidation journals for easy audit traceability and reporting transparency to understand your consolidated numbers at-a-glance.
Consolidated Balance Sheet Entity 200
Month Ending 01/31/2024 Entity 201
Month Ending 01/31/2024 Elimination
Month Ending 01/31/2024 All Locations
Month Ending 01/31/2024 152,000.00 167,500.00 0.00 319,500.00 5,000.00 0.00 (5,000.00) 0.00 157,000.00 167,500.00 (5,000.00) 319,500.00 50,000.00 0.00 (50,000.00) 0.00 207,000.00 167,500.00 (55,000.00) 319,500.00 7,000.00 5,000.00 (5,000.00) 7,000.00 0.00 0.00 20,000.00 20,000.00 5,000.00 12,500.00 0.00 17,500.00 95,000.00 50,000.00 (50,000.00) 95,000.00 200,000.00 100,000.00 (20,000.00) 280,000.00 300,000.00 162,500.00 (150,000.00) 312,000.00 307,000.00 167,500.00 (155,000.00) 319,500.00 Total Assets Total Liabilities and Equity Assets Current Assets Liabilities Stockholders Equity Capital Stock Common Stock Net Income (Loss) Total Stockholders Equity Cash and Cash Equivalents Intercompany Receivable Total Current Assets Investments Liabilities and Equity

All resources

Explore the latest research, guides, and webinars on accounting and finance.
Product demo

Sage Intacct for growing businesses

Data sheet
""

Multi entity financial management

Sage Membership. Get more than software and solutions.

Member Masterclass

Explore articles and tap into weekly videos on the topics that matter to you.

Learning and certifications

Grow your knowledge and boost skills across your team.

Community

Network, share knowledge, and get the most out of Sage software.

Doug Johnson

Executive VP and COO, Pentaho

When we evaluated competing financial management solutions, Sage Intacct was best suited to meet our needs in several key areas, including multi-entity and multi-currency management and advanced revenue management.

Talk to our experts

Expert advice

Ready to learn more about what Sage Intacct can do for your business? We are, too. Our product experts are here to guide you every step of the way.

""