Oracle® Fusion
Accounting Hub Implementation Guide 11g Release 1 (11.1.2) Part Number E20374-02 |
Contents |
Previous |
Next |
This chapter contains the following:
Manage Intercompany Balancing Rules
Manage Ledger Balancing Options
Intercompany balancing rules are used to generate the accounts needed to balance journals that are out of balance by legal entity or primary balancing segment values.
You specify the intercompany receivables and intercompany payables accounts you want to use. The intercompany balancing feature then uses these rules to generate the accounts of the balancing lines it creates.
You can define intercompany balancing rules at the following rule levels:
Primary balancing segment
Legal entity
Ledger
Chart of accounts
The rules are evaluated in the order shown above. For example, you can define a Primary Balancing Segment rule and a Legal Entity level rule. If both rules are used to balance a particular journal, the Primary Balancing Segment rule is used, as it has a higher precedence.
You have flexibility in defining your intercompany balancing rules. You can have a simple setup in which you define one rule for your chart of accounts. This rule is used for all intercompany balancing for all ledgers that use this chart of accounts. Alternatively, you can have a more granular set of rules. For example, you can define a different rule for each legal entity and one chart of accounts rule to cover any gaps in your rule definitions. You can gain even more granularity by defining rules for specific journal and/or category combinations or intercompany transaction types.
This topic provides examples of intercompany balancing rules and the intercompany balancing lines generated. These rules are used to generate the accounts needed to balance journals that are out of balance by legal entity or primary balancing segment values.
Simple Chart of Accounts
In this scenario the enterprise has one chart of accounts for all its ledgers. The chart of accounts has an intercompany segment. They are using this intercompany segment and the company segment to identify the intercompany trading partners for each transaction. They do not have a need to track their intercompany activity at a granular level such as by journal source and journal category or by intercompany transaction type.
Setup
InFusion USA Chart of Accounts
Segment Qualifier |
Primary Balancing Segment |
Second Balancing Segment |
Third Balancing Segment |
Account |
Intercompany Segment |
---|---|---|---|---|---|
Segment Name |
Company (CO) |
Cost Center (CC) |
Product (PROD) |
Account (ACCT) |
Intercompany (IC) |
Ledger, Legal Entity, Primary Balancing Segment Value Assignments
Ledger |
Legal Entity |
Primary Balancing Segment Value |
---|---|---|
InFusion USA |
InFusion Farms |
3100, 3200, 3300, 3400, 3500 |
InFusion USA |
InFusion Textiles |
4000 |
InFusion USA |
InFusion Products (East) |
5000 |
InFusion USA |
InFusion Products (West) |
6000 |
InFusion USA |
|
1000, 9000 |
Chart of Accounts Rule
Rule Number |
Chart of Accounts |
AR Account |
AP Account |
Source |
Category |
Transaction Type |
---|---|---|---|---|---|---|
1 |
InFusion USA Chart of Accounts |
1000 - 000 - 0000 - 13010 - 0000 |
1000 - 000 - 0000 - 21010 - 0000 |
Other |
Other |
None |
Journal Balancing
Journal before Balancing
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
2 |
Liability |
InFusion Textiles |
4000 |
500 |
1300 |
40118 |
0000 |
|
150 |
Journal Balancing
Journal after Balancing
Uses Rule |
Line |
Line Type |
Legal Entity |
Company |
Cost Center |
Product |
Account |
Intercompany |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|---|
|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
|
2 |
Liability |
InFusion Textiles |
4000 |
500 |
1300 |
40118 |
0000 |
|
150 |
1 |
3 |
IC AP |
InFusion Farms |
3100 |
100 |
1200 |
21010 |
4000 |
|
150 |
1 |
4 |
IC AR |
InFusion Textiles |
4000 |
500 |
1300 |
13010 |
3100 |
150 |
|
Legal Entity and Chart of Accounts Rules
In this example the legal Entity InFusion Textiles intercompany manufacturing activities are tracked separately from its non-manufacturing activities. In order to achieve this legal entity level rules are defined specifically between the legal entity InFusion Textiles and the two manufacturing legal entities, InFusion Products (East) and InFusion Products (West). A chart of accounts rule is created to cover all other intercompany activities.
Setup
InFusion USA Chart of Accounts
Segment Qualifier |
Primary Balancing Segment |
Second Balancing Segment |
Third Balancing Segment |
Account |
Intercompany Segment |
---|---|---|---|---|---|
Segment Name |
Company |
Cost Center |
Product |
Account |
Intercompany |
Ledger, Legal Entity, Primary Balancing Segment Value Assignments
Ledger |
Legal Entity |
Primary Balancing Segment Value |
---|---|---|
InFusion USA |
InFusion Farms |
3100, 3200, 3300, 3400, 3500 |
InFusion USA |
InFusion Textiles |
4000 |
InFusion USA |
InFusion Products (East) |
5000 |
InFusion USA |
InFusion Products (West) |
6000 |
InFusion USA |
|
1000, 9000 |
Chart of Accounts Rule
Rule Number |
Chart of Accounts |
AR Account |
AP Account |
Source |
Category |
Transaction Type |
---|---|---|---|---|---|---|
2 |
InFusion USA Chart of Accounts |
1000 - 000 - 0000 - 13050 - 0000 |
1000 - 000 - 0000 - 21050 - 0000 |
Other |
Other |
None |
Legal Entity Level Rule
Rule No. |
From Legal Entity |
To Legal Entity |
AR Account |
AP Account |
Source |
Category |
Transaction Type |
---|---|---|---|---|---|---|---|
3 |
InFusion Textiles |
InFusion Products (West) |
1000 - 000 - 0000 - 13020 - 0000 |
1000 - 000 - 0000 - 21020 - 0000 |
Other |
Other |
None |
4 |
InFusion Textiles |
InFusion Products (East) |
1000 - 000 - 0000 - 13030 - 0000 |
1000 - 000 - 0000 - 21030 - 0000 |
Other |
Other |
None |
Journal Balancing
Journal before Balancing
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
2 |
Expense |
InFusion Products (East) |
5000 |
100 |
1200 |
52340 |
0000 |
200 |
|
3 |
Expense |
InFusion Products (West) |
6000 |
200 |
1300 |
52345 |
0000 |
300 |
|
4 |
Liability |
InFusion Textiles |
4000 |
500 |
1300 |
40118 |
0000 |
|
650 |
Journal Balancing
Journal after Balancing
Uses Rule |
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|---|
|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
|
2 |
Expense |
InFusionProducts (East) |
5000 |
100 |
1200 |
52340 |
0000 |
200 |
|
|
3 |
Expense |
InFusionProducts (West) |
6000 |
200 |
1300 |
52345 |
0000 |
300 |
|
|
4 |
Liability |
InFusion Textiles |
4000 |
500 |
1300 |
40118 |
0000 |
|
650 |
2 |
5 |
IC AR |
InFusion Textiles |
4000 |
500 |
1300 |
13050 |
3100 |
150 |
|
2 |
6 |
IC AP |
InFusion Farms |
3100 |
100 |
1200 |
21050 |
4000 |
|
150 |
4 |
7 |
IC AR |
InFusion Textiles |
4000 |
500 |
1300 |
13030 |
5000 |
200 |
|
2 |
8 |
IC AP |
InFusionProducts(East) |
5000 |
100 |
1200 |
21050 |
4000 |
|
200 |
3 |
9 |
IC AR |
InFusion Textiles |
4000 |
500 |
1300 |
13020 |
6000 |
300 |
|
2 |
10 |
IC AP |
InFusionProducts (West) |
6000 |
200 |
1300 |
21050 |
4000 |
|
300 |
Ledger balancing options are defined for the ledger to balance the second balancing segment and/or the third balancing segment, when a transaction is unbalanced by one of these segments.
Ledger balancing options include the following settings:
Receivables and payables accounts used for ledger balancing
Summarization options
Clearing company options
You can choose to specify the receivables and payables accounts to be used, if your chart of accounts has the second balancing segment and/or the third balancing segment enabled. These accounts are used for the balancing lines generated when a journal is balanced by its primary balancing segment values but is not balanced by its second balancing segment and/or third balancing segment.
You can choose to summarize balancing lines generated for a primary balancing segment out of balance scenario, where all the primary balancing segment values are assigned to the same legal entity. You do this by specifying the Summarization option of Summary Net or Detail. You can choose to summarize by primary balancing segment value or alternatively have individual balancing lines (that have not been summarized) generated. Note that summarization always applies to balancing lines generated in a cross legal entity scenario.
You can choose to set clearing company options to balance a journal with different primary balancing segment values that all belong to a single legal entity. Set the following options to handle your clearing company balancing.
Clearing company condition
You can choose to balance using a clearing company value for all journals or for journals with many legal entities on the debit side and many legal entities on the credit side.
The default value for this option is to error Many-to-Many journals.
Clearing Company Source
Choose how the clearing company value is derived for your balancing lines, from the following options:
Default clearing balancing segment value. Choose this option if you want a single specific primary balancing segment value for your clearing company.
Default Rule. Choose this option if you want to allow the system to derive the clearing company value from a default intercompany balancing rule.
Manually entered clearing balancing segment value. Choose this option if you want to enter the clearing company value when you create a journal.
Clearing Company Value
If you chose the default clearing balancing segment value as your clearing company source, you can enter your chosen primary balancing segment value in this field.
This topic provides examples of ledger balancing options, the setup required, and the journal before and after balancing.
Simple ledger balancing option with no clearing company options
In this scenario the enterprise has the second balancing segment and the third balancing segment enabled for its chart of accounts. The journal is balanced by primary balancing segment but is out of balance by the second balancing segment and the third balancing segment.
Setup
InFusion USA Chart of Accounts
Segment Qualifier |
Primary Balancing Segment |
Second Balancing Segment |
Third Balancing Segment |
Account |
Intercompany Segment |
---|---|---|---|---|---|
Segment Name |
Company CO |
Cost Center CC |
Product PROD |
Account ACCT |
Intercompany IC |
Ledger, Legal Entity, Primary Balancing Segment Value Assignments
Ledger |
Legal Entity |
Primary Balancing Segment Value |
---|---|---|
InFusion USA |
InFusion Farms |
3100, 3200, 3300, 3400, 3500 |
InFusion USA |
InFusion Textiles |
4000 |
InFusion USA |
InFusion Products (East) |
5000 |
InFusion USA |
InFusion Products (West) |
6000 |
InFusion USA |
|
1000, 9000 |
Ledger Balancing Options
Rule Number |
Ledger |
Source |
Category |
Transaction Type |
AR Account |
AP Account |
---|---|---|---|---|---|---|
1 |
InFusion USA |
Other |
Other |
None |
1000 - 000 - 0000 - 13010 - 0000 |
1000 - 000 - 0000 - 21010 - 0000 |
Journal Balancing
Journal Before Balancing
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
2 |
Liability |
InFusion Farms |
3100 |
500 |
1300 |
40118 |
0000 |
|
150 |
Journal Balancing
Journal after Balancing
Uses Rule |
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|---|
|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
|
2 |
Liability |
InFusion Farms |
3100 |
500 |
1300 |
40118 |
0000 |
|
150 |
1 |
3 |
AP |
InFusion Farms |
3100 |
100 |
1200 |
21010 |
0000 |
|
150 |
1 |
4 |
AR |
InFusion Farms |
3100 |
500 |
1300 |
13010 |
0000 |
150 |
|
Ledger balancing options with detail summarization and clearing company options set
In this scenario the enterprise has the second balancing segment and the third balancing segment enabled for its chart of accounts. Management has decided to use a clearing company for balancing Many-to-Many journals only. Since the primary balancing segment values in the journal are out of balance intercompany balancing is required. Additionally since clearing company options have been specified they will be used to balance the journal. Note that if the primary balancing segment values were balanced and only the second balancing segment and the third balancing segment were out of balance, the clearing company options would not be used.
Setup
InFusion 1000, USA Chart of Accounts
Segment Qualifier |
Primary Balancing Segment |
Second Balancing Segment |
Third Balancing Segment |
Intercompany Segment |
|
---|---|---|---|---|---|
Segment Name |
Company |
Cost Center |
Product |
Account |
Intercompany |
Ledger, Legal Entity, Primary Balancing Segment Value Assignments
Ledger |
Legal Entity |
Primary Balancing Segment Value |
---|---|---|
InFusion USA |
InFusion Farms |
3100, 3200, 3300, 3400, 3500 |
InFusion USA |
InFusion Textiles |
4000 |
InFusion USA |
InFusion Products (East) |
5000 |
InFusion USA |
InFusion Products (West) |
6000 |
InFusion USA |
|
1000, 9000 |
Chart of Accounts Rule
Rule Number |
Chart of Accounts |
AR Account |
AP Account |
Source |
Category |
Transaction Type |
---|---|---|---|---|---|---|
1 |
InFusion USA Chart of Accounts |
1000 - 000 - 0000 - 13050 - 0000 |
1000 - 000 - 0000 - 21050 - 0000 |
Other |
Other |
None |
Ledger Balancing Options
Rule Number |
Ledger |
Source |
Category |
Transaction Type |
AR Account |
AP Account |
---|---|---|---|---|---|---|
2 |
InFusion USA |
Other |
Other |
None |
1000 - 000 - 0000 - 13010 - 0000 |
1000 - 000 - 0000 - 21010 - 0000 |
Clearing Company Options
Rule Number |
Ledger |
Source |
Category |
Transaction Type |
Condition |
Source |
Value |
---|---|---|---|---|---|---|---|
2 |
InFusion USA |
Other |
Other |
None |
Use for many-to-many journals only |
Default clearing balancing segment value |
9000 |
Note
The Ledger Balancing Options and Clearing Company Options appear as one line on the form.
Journal Balancing
Journal before Balancing
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
2 |
Expense |
InFusion Farms |
3100 |
300 |
1200 |
52340 |
0000 |
200 |
|
3 |
Expense |
InFusion Farms |
3300 |
200 |
1300 |
52345 |
0000 |
300 |
|
4 |
Liability |
InFusion Farms |
3400 |
500 |
1300 |
40118 |
0000 |
|
320 |
5 |
Liability |
InFusion Farms |
3500 |
600 |
1400 |
40112 |
0000 |
|
330 |
Journal Balancing
Journal after Balancing
Uses Rule |
Line |
Line Type |
Legal Entity |
CO |
CC |
PROD |
ACCT |
IC |
Debit |
Credit |
---|---|---|---|---|---|---|---|---|---|---|
|
1 |
Expense |
InFusion Farms |
3100 |
100 |
1200 |
52330 |
0000 |
150 |
|
|
2 |
Expense |
InFusion Farms |
3100 |
300 |
1200 |
52340 |
0000 |
200 |
|
|
3 |
Expense |
InFusion Farms |
3300 |
200 |
1300 |
52345 |
0000 |
300 |
|
|
4 |
Liability |
InFusion Farms |
3400 |
500 |
1300 |
40118 |
0000 |
|
320 |
|
5 |
Liability |
InFusion Farms |
3500 |
600 |
1400 |
40112 |
0000 |
|
330 |
1 |
6 |
IC AR |
|
9000 |
000 |
0000 |
13050 |
3100 |
150 |
|
1 |
7 |
IC AP |
|
3100 |
100 |
1200 |
21050 |
9000 |
|
150 |
1 |
8 |
IC AR |
|
9000 |
000 |
0000 |
13050 |
3100 |
200 |
|
1 |
9 |
IC AP |
|
3100 |
300 |
1200 |
21050 |
9000 |
|
200 |
1 |
10 |
IC AR |
|
9000 |
000 |
0000 |
13050 |
3300 |
300 |
|
1 |
11 |
IC AP |
|
3300 |
200 |
1300 |
21050 |
9000 |
|
300 |
1 |
12 |
IC AR |
|
3400 |
200 |
1300 |
13050 |
9000 |
320 |
|
1 |
13 |
IC AP |
|
9000 |
000 |
000 |
21050 |
3400 |
|
320 |
1 |
14 |
IC AR |
|
3500 |
600 |
1400 |
13050 |
9000 |
330 |
|
1 |
15 |
IC AP |
|
9000 |
000 |
000 |
21050 |
3500 |
|
330 |
Intercompany reconciliation provides you with reports to assist you with reconciling your intercompany receivables and intercompany payables accounts and to identify any differences.
The main goal of the reports is to make it easy for you to identify either the receiver side or provider side of a transaction that has not been posted to the intercompany receivables or intercompany payables account.
The reports show the following intercompany lines:
Intercompany receivables and intercompany payables lines generated by the intercompany balancing feature
Intercompany receivables and intercompany payables lines generated for the provider and receiver of each intercompany transaction
The following are not included on the intercompany reconciliation reports:
Ledger balancing lines generated when the primary balancing segment value is in balance but either the second balancing segment or the third balancing segment is out of balance
Clearing company balancing lines
The reconciliation reports show the Entered or Transaction amount of the accounting entries booked to the intercompany receivables and payables accounts for a pair of Provider and Receiver legal entities. Since the accounted amounts may be different if the conversion rates used for the intercompany receivables and intercompany payables are different, you can choose to run the reports using an additional currency and conversion rate that will convert all amounts into a common currency for comparison.
The intercompany reconciliation process starts with running the Extract Intercompany Reconciliation Data program. Choose from a variety of parameters to determine what data will appear on your reports. For example, choose the provider legal entity and receiver legal entity you want to run reconciliation for.
Once the Extract Intercompany Reconciliation Data program has completed successfully, choose your request from the Oracle Business Intelligence Publisher (BI Publisher), BI Publishing Options list of values and view the Reconciliation Period Summary report. This report displays the intercompany receivables and intercompany payables balances in summary for a period, and any differences between them. Drill down on the hyperlinks to view the balances by source and then by journal lines. You have full drill down capabilities to the general ledger journal, subledger accounting entry and source receivables or payables transaction.
This process will extract the data to generate reports that a user can view and utilize to assist with their reconciliation.
Run the report from the Intercompany Reconciliation Task Panel and optionally schedule the report to run periodically.
Parameters
Ledger
Ledger associated with the provider organization. Exclude secondary and reporting currency ledgers.
Legal Entity
Legal entity of the provider organization.
Accounting Period
Accounting period of the provider ledger.
Ledger
Ledger associated with the receiver organization.
Legal Entity
Legal entity of the receiver organization.
Accounting Period
Accounting period of the receiver ledger.
Currency
Currency for converting the accounted amount.
Conversion Rate Type
Conversion rate type for the additional currency.
Conversion Rate Date
Conversion rate date for the additional currency.