Back	Home > Tamarac Reporting > Data Setup & Calculations > Data Setup > Cash & Securities > Ignore Cost Basis Reset Transactions

Ignore Cost Basis Reset Transactions

Contents

Introduction

If you maintain accounts, groups and securities in Tamarac Reporting, you can ignore the effects of Cost Basis Reset transactions from reporting in Tamarac Reporting.

To request this feature, please contact your Tamarac service team.

Enable Cost Basis Reset Transactions to Be Ignored

The following transactions are created when a cost basis is updated:

• A debit, to close the position

• Credit of security transactions for each open trade lot, including the applicable cost basis and original trade date

The cost basis reset matching process runs either at the end of the Tamarac Reporting sync or when the Transactions data set is uploaded. Because you are replacing transactions, the cost basis reset process can affect calculations on reports in Tamarac Reporting.

Match for Cost Basis Reset Transactions

Your cost basis reset transactions will automatically be flagged as custodian lot adjustments. The net transactions are matched if they meet the following criteria:

• Same security

• Same transaction date

• Net shares matching

• Net market value matching

The transactions that do not meet the criteria can be excluded by using an upload data set.

Effect of Ignoring Cost Basis Resets on Reports

Once the feature is enabled, transactions may appear differently on certain pages and reports:

Edit a Report to Exclude Cost Basis Reset Transactions

To ignore cost basis reset transactions:

1. Open the Transactions report:

   • On the Reports menu, click Transactions, or

   • On the Client Reporting menu, click Templates, then select your template or create a template with a Transactions section.

2. Clear the Custodian Lot Adjustment check box.

   

3. Click Save.

Exclude Debits or Credits from the Matching Process in Bulk

To manually exclude your transactions from the matching process, you can create an Account Transactions bulk report and include columns for Transaction ID, Activity Type, and Custodian Lot Adjustment.

After you've run the bulk report, you enter No in the Custodian Lot Adjustment column to exclude credits and debits from the matching process and then upload your data into Tamarac Reporting.

You will need to complete two tasks for uploading—prepare the file for upload and then upload the data set.

Prepare the File for Upload

To prepare the data set that you will upload into Tamarac Reporting, follow these steps:

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

2. Click Edit next to a report you usually use to upload account information. If you haven't created a bulk report, see Understanding Bulk Data Exports.

   

3. Under Account - General, click the Custodian Lot Adjustment column and then click .

4. Click Save.

5. Click Run Report to run the report. When you open the report, you'll see the columns you selected.

6. In the Custodian Lot Adjustment column, type No. This excludes the credit or debit from the matching process for custodian lot adjustments. If the field is blank or says Auto, it will also allow the cost basis reset transactions to be ignored.

7. When finished, click Save.

Upload the Data Set

To upload the file you've prepared into Tamarac Reporting, follow these steps:

1. On the Setup menu, click Upload. If you haven't used uploads before, see Understanding Bulk Data Uploads.

2. In the Add an upload data set list, click Transactions and then click Add.

3. Click Browse and double-click the file that you've prepared for upload.

4. Click Upload.