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:
 

• Create & edit reports in Spreadsheet Sync
• Spreadsheet Sync troubleshooting
• Post data using Spreadsheet Sync
• Learn about exchange rates

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