| Highlights: |
|
Doing business internationally often means working with customers and vendors who use different currencies. Whether you're selling products to a Canadian customer or purchasing materials from an overseas supplier, managing exchange rates and tracking transactions across currencies can add complexity to your accounting processes.
Acumatica's multicurrency functionality helps simplify these transactions by allowing businesses to manage exchange rates, process sales and purchases in different currencies, and automatically account for currency fluctuations.
Here's a closer look at how it works.
Setting Up Currency Management in Acumatica
Before processing transactions in multiple currencies, you'll need to configure a few settings within Acumatica's Currency Management module. The first step is establishing your currency rate types, which determine the exchange rates used for transactions. For example, you might use a spot rate that reflects the exchange rate for a particular date.
Next, you'll set up currency profiles for the currencies your business works with. Each profile allows you to define the currency description, symbol, and default general ledger accounts, including those used to record currency gains and losses.
Once configured, these settings support multicurrency transactions throughout your sales, purchasing, and financial processes.
Keeping Exchange Rates Up to Date
Exchange rates change regularly, but Acumatica can automatically retrieve updated rates from an online source. Using the Refresh Currency Rates feature, you can update rates manually or establish an automated schedule to refresh them daily or at another interval.
Acumatica also provides a Currency Rate History report, allowing you to review historical exchange rates by date. This can be helpful when reviewing past transactions or understanding how currency fluctuations have affected your financial results.
Assigning Default Currencies to Customers
Acumatica allows you to assign a default currency directly to each customer record.
Within the Financial tab, you can specify the customer's default currency and the exchange rate type that should apply.
For example, a customer in British Columbia might have Canadian dollars (CAD) established as their default currency. When you create a sales order for that customer, Acumatica automatically applies Canadian dollars and retrieves the exchange rate associated with the transaction date.
You can also enable the Currency Override setting, allowing you to change currencies on individual documents. This provides flexibility when a customer prefers to receive invoices in Canadian dollars but makes payments in U.S. dollars.
Creating Sales Orders and Invoices in Different Currencies
Once the customer settings are established, processing a multicurrency sales order follows much of the same workflow as a standard transaction.
Suppose you're creating a sales order for a Canadian customer totaling CAD $1,000. When you select the customer, Acumatica automatically populates Canadian dollars as the transaction currency and applies the exchange rate based on the document date.
From there, you can add items, adjust quantities and prices, and process the order as you normally would. When you create the shipment and invoice, the invoice maintains the currency established on the sales order.
Acumatica also allows you to toggle between the transaction currency and your company's base currency. For example, you can view the CAD $1,000 invoice in Canadian dollars or see its equivalent value in U.S. dollars.
When you generate or email the invoice, the document displays amounts in the assigned currency. This means your Canadian customer receives an invoice showing Canadian dollars, while your accounting team can review the corresponding U.S. dollar values.
Process Payments in Different Currencies
Acumatica also provides flexibility when receiving payments.
For example, your business might invoice a customer in Canadian dollars but receive payment in U.S. dollars. With the appropriate currency override settings, Acumatica can accommodate this scenario. Alternatively, if the customer pays in Canadian dollars, you can select the appropriate Canadian currency cash account when recording the payment.
The system recognizes the payment in Canadian dollars while also maintaining the corresponding U.S. dollar value for accounting purposes. This allows businesses to accommodate different customer payment arrangements without manually calculating currency conversions outside their ERP system.
Accounting for Exchange Rate Changes
Exchange rates can change between the time an invoice is issued and when payment is received. Acumatica automatically calculates and records the resulting currency gains or losses.
Consider a customer who receives an invoice for CAD $1,000. At the time of invoicing, that amount converts to $709.25 in U.S. dollars. However, by the time the customer makes the payment, the exchange rate has changed.
| Transaction | Canadian Dollars | U.S. Dollar Equivalent |
| Original Invoice | $1,000.00 | $709.25 |
| Customer Payment | $1,000.00 | $694.98 |
| Exchange Rate Difference | $0.00 | -$14.27 |
Although the customer paid the full CAD $1,000, the value of that payment decreased by $14.27 in U.S. dollars. Acumatica automatically calculates this difference and records the resulting foreign exchange loss in the appropriate general ledger account.
Rather than requiring manual journal entries, the system handles these calculations as part of the payment workflow. You can also review the associated journal transactions in both the transaction currency and your company's base currency.
Managing Multicurrency Purchases and Vendor Payments
While these examples focus on sales orders and customer payments, Acumatica supports similar functionality on the purchasing side.
Vendor records can be configured with default currencies and currency override settings, allowing businesses to create purchase orders, process vendor invoices, and make payments in different currencies.
For example, you might purchase materials from a Canadian supplier and choose whether to process the purchase and payment in Canadian or U.S. dollars.
Acumatica uses the applicable currency settings and exchange rates to support these transactions and record the corresponding accounting activity.
Simplify International Transactions with Acumatica
Managing multiple currencies adds another layer to your financial operations, particularly when exchange rates change between invoicing and payment.
With Acumatica's multicurrency functionality, businesses can automate exchange rate updates, process transactions in different currencies, and track the financial impact of currency fluctuations within their ERP system.
© 2026 SVA Consulting