Define detail rollups from imported transactions

Use the Description Miner 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 dropdown.

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

  12. To filter certain bank accounts, select the condition and the applicable account in the Bank accounts to apply to dropdown.

  13. To include the date of the transaction, select the Include Date? check box and select the Start Date and End Date fields.

  14. To override any manual settings, select the Override Manual? check box.

  15. Select the Enabled check box to verify that the rule is applied. Clear the Enabled check box to save the rule but disable it.

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

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

  17. Click OK to confirm the saved data.

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