cancel
Showing results for 
Search instead for 
Did you mean: 
PhotoJoseph
Level 2

Foreign currency future-date exchange rate should pull from latest rate available

When working with multi-currency, everything is ultimately converted back to your home currency for reporting. The conversion rate is automatically populated based on the date of the entry. Makes sense. However often I'm entering foreign currency bills that are due in a future date, scheduling a payment through my foreign currency bank, and entering that bill as "paid" on the future date in QBO. Pretty standard stuff.

 

The problem is that since the date is in the future, QBO can't pull the exchange rate. So it just gives you an error. The best solution I've come up with is to modify the date to today/yesterday, copy the exchange rate that's now automatically populated, change the date back to what it should be, and paste the exchange rate in. This isn't going to be 100% accurate but it's close enough, and I have to enter something or I can't proceed.

 

See below; (1) the error, (2) the empty exchange rate.

 

CleanShot 2024-05-08 at 08.56.11.jpg

 

Unless there's a solution I'm missing, I'd like to see QBO offer to use the latest exchange rate available (which is what I'm doing, but in a manual and convoluted way), or to note that it's temporary and then update it with an actual exchange rate when that date passes. Automatically, of cou

1 Comment 1
MAnneJ
QuickBooks Team

Foreign currency future-date exchange rate should pull from latest rate available

I can see the importance of an auto-updated exchange rate when creating bills in QuickBooks Online in your business, @PhotoJoseph. However, this feature is unavailable. I recommend sending feedback. This way, it'll help our Product Engineering team to add this in future enhancements.

 

Here's how:

 

  1. Go to the Gear icon, located at the top right corner.
  2. Select Feedback.
  3. Enter your suggestions/comments and click Submit.

Your feedback will be highly appreciated. You can also track the status of your request in our customer Feedback for QuickBooks Online.

 

Moreover, you might want to check this article and learn how to handle bills to be paid later and bills to be paid immediately using bills, checks, or expenses: Learn the difference between bills, checks, and expenses in QuickBooks Online.

 

The Community is open to your queries if you need additional assistance managing your bills. I'm always available. Keep safe. 

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

Need to get in touch?

Contact us