Exclusion & Inclusion rules for Accounts and Adjustments on Uploads

As of Version 1.9.7, you can implement Exclusion and Inclusion rules for both ACCOUNTS and ADJUSTMENTS

Excluding data:

You can prevent data from being uploaded by using Exclude rules .  This can be useful if you:

• Receive the same data from more than one source.
• Do not wish to track some accounts or adjustments in PropReports.
• Wish to exclude certain data such as fees from being loaded for specific accounts.

Including data:

Include rules may be necessary if there is a wide-ranging Exclude rule that is preventing the loading of data for specific account(s) or adjustments(s) that you need to import.  

 Important:  Include rules take precedence over Exclude rules, and will OVERRIDE any Exclude rule that would normally prevent data from being loaded.  

To view and edit the Accounts or Adjustments lists, navigate to the Upload > Upload Filters page:

Excluding Accounts 

To specify a single account to exclude, select the Source and enter an Account Id to match. For example, entering 'ACCOUNT123' and selecting Sterling as the source will exclude all activity for that account when importing data from Sterling: 

Once an account is on the "Accounts to Exclude" list, all uploads for that account and source will be excluded, which will affect executions, adjustments, locates, positions (for reconciliation) and buying power entries (if enabled).  

 Important: Note that the Account Id is checked for exclusion before any rename rules are applied.  Also, any data that is already loaded will not be affected.    

Excluding Multiple Accounts

To easily exclude more than one account, you can specify a pattern to match. Here are some examples:

The patterns used are Perl Compatible Regular Expressions.  Their syntax is described in detail here.  

It can be useful to combine an expression with a group.  If you select a group, PropReports will exclude a matching account only if it already exists in PropReports and belongs to that group.

Including Accounts 

You can enter a specific account or a regular expression along with a Source to ensure that data is allowed.  Include rules will always override any Exclude rules that would normally prevent the specified account from being imported.

Example of an Include rule overriding an Exclude rule:

• The Exclude rule of 123* is preventing all accounts beginning with the sequence of 123. 
• If there is a need to allow one specific account beginning with 123, then you could insert the account as Include rule.  Example : 12345678. 
• This Include rule will be checked first, and any data from 12345678 will imported, and then data for any remaining accounts  beginning with 123 will be excluded.

Testing the List

To see whether or not an account will be excluded:

Step 1: Click on the Test an Account Id

Step 2: Select the Source, enter the Account Id and press Test.  

Result: The success or failure of the account test will be displayed, and an example of each is shown below. 

 Tip: The ID of the rule that allows or disallows the account will be displayed in parentheses.

Excluding and Including Adjustments

The concept is the same as Excluding/Including Accounts.  The additional flexibility with Adjustment filtering is that you can specify a Recurring Fee Category as well.

This Exclusion rule would prevent any sources from posting adjustments that would typically populate in the Fee: Dividend category.