question

tlenzmeier avatar image
tlenzmeier asked

Categorizing ACH Transactions

Hello,

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.

sql-serverlikecharindexpatindex
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.