GL Intra Company Accounting

Overview

ICA processing lets the system, based upon set-up parameters, generate journal lines to keep a single transaction balanced for each set of books represented by a user's data entry.

You must designate one of your account segments as the balancing segment for a transaction. For example, if your account definition is Div-Acct-Centre, you may specify that when a transaction crosses divisions, the system should generate lines to keep each division balanced. You can also specify that when a transaction crosses management codes, the system should generate transaction to keep each management code balanced. Otherwise, you can specify that when a transaction crosses cost centres, the system should generate transactions to keep each centre balanced.

You can find further information on ICA in:

ICA Structure

ICA processing relies upon GL structures. On the structure, you specify the points in the organisation that require a balanced set of books. These points are called BTZ (balance to zero) elements. You can also specify additional elements that allow you to generate a BS or P&L Statement. But if the element is not a BTZ element, the statements will not balance.

The following structure is based on locations. For each BTZ element, you specify the path keys that point to the element. When you enter a journal with path keys that cross multiple BTZ elements, the system generates lines to make the debits equal the credits for each BTZ. See Structures for more information on structures and path keys.

Diagram gl030

 

The locations, LOC1, LOC2, etc. are defined as management codes on the Chart of Accounts for the management segment Location. This structure is then designated as the ICA structure on the GL Company Controls screen MEAB and the Location segment is identified as the relevant ICA management segment. Suppose that the elements marked with an asterisk are BTZ elements. When necessary, the system generates postings for each element, so they will be in balance with regard to Location. Any element that is higher in a structure than a BTZ element, must also balance. For example, SUB1 will balance, as will DIV3 and COMP.

Balancing Elements

e5 GL works on the principle that for every actual balance (AB) posting there is an equal but opposite posting. For example, for a £100 debit posting to LOC1, there will be a £100 credit, which may post to another location, or to a different nominal for LOC1, assuming the structure on the previous page is the ICA structure. If the £100 credit posts to LOC2, these two postings will balance to zero for DIV1 when the management segment Location is considered.

ICA is demonstrated when the double-entry posting involves two BTZ elements. For example, a £100 debit to LOC1 and £100 credit to LOC3. This would leave DIV1 and DIV2 out of balance if not for ICA. The system makes additional postings using a Location management code for DIV1 and DIV2 to credit DIV1 with £100 and to debit DIV2 with £100.

DIV1:

user posts

 £100 D

 to LOC1

system generates

 £100 C

 to the Location set up for DIV1 as a part of the ICA structure definition

DIV2:

user posts

 £100 C

 to LOC3

system generates

 £100 D

 to the Location set up for DIV2 as a part of the ICA structure definition

 

ICA only generates these additional postings when actual or accrual postings are made. Planning and commitment accounting adjustments do not generate any ICA postings as there is no requirement for equal and opposite postings for those types of processing.

Cost Allocation only generates ICA postings when actual values (AB) or value-dated balances (VB) are allocated.

Postings

This section shows the postings that arise in a company that is using ICA. These postings may occur when transactions originate outside of GL or within GL. In the examples in this section, a batch of transaction details is created and, as part of the ICA routine, additional ICA postings may be created.

In all of the examples, the following structure is used:

Diagram gl040

 

There are five BTZ entities on this structure, as defined on the Intra Company Account screen MECJ. They are indicated with an asterisk (*). The ICA management code that is set up to use when generating ICA postings is indicated with a hash sign (#).

The following list identifies how this structure is set-up:

The ICA Relationship screen MAKJ lets you specify which BTZ elements can trade with one another. This screen also lets you specify the nominal and other required segments the system should use for the ICA when generating ICA lines.

Suppose trading between the following:

Note: The location LXXX in the following examples indicates the entry is irrelevant, as it will be overlaid with the preceding locations when the system generates transactions.

 

 Nominal  Centre  Location

DIV1 and DIV2 use

 100

 CC00

 LXXX

DIV1 and any BTZ element in DIV3 uses

 200

 CC00

 LXXX

DIV2 and any BTZ element in DIV3 uses

 300

 CC00

 LXXX

Any pair of BTZ elements in DIV3 uses

 400

 CC00

 LXXX

 

This can be achieved with the following arrangement in which eight trading relations are defined on the ICA Relationship screen MAKJ:

BTZ Element From

BTZ Element To Trading Account

********************

********************

ICA 200 CC00 LXXX

DIV1

DIV2

ICA 100 CC00 LXXX

DIV2

LOC5

ICA 300 CC00 LXXX

DIV2

LOC6

ICA 300 CC00 LXXX

DIV2

SUB2

ICA 300 CC00 LXXX

LOC5

LOC6

ICA 400 CC00 LXXX

LOC5

SUB2

ICA 400 CC00 LXXX

LOC6

SUB2

ICA 400 CC00 LXXX

 

NOTE There are no entries between DIV1 and the elements in DIV3. Therefore, when transactions cross elements in these divisions, the system uses the first entry in the table (the default). If you want to prevent a pair of elements from trading, create an entry with a blank account number.

A key concept in ICA is that there is an "owning" BTZ element for every data entry batch. The owning BTZ element holds responsibility for entered transactions and represents the trading point for the transactions.

If the trading point is not one of the BTZ elements to which one of the line-level entered ICA management codes is linked, there will be additional ICA postings.

Data Entry Transactions:

Assume the user enters these detail lines for all of the following examples:

Nominal

 Centre Location Value

NOM1

CC00

LOC1

£100 D

NOM1

CC00

LOC3

£40 C

NOM1

CC00

LOC5

£60 C

 

Example 1:

If the header BTZ element is DIV1, the system generates these ICA postings:

Nominal

Centre Location Value

100

CC00

LOCA

£40 C

100

CC00

LOCB

£40 D

200

CC00

LOCA

£60 C

200

CC00

LOC5

£60 D

 

Consequently, each BTZ element remains in balance with these journal lines:

BTZ

Nominal Centre Location Value Notes

DIV1

NOM1

CC00

LOC1

£100D

user entered

 

100

CC00

LOCA

£100C

system generated

DIV2

NOM1

CC00

LOC5

£60C

user entered

 

300

CC00

LOC5

£60D

system generated

LOC5

NOM1

CC00

LOC3

£40C

user entered

 

100

CC00

LOCB

£100D

system generated

 

300

CC00

LOCB

£60C

system generated

 

Example 2:

If the header BTZ element is DIV2, the system generates these ICA postings:

Nominal

Centre Location Value

100

CC00

LOCB

£100 D

100

CC00

LOCA

£100 C

300

CC00

LOCB

£60 C

300

CC00

LOC5

£60 D

 

Consequently, each BTZ element remains in balance with these journal lines:

BTZ

Nominal Centre Location value Notes

DIV1

NOM1

CC00

LOC1

£100D

user entered

 

100

CC00

LOCA

£100C

system generated

DIV2

NOM1

CC00

LOC5

£60C

user entered

 

300

CC00

LOC5

£60D

system generated

 LOC5

NOM1

CC00

LOC3

£40C

user entered

 

100

CC00

LOCB

£100D

system generated

 

300

CC00

LOCB

£60C

system generated

 

Example 3:

If the header BTZ element is SUB2, the system generates these ICA postings:

Nominal

Centre Location Value

200

CC00

LOC7

£100 D

200

CC00

LOCA

£100 C

300

CC00

LOC7

£40 C

300

CC00

LOCB

£40 D

400

CC00

LOC7

£60 C

400

CC00

LOC5

£60 D

 

Consequently, each BTZ element remains in balance with these journal lines:

BTZ

Nominal Centre Location Value Notes

DIV1

NOM1

CC00

LOC1

£100D

user entered

 

200

CC00

LOCA

£100C

system generated

DIV2

NOM1

CC00

LOC3

£40C

user entered

 

300

CC00

LOCB

£40D

system generated

SUB2

200

CC00

LOC7

£100D

system generated

 

300

CC00

LOC7

£40C

system generated

 

400

CC00

LOC7

£60C

system generated

LOC5

NOM1

CC00

LOC5

£60C

user entered

 

400

CC00

LOC5

£60D

system generated

NOTE The menu path shown is the default for the system. Your company may have customised menu options, so the path shown may not be accurate. Please contact your system administrator for details.

See also

General Ledger Home Page