Difference between total assets and liabilities

[AlainCageda]

>________________________________
> De : David Carlson <carlson.dl at sbcglobal.net>
>À : gnucash-user at gnucash.org 
>Envoyé le : Lundi 5 novembre 2012 15h01
>Objet : Re: Difference between total assets and liabilities
> 
>On 11/5/2012 7:36 AM, AlainCageda wrote:
>> The difference is only about 18 € out of a balance sheet of more than 100 000. Not significant fiancially but I have to get get rid of it. Assets need to equal Liabilities. If there was a small problem like that in a regular account I'd just register the amount as Loss or Profit. But here the difference is not the balance of an account I can manage. It's the result of a substraction (or addition for all I know) on which I have no power. So, Derek suggested the difference may come   from a faulty currency conversion. Do you know how I can fix that?
>>
>> TIA
>> Alain
>>
>>
>>
>> ----- Mail transféré -----
>>> De : AlainCageda <alaincageda at yahoo.fr>
>>> À : "derek at ihtfp.com" <derek at ihtfp.com>; ""gnucash-user at gnucash.org"" <gnucash-user at gnucash.org> 
>>> Envoyé le : Dimanche 4 novembre 2012 18h49
>>> Objet : Tr : Difference between total assets and liabilities
>>>
>>> Complement: My credit card payment in USD are automatically converted into EURO so I diont think they are involved, but I do have accounts for USD and GBP in cash. So what should I check about them?
>>>
>>>
>>> ----- Mail transféré -----
>>>> De : AlainCageda <alaincageda at yahoo.fr>
>>>> À : Derek Atkins <derek at ihtfp.com>; "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
>>>> Envoyé le : Dimanche 4 novembre 2012 18h28
>>>> Objet : Re: Difference between total assets and liabilities
>>>>
>>>> Yes. I'm mainly in euros but I do occasionally deal in  USD.
>>>> Do you know what I should check?
>>>>
>>>>
>>>>
>>>>
>>>>> ________________________________
>>>>> De : Derek Atkins <derek at ihtfp.com>
>>>>> À : AlainCageda <alaincageda at yahoo.fr>; "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
>>>>> Envoyé le : Dimanche 4 novembre 2012 17h21
>>>>> Objet : Re: Difference between total assets and liabilities
>>>>>
>>>>>
>>>>> Are you dealing with multiple currencies or stocks?  This error tends to occur when you do not properly account for the gain or loss of trading.
>>>>>
>>>>> -derek
>>>>>
>>>>> Sent from my HTC smartphone
>>>>>
>>>>> ----- Reply message -----
>>>>> From: "AlainCageda" <alaincageda at yahoo.fr>
>>>>> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
>>>>> Subject: Difference between total assets and liabilities
>>>>> Date: Sun, Nov 4, 2012 11:17 AM
>>>>>
>>>>>
>>>>> Hello.
>>>>>
>>>>> My problem is this:
>>>>>
>>>>> The result of my Income / Expense statement is say:10 000.
>>>>>
>>>>> My balance sheet shows 
>>>>>
>>>>> Registered Gains (or whatever it is in english I'm working in French) : 10 000.00
>>>>> Unrealized losses (                        d°                       ) : 18.00
>>>>>                      making my Liabilituies 18€ lower than my Assets.
>>>>>
>>>>> Anyone has an idea where this come from and a solution to fix it?
>>>>>
>>>>> TIA
>>>>> Alain 
>>>>> _______________________________________________
>>>>> 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.
>>>>>
>>>>>
>>>> _______________________________________________
>>>> 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.
>>>>
>>>>
>>> _______________________________________________
>>> 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.
>>>
>>>
>> _______________________________________________
>> 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.
>Have you tried running reports for different times and checking to see
>if the error changes?  Every time it changes there is at least one
>erroneous transaction.  By checking shorter intervals you can close in
>on a date range.  If you are very lucky, there is only one transaction,
>and you can close in on it fairly quickly.
>
>David C
>
>
>
>
>Tks for this advice David. using your method I found a transaction in my USD cashbox. Editing the exchage rate changed the end of the year error (without fixing it). So this is at least part of the problem. But I can't make out what is faulty in this transaction.
>
>
>Alain
>
>
>_______________________________________________
>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.
>
>