Foreign Currency results in non balanced balance sheet

c-a-l c-a-l at earthlink.net
Sat Mar 6 13:26:00 EST 2010


I'm trying to isolate the source of the imbalance balanced sheet.  No income
and expense have been entered in the following example, so that should not
affect the numbers (except to the extent that there is income/expense due to
the foreign currency transactions, which if I am just dealing with one day,
and the transfers were made on that day, there should not be any).

Started by entering opening balances of US bank accounts as of 9/1/08.
Entered US dollar liabilities as opening balances, also as of 9/1/08.
Entered Fixed Assets, as of 9/1/08
Entered Investments, as of 9/1/08

Everything balances just fine.

Entered opening balances of Euro bank accounts as of 9/2/08

Price Source has an entry for 9/1/08 and 9/2/08 all Stocks and 9/2/08 for
Euro

Balance sheet as of 9/2/08 does NOT balance if I select as Price Source
"Nearest in Time", which has a 9/2/08 entry.  If I select Average or
Weighted it will Balance.

However, using Average or Weighted and setting the Balance Sheet date 9/2
results in incorrect values for the investment accounts as of 9/2.  To get
the Balance Sheet to show the correct value of investment accounts, I must
select "nearest in time."  Doing so apparently messes up the foreign
currency and then there is an imbalance.

I can totally get rid of the imbalance by deleting all the foreign currency
accounts, so I KNOW that is what is causing the problem.

This is making me crazy.  I MUST turn in a balanced balance sheet, that
shows the actual values of the securities on the date of the balance sheet. 
What do I do????

-- 
View this message in context: http://n4.nabble.com/Foreign-Currency-results-in-non-balanced-balance-sheet-tp1582974p1582974.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list