Managing Multi-Currency Transactions in ERPNext
ERPNext allows businesses to create accounting transactions in both the company’s base currency and the customer’s or supplier’s preferred currency. This makes it easier to conduct international business while ensuring all accounting records are maintained accurately in the company’s base currency.
When a transaction is created in a party’s currency, ERPNext automatically converts the amounts using the applicable exchange rate and displays the correct currency symbols in both the transaction and its print format.
ERPNext stores the transaction in the party’s currency while simultaneously calculating its equivalent value in the company’s base currency for accounting and reporting purposes.
1. Creating a Multi-Currency Sales Invoice
To create a Sales Invoice in a foreign currency:
Home > Accounting > Billing > Sales Invoice > New
Follow these steps:
- Create a new Sales Invoice.
- Select the Customer.
- If a default currency is configured for the customer, ERPNext automatically populates the Currency field.
- The current exchange rate between the company’s base currency and the customer’s currency is automatically fetched.
- Add the required Items, Taxes, and Payment Terms.
- Review the invoice and Save.
2. Exchange Rate Handling
When a customer uses a different currency from the company’s base currency, ERPNext automatically retrieves the applicable currency exchange rate.
For example:
- Company Base Currency: USD
- Customer Currency: EUR
ERPNext uses this exchange rate to:
- Calculate accounting values in the company’s base currency.
- Display invoice values in the customer’s currency.
- Generate accurate financial reports.
3. Taxes and Charges
When creating transactions in a foreign currency:
- Item Rates and Amounts are entered in the customer’s currency.
- Taxes and Charges are calculated in the transaction currency.
- Charges of type Actual should also be entered in the customer’s currency.
This ensures the customer receives an invoice entirely in their preferred currency.
4. Print Format
After saving the Sales Invoice, ERPNext automatically updates the print format.
The following fields display the customer’s currency symbol:
- Item Rate
- Amount
- Taxes
- Grand Total
- Outstanding Amount
The printed Sales Invoice reflects the customer’s currency throughout, making it easier for international customers to review and process the invoice.
5. Using Currency Exchange Masters
If your organization uses a fixed exchange rate with a particular customer or supplier, you can configure it using the Currency Exchange master.
Navigate to:
Home > Accounting > Settings > Currency Exchange
Create a Currency Exchange record by specifying:
- From Currency
- To Currency
- Exchange Rate
- Effective Date
Once configured, ERPNext will use this exchange rate for future transactions.
6. Currency Exchange Priority
ERPNext determines exchange rates using the following priority:
- Exchange Rate defined in the Currency Exchange master.
- Live exchange rate fetched from the configured exchange rate provider.
For example:
- Configured Currency Exchange: 1 USD = ₹65
- Current Market Rate: 1 USD = ₹69
ERPNext will use the configured rate of ₹65 because manually defined exchange rates always take precedence over live market rates.
A manually configured Currency Exchange record overrides live exchange rates, allowing organizations to work with contractually agreed or internally approved exchange rates.
7. Benefits of Multi-Currency Transactions
- Create invoices in customer or supplier currencies.
- Automatically calculate values in the company’s base currency.
- Generate invoices with the correct currency symbols.
- Support both live and fixed exchange rates.
- Improve international accounting and financial reporting.
- Maintain consistent exchange rate policies across transactions.
