![]() I used to use spreadsheets like this and they are great for keeping track of where you spent your money, but knowing what happened in the past is really only of limited usefulness. So cut back, and use that found money - which is YOUR MONEY - and save it in an emergency fund, reduce debt, and increase your net worth. I have a hunch that after tracking your expenses, you’ll see the shopping patterns and spending places where you can cut back. I want you to Fall in love with your Personal Savings Rate and increase the percentage of your saved income by not consuming it. ![]() Final Steps: Improve your personal savings rate There are a dozen free downloads, worksheets, and spreadsheets throughout this series to help you get your money on track, so go check it out. I’ve written a whole series on budgeting called: How to Build a Budget. Tally your expenses during the month and add them to the Free Budget Spreadsheet under the right category. Step Three: Add spending totals to your budget Just be sure to track all your cash, credit card, and debit card purchases to see where you’re blowing your dough. It may seem like a lot of work at first, but over time you’ll find that a daily money tracking system is an easy habit to keep. Save your receipts and tally your spends every day. Be an Expense Tracker Step One: Download!ĭownload your preferred tracking method - the worksheet (PDF), spreadsheet (XLS), or both.įill in your spending categories across the top.ĭownload: Track Your Expenses Worksheet (PDF)ĭownload: Track Your Expenses Spreadsheet (XLS) It’s a bummer for this blogger ’cause I’d like to thank him for his idea. The only problem with Stu is every time I reply to his super nice email, my response bounces. The second is a full-on expense tracker spreadsheet that does the math for you. The first is a simple printable worksheet for carrying around in your purse or wallet. Since I like Stu, I went ahead and built him not one, BUT TWO expense tracker downloads. Stu just wants a simple spreadsheet to get his expenses tracked with little fuss and no muss. You see, Stu doesn’t want to link his bank accounts to third-party online budgeting systems or deal with complex budget software programs when it comes to counting cash. He sent me a super nice email asking for a simple solution to his expense tracking dilemma. Change Budget to Goal if you want to use the spreadsheet to track your savings goals.Stu is a smart guy, he asked me for an “Expense Tracker”.The expense tracker can be used for income tracking by making just a few changes to the labels. In the latest version, I changed the date format to the default * format so that dates will display as d/m/yyyy or m/d/yyyy depending on your computer's locale settings.When inserting a new category, insert the new column to the left of the Other column and then copy/paste formulas in the header and total rows. Two of the columns are hidden - to make it easy to insert new expense categories. ![]() This will help make sure the Totals update correctly (you should probably check to make sure you don't mess up the formulas, though). When inserting new rows, insert the new rows above the last empty row in the table (not directly above the Total row).Conditional Formatting is used to highlight every other row, to allow you to easily insert or delete rows and still maintain easy readability of the expense list."Category X") are just labels so go ahead and change them to be what you want. The labels for the expense categories (e.g.Listed below are some of the features or details to note as you are using the expense tracking sheet or the budget tracking chart. I have tried to set up the spreadsheet so that it is easy to insert or delete columns, depending on how many different expenses you want to track. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |