Finance | Project Operations, Human Resources, ...

Incorrect information in yearend closing and trial balance

(3) Share

Report

Posted on by J_Lee

1,342

During the FY2024 year-end closing process, we noted that the closing journal shows a transaction amount of 1,301,202.30 for accounts 13040000. However, this amount does not reconcile with the corresponding balances shown in the Trial Balance at 2024-12-31.

Could you please advise on the possible cause of this discrepancy and what may be incorrect?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (9)

Answers (0)

Sort by

André Arnaud de Cal... 305,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi J Lee,

I think to understand there is another amount as opening balance compared to the year end amount actual posted. I don't know what exactly you retrieved in your Excel sheet and if this is correct or complete. It looks like there are multiple lines for the same ledger account. Is this linked to a specific dimension value combination? Assuming the amount is correct, then one of the reason can be that there are new postings in 2024 after when the opening balance was created.

Was this reply helpful? Yes No
J_Lee 1,342 on at

Like (1)

Report
Copy link

Link copied!

The excel figure is the journal entries in 2024 year-end closing.

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 3,450 on at

Like (1)

Report
Copy link

Link copied!
Hello,

When you run the closing process in D365FO, it takes a snapshot of the balances at that moment.
Recommendation:

Export the 2024 transactions (even just for the main account) and check if the closing / opening balance is consistent.

If not, run the closing process again to realign the balances.

If the D365FO balances are consistent, the issue is in your Excel file.

Thank you,
Giorgio

Was this reply helpful? Yes No
André Arnaud de Cal... 305,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi J. Lee,

It is impossible to know from these screenshots what happened in your environment. Do you have a partner that can assist you by looking at the details in your environment?

Was this reply helpful? Yes No
J_Lee 1,342 on at

Like (2)

Report
Copy link

Link copied!

Hi, Aoo,

I found it is caused by the closing ledger adjustment (i.e. general ledger > period Close > closing period adjustments).

My users inputted the adjustment in 31 DEC, 2024 and then the 2025 opening balance was changed.

Please advise why the TB in 2024 didn't reflect this closing ledger adjustment.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi J Lee,

After using the closing sheet, the Opening balances needs to be updated or regenerated again. This is not an automatic process as the application is not aware if all adjustments or other journals are finalized.

Was this reply helpful? Yes No
J_Lee 1,342 on at

Like (2)

Report
Copy link

Link copied!

Hi All.

As i exported the general ledger entries via DMF, i failed to find this closing sheet entries, please advise where and how to extract the closing sheet.

Since i want to verify its calculation.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi J Lee,

Can you tell which exact data entity you have used?

Was this reply helpful? Yes No
J_Lee 1,342 on at

Like (1)

Report
Copy link

Link copied!

Hi Andre,

The closing adjustment ledger was inputted via General Ledger > Period Close > Closing period adjustments.

Its data source is GeneralJournalEntry

Thanks

Jessica

Was this reply helpful? Yes No