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