cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
SGI
Level 3

How to manually import transactions in multiple currencies?

Hello!

I have accounts in 3 currencies (GBP, EUR, USD) at Metro Bank (UK).

Unfortunately Metro bank is not supported for automatic banking connection.

 

So I have tried to import transactions manually. Turns out Metro bank exports in quite different .csv layout than QB can upload. 
I can manually change the colums into format prescribed here: https://quickbooks.intuit.com/learn-support/en-uk/banking/import-bank-transactions-using-excel-csv-f... 

 

But - how do I differentiate between GBP, EUR and USD transactions? The file format prescribed in manual linked above does not provide any currency recognition feature.

Solved
Best answer April 17, 2020

Accepted Solutions
FritzF
Moderator

How to manually import transactions in multiple currencies?

Thanks for getting back to us, @SGI.

 

Since you're still unable to manually import your bank transactions in QuickBooks Online (QBO) after following the steps shared by my colleagues above, I highly suggest contacting our Support team. They have tools such as screen-sharing (remote access) that can pull up and check your account in a secure environment. They're also able to perform other troubleshooting steps to help fix this for you.

 

Here's how to reach them:

 

  1. In QBO, click the Help (question mark) icon at the top right.
  2. Select Contact Us at the bottom to connect with our live support.

 

I want to make sure everything is taken care of for you, so please let me know how it goes or if you have any other issues or concerns. I'll be here to assist. Have a good one!

View solution in original post

EmmaM
QuickBooks Team

How to manually import transactions in multiple currencies?

Hello SGI

 

Thank you for getting back to us. Very happy the formatting is now allowing you to upload the file. We'll pass on your feedback regarding the .scsv format to our product engineers. It is worth adding it to the feedback section in the cog in the top right of the QuickBooks product as well.

View solution in original post

10 REPLIES 10
RenjolynC
QuickBooks Team

How to manually import transactions in multiple currencies?

Hi there, SGI.

 

 

To match your statement fields in QuickBooks fields, you'll want to include the currency in the Description column. Then, categorize your downloaded transactions. Here's an article for the instructions: Assign, categorise, edit, and add your downloaded banking transactions.

 

I'm also adding this article for reference: About Multicurrency.

 

Please don't hesitate to let me know if you have any additional questions or other concerns. Take care. 

SGI
Level 3

How to manually import transactions in multiple currencies?

Hello,

 

I have tried to re-format my .csv file with transactions into format presribed here https://quickbooks.intuit.com/learn-support/en-uk/banking/import-bank-transactions-using-excel-csv-f...

I have also added currency (USD) at the start of description to every payment.

But when I try to upload the QBO says "Invalid file format".

Are there more specific requirements for formatting? Like do I have to have date formatted like 01/02/20 instead of 01.02.2020?

Or maybe there is a limit on lenght of description? I have very long descriptions because I have combined several columns from original file downloaded from bank.

KlentB
QuickBooks Team

How to manually import transactions in multiple currencies?

I'll make sure that you can upload your bank transactions, SGI.

 

CSV files downloaded from most banks often have their own formats, and as a result, you might not be able to import the CSV file. Check out the additional pointers below that will guide you in reformatting your CSV file:

 

  • 0's are not allowed anywhere in the file, e.g Rs. 0 should be left blank
  • Commas for thousands are not allowed either e.g 2,111 should be 2111
  • Other special characters such as #, %, and & are not allowed
  • Correct any transactions with the amount showing in the description column

Please know that the standard the date format is dd/mm/yyyy (01/02/20). I would also recommend to shorten your description so that the program will be able to easily read your bank transactions. You can refer to this article to article in uploading your bank transactions: Import bank transactions using Excel CSV files.

 

Once you're done uploading the file, we can now start matching and categorizing your bank transactions.

 

Feel comfortable to visit us again here if you need more help in managing your bank and credit card transactions. As always, we're just one post away.

Fiat Lux - ASIA
Level 15

How to manually import transactions in multiple currencies?

@SGI 

As additional option, utilize the trial period of this 3rd party importer tool

https://transactionpro.grsm.io/qbo

 

You should prepare the data with 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
SGI
Level 3

How to manually import transactions in multiple currencies?

KlentB

 

I have tried everything you suggested - except the date - for some reason my excel only wants to save it as mm.dd.yyyy

I have even deleted all description - just left USD in description bit.

Please see below how the top of my .csv file looks now.

And still "Invalid file format".

 

What am I doing wrong?

- Is there a limit on how far back the transactions can go in manual upload? (I don't have many transactions because I started with our USD account - it has the fewest transactions as it is the least used one.

- Maybe I have to manually pre-create bank account somehow before uploading? Checked with Accounting Tab but there is no "create new bank account" in "create new" options. I cannot connect bank account automatically because you stopped support for Metro bank PLC.

FritzF
Moderator

How to manually import transactions in multiple currencies?

Thanks for getting back to us, @SGI.

 

Since you're still unable to manually import your bank transactions in QuickBooks Online (QBO) after following the steps shared by my colleagues above, I highly suggest contacting our Support team. They have tools such as screen-sharing (remote access) that can pull up and check your account in a secure environment. They're also able to perform other troubleshooting steps to help fix this for you.

 

Here's how to reach them:

 

  1. In QBO, click the Help (question mark) icon at the top right.
  2. Select Contact Us at the bottom to connect with our live support.

 

I want to make sure everything is taken care of for you, so please let me know how it goes or if you have any other issues or concerns. I'll be here to assist. Have a good one!

View solution in original post

SGI
Level 3

How to manually import transactions in multiple currencies?

Hello, FritzF and KlentB

 

Problem solved with Support online assistance.

 

Turned out problem with file format was on my side - excel was saving files as .scsv instead of proper .csv without any warning. I.e. it was using ; separator instead of , . Unfortunately it did not warn me about it, so files had .csv in properties etc. and I did not notice the difference until I was advised to try and open files with Notebook. Of course your system did not recognize file format. 

Once I opened file in Notebook and and mass-changed ; to , all was fixed.

 

BTW you should probably ask your dev team to consider adding recognition of .scsv format. Separator is set by regional and language standard, and if your mother tongue is not English and you are using windows and office in your own language for convenience you could get this problem when MSExcel says it is saving files as .csv but instead it is using .scsv.

EmmaM
QuickBooks Team

How to manually import transactions in multiple currencies?

Hello SGI

 

Thank you for getting back to us. Very happy the formatting is now allowing you to upload the file. We'll pass on your feedback regarding the .scsv format to our product engineers. It is worth adding it to the feedback section in the cog in the top right of the QuickBooks product as well.

View solution in original post

Fardinkhan Omar
Level 1

How to manually import transactions in multiple currencies?

Hello, 

I have a question in terms of Entering Bill. 

My home currency is AFN, and I enter bill to a foreign vendor (USD). In amount field of the Bill I need more decimals, but quickbooks calculates only two decimals. 

How can I solve this? 

CharleneMae_F
QuickBooks Team

How to manually import transactions in multiple currencies?

Hi, Fardinkhan Omar.

 

Yes, you're correct. QuickBooks Online calculates two decimal places by default. The option to change this is currently not available.

 

In the meantime, I recommend visiting our QuickBooks Blog website from time to time. Doing so helps you stay updated on all the product improvements.

 

Additionally, for other "How do I" steps in QuickBooks Online, I encourage you to go through these articles for your references:

 

 

You can always get back to this thread and tag my name for other QuickBooks concerns.

Need to get in touch?

Contact us