Formula to auto categorise bank transactions

Our take

Hello everyone! I'm looking to streamline my bank transaction management by using a formula to automatically categorize transactions. My main sheet includes columns for Date, Amount, Description, and Category, with the first three populated from my bank download. I'm considering creating a merchant table with corresponding categories, like "Woolworths" for "Groceries." I need a formula that scans the Description for keywords from the Merchant column and then fills in the appropriate Category. Any guidance on making this work would be greatly appreciated! Thank you!

Hi everyone, I'm trying to put a formula in to auto categorise my bank transactions. I have the transactions in my main sheet as:

Date | Amount | Description | Category

The first three are populated from my bank transaction download, and category is where I want the category to auto populate.

I've tried using VLOOKUP but can't get it to work. I'm fine to create a merchant/data table on this sheet or another:

Merchant | Category

Eg:

Woolworths | Groceries

I want the formula to look at the Description cell for any of words in the Merchant cell. When it finds a word, I want it to put the corresponding word in the Category column from the merchant table to the Category column in the bank transaction section.

Thanks

submitted by /u/josephinesparrows
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#AI formula generation techniques#formula generator#generative AI for data analysis#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#bank transactions#category#auto categorise