Exchange Rates Overview
The Exchange Rates screen allows users to setup different foreign exchanges for their business for different time periods. This is a manual screen which requires users to manage internally either daily or monthly.
This screen is available under the "setup" menu option in Accounting.
...
Defining the fields
Overall, there are three different currency types that will be setup and used in Softrip: Quote, Cost, and Pay currency.
...
The following provides an overview of the fields that are available to setup in the exchange rates screen.
Base Currency
This is the currency that users will have the company setup in. The currency that is associated to the company in the "companies" screen is the base currency that is entered here.
Type
Users will need to setup the exchange rates for the three different currencies available by selecting the currency from the drop down menu.
Code
Enter the three letter currency code into this field.
Panel | ||
---|---|---|
| ||
Example:If a user wants to setup an exchange rate from their base currency of |
Exchange Rate
The exchange rate field is the actual numeric value used to calculate the rate.
Panel | ||
---|---|---|
| ||
Example:Exchange Rate code |
Begin Date
The beginning booking date of the period in which this Exchange Rate is applicable. Can not come later than the Ending date.
Info |
---|
Note: This is a manual process. Users can make updates to these dates internally as needed based on the current exchange rate values. |
End Date
The ending booking date of the period in which this Exchange Rate is applicable. Can not come before the beginning date.
Info |
---|
Note: This is a manual process. Users can make updates to these dates internally as needed based on the current exchange rate values. |
...
Calculation Example
Given the following:
Company base currency is
USD
has its bank accounts inUSD
This is the Base Currency
Service costs are in
EUR
This is the Local Currency
Cost is 100
EUR
(= Local Cost)
Reservation is quoted in
GBP
This is the selling or Quote Currency
Markup rule is
1.10
(10% markup)Exchange Rates loaded:
Type
C
(Cost exchange rate)1.20
1.00 EUR
=1.20 USD
Type
Q
(Quote exchange rate)0.80
1.00 USD
=0.80 GBP
When pricing this service in EUR
to be sold in GBP
, the pricing engine will perform the following calculations:
Convert local service cost (
EUR
) to base cost (USD
)ServiceCost LocalCost * CostExchange = BaseCost
100.00 EUR * 1.20 = 120.00 USD
Apply markup to get base price (
USD
)BaseCost * Markup = BasePrice
120.00 USD * 1.10 = 132.00 USD
Convert base price (
USD
) to quote price (`GBP`GBP
)BasePrice * QuoteExchange = QuotePrice
132.00 USD * 0.80 = 105.60 GBP