search icon

Sage Intacct Consolidations Reporting

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

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 (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 AUD AUD AUD AUD AUD AUD AUD AUD AUD 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 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

Learn more with resources

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

Room to Read—case study

Learn how Room to Read is building a financial infrastructure to support rapid expansion with multi-entity consolidations across 25 entities and 19 currencies. 

Multi-entity financial management data sheet

Whether your business is global or domestic, simple or complex, now you can close the books faster and gain the visibility you need even as your operations grow and evolve.

Next generation financial consolidations white paper

Learn a better way of tackling the increasing complexity and compressed timelines of consolidations and ensuring your consolidation process is a source of value creation.

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.

Inventory management

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

Project accounting

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

Revenue recognition

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

Spend management

Govern company purchasing vs. budgets and never exceed spending caps.

Time and expense management

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

Interested in learning more?

Give Feedback