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