How to track expenses AUTOMATICALLY in Excel | BUDGET SPREADSHEET

Learn how to track expenses in Microsoft Excel automatically by using simple formulas and functions in this step-by-step guide/Tutorial.

In this template I provide links to all my online videos and I also have a section for frequently asked questions and my answers (FAQs). I also include an alternative Data tab for bank downloads with two columns!

(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 BY ME

SUBSCRIBE NOW!!!

OTHER INFORMATION
I will show you how to automate your tracking in Excel by showing you how to download and open CSV files from your bank and then use some simple formulae to format the data in a more usable way that minimises manual work saving you time and money! I will then show you how to display your data in a Pie chart and how to sort by month and year.

I created this 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 when it could be hacked - not to mention the ongoing monthly fees.

CHAPTERS
00:00 How to track expenses AUTOMATICALLY in Excel | TUTORIAL
01:13 Download online bank statements
01:52 Open CSV file in Excel
02:16 Create Expense tracker file in Excel
02:34 Copy and paste CSV file into Data
03:34 LEFT formula
05:26 Create Unique identifiers for categories
06:55 VLOOKUP formula
08:17 Create a Pivot Table
10:07 Formatting a Pivot Table
13:24 Add in a second month of bank data
15:58 Add MONTH and YEAR Formula to organise date in Pivot Table
17:53 Add month filter to Pivot Table
20:08 Create Pie Chart using Pivot Table
20:54 Formatting Pie Charts to look better

#budgeting #personalfinance #excel

[IRmeterman]

This is the most underrated personal finance video on Youtube.

If you grind 3-6 months of past transactions it's almost automatic. I only need to categorize expenses from vacations or odd e transfers. It's also easy to drill down to problem areas in your spending (for me it was pets).

[gaius_marius]

Great tutorial. I was able to set it up for my personal bank and credit card accounts. Thanks!

[kagomekirari]

This is fantastic thank you so much! I will say as someone who literally works with Excel for a living, this can be made much simpler by using a Table in your Data tab. It will automatically copy all your formulas down, and you can make your PivotTable based on the Table rather than a selection of data, which means if you add or delete columns (among other things), you won't have to reset/redefine your data source. Just a lil tip from my experience making my sheet from this tutorial!

[jgcollopy]

Brilliant! After YEARS of manually inputting my expenses data, this is the solution I’ve been looking for. Thank you for sharing this, you have saved me hours of work and improved my excel skills!

[aaliyahtainui]

Hey Dan, I am currently doing my end of year statements because I want a true idea of how I spend and not just a guesstimate. I saw all the comments before really getting into the video and I was insecure and almost clicked off the video; everyone here seems like they have a basic idea of Excel and I really, realllly don't, I just make pretty tables. But I thought I'd try and.. this video within just 20 Minutes (!!) has absolutely upskilled me on excel. Your explanations are in depth and easy to understand and now I have the best reflection of my personal finances. I cannot thank you Liked, subscribed, shared, all of that! Wow thank you :) I'll be using my own little excel sheet for years to come.
This is priceless work you are doing

[gavinackerly]

Excellent Instructions and Template from ETSY! I have been searching for something clear and straightforward. This is it for us, Novices!

[gaps]

Exactly what i was looking for! Thanks for the amazing content

[arunkulli]

The only video that I was looking for, Thanks a ton!

[robertpeschke]

This was so simple. Thank you LOADS! It would have taken me hours to google this on my own. Exactly what I needed.

[levarmorris]

Absolutely lovely- thank you! That was surprisingly fun to watch. 😅
Please share more you're very detailed.

[solomonriley]

This is soo useful, thank you! Nice to have someone talking about money specifically for Australia, I’m subbed!

[knotdavewalker]

I have just realised how many hours of my life I have wasted. Thanks for the Information. you have made my life easier.

[wealthbuilder]

Love it!! I will show this to other members of the family.

[leannemkelly]

Yes awesome Dan. Again think I mentioned a few weeks ago when trawling through all these types of vids that I really appreciated the Aussie accent!! And way of communicating. Your comment to make sure the cells (lines/ rows etc) matched exactly on each sheet helped solve my Vlookup error too😅

[nelisivhey]

Thanks a lot Dan! This helped me a lot. Was looking for a while for an offline version. It took me a few hours to build. But I made it^^

[yarnos]

Awesome simple and direct explanation. Perfect what i was looking

[mallorymcmahon]

I was very nervous about starting an excel spreadsheet to see our income and expense sheet as I did not have a lot of practice besides just data entry. I have never used formulas. I tried creating my spreadsheets based on a couple of different videos. This BY FAR is the best tutorial I have ever seen for excel! I am so thankful for this video I have saved this as my favorites tab to share with a few friends that I know want to do this too!

My question for your Dan: I used my credit card statement for my original model to practice with because we charge everything to it. I would like to be able to add my checking accounts to this as my "income" does not go to my credit card but to my checking account. Is there a way to put it all together? Or do you have a personal opinion on how I should create a sheet that will have the income and expense together? Income in debit account and expenses on credit card? I want to show my husband a side by side on what our positive or negative outcome is each month. Thank you in advance!

[danport]

I like that once it is set up you just need to download another CSV file from the bank and it is automatically refreshes in seconds. Great idea!

[TallJuli]

This is it! I searched for hours to find this exact information! Dan, you want more views? Different keywords and title! This information is well presented, succinct, and easy to follow - thank you!

[jhors]

Thank you for posting this helpful video