Skip to content

How do I add a currency?

A currency is a currency your company works with. Its record stores how it is written (code and symbol), how many decimals its amounts are shown with and what its exchange rate is. One of them is the base currency: the one the company keeps its accounts in.

What is the currencies record and what is it for?

It is your company’s catalogue of currencies. It is in Settings → Currencies, and it also appears in the Records group alongside the rest of the master data.

Each currency stores four things: its three-letter ISO code, its Name, the Symbol its amounts are printed with and the Decimals they are shown with. It also stores its Exchange rate against the base currency.

What you choose in the Currency drop-down on a customer or supplier record comes from here, and so does the currency of a sales or purchase document (see how to put a document in another currency). Before, those drop-downs offered three fixed currencies and there was no way to add a fourth.

Each company has its own catalogue. What you add in one doesn’t appear in the others.

Which currencies do I have without doing anything?

A new company starts with three: EUR (Euro), USD (US dollar) and GBP (Pound sterling).

EUR starts as the base currency and active. The other two start inactive and with the exchange rate at 1.

The 1 on the two inactive ones isn’t a quoted rate: it is a placeholder value. No exchange rate is made up that no one has checked. When you want to use the dollar or the pound, activate them and type in the day’s rate.

Every company starts with those three currencies, so you don’t need to set anything up to operate. If the list were empty —for example, after deleting all the currencies by hand—, the screen itself offers the Create the default currencies button, which adds the set in one go. It only appears with the list empty: if any currency has been added, the default set isn’t mixed with yours.

How do I create a new currency?

Click Add currency, fill in the record and save.

ISO code and Name are the only two required fields.

The ISO code is the currency’s three letters: EUR, USD, CHF. It is always saved in capitals, so ‘usd’ and ‘USD’ are the same currency. The field doesn’t take more than three characters: if you type ‘EURO’, the last letter doesn’t fit.

There can’t be two currencies with the same code in the same company. If you try, the save is rejected and you are told which code is repeated.

The Symbol is optional. If you leave it empty, amounts are shown with the code.

What exactly does the Exchange rate field mean?

It is **how many units of that currency are equal to one unit of the *base currency***.

If your base currency is the euro and the dollar is at 1,084, the dollar’s Exchange rate is 1,084: for each euro, 1,084 dollars. Below the field you have the reminder ‘Units per 1 Euro’, with the name of your base currency.

It takes up to six decimals. They are needed for currencies with large parities, where one euro is thousands of units.

It has to be greater than zero. Zero is rejected because it would turn any amount into zero.

You can type it by hand or ask for the day’s rate (see the next question).

How do I get the day’s exchange rate without looking it up myself?

Click the Update the rate from the service icon on that currency’s row. The ERP checks the day’s quoted rate and writes it on the record.

To bring them all up to date at once, use Update all exchange rates in the screen header. It goes through the active currencies other than the base currency —the base is worth 1 by definition, and an inactive currency isn’t offered anywhere—.

The rates are the European Central Bank’s daily reference rates. They are the ones used for invoicing: an official value for the day, not a market price that changes every second.

Next to the exchange rate you will see updated on with the date of the last check. If it says not updated, that rate doesn’t come from the service: someone typed it or it is the default one. The date may be the previous day’s at weekends or on public holidays: the ECB doesn’t publish on those days and the last real figure is kept, which is the honest thing to do.

Typing the exchange rate by hand doesn’t change that date, because the date says when the service was checked, not when the record was changed.

If the exchange rate can’t be fetched

It can happen: with no Internet connection, or because the European Central Bank doesn’t publish a rate for that currency. In that case:

In that case, type the exchange rate by hand.

Does it update itself every day?

It can, but it comes turned off. If you would like the ERP to fetch the rates every morning without anyone clicking anything, ask whoever administers your installation: it is a setting per company. While it is off, the exchange rate only moves when you ask for it.

Documents already issued are never touched, not even with automatic updating on: each document keeps the exchange rate agreed on the day it was made.

What are the currency’s Decimals?

Decimals are the figures shown after the decimal comma in amounts in that currency. The euro and the dollar have 2; there are currencies without fractions that have 0. From 0 to 6 is accepted.

It is a display setting: it says how an amount is shown, not how it is stored. Lowering them doesn’t round anything you already have: a document saved with 1.234,56 is still worth that even if you set 0, and it will be shown in full again as soon as you raise them.

What is the base currency and why is it different from the others?

It is the currency your company keeps its amounts and its accounts in. In the list it appears with the Base currency badge next to its name.

There can only be one per company. It is the reference all exchange rates are measured against, so two would be two different yardsticks.

That is where its three special features come from:

How do I change which currency is the base currency?

Open the currency you want it to be, tick Company base currency and save. The one that was the base stops being so in that same step.

It is done this way and not the other way round: you can’t untick the current base without putting another in its place. If you try, the save is rejected and you are told to mark another currency as base.

When you mark a currency as base, its Exchange rate becomes 1 and it is set to active. That is the only thing it can be, so the record does it the moment you tick the box: what you see is what is saved.

When editing the base currency, the ISO code can’t be changed. That code is written on the records that already use it, and changing it would leave them pointing at a currency that doesn’t exist.

How do I edit a currency?

With Edit currency, the pencil on its row. Change whatever you need and click Save changes.

The only thing that can’t be changed on a currency already in use is its ISO code: it is stored on the documents issued with it, and renaming it would leave those documents pointing at a currency that no longer exists.

How do I stop using a currency without losing what was done with it?

With Deactivate currency, the switch on its row, or by unticking Active currency on its record. They are the same setting seen from two places.

A deactivated currency is no longer offered in the customer, supplier and document drop-downs, but it doesn’t disappear: records that already have it keep it, and documents issued in that currency are still worth what they were worth. It is the normal way to retire a currency you no longer use.

To use it again, the same switch, which then says Activate currency.

When can I delete a currency and when can’t I?

Delete currency removes it completely, and it is for correcting one you have just added, not for retiring a currency in use. That is what deactivating it is for.

If anything is using it, the deletion is rejected and the screen tells you what is using it. And the base currency shows neither switch nor bin: it can’t be deactivated or deleted while it is the base.

How do I search for a currency?

The search box at the top matches the code, the name and the symbol at once. It is not case sensitive: searching ‘pound’ finds ‘Pound sterling’.

How do I sort the list?

The search box at the top matches against the Code, the Name and the Symbol at the same time. It ignores capitals: searching for ‘pound’ finds ‘Pound sterling’.

The Code, Name, Exchange rate and Status headers sort the list. Click once to sort and again to reverse the direction.

The list also shows the inactive ones, which are exactly the ones you need to be able to reactivate. Each row has its Active or Inactive badge.

How do I give a customer or a supplier a currency?

On the Financial tab of their record, with the Currency drop-down.

The drop-down shows each currency’s flag next to its code and its name, so you can recognise it at a glance. Currencies without a flag of their own are shown with a generic icon; it isn’t an error, it is just that not all of them have one.

Only active currencies are offered. If the one you are looking for doesn’t appear, add it or activate it in Settings → Currencies.

The ‘Not specified’ option is kept, which is how records that have never filled in the field start. It is a valid value: leave it like that if it doesn’t apply.

If something goes wrong

What you seeWhat has happenedWhat to do
‘A currency with the code “X” already exists.’Another currency in this company uses that ISO codeUse another code, or edit the one that already exists
‘The currency’s ISO-4217 code is required’The ISO code is missingType the currency’s three letters
‘The code can’t exceed 3 characters’The ISO code is longerUse the three letters: EUR, not ‘EURO’
‘The currency exchange rate must be greater than zero.’The Exchange rate is zero or negativeType the real rate
‘The currency decimals must be between 0 and 6.’The Decimals are out of rangeEnter a value from 0 to 6
‘The company needs a base currency’You have unticked the base without setting anotherMark another currency as base; the current one is unticked automatically
‘The base currency cannot be deactivated.’Someone tried to retire the company’s own currencyMark another currency as base first
‘The base currency can’t be deleted’The same, when deletingMark another currency as base first
The drop-down on the customer record is emptyThere is no active currency in this companyActivate one in Settings → Currencies

See also: Add a customer · Add a supplier

More about Records