Securities Historical Activity Report

Updated on 13 Sep 2023
Contributors

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Securities Historical Activity Report

This report provides information about the historical activity for any securities in FIMS. When you run the report, you can select the type of information you want to include (for example, unposted Gifts, unposted proceeds, restrictions, comments, or broker information).

NOTE: This report is only available if you have the optional Stock Gift Management module.

NOTE: You can access this report from anywhere in FIMS by selecting Reports > Gifts > Securities Reports > Securities Historical Activity Report.

Securities Historical Activity Report Fields

Field	Description
Ticker	The security’s ticker symbol.
Security Name	The name of the security.
CUSIP	The security’s unique, nine-character identification number (CUSIP).
Security Type	The security’s Type code.
Sec ID	The security’s ID code.
Original Value	The total initial value of the security when it was acquired.
Original PAR / Shares	The number of shares in the initial acquisition (or PAR value for fixed income investments).
Original Price	The price per share and date of the initial acquisition.
Acquisition Date	The date of the initial acquisition.
Date Held Through	The date when the stock was sold or transferred.
Current Value	The current total value of the security.
Current PAR / Shares	The number of shares that are currently held (or PAR value for fixed income investments).
Current Price	The current price per share.
Current Price Date	The date when the current price was calculated.
Activity	The type of activity that took place (for example, Acquire, Proceeds, or Revalue).
Activity Date	The date when the activity took place.
Value	The total value associated with each activity. For example, the Acquire value is the same as the Original Value and the Proceeds value is the amount that was received when shares were sold.
Shares	The number of shares that were involved in the activity.
Price	The price per share associated with each activity.
Date Posted	The date when the activity was posted.
Reference #	The reference, deposit, or confirmation number for the transaction.

Running the Securities Historical Activity Report

1. In the Donor and Gift Management module, select Reports > Gifts > Securities Reports > Securities Historical Activity Report. The FIMS Report Selections window opens with the Include tab selected.
Include Tab

2. Select or clear any of the following checkboxes to determine what will appear on the report:

Include Gift Information: Adds the Gift Number, Donor Name, and Fund ID and Name to the report. This information is listed just below the values for each security.
Include Unposted Gifts: Adds information about securities from unposted Gift records to the report.
Include Unposted Proceeds: Adds values for recorded, but unposted proceeds to the report.
Include Restrictions: Adds any restrictions on the security to the report.
Include Comments: Adds any comment text for the security to the report.
Include Broker: Adds the Broker ID code to the report.
Include Custodian: Adds the Custodian ID code to the report.
Include Revaluations in Activity: Adds any revaluations that have taken place to the report.

3. Once you have selected all of the desired information, complete the process for setting up your report, and then click the Run Report button.

Was this article helpful?

What's Next

Securities Historical Pricing Report