Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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.   

Calculations Examples

Given the following:

  • Company base currency is USD

  • Service costs are in EUR

    • Cost is 100 EUR

  • Reservation is in GBP

  • 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

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

    1. ServiceCost * 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

  • No labels