A version of this spreadsheet is available via my blog (or search ‘FvL investment tracking spreadsheet’), in Google Sheets. It knows my target asset allocation and helps me monitor the deltas between target and actual, consolidating positions across accounts. SEE FINANCE VS IBANK VS MONEYDANCE UPDATEI use Excel for tracking the value of my investment portfolio, and update it fully at least monthly. It is fast and effective, once the data is in place. Quicken lets me look at it by account, by time period, by category, and export quickly in Excel. This is a key metric I track on my FIRE journey. I also try to capture all dividend/income (except IB) in Quicken. I use Quicken for my CGT reporting for these accounts. What matters, and what I use Quicken as source of truth for, is the Buy/Sell transactions. However because it won’t import prices at all (any more) let alone live ones, I don’t properly update valuations. Quicken also has a record of every transaction in all my investment accounts except for Interactive Brokers. SEE FINANCE VS IBANK VS MONEYDANCE MANUALAs a result, manual keying, while not unheard of, is mostly eliminated. Thankfully, many banks/card providers do let me export either in native Quicken format (despite Quicken having left the market 10+ years ago!) and/or a CSV format, and I use to map CSV files into Quicken format. charity donations, property rental spending, bank interest, previous tax payments, etc. Quicken is very helpful for letting me pull out specific spending categories – e.g. charity donations – tho I do still categorise 90%+ of my spending. These days the advent of contactless payments has meant a proliferation of tiny transactions on my statement and I only categorise large payments or transactions in certain categories – e.g. Until a year or so ago I categorised every transaction. You could get online stock quotes back in 2003 Quicken is my source of truth for spending – credit cards, current accounts, etc. Much as I had assumed that I was in a minority of about one, until I read Ermine’s blog post, a lot of online banking/credit card systems do offer some support for Quicken file formats so I suspect there are a few tens of thousands of us still out there.īut in recent years a wealth of new tools/capabilities have emerged, and as a result my approach has evolved somewhat. Credit due to Microsoft for the backwards compatibility too (you listening, Apple?). It continues to offer QuickBooks, for business accounts, but thankfully Quicken 2004 still works, albeit without any live-off-internet functionality. SEE FINANCE VS IBANK VS MONEYDANCE SOFTWAREA recent blog post /comment thread on Ermine’s Simple Living in Somerset was the inspiration for this post – about the tools/processes I use for tracking my finances.Įrmine and I find ourselves relying on a 2004 piece of Windows software, Quicken 2004, produced by a US company that pulled out of the UK market for personal finance software in 2005.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |