Balance sheet out - how do I fix?

bunk3m bunk3m at gmail.com
Fri Apr 5 11:03:06 EDT 2013


Further to my earlier email, I checked balance sheets back month by
month until I found the dates between which the balance sheet got out of
balance.

March 12, 2012 balance sheet is OK.  CAD-USD xchg = 1.022 on report
March 13, 2012 balance sheet is out by $0.32. CAD-USD xchg = 0.9894

1) Both reports use Commodity:Price Source:Nearest in Time.
2) All base currency (CAD) balances are identical in both reports.
3) The only differences between the two reports is the USD valuation
calculation, which shouldn't be there because the price didn't change.

There are no transactions on either date.  There is no currency price on
either date in the Price Editor, so there should be no change in the
currency on the report.

What's going on?  What do I need to do to fix this?

Is this a bug?

Thanks in advance for your help and quick reply.

B.

On 5.04.2013 10:13 , bunk3m wrote:

> 2012 balance sheet is out by $0.63.  I have an unrealized gain of
> hundreds of dollars on Dec. 31, 2012 but can't figure out if the $0.63
> is part of this calculated gain or an actual transaction.
> 
> And 2013 balance sheet is out $0.31.  The 2013 difference is exactly the
> unrealized gain on the 2013 balance sheet.  As I closed the foreign
> currency account on Jan. 4 and the currency amount on Dec. 31 and Jan 4
> 2013 are the same I shouldn't have a gain.
> 
...
> I'm stuck now and have 2 questions.
> 1) Would anyone have a suggestion of how to find which transaction(s)
> have caused the imbalance?  I'm starting to change the balance sheet
> date end or each month until I find something out of balance but am
> wondering if anyone has additional suggestions.


More information about the gnucash-user mailing list