Set up the affiliate entity dimension

Sage Intacct uses the affiliate entity dimension to auto-tag automated inter-entity journal entries. You can also use the affiliate entity dimension to tag manually generated General Ledger journal entries.

By enabling the affiliate entity dimension, you can:

  • Enrich and enhance inter-entity activity and balance information.
  • Glean more detailed information when you run reports such as dimension balance, General Ledger, and financial reports.
  • Automatically track activity by affiliate entity on all automated inter-entity entries. Use with the entity pair mapping to determine the due to and due from balances by affiliate entity

Affiliate entity tagging benefits the inter-entity reconciliation process. You can get the balance of accounts by the affiliate entity dimension value. For example, suppose that your management company entity E101 has inter-entity receivables for 15 entities. You can use the affiliate entity dimension to report on that inter-entity activity and easily reconcile it against the inter-entity payables for all 15 entities. You can do this using only one inter-entity receivable account and one inter-entity payable account.

Use the affiliate entity dimension to automate eliminations in your consolidations by eliminating activity between entities in the same reporting book. You can use affiliate entity in Domestic, Global, or Advanced Ownership Consolidation. Auto-eliminate across more complex direct and indirect inter-entity relationships in Advanced Ownership Consolidation.

Simplify your inter-entity mapping by leveraging the affiliate entity dimension to identify the due to or due from amounts in an inter-entity transaction.

Subscription

Company

Consolidation

General Ledger

Multi-Entity Management

Regional availability

All regions

User type

Business user with admin privileges
Permissions

Company

  • Application subscriptions: List, View, Configure
  • Entities: List, View, Add, Edit, Delete

Set up the affiliate entity standard dimension for your company

  1. Go to Company > Admin > Subscriptions > Multi-Entity Management.
  2. Select Configure.
  3. Select Enable affiliate entity dimension.
  4. Select Save.

After you enable the affiliate entity dimension in Multi-Entity Management, it's automatically enabled in General Ledger.

Enable the affiliate entity dimension in a Consolidation book or ownership structure

You can enable the affiliate entity dimension per book or ownership structure. When you enable the dimension for an ownership structure, Intacct propagates the affiliate entity dimension to all the consolidation books that are part of the ownership structure. The Eliminate by affiliate entity option appears selected and unavailable on any book where the ownership structure to which the book belongs already has the affiliate entity dimension enabled.

Before you begin:

Before selecting Eliminate by affiliate entity, it's a best practice to first determine when you want to start tagging inter-entity activity by affiliate entity and reclassify those transactions accordingly. Future consolidations will be incorrect without first reclassifying transactions as needed.

Refer to Reclassify data with the affiliate entity dimension and consolidate for more information about reclassifying inter-entity activity.

  1. Reclassify transactions as described in Reclassify data with the affiliate entity dimension and consolidate.
  2. Select Eliminate by affiliate entity for the book or ownership structure.
  3. Re-consolidate.

If you need a quick fix, simply deselect Eliminate by affiliate entity, save the book or ownership structure, and re-consolidate.

  1. Go to the list of books or ownership structures:
    • Domestic Consolidation > Setup > Books.
    • Global Consolidation > Setup > Books.
    • Advanced Ownership Consolidation > Setup > Ownership structures.
  2. Select Edit next to the book or ownership structure that you want to edit.
  3. Go to Consolidated dimension and select the Affiliate entity dimension.
  4. Save your changes and reclassify your inter-entity activity with the affiliate entity dimension.

    For more information about reclassifying inter-entity activity, see Reclassify data with the affiliate entity dimension and consolidate.

  5. Select Eliminate by affiliate entity.
    • For a book: On the Entities to eliminate tab, select Eliminate by affiliate entity.
    • For an ownership structure: On the Ownership structure page, select Eliminate by affiliate entity.

    After you select Eliminate by affiliate entity, Intacct automatically selects Affiliate entity from the list of Consolidated dimensions if it is not already selected.

Tag manually created journal entries with the affiliate entity dimension

  1. Go to General Ledger > All > Journal entries.
  2. Select Edit next to the journal entry that you want to edit.
  3. In the table of Entries, select an entry and then select the Affiliate entity table cell for that entry.
  4. Select the relevant affiliate entity for the entry.
  5. Select Post to save your changes.

Move affiliate entity dimension to the line items table

You can move the Affiliate entity dimension from the More details menu into the line-items grid for better visibility. There's not an option to move entry lines in the inter-entity entries section.

Learn how to move entry lines.