Excluding an Account from Import and Reconciliation

You have the ability to exclude an account from Import and Reconciliation. This excludes any transactions from importing and posting for the account and also does not display any reconciliation errors related to this account.

How to exclude accounts from Import and Reconciliation within the Definition Master

These steps only apply to existing, imported accounts.

  1. Click on Tools, Edit Definition Master, Client/Account Mapping.

  2. Locate the account you’d like to exclude.

  3. In the Account Import Setting column, click on Include in Import and Reconciliation. Choose Exclude from Import and Reconciliation.

  4. Click Save.

How to exclude accounts from Import and Reconciliation from the New Accounts blotter

These steps apply to a New Account coming in with your current import that you do not want imported.  You can exclude it from import and reconciliation from the New Accounts blotter.

  1. In the Import Blotter, click on the New Accounts blotter.

  2. Locate the account you’d like to exclude.

  3. In the Account Import Setting column, click on Include in Import and Reconciliation.  Choose Exclude from Import and Reconciliation.

  4. In the Mapped Client Name column, select a client. Note: Selecting a Mapped Client Name is needed to establish the mapping, however, the account will not add within Morningstar; so, if there is not an appropriate client to select, any selected Mapped Client Name will work to establish the mapping. If you want the account to add into Morningstar, but be excluded from import and reconciliation, you would not select a Mapped Client Name.

  5. Click Save.

When you would want to exclude an account from Import and Reconciliation

Re-including accounts that have been excluded from Import and Reconciliation

  1. Click on Tools, Edit Definition Master, Client/Account Mapping.

  2. Locate the Account.

  3. In the Account Import Setting column, click on Exclude in Import and Reconciliation. Choose Include from Import and Reconciliation.

  4. You will receive a warning stating ‘You will need to re-initialize this account by generating the initial transactions in the Reconciliation Blotter if you want to restart posting transactions to this account on an ongoing basis. Are you sure you would like to include this account in import and reconciliation?’  If you want to re-include the account, click OK. If not, click Cancel.

See Also

Generating Initial Transactions

Importing from Microsoft Excel