Account Modification in the Electronic Bank Statement

[Former Member]

Hi Gurus,

I need your advice on this question related to Electronic Bank statement set-up in ECC. I am new to this area of Finance. Our existing set-up for the Bank statement has all incoming ACH payments being posted to the Bank sub-ledger account 10011 defined as ACH-in account. We have a new requirement that for incoming customer ACH payments, the payment should post to new GL account 10012 and all other ACH-in payments should keep on getting posted to the old ACH-in account 10011. Our payment file is in the Idoc format.

I have read many forum questions and SAP online help as well. What I understood so far is that the Account modification in the Assign accounts to Account symbol might be the place to accomodate this request but not sure if my understanding is correct and how should we do this set-up.

I would be thankful if you can guide me with this issue.

Thanks,

Best Regards,

Shalu

[ivo_postma]

Hi there,

Your question is quite confusing; I think you are mixing up payments and receipts; payment files and bank statement.

I am assuming you are talking about customer receipts here, which are initiated by the customer itself (no direct debit) collected on a dedicated collections (bank) account.

Second assumption is that the company receives an electronic end of day bank statement from the bank in the form of an MT940, containing all the receipts on the bank account for the previous day.

In the old situation ALL mutations on this bank account were auto-posted to a single GL account. This was easy; just post all items (using UNALLOCATED)  to a single posting rule and asign a GL account to this posting rule.

In the new situation we need to post certain items to GL account X, other items to GL account Y.

Really the first thing you need to do now is analyse the bank statements and look if you can find a structural difference between the two types of receipts. You should first look if you can discern the two types by Bank Transaction Codes (i.e. NMSC, NTRF etc.). If this is the case, you can assign two BTC codes to two posting rules and your issue is solved.

If you cannot discern the two types by BTC code, you need to analyse if you can discern the two types of receipts by the text fields in the MT940 (i.e. field 61 or 86). If you can discern by static text you can setup a simple search string, looking for the text and assigning a posting rule from there.

If you cannot discern by static text, but only by dynamic text (i.e. invoice number), you need to use one of the algorithms to let SAP analyse the items and try to determine which rule is appropriate.

So depending on your analysis of the bank statement, different solutions should be implemented.

[Former Member]

Hi Gurus,

Can someone please help me with this issue?

Thanks,

Best Regards,

Shalu