Once the currency information is set up, you can enter the exchange rate values on the Exchange Rates tab.
The exchange rates entered here are used for all foreign currency processes. You can change the exchange rates when entering individual transactions, as long as the currency is Amendable. When you enter transactions, changes made to exchange rates do not update the exchange rates entered here. You can only update the exchange rates if you choose Edit exchange rates when printing invoices and credits in the Accounting System Manager system Operational settings tab. If you have selected this, you can choose to save the new exchange rate, when you print the invoice or credit note.
Note: The most up-to-date exchange rates are available on the Internet (e.g. from www.xe.com). Exchange rates may change on a daily basis so you should identify your own best method of updating them regularly in Sage 200. This could be daily or weekly. The more often you update the exchange rates, the more accurate your foreign currency trading transactions will be.
Open: Accounting System Manager > Settings > Currencies and Exchange Rates | Exchange Rates.
For non-euro currencies, enter the exchange rate in the 1£ equals column. If the currency is fixed to the Euro, through triangulation, enter the Euro exchange rate in the 1 Euro Equals column.
For the Euro, enter the exchange rate in the 1 Euro Equals column for your base currency. A euro to base calculation is always used, e.g. 1 Euro= £0.87.
You set up a rate and an expiry date for the rate in the Period Exchange rates to £ box for non-euro currencies. You must also set the rate and expiry date in the Period Exchange rate to Euro for the Euro or for currencies fixed to the Euro, through triangulation. You can add as many period exchange rates as you need.
Overview
Other tasks
View history of currency exchange rates
Reference
xe.com website (www.xe.com)