Classify expenses based on fuzzy AI match

Hi,

I want to build a workflow which will classify new transactions from my bank accounts into expense categories, based on prior examples i’ve done manually.

The new transactions are in a google sheet, and the data includes information such as the merchant, date, which card was used, amount etc. These fields could be in multiple columns, or i could concatenate them. Of these, the merchant and card used are probably the most predictive.

I have around 3000 prior transactions classified in another sheet. These classified transactions have the same info as the new transactions (merchant, date, card, amount), but they also have one of ~40 different expense categories allocated to each row.

So i want the AI to use these prior transactions as examples to classify the new transactions. This will be a fuzzy match problem, not a pure lookup. I only want the classification if the AI is quite confident. If its not confident, then i want to return “Unknown” and i’ll manually classify them.

I’m wondering if this is possible? I’ve tried, but the challenge i come across is what workflow step do i use to upload the 3000 prior transactions into the context window so that AI can classify new transactions? I only seem to be able to generate prompts where it needs me to list all the examples into the prompt window which is not practical given there are 3000 examples.

Any help or suggestion is greatly appreciated! Thanks!

Hi Daniel,

Thanks for reaching out! What you’re looking to do—classifying transactions based on prior examples—is more suited for a trained model rather than an automation workflow.

Right now, Bardeen doesn’t support training models or retrieving the most similar past transactions dynamically. A better approach would be to upload your dataset to a service that allows similarity search (like a vector database) or train a small ML model to predict expense categories.

Let me know if you’d like some alternative automation ideas within Bardeen! :rocket:

Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

Hey @daniel.j.murphy ,

We have an LLM classifier that can be fine tuned on your data to solve your problem. Is this a recurring business use case that would be worth investing some time and resources into? If so, I’m happy to introduce you to our Sales Engineering team and have it solved for you. Please reach out to me at artem@ our domain.

Artem

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.