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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Exchange Rate calculation

(5) ShareShare
ReportReport
Posted on by 10
I am busy with an audit and the auditors have selected a sample of realised / unrealised exchange rate gains/ losses and require the calculation thereof. Is there a way to see how these were calculated as currently all I could see was the journal?
I have the same question (0)
  • Suggested answer
    Ahmad Subhani Profile Picture
    585 on at

    Hi,

    To review how the amounts were calculated:

    1. Go to: Currency Exchange Rate Adjustments or the "Adjust Exchange Rates" batch job used.

    2. Open the related Posted General Journal or Detailed Ledger Entries.

    3. For detailed breakdown:

      1. Use the "Currency - Adjust Exchange Rates" report if it was run.

      2. Or check "G/L Entries" or "Customer/Vendor Ledger Entries" filtered by the currency and adjustment posting date.
    4. If needed, re-run the batch job in a test company with the same parameters to simulate the calculation logic.

     

    I am attaching the link under from which you can drive the Results.

     

    Mark the Answer as Verified if this is Helpful.
     

  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,641 Super User 2025 Season 2 on at
    Hello,
     
    You will need to trace the original foreign currency transactions, compare the exchange rates used at the transaction, settlement, and reporting dates, and review any revaluation entries.
     
    While journal entries show the accounting impact, the actual calculations are often found in the transaction history, audit trail, or foreign currency reports within your accounting system.
     
    If those aren’t available, you can manually recalculate the gains or losses using the relevant exchange rates and amounts.
  • Suggested answer
    Mansi Soni Profile Picture
    8,933 Super User 2025 Season 2 on at
    Hello,

    Yes, in Business Central, realized and unrealized exchange rate gains/losses are typically posted through the Adjust Exchange Rates batch job, and while the journals show the entries, the actual calculation details are not stored directly. However, you can run the Adjust Exchange Rates report in simulation mode for the same date range and filters. This will recreate the calculation logic and show how gains/losses were determined, helping you match the posted entries with the underlying currency revaluation logic for audit purposes.

    Hope this answer will help you!

    Regards,
    Mansi Soni
  • Suggested answer
    YUN ZHU Profile Picture
    96,041 Super User 2025 Season 2 on at
  • Gerardo Rentería García Profile Picture
    25,398 Most Valuable Professional on at

    Hi, good day

    You can rely on third-party solutions that improve the reporting of this process.

    Business Apps – Microsoft AppSource

    Best Regards
    Gerardo

  • Suggested answer
    Sohail Ahmed Profile Picture
    11,156 Super User 2025 Season 2 on at
    Hi! Yes, in Business Central, the actual calculation behind realized and unrealized exchange rate gains/losses isn't shown directly in the journal, but you can trace it with these steps:
     
    1. Check the Currency Exchange Rates
    Go to Currency Exchange Rates (Search > Currencies > Exchange Rates) to find the rate used on the posting date.
     
     
    2. Open the Detailed Ledger Entries
    For realized gains/losses, go to the Customer/Vendor Ledger Entries, and click Navigate > Entries > Detailed Ledger Entries. This will show the exchange rate differences and the applied amounts.
     
     
    3. Unrealized Gains/Losses
    If it’s unrealized, go to the General Ledger Entries and filter for entries posted with the description like "Unrealized Gain" or "Unrealized Loss", typically posted from the Adjust Exchange Rates batch job.
     
     
    4. Audit Trail
    Use Navigate on the G/L entry to find linked subledger details — invoice, payment, rate used — and re-perform the calculation manually using the original transaction amount and rate vs. adjusted rate.
     
     
     
    Unfortunately, BC doesn't store a separate calculation log — you have to reconstruct it using posted entries and rate tables.
     
    ✅ Mark this answer as verified if it helps 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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,585

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 780 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 712 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans