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?

tamsin · ‎March 13, 2019

Ashleigh1 · ‎June 12, 2020

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

TaliaI · ‎March 13, 2019

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 · ‎March 30, 2019

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 · ‎March 31, 2019

Hello, trang-tran.

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

Go to Banking from the left menu.
Select Banking tab and choose the correct bank account.
If the transaction is already added in QuickBooks, go to Reviewed tab, locate the transaction and click Undo.
Go back to For Review, locate and click the transaction.
Select the Find Match option.
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 · ‎March 31, 2019

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 · ‎April 01, 2019

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 · ‎June 12, 2020

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 · ‎June 12, 2020

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:

Go to the + New button and select Bank Deposit.
From the Account drop-down▼menu, choose the account you want to deposit the money into.
Select the box for each payment you want to combine.
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 · ‎June 12, 2020

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 · ‎June 12, 2020

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 · ‎June 12, 2020

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 · ‎June 12, 2020

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 · ‎October 05, 2022

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.

Topics

Training

Community

Resources

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?