Balance sheet does not tally
J
jitkothari at gmail.com
Fri Jan 10 05:32:07 EST 2014
Hi Mike,
Installed ver 2.6.0 (under Portable Apps to test out), and generated
Balance sheet with Price source (Weighted average).
I can see a value under Trading Gains & Unrealised Losses. Balance sheet
does not match by the value under Unrealised Losses.
What steps shall i try to find the source of this difference ?
Regards,
Jiten
On 04/01/2014 11:46 AM, Jitendra Kothari wrote:
>
> Thanks Mike
>
> Will install ver 2.6 & check it out
>
> If it does not resolve will check the balance sheet at different dates.
>
> Regards,
> Jiten
>
> On Jan 4, 2014 9:58 AM, "Mike Alexander" <mta at umich.edu
> <mailto:mta at umich.edu>> wrote:
>
> The transaction you quote below shouldn't be considered balanced
> if its exchange rate is not 1.5. Prior to 2.6 there was a bug
> that would sometimes consider transactions like this to be
> balanced, but that bug has been fixed. When I fixed that bug I
> discovered that I had a number of unbalanced transactions that had
> never been noticed before.
>
> I'm not sure what, if anything, this has to do with the original
> question about balance sheets not balancing. Unfortunately I
> don't have much to add to that. One brute force way to attack
> this problem is to run balance sheet reports at various dates in
> the past to see when it first fails to balance. Then look for
> transactions around that date to see which one is causing the problem.
>
> Mike
>
> --On January 4, 2014 6:54:45 AM +0400 Jitendra Kothari
> <jitkothari at gmail.com <mailto:jitkothari at gmail.com>> wrote:
>
> Hi,
>
> Any help to check thia issue.
>
> Regards,
> Jiten
> On Jan 1, 2014 2:26 PM, "Jitendra Kothari"
> <jitkothari at gmail.com <mailto:jitkothari at gmail.com>>
> wrote:
>
> Hi,
>
> I am using ver 2.4.13.
>
> If it helps, the data file i am using is the same for last
> 4 years+
>
> Regards,
> Jiten
>
>
> On Tue, Dec 31, 2013 at 10:18 PM, Alun Champion
> <alun at achampion.net <mailto:alun at achampion.net>>wrote:
>
> Which version of Gnucash are you using?
> In the latest (2.5.X & 2.6.X) I found a lot of my
> multi-currency
> transactions were not balancing (I use trading
> accounts). I had to
> manually edit the exchange rate for all the unbalanced
> ones. It
> seems that Gnucash 2.4 didn't validate the exchange
> rate and
> allowed me to manually enter the splits of foreign
> transactions.
> When the exchange rate was fixed the same transaction
> then balanced.
> E.g.
> Account $: 150
> Account £: -100
> Trading:Currency:USD: -$150
> Trading:Currency:GBP: £100
>
> Balanced in 2.4, unbalanced in 2.5/2.6 until I fixed
> the exchange
> rate to 1.5
> -Alun.
>
>
> On 30 December 2013 11:59, Jitendra Kothari
> <jitkothari at gmail.com <mailto:jitkothari at gmail.com>>
> wrote:
> > Hi,
> > I am using Gnucash with 2 currencies for last 4 years.
> > The issue I face is the balance sheet does not
> tally, tried using
> trading
> > account.
> > What steps can i do find the reason behind the
> difference.
> > Thank you in advance for your help.
> > Jiten
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> <mailto: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 <mailto: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.
>
>
>
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
More information about the gnucash-user
mailing list