Set up exclusion rules

You can refine your search to exclude certain transactions from the Working Capital Dashboard, Cash Flow Report, and Cash Forecast by creating a rule that excludes a transaction when predetermined criteria are met. Treasury Cash Management provides two ways to exclude transactions:

• Set up exclusion rules.

• Indicate exclusions in the Detail Drill window within the Cash Flow Report.

1. On the Treasury Cash Management page, click Administration > Cash Flow/Working Capital.

2. Click Exclusion Rules.

   

   NOTE: The number in the Transaction Count column indicates the number of transactions that conform to the rule's criteria. Click the numbered link to view details of the transactions.

   NOTE: The number in the Order column indicates the order each rule is prioritized.

3. To set up a new rule and its criteria, click Add New Rule.

4. Select Include, Exclude, or Ignore in the Working Capital drop-down list. (Include is selected by default.) Transactions that meet all criteria for the rule follow the setting to be included in or excluded from the Working Capital report.

5. Select Include, Exclude, or Ignore in the Cash Forecast & Cash Flow Analysis drop-down list. (Include is selected by default.) Transactions that meet all criteria for the rule follow the setting to be included in or excluded from the Cash Forecast & Cash Flow Analysis reports.

6. Select In and the account number from the Bank Accounts drop-down list. Select Not In to exclude a specific bank account.
7. Select In and the code from the BAI Cash Codes drop-down list. Select Not In to exclude a specific BAI cash code.
8. Select Debit, Credit, or All in the DB/CR field to include either or all transaction types in your rule's criteria.

9. Select Contains or Does not contain, and then enter the exact description in the Description from the BAI2 file fields for your rule's criteria.

10. Select the Detail Rollup to include or exclude in your rule's criteria.

    NOTE: Criteria for all of these fields must be met to follow the created rule. (The "and" is implied; for example, the account, BAI cash code, and Detail Rollup all must match the indicated field to included/excluded as indicated in the rule.)

11. To include Reportable Fields:
    • Select the applicable field (designated in Administration > Cash Flow/Working Capital > Description Miner) from the Select Field drop-down list.
    • Select the applicable condition (Include or Exclude) in the drop-down menu under Field Values.
    • Enter the search text under Field Values.
12. To indicate a date range for your rule:
    • Select the Enable Dates checkbox.
    • Enter a Start Date and End Date for your Transaction Data Range.
13. To include transactions within a designated amount, select the condition (greater than, equal to, not equal to, less than) for the Flow Amount and the dollar amount.
14. Select which days from which to draw transactions in the Weekdays Included drop-down list.
15. Select the Override Manual Changes checkbox to prioritize the rule over the settings in Detail Drill window within the Cash Flow Report.
16. Select the Enabled checkbox to enable that row's rule.

17. Click one of the save options:

    • To save the extraction rules, click Save.

    • To save and run the extraction rules immediately, click Run Extraction Rules.