Balance sheet out - how do I fix?

Derek Atkins warlord at MIT.EDU
Wed Apr 10 11:41:03 EDT 2013


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

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list