search icon

Sage Intacct Consolidations Reporting

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

Request a demoView product tour

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 customisation with an intuitive consolidation setup from Sage Intacct.

  • Quickly add new or existing entities to model organisational structure based on how you report results.
  • Define multi-levelled 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

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

  • Enhance reporting periods with formalised, audit-ready elimination entries for local compliance with traceability.
  • Reduce time-wasting manual checks and corrections with a consolidation process that prioritises accuracy.
  • Auto-generate non-controlling interest based on varying ownership percentages for simplified compliance.
Account Posted date Description Entity Currency Txn amt Debit (CAD) Credit (CAD) 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 31/1/24 31/1/24 31/1/24 31/1/24 31/1/24 31/1/24 31/1/24 31/1/24 31/1/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 EUR EUR EUR EUR EUR EUR EUR EUR EUR 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.

  • Utilise 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 organisation'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 31/01/2024 Entity 201
Month Ending 31/01/2024 Elimination
Month Ending 31/01/2024 All Locations
Month Ending 31/01/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

Resources to help your business perform at its best

Gain valuable insights, reduce costs and grow your business faster with our guides.

Room to Read case study

Room to Read dramatically streamlined its chart of accounts from 56,000 to just 100 accounts and can now tag transactions with details such as specific programs and locations.

Read case study

Next Generation Financial Consolidations

Learn why the traditional approach to consolidations doesn't work, and how automation improves business insights and supports faster growth for financial service organisations.

Download now

2021 Buyers Guide to Accounting and Financial Software

Finance leaders balance increasing levels of business complexity with the need for speed. Is your accounting software helping your company grow or is it holding it back?
Download now

After a wide-ranging evaluation process, we narrowed our options down to Sage Intacct or Oracle NetSuite. Sage Intacct’s cloud-based system ended up as a clear choice over Oracle NetSuite because of its impressive multi-entity and multi-currency capabilities, as well as the great experience we had with the Sage Intacct team.

Celine Okoh, CFO

White Ribbon Alliance

Explore advanced functionality

Fixed assets

Fixed assets and core accounting create an automated asset management system.

Find out more

Inventory management

Track, value, and manage stock while maintaining accuracy at every step.

Find out more

Project accounting

Manage costs and revenue, keep projects on time, and maintain profitability.

Find out more

Revenue recognition

Account for multiple revenue types - subscriptions, licenses, and services.

Find out more

Spend management

Govern company purchasing versus budgets and never exceed spending caps.

Find out more

Time and expense management

Keep your team focused on client goals, not administrative tasks.

Find out more

Interested in learning how Sage Intacct can help your business?

Request a demoGet a product tour

Give Feedback