Out of balance after QIF Import

[John Layman]

I am a former Microsoft Money user who converted to GNUCash January 1st.  I
have separate files for business and personal accounts, and started both
cold as of January 1st.  I imported only investment accounts from Money.
Since converting, my business accounts are always in balance, but the
personal accounts are not.  I believe this is due to the investment-related
transaction prior to Jan 1.  I have been unable to think of a way to balance
my personal accounts.

-----Original Message-----
From: gnucash-user-bounces at gnucash.org
[mailto:gnucash-user-bounces at gnucash.org] On Behalf Of Anthony Dardis
Sent: Monday, May 24, 2010 1:28 PM
To: Derek Atkins; Mitch Singler
Cc: gnucash-user at gnucash.org
Subject: Re: Out of balance after QIF Import

I just migrated from Quicken 2009. (From Win XP to Mac OS X, the .dmg
version). Two things:

--before I migrated, I "cleaned up" Quicken by deleting closed bank
accounts, credit cards, etc., and then closed the books relative to a
sensible starting point (Jan 1 2008, fwiw). (I think, before you close the
books, you should make sure to reconcile every account you can, even if
there's nothing to reconcile them against--see next point:)

--nevertheless, the QIF export [remember: export EVERYTHING] retained a
bunch of transactions from a couple of those accounts, going back to the
beginning of time; these made my opening balances and ending balances no
good for my checking account, where most everything comes from and goes to.
I ended up just deleting all those transactions. (Think through what the
consequences will be; but in my case, it was just a matter of deleting
them.) I think they just happened to be a couple of accounts I never had had
reason to reconcile, and so Quicken kept them around (even through the
closing process) even though they were long since inactive.

Good luck!



On Mon, 24 May 2010 10:15:27 -0400, Derek Atkins <warlord at mit.edu> wrote:

> Mitch Singler <msingler at yahoo.com> writes:
>
>> I am trying to migrate from Quicken Deluxe 2004 but when I import my 
>> QIF file my accounts do not have the same balance as in Quicken. I am 
>> referring to the Quicken accounts in GnuCash not "categories".
>>
>> Do I need to make an "opening balance" entry in each asset & 
>> liability account to get to the correct balance?
>
> It depends...  You might have to if the opening balance didn't 
> transfer across.
>
>> Thanks for any help,
>> Mitch
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
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.