Reconciling TR-TM-SE and FI Balances Manually 

Use

The local currency amounts in FI and TR-TM-SE are converted independently of each other. Since the local currency amounts are converted at different summarization levels (at flow level in TR-TM-SE, for the document or account transaction figures in FI), there may be rounding differences when you compare TR-LO and FI resulting from the local currency changeover.

In FI documents, the system clears any difference between the debit and credit sides after the local currency changeover by means of an additional posting item. This posting item does not exist in TR-TM-SE. This may lead to different balances in TR-TM-SE and FI.

Procedure

There is no program that automatically reconciles the balances in the FI general ledger and TR-TM-SE.

However, you can reconcile the balances manually using the posting evaluations in TR-TM-SE and FI. You should carry out the reconciliation before and after the local currency changeover.

Clear any differences that exist before the local currency changeover.

Accordingly, any differences which exist after the local currency changeover are rounding differences resulting from the changeover. You can clear these differences manually in FI after the local currency changeover.

To reconcile the balances manually, proceed as follows:

Determining the amounts posted from the point of view of TR-TM-SE

1. Call up the posting journal for securities and carry out the reconciliation separately for each company code (Treasury ® Treasury management ® Securities ® Information system ® Report selection ® Accounting ® Posting journal).

2. In the posting log, select all the flows which have been posted to FI and which have not been reversed. To do this, set the Flows not reversed and Only flows posted in FI indicators, and deactivate the Flows reversed indicator.

3. Under Output control, set the Output a line for each flow and G/L account indicator.

4. Generate the posting journal.

5. Define a display variant with the following fields:
  1. Specify the G/L account as the primary sort variable and create a subtotal of the amount in local currency for each G/L account. For each FI account, the system displays the subtotal posted to the FI account (balance).

Determining the amounts posted from the point of view of FI

1. In the G/L balance display, display the G/L balance for each FI account in local currency.

Before the local currency changeover, this balance should match the balance calculated above for each FI account.

You can only follow this procedure if the postings to the relevant FI accounts come exclusively from TR-TM-SE.

2. If this is not the case, you can determine the balances for the postings made to the FI accounts from TR-TM-SE using other FI evaluations. One alternative is to identify the documents posted from TR-TM-SE using a specific document type. To do this, you can use the FI evaluation G/L line items (report program RFSOPO00). This evaluation gives you the balance in local currency for the selected documents per FI account. Compare these balances with the balances per FI account calculated above.