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.
Hello P B,
I am not sure I understand well your query. Could you provide more details ?
Thank you.
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
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 ?
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,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,841
André Arnaud de Cal... 783 Super User 2025 Season 2
Sohaib Cheema 490 User Group Leader