cancel
Showing results for 
Search instead for 
Did you mean: 
FortyTwo
Level 1

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?


Hi

I thought I'd share my solution to the problem. Possibly not the most elegant solution - but in real-world terms it was the most time-efficient solution.

 

So my main QB currency is GBP, but I have a USD bank account and a EURO bank account, and I wanted to document a transfer between the USD and EURO bank accounts.

So in the Chart Of Accounts, I created a new "bank account" called QB Transfer Workaround (So I wouldn't forget in 6 months why I did this!) with the currency set to my main currency (GBP).

I then connected the transfer from the USD account to the QB Transfer Workaround Bank account, recording the transfer as a USD to GBP transfer.

I then recorded a transfer from the QB Transfer Workaround Bank account to the EURO account.

 

So rather than the transfer being from USD to EURO, I made it USD to GBP to EURO.

As long as you set the exchange rates to the correct amount you will end up with zero funds in the QB Transfer Workaround Bank account (i.e.: the USD exchange rate created the exact amount in GBP that I needed to cover the EURO transfer.) and it will not cause any changes to the overall accounts.

(The first time I tried I didn't adjust the exchange rates and made $17,000 in exchange rate differences - if only!!)

Once this is set up like this, I just repeat the above for any transaction that goes between the USD and EURO account.

I hope that makes sense - and is of some help to everyone having problems with this bug.

 

Kind regards

Robert

David G2
Level 1

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

The fix proposed in 2018 does not work for me. When will this actually be fixed? Are there any other so-called "work-arounds" because the one proposed does not work.

AlexV
QuickBooks Team

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

Good day, David G2.

 

There's a new investigation about this error that occurs when reviewing multi-currency transactions in bank feed. Our product team is now fixing it. I suggest contacting our Customer Support Team so you'll be added on the list of affected users and will receive updates.

  1. Go to Help (?) and select Contact Us.
  2. Enter INV-49466, then select Let's talk.
  3. Choose either Message an agent or Get a callback.

Post again if you have more concerns. We'll respond as soon as we can.

Umair Khan
Level 1

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

So this is how I resolved the problem:


I realised that I had a 'Payee' set up. So some transactions were being assigned a 'Payee' (lets say 'Amazon' for example). This was showing up on the transaction brief. However when I clicked on the transaction to go into details (where it shows you description, conversion amount etc, the 'Payee' section was empty and I could not see 'Amazon' listed - this was strange. So I simply de-activated 'Amazon' (made 'inactive' in the Expenses --> Supplier area) . Once I inactivated, the problem resolved itself! :)

Hope this helps.

Umair

Gulzira
Level 1

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

Dear Quickbooks Team,

 

I am currently posting some audit adjustments by creating Journal Entries in our home currency - USD, and getting an error "Transactions can have only one foreign currency at a time".I believe, it has something to do with the banks which are not in USD. 

 

I am therefore, thinking to post all journals which are not related to non USD bank accounts at once, and then post rest of the non USD bank account adjustments separately.

 

I would like to know if i am taking the right approach or shall i be doing something else to resolve this issue with the stated error and run my TB and further reconcile the BS to the signed accounts. .

 

Number two question is: what does that mean to include the bank account equivalent currency, so our bank reconciles correctly? How do I do that to ensure correct BR to happen? 

 
Thanks very much in advance for your advice and I am looking forward to hearing from you soon.
Kind regards,
Richard
Gulzira
Level 1

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

Dear Quickbooks Team,

 

I am currently posting some audit adjustments by creating Journal Entries in our home currency - USD, and getting an error "Transactions can have only one foreign currency at a time". 

I believe, it has something to do with the banks which are not in USD. 

 

I am therefore, thinking to post all journals which are not related to non USD bank accounts at once, and then post rest of the non USD bank account adjustments separately.

 

I would like to know if i am taking the right approach or shall i be doing something else to resolve this issue with the stated error and run my TB and further reconcile the BS to the signed accounts. .

 

Number two question is: what does that mean to include the bank account equivalent currency, so our bank reconciles correctly? How do I do that to ensure correct BR to happen? 

 
Thanks very much in advance for your advice and I am looking forward to hearing from you soon.
Kind regards,
Richard
Kristine Mae
Moderator

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

Let me help you sort this out, Richard.

 

In QuickBooks Online, you can only create a transaction with one currency at a time. Our program blocks entries with mixed currencies since it can lead to an incorrect open balance or incorrect exchange gains or losses. We have different ways to record the transactions. Feel free to check this article for the steps: Multi-Currency: Journal Entry Error Message.

 

Concerning your second question, you'll have to select the bank account with the same currency as your transaction. You'll just have to ensure to select the bank account to have an accurate business register (BR). This way, you can reconcile them correctly as well.

 

If you have additional questions, don't hesitate to let us know. We'll reply as soon as we can. Take care!

Gulzira
Level 1

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

Dear Quickbooks Team,

 

Thanks very much for your response. It makes sense, but I am left a little bit lost with 2 main points:

 

1) i have got my audit adjustments prepared all in our home currency USD, but i have some banks in two other currencies: EUR & GBP. As an example, below are the audit adjustments to be entered in the separate two journal entries, but the amount is prepared in USD. How can I reflect this amount in the USD, GBP and EUR bank accounts and which currency rate shall i use? Where can I find this currency exchange rate?

2) Do i need to show e.x. below adjustments only in the EUR/GBP and/or plus the USD bank account? If, yes, how?

2020012Accounts Payable EUR                        723
2020013Accounts Payable GBP                        387
1090202Banks EUR:BOC EUR                        390
1090302Banks GBP:BOC GBP                        689

Thanks a lot for your advice and I am looking forward to hearing back from you. I highly appreciate your help.

Best regards,

Richard

MR88
Level 2

We're getting the 'Transactions can have only one foreign currency at a time.' error. What is the solution or workaround?

My issue with multicurrency has been going on since March 2021. I've spent hours on the phone with support and then they assured me the issue was moving on to engineering. It is still not resolved.

 

A customer was invoiced in GBP for £9,000. They paid with a credit card and we received $12,535.70 USD, with another $15,000.00 payment the same day from a different customer. Once I separated them and deposited the $15k manually, that one worked. The $12,535.70 would not. The money popped up in QB's "trash" account Opening Balance Equity, even though the money was also in our bank account. I finally wrote a JE to move the money to Sales. Now that amount still sits waiting to be deposited. I get notices all the time that I need to deposit it. But no matter where I put it is appears in the wrong place on the balance sheet.

 

In short, the total is in our bank account, in sales, and waiting to be deposited, or else it will show up inaccurately in our balance sheet. Please, please pass this on to your engineers. 

 

 

Need to get in touch?

Contact us