Which variables can be used in Word templates?

Document templates can be created and uploaded to Ledgy to be filled in with the information from the corresponding transactions. Here is a list of the supported variables that can be used in your document templates.

General variables

Variable Example Description
{today} 18 Mar 2020 Date of today
{currency} EUR Transaction's currency

Stakeholder variables

Variable Example Description
{stakeholder.name}  Elon Must Stakeholder's name as inserted on Ledgy
{stakeholder.email} elon@must.com  
{stakeholder.nationality} US  
{stakeholder.birthdate} 28 Jun 1971  
{stakeholder.notes}   Stakeholder's Internal Notes
{stakeholder.address.line1} Rocket Road 1  
{stakeholder.address.line2} c/o SpaceX Corp.  
{stakeholder.address.postcode} 9808  
{stakeholder.address.city} Hawthorne  
{stakeholder.address.country} India  
{stakeholder.identifier} EM-1234  

Usage

Stakeholder variables can be used wherever a stakeholder is involved. You may reference any of the sub-fields of the stakeholder, e.g. {stakeholder.name}, {stakeholder.email}, etc., as shown in the example below.


Option, warrant, and phantom grant variables

Variable Example Description
Stakeholder variables   Follow the link to see the available stakeholder variables that can be used
Vesting variables   Follow the link to see the available vesting variables that can be used
{amount} or {granted} 10,000 The number of grants being granted
{sharePrice} 2.00 Grant's purchase price (price to pay per each of the grants to receive them - usually applicable for Warrants)
{strikePrice} 3.1415926535 Grant's strike/exercise price (price to pay per each of the grants to exercise them - usually applicable for Options and Warrants)
{date} 12 Jul 2020 Date of the grant
{expiryDate} 12 Jul 2025  
{notes} More information on notes Grant transaction's internal note
{investment} 20,000.00 The amount payable by the stakeholder to receive the grants
= purchase price * granted amount
{dilutedShareCapital} 100.00 = number of grants issued * nominal value per grant

Vesting variables

Variable Example Description
{vesting.startDate}  1 Jul 2020  
{vesting.duration}  48 Vesting duration in months
{vesting.interval} 1 Vesting interval in months
{vesting.cliff} 12 Vesting cliff in months

Usage

Vesting variables can be used wherever vesting or reverse vesting can be added. You may reference any of the sub-fields of the vesting, e.g. {vesting.duration}, {vesting.cliff}, etc., as shown in the example below. Currently templating only supports simple vesting schedules.

 

Exercise variables
  1. General exercise variables

    Variable Example Description
    Stakeholder variables    
    Vesting variables   For reverse vesting
    {amount} or {exercised} 10,000 Amount of grants being exercised
    {date} 1 Oct 2022 Date of the exercise
    {sharePrice}  3.1415926535 Strike/exercise price
    {investment} 17'671.46 Amount payable by the stakeholder to exercise the grants = strike price * exercised amount
    {class} Common Share class issued from the exercising transaction
    {notes}  More information on notes Exercise transaction's internal note
    {shareCapital} 56.25 = number of shares issued * nominal value per share
  2. Variables relating to the original grant, that is being exercised
    Variable Example Description
    {grant.amount} or {grant.granted} 10,000 Total original grant amount
    {grant.strikePrice} 3.1415926535 Grant's strike/exercise price
    {grant.investment} 20,000.00 Original grant investment amount (= purchase price * granted amount)
    {grant.date} 12 Jul 2020 Original grant date
    {grant.expiryDate} 12 Jul 2025  
    {grant.notes} More information on notes Original grant transaction's internal notes
    {grant.dilutedShareCapital} 100.00 Original grant's diluted share capital (= number of grants granted * nominal value per grant)
    {grant.vesting.startDate} 1 Jul 2020  
    {grant.vesting.duration} 48  
    {grant.vesting.interval} 1  
    {grant.vesting.cliff} 12  

Share issuance variables

    Variable Example Description
    Stakeholder variables    
    Vesting variables   For reverse vesting
    {amount} or {issued} 1,500 Amount of shares being issued
    {sharePrice} 1.55 Shares' issue price
    {investment} 2,325.00 = sharePrice * amount
    {classId} Common Share class issued
    {date} 3 Feb 2021 Date of the share issuance
    {notes} More information on notes Share issuance transaction's internal note
    {shareCapital} 15 = number of shares issued * nominal value per share

    Custom Variables

    Would you like to have other customizable information in the document and the variable is not available for replacement on Ledgy in the list above? Below you may find two alternatives to insert further custom information in your templates.

    Transaction's Notes

    Ledgy has all the usual variables needed for document templates, but sometimes there could be a small difference from some companies to others, for such cases there is a workaround:

    An existing variable is {notes}, and it retrieves the information present in the Internal note section of the transaction on Ledgy. If you have a variable that you would like to use on the document template, but that variable is not available within Ledgy's standard variables, you can input the value of the variable in the transaction's Internal Notes, and use the variable {notes} to retrieve it in the document. For example, if you would like to input the amount of money paid when exercising a particular transaction, you can write that number in the transaction's Internal Note and use the variable {notes} in the document where you would like the variable to be replaced. 

    Custom variables

    Additionally, it is also possible to use the Stakeholder custom fields as variables in document templates.

    Follow the structure below to accurately enter the information in your template:

    General structure: {stakeholder.Custom Field}

     

    Example of a Stakeholder Custom field:

    Cost Center: 7237-234

    Custom field variable: {stakeholder.Cost Center} ⇒ Result: 7237-234

     

    Pro-tips

    Is your variable not working? Ledgy will automatically fill in with “undefined” if the variable cannot be found. 

    • Make sure that the information to replace the variable is on Ledgy: if you use the variable {stakeholder.address.city} but you have not input the stakeholder’s city information on Ledgy, it will show up as “undefined”
    • Make sure the variable is written exactly as stated above: if you have written {stakeholder.adress.city} (with a missing d), it will show up as “undefined”

     

    Example

    Let’s put the following text in a Word document for an option grant template:

    Berlin, {today}

    Dear {stakeholder.name},

    We hereby grant you the following number of Virtual Options according to the terms and conditions contained in the Agreement and in this Grant:

    Number of Options:     {amount}
    Grant Date:                    {date}
    Exercise Price:               {currency} {strikePrice}
    Vesting:                           {vesting.duration} years, {vesting.cliff} months cliff, vests every {vesting.interval} months

    Sincerely yours,

    Gwynne Sheetwell, Tom Baker

    The resulting PDF will contain:

    Berlin, 18 Mar 2020

    Dear Elon Must,

    We hereby grant you the following number of Virtual Options according to the terms and conditions contained in the Agreement and in this Grant:

    Number of Options:     10,000
    Grant Date:                    14 Mar 2020
    Exercise Price:               EUR 3.1415926535
    Vesting:                           4 years, 6 months cliff, vests every 6 months

    Sincerely yours,

    Gwynne Sheetwell, Tom Baker