![]() Remember to select the "Bank" account when importing the cash portion of the investment accounts. If you make a mistake (like importing into the wrong account) you'll probably need to start over so be extra careful. That's why you should give the qif files descriptive names in step 3. If done correctly, every account will get populated with the correct transactions, even the loan accounts. There should not be any of those "Imported Account" accounts or categories. If there are, then you've made a mistake. Move all transactions from the temporary "Bank" accounts you created for place holders for the cash portion of the investment accounts from MSMoney into the one and only corresponding investment account in Moneydance. To move transactions, select them in the "Bank" account by selecting the first transaction and then using shift-click to select the last transaction. Then right click on the select transactions and select "Batch Change" -> Account and specify the investment account as the destination. Delete the temporary place holder account in Moneydance. Moneydance will contain the cash transactions in the root of the investment account.Įdit the loan accounts in Moneydance. When you click Done, Moneydance will ask if you want to transfer the loan balance to another account. ![]() Select Yes and choose the account that received the loan proceeds. This may be a checking account if it was an unsecured loan or it may be an asset account if there was an asset that was acquired. You may need to modify the transaction later to account for closing costs, etc. Organise your accounts and categories the way you want. The Find and Replace extension can be very useful for changing the categories of a lot of transactions at once. You can install it in Moneydance by going to Extensions -> Manage extensions, then scrolling down and clicking the Install button next to the Find and Replace extension. You may need to make a few balancing entries in some of the accounts to get things balanced correctly. That's because MS Money is not a double-entry system and so things aren't required to balance there.I've used KMyMoney, GNUCash and Quicken. Neither KMyMoney nor GNUCash can compare to Quicken in either ease of use or integration with banks. Quicken is very straight-forward in setting up accounts and automating updating your transactions. So I'm wondering if anyone has written a libre package that aims to do the web scraping approach for various popular banks that don't support Direct Connect.With GNUCash I had to log on to each bank and download transactions as QIF and import them. Of course that becomes a bit tedious and doesn't give Moneydance (or whatever) access to your recent transactions (it would be very convenient to `tail /var/log/bank` rather than having to login manually). But you can personally download the OFX files from the web interface for use with Moneydance (etc), and given the way OFX works you don't even need to be careful about overlapping date ranges (eg download the last year of transactions every month). Of course using Plaid is horrible because not only are you giving out your credentials, but you're also giving away your private financial data to a surveillance company. I believe this is what Plaid et al retrieve. ofx/.qfx files through their web interface. ![]() Meanwhile, all banks seem to have the functionality to download. For example, Capital One 360 used to serve it up, but they turned it off in the past several years. ![]() But as web culture took over with things like Plaid, banks have become more wary about serving up a bespoke protocol that (I believe) authenticates in plain text, or at the very least doesn't support snake oil 2FA and the like. The download functionality of Moneydance and GNUCash is via "OFX Direct Connect", which is an older non-HTTPS protocol to download OFX data from a bank. ![]()
0 Comments
Leave a Reply. |