Back	Home > Tamarac Reporting > Data Setup & Calculations > Data Setup > Cash & Securities > Create, Edit, or Delete a Manual Security Snapshot

Create, Edit, or Delete a Manual Security Snapshot

Contents

Introduction

Clients who have agreed to provide capital to a venture capital fund will generally need to make contributions over a specified time period to satisfy the terms of the agreement. You can track the payment information in Tamarac Reporting on the Committed Capital report.

Tracking committed capital requires some basic setup before the securities appear on the Committed Capital report. This page provides instructions for step 3, creating a manual security snapshot to track transactions for the security.

For more information on all the steps to track committed capital, see Committed Capital Securities.

You can also use manual security snapshots to track activity for other manual securities. For more information about using manual securities and manual security snapshots in general, see Manual Securities and Manual Security Snapshots.

Create a Manual Security Snapshot

After you've added the security to Tamarac Reporting and assigned it to an account, you can create a manual security snapshot and track transactions for the committed capital security.

To create a manual security snapshot, follow these steps:

1. On the Setup menu, under Security Settings, click Manual Security Snapshots.

2. In the Find data for list, select the account for which you want to create the manual security snapshot. You only can create a manual snapshot for accounts.

3. In the Actions list or on the grid, click Create New Snapshot.

   

4. On the Create Snapshot page, click:

   • ActualIf this snapshot is for actual data. Only one snapshot can be set to Actual per day for each security.

   • EstimateIf you want to provide your client with an estimate so they can see their full financial picture, or if you have been given an estimated valuation prior to receiving complete data.

   You can have both an actual and an estimated snapshot for each day.

5. Select Active to reflect this snapshot in reports. Otherwise the snapshot information will only be visible internally on the Manual Security Snapshot page.

6. Complete any of the following information:

   Security (required) Funding Account Date Global Notes and Notes Total Market Value Reset Cost Basis Return Of Principal

   Contributions/Capital Called Other Contributions Withdrawals/Distributions Fees Misc Expense Tax Withheld Interest Paid

   Dividends Paid Long Term Realized Gains Short Term Realized Gains Reinvested Distributions Reinvested (check box) Recallable Distributions

7. Click Save.

Create Multiple Manual Security Snapshots Through Upload

You can efficiently create or modify snapshots in bulk with a Manual Security Snapshots bulk upload. For steps on how to edit data using an upload, see Upload Bulk Data.

To add create manual security snapshots using a bulk upload:

1. On Reports, under Global Reports, click Bulk Reports.

2. Create a Manual Security Snapshot bulk report. Include the desired columns.

   • If you want to edit an existing snapshot, make sure to include the Account Number and Upload Security ID. This will match the changes with the correct snapshot.

   • If you want to create a new snapshot, make sure to include the Account Number and Symbol columns. This matches the new snapshot data with the correct account and security.

   • You can also include the Upload Actions column to more specifically control the actions performed. For more information, see Upload Actions When an Upload Edits Existing Snapshots and Upload Actions When an Upload Creates New Snapshots.

   

   Notes

   • If you fill in the Global Notes column, all other notes will be overwritten.

   • If you enter a total market value, Is Valuation must be set as Yes.

   For more information about bulk reports, see Understanding Bulk Data Exports and Bulk Report Descriptions.

3. Save the bulk report.

4. Generate the bulk report.

5. Open the CSV file on your computer. Remove any data for snapshots you don't want to change. Edit or add data to the included columns to make the desired snapshot changes.

   

6. In Tamarac, under Setup, click Upload.

7. In Add an upload data set, choose Manual Security Snapshot.

8. Select the Data source and use the edited CSV file from your computer to add data to the upload. For more information about creating upload data sets, see Understanding Bulk Data Uploads.

   

Upload Actions When an Upload Edits Existing Snapshots

To edit existing snapshots in bulk, you can create an upload that is matched to an existing manual security snapshot. When you enter actions in the Upload Actions column for a matched snapshot, the actions have the following impact:

• Create: Updates the matched snapshot.

• Update: Updates the matched snapshot.

• Delete: Deletes the matched snapshot.

• (leave the cell blank): Updates the matched snapshot.

Upload Actions When an Upload Creates New Snapshots

When you create entirely new manual security snapshots in bulk, the upload is not matched to an existing snapshot. When you enter actions in the Upload Actions column for a new snapshot, the actions have the following impact:

• Create: Creates a new snapshot.

• Update: Creates a new snapshot.

• Delete: No action taken.

• (leave the cell blank): Creates a snapshot based on the fields edited.

Edit a Manual Security Snapshot

To edit a manual security snapshot:

1. On the Setup menu, under Security Settings, click Manual Security Snapshots.

2. In the Find data for list, select the account or group with the snapshot you want to edit.

3. In the Security column, click the name of the security you want to edit.

   

4. Complete any of the following information:

   Report As Actual/Estimate Active Security (required) Funding Account Date Global Notes and Notes Total Market Value

   Reset Cost Basis Return Of Principal Contributions/Capital Called Other Contributions Withdrawals/Distributions Fees Misc Expense Tax Withheld

   Interest Paid Dividends Paid Long Term Realized Gains Short Term Realized Gains Reinvested Distributions Reinvested (check box)

5. Click Save.

Delete a Manual Security Snapshot

To delete a manual security snapshot:

1. On the Setup menu, under Security Settings, click Manual Security Snapshots.

2. In the Find data for list, select the account or group with the snapshot you want to edit.

3. Select the check box next to the snapshot(s) you want to delete.

4. In the Actions list, choose Delete Snapshots.

   

5. In the confirmation dialog, click Delete.