How to import camt.053 with structured remittance details for a batched incoming payment

[MikkelN]

Have a camt.053 containing an incoming payment (one NtryRef) that is batched and the belonging individual reference details are provided as structured references in TxDtls > RmtInf -> Strd segment.

When importing the camt.053 it throws an error about FEBRE overrun (there are approx. 5000 individual payments). FEBRE can hold 999 lines per KUKEY and it might be a bit confusing to have all 5000 invoice references in the Memo Line field.

Believe the XLST transformation need to be adjusted but where is the best place to store the structured references to obtain an automatic clearing?

The system is S/4HANA OP.

[Edrilan_Berisha]

Hi,

where does the bank store those data? Not in the memo line because no bank will provide the option to enter such a long string. If you talk about 5000 invoices which are paid and we assume the invoice references have 10 digits.... well this will be impossible.

For such cases you should use payment advices. So you should import the payment advice or create the payment advice in your system and refer to the payment advice in the memo line of your bank statement file.

Then, with help of an algorithm, the system should be able to match the correct payment advice.

Best,

Edrilan Berisha

SAP S/4HANA Cloud Financials Development

[CBrueckner]

Hi Edrilan,

I disagree. There are payment types like ACH CTX where the banks can transport huge amounts of structured remittance information in camt.053-statements. SAP should enable S4 to process this data and not point towards payment-advices. With payment-advices you have a parallel process, which is in most cases based on unstructured data like PDF-documents. This increases complexity and is error-prone. When you have the data perfectly structured in camt.053 you want to process this data and not establish a parallel error-prone process based on unstructured data.

Best regards
Christian

[CBrueckner]

Hi MikkelN,

what payment-type in which country are you using?

Best regards
Christian

[MikkelN]

Hi Christian,

[MikkelN]

The bank(s) provide camt.053 bank statements with a large volume of structured remittance information (in the TxDtls > RmtInf -> Strd segment) for a single payment (one NtryRef). The reference quality is very high, resulting in nearly 100% automatic matching.

In S/4, the structured clearing reference is placed in the Payment Reference field (KIDNO). This is a common practice in countries with clearing house systems that provide structured payment reference exchanges, such as Denmark and Sweden.

I am looking for a method to use the camt.053 bank statement for clearing without establishing a parallel process (as Christian mentioned in his comment) while maintaining a fair degree of user-friendliness in case reprocessing is required (which would not be the case if references are populated to FEBRE (memo line), as commented by Edrilan).