Learn how to track expenses in Microsoft Excel automatically by using simple formulas and functions that follows on from my previous expense tracking tutorials.
💰 You can buy my Excel Template that I use in this video at my online store here: https://moneywithdan.etsy.com
This video will show you how to setup automatic categories to your expenses in Microsoft Excel using common formulas and your online bank statements for any date range extracted into a CSV file format. Once your bank transactions are in Microsoft Excel you can use all of the features of Microsoft Excel to organise your data anyway you like, including formulas like VLOOKUP, LEFT and Pivot Tables. Only an intermediate level of Microsoft Excel skills required.
LINKS
💰 Use SHARESIGHT to track your shares - https://www.sharesight.com/moneywithdan/
(BONUS When you signup using this link, the first 4 months of subscription are free if you choose to upgrade to advanced plan and I may get a small my commission at no extra cost to you, so we both win!)
OTHER VIDEOS
Budget and Track Expenses in Excel AUTOMATICALLY and FREE: https://youtu.be/DYsBcwJ9kAs
Excel Pivot Table: Track expenses and BUDGET: https://youtu.be/4XEoOzDwc6M
How to open banks statements in Excel: https://youtu.be/pUo0kO60mB8
Identifying Variances in Excel | What to do if you spent too much money: https://youtu.be/kqxlS-yvPOo
How to Track Expenses in Excel (full tutorial): https://youtu.be/sFZgraCGUSs
How to setup the Barefoot investor buckets | 2 year review with tips : https://youtu.be/BtNFSDoFK1s
Please subscribe to my channel to see more videos from me!
OTHER INFORMATION
Throw away your envelope budget system, highlighters, receipts, and pens and paper. Save more money by tracking your expenses and find out your spending habits and start the new year's resolution to save more money and invest now!
Adding Categories to your extracted bank statement in Microsoft Excel, is the second step to automatically tracking your income and expenses. By obtaining your data electronically you are potentially saving hours of time of writing down, avoiding duplicating data, and tracking receipts daily which gives you time back to focus on the important things in life without having to take your eye off your spending habits.
I created this step by step tutorial after being disappointed with the new tracking tool my bank offered. I was also nervous of uploading my personal bank transactions and details into the cloud application on their mobile phone when it could be hacked - not to mention the ongoing monthly fees.
#budgeting #personalfinance #excel