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.  

• 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. 

Example:

If a user wants to setup an exchange rate from their base currency of USD to sell in EUR in reservations, they will enter USD into the BaseCurrency, Q in the Type field, and EUR in the Code field.  

Exchange Rate

The exchange rate field is the actual numeric value used to calculate the rate. 

Example:

Exchange Rate code C is (LocalCost * ExchRate = BaseCost).
Exchange Rate code Q is (BasePrice * ExchRate = QuotePrice).
Exchange Rate code P is (ApplyLocal * ExchRate = ApplyBase).

Begin Date

The beginning booking date of the period in which this Exchange Rate is applicable.  Can not come later than the Ending date.

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. 

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 USD

  • 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:

1. Convert local service cost (EUR) to base cost (USD)

   1. LocalCost * CostExchange = BaseCost

   2. 100.00 EUR * 1.20 = 120.00 USD

2. Apply markup to get base price

   1. BaseCost * Markup = BasePrice

   2. 120.00 USD * 1.10 = 132.00 USD

3. Convert base price (USD) to quote price (GBP)

   1. BasePrice * QuoteExchange = QuotePrice

   2. 132.00 USD * 0.80 = 105.60 GBP