Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

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

Posted on by 410

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

  • Verified answer
    Pratik Bhosle Profile Picture
    Pratik Bhosle 410 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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard 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

  • Pratik Bhosle Profile Picture
    Pratik Bhosle 410 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
    Ludwig Reinhard 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

  • 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.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans