Finance | Project Operations, Human Resources, ...

General Journal Line Entry Excel Upload is changing the date of my data

(3) Share

Report

Posted on by EL-29050242-0

Hi,

I am manually uploading general journal entries via excel and it is unwilling changing the dates on my spreadsheet.

I have no idea why it is forcing dates to either January 1st of 2024 or January 31st of 2024.

Any solution for this?

Thank you

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Hana Xue Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,
Can you check if the date format is correct, you can refer to old threads similar to this question. Using Excel Upload to D365 - error in copy and paste dates (dynamics.com)
Best Regards,
Hana

Was this reply helpful? Yes No
EL-29050242-0 46 on at

Like (0)

Report
Copy link

Link copied!

Hi Hana,

Thank you for responding.

I have done it multiple times but it started to be problematic this time only.

Also not all but first few rows are ok but it gets changed after 5th row and they are all in same format.

Was this reply helpful? Yes No
Community member 4 on at

Like (1)

Report
Copy link

Link copied!

Double-check that the dates you're entering in the Excel cells are correctly formatted. Ensure that the dates are entered in the same format as the cell's formatting. For example, if the cell format is mm/dd/yyyy, make sure you enter the date in that format. <slope game>

Was this reply helpful? Yes No
EL-29050242-0 46 on at

Like (0)

Report
Copy link

Link copied!

First 4 rows are recognized correctly, and also using the date format embedded in the spreadsheet is identical to what I did.

It is so strange how only after row 4, the dates are forced to change as Jan 31st.

Was this reply helpful? Yes No
CU08080249-4 2 on at

Like (0)

Report
Copy link

Link copied!

Ensure the date format in your Excel spreadsheet matches the format required by your accounting system. Check if there are any default date settings or mapping configurations in your journal entry upload process that might be overriding the dates from your spreadsheet. Verify that the dates in your spreadsheet are correctly formatted and not being converted incorrectly by Excel. Additionally, review the upload template or guidelines provided by your accounting software to ensure compliance. If the issue persists, consider reaching out to the software's support team for further assistance to identify and resolve the date formatting issue. (Source)

Was this reply helpful? Yes No

Join the conversation

Community site session details

General Journal Line Entry Excel Upload is changing the date of my data

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

General Journal Line Entry Excel Upload is changing the date of my data

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates