Exchange Gain / Loss in ERPNext: Managing Currency Differences in Payments
In ERPNext you can create transactions in foreign currency. When you do, the system records the current exchange rate between the customer’s or supplier’s currency and your company’s base currency. Because exchange rates fluctuate, you might receive payment from a client at a rate different from the one on the Sales or Purchase Invoice leaving a difference to account for. This page explains how to manage that difference in the payment entry.
Add Expense Account
To handle the currency difference, create an account called Exchange Gain/Loss. This account is generally created on the expense side of the Profit & Loss statement, though you can place it under another group if your accounting requirements call for it.
Book Payment Entry
When you book the Payment Entry against the invoice, ERPNext compares the exchange rate at payment with the rate on the original invoice. It then automatically calculates the exchange gain or loss and posts it to the Exchange Gain/Loss account so the difference arising purely from the rate change is recorded correctly, separate from the actual amount received.
NOTE
The gain or loss comes only from the rate change between invoice and payment not from the customer paying a different amount. Booking it to the Exchange Gain/Loss account keeps this currency effect cleanly separated from your real income and expenses.
TIP
Set up the Exchange Gain/Loss account before you start booking foreign-currency payments, so ERPNext has somewhere to post the difference automatically. Without it in place, you’d be left adjusting rate differences by hand on every cross-currency settlement.
Related Topics
- Payment Entry
- Sales Invoice
- Purchase Invoice
- Chart of Accounts
- Currency
SUMMARY
When you transact in foreign currency, ERPNext records the exchange rate against your base currency, and a fluctuating rate can mean payment is received at a different rate than the invoice. To manage this, create an Exchange Gain/Loss account (typically on the expense side of the P&L). When you book the Payment Entry, ERPNext automatically calculates the exchange gain or loss from the rate difference and posts it to that account, keeping the currency effect separate from your actual income and expenses.
