Technical Articles
Electronic Bank Statement – CAMT053 and CAMT054 format
Electronic Bank Statement – CAMT053 and CAMT054 format
EBS is in provided by bank in different format like MT, CAMT, BAI, Multicash.
I will talk about CAMT054 and CAMT053 and difference between both.
- CAMT is an ISO 20022 Payment Message definition that stands for Cash Management and specifically covers Bank to Customer Cash Management reporting.
- Note: Here customer is company. E.g. Here customer word does not mean Company ABC end customer but it mean Company ABC is customer of MDFC.
Lets use below details as an example in explaination.
Company: ABC company
Bank: MDFC
End customer of ABC company: Suraj.
What is CAMT 054 format?
The CAMT.054 format provides the details of payment transaction done by end customer. E.g. Suraj made payment to company ABC account exist at MDFC bank. i.e. MDFC Bank.
CAMT054 Collective credit breakdown
CAMT054C carry credit transaction details made by Suraj to company ABC account exist at MDFC bank. It is alternate to MT910.
CAMT054D carry Debit transaction details made by Suraj to company ABC account exist at MDFC bank. It is alternate to MT900.
CAMT054B carry both Debit and credit transaction details made by Suraj to company ABC account exist at MDFC bank.
NOTE: CAMT054 does not carry information about transaction done by ABC company at MDFC bank for its vendor.
What config required in SAP to process CAMT054. What different config required for CAMT054 to MT940.
Despite CAMT054 is XML format No specific config required for CAMT054. It is SAP standard function that read XML without specific config.
Only EBS Config is required to determine Bank G\L and Sub G\L account.
In MT940 and CAMT054 different External transaction type or Bank transaction code are used so external transaction type specific to CAMT054 need to configure in EBS.
What is CAMT 053 format?
The CAMT.053 format provides the details of payment transaction done by our end customer along with details of transaction about payment made by us to our vendor using MDFC bank. E.g. Suraj made payment to company ABC account exist at MDFC bank and company ABC made payment to vendor using company bank account exist at MDFC bank.
The CAMT.053 replaces the MT940. Both are account statement.
NOTE: CAMT053 carry information about both customer incoming payment and vendor outgoing payment.
What config required in SAP to process CAMT053. What different config required for CAMT053 to MT940.
Despite CAMT053 is XML format No specific config required for CAMT053. It is SAP standard function that read XML without specific config.
Only EBS Config is required to determine Bank G\L and Sub G\L account.
In MT940 and CAMT053 different External transaction type or Bank transaction code are used so external transaction type specific to CAMT053 need to configure in EBS.
What is common difference between CAMT054 and CAMT053.
CAMT054 carry out details about customer transactions only.
CAMT053 carry out details about both customer and vendor transactions.
Bank send bank statement number in case of CAMT053 and MT940.
Bank statement number is generated by SAP in case of CAMT054.
Hi Raj,
Thanks for the heads up about CMT files. Can you share the details of the CAMT053 file features and if possible the config steps as well. I believe it will be pretty standard as MT940 configuration only the file format will be different.
Regards
Partha
Hi Partha,
CAMT053 file is XML file and format is shared by bank. This is standard XML format. In SAP you do not have to config XML format. Just change file format in RFEBKA00 program. Attached is pic of same. Config steps are same as for MT940. just bank transaction codes or external transaction types are different.
Thanks,
Raj
Thanks Raj for your valuable inputs! Can you share a sample CAMT053 file with lesser number of transactions. May be just one incoming and outgoing payment line each with OB and CB?
Regards
Partha