Out of balance after QIF Import

John Layman john.layman at laymanandlayman.com
Tue May 25 14:34:22 EDT 2010


The root problem is that investments are not fixed assets, so valuation (and
the unrealized gain) fluctuates from day to day.

-----Original Message-----
From: Anthony Dardis [mailto:adardis at gmail.com] 
Sent: Tuesday, May 25, 2010 2:06 PM
To: john.layman at laymanandlayman.com; 'Derek Atkins'
Cc: 'Mitch Singler'; gnucash-user at gnucash.org
Subject: Re: Out of balance after QIF Import

Whatever Quicken was doing for me to keep track of unrealized gains on my
house, didn't come over, so I did this:

Increase Income:Accrued Gains on Asset and the offsetting transaction
increases Assets:Fixed Assets:House (which had an opening balance
corresponding to the purchase price from Equity:Opening Balances, which did
come over from Quicken).

(I'm not any kind of accountant, I got the term "Accrued Gains on Asset"  
and the pattern to use here:  
http://www.gnucash.org/docs/v1.6/de_DE/t1217.html)




On Tue, 25 May 2010 13:15:52 -0400, John Layman
<john.layman at laymanandlayman.com> wrote:

> The balance difference is the amount of unrealized gains.
>
> -----Original Message-----
> From: Derek Atkins [mailto:warlord at MIT.EDU]
> Sent: Tuesday, May 25, 2010 11:56 AM
> To: john.layman at laymanandlayman.com
> Cc: 'Anthony Dardis'; 'Mitch Singler'; gnucash-user at gnucash.org
> Subject: Re: Out of balance after QIF Import
>
> "John Layman" <john.layman at laymanandlayman.com> writes:
>
>> 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.
>
> Sounds like you're failing to account for any capital gains or losses 
> from the sale of equities?
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>



More information about the gnucash-user mailing list