Balance sheet out - how do I fix?

[bunk3m]

Thank you Carsten.

I will give this a try but it might take a bit of time if I have to
manually add all the transactions.

Is there a way to export transactions that I haven't found in GnuCash or
a related tool? 

I have found a gnucash xml to qif file manipulator but not a way to
export specific ranges of transactions.  I don't think that will help
much unless I learn how to manipulate QIF files.

Thanks again.

B.

On 10.04.2013 1:15 , Carsten Rinke wrote:
> Hi,
>
> in order to exclude a program bug:
>
> Is it possible to reproduce this behaviour starting with a new file
> that has similar transactions for the Feb-Mar 2012 time frame?
> Yes, this can be quite some work depending on your setup and on the
> amounts of transactions at that time.
> But you can export the "empty" account tree and maybe it is enough to
> "only" enter the suspecious transactions and price info.
>
> Kind regards,
> /Carsten
>
>
> On 04/09/2013 06:44 PM, bunk3m wrote:
>> Not sure if this got through or if it's gotten lost.  So a resend.
>>
>> Still need some help to figure out why the balance sheet doesn't balance
>> anymore.
>>
>> Thanks in advance.
>>
>> B.
>>
>> ---Original Send Apr. 5, 2013 13:21---
>> 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.
>>
>> B.
>>
>> 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?