Handling Foreign Currency Invoices in Dynamics 365 – More Than Just an Exchange Rate
Running a business on an international scale inherently involves operations in foreign currencies. However, as soon as an invoice is issued in a currency other than the entity’s accounting currency, a whole series of additional tax, accounting, and system-related implications arise.
The handling of foreign currency invoices in Dynamics 365 Finance is an area that particularly highlights the complexity of local requirements and the challenge of maintaining data consistency in a multi-country environment.
One Document, Multiple Conversion Points
A foreign currency invoice is not converted “once and for all.” Depending on the transaction type and system configuration, Dynamics 365 may apply different reference dates for the exchange rate, such as the invoice date, posting date, tax point, or VAT register date.
In practice, Poland operates with a dual exchange rate approach. For Value Added Tax purposes, the exchange rate published by the National Bank of Poland from the day preceding the tax point is applied. In contrast, for accounting purposes, the method for determining the rate is derived from the Polish Accounting Act and the adopted accounting policy.
As a result, the same document may be converted according to different tax and accounting rules, leading to the application of different exchange rates.
From a system perspective, this requires a conscious approach to configuration. In Dynamics 365, this can be managed using features such as “Fixed exchange rate” or controlled exchange rate overrides at the document level.
W praktyce w Polsce mamy do czynienia z tzw. dualizmem kursowym. Dla celów VAT stosuje się kurs NBP z dnia poprzedzającego powstanie obowiązku podatkowego, natomiast w rachunkowości sposób ustalenia kursu wynika z ustawy o rachunkowości i przyjętej polityki rachunkowości.
W efekcie ten sam dokument może być przeliczany według różnych zasad podatkowych i księgowych, co przekłada się na zastosowanie różnych kursów.
Z punktu widzenia systemu wymaga to świadomego podejścia do konfiguracji. W Dynamics 365 można w tym celu wykorzystać m.in. funkcję „Fixed exchange rate” lub kontrolowane nadpisanie kursu na poziomie dokumentu.
Invoice Corrections: Local vs. Global Approach
The correction of a foreign currency invoice is an area where discrepancies between system logic and local requirements most frequently arise.
In Dynamics 365, where standard parameters often stem from IFRS practice, a correction is sometimes treated as a separate transaction. In the default configuration, this leads to the application of the current rate (from the date the correcting document was issued).
In the Polish reality, the approach is different. A correction most often refers to a transaction already completed and should maintain the historical exchange rate from the original invoice. Exceptions occur, among others, in the case of corrections covering multiple transactions, periodic settlements, or summary invoices.
Thanks to dedicated Polish localization parameters in Dynamics 365, the system allows for the automatic linking of the correction rate to the original invoice rate. Such a configuration reduces the risk of incorrectly applying the current rate and allows for consistent Value Added Tax and Corporate Tax reporting without the need for manual recalculations.
Exchange Rate Differences and Foreign Currency Revaluation
Proper handling of foreign currency invoices in Dynamics 365 involves not only the moment of document posting but also the precise settlement of exchange rate differences.
In Dynamics 365, this process is supported by the Foreign currency revaluation function, which enables the revaluation of receivables and payables, bank accounts, and the general ledger in line with the configured rules. The system automates this process in two key areas:
Realized exchange rate differences – these arise at the time of payment settlement in the Accounts Payable (AP) and Accounts Receivable (AR) modules. Dynamics 365 compares the rate used when posting the document with the rate from the payment date, eliminating the need for manual calculations.
Balance sheet valuation – this applies to open positions in foreign currencies and is carried out at the end of the period. It covers, among other things, receivables and payables (AP/AR) as well as bank account balances, updating their value in line with the system configuration.
When performed correctly, valuation ensures a reliable reflection of the value of assets and liabilities in the financial statement.
Crucial to this is the proper planning of the timing and frequency of valuation, as well as the configuration of exchange difference accounts. Before execution, one should ensure that open positions have been correctly settled to avoid double conversions and maintain data reliability.
Summary
Properly handling foreign currency invoices in Dynamics 365 is a subject much broader than simply selecting the right exchange rate. It is a process that must cohesively link the timing of revenue and cost recognition, local tax reporting rules (Value Added Tax/Corporate Tax), and periodic foreign currency revaluation.
In international organizations, where local regulations often clash with group standards (e.g., IFRS), accurately reflecting these rules in the system configuration becomes crucial.
A well-designed conversion model in Dynamics 365 helps avoid discrepancies between modules and reports, while simultaneously ensuring the transparency necessary for group reporting.
Ultimately, it is the proper integration of system logic with accounting practice that determines the quality of the entire financial process.
Do you want your foreign currency settlements in D365 to be fully compliant with local regulations?
At 7F, we support companies in building processes ranging from automated exchange rate imports to handling complex corrections and group reporting. Contact us to find out how we can streamline your finances.
Klaudia Gąszcz
D365 F&O Consultant
