Skip to main content

Work in multiple currencies

You can buy and sell in any currency while keeping your books in one. Your base currency is the one your books, inventory value and costs are kept in. Every other currency you add has a conversion to base: how many units of your base currency one unit of it is worth. SKU.io updates those rates every day from Open Exchange Rates, or you can type your own, and each purchase order, sales order and supplier bill keeps the rate it was converted at.

You can also look at your figures in a second currency without changing your books, and enter a product's default cost in the currency your supplier quotes.

Before you begin​

  • You need permission to manage currencies. Administrators have it.
  • Pick your base currency before you start trading. Changing it later converts every amount already stored, which is a large job.

See your currencies​

Go to Settings → General → Currencies. The top of the page shows your Base currency and your Default report currency; the list of currencies is underneath.

The Currencies list, with the base currency and a second currency on automatic rates

ColumnWhat it shows
CurrencyThe currency code.
BaseMarks your base currency.
Auto-updateAuto when the rate updates daily, Custom when you set it.
Conversion to BaseHow many units of your base currency one unit of this currency is worth. With US dollars as your base, a Canadian dollar rate of 0.72 means 1 CAD = 0.72 USD. Your base currency is always 1.
Last UpdatedWhen the rate last changed.

Under the title you'll see when rates last updated, such as Rates updated 2 hours ago · Open Exchange Rates. Two chips can appear beside it:

  • Automatic updates not configured — daily rates aren't available on your account. Set rates yourself with Custom.
  • Provider unavailable — showing last known rates — the rate service couldn't be reached. Your currencies keep their last rates until it's back.

Add a currency​

  1. Click Add Currency.
  2. Under Select Currency, choose the currency.
  3. Under Conversion to Base, enter how many units of your base currency one unit of the new currency is worth.
  4. Click Add.

The Add Currency dialog

A new currency is set to Auto. When today's market rate is available, it replaces the rate you typed straight away. To keep your own rate, switch the currency to Custom as described below.

Let rates update daily​

With Auto-update switched on, SKU.io fetches every currency's rate once a day, early in the morning UTC, after the major central banks publish. Rates are converted to your own base currency, whatever it is.

To fetch rates now instead of waiting for the next update, click Refresh Rates. The refresh runs as a background job, and the list updates when it finishes. The button is unavailable until you have at least one currency besides your base currency.

Set your own rate​

Use a custom rate when you've agreed a fixed rate with a supplier, or when your accountant sets the rates.

  1. Switch the currency's Auto-update off. It changes to Custom, and Conversion to Base becomes a box you can type in.
  2. Type the rate.
  3. Press Enter, or click away from the box, to save it.

Daily updates skip custom currencies. Switch Auto-update back on to return to the market rate.

See past rates​

Open the History tab. It lists the rate for each currency on each day, for the last 90 days unless you choose other dates, with its Source: the daily feed, or a rate someone typed. Filter it by Currency or Date.

SKU.io keeps this history so that a document dated in the past is converted at the rate in force on its date, not today's. A supplier bill dated March 3 uses the March 3 rate, even if you enter it in April.

Rates you type are kept too. Each custom rate is recorded with the date it took effect and stays in force until you type another or switch the currency back to Auto. These rows appear on the History tab with Manual as their Source and can't be edited there. A payment on a bill that posts in the supplier's own currency uses the rate in force on its Payment Date, so a custom rate you changed last week doesn't rewrite a payment made last month. See Post supplier bills in their own currency.

Use a currency on an order​

Purchase orders take their currency from the supplier. Give a supplier a pricing tier in its currency, and every new purchase order for that supplier starts in that currency. You can change it in the Currency box before you click Create Draft.

The New Purchase Order dialog, with the Currency box

The order shows its currency under Order Details.

A purchase order's Order Details, showing its currency

Sales orders work the same way: an order is in the currency its sales channel or customer uses, and you can pick a currency, or add one, when you create a sales order by hand.

Rates stay fixed on each order​

When an order is created in another currency, or its currency is changed, SKU.io stores that day's rate on it. Later rate updates don't change orders you've already placed, so a purchase order's cost in your base currency stays the same after the daily rate moves. On a purchase order in another currency, the rate it was converted at is shown under its currency as one unit of the order's currency in your base currency. With US dollars as your base, a Canadian dollar purchase order converted at 0.72 reads 1 CAD = 0.72 USD. Hover over it to see when the rate was last updated.

Enter a default cost in another currency​

A product's Default Cost is the cost SKU.io uses when stock arrives with no better cost to go on, such as a stock take or an adjustment that adds units. If your supplier quotes you in another currency, enter the cost in that currency rather than converting it yourself.

  1. Open the product and click Edit on Product Details.
  2. Next to Default Cost, choose the currency, then type the amount.
  3. Click Save.

Default Cost entered in Canadian dollars on a store whose base currency is US dollars

SKU.io keeps the amount exactly as you typed it. Whenever stock is valued from it, the amount is converted at the rate in force on the date of that stock event: a stock take counted on March 3 uses the March 3 rate, not today's. The product page shows the amount you entered with today's equivalent under it, such as 16.50 CAD and ≈ 11.88 USD today. A purchase order in the same currency starts with the amount as typed.

To go back to a cost in your base currency, choose your base currency and type the amount.

Choose the report currency​

Your Default report currency is the currency reports open in for everyone. It changes only what's shown on screen. Your books stay in your base currency.

  1. Under Default report currency, choose a currency.
  2. It saves straight away.

The Base currency and Default report currency settings

Anyone can pick a different currency on a report with Show amounts in. Their pick is remembered on their browser.

See costs in both currencies​

Most reports convert their amounts to the currency you pick. A few screens keep your base currency, because that's what your books hold, and show the other currency under each amount instead:

  • Inventory Valuation, at the rate for the report's date.
  • The COGS Report and Accounting COGS, at the average rate for the report's dates.
  • A product's Default Cost and Average Cost, at today's rate.

On those screens the switch reads Also show amounts in. Choose your base currency there to show one currency only. When you export the COGS report, each money column is followed by the same column in the other currency, such as Net COGS and Net COGS (CAD).

The Inventory Valuation report in US dollars with Canadian dollar amounts under each figure

Change your base currency​

To make another currency your base, click Set as base on its row, then confirm. SKU.io converts every amount already stored (inventory costs, COGS, order financials) at that currency's rate and restates every other rate against it. It can't be undone automatically, so check the rate first, and do this before you start trading if you can.

Next steps​

Last verified: