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

How do I bulk-add foreign currency transactions?

When I'm in a dollar account, the option to select and bulk add transactions is not there.  I can't even add individual transactions unless I first click on the transaction. Otherwise it says 'enter the exchange rate'. But I don't enter the rate - Quickbooks fetches the rate itself.

 

I have thousands of transactions in US dollars so it's very obviously not practical for me to go into every one, click and then add.  I thought I had found a way around this by creating a rule to auto-add these transactions, but to my horror I find that the exchange rate is now pulled in as 1 GBP to 1 USD for these 'rule' added transactions.

 

Please tell me there's a way to bulk import these dollar transactions while keeping the exchange rate calculation, and please tell me how to do it. 

 

Thanks!

6 REPLIES 6
QuickBooks Team

Re: How do I bulk-add foreign currency transactions?

Thanks for coming in with us today, delicado.

 

Transactions with the same currency as your home currency will automatically go through the bank.

 

However, the system will prompt an error if you're adding transactions that are different from your home currency. This is the reason why the Accept selected option or bulk add transaction is not there.

 

You'll need to manually expand each transaction to confirm the exchange rate to populate, then add them.

 

Learn more about the multi-currency feature in QuickBooks Online through this link: Turn on and use multicurrency.

 

If you have more questions, just let me know. I'm always happy to help.

Level 6

Re: How do I bulk-add foreign currency transactions?

consider 3rd party data importing tool

https://transactionpro.grsm.io/qbo

 

Level 2

Re: How do I bulk-add foreign currency transactions?

Hi.

- However, the system will prompt an error if you're adding transactions that are different from your home currency. This is the reason why the Accept selected option or bulk add transaction is not there.

 

My question is why will the system prompt an error? If I can click them individually and add them successfully with the exchange rate, why would there be an error if I do it in bulk?

Could you please log a feature request 'allow bulk import of transactions'. I appreciate it might take a developer a day or two to make it work, but it would save me a day or two every few months, and I'm one of (I assume) millions of customers that you have.

 

I'm consistently astounded at how QB online fails with *every single* thing that I need it to do.

 

 

 

Level 2

Re: How do I bulk-add foreign currency transactions?

Thanks for this Plung.  $149 for a year isn't terrible if it works. Isn't it pathetic that this artificial market is created by the core software fundamentally not doing lots of basic things!

QuickBooks Team

Re: How do I bulk-add foreign currency transactions?

Hi delicado

 

We will certainly raise a product enhancement request for you and we encourage you to leave feedback from within the product.

Level 2

Re: How do I bulk-add foreign currency transactions?

Thanks! Sorry for the grumpiness - it's just how using QB makes me feel; nothing personal!