¶ Introduction
Derivatives are tools or securities that an investor uses for different reasons including hedging. These securities are called derivatives because they are derived from some underlying asset. Futures for instance, are derivatives, which can be used to hedge. Hedging and derivatives are related terms in the financial and investment world.
Hedging is an investment strategy and technique to prevent loss and risks in any market situation. It acts as a preventive measure – like insurance. Derivatives are just one of the hedging instruments.
In different situations, hedging can either result in a profit or a risk loss. Derivatives are tools that contribute to either result. Both concepts are also different in nature. Derivatives come in the form of contracts or agreements between two parties.
¶ Navigation
¶ Setup
¶ Step 1: Setup Derivative groups
To create a Derivative group, go to:
- Treasury > Hedge and derivatives > Setup for hedge and derivatives > Derivative groups
- Create a new Derivative group and Description
- Select derivative Posting profiles
- Click the Save button
|
Derivative group |
Description |
| Cur/SW | Currency swaps |
| FT | Future contracts |
| FW | Forward contracts |
| In/SW | Swaps |
| OPC | Option - Call |
| OPP | Option - Put |
| SW | Swaps |
¶ Step 2: Setup Posting profiles - derivatives
To create Derivative posting profiles, go to:
- Treasury > hedge and derivatives > Setup for hedge and derivatives > Posting profiles - derivatives
- There are profiles for:
- Initial recognition
- Subsequent measurement and
- Settlement
- Click on New to add a posting profile line for each ledger account, in the posting profile header of the page
- Account type, Ledger account, Offset account type and Ledger accounts can be filled in on the Account structure
- When either customer or vendor is selected as the account type, the corresponding field can be left empty in the posting profile. The checkbox labelled Populate from Derivative can be used in the place of filling the customer or vendor account.
- Click the Save button
¶ Step 3: Setup Derivative contract type
To create Derivative contract type, go to:
- Treasury > Hedge and derivatives > Setup for hedge and derivatives > Derivative contract type
- Click on New: Create new Derivative contract type
¶ Step 4: Setup underlying entity type
To create Underlying entity type, go to:
- Treasury > Hedge and derivatives > Setup for hedge and derivatives > Underlying entity type
- Click on New: Create new
¶ Step 5: Setup underlying entity
To create Underlying entity, navigate to:
- Treasury > Hedge and derivatives > Setup for hedge and derivatives > Underlying entity
- Click on New: Create new Underlying entity
¶ Step 6: Financial Risk register (G2T)
For more information on the setup of the Financial risk register, open the GRC001 Test script Operational Risk management.docx document, which forms part of the Governance, Risk and Compliance module.
The GRC001 Test script Operational Risk management.docx document contain the following setup:
- Risk types
- Economic
- Health
- Strategic
- Safety, etc.
- Risk configuration
- Risk categories
- Risk Likelihood
- Inherent risk
- Residual risk
- Mitigation effectiveness
- Inherent consequence
- Residual consequence
¶ Step 7: Setup Treasury parameters
To enable the Derivative values FastTab on Derivatives, go to:
- Treasury > Setup > Treasury parameters
- On the General tab, expand the Derivatives FastTab
- Slide the Enable derivative values toggle to Yes
- When set to Yes, the Derivative Values FastTab will be visible on the derivatives page, and when set to No, it will be hidden.
¶ Daily use
¶ Step 8: Create a new Derivative contract
The Create new Derivative contract dialogue consist of the following FastTabs/sections:
- Identification
- Contract
- Contract inception
- Currency conversion spot rate
- Contract termination
- If Use contract termination toggle was set to Yes in the Contract section, this FastTab called Contract termination will appear and can be filled in
- Currency conversion forward rate
- Posting profiles
- Financial dimensions
To create a derivative contract, go to:
- Treasury > Hedge and derivatives > Derivative register
- Create New
- Enter the information in the fields under the Identification heading:
- The derivative ID populates automatically with a set up number sequence
- A derivative type as set up is specified.
- The derivative group is selected from the drop-down menu which was set up and created
- Enter the information in the fields under the Contract Inception heading.
- Enter the information in the fields under the Contract Termination heading.
- The Posting profiles defaults from the Derivative Group which was set up
- Complete Default Financial Dimensions which can be linked to the derivative contract
- Enter the information in the fields under the Contract heading.
- If the derivative contract is an intercompany contract, a drop-down list of legal entities is available in the Intercompany counterparty field.
- Users have the option to default the exchange rate from the General Ledger instead of manually entering it.
- A Yes/No toggle called Use General ledger rates can be used.
- If Yes is selected, the rate for the exchange pair will automatically populate the spot rate field from GL > Exchange Rates.
- If No is chosen, the process will continue as before.
- The exchange rate type can be found in the General Ledger setup.
- The contract date will be utilized to determine the correct rate from Currencies > Currency Exchange Rates.
- If no rate exists in the exchange rate setup, the process will proceed normally without a rate being defaulted
- If a rate for the specific contract date is unavailable, the latest available rate will be used.
- Users retain the option to edit the defaulted rate even if it is automatically populated.
- When Yes is selected in the new dialog box, the initial journal will be created differently:
- If No is selected, the journal will be created as it was previously.
- If Yes the debit and credit lines will be generated using GL exchange rates. If the user retains the spot rate, this will create a balanced journal for the accounting and/or reporting currency if it matches one of the swap currencies.
- However, if Yes is selected and the spot rate is changed, the journal lines will still be created using GL exchange rates, resulting in an imbalance in the accounting or reporting currency. In this case, a third and fourth line will be created using the posting profile setup to fetch the account for exchange gain/loss, which will either be debited or credited to balance the journal
- If the swap currencies do not match either the accounting or reporting currencies, a third and fourth line will be created to reflect either a gain or a loss, which could result in one being a loss and the other a gain
- These specifically apply to a forex swap at the spot rate, relevant only for the contract inception portion of the record and not for the contract termination
- When capturing the Buy amount and the Sell amount, the Spot rate will be calculated
- The Sell amount can be captured, and the user will enter a rate per unit of the buying currency, and the system will calculate the buying amount
- The rate can also be captured in one of two ways:
- Manually, by calculating the Sell amount divided by the Buy amount and entering the result.
- By capturing a different conversion direction, and have the system calculate the rate and updating the spot rate. In turn this can be captured as a rate per unit of the buying or selling currency.
The currency swap method of input are allowing the user to capture a rate and the selling quantity, with the system calculating the buying quantity. The conversion tool enables the user to capture the rate in either buying or selling currency format, and the system converting to the appropriate rate for the currency swap.
¶ Step 9: Derivative register list page
- Users can filter on Derivative type
- The column called Position displays Open derivatives
- Derivative register keeps track of the remaining value.
- View of list page when scrolling right
- Derivative ID: system generated number
- Derivative type: automatically populated when Derivative type ID is selected
- Derivative type ID: short code for Derivative type, can be chosen from options menu
- Currency swaps (Cur/SW)
- Future contracts (FT)
- Forward contracts (FW)
- Swaps (In/SW)
- Option – Call (OPC)
- Option – Put, etc. (OPP)
- Swaps (SW)
- Derivative sub-type to be selected from dropdown menu options:
- Call Option (OPC)
- Commodities (FT)
- Currency (Cur/SW)
- FEC contracts (FW)
- Interest (In/SWO
- Payments (SW)
- Put Option (OPP)
- Derivative description
- Bank groups
- Exchange description
- Exchange ID
- Position
- Risk strategy description
- Risk strategy ID
- Start date
- End date
- Entity ID
- Name
- Contract description
- Partner
- Contract reference
- Service provider
- Contract type ID
- Contract date
- Contract expiry date
¶ Step 10: Derivative register details page
The following FastTabs can be viewed when opening a specific Derivative item on the Derivative Lines section:
- Derivative register header
- Derivative values
- Associated transactions
¶ Step 10.1: Derivative register header FastTab (under Lines section)
- Identification
- Under the Identification section, the user can select Paying or Receiving for the Derivative group from the drop-down list
- If the user selected a derivative group for Paying, that derivative will be available for use on Purchase Orders
- If the user selected derivative group of Receiving, that derivative will be available for use on Sales Orders.
The External counterparty field is a drop-down to the vendor master table.
The Position field on each Swap header will automatically update from Open to Closed when a Settlement journal is successfully posted. By default, the Position is set to Open upon swap creation.
¶ Step 10.2: Derivative values FastTab
The following FastTabs can be viewed when opening a specific Derivative item on the Derivative Header section:
- Derivative register
- Derivative values
- Associated transactions
¶ Step 10.3: Associated transactions FastTab
- Loans and investments
- Sales orders
- Purchase orders
- Budgets
¶ Step 10.3.1 : Loans and Investments
¶ Linking loans to currency swaps
The sequence of loan creation and derivative creation can occur in either order. Associating one product with the other will automatically register the linked record. When a loan is linked from the Derivative register, the loan fields are automatically populated, and the Hedge toggle is set to Yes with the FastTab displayed. Conversely, when a derivative instrument is linked from a loan, the relevant fields in the derivative register are also populated accordingly
When the toggle for Hedged is set to yes on the Header index tab of the loan details page, a FastTab labeled Hedged will appear. This section, known as the Hedged FastTab, includes options to add or remove entries. It contains columns for:
- Derivative
- Derivative type
- Derivative description
- Start date
- Currency
In the Derivative register, located under the Loans and investments FastTab, the associated Loan number appears as a hyperlink. This field is automatically populated when linking the derivative instrument from the Loan page
¶ Step 11: Sales orders and Derivatives
To link a derivative to a specific Sales Order, go to:
- Accounts Receivable > Orders > All sales orders
- Open an existing sales order
- Expand the Header section
- Expand the Derivatives FastTab
- Click on Add
- Select a Derivative from the drop-down menu
- Click Save
The rate negotiated on the forward exchange contract (Derivative) will populate to the Price and discount FastTab, into the field “Fixed exchange rate” on the Sales Order header and be used for posting purposes.
- Once the derivative has been selected on the Sales order, it will update the Fixed Exchange Rate field and Derivative conversion rate fields on the Derivatives fast tab on the Sales Order.
- An open value to exist, if value is less than zero, an error message will appear
- When changing the Derivative, it will update the exchange rate on the Sales Order header. Creating a second derivative against the same Sales Order, will override the rate.
¶ Step 12: Purchase orders and Derivatives
When adding a Purchase order to the Derivative, it will automatically appear on the Purchase Order as well. To view the linked derivative or to add derivatives to the Purchase Order, go to:
- Accounts Payable > Purchase orders > All purchase orders
- Open an existing purchase order
- Expand the Header section
- Expand the Derivatives FastTab
- Click on Add
- Select a Derivative from the drop-down menu
- Click Save
The rate negotiated on the forward exchange contract (Derivative) will populate to the Price and discount FastTab, into the field “Conversion rate” on the Purchase Order header and be used for posting purposes.
- On Purchase Order Invoice posting stage, on the Invoice header, Setup FastTab, the user can choose to include derivatives or not
Once the derivative has been selected on the Purchase order, it will update the Fixed Exchange Rate field and Derivative conversion rate fields on the Derivatives FastTab on the Purchase Order.
- An open value to exist, if value is less than zero, an error message will appear
- When changing the Derivative, it will update the exchange rate on the Purchase Order header. Creating a second derivative against the same Purchase Order, will override the rate.
¶ Step 13: Derivative Journals
Derivative journals are created to record the accounting transactions of derivative contracts. It includes the initial recognition journal, subsequent measurement journal and settlement journal. Posting profiles should be set up before derivative journals can be created and posted.
¶ Step 13.1: Initial Recognition Journal
Once the derivative contract has been created the initial recognition journal is created. It can be set up with that the journal is automatically posted, or the journal can be reviewed before the journal is posted.
- Navigate to: Treasury>Hedges and Derivatives>Derivative register
- Click on New and complete the necessary fields
- Click on OK
- The journal is automatically created:
- Navigate to the Derivative Register menu on the Derivative contract, the journal has been created:
¶ Step 13.2: Subsequent Measurement Journal
If the contract period is over multiple months, the contract should be re-measured at each month end.
- Navigate to: Treasury>Hedges and Derivatives>Periodic>Subsequent Measurement journal
- Click on Subsequent Measurement Journal, complete the necessary fields and click on OK
- Enable the Post journal setting to Yes if the journal should be posted automatically
- Navigate to the Derivative Register menu on the Derivative contract, the journal has been created:
¶ Step 13.3: Settlement Journal
When the contract terminates the settlement journal should be created and posted to settle the contract
- Navigate to: Treasury>Hedges and Derivatives>Periodic>Settlement journal
- Click on Settlement Journal, complete the necessary fields and click on OK
- Enable the Post journal setting to Yes if the journal should be posted automatically.
- Navigate to the Derivative Register menu on the Derivative contract, the journal has been created:
If a derivative has any posted or unposted journals, it will be non-deletable. When attempting to delete a derivative with an Intercompany counterparty that has existing journals (posted or unposted), the following warning will be displayed: "Note: Journals already exist for the intercompany counterparty. Are you sure you want to delete?" with options for Yes or No.
¶ Reporting
¶ Step 14: Swap deals inquiry
Once an FX Swap contract is terminated, a revaluation will occur to calculate the Gain/Loss on the contract. This revaluation is based on the commitment at the contract termination against the exchange rate value captured in the system, and not the forward rate fixed on the deal.
To run the Swap deals inquiry report, go to:
- Treasury > Hedge and derivatives > Enquiries and reports > Swap deals inquiry
- The Start date and End date fields are not mandatory
- This report will calculate and populate after the settlement journal has been posted.
- Trade date - linked to document date
- Bank - this is the bank providing the swap
- Spot rate - conversion rate from currency 1 to currency 2
- Spot value - nominal value of deal in currency 2 on start date
- Forward rate - conversion rate from currency 2 to currency 1
- Accounting rate - conversion rate between currencies as on contract End date
¶ Step 15: Period interest inquiry
To run the Period interest inquiry report, go to:
- Treasury > Hedge and derivatives > Enquiries and reports > Period interest inquiry
