Define Detail Rollups from imported transactions

Use the Description Miner feature to assign transactions to meaningful groups for use in cash forecasting, cash flow analysis, and reporting. For each imported transaction, you can search the Descriptions, BAIs, and bank accounts to identify similar transactions (or "mine the data") and group them into a Detail Rollup field.

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

  2. Click Description Miner.

  3. Select the Detail Rollup option.

  4. Click See unassigned transactions to view all transactions that have not been assigned a detail rollup.

  5. Click Add Record to set up a new method to extract data from a transaction. A new blank, additional record is added to the bottom of the table.

  6. Enter the Order number to indicate the order in which the rules are applied.

  7. Click the applicable field in the Detail Rollup Name drop-down menu.

  8. Enter search text for the Detail Rollup Search Term field. Any transaction that contains the search text in the Description field is assigned to the respective detail rollup.

  9. To filter specific days of the week, select the applicable weekday (or All) in the Weekdays field. All weekdays are included by default.

  10. To filter only debits or credits, select the applicable transaction type in the DB/CR drop-down menu. All transaction types are included by default.

  11. To filter certain Bank Administration Institute (BAI) codes, select the applicable code in the BAIs to apply to drop-down menu.

  12. To filter certain bank accounts, select the applicable account in the Bank accounts to apply to drop-down menu.

  13. Select the Enabled checkbox to verify the rule is applied. Clear the Enabled checkbox to save the rule but disable it.

    NOTE: The number in the Count column indicates the number of instances the rule identified.

    NOTE: The number in the UID column provides a Unique ID number that is used in the database.

  14. Click Save to save any changes and added records.

  15. Click OK to confirm the saved data.

  16. Refer to Run Description Miner to apply the rules defined above.