Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Transaction date on im...
Small and medium business | Business Central, N...
Suggested answer

Transaction date on imported bank statement

(1) ShareShare
ReportReport
Posted on by olegvi 779

Hi,

I created the format for importing the bank statement using Data Exchange Definitions. It generally works to import the bank statement using csv file. However, no matter what I do, the date comes in as January of 2021. The actual date is recognized but the month is not. 

Has anybody seeing that issue before?

pastedimage1639671529660v1.png

The actual data looks like that:

pastedimage1639671598754v2.png

  • Community member Profile Picture
    Community member 6 on at
    Transaction date on imported bank statement
    I was having this same issue.  Our company opened a second checking account in October, so I had to create the bank statement import template.  I followed the existing template, tweaking it as needed to work with the csv file was I able to get from the new bank.  It was working fine until I got to February of a new year.  No matter what I did the date kept pulling in as January.  I check everything people suggested and everything looked fine.  I then compared the old template with my new template and the only thing I could see different was the format on the old bank account template was M/d/yyyy and my new bank account was m/d/yyyy.  I made that minor change from a small 'm" to a capital "M" in my date format and that fixed the problem.
  • SchaferN2019 Profile Picture
    SchaferN2019 30 on at
    RE: Transaction date on imported bank statement

    Andy - this looks like it would work when you have 3/1/2022 but what happens when the file has 3/11/2022?  Or when you go into 2 digit months - how does this format work?  I am troubleshooting the same issue and I have MM/dd/yyyy and I am getting the same error

  • Suggested answer
    olegvi Profile Picture
    olegvi 779 on at
    RE: Transaction date on imported bank statement

    Thank you all, it appeared that the date format is case sensitive: MM/dd/yyyy. Who would've thought?!

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Transaction date on imported bank statement

    Oleg,

    Make sure the Date, Data Type for format is set correctly, below. as for the field mapping, you are pointing the Date to Field ID 5, Transaction Date, yes?

    pastedimage1641246172331v1.png

    Thanks,

    Steve

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Transaction date on imported bank statement

    Can you try changing the date format to M/d/yyyy?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,099 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,880 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans