If your business frequently makes sales or purchases in a different currency than your main Business Currency, there's a good chance you have one or more Foreign Currency Bank Accounts.
Recording transfers between accounts in different currencies is a little tricky, as you need to ensure ensure the exchange rates used line up correctly with the rate your bank actually gave you on the transfer, and also account for Currency Gains and Losses. But don't worry — by following the steps in this ‘How to’ guide, you'll quickly be able to get on top of Foreign Currency Bank Transfers.
“It's a transfer, Jim, but not as we know it!”
Transferring funds from a foreign currency account is essentially the same as transferring funds between two accounts in your home currency, with one additional step.
So before we get into the detail, let's remind ourselves the normal way that you transfer funds between two accounts. Say, $100 from 'Checking' to 'Saving':
- Add (or locate, if you have the bank connected for auto updates) a $100 Expense transaction, paid from the sending account ('Checking Account', in this example).
- Add (or locate, if you have the bank connected for auto updates) a $100 Income transaction, paid into the receiving account ('Saving Account', in this example).
- Select the checkboxes next to the two transactions, and click the Transfer button at the top of the Transactions table.
“How hard can it be?”
So, how is this different when the accounts are of different currencies? Not very, but there are two issues we need to deal with:
- Chances are, the exchange rate you get from your bank will be different to the daily mid-market rates that Wave uses by default. You're going to need to tell Wave the actual rate achieved; and
- We want transactions in your Foreign Currency account to be shown in the Foreign currency, and transactions in your Home Currency account to be shown in the home currency. To do this, we're going to need to make the transfer in two steps, via an Undeposited Funds account. Don't worry... we'll explain this in detail!
“OK. Let's do this!”
Let's take a scenario and go step-by-step:
Here are the steps you'll need to take:
- If you don't already have one, create an ‘Undeposited Funds Account’. This is simply a bank account called ‘Undeposited Funds’ (or any other name you prefer, that says to you it is not a real, physical bank account). To create this:
- Click Accounting on the left navigation bar in Wave, then Chart of Accounts.
- Click the Add an Account button, then browse on the Asset tab into Bank => Bank & Cash => Other Bank Account.
- On the Edit account dialog that displays, overwrite ‘Other Bank Account’ with ‘Undeposited Funds’; make sure the ‘Payment Account’ checkbox is checked, and that your Home Currency is selected.
- Finally, click the Save button.
- Add (or locate, if you have the bank connected for auto updates) the US$3,702.09 Income transaction that represents the deposit into your US$ bank account (called 'Checking Account', in this example).
- Add (or locate, if you have the bank connected for auto updates) the Expense transaction that represents the withdrawal from your CA$ bank account (called 'Checking Account (CAD)', in this example). Enter the amount of the expense in the Foreign Currency of the bank account, i.e. in CA$ for this example.
- Create an Expense transaction from your ‘Undeposited Funds’ account for the Home Currency amount that you transferred to your Home Currency bank account.
- Create an Income transaction into your ‘Undeposited Funds’ account for the Foreign Currency amount that you transferred from your Foreign Currency bank account, and adjust the exchange rate so that the ‘Home Currency’ amount matches the expected amount.
To record the Foreign Currency amount into your Home Currency ‘Undeposited Funds’ account, drop down the Details tab of the Transaction and set the Foreign Currency (CAD - Canadian dollar in this example). Insert the correct Exchange Rate, which will be simply the home currency amount received (US$3,702.09 in this example) divided by the foreign currency amount sent ($5,000 in this example). When you enter the correct rate, you will see the currency converted amount shown by Wave (in the red box, in the screenshot) matches the figure you expect.
- Finally, go ahead and complete the two Transfers that represent:
- Transferring the Foreign Currency amount from your Foreign Currency Bank Account to your Undeposited Funds account (and converting it to Home currency); and
- Transferring the converted amount from your Undeposited Funds account to your Home Currency Bank Account.
Note: When you process the first Transfer, Wave will probably re-order your transactions. Don't get caught out!
Using these steps, you can record a transfer that shows as a withdrawal in foreign currency from your foreign currency account, and a deposit in home currency to your home currency account. High 5! You're a foreign currency bank transfer super-hero!
Frequently Asked Questions
Help! I can't edit the Exchange Rate!
Wave displays an editable Exchange Rate field any time you are processing a transaction in a currency that is different to the currency of the Payment Account. If you cannot edit the Exchange Rate, that means that the currency you are recording the transaction in is the same as the account currency. In the example above, that would mean you were trying to record the transaction in US Dollars.
Do I really need to do two transfers? Why can't I just transfer directly between accounts, and adjust the exchange rate?
It is possible to transfer directly between accounts in different currencies, but remember that to adjust the exchange rate, you need to be recording a transaction that is in a different currency to the account currency. Going back to the example above, you could record a US$ withdrawal (expense) of US$3,702.09 from your Canadian Dollar account, and adjust the exchange rate to make this equal to CA$5,000. Your transfer would then work.
The problem this would cause is that you now have ‘Home’ (US$) and ‘Foreign’ (CA$) transactions in your Foreign Currency account, which would make balancing and reconciling the account very complicated. The method shown above “isolates” the currency switch in your ‘Undeposited Funds’ account, which should always come back to a zero balance after each set of transactions.
While I had money in my Foreign Currency Account, the exchange rate changed. How do I record the gain (or loss)?
Tracking currency gains and losses in foreign currency accounts is much easier when you use the method detailed above to record your transfers. There are a few steps to be aware of, so we have a whole separate article about this topic.