Example Of A Reconciliation Report 
Example Of A Reconciliation Report
Reconciliation reports (report groups 5AF1, 5AF2) compare the account balances in Controlling with those in Financial Accounting.
In reconciliation report 5AF2, the system displays the values only if you have entered the group currency as the second or third local currency in the general ledger for the corresponding company code.
You have made the following assessment in CO:
Company code 1000 is credited with 11,863.82 USD, company code 2000 is debited with 11,863.82 USD. The CO document contains the following data:
Company Code |
Dr/Cr |
CoElem |
Value/Group Currency |
Partner Company Code |
1.000 |
Cr |
618.000 |
- 11,863.82 USD |
2.000 |
The system creates a corresponding totals record in the reconciliation ledger. The cost flow report is run for company code 1000.
The results list for the cost flow report displays the following values (cross-company code):
Company Code |
Partner Company Code |
Amount (Company Code Currency) |
1.000 |
2.000 |
-11.863,82 USD |
In the account determination, the G/L account 499.998 is set up for the CO-FI reconciliation (11,863.82 USD).
Reconciliation report 5AF1 displays the following data before you make the reconciliation posting:
Adjustment Account |
CO Per. One |
FI Per. One |
Variance (Absolute) |
Reconciliation Posting |
499.998 |
-11,864 USD |
-11,864 USD |
The system displays the CO cost flows (618.000 reposting) in the report using cost element 499.998, which was found by the account determination.
In the reconciliation report, the SAP R/3 System always uses the current setting for account determination for the CO column. In Financial Accounting, the system always displays the amounts that were actually posted.
Therefore, avoid changing the account determination after the reconciliation posting, and before calling up the report.
The drilldown for the adjustment account 499.998 displays all the cost elements that flow to the G/L account via the account determination.
Adjustment Account |
CO Per. One |
FI Per. One |
Variance (Absolute) |
Reconciliation Posting |
618.000 |
-11,864 USD |
0 |
-11,864 USD |
0 |
Drilldown | ||||
499.998 |
-11,864 USD |
0 |
-11,864 USD |
0 |
The CO-FI reconciliation posting results in the following values in the reconciliation report:
Adjustment Account |
CO Per. One |
FI Per. One |
Variance (Absolute) |
Reconciliation Posting |
499.998 |
-11,864 USD |
-11,864 USD |
0 |
11,864 USD |
The drilldown of the adjustment account by cost element results in the following values:
Adjustment Account |
CO Per. One |
FI Per. One |
Variance (Absolute) |
Reconciliation Posting |
499.998 |
0 |
-11,864 USD |
11,864 USD |
0 |
618.000 |
11,864 USD |
0 |
-11,864 USD |
11,864 USD |
Drilldown | ||||
499.998 |
-11,864 USD |
-11,864 USD |
0 |
11,864 USD |