Canadian personal finance software with ability to export historical credit card transactions?
Yodlee is the back-end which communicates with the banks, and Mint just provide a pretty layer on top. You can sign up for an account with Yodlee directly, which may give you the flexibility you need. "Yodlee and Mint are good solutions if you don't mind your personal financial information being stored ""in the cloud"". I do, so I use Quicken. Quicken stores whatever you give to it for as long as you want: so the only question is how to get the credit card transactions you want into it? All my financial institutions allow me to view my credit card statements for a year back, and download them in a form Quicken can read. So you can have a record of your transactions from a year ago right now, and in a year you will have two year's worth." If you're willing to use OFX or QIF files, most Canadian banks can spit output more data than 90 days. The files are typically used to import into Quicken-like local programs, but can be easily parsed for your webapp, I imagine.
I use http://moneydance.com/ it has Mac, Windows and Linux versions and works well for my needs. You could try looking for a UK implementation of http://www.yodlee.com/ : Google tells me that http://www.lovemoney.com/ ( http://www.yodlee.com/2010_1_20.html ) is one such service. I use ANZ money manager - an Australian implementation of Yodlee and find it very useful.  I wouldn't use Yodlee directly though (http://money-watch.co.uk/7197/uk-pfm-tool-review-yodlee-moneycenter) those T&Cs don't sound great. "I use ""Money Manager Ex"" which is a Windows application I use on PC to log my transactions and for simple statistic. They have two versions, simple standlone application and self-hosted web app." Not sure you are going to find anything like this in Excel - with the automatic lookup in specific. Microsoft has a template available; but it looks to be a pretty busy page. Why not look at other software?  If you have a PC, Quicken and Microsoft Money are of course the big guns.  You don't mention why you switched away from MS Money... There are many other packages as well.  The one that I use (but have no other financial interest in) is Moneydance as it was the best on Mac at the time I was looking.  It also runs on Windows and Linux. Money Dashboard and Love Money look like two best options out there now that Kublax closed their doors. Mint were making noises last year about spreading to UK/Canada, but I've not heard anything new about that. Systems to research that may help you out: Less Accounting and Wave are great because they can import data from banks / credit cards. I know you said your bank doesn't export it but it seems like something as a small business you would want. Yes and no, P2P Capital Markets is similar concept but is more geared towards business loans. Community Lend used to offer this service but has stopped. "Parts of what you want are possible, but taken as a whole, you're out of luck. First of all, there is no master database of every cardholder in the country.  The only way to check if information is correct is to ask the issuing bank.  The AVS system is a way to automate doing so, but it's possible to call the bank directly and verbally verify the address.   That means you're subject to the whims of what the issuing bank chooses to support.  Banks that are part of the Visa and MasterCard networks generally only verify the numeric parts (address, apartment number, zipcode).  AmEx can also verify the cardholder name.  But if the bank doesn't have support for validating something, you can't validate it. Separately, there is a ""verify-only"" transaction which some processors support, which will do exactly what you want:  Return AVS values without ever charging the card.  However, processors require you to have the ""approved merchant account"" you don't want to have to have.  Without being a merchant, you shouldn't have access to other people's credit cards anyway.  Would you really want anyone in the country to be able to verify anyone else's address whenever they want? In short, whatever purpose you have for wanting this probably falls into one of three categories:" For double entry bookkeeping, personal or small business, GnuCash is very good. Exists for Mac Os. Quicken has tools for this, but they have some quirks so i hesitate to actually recommend it on that basis. "I'm currently using You Need A Budget for this. It lets you track spending my category and ""save"" money in particular accounts from month to month. They also have some strong opinions about how one should manage one's cashflow, so check it out to see if it'll work for you. It's neither web-based nor free, but the licensing terms are very reasonable." Take a look at http://en.wikipedia.org/wiki/Comparison_of_accounting_software, in particular the rows with a market focus of 'personal'. This is probably one of the more complete lists available, and shows if they are web-based (like Mint) or standalone (like Quicken or Microsoft Money). I used to use Quicken, but support for that has been suspended in the UK.  I had started using Mvelopes, but support for that was suspended as well!  What I use now is an IPhone app called IXpenseit to track my spending. I currently use Moneydance on my Mac.  Before that I had used Quicken on a PC until version 2007. It is pretty good, does most simple investment stuff just fine. It can automatically download prices for regular stocks.  Mutual funds I have to input by hand. The best way to answer this question is to try. GnuCash is free, so setting it up and giving it a go shouldn't be too hard. After all, what really matters is how helpful the program is for your purposes. One aspect of personal finance that stops me from jumping to GnuCash/KMyMoney/MoneyDance is the ability to download transactions from my financial institutions. Last time I checked, the process was somewhat involved and support was limited for a handful of banks. Because of that, I decided to stick with MS Money (and once Microsoft dropped the ball, with Quicken). I am sure things are better these days, but I am still not comfortable with trusting my finances to something new and unproven. I still remember how painful it was several years ago, when some bug in MS Money caused occasional mess-up of the reconciliation state for the American Express credit cards.