Balance sheet out - how do I fix?

[Carsten Rinke]

ok.
Together with what Derek explained my guess is that this is "only" an 
effect of the currency exchange in the report, your book as such should 
be ok otherwise I would expect to see an automatically created entry in 
the imbalance account.

My next suggestion is to let me try to reproduce it and then we can try 
to check out the balance sheet report and eventually file a bug report 
if needed.
Try to create a minimum setup that shows the effect (to me it sounds 
like a couple of accounts and transactions should show the effect) and 
rephrase everything to make it possible to send the file over as an 
attachment without any private data. Let me know which pricing table 
information you set up and then I will check if I can reproduce it on my 
mashine.
Hope that sounds feasible.

Carsten


On 04/11/2013 02:16 AM, bunk3m wrote:
> Just tested your suggestion, Carsten.
>
> I deleted both reports and started again from new balance sheets for
> Mar. 12 2012 and Mar. 13 2013.
>
> I changed both reports to "Most Recent".  Now the balance sheets both
> show Xchg = 1.00.  Balance sheet Mar. 12 is out of balance by 0.60.
> Mar. 13 is out by 0.22. ????  Why it selects Xchg = 1.00 doesn't make
> sense to me.   If the xchg rate is "the same", then the balance should
> be the same.  Weird that they aren't out the same amount since there are
> no transactions on either date.
>
> Using "Nearest in Time" balance sheet Mar. 12 is out 0.60 (xchg =
> 1.022).  Mar. 13 is out 0.32 (xchg = 0.9894).
>
> The balance sheet by definition is supposed to balance unless there is a
> transaction that misses either a debit or credit.  As there is no
> "Unbalance" account anywhere, the calculation somewhere is incorrect.
>
> This is driving me nuts!
>
> How do I export all transactions from gnucash?  I'd like to review these
> in a spreadsheet.  Maybe then I can find out where either the
> transaction error is or where the multi-currency calculation is incorrect.
>
> Thanks again for your help.
>
> B.
>
> On 10.04.2013 14:17 , Carsten Rinke wrote:
>> Hm,
>>
>> does that mean, switching from
>> -> Commodity:Price Source:Nearest in Time.
>> to
>> -> Commodity:Price Source:Most Recent
>> resolves the issue?
>>
>> Carsten
>>
>>
>> On 04/10/2013 05:41 PM, Derek Atkins wrote:
>>> Hi,
>>>
>>> bunk3m <bunk3m at gmail.com> writes:
>>>
>>>> I checked each account manually and there are no transactions on Mar 12
>>>> or 13.  I also ran a transaction report selecting all accounts for Mar
>>>> 2012. The report shows the closest transactions are Mar 4 and Mar 21.
>>>>
>>>> The price editor has price info on Feb 29 {xfer-dialog 1.022} and
>>>> Mar 26
>>>> {user:price-editor 0.9894}.  The balance sheet on Mar 13 should use the
>>>> 1.022 exchange rate too.
>>>>
>>>> So, I'm as sure as I can be that there are no transactions or price
>>>> changes.
>>>>
>>>> I'm assuming there must be a corruption in the file or a bug in the
>>>> program.  What do you suggest to try next?
>>>>
>>>> Just a wild thought here ... Mar 13 is exactly 1/2 way between Feb. 29
>>>> and Mar 26.  Is it possible that the program is adjusting/averaging the
>>>> difference in the dates to determine the currency rate even when I've
>>>> selected "Nearest In Time" on the report?  If yes or no, the balance
>>>> sheet should still balance.
>>> No, it wouldn't average them.  More likely it is choosing the Mar 26
>>> price on Mar 13 and the Feb 29 price on Mar 12.
>>>
>>>> B.
>>> -derek
>>>
>>>> On 5.04.2013 12:23 , Derek Atkins wrote:
>>>>> bunk3m <bunk3m at gmail.com> writes:
>>>>>
>>>>>> 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.
>>>>> There must be SOME piece of data on March 12 or March 13 that is
>>>>> causing
>>>>> this.  Are you SURE there's no transactions or PriceDB entries?
>>>>>
>>>>>
>>>>
>>
>