Use the Intercompany Matching Rules and Intercompany Booking Rules form to add, delete, edit, and duplicate matching and booking rules.
You can use the Intercompany Matching Report to identify intercompany variances easily as part of the Intercompany Accounts Elimination process. You need to create an intercompany matching account for each intercompany pairing. The report also has a feature to automatically book variances under a certain materiality threshold. To take advantage of this feature, you need to create an Intercompany Auto Booking account for each intercompany pairing.
Note: The Intercompany Booking and the Intercompany Matchings forms use the same header. Changes made to the Header details when updating one form will automatically be reflected in the Booking form because of the shared header.
Access the Intercompany Matching Rules form
To access the form:
- Select the Maintain module.
- Select Consolidation if prompted for a Rule Set.
- Select Intercompany Matching in the Intercompany & EQP section to open the form.
A list of the current Intercompany Matching rules is displayed.
Using the Intercompany Matching Rules form
Intercompany Matching Rules headers
The form opens with all the headers in view.
These columns for the Intercompany Matching Rules headers are available:
| Header | Value |
| Intercompany Matching | It's the name for the Intercompany Matching rule. |
| Model | It's the Model that the Intercompany Matching rule will apply to. If no Model is specified, the default Consolidation model in your system will be used. |
| Matching | This parameter is used for the booking process. It's best practice to select the Seller Rule, which will make the Buyers side equal to the Seller side. |
| Tolerance | It's the Tolerance level for the Matching report. This value represents an amount, not a percentage. |
| Dimension Breakdown | If your system has rules for Dimension Breakdown, you can choose a dimension to further break down your Intercompany Matching report by. |
| Source Audit | It's the Source Audit member for the Intercompany Matching rule. It's best practice to select Management Reporting. |
| Target Audit | The Target Audit member for the Intercompany Matching rule. It's best practice to select the IntercoAdjustment Audit member. |
| Account | Select the system matching Account member. Typically, these members are located under the System > Interco_Matching parent (tagged as #IntercompanyMatching). There needs to be one Interco Matching member for each interco pairing. These accounts must be created before creating the Matching rule. |
| Movement | It's the Movement member for the Intercompany Matching rule. It's best practice to select the Closing Movement. |
| Other Dimensions | Not currently being used. This field can be left blank. |
| Available Period | Select the Available Periods for the Intercompany Matching Rule. This is typically set to All_. |
| Input Name | Not currently being used. This field can be left blank. |
| Start Date | Specify the Date when the rule should start being applied can be specified. |
| End Date | Specify the Date when the rule should end being applied can be specified. |
Intercompany Matching Rules Details
When you select an Intercompany Matching Rule, the Details pane opens at the bottom of the screen displaying the details of the selected rule.
Each rule has four line items representing the four Accounts needed for Intercompany Elimination and Matching.
- Debit account, such as Intercompany Account Receivable
- Credit account, such as Intercompany Account Payable
- Auto Booking account
- Offset account
These columns for the rule details are available:
| Column | Value |
| Sign | Specify the sign for the Intercompany Matching Rule details. Valid values are + or -. |
| Account | Select the Account for the Intercompany Matching rule details. |
| Movement | Specify the Movement for the Intercompany Matching rule details. |
| Matching Type | Select value for the Intercompany Matching rule detail. Valid options are:
|
Access the Intercompany Booking Rules form
To access the form:
- Select the Maintain module.
- Select Consolidation if prompted for a Rule Set.
- Select Intercompany Booking in the Intercompany & EQP section to open the form.
- A list of the current Intercompany Booking rules is displayed.
Using the Intercompany Booking Rules form
Intercompany Matching Rules headers
The headers for the Intercompany Booking Rules form are the same as the headers created in the Intercompany Matching Rules form. However, in the Intercompany Booking Rules form you can set the booking details for these intercompany matching rules.
Intercompany Booking Rules Details
When you select an Intercompany Matching Rule, the Intercompany Booking Rule Details pane opens at the bottom of the screen displaying the booking details of the selected Intercompany Matching Rule.
These columns for the rule details are available:
| Column | Value |
| Sign | Specify the sign for the Intercompany Booking Rule details. Valid values are + or -. |
| Account | This Account is usually set to the automatic booking account. |
| Movement | It's the Movement for the Intercompany Booking rule detail. This field is usually set to Closing. |
| Add Intercompany | The Intercompany member for the Intercompany Booking Rule detail. |
There are two lines in the Booking Rule.
- The first has an operator of + and the Intercompany field is left blank.
- The second line has a negative (-) operator and the Intercompany field is set to No Intercompany.
