¶ 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, go 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
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/Notoggle 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
¶ 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.
¶ 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 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.
