I spent a few hours fine tuning my clients EBS settings.
The best way to customize the Posting is to analyze real time EBS statements , and fine tune them with search strings.
The problem with that, is that MT940 statements are posting with different transaction codes, for the same bank, but in a different country.
You can create search strings for almost any data found in the note to payee field.
For the company in Poland for example, they activated Business Area as a segment for document splitting in order to be able to generate financial statements per business areas, within a single company code. The business area's are used to report on different business area's per country.
So in order to automatically recognize the correct business area, there were exchange rates mentioned.
For example : Any time there was a CSZ exchange rate mentioned, I knew it belonged to a particular business area for CZ ,and whenever HUF exchange rate is mentions, I use another for HU country.
This is a good way for statement items which can be defined.
but for other area's where it is not clear from the note to payee field, the business area is a mandatory field for posting, so the statement posting rule just goes to a red traffic light and users can just complement the posting in FEBA.
There are usually not many issues with outgoing payments that have cleared open vendor items. As long as they have been mapped to the correct sub-account such items are usually auto-cleared in FEBA.
A bigger challenge is posting entries for a Market fund account, especially when the interest earned is not separately defined.
such entries get tagged with an automatic payment advice note.
Within FEBA, you can then change the principal amount on the payment advice, take off the interest part, post the difference to the interest earning account and clear the principal against the originial investment placed.
There are some gray area's where information is missing, so you need to park the statement on a suspense account. for example, in some cases, a investment account needs to be posted to. but there are different transactions, whith different currencies, requiring different GL Accounts.
In those cases, you sometimes have to let the user decide where the posting will go to.
You make a initial posting to sub-account (reflecting a green traffic light) and then let the user transfer post the suspense account item to the actual GL account.
Configuring Electronic Bank statements on SCN
