cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
YaffaS
Level 1

Importing CSV with Multicurrency

I want to import a CSV into QBO Essentials. I have $ as my main currency and I want to import ILS transactions. How do I ensure the transactions are imported in ILS? I have enabled multicurrency.

4 Comments 4
LeizylM
QuickBooks Team

Importing CSV with Multicurrency

Thank you for posting here on the Community page, YaffaS. 

 

I can share with you on how multicurrency works in QuickBooks Online. 

 

The option to import or sync currencies other than the once used by your bank isn't possible. If your bank account is in the United States, the currency that will be imported is still the US $. As a workaround, you can convert the amount to the same currency at your local bank.

 

Once you've successfully imported the transactions, you can already categorise and match them.

 

I'm adding these articles to help you maximize the multi-currency feature in QuickBooks: Multi-currency FAQ.

 

Keep me posted for additional questions or other concerns while importing your bank transactions in QuickBooks Online. I'd be more than happy to help. Wishing you the best of luck.

Fiat Lux - ASIA
Level 15

Importing CSV with Multicurrency

@YaffaS 

What kind of transaction type do you need to import? Invoice, Sales Receipt, Bill, or else?

YaffaS
Level 1

Importing CSV with Multicurrency

I need to upload several expenses into my bank account which is in ILS.

Also, can I add a tag into the import sheet?

Fiat Lux - ASIA
Level 15

Importing CSV with Multicurrency

You can prepare the Bank Statement data with the following template

TxnDatePrivateNoteCurrencyExchangeRateDepositToAccountEntityLineDescLineAmountAccount
28/07/2020Manual Feed  CheckingJane SmithMonthly Dues25Account1
29/07/2020Manual Feed  CheckingBank of the WestJuly Fees-15Office Expenses
30/07/2020Manual Feed  CheckingStaplesPaper for Copier-50Office Expenses
01/08/2020Manual Feed  CheckingTeddy JonesCharitable Contribution500Account1

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo