Process documentationReconciling Group G/L Accounts in the Group (Cross-System)

 

The program supports you with automatic and interactive substeps during the reconciliation of intercompany transactions of affiliated companies within the group that were posted to G/L accounts.

The program covers the following process steps:

Intercompany reconciliation distinguishes between the following processes:

  • Process 001

    Reconciliation of Open Items in General Ledger

  • Process 002

    Reconciliation of G/L Account Line Items

  • Process 003

    Reconciliation of Open Items in Accounts Receivable and Accounts Payable

Processes 001 and 003 usually relate to the reconciliation of payables and receivables within the group. Depending on your business processes, it may be useful to use processes 001 and 003 separately or to integrate the open items of one process into the other process. Both variants are supported. You can use process 002 to reconcile accounts that are not managed on an open-item basis. Usually, postings to revenue and expense accounts are reconciled in this process. For more information, see the documentation on the Customizing activities.

Prerequisites

  • In the Customizing settings for the group structure, you have assigned the company codes to the corresponding companies.

  • For relevant G/L items, a trading partner was assigned during posting, or the number of the trading partner is stored in the master data of the G/L accounts.

  • In Customizing, you have made the relevant settings:

    To make the Customizing settings for General Ledger Accounting, use the following menu path:

    • If you use classic General Ledger Accounting:

      Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation End of the navigation path

    • If you use new General Ledger Accounting:

      Start of the navigation path Financial Accounting (New) Next navigation step General Ledger Accounting (New) Next navigation step Periodic Processing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation End of the navigation path

Business Add-Ins

You can implement the following Business Add-Ins (BAdIs) to tailor the functions in the process to your needs.

  • FB_ICRC_001(Intercompany Reconciliation: Exits for G/L Open Items)

    You find this BAdI in Customizing under the following paths:

    • If you use classic Financial Accounting:

      Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Sender System Next navigation step Open Item Reconciliation Next navigation step Define Enhancements End of the navigation path.

    • If you use new Financial Accounting:

      Start of the navigation path Financial Accounting (New) Next navigation step General Ledger Accounting (New) Next navigation step Periodic Processing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Sender System Next navigation step Open Item Reconciliation Next navigation step Define Enhancements End of the navigation path.

  • FB_ICRC_002 (Intercompany Reconciliation: Exits for Open G/L Accounts)

    You find this BAdI in Customizing under the following paths:

    • If you use classic Financial Accounting:

      Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Sender System Next navigation step G/L Account Reconciliation Next navigation step Define Enhancements End of the navigation path.

    • If you use new Financial Accounting:

      Start of the navigation path Financial Accounting (New) Next navigation step General Ledger Accounting (New) Next navigation step Periodic Processing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Sender System Next navigation step G/L Account Reconciliation Next navigation step Define Enhancements End of the navigation path.

  • FB_RC_ASSIGNMENT (Reconciliation: Exits Processed During Document Assignment)

    You find this BAdI in Customizing under the following paths:

    • If you use classic Financial Accounting:

      Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Reconciliation System Next navigation step Data Assignment Next navigation step Define Enhancements End of the navigation path.

    • If you use new Financial Accounting:

      Start of the navigation path Financial Accounting (New) Next navigation step General Ledger Accounting (New) Next navigation step Periodic Processing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Reconciliation System Next navigation step Data Assignment Next navigation step Define Enhancements End of the navigation path.

  • FB_RC_PRESENTATION (User Interface for Reconciliation: Exits)

    You find this BAdI in Customizing under the following paths:

    • If you use classic Financial Accounting:

      Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Reconciliation System Next navigation step Data Reconciliation Next navigation step Define Enhancements End of the navigation path.

    • If you use new Financial Accounting:

      Start of the navigation path Financial Accounting (New) Next navigation step General Ledger Accounting (New) Next navigation step Periodic Processing Next navigation step Check/Count Next navigation step Cross-System Intercompany Reconciliation Next navigation step Preparations in the Reconciliation System Next navigation step Data Reconciliation Next navigation step Define Enhancements End of the navigation path.

Process

  1. Start the data selection.

  2. Where applicable, check the status of the data selection.

  3. Start the automatic assignment.

  4. Check the status of the reconciliation run.

  5. Reconcile the remaining items interactively.

    Alternatively, you can skip the automatic assignment in the reconciliation process if running the program with large volumes of data would take too long. In such cases, perform the automatic assignment during manual assignment instead. You make the Customizing setting for this in the activity Define Reconciliation Process Attributes (using the Selection Strategy field).

  6. You make any necessary adjustment postings.

  7. Repeat steps 1 to 6 until no further differences are found or the differences are within the tolerances dictated by your group guidelines.

Note Note

Typically, you schedule the data selection and the automatic assignment to occur in jobs at regular intervals. In the case of large volumes of data, the automatic assignment can take a relatively long time because the open items of all business relationships need to be processed. Alternatively, you can integrate the automatic assignment of items into interactive reconciliation. With interactive reconciliation, the system checks when selecting a business relationship whether data selection has been performed for one of the trading partners involved since the last automatic assignment. If this is the case, the program performs automatic assignment, but only for the data relating to the select business relationship. Consequently, the response time for selecting a business relationship the first time after data selection is slightly greater. However, you do not need to wait for a long-running process before the data can be analyzed. In most cases, the program perform the automatic assignment of the data of a single business relationship sufficiently quickly for this to be the better solution. This holds particularly true when you only want to analyze business relationships with a relatively low volume of data. You make the Customizing setting for this in the activity Define Reconciliation Process Attributes (using the Assignment Mode field).

End of the note.

Result

The intercompany transactions of the group are reconciled.