We typically post in the same account in several currencies. The danger here of course is adjustments made in USD only attempting to clear the ending balance will leave "orphaned" FX balances in that account that continue to try and revalue, cause issues, etc. Anyone found a way to easily get a balance by currency in an account? I know there's that Unrealized report, but I think it's frankly pretty confusing and unintuitive. I know you can build a search, dump to Excel, and then add a running balance column, but for Balance Sheet accounts you obviously have to do that from the beginning of time and that doesn't work great when you have a high volume and old account. Anyone have a better way?

We just use a saved search showing the subsidiary, account, transaction amount (debit/credit), and currency (summarized).

yeah that's what I ended up doing too. it's kind of wild that there's not some standard report that shows this.