Bank statement and FI-CA reconciliation

[Former Member]

Hi gurus,

I need to upload manually a bank statement and make the integration with FI-CA.

Could someone explain me the process and configuration needed for ?

Thanks in advance

Loutre.

[oliviawalsh · Accepted solution]

Hello,

Some general comments:

The electronic bank statement (TA FF.5) which allows to import

certain bank statement formats and to post these. SAP supports

general formats like SWIFT MT940, Multi Cash (see note 36833)

and also a lot of country specific formats.

The manual bank statement (TA FF67) is used to enter the bank statement

data manually via dynpro.

As the transaction FF67 contains no front end

controls it can be called via batch. Therefore it is necessary

to write programs (customer programs) which create

the BDC data. It is also possible to write a program which creates files in

MultiCash/Swift format. This files can be imported via FF.5 like

other electronic bank statements. The situation is the same as

for manual bank statement: You need to develop it by your own.

there are 2 possibilities:

1.

You can create a program which creates batch input sessions for

transaction FF67. Use transaction SHDB to record the transaction

in order to see program, dynpro and field names. It helps a lot

creating such program

2.

You can also create a program which creates a files in the Multi Cash

format (see note 36833 for Mutli Cash format).

Hope this information is helpful for you.

Regards

Olivia

[Former Member]

Hi Olivia,

Thank you for your answer but if I use contract account receivables, how i can reconcile the bank statement information with the incoming payment ? I need to do the bank account clarification.

Regards,

Loutre

[Former Member]

Since you want to manually upload the bank statement, use transaction FB50 to do the same.

Then use transaction f-03 to manually clear the items.

[former_member213733]

Hi ,

First of all i hope you are clear with the concept of Incoming , otugoing and main bank account that we need to create 3 or more diffrent bank accounts for reconcilliation purpose .

the case here is that you cant to do a manual statement upload then in that case you will have to take care of following things .

How is the information transferred from FICA to FICO means along with the reconcilliation key what else information are you passing on to FI in the documents .

Secondly in the bank statement are you getting the reconcilliation key ??? or what information are you getting in the bank statement ???

because the integration of FI and FICA is the reco key and it becomes very crucial for you to have the same in the bank statement .

thirdly , Use the manual reconcillaiton functionality provided in FI for reconciling the same , where in you will have to configure the manual bank statement functionality and by using the T code ff67 you can reconcile it .

Hope this suffices the prupose .

Do revert back in case of any other queries .

cheers ,

dewang

[Former Member]

Hi,

I'll like to implement the same things in FI-CA for Electronic bank statement.

Can you give me more details/ steps as how this can be accomplished in FI-CA.

And, how does it different from FI bank stmt (FF_5)?

Many Thanks.

Regards

Chew Lin