Online Personal finance with QIF import
"Unfortunately I don't think any of the online personal finance applications will do what you're asking. Most (if not all) online person finance software uses a combination of partnerships with the banks themselves and ""screen scraping"" to import your data. This simplifies things for the user but is typically limited to whenever the service was activated. Online personal finance software is still relatively young and doesn't offer the depth available in a desktop application (yet). If you are unwilling to part with historical data you spent years accumulating you are better off with a desktop application. Online Personal Finance Software Pros Cons Desktop Personal Finance Software Pros Cons In my humble opinion the personal finance software industry really needs a hybrid approach. A desktop application that is synchronized with a website. Offering the stability and tools of a desktop application with the availability of a web application."
Mint.com is a fantastic free personal finance software that can assist you with managing your money, planning budgets and setting financial goals. I've found the features to be more than adequate with keeping me informed of my financial situation. The advantage with Mint over Microsoft Money is that all of your debit/credit transactions are automatically imported and categorized (imperfectly but good enough). Mint is capable of handling bank accounts, credit card accounts, loans, and assets (such as cars, houses, etc). The downsides are: Converting fideli comment to answer I don't think any Canadian bank offers this capability for online banking. However, there seems to be a fierce push right now at most banks to improve their online banking platform so they may be open to the suggestion of guest accounts Online banks are the future. As long as you don't need a clerk to talk to (and why would you need?) there's nothing you can't do with an online bank that you can with a brick and mortar robbers. I use E*Trade trading account as a checking account (it allows writing paper checks, debit card transactions, ACH in/out, free ATM, etc). If you don't need paper checks that often you can use ING or something similar. You can always go to a local credit union, but those will wave the fee in exchange for direct deposit or high balance, and that you can also get from the large banks as well, so no much difference there. Oh where where did Washington Mutual go.... You need 2 things One a Demat Account and second a Broker Account. If you need to trade online, then an agreement [Power of Attorney] between Your Saving Bank Account, the Demat Account and the Trading Account. So there are quite a few forms that need signature and proof of identify. Physical presence is required. CashBase has a web app, an iPhone app and an Android app, all sync'ed up. It doesn't integrate with banks automatically, but you can import bank statements as CSV. Disclosure: Filip is CashBase's founder. MoneyDance Is the way to go.  I've been using it for years and it works well.  It keeps getting better, and best of all, it's completely cross platform!  Mac, Windows and linux! "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." I  found that  an application already exists which does virtually everything I want to do with a reasonable interface.  Its called My Personal Index.  It has allowed me  to look at my asset allocation all in one place. I'll have to enter: The features which solve my problems above include:  Note - This is related to an earlier post I made regarding dollar cost averaging and determining rate of returns.   (I finally got off my duff and did something about it) 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 MoneyStrands.com to manage my spending. It's a lot like Mint, but provides support for more banks, and works with most Canadian financial institutions. I can't really compare them fairly though, since I didn't bother with Mint after learning that they don't care about Canadians. If your bank isn't supported by MoneyStrands, or you don't want to trust an online webiste with your account login, you can create accounts for manually uploaded files. It just means you have to log into your bank yourself, download the transactions as QFX, OFX, CSV or other supported formats, and then upload the files to the appropriate account in MoneyStrands. I love the expense tracking and reporting that MoneyStrands offers, but like Mint, their budgeting feature is seriously lacking. Fortunately I don't need to budget month-to-month, I just use it to see how much I spend on various categories, to help create annual budgets and decide how much I can invest or use for a vacation. Google Finance will do all the bullet points in your list and a few more.  The only drawback is that you have to enter ALL buy and sell manually.  It has an import feature, but it does not work with all trading software. http://www.google.com/finance Let me know if it works.  Also, yahoo.com/finance has a good tool, but I still like better Google's application. You'll need to find out in what format MoneyStrands expects the data.  A .qif or an .ofx file may not be the answer. "You Need A Budget is a nice budgeting tool that works on the desktop.   It is more focused on manual entry and budgeting over auto-downloading and categorizing.   It does support downloading transactions from banks and then importing the transaction files.    You mentioned having ""trust issues"" with a bank and this would be safe as you don't enter your credentials into the app.   It also has a mobile app that works well. Not exactly what you are looking for, but it would work in India and be safe if you have an untrustworthy bank and it would allow you to import transactions." 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. None of what you said is correct. Wells Fargo makes over half of it's net income from community banking. Investment Banking is tucked inside of the Wholesale division and represents a relatively small piece of that. Wells' auto portfolio is at $58 billion; by no means as large as say the mortgage exposure, but certainly nothing to sneeze at.