Map inter-entity accounts

Sage Intacct records inter-entity transactions separately from other types of receivable and payable transactions. An example of an inter-entity transaction is when one entity pays an AP supplier invoice on behalf of another entity. For each entity in your company, you can specify the payable and receivable accounts you want to use for inter-entity transactions.

You can set up inter-entity transaction (IET) accounts for all your entities on one central page. First, select an inter-entity account mapping plan, either Basic or Advanced. The Basic plan enables using two accounts per entity for IETs. The Advanced plan enables using four accounts per entity for IETs.

Before you begin mapping inter-entity accounts

Before you set up an IET mapping plan, note the following:

• Choose the right time to change your IET setup
• Save a copy of your IET mapping before making changes
• Unsupported IET changes

Choose the right time to edit your IET setup

A best practice is to make changes to your inter-entity setup at:

• A time when no transactions are being recorded.
• The beginning of an accounting period.

Save a copy of your IET mapping before making changes

A best practice before changing your inter-entity account setup is to export the setup from the Inter-entity account mapping page. Exporting your IET setup saves the setup to a CSV file. You can save a copy of the CSV file as an archive and edit another copy to update your setup. You can re-import the file after saving your edits to apply those edits to the Inter-entity account mapping page.

Learn more about importing and exporting an inter-entity account mapping plan.

No asymmetric pairs or inactive entities

Sage Intacct does not support:

• Asymmetrical relationships where A can pay for B, but B cannot pay for A, or the reverse.
• Mapping any inactive entities.

Select an inter-entity account mapping plan

The Manage multiple entities page enables you to choose either the Basic or Advanced inter-entity account mapping plan.

1. Open Subscriptions (Company > Admin > Subscriptions).
2. On the Subscriptions page, select Multi-Entity Management, then select Configure.
3. Scroll down to the Inter-entity account mapping section, and select an inter-entity account mapping plan from the drop-down list: Basic, or Advanced.

Map all your entities

Use the IET account setup CSV template to:

• Automatically generate a list of all possible entity pair permutations in your Intacct company. Then, download the auto-created CSV template file, edit the file to define accounts for any entity pairs that you want to map, and import the CSV file back into Intacct.
• Edit your existing IET account setup by exporting your setup to a CSV file, edit the file as you like, then save the file and import it back in to Intacct. The changes you make in the imported file are reflected in your IET account setup.
• Archive your current inter-entity account setup by exporting it to a CSV file.

Learn more about automatically generating a list of entity pair mappings by downloading a CSV file.

Edit the inter-entity account mapping

The inter-entity account mapping page enables you to map entities for inter-entity transactions. Entities are mapped in pairs, and you can select inter-entity receivable (IER) and inter-entity payable (IEP) accounts to be used with each entity pair.

If you have not yet mapped entities to inter-entity payable and receivable accounts, you can do so here. If your entities are already mapped, you can edit existing entity mappings or add more entity mappings.

1. On the Inter-entity account mapping page, select Edit.
2. To add a mapping, select Add (circle) next to an existing inter-entity account mapping.
3. To edit a mapping, select the name of the entity or account you want to edit, and select another value.
4. To delete a mapping, select the delete icon next to the inter-entity account mapping you want to delete.
5. Select Save.

Field-by-field descriptions

The following tables describe the fields in the inter-entity account tables:

Export template and Import options

Field

Description

Export template Import

If you decide to make extensive changes to your inter-entity setup, you can also do so with CSV files. The inter-entity account setup page enables you to export a CSV file containing your migrated inter-entity account setup and edit the setup as you wish. When you're done editing, you can save the file and import it back in to Intacct. The changes you make in the imported file are then reflected in your inter-entity setup. Finally, you can export your current inter-entity account setup to a CSV file simply to archive your inter-entity account mappings. A best practice before changing your inter-entity account setup is to export the setup from the Inter-entity account mapping page. Exporting your IET setup saves the setup to a CSV file. You can save a copy of the CSV file as an archive and edit another copy to update your setup. You can re-import the file after saving your edits to apply those edits to the Inter-entity account mapping page. Learn more about importing and exporting an inter-entity account mapping plan.

Basic inter-entity account mapping plan

Field	Description
Entity	The name or ID of the entity.
Receivable account	The receivable account that you assign to the entity to record inter-entity transactions.
Payable account	The payable account that you assign to the entity to record inter-entity transactions.

Advanced inter-entity account mapping plan

Field	Description
Entity A	The name of one entity in the mapped pair
Entity B	The name of the other entity in the mapped pair.
Entity A IER	The inter-entity receivable account that you assign to Entity A to record IETs.
Entity A IEP	The inter-entity payable account that you assign to Entity A to record IETs.
Entity B IER	The inter-entity receivable account that you assign to Entity B to record IETs.
Entity B IEP	The inter-entity payable account that you assign to Entity B to record IETs.