How do I complete cash transfers with the Investment Bookkeeping worksheet?

Foreign cash is converted using Bank of Canada forex rates as a starting point. When increasing USD you can make required adjustments to the ACB of the USD. When you are decreasing USD, you can make required adjustments to the realized gain/loss.

All cash transfers between accounts not included on the worksheet are balanced manually on the JE tab keeping everything fully integrated.