cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
porthgwarra
Level 2

I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.

When I come to reconcile I have two duplicate entries... mine, which is correctly associated with the invoices, and the bank's.  Exact same date and GBP amount, but I can only 'Add', and not 'Match' transactions.  Is there a workaround please?
Solved
Best answer July 20, 2019

Accepted Solutions
Rasa-LilaM
QuickBooks Team

I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.

Thanks for dropping by the Intuit Community, porthgwarra.


Let’s select the Foreign currency option so you can match the transaction. I’m here to help accomplish this task.


Here’s how:

 

  1. Log in first to your account to access and select the Banking menu to open the Bank and Cards screen.
  2. From there, choose the appropriate account you’re working.
  3. Under For Review, locate and select the transaction to open it.
  4. Mark the radio-button for Find Match.
  5. Once the Match transactions window opens, choose the Foreign currency radio button.
  6. In the Select transactions to match section, you’ll see lists of possible matches and select the right one.
  7. Click on Save.

For more in-depth information on how QuickBooks analyses your bank transactions and matches them: Add and match downloaded bank transactions.


If there’s anything else I can help you with, click on the Reply button and post a comment. I’ll be right here to assist further. Wishing you the best. 

View solution in original post

3 REPLIES 3
Rasa-LilaM
QuickBooks Team

I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.

Thanks for dropping by the Intuit Community, porthgwarra.


Let’s select the Foreign currency option so you can match the transaction. I’m here to help accomplish this task.


Here’s how:

 

  1. Log in first to your account to access and select the Banking menu to open the Bank and Cards screen.
  2. From there, choose the appropriate account you’re working.
  3. Under For Review, locate and select the transaction to open it.
  4. Mark the radio-button for Find Match.
  5. Once the Match transactions window opens, choose the Foreign currency radio button.
  6. In the Select transactions to match section, you’ll see lists of possible matches and select the right one.
  7. Click on Save.

For more in-depth information on how QuickBooks analyses your bank transactions and matches them: Add and match downloaded bank transactions.


If there’s anything else I can help you with, click on the Reply button and post a comment. I’ll be right here to assist further. Wishing you the best. 

porthgwarra
Level 2

I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.

Hello again Rasa-LilaM,

This question follows on from the answer you helpfully provided in July...

I've receieved USD payment into my Undeposited Funds a/c, within QBO.

My GBP bank download shows the funds arriving, in sterling

As you taught me, I can 'find match' by selecting the foreign currency button...

BUT... when I click 'save', I get the error message...

    "Something’s not quite right

      The currency of the transaction is invalid for customer/supplier/account."
The currency for the customer is USD, and correct.
To me, this seems no different from the transactions I've handled since your last advice
I hope you're able to help, again.  Many thanks, Peter
GraceC
QuickBooks Team

I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.

Hello there, @porthgwarra.

 

You can create a bank deposit to match your banking. Let me guide yo how.

 

  1. Click the Create (+) icon.
  2. Choose Bank Deposit.
  3. Update the Account and Date.
  4. Make sure the correct Currency is selected.
  5. Click Save and close.

From the bank deposit change the currency to show the USD payment that you create.

 

Don't hesitate to drop your comment below if you have any other questions. Have a nice day!

Need to get in touch?

Contact us