Sage Intacct Inter-Entity Setup

Navigate to:Home:Sage Intacct Inter-Entity Setup

Sage Intacct Inter-Entity Setup

By: Dean Dorton | April 21, 2020

Accounting Software | Accounting Software | Sage Intacct

Multi-entitities and inter-entities are extremely important and useful components inside of Sage Intacct. It’s crucial to know the inter-entity setup best practices, along with the recent changes that have come with that setup. Check out our tips and tricks below for inter-entity setup.

  • Changes might be pushed down the line due to interruption in service
  • Centralized IET Setup
    • Two options (compared to just the one option now) Included in Multi-Entity
    • Option1: Simple & clean
    • No break out by entity pair
    • Easy to maintain

Option 1

Entity IER IEP
Entity 1 A B
Entity 2 C D
Entity 3 E F

Option 2 (IET setup per entity pair)

Entity A Entity B Entity  IER Entity A IEP Entity B IER Entity B IEP # of GL Accounts
Entity 1 Entity 2 A B C D 4
Entity 1 Entity 3 E E F F 2 (recommended)
Entity 2 Entity 3 G G G G 1

Combined IET Journal

    • For existing customers, Sage Intacct will use the first journal
  • Should not switch inter-entity setup as it will delete all of the prior setup
  • New centralized mapping screen
    • Will require permission to be enabled
  • Updates to Dynamic Allocations will come after Inter-Entity logic is consolidated

Define IET Relationship

  • Export template will allow you to import all of the relationships (will make updating and managing this setup much easier)
  • Centralized IET Mapping
    • Moved IET setup from tab within Entity setup to separate Inter-entity accounting mapping
    • New screen new permission
  • IET is not required when setting up multiple entities

Migration

  • All active entities are migrated
  • Will be done by Sage when this update rolls out

Release Recommendation

  • Original timeline May 2020
  • May be pushed back due to COVID-19 and interruption to users

Inter-Entity Enhancements

  • Automate IET Journal Entries across multiple base currencies (required IGC)
  • Combined IET with source transaction
    • Ease of reconciliation
    • IET custom report drill down to IET & source
  • Unify IET dimension to location only
    • IET triggered by entity, but unify tracking for location only
    • Remove all other dimensions for simplicity (Drill down will only keep Location, errors caused by maintaining multiple dimensions)
  • Automated IET JE when entering transactions
    • No longer need to manually create the IET
    • Only keeps Location dimension

Inter-entity Drill Down

  • Linked IET with the source transaction
    • Bill
    • Payment
    • Source + IET
    • IET Report
  • Ability to view IET directly in the Journals with the original payments
  • Will only affect new transactions after release

How this will affect Dimension Relationships

    • IET will ignore Dimension Relationships when posting
    • No plans to include more dimensions into the IET postings for now

Inter-entity Report

  • In Drill Down report there is a Record number and it will drill into the individual transactions
  • It is a Custom Report that will need to be built.
  • Include the OET object and Record number field

If you’d like to learn more about Sage Intacct’s capabilities for your company’s financial management, visit our Sage Intacct Overview page.

Have a question? Click here to contact this representative.