Transaction History Report

Overview

NOTE:

The Transaction History Report shows all transactions or a selected set of transactions for an individual account, client, or group of accounts. You can run the report manually or you can subscribe to it, so it will run daily after 8:00 AM Eastern time. Also, if you subscribe to the report, you can choose to downloaded it automatically to a directory or folder of your choice.

Your parameter selections display at the top of the report, so you have a frame of reference for the following transaction information contained within it. The report output is not sortable and is presented according to account number. There is a header for each account, which contains the following information:

Column Description
Account # Displays the number of the account.
Account Source Displays the source of the account. Options are: Fidelity Brokerage, NFS, Fidelity Annuity/Life Insurance, Fidelity 403(b)/401(k), and CGF Donor Advised Fund.
Primary Account Holder Displays the name of the primary account holder.
Registration Displays the registration type of the account, such as Corporate or Individual, followed by the associated Code in parentheses.
Short Name Displays the short name(s) of the primary account holder. NOTE: Short Name reflects the preference you establish on the Short Name Display screen (User Menu > User Preferences > Short Name Display), which is FBSI Short Name and/or Custom Short Name. If both checkboxes are selected, the format is Custom Short Name/FBSI Short Name.

The following transaction information displays for each account:

Column Description
Account Type Displays the type of account; options are DVP/RVP, Cash, Margin, Short, Long, Restricted Securities, Financing, Partially Called Bonds, When-Issued Securities, Div/Int Disbursement, Fixed Deferred Annuity, Variable Deferred Annuity, Defined Contribution (401k/403b), Charitable Gift, FILI - Insurance, FILI - Annuities, Variable Life, Fixed Income Annuity, and Variable Income Annuity.
Commission Displays the dollar amount of any commissions made on the transaction.
Entry Date Displays the date the transaction was entered. NOTE: For an adjusted transaction, it reflects the date of the adjustment.
Net Amount Displays the net dollar amount of the transaction in US dollars.
Quantity Displays the number of shares/dollars in the transaction.
Security Description Displays the description of the security, annuity/insurance fund, or charitable gift pool, usually indicating the name of the issuer.
Settlement Date Displays the settlement date of the transaction.
Trade Date Displays the trade date of the transaction.
Transaction Displays a short description of the transaction, such as Journaled, You Bought, You Sold, or Dividend Received.
Top

Accessing and Running the Transaction History Report

NOTE:

  1. Select Reports & Alerts > Reports > Legacy Reports. The Main Reports Screen displays.
  2. If the section is not already expanded, select the plus icon in front of the Transaction Reports entry in the Table of Contents to display the list of reports available to you. NOTE: The icon changes to a minus.
  3. Select the Transaction History Report link to display its parameters in the Report Parameters section of the screen.
  4. Make your parameter selections.
  5. When you complete your selections, select the Save button if wish to save the settings so you can run the report again without needing to re-establish the parameters. NOTE: If you wish to subscribe to the report, go to the Subscribing to the Transaction History Report section. Otherwise, proceed to the next step.
  6. Select the Run Report button to manually run the report. NOTE: Reports run asynchronously. Therefore, when you queue a report to run, it does so in the background and you can continue to use other platform functions. A message posts in the Message Center notifying you when the report completes or encounters an error.
  7. Select the Refresh link to update the Completed Reports list, display the report within it, and update the Status column (if applicable).
  8. If the Report Name displays as a link, select it to view the contents in a separate window. NOTE: The link is not available if the report is In Process or encountered an Error.
Top

Subscribing to the Transaction History Report

NOTE: Select the Cancel and return to Completed Reports link at any time to exit this screen without running the report and display the Main Reports screen.

If you choose to subscribe to the Transaction History Report, it is generated daily after 8:00 AM Eastern time. Also, if you subscribe to the report, you may choose to download the report automatically to a designated folder in addition to its being available on the Main Reports screen.

  1. When making your parameter selections, select the Subscribe radio button.
  2. Select the Save button.
  3. A pop-up warning screen displays prompting you that saving the new parameters will overwrite the existing settings.
    Select the Cancel button to close the pop-up, ignore any changes, and return to the Transaction History Report Parameters screen.
    OR
    Select the OK button to proceed with the changes to the settings. A Save Successful pop-up displays; select the OK button to close this verification screen and return to the Transaction History Report Parameters screen.
Top

Scheduling the Automatic Download of the Transaction History Report

NOTE:

If you subscribe to the Transaction History Report, you can choose to download the report automatically to a directory of your choice. The Profiler service makes the first check for the report approximately ten (10) minutes after its scheduled run time of 8:00 AM Eastern time. If the report is not available at that time, the service continues to poll for the report for up to fifteen (15) times at five (5) minute intervals before abandoning the process. If the report is not generated in this timeframe, you must download the report manually from the Completed Reports List on the Main Reports Screen when it is available.

  1. When subscribing to the report, select the Automatically Download Report checkbox to select the automatically download the report to a designated folder.
  2. Enter the path to the desired folder in the Download Directory text field.
  3. Select the Save button.
  4. A pop-up warning screen displays prompting you that saving the new parameters will overwrite the existing settings.
    Select the Cancel button to close the pop-up, ignore any changes, and return to the Transaction History Report Parameters screen.
    OR
    Select the OK button to proceed with the changes to the settings. A Save Successful pop-up displays; select the OK button to close this verification screen and return to the Transaction History Report Parameters screen.
Top

Saving the Report Parameters

You can save your parameter settings in the event that you want to manually run the report on many occasions without entering the same criteria each time. If you prefer to generate the report on a daily basis, you can subscribe to it using the saved parameters. Also, if you subscribe to the report, you can choose to downloaded it automatically to a directory of your choice.

  1. After making your parameter selections, select the Save button.
  2. Select the Cancel button to close the pop-up, ignore any changes, and return to the Transaction History Report Parameters screen.
    OR
    Select the OK button to proceed with the changes to the settings. A Save Successful pop-up displays; select the OK button to close this verification screen and return to the Transaction History Report Parameters screen.
Top

Changing the Report Parameters

NOTE: Select the Cancel and return to Completed Reports link at any time to exit this screen without running the report and display the Main Reports screen.

If you wish, you can change the established parameter settings for the Transaction History Report.

  1. Select Reports & Alerts > Reports > Legacy Reports. The Main Reports Screen displays.
  2. If the section is not already expanded, select the plus icon in front of the Transaction Reports entry in the Table of Contents to display the list of reports available to you. NOTE: The icon changes to a minus.
  3. Select the Transaction History Report link to display its parameters in the Report Parameters section of the screen.
  4. If you wish to unsubscribe to the Transaction History Report, select the Unsubscribe radio button. NOTE: The unsubscription process occurs in real time; any pending reports are cancelled and the automatic download feature is disabled.
  5. If you subscribe to the report and wish to change the download directory or other settings, make the desired modifications.
  6. If you are not subscribed to the report (generate it manually) and want to change saved report parameters, make the necessary changes.
  7. When all changes are complete, select the Save button.
  8. A pop-up warning screen displays prompting you that saving the new parameters will overwrite the existing settings.
    Select the Cancel button to close the pop-up, ignore any changes, and return to the Transaction History Report Parameters screen.
    OR
    Select the OK button to proceed with the changes to the settings. A Save Successful pop-up displays; select the OK button to close this verification screen and display the Transaction History Report Parameters screen.
Top

Parameters

Parameter Definition
Automatically Download Report Specifies if the report is downloaded automatically. NOTE: This checkbox is associated with the Download Directory text field and enabled if the Subscribed radio button is selected.
Download Directory Specifies the directory or folder used for the automatic download of the report. NOTE: This field is associated with the Automatically Download Report checkbox and enabled if the Subscribed radio button is selected.
Entry Date (Required) Specifies the range for displaying transactions; frame of reference is with respect to the Entry Date of the transaction. NOTE: Selections are: Last Business Day, Last 5 Days, Last 30 Days, Last 60 Days, and Last 90 Days, as well as Custom, where you can enter the dates manually OR use the Calendar icons associated with the From and To fields to establish a custom range. Transaction data is available for up to two years in the past. However, for single account requests, based on the number of transactions within the time period you designate, you may exceed the system limitation of 10,000 rows of data. If this situation occurs, you will get a Partial Complete Status for the report. View the report to determine the time period that was returned and re-run the report for the remaining period. For group and client requests, although transaction data is available for up to two years in the past, you may only access transactions in ninety (90) day intervals during this period.
File Name (Required) Specifies a user-defined name for the report, which may help you to identify it more easily. NOTE: If you do not enter information in this field, the Report Name defaults to the Transaction History Report.
Include Cover Page Specifies whether or not a cover page is created and included with the report when it is generated. NOTE: If requested, the cover page includes the report name, firm name, name of the individual who generated the report, the timestamp or "as of" date and time that the report was generated, and the criteria established when the report ran (such as the selected client, group, or account and the time period of the transactions included in the report (e.g., For Group: All Accounts, All Transactions from 12/11/17 to 12/21/17)). This option is available only when selecting a PDF Report Output.
Report Output Specifies the format in which the report will be created and viewed. NOTE: Selections are: XLS and PDF (the default).
Run Report For (Required) Specifies the Group, Account Number, or Client for which you wish to run the report. NOTE: Use the drop-down list to specify Account #, Group, or Client. If you select Account # and know the number or you select Group or Client and know the name, you can enter this information in the associated field. However, if you do not know or are unsure about this information, select the Account, Group, or Client Lookup link for assistance in completing the field.
Show (Required)

Specifies the transactions types to include in the report. NOTE: Selections are: All Transactions and Transaction Types.

If you choose Transaction Types, make your selection from the following options in the associated drop-down list: Buys, Buys and Sells, Corporate Actions, Deposits, Deposits and Withdrawals, Dividends, Exchanges/Transfers, Fees, Interest, Journal, Other Transactions, Sells, and Withdrawals. NOTE: You can make one or more selections in the list. To select non-contiguous entries: Hold down the CTRL key while you select the desired entries in the list. To select contiguous entries: Select an entry in the list, hold down the SHIFT key, and then select a second entry; all entries between the two are highlighted.

Subscription Status Specifies whether you are Subscribed or Unsubscribed to the report.

855124.1.0

Top