Personal finance tracking
28 July, 2008How much money do you have and how do you find out what you’re spending it on?
This is the question that irks me. The financial free software world is centred around GnuCash which is all about detailed tracking of your finances – well, as far as I’m concerned my bank already does this for me so all I need is the visualisation from that data.
What my bank (Barclay’s) actually allows me to do is download up to the last three months’ worth of data in OFX format.
So, right now I’m using ofx-parser, a Ruby library, to process the data and import into into a sqlite database. I’m then using CodeIgniter to display a list of my transactions and the Yahoo! Charts library to graph them (the CodeIgniter PDO library needed some patching to support sqlite properly before I could make much progress).
Unfortunately Barclay’s don’t put a timestamp on the transactions, only a date, so the graphed balance isn’t always accurate – in the screenshot above you can see that it looks as though my account has twice dropped below zero although no such thing ever happened. Obviously this is part due to my woeful lack of graphing skills but the lack of time is still pretty annoying.
I can so far group and plot my expenditures and savings. The next set of features will be tagging by type and vendor recognition at which point I’ll be able to work out and plot exactly how much I’m spending on food over time and with which retailers.
This is all inspired by Wesabe which is an excellent application but despite their reassuring Data Bill of Rights I just don’t feel comfortable uploading all my bank details and transactions to an American company once every three months.
Comments
mathew
29 July, 2008 at 08:33
Phil
29 July, 2008 at 13:50
Bill Rawlinson
29 July, 2008 at 15:07
Phil
29 July, 2008 at 18:05
Amanda
03 August, 2008 at 19:53
Coupon Artist, Frugality and Smart Spending Blogger
30 April, 2009 at 14:04
Cant you make sure that all payments into your account are considered before withdrawals, that should stop these small dips below 0.
Also can’t you group by vendor using grep, if you convert to the wonderful csv format?
The last thing is that you graph is too small for me to see what you are spending.
Yes, parsing payments before withdrawls would make sense, but would require more work. Bah! 😉
The vendor stuff isn’t hard and you’re right, it should just be a simple grep procedure, but I also want to be able to assign a ‘friendly’ name to vendors and group by that. It should all be straightforward, but frankly banks should be providing all of this already.
I’ll make a note to put a larger screenshot up next time 😉
While I realize it isn’t a huge alternative you may want to check out moneycenter.yodlee.com – it is an American company as well, as far as I can tell – however a bunch of banks already use them to move data around so you may feel more secure in using their service (I dunno).
I use it and it is pretty nice. It can aggregate data from a lot of different financial institutions and provide comprehensive graphs – though they are all pretty much pie charts and not line graphs.
There is another site, mint.com, that offers nicer graphs but in the back end they still use Yodlee for data fetching/aggregation.
Thanks Bill – I’ve seen both Yodlee and Mint before (although I hadn’t realised Mint used Yodlee behind the scenes) but you’re right, the same caveats apply – there are just too many places for me to make a mistake and upload my financial information to the wrong place, let alone the European/US data privacy implications.
There is clearly room for improvement and perhaps someone will come up with a better program soon. Mint.com is okay.
I use a simple Excel spreadsheet to track my finances. Since I am paying off debt, and really constantly strive to be frugal and save money on every area of spending, I really want to be aware of where I am overspending. It helps me to make sure that I stick to my budget and it helps me to see problem areas if I manually keep track of my spending using excel. I save all my receipts and I also sign on to online banking about once or twice a week. I enter the data from the receipts and from my bank account into my spreadsheet, and have created my own custom categories to track my spending. Yes, it definitely is more work- but this way I am constantly aware of where my money is going and if I am potentially going to go over budget in any area. Since I tried a cash only and/or envelope system and it didn’t work for me, this is the best way to ensure that my frugality efforts are paying off.