#Understanding Multi-Currency Payments
When paying vendors in foreign currencies:
- Invoice is in vendor's local currency (e.g., EUR, GBP, JPY)
- You may pay in your functional currency or vendor's currency
- FX conversion happens at time of payment
- Gains/losses are recorded in GL
Light automates FX management and provides FX rate controls.
#Setting Vendor Currency Preferences
#Vendor Default Currency
-
Open a vendor
-
Navigate to Payment Preferences
-
Set Preferred Currency for payment
-
Options:
- Company currency (you pay in your currency)
- Vendor's currency (you pay in their local currency)
- Currency of invoice (pay in whatever currency bill is in)
-
Click Save
When you create a bill from this vendor, the bill defaults to their preferred currency.
#Payment Currency Selection
#Choosing Payment Currency
When executing a payment:
-
Open the bill/payment
-
Find Currency field
-
Options:
- Bill Currency: Pay in currency of the invoice (most common)
- Company Currency: Convert to your functional currency
- Other Currency: Convert to a third currency (rare)
-
Light calculates payment amount based on selection
-
Shows FX rate used
-
Click Record
#Foreign Exchange Rates
#Automatic FX Rates
Light automatically retrieves current FX rates from market data providers:
- When you select payment currency, Light fetches current mid-market rate
- Rate is shown: "1 EUR = 1.08 USD" (example)
- Payment amount is calculated using this rate
- Automatically sources to your configured rate provider (e.g., ECB, Fed, etc.)
Rates are updated throughout the day as markets open.
#Overriding FX Rates
Use a specific rate instead of market rate:
- When creating payment, find FX Rate
- Click Override Rate
- Enter the rate you want to use
- Select the source (e.g., "Customer Quote", "Internal Policy", "Spot Rate from Vendor")
- Light recalculates payment amount using your rate
- Click Apply
Override rates when:
- Vendor negotiated a specific rate
- You have a forward contract at a fixed rate
- You want to honor a rate you quoted to customer
- Company policy mandates a specific rate
#Rate Locks and Forward Contracts
For budgeting certainty, use forward contracts:
- Work with your bank or FX provider to lock a rate
- When recording payment, select the forward contract rate
- Light records the locked rate for accounting
- Settlement proceeds at locked rate regardless of market movement
Document the contract details for audit.
#Currency Conversion Process
#How Payments are Converted
When paying a bill in a different currency:
- Original Transaction: Bill created in EUR for 1,000 EUR
- FX Rate: 1 EUR = 1.08 USD (example)
- Payment Amount: 1,000 EUR × 1.08 = 1,080 USD
- Bank Processing: Your bank executes 1,080 USD payment
- GL Entry: Records both original amount (1,000 EUR) and payment (1,080 USD)
If actual received/paid amount differs from calculated (due to bank fees, rate changes at settlement):
- Light records actual amount paid
- Calculates realized gain/loss
- Posts to FX gain/loss GL account
#Multi-Currency Payment Instructions
#Payment Details with Currency Conversion
When vendors require payment in their currency:
- Open the bill (e.g., in EUR)
- Click Create Payment
- Select Payment Currency: EUR
- Light displays payment in EUR
- Your bank converts from USD to EUR at their rate
- Vendor receives EUR amount
Ensure vendor's banking details are set for international transfer (IBAN, BIC, etc.).
#Payment in Your Currency
If you prefer to always pay in your currency:
- Select Payment Currency: USD (your functional currency)
- Light converts bill amount from EUR to USD
- Vendor's bank receives USD
- Vendor's bank converts to EUR (vendor bears risk)
Use only if vendor has USD account or accepts USD.
#Batch Payments in Multiple Currencies
#Processing Mixed-Currency Batches
When paying multiple vendors in different currencies:
-
Create payment batch with bills in EUR, GBP, JPY, etc.
-
Light calculates payment for each in its currency:
- Bill 1: 1,000 EUR = 1,080 USD (at 1.08 rate)
- Bill 2: 500 GBP = 630 USD (at 1.26 rate)
- Bill 3: 100,000 JPY = 680 USD (at 147 rate)
-
Total payment: 2,390 USD (sum of conversions)
-
Approvers see both original and converted amounts
-
Execute as single batch or by currency
#Currency Consolidation
To simplify payment execution, consolidate by currency:
- Navigate to Payments
- Click Group by Currency
- Light shows total payment due in each currency
- Execute EUR payments separately, GBP separately, etc.
Reduces complexity and leverages bulk rates from banks.
#FX Gains and Losses
#Realized Gains/Losses
When payment is made at different rate than invoice:
Example:
- Bill created: 1,000 EUR at 1.08 rate = 1,080 USD (recorded)
- Payment made: 1,000 EUR at 1.06 rate = 1,060 USD (actual)
- Realized gain: 20 USD
Light automatically:
- Records actual payment of 1,060 USD
- Calculates difference (1,080 recorded - 1,060 paid = 20 gain)
- Posts 20 USD to FX Gain GL account
- Mark bill as CLEARED
#Unrealized Gains/Losses
For bills not yet paid in foreign currency:
-
Navigate to Reports > FX Exposure
-
View open bills in foreign currencies
-
Light calculates unrealized gain/loss based on current rates
-
If currencies have moved against you:
- Originally owed 1,000 EUR @ 1.08 = 1,080 USD
- Now worth 1,000 EUR @ 1.10 = 1,100 USD
- Unrealized loss: 20 USD
-
At period end, adjust GL for unrealized FX to comply with accounting standards
Light can automatically create adjusting entries for unrealized gains/losses.
#Managing FX Risk
#Hedging Strategies
For large foreign currency exposure:
-
Work with treasury/risk management
-
Options include:
- Forward Contracts: Lock exchange rate for future payment
- Currency Options: Limit downside while keeping upside
- Netting: Offset payables and receivables in same currency
- Natural Hedges: Match currency of receipts to payments
-
Document hedge relationships for accounting purposes
-
Light can track both hedged and actual payments for effectiveness testing
#FX Rate Forecasting
Prepare for currency movements:
- Navigate to Reports > FX Forecast
- View projected cash flows by currency
- Set rate scenarios (e.g., 5% appreciation/depreciation)
- See impact on cash needs and P&L
- Use for treasury planning and risk assessment
#Related Articles