Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Payments in foreign currency best practices

(0) ShareShare
ReportReport
Posted on by 1,375

Hi,

I need to process AP and AR payments in foreign currency and many questions come up.

1. In the case of AP, I create payments in D365 and send the files to the bank. So the transactions in D365 are generated before we can see them in our bank statements. As I don't know which exchange rate the bank is going to apply I guess I can't post the payment journal until I see it in the bank and change manually the exchange rate so the amount that I will deduct from my D365 bank account match the amounts that I see on my bank statement. Can you confirm that this is the best practice in this scenario?

2. In case of customers, many times we will see the receipts in our bank statements before we create the payment proposal in D365. So we will calculate which exchange rate the bank has applied and put it manually on the "exchange rate" field under "exchange rates". This does not make much sense to me. It would make more sense that I manually inform the amount the bank has deducted and the exchange rate gets calculated accordingly. Am I understanding this correctly?

pastedimage1579689583106v2.png

When would the "secondary exchange rate" and the "cross rate" be active?

Also, why are the reporting exchange rates empty? There's a exchange rate informed in the system for that pair:

pastedimage1579689322324v1.png

  • CapsLock Profile Picture
    1,375 on at
    RE: Payments in foreign currency best practices

    Hi,

    I already found how to allow multiple currencies in a bank account.

    pastedimage1579709405280v1.png

  • CapsLock Profile Picture
    1,375 on at
    RE: Payments in foreign currency best practices

    Do you know why the exchange rates for the reporting currency (USD) are empty? The cross rates and secondary exchange rates are clear, we are not using triangulation so it's ok

    Also, is it possible then to pay an invoice in GBP from a bank account in EUR? I'm selecting an invoice in GBP and I want to settle the full amount in GBP but I'm doing that from a EUR bank account. Exchange rate between both currencies exist. When I try to post the journal I get an error saying that the currency is not allowed for the bank account but it should be because in real life that is possible.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Payments in foreign currency best practices

    Hi CapsLock,

    For No 1:

    I have seen companies that either wait for the bank confirmation and the exchange rate applied before they post the journal.

    Yet, I have also seen companies who posted the journal directly against a bridging account.

    Once the bank deducted the money the bridge account was cleared and the difference recorded as exchange rate gain / loss.

    For No 2:

    For customer payments I am used to receive a bank statement that is imported and then used to reconcile.

    In Europe, many companies use add on's, that is, third-party solutions for importing and reconciling those customer payments.

    Otherwise, it is often a quite manual process that involves a lot of steps.

    Hope this helps.

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans