cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Xavier
Level 3

Show Exchange Rate on Invoices

Hi. How can we show the exchange rate on invoices?

From this month, one of our clients requires FX rate along the VAT amount. Thanks

3 REPLIES 3
LouiseG
QuickBooks Team

Show Exchange Rate on Invoices

You'll need to assign a foreign currency to your customer's profile to display the exchange rate on the invoice, Xavier. Allow me to provide further details below.

 

First, you'll need to activate the multicurrency feature in QuickBooks before you can configure foreign currency settings for your customer's profile. This feature allows you to manage transactions in various currencies different from your local currency. Please note that once enabled, this feature cannot be deactivated and is available in the Essentials, Plus, and Advanced plans.

 

Upon activation, you can then set a foreign currency for your customer's profile. If a customer was created before this setup, you need to deactivate that customer and create a new profile with the appropriate currency settings.

 

Here's how:

 

1. Navigate to the Sales, then Customers.

2. Click New customer.

3. In the Customer information window, select the customer's currency from the Currency dropdown field. This is the currency that the customer uses to pay you for products or services.
image (41).png

4. Fill out the required information.

5. Hit Save.

 

Remember, once a customer’s currency setting is saved, it cannot be changed. For additional details, you can visit the guide: Assign a foreign currency to a customer in QuickBooks.

 

Moreover, when generating an invoice, please refer to the attached screenshot to see how the Rate and VAT are applied. Keep in mind that QuickBooks uses exchange rates from IHS Markit, and you'll need to select the appropriate VAT rate for the invoice.

image (42).png

Furthermore, if you prefer to use your exchange rates for foreign currency transactions, you can consult this guide for assistance: Enter and use your exchange rates in QuickBooks Online.

 

For future reference, I'll leave these resource for using the multicurrency feature when assigning a currency to a bank account: How to add a foreign currency account.

 

The information above serves as a comprehensive guide to managing foreign currency transactions in QuickBooks. These steps effectively enhance your ability to handle international business dealings with ease. If you have additional questions or concerns about foreign currencies, don't hesitate to click the Reply button below. I'm always here to assist you.

Xavier
Level 3

Show Exchange Rate on Invoices

Hi Louise

Thanks but how can we show/display the exchange rate on our invoices?

X

RazzieE
QuickBooks Team

Show Exchange Rate on Invoices

Hi, @Xavier. Thank you for getting back in the thread, i understand that displaying the exchange rate alongside the VAT amount is essential for compliance with your client's requirements.

To begin with, QuickBooks Online (QBO) doesn't have a direct option to add the exchange rate on your printed invoice forms. You can submit your feedback to our development team, which will help us enhance your overall QuickBooks experience. To do that:

  1. In your QBO account, go to Settings and select Feedback.
  2. Enter your product suggestions.
  3. Then, click Next to submit them.

However, we have a workaround to display the exchange rate on your printed invoice. You can use Custom fields and enable the Print on form option for Invoice to display this information.

Here's how:

  1. Go to the Gear icon.
  2. Select Custom fields.
    image_720.png
  3. Click Add field.
  4. In the Name field, enter "Exchange rate".
  5. For the Data type, select Text and number.
  6. Check the Invoice box, then enable the "Print on form" option for that field.
    image_720.png

Let’s print a test invoice to see if the exchange rate will display.

 

  1. Go to the +New button, then select Invoice.
  2. After filling in the necessary information on the invoice, copy the highlighted box and paste it into the exchange rate box.
  3. Click Print or Preview button
    image.png

    You will now see the exchange rate on your printed invoice.

    image (2).png

Furthermore, you can visit this article to learn how to personalize and add specific information to your sales forms: Customise invoices, estimates, and sales receipts in QuickBooks.

If you require any additional information about foreign currencies in QBO, please feel free to ask. Have a wonderful day.

Need to get in touch?

Contact us