cancel
Showing results for 
Search instead for 
Did you mean: 
greg-yochim
Level 1

I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange.. But there's no column for rate?

I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange rate are required for transaction in foreign currency. However there is no column to enter the exchange rate. Maybe you can't really use Spreadsheet sync to update foreign currency transactions.
4 Comments 4
ZackE
Moderator

I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange.. But there's no column for rate?

Thanks for becoming part of the Community, greg-yochim.

 

Since you're receiving a message informing that your currency and exchange rate are required for a transaction in a foreign currency, I'd recommend making sure the template you're working with is formatted properly and includes all of its required data.

 

When a template's open in Excel, you can edit it and add data to it. You mention that yours is missing a column for exchange rate. Since the message you're encountering advises you'll need a rate specified, you can add a new column to your spreadsheet.

 

Here's a video showing how it's done:

 

 

If you need additional assistance customizing a spreadsheet, I'd recommend getting in touch with our Customer Care team. They'll be able to pull up the account in a secure environment and conduct further research with you.

 

They can be reached while you're signed in.

 

Here's how:

 

  1. Use the Help (?) icon.


     
  2. Click Contact Us.


     
  3. Enter a description of your situation in the What can we help you with? field, then hit Let's talk.


     
  4. Select Start messaging or Get a call.

 

Be sure to review their support hours so you'll know when agents are available.

 

I've also included a few detailed resources about working with Spreadsheet Sync and exchange rates which may come in handy moving forward:
 

 

I'll be here to help if there's any additional questions. Have a great Thursday!

greg-yochim
Level 1

I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange.. But there's no column for rate?

I have been in contact with support and apparently this is a known issue, and is being worked on.

 

It seems like there should be a fairly easy solution. The exchange rate field just needs to be added to the data being passed to Spreadsheet Sync, since exchange rate is a field on every transaction involving foreign currencies.

AN34
Level 2

I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange.. But there's no column for rate?

Yep, I have the same problem. I want to post journal entries in foreign currency, but in the "Journal entry" template, there's no column to fill the exchange rate. Only column for "Currency" which we can select a foreign currency. How could it be that funny way with this template?

RogelioL
QuickBooks Team

I'm using foreign currencies, and when I try to use Spreadsheet sync to update transactions, I get an Error - The currency and exchange.. But there's no column for rate?

Hello there, @AN34. Let me share some information on how to put the exchange rate in your Journal Entry.

 

To begin with, please ensure to turn on the multi-currency feature in the Accounts and Settings.

 

Once done, let's go to the Journal Entry and begin navigating by following the steps I've provided below:

  1. Click the +New, then select Journal Entry
  2. In the Currency field, choose a different currency. 
  3. After this, you can now input the exchange rate.

 

Please note that some accounts, such as Home Currency, Account Receivable, and Accounts Payable, do not have an exchange rate.

 

Moreover, you can check out this article if you get an alert because your accounting has journal entries that mix currencies for customers or vendors: Mixing currencies in journal entries.

 

You can also check out this article to learn how to enter your exchange rates so you can use them for foreign currency transactions: Enter and use your exchange rates in QuickBooks Online.

 

Let me know if you have additional concerns about exchange rates in Journal Entry or any QuickBooks-related queries. Keep safe. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us