Balance sheet out - how do I fix?

Carsten Rinke carsten.rinke at gmx.de
Wed Apr 10 14:17:06 EDT 2013


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?
>>>
>>>
>>
>>



More information about the gnucash-user mailing list