cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
artizians
Level 1

This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.

Hi member of this community,

We have multi currency accounts and our system is synced with Wise. I am facing problem when recording funds transfer from our Euro account to CAD account while our base currency is GBP.

 

 

The message displayed is 

 
 

Something’s not quite right

Please click on the rows below to see transaction specific errors.
 
This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.
 
can you guide about this error?

 

5 REPLIES 5
SarahannC
Moderator

This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.

Definitely, yes, I can guide you through recording the funds to foreign currency in QuickBooks Online, artizians.

 

The system won't record the funds with a foreign currency to a different foreign currency account. That is why the error is showing on your end. To avoid getting that error message, let's make sure to record the funds to the same currency account or use your home currency bank account. 

 

As initial steps to fix this, your customer/vendor profile should also be set to the correct currency. Here's how:

  1. Go to the Sales menu.
  2. Within the Customers tab, click New.
  3. Click the Currency drop-down arrow and choose EURO currency.

 

However, if you have created a customer profile already and utilise the Record as transfer option from the bank feed, you can create a dummy home currency account (GBP) to move the funds. 

 

Then, transfer the funds from the home currency account to the CAD account. Here's how:
 

  1. Select + New, then Transfer.
  2. Under the Transfer Funds From column, select the Dummy Bank from the drop-down arrow.
  3. Select CAD bank from the drop-down arrow, under Transfer Funds To.
  4. Under Exchange rate, the exchange rate will automatically appear or you can manually change

 

Also, you may want to explore this article: Categorise and match online bank transactions. It provides additional details on how to manage the downloaded transactions in QBO.

 

If there’s anything else I can help you with, please don't hesitate to let me know by commenting below. I’m always here to assist you further. 

Malek Fandouli
Level 2

This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.

help me im facing the same problem

LeizylM
QuickBooks Team

This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.

I understand that you're experiencing an issue when recording a funds transfer from your Euro account to your CAD account in QuickBooks Online (QBO), while your base currency is GBP, Malek Fandouli. 

In QBO, we cannot directly move amounts from foreign currencies without using the home currency as a partner account. This is why you're getting this error message. 

 

When recording funds transfer, you'll have to make sure that we select the same currency for the vendor's profile and the Account. You can check out this article to learn more about how to transfer funds in QBO. This way, you'll be able to recognize it easily in the register: Transfer funds between accounts. 

 

Don't hesitate to post again if you have any other questions about currency. I'm always here to help. Have a good one.

Malek Fandouli
Level 2

This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.

great thanks for reply but im confused 

im someone help me with this lool my mind will blow up , i can't do lol

RoseJillB
QuickBooks Team

This transaction type doesn't work with foreign currencies. Instead choose Transfer and choose the foreign credit card in the Transferred To dropdown.

I can help and guide you thoroughly in recording the amounts with different currencies in QuickBooks Online (QBO), Malek.

 

My peers in this thread are correct that we're unable to directly record fund transfers with multi-currencies without using the home currency account. Instead, we can record the fund transfers from your Euro to GBP accounts. Then, transfer the amount from GBP to your Canadian Dollar account.

 

Before that, please make sure to turn on your multi-currency setting to allow your company file to set other currencies in your accounts. Then, to accurately record the same amounts when transferring funds, you'll want to check the exchange rates during the transaction created.

 

Since we will need to move funds into your home currency before transferring them into a Canadian Dollar transaction, let's create a clearing account set in GBP or your home currency. Clearing accounts are used to move money from one account to another account when you cannot move the money directly.

 

Here's how:

 

  1. Head to the Accounting menu from the left navigation pane and choose Chart of Accounts.
  2. Select the + New button to create a new account.
  3. Choose Cash at Bank and in Hand under the Account Type dropdown, and select Cash on Hand under the Detail Type dropdown.
  4. Type barter or a name that will identify the account in the Name field.
  5. Set the Currency to GBP British Pound Sterling.
  6. Press the Save & Close menu.

 

To start recording the transactions, let's go over to your Euro account and locate the funds. I'll show you how:

 

  1. Go to the Banking menu and navigate to the Banking tab.
  2. Tap your Euro account tile to see transactions in it.
  3. Select the bank transaction you want to transfer to.
  4. Tap the Record as transfer radio button and select the barter account you created from the Transferred to dropdown.
  5. Add the necessary details you may need and click Add.

 

Lastly, let's move the funds from your barter account to your Canadian account:

 

  1. Click the + New icon and select Transfer.
  2. Select your barter account in the Transfer Funds From dropdown.
  3. In the Transfer Funds To, select your CAD account.
  4. Enter the amount in the Transfer Amount. To get the accurate amount, you can refer to the exchange rate when the transaction was created or follow this formula: Balance/Exchange Rate = Transfer Amount.
  5. Then, Save and Close.

 

Now you have moved the amount, we can manually upload a transaction to match the transferred funds. Please go to your Canadian Account from the Banking tab and follow the steps in this article: Manually upload transactions into QuickBooks Online.

 

Alternatively, you can directly Exclude the transaction from your Euro account and manually import this into the Canadian account.

 

  1. Go to the Banking menu in the left panel and choose Banking.
  2. In the For Review tab, select the particular transaction you are referring to.
  3. Tap on the Exclude button.

 

After that, manually calculate the amount to enter into your Excel file and import this to your Canadian Account bank feeds.


Moreover, I still recommend consulting with your accountant to get you guided along the process.

 

Furthermore, learn to reconcile your account to keep your books accurate and prevent discrepancies.

 

Let me know if you have more concerns about managing your bank transactions. The Community is 24/7 available to help.

Need to get in touch?

Contact us