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

  • Quickly add new or existing entities to model an 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 GBP GBP GBP GBP GBP GBP GBP GBP GBP 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.

  • 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.

All resources

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

Sage Intacct Product Brochure

Webinar

Lunch and Learn: Sage Intacct Product Showcase

Webinar

Take a coffee break with Sage Intacct for Financial Services

Webinar

Future of Planning, Budgeting, Forecasting, and Reporting

Whitepaper

7 Key Trends That Will Reshape Accounting and Finance in 2023

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

Celine Okoh, CFO

White Ribbon Alliance

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.

Interested in learning how Sage Intacct can help your business?

Start Chat
Sage Live Chat

Welcome to Sage Live Chat!

Payroll Advice

Choose an option to get started.

I need help with my existing product
Sage Live Chat
Please choose your support option.
Speak to a live agent

Open weekdays 9am to 5pm

Call our sales team

0191 4795988

Open weekdays 9am to 5pm

Give Feedback