I tried to use Personal Capital for this, but I didn't like how it broke down my allocation. Sure a lot of my funds hold 0.5% cash (or whatever), and some of my funds have a tiny bit of International components to them. But I don't care. I just want 40% VTSAX (US Stocks), 40% VTIAX (International Stocks), and 20% VBTLX (US Bonds). Their breakdown page couldn't quickly tell me this:
Then I realized Vanguard let's me track "outside investments", so I can use their Portfolio Analysis across all my accounts:
Which is perfect, because it stays up to date with market fluctuations, but I have to update it manually every time I add new money to my outside investments (like my 401k), and I still have to calculate how much of the new contributions I should put towards each fund to stay at my 80/20 level (same problem with Personal Capital). I'm also not sure if they assume the outside investments are reinvesting dividends.
So now I just manually update my spreadsheet whenever I need to add money to the account:
I use
this extension to auto-update the balance based on market movement, but really it does't help much. I still have to manually update the sheet when I make new contributions, and when dividends hit. I've yet to find the perfect solution, but this is the best I've found so far. And really, it doesn't take that long to update the sheet, especially if you're using Mint/Personal Capital to aggregate it all for you, so it's not that bad :)