Out of balance after QIF Import

[Mitch Singler]

Sorry for the late reply.

I will try your first suggestion. Been waiting for a couple of transactions from last year to clear the bank so I can reconcile them. Will start a new new year for 2010 as I am currently using my Quicken file started in 2004. I exported only 2010 transactions for import to gnucash but who knows what state things are in until I pare it down a bit.

Thanks,
Mitch





________________________________
From: Anthony Dardis <adardis at gmail.com>
To: Derek Atkins <warlord at mit.edu>; Mitch Singler <msingler at yahoo.com>
Cc: gnucash-user at gnucash.org
Sent: Mon, May 24, 2010 12:28:01 PM
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
>