web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Ledger settlement for multiple currencies that don't balance to accounting currency

(0) ShareShare
ReportReport
Posted on by 414

Hello friends,

Trying to do ledger settlement for the transactions posted between two currencies. Accounting currency is GBP & some trans has been posted in EUR. Now scenario is they don't balance to each other due exchange rate and i even seen some old posts talking about running foreign currency revaluation, but question here is it will change the value again in GBP. How can i bring to balance those and match down against each other. Please guide me through.

pastedimage1585905249283v1.png

I have the same question (0)
  • Michal Krejza Profile Picture
    on at
    RE: Ledger settlement for multiple currencies that don't balance to accounting currency

    Hello P B,

    I am not sure I understand well your query. Could you provide more details ?

    Thank you.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Ledger settlement for multiple currencies that don't balance to accounting currency

    Hi P B,

    What amounts do you try to balance and what difference do you get that does not balance?

    Have you run the foreign currency revaluation that you mentioned above?

    Best regards,

    Ludwig

  • Pratik Bhosle Profile Picture
    414 on at
    RE: Ledger settlement for multiple currencies that don't balance to accounting currency

    Hello Michal & Ludwig

    Apologies for my late response as system was unavailable during weekend. The main accounts that i plan to ledger settlement between are VAT input and output as well VAT control accounts.

    There are two different types of currency involved in these 3 accounts which i want to settle.

    Usually you find settlement under : GL > Periodic > Ledger Settlements

    Yes currency revaluation is regularly done at month end and above figures are after currency revaluation

    Question here is : How can i do settlement for different currency with multiple accounts, do they suppose to match the values ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Ledger settlement for multiple currencies that don't balance to accounting currency

    Hi PB,

    You should be able to match/settle the different amounts as long as the overall balance of the selected transactions is $0.00.

    If there is only a small (penny) difference then you cannot apply the settlement.

    Can you share a screenprint of the transactions selected in the settlement form?

    Many thanks,

    Ludwig

  • Verified answer
    Pratik Bhosle Profile Picture
    414 on at
    RE: Ledger settlement for multiple currencies that don't balance to accounting currency

    Hi Ludwig

    Thanks for the response, i figured it out it was due to wrong posting was not balancing to GBP.

    Thanks we can now close this thread.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,841

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 783 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 490 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans