Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Wrong dates in Bank Re...
Small and medium business | Business Central, N...
Suggested answer

Wrong dates in Bank Reconcilliation

(1) ShareShare
ReportReport
Posted on by Dv Acuma 34

Hi All,

As the title suggest, I'm getting the wrong dates when uploading my bank statement into the bank reconciliation pane. I already checked the values in the data exchange definition and the date format is the same with my bank statement. Basically, what is happening is, whenever I upload a bank statement the system is automatically changing the month portion of the date to January. For example, I uploaded a bank statement for the month of February, the system is registering it as January. Days and year are correct, it's just the month that have an issue. 

  • Suggested answer
    Community member Profile Picture
    Community member 6 on at
    Wrong dates in Bank Reconcilliation
    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.
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Wrong dates in Bank Reconcilliation

    There is a region on the Bank Account in BC. Please make sure that this field indicates US.

    You might also provide a screen shot of the data definition of the bank import.

  • Dv Acuma Profile Picture
    Dv Acuma 34 on at
    RE: Wrong dates in Bank Reconcilliation

    Hi!

    I am positive the date format in BC and the one with the Bank statement are the same. I'm using the US region on BC, and the date format on my bank statement is MM/DD/YYYY.

    Kind regards,

    Lawrence

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Wrong dates in Bank Reconcilliation

    Hi,

    Please check the file you are importing has the same Date format, as your system does. and then try to import.

    Thanks.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans