The table below lists information about each column that can be found on the import blotters. The list is in alphabetical order, contains a description of the column, and each blotter that column appears on.
Tip Use CTRL+F to quickly find a column name.
Column |
Description |
Blotters |
+/- |
This shows whether the Morningstar position is more or less than the custodian position. |
Positions Blotter: |
Account Import Setting |
This tells the system whether the account is included or excluded from the import. |
Accounts Blotter: |
Account Name |
Displays the account name that the custodian sends in the files unless the information has been updated within Morningstar Office. |
Accounts Blotter: Positions Blotter: Transactions Blotter Lots Blotter: |
Account Number |
Displays the account number that the custodian sends in the files unless the information has been updated within Morningstar Office. |
Accounts Blotter: Positions Blotter: Transactions Blotter Lots Blotter: |
Account Type |
Displays the account type that the custodian sends in the files. If nothing is sent, the system will default to Taxable. |
Accounts Blotter: |
Active |
This shows whether the security is active or inactive. |
Securities Blotter: |
Address |
Displays the address that the custodian sends in the files. |
Accounts Blotter: |
As Of Date |
The file date of the position file that is used during reconciliation. |
Positions Blotter: |
Asset Class |
The asset class of the security. |
Securities Blotter: |
City |
Displays the client’s city. For a New Account, this pulls from the custodian files. For an Existing Account, this pulls from the account profile within Morningstar Office. |
Accounts Blotter: |
Client |
Displays the name of the client that the custodian sends in the files unless the name has been updated within Morningstar Office. |
Positions Blotter |
Client Name |
Displays the name of the client that the custodian sends in the files unless the name has been updated within Morningstar Office. |
Accounts Blotter: Transactions Blotter Lots Blotter: |
Client Type |
Shows whether the client is an Individual or Institutional client. |
Accounts Blotter: |
Closed? |
This column will only display if you run reconciliation on All Posted Accounts in Morningstar. This column will display a red flag if we are no longer receiving any information in the files from the custodian. You can use the Generate Closing Transactions tool under Action to create Deliver-outs to close the account in Morningstar. See Also: |
Positions Blotter: |
Comment |
Shows any comments that the custodian has sent down regarding the transaction. A comment can be added manually. |
Transactions Blotter |
Commission Amount |
The amount of the commission charged on a transaction. |
Transactions Blotter |
Cost Per Share |
The per share cost basis of the specific lot. |
Lots Blotter: |
Currency |
The currency of the security. |
Securities Blotter: |
Custodian Cost Per Share |
This shows the per share cost basis of the specific lot that the custodian is reporting in the files. Morningstar compares against this in the cost basis reconciliation process. |
Lots Blotter: |
Custodian Position (Shares) |
This shows the total number of shares that the custodian is reporting in the files. Morningstar compares against this in the reconciliation process. |
Positions Blotter: |
Difference from Custodian Shares |
This shows the difference between the total shares that the custodian is reporting versus the total shares Morningstar has. |
Positions Blotter: |
Error Message |
This shows the error message associated with the warning icon that appears in the Status column. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
Gross Amount |
This is the amount of the transaction before commissions/fees. |
Transactions Blotter |
Holding |
This shows the name of the security. |
Positions Blotter: |
Holding Name |
This shows the name of the security. |
Positions Blotter: Transactions Blotter: Lots Blotter: |
Imported Security Type |
This is the security type that the custodian is sending in their files. |
Securities Blotter: |
Imported Security Type Code |
This is the code that the custodian sends to identify the security type. |
Securities Blotter: |
Inflation Index Ratio |
Displays the Inflation Index Ratio, if applicable. |
Prices Blotter |
ISIN |
International Securities Identification Number – a code that uniquely identifies a security. |
Securities Blotter: |
Last Transaction File Date |
The date of the last transaction file that contained transactions for the specified account. |
Accounts Blotter: |
Lot Acquisition Date |
Original purchase date for the lot. |
Lots Blotter: |
Mapped Account Name |
This is the account name that will show in the Account Profile. This can be edited in the Account Profile within an account. |
Accounts Blotter: Transactions Blotter |
Mapped Account Number |
This is the account name that shows in the Account Profile. This can be edited in the Account Profile under Client Management or Portfolio Management for that account. |
Accounts Blotter: |
Mapped Client Name |
This is the Client name that shows in the Client Profile. This can be edited in the Client Default Settings within a Client. |
Accounts Blotter: |
Matching Method |
Displays the matching method (accounting method) if the custodian included it in the files. |
Transactions Blotter |
Morningstar Cost Per Share |
The per share cost basis that Morningstar is calculating based on the transactions and matching method. |
Lots Blotter: |
Morningstar Exchange Name |
This shows the exchange that the security is on. |
Securities Blotter: |
Morningstar Mapped Holding |
If a security is mapped to a Morningstar tracked security, this is the ticker of the security in the Morningstar database. |
Securities Blotter: |
Morningstar Mapped Name |
If a security is mapped to a Morningstar tracked security, this is the name of the security in the Morningstar database. |
Securities Blotter: |
Morningstar Mapped Security Type |
The security type that Morningstar has assigned to the security. |
Securities Blotter: |
Morningstar Pending Transactions (Shares) |
The total number of shares of the current transactions that are being imported. These have not been posted yet and can be found in the Transactions blotter. If you view transactions on the reconciliation results, these transactions will be shown in Green type. |
Positions Blotter: |
Morningstar Position (Shares) |
This is the total number of shares based on the transactions that are in Morningstar. This included both Posted and Pending transactions. |
Positions Blotter: |
Morningstar Posted Transactions (Shares) |
This is the total number of shares based on the Posted transactions only. |
Positions Blotter: |
Morningstar Security ID |
This is an internal identifier. |
Securities Blotter: |
Morningstar Security Universe |
The Research universe that the security is tracked under. |
Securities Blotter: |
Net Amount |
This is the total amount of the transaction after commissions/fees. |
Transactions Blotter |
Number of Shares |
Shows the number of shares applicable to the transaction. |
Transactions Blotter |
Offset Security Name |
This shows the security that a particular transaction is linked to. IE: Cash, Out of Pocket, etc. |
Transactions Blotter |
Option Key Identifier |
This is an identifier sent from the custodian specifically for Option security types. |
Securities Blotter: |
Original Transaction Date |
This would be the date a transaction originally took place; it will be common to see this filled in for Reversals, Deliver-ins, and Credit of Security transactions. |
Transactions Blotter |
Original Transaction Type |
This is the original transaction type; this will most commonly be seen on Reversals. |
Transactions Blotter |
Other Fee |
Any fees charged on the transaction. This is separate from commissions. |
Transactions Blotter |
Per Share Cost Basis |
Displays the per share cost basis; this will most commonly be seen on deliver-ins and credit of security transaction types |
Transactions Blotter |
Per Share Cost Difference |
This shows the difference between Morningstar’s cost per share and the Custodian’s cost per share. |
Lots Blotter: |
Position Type |
This shows whether or not the position type of the holding is Long or Short. |
Positions Blotter: Transactions Blotter Lots Blotter: |
Price |
The price of the holding on the indicated date. |
Positions Blotter: Transactions Blotter Prices Blotter |
Price Date |
This shows the date of the price that is being sent in the Price file. |
Prices Blotter |
Price Factor |
Displays the price factor, if applicable |
Prices Blotter |
Price Source |
Shows whether the security is using Imported Price or Morningstar Price. |
Securities Blotter: |
Principal Factor |
Displays the principal factor, if applicable |
Prices Blotter |
Product Name |
If provided by DST, this is the product name for Variable Annuity Subaccounts. |
Securities Blotter: |
Rep Code |
If the information is sent in the custodian files, the rep code will be displayed here. |
Accounts Blotter: |
Representative Name |
If the information is sent in the custodian files, the representative name will be displayed here. |
Accounts Blotter: |
Security ID |
Displays CUSIP or Security ID |
Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
Security Mapping ID |
This is an internal identifier. |
Securities Blotter: |
Security Name |
Displays the name of the security |
Prices Blotter Securities Blotter: |
Security Type |
Displays the security type |
Lots Blotter: |
Settlement Date |
The date the transaction will settle. This date will import from the Custodian. For manual transactions, Morningstar will default to 3 days. |
Transactions Blotter |
Shares Open |
This shows how many shares are currently held in the holding. |
Lots Blotter: |
Social Security Number |
This shows the social security number of the client that the account belongs to. |
Accounts Blotter: |
State |
Displays the state the custodian sends in the files. |
Accounts Blotter: |
Status |
This will have an icon if there is any error message on the specific line item. Click here |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
Successfully Reconciled Account as of File Date |
Displays the file date that the account last successfully reconciled. |
Accounts Blotter: |
Successfully Reconciled Holding as of Date |
This shows the last file date that the holding successfully reconciled. |
Positions Blotter: |
Ticker |
Displays the ticker |
Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
Total Amount |
This is the total market value of the holding according to the position file sent from the custodian. |
Positions Blotter: |
Total Shares |
This is the total shares of the holding according to the position file sent from the custodian. |
Positions Blotter: |
Transaction Count |
This shows how many transactions are being sent in the transaction files that are currently being imported. |
Accounts Blotter: |
Transaction Date |
The date of the transaction that is being sent in the files from the custodian. |
Transactions Blotter |
Transaction File Date |
The date of the custodian file that the transaction is included in. |
Transactions Blotter |
Transaction Type |
Lists the transaction type. Click here |
Transactions Blotter |
Transaction Type Code |
Code that is sent by the custodian that is translated into a Morningstar transaction type. |
Transactions Blotter |
Update Existing Security |
Allows you to update information, provided via the import, on User-Defined Securities when you change the option to Yes. This does not allow you to update manually changed information within the blotter. |
Securities Blotter: |
Update Name |
Allows you to update the Account Name when you change the option to Yes. |
Accounts Blotter: |
Use As Substitute |
If this is set to ‘Yes’, the system will use the Morningstar tracked security in place of the user defined security. If this is set to ‘No’, the user-defined security will be used in the account. |
Securities Blotter: |
User-Defined Security ID |
Internal code used to identify securities. |
Securities Blotter: |
View Transactions |
You can click on the magnifying glass in this column to view the transactions for the specific holding. |
Positions Blotter: Lots Blotter: |
Zip Code |
Displays the zip code that the custodian sends in the files. |
Accounts Blotter: |