We have a foreign bank account (CAD) in our USD subsidiary. The unrealized loss on the account has been steadily growing and is so large that it does not make sense to me given the exchange rate between USD and CAD. In currency revaluation entry, I can see that the "Base currency balance" is higher than I would expect.
The Foreign balance for the account agrees to the bank statement and the the ending result post currency revaluation is correct however we report cash balances prior to the final close process which includes the revaluation entry. This has caused issued with the accuracy of our preliminary cash reporting.
This account has
1) cash receipts which we apply to open AR and I can see a realized gain/loss recorded on this activity
2) cash payments which are applied to open AP and i can see a realized gain/loss recorded
3) transfer of funds from the CAD account to the USD account (this is being recorded via a standard CAD$ JE decreasing the CAD account and increasing the USD account using the actual exchange rate to get to the USD amount received)
how do I see the build up of the Base currency balance to try to figure out what might be causing the issue?
Any other ideas of what I should be looking into?
Thanks!