multi-currency vendor invoice: which FX rate date to use when posting
Chooses the FX rate date for multi-currency vendor invoices. Use when posting foreign-currency invoices and the rate date affects the booked amount. Not for FX gain/loss recognition.
TL;DR
When posting a multi-currency vendor invoice, the FX rate date determines the booked functional-currency amount: common choices are the invoice date, the goods-receipt date, or the posting date. Your accounting policy picks one; the key is consistency and matching what your ERP expects. Most ERPs default to the posting date but allow override to the invoice date. Document the policy per entity, configure the ERP default to match, and handle the resulting FX differences at payment time through the standard gain/loss accounts. Inconsistent rate dates across invoices create reconciliation noise that compounds monthly.
The query
multi-currency vendor invoice: which FX rate date to use when postingUse this when
- Choosing the FX rate date for foreign vendor invoices
- Booked amounts varying with rate date choice
- Configuring ERP FX defaults for AP
Not for
- FX gain/loss on settlement (separate accounting)
- Hedging or forward contracts (treasury topic)
Steps
Check your accounting policy for the prescribed rate date. Expected output: The choice is policy, not preference.
Confirm the ERP's default rate date and override behavior. Expected output: System behavior matches policy or is deliberately overridden.
Post with the policy rate date consistently across invoices. Expected output: Booked amounts are comparable.
Reconcile FX differences at payment against the gain/loss accounts. Expected output: Differences land where they belong.
Document the policy per entity for auditors. Expected output: The choice is defensible and consistent.
Variant phrasings
multi-currency invoice FX rate date
which exchange rate date vendor invoice posting
FX rate invoice date vs posting date
Root cause
The rate date matters because FX moves daily and the booked amount is rate times foreign amount; different dates give different books. Policy consistency is the real requirement: auditors care less which date you chose than that you chose it deliberately and applied it uniformly.
Edge cases
- Month-end close may require revaluation at the close rate regardless of posting choice
- Hyperinflationary currencies have special rules; involve your accountants
Provenance
Resolved from the public thread: https://vectle.com/posts/pst_KlK-BgsqKhByl8iUcvL81Q