![]() Remaining – how much more you have to save to reach your goal.The total amount you have for that savings goal, including your opening balance, expenses and adjustments.Less adjustments – (optional) in case you want to swap money between savings goals.Less expenses – for when you spend some money.Add adjustments – (optional) in case you get extra money to add or want to swap some money between your savings goals. ![]() Your opening balance – how much you’ve already saved.Your Target – the amount you want to save.Put in specific goals you want to save for. (You can click to enlarge the pics).Īlong the side are your savings goals or the things you want to save for. Add your own savings categories down the side of the spreadsheet. Start by creating the headings as per the image below. If you have any questions about Excel, feel free to email me. This tutorial goes into detail on how I set up a savings tracker in Excel, but it assumes some basic Excel understanding. The most important thing is to do what works for you.īelow is the system I use. Now, you can create a much simpler spreadsheet if you prefer, or you can just use an exercise book and pen, which is how I tracked my savings for years. The rest of this post is all about how I do this in Excel. If you’ve calculated how much you need in advance, it’s not essential to track your savings goals unless you like to watch your progress for motivation or you’re a data lover like me. Step one: (this one is the most important) I automate our savings. It’s important to note that this is a two-step system. You should always consult a qualified financial expert when making money decisions to tailor plans to suit your circumstances. In this blog, I share my savings and budget planning and what works for us. ![]() That’s all the time I now spend on budgeting, and yet we now find it easier to stick to our budget than we ever did when I was tracking expenses.ĭisclaimer: This is general information only. Updating this spreadsheet takes me about 3 minutes a fortnight, a few minutes longer if I’m paying bills. These days you can have multiple savings accounts to separate your savings, but I find it easier to manage a single account and then use an excel spreadsheet to allocate a single savings amount to different savings goals and expenses. It’s not essential, but it’s motivating to keep track of your goals. Want to keep track of how much you’ve saved towards your upcoming bills?Įven though I stopped keeping a traditional budget and moved onto a more effective budgeting system, I still like to track our individual savings goals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |