Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 15, 2019
Solved

Multicurrency Exchange Rate

  • February 15, 2019
  • 11 replies
  • 39 views

Hi,

 

Just a quick question hopefully....

 

I have just set up multicurrency, as I might be starting a new contract in Belgium shortly and I believe that my invoices will be billed and paid in Euros.

 

Now, each time I raise a bill, the euros side will be fine, as I will bill in Euros and will be paid that amount of Euros, but the conversion from my business account, I suspect will differ each time, since the exchange rate will fluctuate.

 

My question is, if I set the exchange rate in the settings manually, will this affect past invoices?  By that, I mean would it go back and amend the exchange rate used in all previous invoices?  Or will this only impact new invoices/payments received?

 

Obviously, the aim is to end up where the converted (exchanged) euro payment in to Pounds matches the Pounds amount on my invoice so that everything matches up nicely :-)

 

Thanks

 

Andrew

Best answer by TaliaI

Hello Andrew,

 

Welcome back to the Community - thank you for your question!

 

If you alter the exchange rate within the settings, it will not affect any previous invoices/payments, only those going forward.

 

Please let us know if you have any further questions.

 

Thank you,

 

Talia

11 replies

TaliaIAnswer
Level 8
February 15, 2019

Hello Andrew,

 

Welcome back to the Community - thank you for your question!

 

If you alter the exchange rate within the settings, it will not affect any previous invoices/payments, only those going forward.

 

Please let us know if you have any further questions.

 

Thank you,

 

Talia

pezzaAuthor
February 15, 2019

Thank you Talia. Perfect!

July 27, 2020

Hello again, @pezza.


Thanks for sharing such detailed information. It gives me an overview on how to help you handle your transactions in QuickBooks.

 

Based on the information provided, the Multi-currency feature will help you manage them. Just a heads up, this feature is only available in the Essentials and Plus version.

 

If that’s your current subscription, let me walk you through the process of activating it.

 

Here’s how:

 

  1. Go to the Gear icon at the top, then select Account and Settings.
  2. Choose Advanced on the left panel.
  3. Click on the Pencil icon for Currency, then select Home Currency.
  4. Mark the box for Multi-currency.
  5. Click on Save and Done.

Since you’ll be accepting Euro and Pounds, make sure to create these customers and banks in QBO. This will help you efficiently track transactions for each currency.

 

To add customers:

 

  1. Go to Sales on the left panel, then choose Customers.
  2. Click on the New customer button.
  3. On the Customer information window, enter the information for your UK agency/ EU client.
  4. Click on Save.

To add the foreign currency accounts:

 

  1. Go to the Gear icon at the top, then choose Chart of Accounts.
  2. Click on New in the upper-right hand.
  3. Choose the correct Account and Detail Types.
  4. Enter the account’s name in the Name field.
  5. Under Currency, click on the drop-down and choose GBP British Pound Sterling/EUR Euro.
  6. Click on Save and close.

After setting them up, you can now create invoices and accept payments in Euro. Once done, transfer the funds from your EU account to the GBP bank.

 

In regard to your other question, you don’t have to create another expense account for each currency because the amounts recorded in QBO are based on the home currency, and it goes the same way on your reports. However, you can run the Balance Sheet report to check the data for each currency.

 

The information I provided should point you in the right direction.

 

If you have additional questions about QBO, reach out to me by posting a comment below. I'm here to assist you further.

 


Hi, 

 

Thank you for the details explanation and steps here. 

I have a more important questions as since we deal with customers with different currencies - is there any way to fix the pricing to that currency and not base it on the exchange rate?

 

For examples, 

I sell the home customer (US) at $10.00 per unit. However I would like to sell to a foreign customer (UK) at £15.00 per unit. 

The currency exchange will give the price per unit £8.50 for instance.

 

Is there anyway to set it to £15.00 without involving the currency exchange? if this is possible it will be great help.