Skip to main content
K
Kirssko
March 25, 2021
Question

Unable to find the invoices to match transactions even though the invoices have not been matched

  • March 25, 2021
  • 1 reply
  • 0 views

I have several Euro invoices for which deposits have come in. I am unable to match the deposits to the invoices in QB. When I click Find Match the invoices are not found (I have selected the Foreign Currency radio button) but they do not come up. Dates are well within the selected dates.

What would prevent invoices which have not been matched from being found?

 

Would the £ conversion on the deposit being larger than the £ conversion on the invoice be an issue?

I can see this is the case for one of the transactions.

On the other transations the deposit is for two invoices and the £ conversion on the deposit is less than the combined £ value of the two invoices unmatched invoices.

1 reply

M
MirriamM
March 25, 2021

Welcome to the Community forum, Kirssko.

 

Let me share information with you on how matching transactions work in QuickBooks Online (QBO).

 

Right now, in QBO, you can only link transactions with the same currency. In your case, to get this sorted out, you'll have to create a new dummy bank account in the home currency to facilitate the movement between 2 different foreign currencies.

 

Here's how:

  1. In the left menu, click Accounting. 
  2. Go to the Chart of Accounts tab.
  3. Click the New button at the upper right hand.
  4. Under the Account Type, select Cash at bank and in hand. 
  5. Under the Detail Type, select Cash on hand. Then enter Dummy Bank in the Name field.
  6. Before saving and closing, make sure that it is in the home currency.

Once done, record the payment of the foreign invoice. Then, set the Deposit To field to Dummy Bank. After that, transfer the amount from Dummy bank to your other bank.

 

To know more about QBO's matching process, take a look at this article: Categorise and match online bank transactions in QuickBooks Online.

 

Please let me know in the comment section below if you have any other questions. I'll be always around to help.

Terms & ConditionsAccessibility statement