How to split a bank transaction between Client REFUND and BANK FEE in QBO Multi-currency?

Welcome and thank you for reaching out to us here on the Community page, @BruceI.

So you can match the transactions accordingly, you have to edit the refund receipt and include the fee for 0.63 euro.

Here's how:

1. Locate the refund transaction, then open it.
2. Add the fee using an expense account on the next line under the Product/Service.
3. Enter the amount.
4. Save the transaction.

For additional reference about adding and matching transactions in QuickBooks Online, check out these articles:

• Assign, categorize, edit, and add your downloaded banking transactions
• Categorize and match online bank transactions in QuickBooks Online

Get back to me if you have any other questions. I'm always here to help. Have a good day!

Thank you for thinking about. However if we do in this way we are going to add the bank fee to the reimbursement receipt that is the fiscal document we already issued to the client. This would be not correct as the client has not received the bank fee. The client would like to have a receipt with the amount client has received and that client will account. Any chance to have a solution without editing the refund receipt?

How about creating a Journal entry to make the split into the bank registry?

Enabling the multicurrency function will not disable the option to find a match to a certain transaction, BruceI. You still can match the foreign transaction and record the bank fee. This way, you'll be able to monitor them and keep your account updated.

I'm here to guide you on how to record the refund receipt along with its bank fee without editing the transaction. 

1. Go to the Banking menu.
2. Select the bank emblem/tile.
3. Go to the For Review tab.
4. Locate and select the transaction.
5. Select the Find match button.
6. In the Match transactions page, click the Foreign currency button beside Home currency.
7. Select the match by clicking the box beside the Date column.
8. Scroll down, then enable the Resolve Difference option.
9. In the Add resolving transactions section enter all the needed information. For the category, select Bank fees. Then, enter the amount of 0.63.
10. Click Save.

I've attached screenshots below for your reference.

To learn more about receiving or paying payments, exchange rates, and foreign currency account using the multicurrency feature in QuickBooks , kindly refer to this article's More information about Multicurrency section: About Multicurrency. It contains related articles that'll further guide you about the said feature

Moreover, if you wish to create a journal entry instead, I'd recommend consulting your accountant to guide you further. This way, you'll be able to keep your books accurate.

Please let me know if you have other concerns. I'm just around to help.

Thank you for getting back. We don't have the 'find match' option and in several posts of QBO team say that this option is not available in multi-currency. Is there a way to enable it? We have a USD account with EUR as additional currency. 

See screenshot: https://gyazo.com/312b235de938afea84c67eac2d7a73ec

We're glad to have you back in the Community, BruceI.

Let me share additional information about the Find Match option within the Banking page.

Regardless the multi-currency feature is turned on or not, the Find Match option will still be visible in your book.  In your case, I suspect that this might have something to do with a browser issue.

Sometimes, a QuickBooks feature will not be responding properly. The common reason why it happened is caused by having too much cache in our browser. We can do some troubleshooting steps to resolve the issue throughout the process. Below are the things that you can try on.

Refresh your browser by clicking the Reload icon or pressing F5 on your keyboard. If the same thing happens, log in to your account through an incognito window. This mode doesn't store cache that's why we recommend using it.

You can use these keyboard shortcuts based on the browser you're using:

• For Internet Explorer of Firefox, press Ctrl + Shift + P.
• For Chrome, press Ctrl + Shift + N.
• For Safari, hold down Command + Shift + N.

Once logged in, let's follow the steps provided by my colleague one more time . If it works fine, go back to your main browser and clear the cache. This helps remove any browser-related issues and refresh your browser's settings.

Aside from that, you can other compatible browsers in QuickBooks Online. Also, you may want to check out these articles. We'll be getting further details about categorizing and matching transactions within the Banking page. 

• Categorize and match online bank transactions.
• Assign, categorize, edit, and add your downloaded banking transactions.

I'll be around together with my colleagues to help you more in case you require additional information. I hope you're safe and well. Take care!

All done but 'find match' is not showing. Are you sure about that? There are several posts from you colleagues that says there is not find match feature in an account with currency different from home currency. Again, I did all the steps you suggest now and months ago and no way to show the nice 'find match' :-)

I appreciate you for providing additional information about the Find match feature in your QuickBooks Online multicurrency account and for the screenshot above, BruceI. This helps me in giving the right information about the issue.

In QuickBooks, you're unable to view the Find match option once any of the criteria such as currency, date, and amount don't match to any downloaded transaction. The system also updates the currency now and then to meet the current exchange rate.

Based on the details you've given above, It seems that the refund receipt didn't match with the downloaded transaction. With this, I recommend reviewing and updating your refund receipt transaction so QuickBooks will find its match.

Once done, you can pull up the Exchange Gain or Loss account's QuickReport from your Chart of accounts. This is to view the exchange rates and differences in your recorded transactions.

Moreover, I'd also suggest reconciling your accounts every month. This way, you'll be able to keep your account updated and monitor the growth of your business. For the detailed steps, kindly check out this article: Reconcile an account in QuickBooks Online. It also contains information about editing completed reconciliations.

Please let me know if you have other concerns. I'm just around to help.

Appreciate your quick message. However it brings us back to my original unsolved question:

- we know that QBO multicurrency doe NOT have the 'find a match' for a bank account in a currency different from home currency.

- my original question: We have a refund receipt of 1000 euro issued to the client. But processing the refund the bank add 0.63 euro. Bank transaction is of 1000.63. Unfortunately there is no 'find match' feature in Multi-currency bank account in EUR (home is USD). 

- we can NOT edit the Refund Receipt as it is a receipt of the amount the client received as reimbursement while the bank fee is an expense we pay to the bank (not to the client) for processing the refund.

The solution we implemented is cancel the bank transaction and manually import 2 transaction. In this way we split manually the reimbursement and the bank fee.

I believe there should be a more elegant way to do it in QBO :-) 

As we already exchanged several messages I would appreciate if you could read the whole conversation and share a proper solution (if any). Thank you for helping.

Hi @BruceI,

You'll want to use the split button so you can add the bank fee manually. Let me guide you how.

1. Go to Banking, then Banking at the top.
2. Select the transaction to open, then click Split towards the bottom.
3. In the Split Transaction page, enter the Category of your bank fee and the Amount. In the next line item, enter your refund receipt amount and other information.
4. Memo field is optional for your reference.
5. Hit Save and add.

With these steps, you'll be able to split up banking expense transactions with ease. Please see this article for more information about categorizing and matching online bank transactions in QuickBooks Online. It contains details on how to properly record your downloaded transactions into QuickBooks.

We also offer a guide on entering split transactions in the register that you may find helpful.

Stay in touch with me here should you need any further assistance, I want to ensure your success. Thanks for reaching out, and have a lovely day.

Are you sure? This would create an EXPENSE while we have the Refund Receipt that is against sales (not against an expense registry)....

Hello there, @BruceI.

At this time, the option to "Find Match" from the home currency is unavailable. Foreign currency is a sensitive transaction in QuickBooks Online.

If you wish to match your transactions to your foreign bank account, you'll need to create the transaction manually with the correct exchange rate that will match the Bank account. 

You may find these recommended articles helpful:

• About Multi-currency.
• How to assign a foreign currency or multi-currency to a customer.

Please comment below if you need further assistance with multi-currency concerns. I’ll be around to help. Have a beautiful day!