I am trying to think of a way to derive types of transactions from a daily transaction table. For example, when ACH transactions are posted, there's always a transaction narrative. Within each narrative we have a string often separated by "/". An illustration looks like this:
STATE FARM BANK/PAYMENT/181004/WEB. Another one looks like this:
PITT TUITION/PITTPAYMNT/181005/WEB. The goal is to classify payments into categories such as mortgage, credit card, utilities, etc.. I think a fair amount of manual effort is required, but if I could aggregate similar lines, that would be a huge start. The goal is to capture a category for most of the transactions. The goal is to build a customer profile.