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

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

 
Solved
Best answer June 12, 2020

Accepted Solutions
Ashleigh1
QuickBooks Team

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hello SGI, 

You would need to record transaction in Quickbooks manually as paid, then what you need to do is just exclude the payment in the banking section as you can't match multi-currency on the banking page to that invoice.

 

To exclude the payment is if you go to the 

 

Banking tab>tick the box on the left-hand side on the transaction you don't want>click batch actions> exclude selected.

 

This will then move the transaction from the for review to the excluded section for you and if you want to delete it totally of Quickbooks if you go into the excluded section>tick the box again>batch actions >delete this will remove it completely out of Quickbooks.  

View solution in original post

12 REPLIES 12
TaliaI
QuickBooks Team

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hello tamsin,

 

You cannot automatically match multicurrency transactions. You will need to manually receive/make payment on the invoice/bill and then go back to Banking to match.

 

Please let us know if you need any further help with this.

 

Thanks,

 

Talia

trang-tran
Level 1

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hi Talia,

I have tried the 'receive payments' but it still doesn't match with the bank incoming amount from the customer. If I try to record that bank amount as 'deposit' while 'receive payment' is there it creates a duplicate. How do I show this perhaps with a journal entry ?

Anonymous
Not applicable

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hello, trang-tran.

 

To avoid duplicate entries, you can match the invoice to the bank transaction directly. Here’s how:

  1. Go to Banking from the left menu. 
  2. Select Banking tab and choose the correct bank account. 
  3. If the transaction is already added in QuickBooks, go to Reviewed tab, locate the transaction and click Undo. 
  4. Go back to For Review, locate and click the transaction. 
  5. Select the Find Match option. 
  6. A list of transactions including invoices will show up. Select the right invoice and click Save.

 

For additional information about this process, please refer to this article: https://quickbooks.intuit.com/community/Banking/Add-and-match-downloaded-banking-transactions/m-p/23...


Drop by again if you have other concerns about QuickBooks. 
 

trang-tran
Level 1

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hi Miki

 
The find match option (which I have used before) doesn't even show for some reasons. I had a workaround by writing cheque, adding unpaid bill to it; then match bank payment with the cheque. But it will be nice to just do journal entry too (but I am not too familiar with accounting concepts t9 be confident I will do it right).
Joyce_P
QuickBooks Team

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hi there, trang-tran.

 

You did great in performing a workaround in matching your bank payment with a check. You'll want to do a journal entry for this, I'd recommend consulting an Accountant. They are experts with the concepts of accounting. Also, they can help you further on how to create and manage your journal entry.

 

You can also refer to this article on creating a journal entry.

 

Let me know if you need more help by leaving a comment below. 

SGI
Level 3

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Talia,

 

I have the same problem with EUR payments not matching even after doing "Receive payment".

For some reason the issue seems to affect anything over 6 month old (we are transfering to QB from Excel and entering a lot of backlog).

 

Is there an option to force-match bank transaction to invoice somehow?

 

Or maybe I should use the way described in this article: https://quickbooks.intuit.com/learn-support/en-uk/manage-customers-and-income/how-to-link-a-deposit-... ?

I would have tried, but I do not have Accounts Receivable account.

AlexV
QuickBooks Team

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Good day, SGI.

 

The best way to record the transaction is to pay the invoice using Receive payment. Then, deposit the payment to your bank. Here's how to do it:

  1. Go to the + New button and select Bank Deposit.
  2. From the Account drop-downâ–¼menu, choose the account you want to deposit the money into.
  3. Select the box for each payment you want to combine. 
  4. Select Save and close or Save and new.

You can also refer to this article for more details: Record and make Bank Deposits in QuickBooks Online.

 

I'll be here if you need anything else. Have a great day!

SGI
Level 3

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hello, Alex!

 

I must have been unclear:

I already have transactions on the banking "for review" page because I downloaded .csv from bank and uploaded it to QB.

 

The issue is that the transactions (in EURO, old ones) do not match to Invoices. Even when I go through "receive payment" path on invoices the "match" button does not appear in banking interface.

 

I don't understand why the developers have limited matching to recent transactions and removed "search for match" button from foreign currency transactions.

Becky29
QuickBooks Team

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hello SGI :waving_hand: There is no find match for multicurrency, the find match option will only be available if part of the process passed through the home currency at some point, When manually making payment/receive payment it can sometimes match if all is correct (dates, amount, account,) but there is no guarantee. Thanks 

 

SGI
Level 3

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Becky29 - So what am I supposed to do with the transactions on bank feed? If I accept them after I have manually received payment for Invoices this results in income being recorded twice.

Ashleigh1
QuickBooks Team

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

Hello SGI, 

You would need to record transaction in Quickbooks manually as paid, then what you need to do is just exclude the payment in the banking section as you can't match multi-currency on the banking page to that invoice.

 

To exclude the payment is if you go to the 

 

Banking tab>tick the box on the left-hand side on the transaction you don't want>click batch actions> exclude selected.

 

This will then move the transaction from the for review to the excluded section for you and if you want to delete it totally of Quickbooks if you go into the excluded section>tick the box again>batch actions >delete this will remove it completely out of Quickbooks.  

imblelaze9
Level 1

When I receive or make a Euro payment, it doesn't automatically match to Invoices within the customer / supplier account - I don't have the option to match the invoice?

What you are describing is totally against all double entry accountancy practice.  Why allow Euro accounts to be imported, if you are unable to onward post the transactions?  Sort the software out, or remove the facility to import from the bank.

Need to get in touch?

Contact us