Error in Match multiple transactions to one invoice

Hello SergeiG,

It's nice to see you reaching out here.  Multicurrency can have some challenges when it comes to matching your transactions. However, QuickBooks Online provides the features you need, so you can match your transactions and reconcile your accounts with confidence. I would be glad to assist!

When issues such as this arise, it's usually related to the  exchange rates used at the time of each transaction.  You can recalculate the home currency value using current exchange rates.  Here's how;

1. Open your Settings ⚙, then Currencies

2. Under the Actions column, select the ▼ dropdown menu, for the currency you want to adjust, then Revalue Currency

3. Enter the Revalue date 

4. Decide whether you'd like it to be based on the Market rate or a Custom rate 

5. Hit Revalue and save

Note; Only one exchange rate can be saved per day per account. 

You're all set, and you should be able to match your transactions and reconcile your account!

If you have other questions, feel free to touch base with us again.  We are here to help!

Hello Trish_T,

Thank you for the answer. I found this feature in my account, but before do it, I would appreciate you for some clarifications:

- In simple words, what actually Revalue date feature does?

- If date of invoice is December 9th, and transactions dates are December 9th and December 10th, what date should I choose as Revalue date?

Thank you.

Hello SergeiG. Glad to hear back from you. Revalue date refers to the date that you're revaluing the currency for. This date can be today or a day in the past. I recommend consulting with your accountant for expert advice on which date to use so your books can remain accurate. In the meantime, let me know if you have other questions. I'm here to steer you in the right direction. 

This absolutely does not work with other currencies. If the currency that is trying to match with an invoice is not exactly the number from the downloaded transaction, you will get this message. You have to make multiple invoices in order to make this work, you can't do "part" payments with foreign currencies in Quickbooks Online. It's completely broken. 

Is this bug going to be fixed anytime soon? It’s ridiculous not to be able to partially match transactions. 

Were you able to make it work somehow? I really need the ability to partially match foreign transactions as I have bank accounts in different currencies. 

Hi there, @MrRidley . QuickBooks Online (QBO) doesn't support partial matching when the invoice and the bank transaction are in different currencies.

QBO can only match payments to invoices when both sides use the same currency, so once the bank converts the amount, the system can't partially apply it. The only workaround for now is to record the payment in the customer's currency using Receive Payment, then manually record the currency conversion in the bank account where the funds were deposited.

If you have follow-up questions, please don't hesitate to click the reply button.

But both my bank account and the customer are in the same currency (Euro). How come it doesn’t work? I’m using the multicurrency feature, but my main QBO currency is USD.

Hello, @MrRidley. Since your bank and customer use the same currency, you can proceed with a partial payment. The current issue stems from a change in the implementation rate, which requires an exchange rate revaluation.

We will recalculate the home currency value using the current exchange rates for the Euro to help you match your partial payments. Here's how:

1. Go to Settings, then select Currencies.
2. Find the currency you want to adjust.
3. Under the Actions column, choose the small arrow ▼ icon.
4. Click Revalue Currency.
5. Select a date (today or a day in the past) to run a currency revaluation.
6. Hit whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
7. Tap the account(s) you want to apply the revaluation to.
8. Press Revalue.
   
   

For further details, you can refer to this article: Enter home currency adjustments for your foreign balances in QuickBooks Online.

This is the result after revaluing your exchange rate; you can now match the partially paid amount.

If you have already revalued your home currency but the issue persists, I recommend contacting our Live Support team for assistance. They can investigate the problem using specialized tools and provide specific guidance to help you resolve the issue.

If you have any more questions or encounter further challenges, please don't hesitate to reply or start a new post. I'm here to help. Thank you for sharing your concerns!