[GNC] Oddities importing from Quicken
Murugan Mariappan
m.muruganandam at hotmail.com
Tue Nov 19 19:42:12 EST 2024
Simon
GNUCash is a double entry system, in your transaction it is mapping to the same account, you need to find the counter account for this transaction and update the same (deposit or withdrawal leg)
Saludos Cordiales
Murugan
________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of Simon Roberts <simon at dancingcloudservices.com>
Sent: 19 November 2024 20:39
To: Gnucash Users <gnucash-user at 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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2F%40DancingCloudServices&data=05%7C02%7C%7Cc64a21d2e0824ad3e5ee08dd08f3a70c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638676564783280236%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=fidiYsc6kssPpRSteSGVb1K9Lvf2tYAmTak%2ByD02kOQ%3D&reserved=0<https://www.youtube.com/@DancingCloudServices>
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fin%2Fsimonhgroberts%2F&data=05%7C02%7C%7Cc64a21d2e0824ad3e5ee08dd08f3a70c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638676564783299286%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=VRCYUgcfIlwtCB59RoE1O1PWgA2GCHRjXoewlLIYWkk%3D&reserved=0<https://www.linkedin.com/in/simonhgroberts/>
More information about the gnucash-user
mailing list