Having a little issue with a report. We have a Balance sheet that shows subsidiaries and has the Amount and Amount (Foreign Amount). For a bank account under the subsidiary there is an amount under the "Foreign Amount", but $0 under the Amount (USD). When I click into the general ledger I don't see the amounts on the report listed there in either views (Consolidated or Subsidiary specific) No other subsidiaries bank account acts like this. I did it with another account and it both values that are in the balance sheet report are present in the general ledger when viewing consolidated or subsidiary specific.

how big is the FX balance? is it possible someone just tried to clear the balance but did it in USD vs the bank acct currency?

It's about 4800 CAD

see if there are any non CAD activities booked via journals

So there were 2 GBP transactions under that account, but I was confused because it didn't seem to total out. What it was is that the Amount - Foreign Currency column just totals the columns regardless of currency and acts the same way a save search would. So the difference between CAD and GBP was the 4800. It's also why when I clicked into see details the $4800 would go away.