Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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).  

(warning) 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.    

...

ExpressionWill Exclude
.*All accounts.
ABC.* All accounts that start with ABC
(?!^ABC).*All accounts that do not start with ABC
(?!^ABC)(?!^XYZ).*All accounts that do not start with ABC or XYZ
^[0-9]+$All numeric accounts
^.*CAD$All accounts ending in CAD
ABC[0-9][0-9][0-9]All acounts starting with ABC followed by three digits
(?!ABC12345)ABC.*All accounts starting with ABC, except for ABC12345

...

(warning) 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.

Image Added