Introduction
About the IC Module
The new Intercompany module allows for automated recharging of the shared cost or management fees from one entity to another. This is done by linking the IC Debtor and IC creditor accounts via an API connection.
This new module can be accessed as a menu option in the blue menu bar and as a separate tab.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/3606/4080913/1716455373298-screenshot-uk1.accountsiq.com-2024.05.23-10_07_05%2B_1_.png)
Key Features of the new IC Module
Here are the new and enhanced features of our latest IC Module release:
- Streamlined IC Connection Setup: Option to create debtor and creditor accounts at the time of creating an IC connection or beforehand.
- Separate IC Listing Grid: All Intercompany accounts (debtors and creditors) are now hidden in the main Customers and Suppliers listings and are placed in the intercompany listing. (To see the IC accounts within the Customers or Suppliers listing grids use the option to clear the default filter.) The IC listing grid lets you view real-time IC balances between linked IC debtor/creditor accounts to identify and resolve out-of-balances as they occur, not just month end. In the Group Consolidation entity, you can view and manage company IC balances for all subsidiaries.
- Enhanced Transactions: The IC module allows for both automated and manual recording of Management Charges, Intercompany Trade (this should cancel on Consolidation), and Payment/Funds between entities in the group. The new IC Bank Transfer lets you record IC bank transactions in both entities simultaneously and set up posting rules to auto-post and auto-reconcile IC funds transfers.
- Enhanced Reporting: IC accounts are separate from sales and purchase reports for more precise analysis. “IC Matrix Reconciliation Report” can drill-down to IC transaction level making it easier for multi-entity companies to complete their close.
What types of Entity can use the IC Module?
IC transactions can be used between Group Subsidiary Companies, between Group Companies and Subsidiaries or other Group Companies, between Franchisor and Franchisees (and vice-versa) or even between independent non-related Companies that want to reduce re-keying of data between them.
What User Permissions do I need?
To use the features outlined in this article, check that you have the following permissions if relevant to your role. These can all be found in the Menu tab of the Maintain Menu Profiles screen. See Setting Up System Users for more details.
- Add Connection: Have permission to set up IC Creditor and Debtor accounts and create a connection between them.
- Unprocessed Transactions: Users who do not have permissions to post invoices, credit notes or purchase debit/credit journals will be able to view but not post those transactions from the relevant screens.
- Intercompany Account Listing: Have permission to view the listing grid.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/3606/4204122/image%2B_58_.png)
See:
New! Introduction to Intercompany module (13.0) - AIQ Academy
New! Creating Intercompany Connections (13.1) - AIQ Academy
New! Creating Intercompany Transactions (13.2) - AIQ Academy
Creating, Editing, and Deleting IC Connections
How many IC Connections can I create?
You can create as many IC connections between two entities as needed to manage your IC activities. For example:
- Create only one connection if all your IC activities will be recorded against one account in each entity.
- Create more than on connection, if different debtor and creditor accounts will be used to track specific activities, for example, one connection for re-charging costs with a specific debtor account, and another connection to track loans.
What IC Accounts do I need to set up?
Control Accounts: These must be set up before a connection is created. Control accounts are used to eliminate intercompany balances at consolidation level by using their GL Category and Sub Category. They also keep IC account reporting separate from other sales and purchases. See Using Codes Maintenance for more on setting up control accounts.
Set up as follows:
- One Way Connection: IC Debtor Control account in the originating company and IC Creditor Control account in the receiving company.
- Two Way Connection: If the IC connection needs to go both ways, then IC Debtor and IC Creditor control accounts should be set up in both the sending and the receiving entities.
To create intercompany loans, you will need to create multiple control accounts.
Sending IC Debtor and Receiving IC Creditor Accounts: These can be set up before or during IC Connection creation. If you set them up before, this can be done from the IC listing grid, by going to the Create New and selecting Debtor or Creditor. The IC Control Account is selected by default so that the accounts will only appear in the IC listing grid. For full details on creating accounts, see Managing Customer Master Records and Managing Supplier Master Records.
Set up as follows:
- Intercompany debtor account for each company that will be sending charges.
- Intercompany creditor account for each company that will be receiving charges.
Are there any Currency Considerations?
As a rule of thumb when the Intercompany accounts are set up, the base currency of the local entity is used for the IC debtor. The IC creditor would then inherit the same currency. In cases when the local entity agrees to bear the cost of the currency fluctuation, the IC debtor account could be set up in foreign currency, i.e. in the base currency of the receiving entity.
Foreign currency revaluation journal must be run at the end of each financial period to align the currency rate for each entity before consolidating accounts and eliminating IC balances.
Creating an Intercompany Connection
First, ensure that the relevant control accounts (described above) have been set up.
- Log into the entity that will send charges.
- From the Create New, select Connection to create connections with another entity to enable Intercompany Transactions.
- Select the company you want to connect to and whether it is a One-way, or Two-way connection.
- Next you must map the customer/supplier relationship between this entity and the partner entity. Create or select the Sending IC Debtor and Receiving IC Creditor accounts. Note, you must create these accounts with the same base currency.
- If you already have designated IC accounts, select them from the Sending I/C Debtor Account and Receiving I/C creditor Account dropdowns.
- If you do not already have IC accounts, set them up. Click Create I/C Debtor and Creditor Accounts and complete the account creation process. This will be either two accounts for a one-way connection or four accounts for a two-way connection.
-
Debtor/Creditor Accounts: The account codes and names will be preselected with the entity codes and names but can be changed. Dropdowns will show what is available in each entity being connected.
- If you do not see an option, i.e. GL, control, or tax code, go to the relevant entity and create it there first, then return and complete the connection setup. Alternatively, select an option from the dropdown but change it as soon as the connection and accounts are created.
- Posting Accounts: Ensure the GL Posting accounts are defaulted to either the IC clearing account, IC Sales, or IC Cost account.
- Control Accounts: Select your designated IC control accounts.
- Tax Code: Select the appropriate default tax code on both accounts to avoid mis-posting at the data processing stage.
- Currency: Currency will be always dictated by the currency selected for the IC debtor account. The creditor's currency will be updated to ensure alignment between the IC debtor and creditor accounts and cannot be changed. The currency used to set up the debtor and creditor accounts will determine which entity will bear the cost of foreign currency fluctuations.
- Click Save.
-
Debtor/Creditor Accounts: The account codes and names will be preselected with the entity codes and names but can be changed. Dropdowns will show what is available in each entity being connected.
- Click Create to complete the connection process.
- In the IC screen refresh the grid and the connection will appear with the relevant Debtor and Creditor accounts created against each entity. If necessary, it can still be deleted if there are no associated transactions (see below). To check if the connection is live, in the IC listing grid, go to Actions > Recharge > Batch Invoice. Check if there is a notice in the footer stating that an IC transaction will be created if the invoice is processed.
Editing an Intercompany Account
- In the IC listing grid, click on the code hyperlink.
- The following can be edited: Account Name, default GL Code, tax code, payment terms and method, and currency. Note, if you edit the currency, you must also edit it manually in the linked company.
- Click Save.
Deleting an IC Connection
Go to Actions > Delete Connection. It is possible to delete connections even if the related IC accounts have transactions. This could be necessary if the connection were set up in error. If the wrong accounts were linked, the connection can then be re-created with different accounts.
IC Transactions
From the IC screen you can initiate intercompany transactions from one entity to another, such as recharges and non-recharging activities, as well as view all transactions in different formats, and email statements. When a transaction is created in the originating entity, the system will automatically generate a corresponding transaction in the receiving entity.
Creating IC Transactions in the Sending Entity
- Go to Actions > Transactions to create either recharge or non-recharge transactions directly from the IC listing grid.
- Recharge transaction goes to the linked company. The IC module has the following transaction type recharge options: Batch Invoice, Batch Credit Note, Credit Journal, Debit Journal, and Refund (Payment to the customer account).
- Non-Recharge transactions are only created in the local entity and does not go to the linked company. The IC module has the following transaction type non-recharge options: Item Invoice, Item Credit Note, and Receipt & Allocate.
- Recharge transaction goes to the linked company. The IC module has the following transaction type recharge options: Batch Invoice, Batch Credit Note, Credit Journal, Debit Journal, and Refund (Payment to the customer account).
- Selecting any transaction type will take you to the relevant transaction screen. A notification appears advising this will create IC transactions. If you don’t see this message, review your intercompany setup.
- From the dropdown, select the IC Account Receivable. Any defaults setup against the IC account will automatically pre-fill but can be changed. Complete all fields. For Batch Invoices, you can populate multiple lines to create multiple invoices to multiple intercompany accounts, or you can create one invoice with multiple lines to only one intercompany account.
- Once all fields are complete, click Post or Process to complete the transaction. A progress bar appears, indicating the number of IC charges sent to the receiving company.
- The IC listing grid will refresh, and the transaction value will update the account balance in the local entity. However, the account on the connected entity will remain unbalanced until the transaction is accepted at that entity.
Accepting Intercompany Transactions in the Receiving Entity
The IC icon displays the number of unprocessed IC transactions awaiting processing. In the event where multiple entities are consolidated, the consolidation manager will show which entities have unprocessed inter-company charges.
Note that the FX rate for foreign currency transactions will be taken from the currency rates table and will be as of the latest rate, not the rate as of the date of the transaction.
- Go to Intercompany > Intercompany Transactions or click on the IC icon. Intercompany charges received will be listed here for you to select and post.
- Select the transactions you wish to accept, and update the editable fields as needed. You can override the default GL account, BI code or tax code which are automatically pulled from the IC supplier account.
- The Type column displays the transaction type that will be created, i.e. Purchase Invoice (PI), Purchase Note (PN), Purchase Debit (PD) or Purchase Credit (PC). Refunds will be sent as the Type PC. Therefore, if some of the PCs were sent as a funds transfer and the incorrect bank account was pre-selected, only bank accounts will be available in the GL Account dropdown.
- It is not currently possible to process a refund for an account that is not in the base currency. Either select a bank account in base currency or change the defaults for the IC Creditor by closing the unprocessed transactions screen and re-opening it to post the transaction.
- If you select a line from a multi-line transaction such as an invoice or a credit note, all other lines of the same transaction will be selected automatically based on having the same type, creditor account, Ext Ref, and Date. If you change an Ext Ref for one of the lines after selecting it, the system will then deselect it.
- When finished, click on Post Selected to accept the transactions and post them as a purchase batch invoice. The charge will disappear from the grid.
- Refresh the IC listing grid to display the updated balance. The transaction will also display in the Purchase Batch Invoices grid. If you log back into the sending entity, both accounts should now balance.
Automating Payments and Fund Transfers
Achieve automation of payments and fund transfers by posting at bank reconciliation stage and setting a rule for future posting within each trading entity. See Using Bank Statement Files with Bank Reconciliation.
Intercompany Loans
To use intercompany loans, create multiple control accounts and link the relevant debtor and creditor accounts to them.
Queries and Reporting with the IC Listing Grid
IC Listing Grid Functions
Use the IC listing grid to:
- View and manage Intercompany connections. Each line represents an IC connection (see section 2 above).
- View and manage your Intercompany account balances with linked entities (see section 3 above).
- Generate queries and export them to Excel (see below).
- Use the Actions dropdown to view statements, transactions, and reports, and email statements.
Generating Queries
- The listing grid displays the date and time the balances were last updated. Click Refresh Grid to bring in any newer transactions. If necessary, click Clear to remove any filter selections.
- Select a Period from the dropdown in the listing header. This will display the account balances as of that date. This assists with IC and Trial Balances reconciliation.
- In Current Filter, select a filter as needed.
- The left-hand side of the grid displays IC accounts of the company you are in, and the right displays the corresponding IC accounts of each connected company. Use the header search fields, dropdowns, and ascending/descending arrows to refine your selection for the following:
- A/C Type: IC Debtors are listed first, followed by IC Creditors. To see the list of only IC Debtors or Creditors use the grid filter for the A/C Type field.
- A/C Code (Local Company)/A/C Code (Connected Company): Click the code to view the company account details. The link will only work if you have access to this company.
- A/C Name
- Currency
- Balance: This displays the real-time balances. Click on the link to open the Transaction Details for the local company. The balances on the local and connected accounts should cancel each other out.
- To create a copy of the report, click Export to Excel.
Error Notices
The Notice icon lets you know immediately if there is an issue, such as an unbalanced account, mismatched currency, or if the IC debtor or IC creditor is created but not linked. From the listing grid, you can log into any connected entity and make any relevant updates to the related accounts. Hover over the icon to view an explanation.
Note, the currency mismatch error can only apply to accounts that were set up using the legacy module.
IC Group Consolidation
Eliminating IC Balances
Intercompany balances are eliminated by linking the Intercompany Control Accounts to the same GL Category and GL Subcategory in the Group Consolidation Entity. See the report “Consolidated Balance Sheet - Split by Subsidiary”.
Elimination of IC Trade
Elimination of intercompany trade can also be achieved by posting a journal in the Group Consolidation Entity at the end of each reporting period by going to General > GL Journal Manager > Create New Journal > GL Journal.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/3606/4081637/1716473702183-screenshot-uk1.accountsiq.com-2024.05.23-15_14_16.png)