Credit Card Reconciliation that needs help automating matching to chart of accounts

Hi,

I have a spreadsheet to reconcile credit card statements that I am trying to make a bit more efficient and link in to our chart of accounts. At the end of the day, I need the report to look at the vendor/or keywords in the description and automatically return the chart of accounts that it most likely corresponds to.

A lot of the statement charges or "vendor" are the same each month. For example, every month we have a charge from a software company, but the amount varies each month. The statement also has recurring charges that are exactly the same (same vendor and same amount). Additionally, there are some common phrases (like grocery or garage, or glass) that might pop up in the vendor name or description that could be easily tied to a specific account in our chart of accounts.

Before I get started down a rabbit hole, does anyone have some tips/recommendations on how to go about it?