Pie Chart Check Past
By Spender | June 15, 2008
I’m now on a pretty regular routine with the expense tracker. It’s so simple now that Saver showed me how to use it. And the whole web entry form will be really handy once I’m able to use my iPhone again someday. I am eager to see how this changes my outlook on spending. You know those online pie charts and stats you can monitor regarding your credit or debit card. I seem to only look at those things once a year and think to myself why did I spend all that money going out or on ATM fees. I now look at those stats a couple times a week and enter exactly where and why I’m spending money. It’s a bit harder to shrug off mindless money spending like in my yearly pie chart checking past.
Topics: Budgets/Expense tracking, Spender's Posts | Related Posts: The Numbers, Free Money!, Carnival of Personal Finance
Carnival of Personal Finance
By Saver | June 13, 2008
I submitted my last post to the Carnival of Personal Finance this week. Check it out!!
Topics: Carnivals and Links, Saver's Posts | Related Posts: Friday Night Links, Personal Finance Meets Personal Fitness, Welcome to my (pf) life
Expense Tracking: Using Google Spreadsheets
By Saver | June 8, 2008
I’ve always known that tracking your spending and having some kind of budget is a key part of getting your financial house in order. However, I was never actually successful in doing so, and certainly not successful in getting Spender involved with the idea.
At one point, I tried Microsoft Money, but eventually realized I could build a better system by myself in Excel, one that would do exactly what I wanted it to do (and I will admit I spent a lot more energy making the the spreadsheet more and more sophisticated rather than actually keep on top of my spending). I kept the spreadsheet on my laptop, and would occasionally tell Spender “let’s do our finances tonight.” I would copy and paste most of the transactions from both of our accounts, and ask him what else he’d spent money on. We might do this for a few weeks in a row, but it never lasted more than a month. And while we would occasionally discuss what we should budget each month for different categories, we never got to the point of comparing actual spending to the budget.
But now, despite an early kink, we have a new system is up and running, and this time I’m pretty optimistic. I created a Google spreadsheet with a place to enter the every expense, listing the amount spent along with the date, place and category:
One feature of Google spreadsheets is the ability to easily create a form that enters data into your file. We can just go to a website to enter the info.
Now, I know I shouldn’t get too excited after just one week, because budgeting and expense tracking only works if you can follow through for the long term. However, I think we have a few really good things going for us with this system:
1) Both Spender and I can access it at anytime (at least long as we have our computers). We can both add any spending we do, and we can both keep an eye on how close we are to our budgets.
2) It’s simple. We are starting by tracking disposable income and current spending. It will track our income (in Euros) and our daily spending and that’s all. Our student loans are currently being paid out of our US savings accounts, but I’m not going to try to incorporate that into this sheet. Simple is better. However, it is still flexible enough for us to be able to add anything we thing will be useful.
3) I actually really like the idea of entering expenses manually, because it makes you think about your purchases more than if you just download them from the bank. The Google form makes this super easy, and I don’t think it will take more than a few minutes a day (or an hour a week) to keep up.
I’m looking forward to continuing to make this a system that works for both of us.
Topics: Budgets/Expense tracking, Saver's Posts | Related Posts: How to Make a Budget, Pie Chart Check Past, Milestones
Not on the same speadsheet
By Spender | June 4, 2008
Spender here. Wait?! What? Spender is going to post to this blog?! I truly loathe disappointing Saver and I want to make every effort I can to save money and contribute to our financial stability and success. Perhaps contributing to this blog will help me stay focused on my fiscal well being. I read a story about the therapy of writing and why blogging is healthy. Maybe that’s what I need. A place to sort out these issues.
Keeping track of how much we’re spending each day hasn’t been a very smooth process for me yet. Surprisingly, I know every penny I’ve spent this week, however, when I went to input it into the spreadsheet system Saver setup I ran into trouble. I know she made it into a simpler system but it still doesn’t make sense to me with the multiple spreadsheets and categories and stuff. It might have helped if we had discussed exactly how to use this tool before she left but I thought it would be straight forward. Well straight forward in my mind is something completely different in hers. I definitely understand the concept behind it but nothing makes sense to me in the way it’s laid out. In the mean time, I’m using a calendar and recording my purchases details for each day. That should keep me on track until we are on the same page.
Topics: Budgets/Expense tracking, Spender's Posts | Related Posts: Expense Tracking: Using Google Spreadsheets
Milestones
By Saver | June 2, 2008
I’m in Belgium this week, at a week-long Dutch language course. (Half of Belgium speaks Flemmish, which is just a dialect of the Dutch they speak in the Netherlands).
June 1st (yesterday), was Spender’s and my five year anniversary. We now know each other better than we’ve ever known anyone else, though there are still occasionally surprises. We’re still complete opposites in almost every way, but now are differences are much more likely to make us crack up laughing than cause a fight.
I still am working on the the balance of where to accept that we’ll always be worlds apart (i.e., Spender loves to go out and hang out with friends all night, I like to go to bed around 10:30) and where try to bring us closer together. To be clear, I know Spender is not going to change much of anything just because I want him to. But by setting a good example and being supportive and showing him the benefits of certain lifestyle choices (not to mention working out the math of paying only minimum payments) I do think Spender may eventually become Not-such-a-Spender or even A-little-bit-of-a-Saver. (In Dutch that would be Saverje).
Not related to our anniversary, we decided we would have a new focus on having a budget and saving money. Going forward, we are tracking every penny. We set up a spreadsheet on google docs to keep track of spending and budgeting. I had made a fairly fancy-schmancy one in excel, but that could only live on my laptop. Instead, I’ve now made a much simpler version that lives online in google spreadsheets. This was Spender can not only update it with his spending every night, he can also see the status of the budget whenever he wants. If I can figure out a way to make sure it stays anonymous, I’ll even post it for everyone to see.
Topics: Relationship, Saver's Posts | Related Posts: None
Time to get serious
By Saver | May 27, 2008
Goal for tomorrow:
1) Sit down and figure out where we’ve spent money in the last 6 weeks
2) Figure out a way to regularly track spending going forward
I’ve used Microsoft money and mint.com in the past, but now i’ve actually created my own excel program that does everything the way I want it to. I have everything set up and ready to go, but have not yet been successful at sitting down with it and entering our expenses on a regular basis. We need to be on somewhat of a budget these days, though, so I’m making it a priority. My goal is to reconcile at least once a week.
Spender is on board, and we’ve agreed to sit down tomorrow night to do our best accounting of the last 6 weeks. Now that we’re getting settled in to life here, we can also finalize our budget. As of June 1st, our “we just moved here” excuse is officially over!!
Topics: Goals, Saver's Posts | Related Posts: Time Two Tell, Time is Money, an apology and course correction to save(er), About Us
Coming Clean
By Saver | May 24, 2008
Like any good personal finance blogger, I plan to post regular (monthly?) updates on my progress of paying down debt and savings toward goals. My finances are just starting to get settled after we moved to Amsterdam in April. I had been holding on to some cash because I wasn’t too sure about how much our living expenses would be, but it’s looking like my paycheck (in Euros) will be enough to cover everything. I’m leaving the money in US savings accounts (at my bank and Emigrant Direct) for the automatic transfers to my student loans and my Roth IRA, but I do need to do some thinking about how to manage my finances on two-continents! That’ll be a post for another time, though.
Here are the numbers:
Debt:
Student loan, $13,176.35 @ 3.25%
Savings:
Vanguard Roth IRA, $9,970.34
Roth 401(k), contributed $2,980.00 so far
Employer retirement plan, I think around $12,000 (I’m unable to access the account at the moment)
Cash savings, $13,326.66
Living expense money in Dutch bank account: $2,226.74 (€1412.64)
Spender’s situation is not quite the same as mine.
Debt:
Student Loans, $15,182.10 (at rates between 5-7%)
Credit card debt, $386.02 (although my typing that has prompted Spender to log on and pay it off).
Savings:
Roth IRA $751.76
Cash savings, $1,965.07
My personal goals are to pay down my student loans (despite really wanting to pay them off, I had been saving in a HYSA because the interest rate was better. Now that the interest rates have come down, that’s no longer worth it), and to max out my Roth IRA. I’d also like to resume contributing to my 401(k), which I put on hold when I moved. My employer contributes a fixed amount to our retirement plan each year in December, so I’m not missing out on any free money by not contributing now. I also have a goal of doing a lot of travelling this year, and will have to be careful to balance being frugal and saving for the future with taking advantage of the opportunity for some amazing experiences.
My goals for Spender are simple: Pay off those loans!! and develop a savings habit.
Topics: Goals, Saver's Posts | Related Posts: Someone's Not Paying For Their Electricity, July Net Worth Update, Working Away