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 wil will be setup and used in Softrip: Quote, Cost, and Pay currency.
Quote currency - sets up the booking for the amount the passengers or agencies are going to pay. This is either setup in a monthly or annually fashion.
This currency is only used at time of booking (whenever the booking is created through reservations)
Applies to the payments that the company will receive from their passengers.
Once the booking is created, the exchange rate is locked in on that booking for the initial payment and any payment that occurs on that booking in the future.
Cost currency - cost currency relates to the services added into the application. This is the expected exchange rate to be in the future at the time of departure. This exchange rate would generally be applied when the suppliers are being paid.
This currency is setup in the product setup
Pay currency - The exchange rate that would be applied when the suppliers are being paid. This is an actual exchange rate.
This currency relates any time a user uses the payables screen in accounting
...
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 has its bank accounts in
USDThis is the Base Currency
Service costs are in
EURThis is the Local Currency
Cost is 100
EUR(= Local Cost)
Reservation is quoted in
GBPThis is the selling or Quote Currency
Markup rule is
1.10(10% markup)Exchange Rates loaded:
Type
C(Cost exchange rate)1.201.00 EUR=1.20 USD
Type
Q(Quote exchange rate)0.801.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)LocalCost * CostExchange = BaseCost100.00 EUR * 1.20 = 120.00 USD
Apply markup to get base price (
USD)BaseCost * Markup = BasePrice120.00 USD * 1.10 = 132.00 USD
Convert base price (
USD) to quote price (GBP)BasePrice * QuoteExchange = QuotePrice132.00 USD * 0.80 = 105.60 GBP