bank reconcilation sheet date field is one day different with bank statements

(2) Share

Report

Posted on by LIN LIN

109

I have manually created a bank statement as following in May 1st.

But when I open the reconcilation work sheet the book date changed as April 30th. Any one knows whether it's the standard behaviour? And if I need to change this behaviour how should I configure the setup.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Arvind Bharti 1,015 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you check the timing of you lines it shows 12 AM , can you change to 11 PM?

Also check when you are creating your statement what is the end balance date and time.

Was this reply helpful? Yes No
Verified answer

Assisted by AI

Saif Ali Sabri 2,791 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
This is standard behaviour in many Dynamics 365 Finance & Operations bank reconciliation scenarios and is almost always caused by date/time conversion (UTC vs local time) rather than the reconciliation logic itself.
Why you see May 1 → April 30
Bank reconciliation uses DateTime internally (stored in UTC). If your statement is created at 00:00 (midnight) in your local time zone, it may be converted to UTC and shift back to the previous day, resulting in:

Local: May 1, 00:00

UTC: April 30, 18:00 / 19:00 (example depending on timezone)

Display in worksheet: April 30

So the “one day difference” is typically a time zone boundary issue, not a data entry error.

What to check (important)
1. Statement Date vs Statement End Date/Time
When creating the bank statement:

Check Statement Date

Check Statement End Date/Time (if available)

If the end time is defaulting to 12:00 AM, it can cause the shift

✔ Best practice: set end time to end of day (23:59:59)

2. User Time Zone setup
Go to:

System administration > Users > Users

Check the user’s Time zone

If users in different time zones are involved, this issue becomes more visible.

3. Bank statement creation method
If statement is:

Manually created → ensure date is entered as date-only (no time component)

Imported → check whether the import file includes a timestamp or gets interpreted as DateTime

How to fix / prevent it
Option 1 (most common fix)
Set statement time explicitly to end of day:

Use 23:59:59 instead of default 00:00

This prevents UTC rollback to previous date.

Option 2
Ensure the field is treated as Date only (not DateTime) in the process you use:

Some customizations / integrations pass DateTime unnecessarily

Adjust integration to pass date-only values

Option 3 (configuration check)
If using bank statement import or reconciliation configuration:

Review Cash and bank management parameters

Ensure no customization is converting statement dates to UTC DateTime improperly

Summary
Yes, this is standard behavior caused by UTC conversion of midnight timestamps.
Fix is typically achieved by ensuring the statement uses end-of-day time (23:59:59) or eliminating DateTime usage in favor of pure Date fields.

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 3,530 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

I afraid that is not possible. Are you sure that you are looking the bank reconciliation from the correct bank statement.

Select your bank statement and click on "Reconciliation in worksheet" from here.

You can switch between "Unmatched" and "Matched", you will find the transaction recorded from the bank statement with the same booking date:

Thank you,

Giorgio

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 15,225 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @LIN LIN,

This normally happens because of date/time and time zone conversion.
If the bank statement line is created with May 1 at 12:00 AM / 00:00, D365 can convert the DateTime value to UTC and it may become April 30, depending on the user/company time zone. Then the reconciliation worksheet can show the previous date as the booking date.

So it is not usually controlled by a bank reconciliation setup parameter. It is more related to how the statement date/time is stored and displayed.

Microsoft Learn references:
https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/organization-administration/tasks/set-users-preferred-time-zone

Was this reply helpful? Yes No