Banking: identify incoming payment by amount

[Former Member]

Hi All,

the case is the following: I am able to download from Web Banking the monthly statement in excel. Unfortunately the Bank Statement includes only Date, Amount, Remarks. So the only way to identify (and if possible to reconcile statement with invoices is due to amount. Bank account is not available in excel).

Is this possible to do automaitcially the reconciliaton of the statement with outstanding invoices (eg through payment wizard?)?

If yes, please tell me.

Best Regards,

Vangelis

[Former Member]

Hello Vangelis Kanellopoulos ,

If you want to reconcile on the basis of DATE and Amount then why are you not working on BTHF add-on it will solve your issue.

because we can import the bank statement in SAP through this add-on and make mapping rule for the Bank Reconciliation Statement(BRS).

Or if there are two line have same amount on the same date then you have a option for select one.

try the Add-on it will make very easy for you.

Here you need to 2 Add-on BTHF and FD(Format Definition) ,need to small configuration in company level

Thanks

Manvendra

Edited by: Manvendra Singh Niranjan on May 12, 2011 8:15 AM

[Former Member]

Hi Mavendra,

actually the reconciliation will be based upon amount and only that (I referred to date because this also in statement although not really useful).

So you do believe that only through amount is possible?

Vangelis

[Former Member]

Hello,

the all process i have done my one of client so yes we can.

But need two addon which i was explain in last reply.

Thanks

Manvendra

[Former Member]

Hi Mavendra,

the reconciliation side seems to be clear.

However do you know if it is possible to import the excel file with only the columns of Date, Amount, Remarks in Bank Statement Details by using BTHF.

Vangelis

[Former Member]

Hello Kanellopoulos ,

Steps for Bank Reconcilliation Statement

1) Select check (Install Bank & Statement Processing) in company detail form.

2) Fill the house bank informaion on the same window.

3.After that need to installed BTHF add-on from Add-on Administration window for activation of import option on Bank statement process form(in Banking Module.

4.Need to install FD (Formate Definination) from same form by use this add-on we make bank format in SAP.

After made this format then it should be assign to house bank account level.

Administration>Setup>Banking>House bank Account and select column (import file Name) then new window will appear from this window we can make new file formate after filled relavent info (format name (SAP_TEST),formate Type(Bank Statement)).

After that assign to file format(.bfp) which made by another Add-on(FormatDefination).

click on the row which was added as file format name

After select correct file name update the file format setup form

Here we assign file format to house bank account

For Mapping on the basis of Amount :-

Now here make Internal code which will link with external code(which provided by bank ) this code will use at the time of Bank Statement Summery this code also identify that which type of posting method used at the time of bank statement processing(i.e. BP from/to Bank Account, G/L Account from/to Bank, Interim Account from/to Bank Account etc.)

Adminstration>Setup>Banking>Bank Statement Process> Internal Bank Operation Code

Administration>Setup>Banking>Bank Statement Process> External Bank Operation Code

Banking>Bank Statement And external reconciliation>Bank Statement Process form(When we click on Import from file button then here we select Bank Statement file for processing

) After successfuly import the bank statement file it show as draft document.

If we want to finilize the bank statement then double click on same draft row then new window will appear

When we import bank statement in SAP then if party have any open invoive either A/P or A/R it should be reflect for making incomming or outgoing payment. Its totally depends on which type of posting method user have mapped.

After that SAP user can adjust or reconcile all bank transaction. If user double clicks on row then new window again open for adjustment.

.

Thanks

Manvendra Singh Niranjan

[Former Member]

Hi Vangelis,

I believe the best you may get is Semi-Automatic. There is not option for you to do automatic reconciliation without exact amount for credit debit pair.

Thanks,

Gordon

[Former Member]

Hi Gordon,

the exact amount per transaction is in the excel bank statement. The problem is that it is not referred the bank acoount of the Business Partner (in bank statement). I don't now if it is possible through eg payment wizard to identify and/or automatically clear outstanding invoices when the amount in invoices and in Bank Statement are exactly the same.

Vangelis

[Former Member]

That is why I suggest Semi-Automatic. You need to configure rule to do reconciliation.