How To Automatically Categorize Credit Card Expenses In Excel

In this video I show you two methods to automatically categorize credit card expenses in Excel. First we create a lookup table in Excel that will be used to automatically categorize your credit card expenses for both methods. Next, I walk you through implementing and updating method 1, then method 2.

⏱Time stamps
0:00 Intro
0:19 Lookup table
2:30 Method 1 Implementation
3:41 Method 1 Update
4:47 Method 2 Implementation
8:40 Method 2 Update

👍 Like

Purchasing through this affiliate link gives me a small commission to support my channel -- the price to you is the same.

[rgagne]

Fantastic presentation! Exactly what I was looking for

[angelgeorge]

Method 1 has been great to add into my expense tracking file to save on the time for categorizing each of my line items. Thanks!!!!

[quantumconsultationcoaching]

very useful. i am an excel dummy and your demo amazing to help me be more efficient !

[benfithian]

You are a get-data master my friend. Always learn a ton from your vids. Thanks for helping me automatically categorize credit card expenses!

[asherlaub]

This tutorial has been immensely helpful, thank you!!

[YouTubeCommenter]

Thanks for the excellent video. I am starting to use your methods in my own excel files and it is going great so far. Thanks for the tips!

[uttyk]

Great video man! Exactly what I was looking for

[ttaylor]

great video, thank you. can you import CSVs from multiple credit card vendors, each with a different format, each mapped & inserted into the same table?

[dango]

This is just awesome. Now just trying figure out a formula to add/group all the transactions under one category to come with a total, (e.g. how much did spend on groceries this month).

[RobertWatkins-vq]

[Expression.Error] The column activity 950.xlsx of the table wasnt found. Got this error when refreshing even thou the data is there

[gunjanstar]

Thank you for this video Pete -I am a complete novice but I am trying to manage my expenses. With your video, I was able to get the help and set up the spreadsheet. However, when I posted the new data as you have shown at 4.08 in the video, the Xlookup only returned Null even when some of the expenses were categorized in the lookup_table earlier. Any thoughts on what I did wrong?

[Jazflyer]

Great video. How would you tackle the problem of say assigning different expense categories to say one vendor, Target for example? I buy a lot of stuff there but it doesn't all fall under just one category. I manually input the category I wish into another column (tried both in the query table and outside of it) but when I refresh data to include my next month's statements, the previously manually inputted expense category changes, ie it moves to a different spot in the table. Thanks in advance

[adnanade]

In bank statement Narration always not remain the same except few words so I want it categorize expenses or income just with specific word so how can we do?

[MsCandiceA]

Hello, This is exactly what I was looking for, however I cannot get excel to accept the formula you have here - the #ALL is problematic etc. Can you tell me what might be incorrect in my data that your formula will not work? I have several categories and 107 lines of transactions.

[originaltasan]

Great video for categorizing, but isn't the most important part of this how to sum the categories so you see the amount of money spent on each category? Did I miss something? How do I see the total for each category?

[ryanl]

Just started following your tutorial but I am stuck for my bank only allows to download csv files.. do you have an updated tutorial? thanks !

[mikeedwards]

Is there a way to do this without using the Unique Values formula?

[finemful]

When I try to use the unique fourmula nothing auto matically populates?

[KyleSorenti]

Finding out where my $ went ☑️
Finding out how to stop to overspend cycle… TBD

[uponsunnah]

Wont work for thousands of transactions. You need a wildcard method especially if you're going to combine data from multiple credit cards.