Import Blotter Columns

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:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Account Import Setting

This tells the system whether the account is included or excluded from the import.

Accounts Blotter:
New Accounts
Existing Accounts

Account Name

Displays the account name that the custodian sends in the files unless the information has been updated within Morningstar Office.

Accounts Blotter:
New Accounts
Existing Accounts
Excluded Accounts

Positions Blotter:
Reconciliations Results
All
Reconciled
Failed
Excluded Holdings,

Transactions Blotter

Lots Blotter:
Imported Open Lots
Reconciliation Results
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Account Number

Displays the account number that the custodian sends in the files unless the information has been updated within Morningstar Office.

Accounts Blotter:
New Accounts
Existing Accounts
Excluded Accounts

Positions Blotter:
All Positions
Reconciliations Results
All
Failed
Excluded Holdings,

Transactions Blotter

Lots Blotter:
Imported Open Lots
Reconciliation Results
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

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:
New Accounts
Existing Accounts
Excluded Accounts

Active

This shows whether the security is active or inactive.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Address

Displays the address that the custodian sends in the files.

Accounts Blotter:
New Accounts
Existing Accounts

As Of Date

The file date of the position file that is used during reconciliation.

Positions Blotter:
All Positions
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Asset Class

The asset class of the security.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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:
New Accounts
Existing Accounts

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
Reconciliation Results
All
Reconciled
Excluded Holdings

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:
New Accounts
Existing Accounts
Excluded Accounts

Transactions Blotter

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Client Type

Shows whether the client is an Individual or Institutional client.

Accounts Blotter:
New Accounts
Existing Accounts
Excluded Accounts

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:
Data Reconciliation Options

Positions Blotter:
Reconciliation Results
Failed

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:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Excluded Holdings

Currency

The currency of the security.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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:
Reconciliation Results
Mismatched Cost Basis

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:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

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:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Error Message

This shows the error message associated with the warning icon that appears in the Status column.

Accounts Blotter:
New Accounts
Existing Accounts

Positions Blotter:
All Positions

Transactions Blotter

Prices Blotter

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Lots Blotter:
Imported Open Lots

Gross Amount

This is the amount of the transaction before commissions/fees.

Transactions Blotter

Holding

This shows the name of the security.

Positions Blotter:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Holding Name

This shows the name of the security.

Positions Blotter:
All Positions

Transactions Blotter:

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Imported Security Type

This is the security type that the custodian is sending in their files.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Imported Security Type Code

This is the code that the custodian sends to identify the security type.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Last Transaction File Date

The date of the last transaction file that contained transactions for the specified account.

Accounts Blotter:
Existing Accounts

Lot Acquisition Date

Original purchase date for the lot.

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

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:
New Accounts

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:
New Accounts
Excluded Accounts

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:
New Accounts
Excluded Accounts

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:
Reconciliation Results
Mismatched Cost Basis

Morningstar Exchange Name

This shows the exchange that the security is on.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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 Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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 Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Morningstar Mapped Security Type

The security type that Morningstar has assigned to the security.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

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:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Morningstar Posted Transactions (Shares)

This is the total number of shares based on the Posted transactions only.

Positions Blotter:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Morningstar Security ID

This is an internal identifier.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Morningstar Security Universe

The Research universe that the security is tracked under.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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:
New User-Defined Securities
Existing User-Defined Securities

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:
Reconciliation Results
Mismatched Lots

Position Type

This shows whether or not the position type of the holding is Long or Short.

Positions Blotter:
All Positions
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Transactions Blotter

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Price

The price of the holding on the indicated date.

Positions Blotter:
All Positions

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:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

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:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Rep Code

If the information is sent in the custodian files, the rep code will be displayed here.

Accounts Blotter:
New Accounts
Existing Accounts

Representative Name

If the information is sent in the custodian files, the representative name will be displayed here.

Accounts Blotter:
New Accounts
Existing Accounts
Excluded Accounts

Security ID

Displays CUSIP or Security ID

Positions Blotter:
All Positions
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Transactions Blotter

Prices Blotter

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Security Mapping ID

This is an internal identifier.

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Security Name

Displays the name of the security

Prices Blotter

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Security Type

Displays the security type

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

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:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Social Security Number

This shows the social security number of the client that the account belongs to.

Accounts Blotter:
New Accounts
Existing Accounts
Excluded Accounts

State

Displays the state the custodian sends in the files.

Accounts Blotter:
New Accounts
Existing Accounts

Status

This will have an icon if there is any error message on the specific line item. Click here  for more information on errors and warnings.

Accounts Blotter:
New Accounts
Existing Accounts
Excluded Accounts

Positions Blotter:
All Positions

Transactions Blotter

Prices Blotter

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Lots Blotter:
Imported Open Lots

Successfully Reconciled Account as of File Date

Displays the file date that the account last successfully reconciled.

Accounts Blotter:
Existing Accounts

Successfully Reconciled Holding as of Date

This shows the last file date that the holding successfully reconciled.

Positions Blotter:
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Ticker

Displays the ticker

Positions Blotter:
All Positions
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Transactions Blotter

Prices Blotter

Securities Blotter:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

Lots Blotter:
Imported Open Lots
Reconciliation Results
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Total Amount

This is the total market value of the holding according to the position file sent from the custodian.

Positions Blotter:
All Positions

Total Shares

This is the total shares of the holding according to the position file sent from the custodian.

Positions Blotter:
All Positions

Transaction Count

This shows how many transactions are being sent in the transaction files that are currently being imported.

Accounts Blotter:
New Accounts
Existing Accounts

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 for more information on transaction types.

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:
Existing User-Defined Securities

Update Name

Allows you to update the Account Name when you change the option to Yes.

Accounts Blotter:
Existing Accounts

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:
Morningstar Tracked Securities
New User-Defined Securities
Existing User-Defined Securities

User-Defined Security ID

Internal code used to identify securities.

Securities Blotter:
New User-Defined Securities
Existing User-Defined Securities

View Transactions

You can click on the magnifying glass in this column to view the transactions for the specific holding.

Positions Blotter:
All Positions
Reconciliation Results
All
Reconciled
Failed
Excluded Holdings

Lots Blotter:
Matched Lots
Mismatched Lots
Mismatched Cost Basis
Excluded Holdings

Zip Code

Displays the zip code that the custodian sends in the files.

Accounts Blotter:
New Accounts
Existing Accounts