cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
skonduru
Level 2

Record foreign currency payment against the invoice raised

Hi, 

 

I have two bank accounts GBP and USD. GBP is my home currency and USD is my foreign currency, I raise invoice in USD for some of my customers who are outside UK and EU. The invoice payments were received in USD account. Can you please explain how do I match my USD invoice with USD payment received? 

Thanks

Suresh

 

15 Comments 15
JasroV
QuickBooks Team

Record foreign currency payment against the invoice raised

 

I appreciate you for sharing the details with me, @skonduru.

 

I'm more than happy to guide you on how to match USD invoice with USD payment.

 

Since the payment made for the USD invoice is USD account, you can receive the payment as you normally do in QuickBooks Online (QBO). Let me show you how.

  1. Go to the + New menu
  2. Select Receive Payment.
  3. Select the name of the customer from the drop-down menu.
  4. From the Outstanding Transactions section, select the invoice you’d like for QBO to calculate.
  5. Select the payment method.
  6. Then click Save and close.

You can also check this article for more details: Record invoice payments in QuickBooks Online.

 

Also, to learn more about multicurrency in your QBO account, check out article for reference: Turn on and use multicurrency.

 

You can always leave a reply below if you have other follow-up questions about multicurrency in QBO. I’ll be around to assist you. Take care!

skonduru
Level 2

Record foreign currency payment against the invoice raised

Thanks @JasroV 

 

Even though I do receive payment, I see that my invoice and deposit in the USD account and it is doubling up total sales. 

 

Like my GBP account why I am not able to see the MATCH on imported USD transactions to match with USD Invoice. Please suggest

 

Regards,

Suresh

SarahannC
Moderator

Record foreign currency payment against the invoice raised

Hello there, Suresh.

 

Let me share additional details about recording foreign currency payments in QuickBooks Online.

 

We can match the imported USD transactions to offset the open invoice we've created for the customer. We'll have to select the Foreign currency radio button to generate the foreign currency payment against the invoice you've raised.

 

Let me walk you through to accomplish this task. Here's how:

 

  1. Go to Banking or Transactions on the left panel.
  2. Within the For Review tab, find the imported USD transactions.
  3. Click that transactions and select Find Match or Find other records.
  4. Make sure to toggle the Foreign currency.
  5. You can enter dates and search for other information to find the invoices easily.
  6. Put a check-mark next to the Date column of the transaction.
  7. Finally, hit the Save button.

 

Here are the sample screenshots for additional reference:

g.PNG

gg.PNG

 

Also, you may want to explore this article: Categorise and match online bank transactions. It provides additional details on how to manage the downloaded transactions in QBO.

 

If there’s anything else I can help you with, please don't hesitate to let me know by commenting below. I’m always here to assist you further. Take care and stay safe always!

skonduru
Level 2

Record foreign currency payment against the invoice raised

Thanks @SarahannC 

 

In the imported transactions of USD, I cannot see any FIND MATCH or FIND OTHER RECORDS radio button. 

 

Please see attached screenshot. 

 

Regards,

Suresh

JonpriL
Moderator

Record foreign currency payment against the invoice raised

Hello @skonduru,

 

When categorising your banking transactions, the Find Match or Find Records function will appear and you're able to click it once QuickBooks recognise any existing transactions. Since it did not show up on your end, will have to make sure that the amounts and dates of your existing payments matches with the transactions you have imported.

 

Lastly, here's an article you can read to learn more about how you can review a transaction in your bank account register: Find, review, and edit transactions in account registers.

 

Keep me updated in the comments if you have any other questions. I'll be here to lend a hand.

Usman01
Level 1

Record foreign currency payment against the invoice raised

Hi Sarah, 

 

I am in the similar istuation like skonduru. We have a client who raise invoices in euro and received payments in euro as well.  I rasied the invoices on the QBO in euro and also converted them in the GBP which is automatically done by the Quickbook to bring the invoices in home currency format.. I then converted the bank in GBP and uploaded the transactions but I can not match the invoices as when I click on match invoices no invoice will show up. I made an other attempt by uploading thebank in the Euro but again no invoice will show up to match the invoices. It is really a pain as the sofwtare is not really helpfull. My client sometime recieve part payment for the invoies now and part later and we should have the option to allocate the payment by ourselves and if there is any small difference we should be allocate that difference to currency gain and losses. Find a mtach feature should appear in all situation much like clearbooks does. It has been a nightmare to get the bookkeeping done on the QBO  for company dealing in foreign currency as you can not match the bill or invoices with the bank feeds being uploaded. It is a pitty that nothing as been done about this. 

 

 

Jen_D
Moderator

Record foreign currency payment against the invoice raised

Thanks for posting here, @Usman01,

 

At the moment, you can only link transactions with the same currency in QuickBooks Online. We're unable to match a GBP payment towards a EUR invoice.

 

Your case is a special situation and so it needs a few steps to do. First, we’ll first have to create a new dummy bank account in the home currency to facilitate the movement between 2 different foreign currencies.

 

  1. Select the Gear icon, then select Chart of Accounts
  2. Press New
  3. Under Account Type column, select Cash at bank and in hand. Under Detail Type column, select Cash on hand. And under Name column, type in Dummy Bank.
  4. Before saving and closing, make sure that it is in the home currency (which is GBP in this case)

 

We’ll first have to record payment of the foreign invoice. In the Receive Payment module, set the Deposit To field to Dummy Bank. Before saving the transaction, take note of the home currency (GBP) amount displayed at the bottom right.

 

 

Next, we’ll have to transfer this GBP amount from Dummy Bank to the EUR bank account.

 

  1. Go to the + New icon and select Transfer.
  2. Under Transfer Funds From column, select Dummy Bank from the drop-down arrow.
  3. Now, in the Transfer Funds To, select EUR Bank from the drop-down arrow.
  4. In the Currency column, select GBP from the drop-down arrow.
  5. For the Transfer amount column, type in the amount.
  6. Under Exchange rate, the exchange rate will automatically appear. But you can manually change the rate.

 

If you have any questions, let me know in the comment. I'll be right here to help you with the customer payments. Have a good one!

Ugur01
Level 3

Record foreign currency payment against the invoice raised

Hi, 

 

In fact, QBO only has GBP accounts. Euro account not available. In this case, how can we transfer money from Dummy Bank (GBP) to a EUR account? Should we create a fake EUR bank account?

JessT
Moderator

Record foreign currency payment against the invoice raised

Hi Ugur01,

Thank you for joining the conversation about receiving foreign currency payments. I will help you record your transactions. However, I want to ask for more information so I can provide the right steps for you.

I understand that your QBO has GBP accounts, but why did you say that you want to transfer from a “Dummy” GBP account to and EUR account? What is that dummy for? Then, what is this EUR account for?

Would you mind providing information about the receiving account and the currency of the payment instead? For example, My bank is in GBP, but my customer is in EUR, and he pays in that currency. However, the payment I receive is pre-converted by my bank to GBP and is deposited to my GBP account. How can I match this to my customer's invoice (EUR).

I would appreciate any additional details. Have a good one!

Ugur01
Level 3

Record foreign currency payment against the invoice raised

Hi Again, 

 

Here is my question. 

 

My home currency is USD. I create an invoice in EUR. The customer paid the invoice amount but the amount was deposited in my bank account in USD. How can I match the deposit amount that is USD and the invoice that is EUR in Quickbooks Online?

LieraMarie_A
QuickBooks Team

Record foreign currency payment against the invoice raised

Welcome back, @Ugur01. I've got the answer you're looking for.

 

Simply choose the Foreign Currency option on the Match Transactions page, and you'll be able to match the US deposit amount with the EUR invoice.

 

Here's how:

 

  1. Go to the Banking menu.
  2. Select your bank.
  3. In the For Review tab, look for the transfer and select it.
  4. Select the Find match option.
  5. Use the filter tools to narrow down the data.
  6. Choose Foreign currency.
  7. Select the entry to match.
  8. Click Save.

 

Additionally, it's important to regularly reconcile your accounts to ensure accurate and up-to-date records. This practice can help you identify any discrepancies or errors, allowing you to address them promptly and maintain the financial health of your accounts.


I'm also adding these resources for additional information:

 

 

Feel free to reply to this post if you have further questions about handling multi-currencies. I'll be happy to lend a hand. Have a good one!

Ugur01
Level 3

Record foreign currency payment against the invoice raised

Thank you, 

 

I have a customer and he has two different companies. One of the home currencies is EUR and the other one is USD. I created two invoices one is EUR and the other one is USD. The customer sent the amount of the invoice in USD for both invoices. Now, in my bank account, there is a USD deposit for these two invoices. 

How can I distribute the deposit to these two invoices? 

The Deposit amount is $34,633.18

The invoices are attached. 

 

GlinetteC
Moderator

Record foreign currency payment against the invoice raised

Thank you for sharing the screenshot, Ugur01. I have additional information on managing the deposit amount in QuickBooks Online (QBO).

 

I can see you're facing a challenge in matching your bank deposit in USD with two invoices, one in EUR and the other in USD. However, I have a solution to help you overcome this problem. You can recreate the EUR invoice in USD to successfully match them using the Find match feature in QuickBooks Online. Select the Foreign currency radio button to ensure accurate matching. This will allow you to reconcile the invoices and the deposit amount effectively. You can follow the steps provided by @LieraMarie_A to match the deposit amount.

 

Once you have successfully matched those deposits, it is advisable to reconcile the account to maintain precise financial records, identify any discrepancies, maintain financial control, and adhere to regulatory obligations: Learn the reconcile workflow in QuickBooks.

 

I'll assist you with additional questions about managing deposits and other concerns.

Ugur01
Level 3

Record foreign currency payment against the invoice raised

I figure out the problem. Thank you @LieraMarie_A @GlinetteC 

 

 
QueenC
Moderator

Record foreign currency payment against the invoice raised

You're most welcome, @Ugur01!

 

Thank you for reaching out and expressing your gratitude towards our colleague for providing a solution to your QuickBooks-related concern. It's great to hear that my colleague's provided solutions were able to help you figure out the problem. concern.

 

Here in Community, we strive to provide exceptional support to our customers, and we want you to know that we're always here to back you up in the Community whenever you have any further QuickBooks-related concerns or need assistance with tasks. Our dedicated team is committed to ensuring your success and satisfaction.

 

Please don't hesitate to reach out to us anytime you need help or have any questions. We're here to support you every step of the way.