[GNC] Oddities importing from Quicken

Doug lemans4 at internode.on.net
Tue Nov 19 19:14:12 EST 2024


I can only speak from my experience (Long time but no accountant!).
 I gave up on Quicken (QIF) imports. This is a proprietary format,
 so my suggestion is to avoid if at all possible.
 My preference is .OFX format, which is an open standard, or .csv 
which is a little harder, but works well. (One needs to pick 
importing transactions, then select the account, then sort the 
disbursements: something that .ofx seems to handle much better in 
my opinion.)
 I have not used Quicken for about 25 years! Suggest trying different export.
 Then later, when importing from your bank, use .ofx or .csv. Perhaps you could try 
importing your old Quicken data in a non-qif format into a new blank gnucash. There is an account importing option for 
a .csv file that might work.
Good luck! (Doug in Australia)



On Tue, 19 Nov 2024 16:39:01 -0700
Simon Roberts <simon at dancingcloudservices.com> wrote:

> 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/


More information about the gnucash-user mailing list