cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
dan01hart@gmail.
Level 1

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

 
Solved
Best answer March 08, 2021

Accepted Solutions
John C
QuickBooks Team

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hi Mulster At the present time you're only able to upload receipts in GBP, there is no functionality to upload in different currencies. We'll submit a product enhancement request to our developers for their consideration and encourage you to leave feedback from within the product.

View solution in original post

13 REPLIES 13
Ashleigh1
QuickBooks Team

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hello Dan01hart@gmail. 

 

Welcome to the Community page, 

 

So you can have multi-currency suppliers and you can create an expense as normal so show this. 

 

So create a multi-currency supplier, then go to create an expense and select this new multi-currency supplier and post to the GBP account, you need to ensure the exchange rate is correct, make sure the date on the expense is accurate and then you can attach the receipt to the expense as an attachment at the bottom and save it. 

Mulster
Level 2

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

While your response is helpful, it does not explain why all receipt are added in GBP - which is hugely confusing, why there’s no ability to adjust the currency when uploading receipts, and why the auto matching receipts does not work with multiple currencies. 

Please can you provide some further and more detailed insights into receipts and multiple currencies, as half our receipts are in different currencies, and this is something that seems poorly supported by QB at the moment. 

Any help would be grateful appreciated!

Charies_M
Moderator

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

I'm here to share clarifications about your concern, Mulster.

 

In QuickBooks Online (QBO), the scanned receipts will show as GBP if your home currency is set in British pound sterling (GBP) when you turn on the multi-currency feature.

 

Since QuickBooks recognizes only one home currency for receipts, you'll have to set up a multi-currency supplier and use it when creating an expense. Then, you can manually match them with the receipts.

 

Before doing so, make sure to turn on your multi-currency feature.

 

Here's how:

 

  1. Go to the Gear icon. Select Account and Settings.
  2. Choose Advanced.
  3. Click Edit in the Currency section and choose your Home Currency.
  4. Select the Multicurrency checkbox and confirm that you understand that you can't undo this option.
  5. Hit Save and close.

For more information about this whole process, check this article: How to turn on Multicurrency and add or delete currencies.

 

Then you can multi-currency supplier. I'll show you how below:

  1. Go to Expenses and choose Suppliers.
  2. Click New Supplier.
  3. Fill in the Supplier Information including the section for "I pay this supplier with" and "Default expense account".
  4. Click Save.

Once done, you can create an Expense for this multi-currency supplier. Just go to the +New icon and select Expense.

 

To give you more insights with multi-currency in QuickBooks, please refer to these links:

I'm always here to help if you have any other questions while working with currencies. Stay safe and have a great rest of the day!

Mulster
Level 2

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hi there - thanks for your reply. I have previously set up multicurrency and multi-currency suppliers - this seems very straightforward, although it would be much smarter if you could duplicate the supplier and then just change the currency before removing the original entry - so simple, and so much easier - especially as there are SO many annoying independent text fields! 

 

So here is the actual issue I am having:

 

1. When I upload an invoice or receipt that is clearly in USD, the amount/tax column appears as GBP - why is this? (and yes, I have set up multicurrency and multi-currency suppliers)

 

2. Next, when I review banking/ credit card transactions I have set up rules to manage repetitive tasks - it works very well, until reviewing multi-currency suppliers. Despite the original USD amount being included in the description for every item, I have to open each transaction and manually copy and paste the USD amount from the description into the currency converter, before I manually categorise it - why is this simple function not automated?

 

3. And finally, if I don't carry out the tedious and manual currency conversion process, then there is no way the original invoice or receipt will be matched (remembering that the original USD amount being included in the description) - why is this?

 

Maybe I'm missing something critical? It would be so good to discover that there's a really simple way to automate all of the above, especially as it seems all the data is available... otherwise, these tweaks feel like basic UI/UX updates that would require only a small amount of work but would deliver significant impact to users.

 

I look forward to your response.

 

John

jamespaul
Moderator

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hello, John.

 

I would also like to do things easier and efficiently on a program, especially if we're talking about saving time. 

 

I have some information regarding how the Multicurrency feature behaves in the Online Banking page. 

 

As what Charies_M pointed out, the Online Bank Feeds' currency depends on the account's currency set up and your home currency. 

 

This goes the same for receipts, They depend on the home currency set in your Account and settings page. 

 

Since the transactions depend on the home currency settings, you'll want to continue manually converting the currencies in the meantime. 

 

However, our engineers might change the way the Multicurrency feature behaves on the Online Banking page. This might be planned for our updates. Stay tuned for our email newsletters about the program release notes. 

 

Also, there might be a third-party app that lets you manage bank transactions with another currency. I suggest looking for one in our App Centre. Just click the Apps tab in QuickBooks Online, then search for an app. 

 

Also going back to your suppliers, I suggest importing them using an Excel file if doing it one at a time becomes tedious. You can check this article for a guide: Import customers or suppliers from email contacts to QuickBooks Online

 

We have other resources to help you manage your books in QuickBooks. Give them a try if you need help running reports or reconciling bank accounts. 

 

Do you have other concerns that you want me to address? Leave them here and I'll listen and help you out. 

Fiat Lux - ASIA
Level 15

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

@Mulster 

Utilize an additional app as a workaround.

Mulster
Level 2

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Thank you for the update.

I am going to describe these issues one post at a time to avoid confusion (probably down to my newness to QBO).

The first one is uploading receipt into QBO - I have attached images below to illustrate the issue:

 

1. Upload a receipt with a USD currency - the Grammarly Receipt is clearly marked as 69.97 USD 

2. Once uploaded into QBO it appears the currency has not been recognised and has been changed to GBP - please see the attached image showing the newly uploaded Grammarly Receipt that is now in GBP

 

I hope you can appreciate how confusing this is?

 

John

John C
QuickBooks Team

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hi Mulster At the present time you're only able to upload receipts in GBP, there is no functionality to upload in different currencies. We'll submit a product enhancement request to our developers for their consideration and encourage you to leave feedback from within the product.

Mulster
Level 2

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

I would add the other points, but I keep getting booted off the system...

GeorgiaC
QuickBooks Team

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hi Mulster, 

 

 

You can change the default time that you remain logged in when inactive by going to the Cog > Accounts & settings > Advanced > Other preferences.

 

If you're finding that you're continuing to be logged out of the system, please check your browser settings or clear the cache and cookies on the browser to troubleshoot. 

 

Thanks :) 

waramatanga
Level 1

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

I am experiencing the same issue. Just came back from a business trip to Japan, Thailand and Germany and have numerous receipts to enter. I do have accounts set up for each currency but when trying to use the receipt scan and upload function the amount is shown in GBP. So basically the scan and upload function is useless! As this is issue has now been known already for over one year, I was wondering when Quickbooks is going to fix this problem.

 

Why is the currency not only determined when the corresponding account has been chosen? Alternatively, by all means, have the home currency GBP as a default to not confuse anybody who does not work with multiple currencies. As soon as the multi currency function is enabled, however, it should be possible to select one of the currencies set up. As I am involved in software development myself, I can't imagine that this would be too much of an effort to fix it. Would Quickbooks online finally make a viable option for internationally active customer ;)

 

Looking forward to hear from QB

Mark_R
QuickBooks Team

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

We're taking notes of your feedback and suggestion, @waramatanga.

 

I understand that the function of the multicurrency feature doesn't meet your expectation while scanning receipts in QuickBooks Online. As mentioned by my colleagues above, QuickBooks only recognizes your account's home currency.

 

To consider adding more functionality to the multicurrency feature, I suggest submitting feedback directly to our product engineers. This way, they can review your request and add it to the future update. To submit feedback, you can go to the Gear icon and select Feedback. Then, enter your suggestion and click Submit.

 

In addition, please know that all suggestions are being considered by our product engineers based on the volume of requests and their influence on the user interface before they are implemented.

 

You may also want to view the status of your sales transactions in your QuickBooks Online. You can go to the Sales menu and select All Sales.

 

We're always here to listen if you have concerns regarding other features. You're welcome to post again or leave a reply below.

Ashleigh1
QuickBooks Team

I travel a lot with business and have receipts in different currency. How do i add these to expenses when it shows as GBP on my statements?

Hello Martinedilone, there is no functionality to upload in different currencies, the receipt capturing does not support multi currencies.The receipt capture feature only supports home currency gbp, it's a relatively new feature in QuickBooks. But you can add the receipt as an attachment to the transaction once it has already been added in qbo. You could see if there is a 3rd party app that integrates with QuickBooks that can do this otherwise you can leave feedback from the main cog wheel> feedback. 

Need to get in touch?

Contact us