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

Set-up made simple

Instantly set up new entities with configurable rules for inter-entity transactions, bank accounts, and more. You make the rules – Sage Intacct makes it easy.

  • Easily consolidate new entities by inheriting existing lists, process definitions, and charts of accounts
  • Quickly configure unique definitions each new entity with total control
  • Centralize assets or set up multiple charts of accounts - you have total control
Entity information Inter-entity setup Entity Information EMP-0004–Jenson, Jodi Active TAMPA-EAST Tampa East * Name Manager | Status * ID Tax ID Entity Enable as the elimination entity

Unified multi-entity architecture

Simplify financial consolidation by sharing vendor, customer, and item lists across entities. Our unifying financial consolidation accounting software architecture handles:

  • Domestic and global locations
  • Single and multiple base currencies
  • Simple to complex ownership structures

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.

Frequently asked questions

Financial consolidation is the process of combining assets, liabilities, and other financial data of two or more entities into one. Without automating financial activities, consolidations can be a drain on time to manually manage complexities in a multi-location organization, such as decentralized payables, inter-entity transactions, or multiple currencies.

Tracking hundreds, perhaps thousands, of inter-company transactions using spreadsheets is error-prone and time-consuming—taking days or weeks to consolidate. Financial consolidation software like Sage Intacct helps automate multi-entity accounting and multi-currency accounting:

  • Automating inter-company eliminations
  • Automating currency conversions and revaluations
  • Complying with ASC 830/FAS-52 multi-currency consolidation, creating cumulative translation adjustments (CTAs)

After setting up your entities’ books, running the consolidations processes is easy. Simply select the books to consolidate and period range and click the consolidate button. You can even set up a recurring schedule of how often you want to consolidate so the process can run in the background.

This comprehensive automation translates to getting your consolidated financial reports in a fraction of the time it takes with manual consolidations processes, leading to reduced close time and improved accuracy. Every stakeholder gets the right view of performance with streamlined financial management and reporting.

Here are just a few examples of how organizations achieved greater efficiency and visibility.

Jumpstart, a venture development nonprofit, managed consolidations across complex multi-entity operations to more than double the speed of planning cycles and increased budget accuracy by 90%.
Tandem HR, a custom HR solution provider, cut 500 hours annually and increased EBITDA 195% through data-driven decision making made possible with faster, accurate financial information.
Rivr Media, a television producer, streamlined inter-company financial processes to shorten the monthly close by 3 to 5 days and save over 125 hours per month.

Sage Intacct financial consolidation software is ideal for setting up and consolidating up new entities. Existing practices, perhaps with similar business models, can be used to quickly configure the accounts of new entities. In-system report writers can adjust to the reporting needs and meet different GAAP and industry requirements. You can adapt the chart of accounts to meet the needs of the new business unit. Configurable rules for inter-entity transactions, bank accounts, and more—keeping new entity setup easy and consistent.

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.

""

Give Feedback