You can use the import file to reflect grant amendments in bulk using an excel spreadsheet.
For the purpose of this support article, we will use Option Grants as an example. But please bear in mind that this is also valid for other types of awards (e.g. warrants, restricted stock units, phantom shares and share grants)
To record amendments via import file , it is necessary to obtain the ID of the grants you want to reflect secondary transactions for.
1. Go to Equity Awards > Options > Grants.
2. Find the relevant option grant > View.
3. Find the ID number on the right-hand drawer.
4. Alternatively, you can download the Grant overview report for a list of all grant IDs currently on to Options > Reports.
5. Click Option grant overview.
6. Open the spreadsheet and check column Grant ID.
7. Go to Grants > Import offline grants.
8. Expand the collapsible menu Download import file template and download the Advanced granting template.
9. Open the spreadsheet you just downloaded and unhide line 3 of the excel spreadsheet, create an additional column in line 3 is_amendment.
10. When reflecting an amendment, these are the items you can change and how to complete the spreadsheet:
11. Return to the Import data page and click Upload.
12. The uploaded file can be edited or removed, otherwise, click Import data.
13. The platform will process the data in the file. Click Publish to publish the transactions or Review Imported Data to review them.
Exercise Price (or Hurdle Price for Share Grants)
To make amendments to the exercise price, fill in the following fields:
grant_id- the ID of the grant that you are amending
date - the date of the amendment transaction
exercise_price - the new exercise price for options, warrants, RSUs
hurdle_price - the new hurdle price if you are amending share grants
note - a not explaining the amendment
is_amendment- marked as 'yes', so that the transaction is recognised as an amendment
Expiration Date
To make amendments to the expiration date, fill in the following fields:
grant_id- the ID of the grant that you are amending
date - the date of the amendment transaction
expires - the new expiration date
note- a not explaining the amendment
is_amendment- marked as 'yes', so that the transaction is recognised as an amendment
Vesting Schedule
To make amendments to the vesting schedule, fill in the following fields. You can then select from the options below to add amendments to different vesting schedules:
grant_id- the ID of the grant that you are amending
date - the date of the amendment transaction
note- a not explaining the amendment
is_amendment- marked as 'yes', so that the transaction is recognised as an amendment
Please see below for an example file of the fields populated to register an amendment to the vesting type of a grant:
Column Name | If required | Explanation |
grant_id | compulsory | The grant ID number of the grant that the amendments are for. |
date | compulsory | The date of amendment transaction. |
is_amendment | compulsory | It must be marked as 'yes' for the transaction to register as an amendment. |
note | compulsory | A note to explain the amendment that will be visible on both the admin side and the grantholder side. |
vesting_type | compulsory if amending the vesting schedule | The type of vesting for the grant: |
vesting_start | compulsory if amending the vesting schedule | The date of when the vesting starts. |
vesting_on | compulsory if amending the vesting schedule for time-based vesting types | For any of the 'time_based' vesting types. When the vesting takes place: first_of_month same_date last_of_month |
vesting_months | compulsory if amending the vesting schedule for time-based vesting types | For any of the 'time_based' vesting types, the number of months vesting will take place (this includes the cliff if applicable). |
vesting_cliff | non-compulsory | For any of the 'time_based' vesting types, how long the vesting cliff is before vesting starts (typically it is 12 months so you will enter 12. It could also not have any cliff so you enter 0). |
cliff_percentage | non-compulsory | For any of the 'time_based' vesting types, and there is a cliff. Typically it is 25% so you enter 25 (no symbols). |
vesting_interval | compulsory if amending the vesting schedule for time-based vesting types | For any of the 'time_based' vesting types, how often the grant vests (after cliff if applicable). For example, if the grant vests monthly, you input 1, quarterly then you input 3 and annually then you input 12. |
scheduled_date | non-compulsory | For custom vesting type and could be used for performance-based vesting type. This would be the scheduled date that the grant will vest on. |
scheduled_quantity | non-compulsory | For custom vesting type and performance-based vesting. This would be the scheduled amount of grant will vest. |
vested_quantity | non-compulsory | Used for custom or performance-based vesting type. To complete if the amount has vested. |
vesting_description_custom | non-compulsory | If left blank, this field is auto-populated with a vesting description for time-based vesting schedules. Otherwise, it can be used to write a description of the vesting schedule. |
exercise_price | non-compulsory | The exercise (strike) price of the grant |
expires | non-compulsory | The date of when the grant expires. Compulsory for EMI and CSOP grants (typically expires after 10 years). |