QuickBooks 2009 and Enterprise Solutions 9.0 (and later) support transactions in multiple currencies. Each account, customer, and vendor has an associated currency. Multi-currency support in QB does not extend to employees.
Therefore, when you set up a bank account, you’ll specify the Currency used for that account, as shown below.
In a company file (.qbw) that has already been set up to use multiple currencies, set up each bank account with the single currency in which the account is maintained.
To transfer funds from 1 bank account in 1 currency to another bank account in another currency, there are 3 basic methods:
- Create a vendor for the foreign bank and write a check to that vendor where the account is the foreign bank itself
- Use the Transfer Funds function
- Use a General Journal Entry
See our related article for more information on recording gains and losses on funds transferred to a foreign bank account.
Method 1 – Create a Vendor for the Foreign Bank and Write a Check
Create a Vendor for the bank account that will receive funds, and be sure to include the currency in which the account is maintained.
Next, simply write a check from the account denominated in 1 currency (the Bank Account in USD below) to the Vendor whose records are maintained in the currency of the account receiving the funds (British Bank below). On the Expenses tab, set the Account to the bank account receiving the funds.
Method 2 – Use the Transfer Funds Function
First, make sure you have already created both bank accounts – the bank account that is the source of funds and the bank account that will be the recipient of funds.
Open your General Ledger Chart of Accounts by clicking on the menu selection Lists->Chart of Accounts or using the keyboard shortcut Ctrl + A. Click once on the bank account that will be the source of funds. Be sure to click just once to select the source account, because double clicking will open a register for that account. If you don’t select the correct account, you’ll have a chance to review and correct the account selection before making the transfer.
With the source account selected, right click on the source account to invoke the context menu. Chose Transfer Funds from the context menu.
The Transfer Funds Between Accounts window will allow you to transfer funds between 2 bank accounts. Verify that the source bank account – the one providing the funds – is selected in the Transfer Funds From pulldown and that the recipient bank account – the one receiving the funds – is selected in the Transfer Funds To pulldown. Until you select a recipient account in a currency other than your home currency, the Transfer Currency will be set to your home currency, and you won’t be able to change it. Once you select a recipient account in a foreign currency, you can record an amount to transfer either in that foreign currency or your home currency – QuickBooks will automatically do the conversion for you. Unfortunately, you can’t transfer funds between 2 accounts, both of which are maintained in foreign currencies.
Enter a Memo for the transfer and click either Save & Close or Save & New. According to Intuit as discussed in this Intuit knowledge base article, because of a product limitation in QuickBooks the Memo for the recipient account is not set to the value entered on the Transfer Funds Between Accounts window when viewed on reports such as the Custom Transaction Detail Report. However, our own tests on QuickBooks 2009 don’t confirm this behavior. QuickBooks correctly sets the Memo field on both the source and recipient (target) accounts, and the Memo correctly displays on the Custom Transaction Detail Report.
Once the transfer is recorded, it will appear in the registers for both bank accounts as a TRANSFR transaction type. Here’s the register from the foreign bank account after recording the transaction:
It’s always important to remember that QuickBooks will use exchange rates on file in QuickBooks before you record the transfer. If there’s no exchange rate recorded in QuickBooks at all for the 2 currencies involved, the exchange rate will be set to 1:1 unless you manually enter a new Exchange Rate in the Transfer Funds Between Accounts window before recording the transfer. If there is an exchange rate for the 2 currencies involved as of an earlier date, QuickBooks will use that exchange rate unless you manually enter a new one.
The Transfer Funds function is not unique to company files with multi-currency enabled or to transfers exclusively between bank accounts. With or without multi-currency enabled, you can use the Transfer Funds function to transfer funds between any 2 accounts.
One small advantage this second method offers is that it doesn’t require adding a Vendor to transfer funds between accounts, although in many cases you may have other reasons to create a vendor for a bank account, such as recording bank charges.
For those using or planning to use third-party addons for QuickBooks, the Transfer Funds function has an important limitation. Many third-party addons use the Intuit Software Developers Kit (SDK) to access QuickBooks data, and versions of the SDK up to 8.0 do not provide access to transfer transactions. For example, a custom report built from QuickBooks data gathered using the QODBC driver would not have access to transfer transactions, since the QODBC driver itself can’t access those transactions in QuickBooks. If transactions were recorded with this method, a custom report that relied on this information would be incomplete and inaccurate. Of course, if you don’t plan to use any addons or extract data from QuickBooks, this limitation is irrelevant, because the QuickBooks program itself can display and report on transfers.
Method 3 – Use a General Journal Entry
Another direct method is to use a general journal entry to accomplish the transfer. The account receiving funds is debited, and the account providing funds is credited.
When using this method, it’s important to understand an important limitation: the Currency of the general journal entry must be the Currency of the foreign bank account. Likewise, since most exchange rates in QuickBooks are expressed as a conversion from a home currency to a foreign currency, the exchange rate for a general journal entry is the reciprocal (i.e., 1 divided by the normal exchange rate) of the normal exchange rate.
Through QuickBooks 2010 release 5, general journal entries recorded in the home currency would incorrectly record home currency units in the foreign bank account – instead of converted home currency units.
Because of these limitations, this method is only recommended for advanced users exercising care when recording the transfer.
[ +2 rating, 2 votes ]
Loading ...
Looking for discounts on QuickBooks? Check out our
my organisation has two bank accounts and each account uses USD and Kenya shillings(KES),our incomes comes mainly from donors in the US and these funds are transferred to the dollar account then some dollars are transferred to KES aacount to be used in Kenya,how am i suppose to record these in the USD Bank given that i didnt change it to multi currency?
Marvin – You’ll need to clarify what you need to accomplish a little more. When you say that you have 2 bank accounts and “each account uses USD and Kenya shillings (KES)”, you are referring to your physical bank accounts, since a QB account can only use 1 currency. Are you running multicurrency in QB? If not, you won’t be able to record the KES transactions directly. You’ll have to manually do the conversion and record the transaction in USD. Later, for financial statements, you’ll need to calculate any currency gains/losses, because QB won’t be taking care of that for you.
We bought 130K Canadian Dollars . We paid 100K US $.We have CAD Bank Account and US Bank Acct. How I can record this in QuicksBooks. All report must be in US $. Thanks.
Alexandra, you originally made your comment on a post about home currency adjustments on our knowledge base, which we’re transitioning to the new forum format you see here. Your question isn’t really about home currency adjustments. It’s really about transferring funds between accounts. Take a look at this article and should cover what you need.
If the balance in your USD bank account went down by $100k and the balance in your Canadian bank account went up by 130k CAD, you can do what you want using the Transfer Funds function (Method 2 above), but all of the methods described will work. The important thing to keep in mind is that the conversion rate in QB is from CAD to USD if USD is your home currency. So the conversion rate is not 1.3; instead, it is the reciprocal of 1.3, or 1 divided by 1.3, or 0.76923. That should result in 1.3 CAD dollars showing up in your CAD bank account for each 1 USD transferred.
You have to watch both sides of the conversion, because the math might be just slightly off on 1 side because QB only uses 5 decimal places for the currency conversion. For example, you’ll probably find that the USD side of the transfer is off by 1 cent. In that case, just record the difference to a rounding account using a general journal entry. If you engage in foreign exchange transactions, a rounding account is a good thing to have in your chart of accounts for just these situations. It would normally be an other income (or other expense account), and it would be debited or credited as required to make the side of the conversion that is a little bit off match the actual currency amount converted.
Chief mechanic, we’re using QB for companies in different jurisdictions and some would not allow by law the canging of home currency.
Hayden, we’ve been using daily currency rates and the ‘Currency conversion ledger’ that gets zeroed out regularly just like you. That ledger is our summary ledger for all extra-jurisdiction inter-currency transactions so it’s easier to manage.
Following on from comment 2. The 2 examples both show transfers from the home currency (USD) to foreign currencies, i.e. GBP in example 1 and EUR in example 2. We have a multi-currency setup where USD is the home currency but we also have GBP bank accounts and need to transfer from GBP to EUR. I don’t believe that it is possible to do this directly in Quickbooks so I have created a pseudo bank account for such transfers called “USD transfer account”. To make a transfer from GBP to EUR say, you first transfer from GBP to USD using example 2, and then transfer from USD to EUR also using example 2. It is a bit cumbersome as you have to make sure that the balance in the USD transfer account is zero after each paid of transfers but I can’t see any other way of doing it. Any suggestions would be gratefully appreciated.
Hayden, you’re absolutely right that in US QB 2009 you can’t transfer funds between 2 accounts that both transact in foreign currencies. Your transfer account solution is the most common workaround solution for this. One thought would be to make sure the transfer account is one of the displayed accounts on your company snapshot; that would give you an easy way to observe the balance and make sure it’s always 0.
Which one is the home currency in this example? Would you still recommend using A/Payable when a transaction consists of two foreign currencies? Is it not better to setup a Bank type ‘Currency Conversion Ledger’ as a pass through account in any case (dealing with home/foreign or foreign/foreign)? Thank you
In the above example, the USD is the home currency and GBP is the foreign currency. QB only supports 1 currency (home or 1 foreign) for an A/P Vendor. If you have a transaction that consists of 2 foreign currencies, you could only enter part of the transaction in any 1 vendor. If you really mean that you have a transaction between a home and a foreign currency but the home currency is not the same as the company’s normal home currency, that sounds like a transaction for a different company. When you think of home currency, think of the currency used when the firm prepares its financial reports; every other currency is foreign to that one. If there are a lot of transactions between 2 foreign currencies (rather than between 1 home and 1 foreign currency), you probably need to do financial reporting in 1 of those foreign currencies. If that’s the case, it’s time to create a new QB company file and make one of those foreign currencies the home currency.