cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
sean-tlysolution
Level 2

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

 
Solved
Best answer December 16, 2021

Accepted Solutions
EmmaM
QuickBooks Team

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

Hello Sean, The rules only work on GBP transactions because of the fx rate needing to be agreed upon (some users use their own rate and want to amend the rate QB uses) so unfortunately if you created the rule it would not auto add.

View solution in original post

5 REPLIES 5
Ashleigh1
QuickBooks Team

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

Hello Sean-tysolution, 

 

Welcome to the Community page, 

 

Can you please go to the main cog wheel>company settings and select advanced> then go to currency and check that you have set it up correctly in there. When you create an invoice on the date you create it, it will put in the exchange rate if using on  the bank, it should auto fill it for you anyway. 

sean-tlysolution
Level 2

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

Hello Ashleigh,

Maybe I'm missing something. It seems to be set-up correctly in Advanced settings, but all I can do as far as I'm aware is check that Multicurrency is on. I can set it for each Invoice but that's not the way I'm using Quickbooks. Here's some more info:

All the transactions are pulled in from my Wise USD account so they are already in dollars, but when I want to add them to my accounts I get the message shown in the attached screenshot. If I click on the transaction, it expands showing the exchange rate has been worked out backwards to GBP automatically, so I just click add. I say just, but this is two clicks for what will be 100's of transactions. Obviously I'd like to use the auto-rules for this number of transactions but I can't with this error message. These are purchases and no invoices are being raised.

I hope this makes more sense. Is there anyway around having to do this?

Many thanks for your time,

Sean

EmmaM
QuickBooks Team

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

Hello sean-tlysolution, To confirm, essentially you would like to create rules for the US currency transactions so that they auto add to QB is that correct?:smiling_face_with_smiling_eyes:

sean-tlysolution
Level 2

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

Yes, that's correct and put much better than I did... Thanks

EmmaM
QuickBooks Team

Can I stop QBs asking for 'exchange rate or original foreign currency amount' so that I don't have to manually enter every transaction in a foreign currency account?

Hello Sean, The rules only work on GBP transactions because of the fx rate needing to be agreed upon (some users use their own rate and want to amend the rate QB uses) so unfortunately if you created the rule it would not auto add.

Need to get in touch?

Contact us