Below are detailed instructions for completing steps in the equity upload process in Microsoft Excel or Google Sheets. The formulas are all expressed in Excel form, but Google Sheets generally has a similar, if not identical, format.
For guidance on uploading equity, see Upload Equity Grant Data via CSV.
Update employee emails
To successfully map the employee's equity to the employee, you must use the employee's Lattice email. An export from Carta includes the employee's personal email by default, so you must use the VLOOKUP matching formula in either Google Sheets or Microsoft Excel to map.
- Download the provided CSV with Lattice's employee names and emails. To find this CSV:
- Navigate to Admin > Compensation > Total Compensation.
- Next to the Equity section, click Edit Settings. This will take you to the Equity Setup page.
- Click Upload Employee equity data. You'll receive a popup modal prompting you to select either Carta or Other Providers as the source of equity data. Select Carta or Other Providers.
- (Optional) If prompted, choose whether you are uploading new grants or updating existing and click Next.
- Click the link to download the Employee Name and Email reference CSV.
- Open the file with the employee's personal emails (generally your grant export).
- Create a new tab in this file, and copy over the two columns from the Lattice emails file with the headers Employee Name and Employee Email.
- In the tab with the grant data, find the column with personal emails and delete the data, leaving only the header. You will not need the personal emails going forward.
- In the first cell in this now empty column, add a formula to replace it with the Lattice email. Use a VLOOKUP formula to map the appropriate email to the employee name.
- This formula takes four parameters after "=VLOOKUP("
- Search key: The corresponding name value
- Range: The table on the second sheet with the names and emails. It should cover both columns and all the rows with values. Ensure the cell markers in the range formula have $ to hold them still
- Index: This should be 2, representing the second column in the range (i.e., the emails)
- Range lookup: Enter FALSE
- Once you've entered the formula, check to ensure the value showing up is the correct email for the employee.
- This formula takes four parameters after "=VLOOKUP("
- Copy the formula into all empty cells in the email column.
- Check to ensure there were no errors in Column B by adding a filter and confirming no error values. If so, the formula could not find the name in the name column in the table with names and emails. Reasons there may not be a match:
- People may have slightly different names in Lattice and in your equity management system, in which case you will need to manually update the name to match the Lattice name.
- People in Carta on the cap table are not active Lattice employees (e.g., inactive employees, other stakeholders). These people should be removed from the file.
- Copy the entire column and "Paste value" once the email column has been filled with the correct employee emails.
- Delete the second sheet with the names and emails.
You now should have all active employees in Lattice with their grants and the Lattice work email.
Map vesting schedule values
In cases where vesting schedules are exported as a single value (for example, a 'Vesting schedule name'), follow the instructions below on correctly mapping the correct values using VLOOKUP.
- Copy and paste the 'Vesting schedule' column from your export into a new sheet.
- Remove duplicates in the Vesting schedule column by selecting the column and:
- In Excel: Click Data > Remove Duplicates
- In Google Sheets: Click Data > Data cleanup > Remove duplicates
- The resulting column should contain only the unique vesting schedules at your company
- To the right of this column, create 4 column headers for "Vesting term (months)", "Cliff term (months)", "Vesting cadence", and "% immediately vested".
- For each vesting schedule, populate the appropriate numbers that represent the details of the schedule (Note: Lattice only supports linear vesting schedules):
- For example, if one of your vesting schedules is represented with the name: "New hire grant: 1/48 monthly, 1 year cliff", the values would be:
- Vesting term (months): 48
- Cliff term (months): 12
- Vesting cadence: Monthly
- % immediately vested: 0
- For example, if one of your vesting schedules is represented with the name: "New hire grant: 1/48 monthly, 1 year cliff", the values would be:
- In the same file, on the primary data tab, add four columns at the end for "Vesting term (months)", '"Cliff term (months)", "Vesting cadence", and "% immediately vested".
- Use VLOOKUP to populate the new columns:
- VLOOKUP parameters:
- Search key: The vesting schedule name (column H)
- Range: The table with vesting schedules and the values you mapped; Should be five columns and cover all the mapped vesting schedules
- Index: This number will change depending on which value you are populating:
- Vesting term (months): 1
- Cliff term (months): 2
- Vesting cadence: 3
- % immediately vested: 4
- Range Lookup: Enter FALSE
- VLOOKUP parameters:
- Once you've written the formula, check that the expected data is showing up. If it is, copy the formula into all empty cells in the column.