The table below contains the menu options that are available within the Import blotters. In addition to the menu option, it also includes a general description of the menu functionality, what blotter(s) it can be found on, and when available, additional information found elsewhere in Help.
Tip Use CTRL+F to quickly find a menu option by name.
|
Menu Option |
Description |
Found in Blotter |
Additional Help Reference |
|
Account: <Drop Down> |
This gives you the option to view a specific account that was included in the cost basis reconciliation or All Reconciled Accounts. |
Lots Blotter: |
|
|
Action: Change Price Source to Imported Price |
After putting a check next to a security or multiple securities, you can change the price source from Imported Price to Morningstar Price. |
Securities Blotter: |
|
|
Action: Change Price Source to Morningstar Price |
After putting a check next to a security or multiple securities, you can change the price source from Imported Price to Morningstar Price. |
Securities Blotter: |
|
|
Action: Delete |
Deletes the selected line items. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: |
|
|
Action: Exclude Holding |
Excludes a holding from positional reconciliation or cost basis reconciliation. |
Lots Blotter: |
|
|
Action: Export |
Gives you the option to export to Excel or CSV file. If nothing is selected in the current blotter, all line items will be exported. You can also select specific line items to export. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
Action: Generate Closing Transactions |
Once an account has been closed at the custodian, you can use this option to generate deliver-out transactions to close the positions. This can only be used when using the ‘All Posted Accounts in Morningstar’ reconciliation option and the line items have a red flag in the closed column. |
Positions Blotter: |
|
|
Action: Generate Distributions |
This is available for the DST FAN Mail import interface only. DST sends down the Fixed Annuity values each month but no transaction is sent down to account for the value difference. This utility is used to generate distribution reinvest transactions for Fixed Annuities that have a negative reconciliation Out of Balance. Transactions will only generate for Fixed Annuities. |
Positions Blotter: |
|
|
Action: Generate Initial Transactions |
When a new accounts comes in to Morningstar, you can use this option to generate deliver-ins to open the positions. |
Positions Blotter: |
|
|
Action: Include Holding |
If a holding has been excluded from positional or cost basis reconciliation, you can re-include it by choosing this option. |
Positions Blotter: Lots Blotter: |
|
|
Action: Print |
Will print the current screen. If nothing is selected in the current blotter, all line items will be printed. You can also select specific line items to print. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
Action: Replace Holding |
Commonly used for security CUSIP/ticker changes. This will replace the security on the original holding transactions with the new security. You will not see any historical transaction for the original holding within this account when you use this option. |
Positions Blotter: |
|
|
Action: Save as User-Defined |
Creates a user-defined security that will be used instead of a Morningstar tracked security. |
Securities Blotter: |
|
|
Cost Difference Tolerance |
Gives the reconciliation a share tolerance to reconcile within. If the difference between the custodian and Morningstar is inside this tolerance, you will not see an out of balance. The default is a .01 tolerance. The other options are .001, .0001, & .00001 tolerances. |
Lots Blotter: |
|
|
Export: Export to CSV |
Exports the current blotter to a CSV file. If nothing is selected in the current blotter, all line items will be exported. You can also select specific line items to export. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
Export: Export to Excel |
Exports the current blotter to an Excel file. If nothing is selected in the current blotter, all line items will be exported. You can also select specific line items to export. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
Go |
Starts the reconciliation process. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: |
|
|
Include Share Tolerance |
Having this box checked will reconcile to the .01 share tolerance. If you deselect this option, you can reconcile the share balance to include fractional shares. This allows you to close an account that may contain a fraction of a share. By default, the Include Share Tolerance is checked. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: |
|
|
New Transaction |
After selecting a line item in the transactions blotter, you can use this option to create a new transaction for the same account. |
Transactions Blotter |
|
|
Post |
This option posts data from the New Accounts, Transactions, Prices and Security blotters. There is no way to post partial information. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
Price Lookup |
If a Deliver-In, Deliver-Out, Credit of Security, and/or Dividend Reinvestment transaction is missing a price, you can use this tool to allow the program to look up a price. This is used if you receive a Transaction Price Missing warning message. |
Transactions Blotter |
|
|
|
Will print the current screen. If nothing is selected in the current blotter, all line items will be printed. You can also select specific line items to printed. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
Reconcile Historical Date |
If you are importing multiple dates or a past date, this allows you to pick a historical date to reconcile as of and excludes any transactions that imported after the file date you are currently reconciling. |
Positions Blotter: |
|
|
Reconcile: All Posted Accounts in Morningstar |
This option, also known as Comprehensive Reconciliation, reconciles every account that has ever been imported into Morningstar from the Interface you are currently importing. This option is used to catch accounts that are closed and dropped from the custodian's feed without the necessary closing transactions being provided in the custodian’s files. This option does not need to be run every day, but should be run periodically to check for dormant accounts in Morningstar that should be closed. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: |
|
|
Reconcile: Imported Accounts |
This option, also known as Normal Reconciliation, is the default option. Use this option to reconcile all the accounts that have been imported for the current import session. Imported accounts with no transactional activity will still be reconciled. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: |
|
|
Reconcile: Imported Activity Only |
Also known as Quick Reconciliation, this option reconciles only the accounts that have transactional activity for the current import session. Accounts that have no transactions for this session will not be reconciled. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: |
|
|
Re-initialize Lots |
This creates a Debit of Security for the total shares open, and Credit of Security for each open lot that the custodian is reporting. These credits and debits are dated for the file date you are importing; therefore gain/loss reports will only be accurate from this date forward. |
Lots Blotter: |
Importing and Reconciling Tax Lot Data in Morningstar Office |
|
Save |
Saves any changes that have been made. |
Accounts Blotter: Positions Blotter: Transactions Blotter Prices Blotter Securities Blotter: Lots Blotter: |
|
|
This tool will scan for any imported, closing transactions that have occurred for holdings with a "Specified" accounting method set within Morningstar Office. When the scanning process completes, these transactions will be flagged so that you can specify the open lot(s) to close. |
Transactions Blotter |
|
|
|
Split Initialized Lots |
Splitting Initialized Lots is a process by which users can simply override open tax lot data (that is either price, number of shares or acquisition date) in Morningstar Office with the data the custodian provides. The system breaks out a deliver-in transactions into multiple deliver-in transactions that represent the individual lots. This detailed and precise process results in Office data most accurately mirroring the custodian data. Partially closed lots cannot be split, however you can manually update the transactions related to those lots. |
Lots Blotter: |
Importing and Reconciling Tax Lot Data in Morningstar Office |
|
Update Cost to Match Custodian |
Creates an Adjust Cost transaction so Office’s cost basis matches the custodian. |
Lots Blotter: |
Importing and Reconciling Tax Lot Data in Morningstar Office |
|
View |
Allows you to view all reconciled accounts or specific accounts that have been included in the Cost Basis Reconciliation process. |
Lots Blotter: |
|