How To Find Recurring Expenses In Credit Card Statements With Excel

It’s hard to find recurring expenses in messy bank and credit card statement data. This tutorial walks you step by step through finding recurring expenses in your credit card statement with Excel. We start by exporting your statement data to Excel and finish with identifying recurring expenses using Excel’s built-in tools. By the end of the video you have a formatted list of recurring expenses in Excel. Please make sure to like, subscribe, and leave a comment letting me know - what else can I help you with in Excel.
🧾 Rocket Money (formerly Truebill) - rocketmoney.sj...
🔔 Subscribe bit.ly/2QCjwXg
👍 Like
😀 Support me with your Amazon purchases amzn.to/2SJ0P5c
Purchasing through these links gives my channel a small commission -- the price to you is the same.
📚 Credit & Inspiration:
-[Article] Myonlinetraininghub DATEVALUE bit.ly/3dBZVlI
-[Video] Trump Excel [FREE Excel Course] Lesson 14 - Text Formulas in Excel • [FREE Excel Course] Le...

[@benfithian659]

My favorite part of this video is how you update and edit the description using a variety of formulas (TRIM, IFERROR, LEFT, PROPER) - really slick. Once you make the formula it’s easy to update every month. Well done sir

[@HowToAnalyst]

Thanks for sharing!!

[@The2screws]

thank you so much this helped me out a lot with my work. I just subscribed

[@HowToAnalyst]

Thanks for the sub, glad it helped!

[@RajDesaiTimelapse]

This becomes really difficult with large data sets. What you could do instead is-
1. List all transactions with the same value AND same description
2. Find the mean and median of the payment intervals
3. Find the last payment made for the transaction
4. If the mean and median of the payment interval is the same, it is a recurring payment
5. To identify which payments are active subscriptions, you can see if the difference between the current date and the date of the payment is less than or equal to the median date because if the difference is higher, you either have a missed payment or no longer use that subscription

[@BethanyCumberland]

do you have anything for text in the middle of a string? for example, if i want to pull out the fees in the below string? Note the fees can vary from 5.00 to 105.00, and the words "fee deduction" is always after the amount
Citibank payment 28.00 fee deduction to China

[@retrorocket2]

how to merge spreadsheet from different organizations with different headers

[@HowToAnalyst]

Possible but much harder and outside the scope of this video. Will add your request to my list.

[@benfithian659]

I wondered why you had a Roto-Rooter charge but then I saw Los Bravos Mexican restaurant.

[@HowToAnalyst]

Too funny!

[@KyleSorenti]

A bit of trivia: the category is determined by something called a MCC code

[@HowToAnalyst]

Just the nerdy type of comment I like to see!