I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange rate are required for transaction in foreign currency. However there is no column to enter the exchange rate. Maybe you can't really use Spreadsheet sync to update foreign currency transactions.