It is always inspiring to read mail from our members and learn about various interesting ways they are using Excel. Sovan built on this concepts and developed an expense sharing worksheet that you can use.Ĭlick here to download the expense sharing excel file. In tracking and sharing expenses using excel post, we have described how you can use MS Excel to findout how to share expenses among your friends or colleagues. Sharing Expenses among Friends using Excel Download the household budget spreadsheetĬlick here to download the household budget excel file. Again, another technique from Sort and Display chart data automatically post. In this, the expenses are sorted from highest to lowest and grouped by category. There is an “analysis” worksheet where you can see some graphs based on your expenses. For this, Sovan uses Conditional Formatting. You can also highlight expenses above certain pre-defined amount. Sovan uses the circular reference formula technique we described in that post. As you enter the expense, the time stamp is automatically generated (read automatic timestamps in excel). Using this spreadsheet, you can track your expenses. So here they are, Household Budget Spreadsheet I immediately asked him if it is ok to share these files with our community and he is more than happy. Naturally I got excited to see such prudent use of excel. Sovan, one of our blog readers from Chennai, India, sent me 2 excel budgeting spreadsheets. But I am here to tell you fun ways to track expenses and household budgets using spreadsheets. So when we got our first job (did I tell you that both Jo and I started working in same company and sat in same floor? Oh, it was such a lovely time), we were very prudent and decided not to waste money on anything trivial (we still are, just that over last 6 years our earning capacity increased a bit and we became parents).Īnyways, I am not here to bore you about my household. Our upbringing has taught us value of money in the most effective way – by exposing us to not having any. PHD and I come from very modest backgrounds. If your car registration is due in January, for example, then your car rego category would only have a value under January, the rest of the year would be 0.At PHD household, we believe in using money wisely. I’ve typed in some data to show you what it will look like, but you wouldn’t just type the same thing for each month. You will notice that the formulas change automatically as you add your data (tip: use the fill handle to copy values across your budget). If there are months where the income or expenses are zero, then type 0 – this will ensure that the average calculates properly. If you’ve been tracking your expenses, then use the information to fill in your budget. Type in expected income and expenses for each month. So you want to make sure there are no calculation errors in your spreadsheet.ĭo this by entering easy data like $10 into various parts of your spreadsheet and making sure all the formulas calculate correctly. The budget decisions you make are only as good as the data you’re relying on. Save As again to create a budget just for this year. Save As now and you will have a template that can be reused every year. Tip: if you type January and click on the small black box (fill handle) in the bottom right-hand corner of cell B2 and drag it across, it will fill in the rest of the months for you without you having to type them. Next, type the months along the next row, staring at B2. Start a new document and give it a heading like Budget. Make sure to customise the spreadsheet expense and income categories to your personal circumstances. Steps Building A Basic Home Budget Spreadsheetīelow are the steps, accompanied with diagrams, to creating a basic home budget. 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. If you don’t have Excel, then the free alternatives ( Open Office or Google spreadsheets) are pretty similar and this tutorial should still be helpful the functions will just be in different menus.ĭisclaimer: This is general information only. The tutorial is based on the latest version of Excel, so if you’re using the older version of Excel, you will find the same functions in the toolbar and menu bar. This tutorial starts from the very beginning for those who have never met a spreadsheet before. When you create your own budget yourself, you can customise it to meet your own needs and circumstances exactly. I have been using it now for over a decade. Excel is an awesome program for personal budgeting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |