Excel models can be linked to Deals in TermSheet by associating Excel model templates to TermSheet fields.
TermSheet syncs underwriting models and captures updates to help save time reducing the manual effort of generating reports for pipeline meetings and memos for investment committee meetings. Make updates in Excel or TermSheet and updates can be published to keep both spaces aligned.
📑 Learn To:
💡 Things to Consider
When mapping an Excel model to Termsheet, it is important to map the model template, then generate new models from the mapped template for all new deals.
A recommended best practice is to map Excel model templates that will be used on a go-forward basis.
Historical deals are mapped individually since they were not created in Excel from a mapped model template.
When adding new fields from TermSheet to Excel Model Templates, refresh the TermSheet tab on the model to map the new fields. Once the new fields have been mapped, they will be mapped for new deals moving forward. These changes are not retroactive and will not impact existing deals.
Custom Fields should be created before linking models to ensure the organization-specific data tracked is mapped. New fields can be mapped at a later date, however deals that have been published to TermSheet will not be updated retroactively.
⚙️ Steps
Before mapping an Excel model template to TermSheet, install the TermSheet Add-in.
Map an Excel Model Template to TermSheet
3. Select the account workspace. Any workspaces you have access to will appear by default.
4. Select "Refresh Fields".
Column 1 : The label of the field that is end user facing in the TermSheet UI
Column 2: The field name. Field name's are the unique identifier for each field. Custom Fields that are unique to the workspace start with "cf_"
- A "TermSheet Ignore" Sheet will appear in the Excel Workbook. This sheet provides a space for exclusions to the publish/pull of data. Simply enter the field name (Column 2 above) to a list in either column to exclude that field from being published to TermSheet or pulled back into the model from TermSheet.
- If this model has been mapped in the past, and new fields have been added to TermSheet in the meantime, "Refresh Fields" will prompt an update where any newly added fields will be appended to the bottom of the "TermSheet" Sheet so that they can be mapped if needed.
5. Map fields by creating reference cells. Select a cell in Column 3. Enter = , then navigate to the cell where that field is found within the model. Select the cell, then select enter to save the reference cell formula.
Work down the list, repeating steps 5-6 for all fields that should be mapped from the model to TermSheet.
6. Save the changes to the model template in Excel.
Link an Excel Model to an Existing TermSheet Deal
When creating new models for deals, create the model from the model template that was mapped as shown above.
-
Open the Excel model. If it was created from the mapped model template, the fields will already be mapped.
-
Select Manage Deals from the TermSheet Add-in Sidebar.
-
Search for the existing deal using the search bar.
-
Select the + icon next to the deal to link it. If the wrong deal was selected, use the trash icon to remove it.
-
Select Publish to TermSheet. A message in the add in toolbar will appear to show that the file is processing. A confirmation message will appear when the data has been successfully published to TermSheet.
Once the model is mapped to the deal, changes can be made directly in the model or directly in TermSheet and synced bi-directionally by publishing to TermSheet or pulling from TermSheet.
Add New TermSheet Fields to the Excel Template Model
Select “Refresh Fields” to populate a complete list of all existing TermSheet fields from the workspace into the TermSheet tab in the Excel workbook.
Typically, users will opt to refresh fields to include newly added custom fields to the mapped model template or individual deal models.
Any new TermSheet custom fields will be appended to the bottom of the workbook.
