Simon, Welcome to GNUCash!
So having gone through migration of Quicken to GNUCash via QIF export-import back in 2020 for decades of data in Quicken, it is not a seamless migration as you hope - and rightfully shouldn’t expected one as GNUCash is not a like-for-like products as Quicken is. As many have mentioned, Quicken is not a double entry system like GNUCash is thus you have to trial-and-error to get all the data into GNUCash the way you want it. You will have to get used to double entry system if you haven't. Also key part is that Quicken Categories become GNUcash contra accounts (i.e. the other side of the Quicken transaction). To start off, LAST items that should move over from Quicken should be transactions. Before moving over transactions, you need to prep GNUCash (assuming you are not moving over Brokerage accounts as that involves even more steps). First move over just the Quicken Category List which will create new contra accounts in GNUCash (you can select what to export in the Quicken qif export window so limit one item only and then import qif in GNUCash!). Next move over Account List from Quicken in this fashion. Once these two are done, thoroughly review these setups. Re-parent accounts in GNUCash that are not correctly setup. Create a back of the GNUCash file in case you need to recover (should perform back up at each step so you can roll back one step rather than start from scratch). Now comes moving over transactions thus is where trial-and-error starts. Start moving transaction from one account from Quicken at a time with the account that has highest amount of transaction to least amount. When you start importing transactions from second account, GNUCash should open a matcher window and this is where you can reassign to applicable GNUCash contra account, if you need to, to transaction that don’t seem right. Hope this helps in your migration. -----Original Message----- From: Simon Roberts <si...@dancingcloudservices.com> Sent: Tuesday, November 19, 2024 6:39 PM To: Gnucash Users <gnucash-user@gnucash.org> Subject: [GNC] Oddities importing from Quicken Hi all, I'm hoping to get my personal accounts onto GNC (I'm using it for a small business, so I'm tolerably familiar with it already). I exported a QIF from Quicken, and imported it. Lots of accounts were created in GNC that map "well-at-first-glance" to the actual accounts and categories in Quicken. However, many balances are way off. I've done some digging, and the thing I've noticed so far is that some transfers between actual bank accounts appear to have been entered twice. I say "appear" because I get oddly different results in "basic ledger" view from what I get in transaction journal view (though I must say up front, I'm not a transaction journal view user, so perhaps I just don't understand it. Here's one of the offending entries in basic ledger. There's only one entry (a deposit to this account) in the Quicken file. but notice two entries here--the blocked out account numbers are identical in the upper and lower entry: [image: image.png] Here's the transaction journal view, notice there's only one entry here (I left the previous and next visible so you can see that :) Again, all those greyed out account numbers are identical: [image: image.png] Did I do something wrong in the export, or in the import? I'd prefer to get this right from the start, there are quite a few years of data, and fixing this up by hand over all the accounts would be a frustratingly major undertaking. Any suggestions gratefully received, Cheers, Simon -- Simon Roberts 303 249 3613 https://www.youtube.com/@DancingCloudServices https://www.linkedin.com/in/simonhgroberts/ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
