FI Funds Management Payment Matching 

Purpose

This procedure allows you to compare the changes in your bank and bank clearing accounts (documents in which commitment items with financial transaction 90 or 80 (bank) were posted to) with the updated payments in Fund Management. Transfers within these accounts are not considered. The graphic illustrates this principle:

Payment matching checks the system as to whether all financial accounting payment documents (FI) have been updated with the corresponding amount and posting date in Funds Management (FM).

A comparison of this data is only necessary if you are working on a payment basis and want to ensure an exact correspondence between financial accounting and Funds Management.

In order to execute the payment matching, several Programs are available which compare the data on a totals record and line item level.

Prerequisites

You have program RFFMS200 for payment transfer (payment transfer with invoice reference) and program RFFMS201 (payment transfer without invoice reference) available for this. If the period-end closing was activated in Customizing, selection screen of program RFFMS201 will also automatically appear when you start program RFFMS200.

For more information about these programs, refer to the program documentation and Transferring payments.

You must also consider that the financial accounting data and Funds Management data only match if other conditions, with regard to system setting and user activities, have been fulfilled. Otherwise, variances will occur which the programs will display accordingly. For more information, read Prerequisites Payment Transfer.

Process Flow

The payment matching process flow is described in the following if you are executing it for the first time. After that, you can decide which programs you want to use regularly for matching data.

  1. Before carrying out a payment matching, you must ensure that the totals and line items match in Financial Accounting and in Funds Management. To do this execute programs SAPF070 (FI) and RFFMRC04 (FM).

    2. Report SAPF070 checks whether the FI line items match the FI totals items (compare tables BSEG and GLT0).

    Report RFFMRC04 checks whether the FM totals items match the FM line items (compare tables FMIT and FMIFIIT).

  2. If this is the case and the above prerequisites are fulfilled, execute program RFFMRC06 that compares the data at totals record level.

    3. If there is no error indicated for the totals, you can assume that the data matches. A further matching at line item level is not necessary.

  3. If errors occur, execute program RFFMRC07 for matching at line item level. This program begins with financial accounting data (from table BSEG) and compares this data with the Funds Management data. The result of the matching is written in a work list that can be displayed using program RFFMSD07.
  4. If you are not able to find all the errors and analyze them after running the program, you must execute program RFFMRC08 that compares the Funds Management data against the Financial Accounting data. Because the program begins with Funds Management data (table FMFIIT), errors can be found which were not discovered by RFFMRC07. The result of the matching is written in a work list that can be displayed using program RFFMSD07.
  5. In order to analyze errors displayed, you can use the program RFFMS007 to activate the analysis of the FM documents in the FI document display (transaction FB03). You can display per document which commitment items and which financial transactions were addressed when posting and from which assignments the FM account assignments were derived.

Payment Matching