Skip to Content
author's profile photo Former Member
Former Member

improving matching rate for Electronic bank statements

Hi All

I need to improve the matching rate for Electronic bank statements. The main reasons for unprocessed items are due to EFT or wire transfers. If we analyze these items in bank statements it is found as, only 1)customer name and 2)amount is given in the bank statement.No invoice number is given in bank statements ( since customer is not providing those detials).

Now business wants to apply these payments with the information availabel in the bank statements.

1.Since it doesnot have any reference numbers (invoice numbers) in the bank statements, what is the best approach to find out the open invoices of the customer and apply the payment automatically to improve the hit rate?

<b>Note</b>: Customer bank details are out of scope (since customer master data doesnt hold any kind of bank details of customer in the business)

2. By taking the consideration of above note....In which way can we find out the customer first and how to find out the open invoices and apply to the open invoices by using the amount given in bank statements?

Any help towards this is really appreciable.

Thanks all

deepa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jul 10, 2007 at 06:02 AM

    Only a user-exit can help you.

    Check RFEBBU10 with your programer guys.

    This would be based on either name or name and amount. But be aware of long run times and problems like multiple identical customer names, short payments etc.

    To have a solution through user-exit might create more problems then it solves...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 10:42 AM

    If this is a problem the business will need to expect to invest some time to see a real benefit.

    Adding the customer's bank master data is one thing that has been noted. Challenge why this cant be done. How do they expect to improve their hit rate if they have customers not supplying their account number and just providing their name. If you have customers with similar names you will struggle.

    Another area you should look into is clearing the open items. Do the customers sent remittances?

    These could either be scanned to work out what invoices are being cleared, or if the payment advices are less than 1000 items payment advises can be used if the data the customer provides can be input into an IDOC.

    This is a major project and if you want serious rewards, you will need to spend money.

    A quick win could be, asking customers to provide your account number in their payment to you. If 25% actually do it, you should be able to improve your hit rate by that amount.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2007 at 10:34 AM

    Hi,

    You can run report RFBIDE00 which will fill the customer bank details based on past transactions automatically. This will at least improve the future matching rate.

    Kind regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 12:46 PM

    Hi All

    Thank you all for your suggestions.

    <b>Hein:</b> If the program RFEBBU10 finds the customer---can it improve the hit rate by clearing open invoices??

    <b>Holdstock:</b> If customer bank details are known, we can find the customer and apply the amount to customer account , but how can we achieve the clearing of open item automatically?

    <b>Mark:</b> Ad you said, this is really a big challenge. I am also not planning to apply the name search logic..since it might create more problems.

    If bank details can be found, how can we apply to open invoices of customer?

    Customers send the remittance advices to business. How can we attach these kinds of remittance advices ( hard copy, soft copy etc..in different formats) to SAP in the form IDOC or store it in tables? And how can we link it to bank statements or in any other way to match them automatically?

    I am really interested to investigate the process of remittance advicesÂ…. Can you PLEASE explain me the process mark?

    I really appreciate your help.

    Thanks all for your time and suggestions.

    Any other suggestions will be really appreciable.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2007 at 08:00 PM

    Hi All,

    The Electronic Bank Statement program RFEBKA00 includes for the SWIFT MT940 a user-exit.

    This user-exit is located direct after the point that the file is loaded.

    At this point the raw-table contains the complete file and you could enrich the data with extra data.

    Example:

    One of the items you could use is the bank number, find the customer, (one banknumber wil mostly lead to one customer), find the open items and check for instance the amount.

    When succes i always place found data at the start of the :86: record.

    Reason for this is improvement in performance.

    You see at this point a lot can be done to improve the data-quality.

    Regards,

    Wim Rusman

    Pl.Senior Developer / SAP NL

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.