Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Understanding CAMT files
Finance forum
Suggested answer

Understanding CAMT files

Posted on by 97

Good morning community,

I have a broader question around CAMT files, more specifically CAMT.053 & CAMT.054.

In summary, the CAMT.053 is the previous day bank statement and provides detailed information on all entries booked to the account for the previous day. On the other hand, the camt.054 – Bank to Customer Debit / Credit Notification, provides the customer with specific account debit and account credit transactions. My questions are:

  • Do you think that by importing only the bank statement (053), the information stored in it would be enough to register all customer/vendor transactions? I see that in the structure of the 053, there are XML tags to identify bank transaction codes, payment references etc.
  • Why would I need the CAMT.054 for? What additional information would it bring?
  • Are there cases where the 054 somehow "complements" the 053, e.g. a summary entry is registered in 053 but the details are stored in the 054?

Many thanks for your answers,

Peter

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Understanding CAMT files

    Hi Peter,

    I think the camt.053 format should be ok to do that.

    This format is also supported by the MS standard ER file formats that we have available.

    Yet, I think the main issue is with your banking institutions and the file format they provide you with.

    Do you have a contact into your banking institution and can find out what file formats they usually deliver to you?

    Best regards,

    Ludwig

  • PeterKRB Profile Picture
    PeterKRB 97 on at
    RE: Understanding CAMT files

    Thank you Ludwig,

    By the first question I mean the following: is the import of CAMT.053 enough to record all the incoming/outgoing transactions of a bank account that I can later relate to open cust/vend transactions? If it is, why would I import the CAMT.054 for?

    I will have a look at your link, thanks!

    Peter

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Understanding CAMT files

    Hello Peter,

    For No1: Can you elaborate what you mean by saying that you want to register all customer/vendor transactions?

    For the other questions, I would recommend having a look at this website:

    www.hettwer-beratung.de/.../

    It's available in German language only but you can make use of online translation tools to get the information in your language.

    It provides a lot of details and background information.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans