How do I put a document in another currency?
A document —an invoice, a delivery note, an order, sales or purchase— can be recorded in a currency other than the euro, with the day’s exchange rate. Amounts are always stored in euros; the currency and the exchange rate say how that document is presented.
Where do I choose the document’s currency?
In the document’s top bar there is a drop-down with the flag and the name of each currency. The currencies it offers come from your company’s currency catalogue (Settings → Sales and documents → Currencies): only the active ones. If your company uses no currency other than the euro, there is nothing to choose and the drop-down shows the euro.
When you choose a currency, the document takes the exchange rate (Change) that currency has on its record at that moment. That rate is written on the document and doesn’t move on its own any more: it is the agreed rate for that transaction, even if the record is updated later.
Can I correct the exchange rate by hand?
Yes. With a currency other than the euro, the Change box appears next to the drop-down: how many units of the currency one euro is worth. You can type another value, always greater than zero. With the document in euros the box doesn’t appear, because the rate is 1 and there is nothing to correct.
What is the icon next to the exchange rate for?
It fetches the real rate for the day and puts it on the document. They are the daily reference rates of the European Central Bank, the ones used for invoicing.
If the query can’t be done —no connection, or because the ECB doesn’t publish a rate for that currency—, the rate from the currency record is used and a message tells you so. In either case the value is left in the box and you can correct it: a document’s exchange rate is the one you agreed, and it takes priority over any published rate.
The rate fetched stays on this document and doesn’t touch the currency record. The other way round too: asking for the day’s rate here doesn’t change any document already made.
What happens if the customer or the supplier has a currency on their record?
When you choose a business partner whose record shows a currency, the document takes it with the day’s rate and a message tells you so. There are two exceptions: if the document already has lines, nothing changes —it only warns you—, and if you had already set another currency by hand, yours takes priority.
Which currency do I see the amounts in?
In the document currency. With the document in dollars, the footer —net total, discount, VAT, invoice total— and the instalments on the financial tab are shown in dollars, with the symbol and the decimals the currency has on its record. Below the Invoice total, the euro equivalent also appears (‘= 1.000,00 €’), so that the amount that is posted is always in view. With the document in euros nothing changes: it looks as always.
Which currency is the document stored in?
Always in euros. The bases, the taxes and the total are calculated and stored in euros; the document also carries its currency and its exchange rate. That is why the accounting, the VAT and the receipts of a document in another currency are exactly the same as if it were in euros.
If something goes wrong
| What you see | Why it happens | What to do |
|---|---|---|
| The drop-down only offers the euro | The other currencies are inactive or don’t exist | Activate them or create them in Settings → Sales and documents → Currencies |
| ‘No exchange rate service: the record’s rate is used’ | The day’s rate couldn’t be looked up: no connection, or the ECB doesn’t publish that currency | The value set is the one on the record; correct it by hand if it doesn’t suit you |
| ‘The document is in the base currency: the exchange rate stays at 1.’ | With the document in euros the exchange rate isn’t changed | Choose the currency first and then adjust the exchange rate |
| You choose the customer and the currency doesn’t change | The document already had lines, or you had set a currency by hand | Change it yourself in the drop-down if you really want that currency |
More about Invoicing
- How do I delete a document?
- How do I make the consignment note for a shipment?
- How do I charge shipping or expenses without VAT?
- Setting up numbering series
- How do I convert several documents at once?
- Why is my invoice one cent out and how do I fix it?
- How do I turn a quote into a sales order, a delivery note or an invoice?
- Can I leave a document half-done and go to another screen?
- How do I issue an invoice?
- How do I deliver a sales order in several deliveries?
- How do I invoice a fee that repeats every month?
- How do I invoice several delivery notes at once?