Is anyone having an issue matching, via reconciliation, a payment to a CAD based bill. The bill does not show up in the list when I do a "Find Match" and select Foreign

Hello there, @tfearn. I'm here to ensure you're able to reconcile your payment transaction to a foreign currency (CAD) based bill in QuickBooks Online (QBO). 

The online banking feature in QBO will automatically identify and use your home currency. When you match transactions, you'll have the option to toggle between Home currency and Foreign currency transaction pages. Based on your description of the issue, the other four foreign CAD-based bills may show up on the Home currency page. With this, you can toggle back to the said button and check to see the other bills. Here's how:

1. Go to the Banking menu.
2. Select the tile for the account you want to review.
3. Go to the For review tab, then find and select the downloaded transaction you want to match.
4. Click the Find other matches button.
5. Toggle between the Home currency and Foreign currency buttons to find the four other bills.
6. Once found, select the boxes beside the bills, then click Save.

I've attached screenshots below that show the first five steps.

After categorizing, you're now ready to reconcile your account. I'd recommend doing this process every month. This is to effectively monitor your income, expenses, and the growth of your business. For the step-by-step guide, you can check out this article: Reconcile an account in QuickBooks Online. It also includes details about reviewing and editing past and completed reconciliations.

You can count on me whenever you have other concerns or follow-up banking and reconciliation inquiries. I'm just around to help. Take care always.

I'm doing this exactly as you describe.  I'm trying to match a bill but it does not show up when I press the Foreign currency radio button.

Hey there, tfearn.

Thanks for reaching out to the Community today, If the steps provided by my colleague seem to not be working for you, then I'd recommend reaching out to our support team for further guidance. They can look into your account with you in a private 1-on-1 setting to determine what the issue is. To reach them follow these links to chat with an agent. 

M-F 6 AM to 6 PM PT

• Chat with us
• You can also contact support via chat using the Merchant Service Center.

If you're also using our Mobile App or have any other commonly asked questions, you can check out this helpful article below:

• Contact Payments or Point of Sale Support.

Thank you for your time and I hope you have a wonderful day.

I have the same problem.....does anyone have the support team eventually assist resolve this simple error in QBO?

QBO, it is foreign BILL we trying to match NOT foreign invoice.

Hello there, @Buck Tsai.

Let's toggle the Foreign currency button in the Banking menu so you can match a foreign bill in QuickBooks Online (QBO).

You're able to match foreign bills aside from invoices in QBO. To successfully match foreign or multicurrency transactions, you'll need to choose the Foreign currency option. Here's how:

1. Go to the Banking menu.
2. Select the tile for the account you want to review.
3. Go to the For review tab, then find and select the downloaded transaction you want to match.
4. Click the Find other matches button.
5. Toggle the Foreign currency button on to find your foreign bills.
6. Once found, select the boxes beside the bills, then click Save.

In case the issue continues, I encourage you to reach out to our Customer Care team. They can create a case to further investigate the error and guide you with a fix. Tod o this, here's how:

1. Sign in to your QBO company.
2. Go to the Help (?) menu.
3. Select the Search tab.
4. Click the Contact Us button.
5. Enter a brief description of your concern in the What can we help you with? field.
6. Select Continue.
7. Choose a way to connect with us (Send a message or Get a callback).

Also, I encourage you to reconcile your accounts regularly (every month). This helps you monitor your income and expense transactions and detect any possible errors accordingly. You may want to check out this article as your reference to guide you in doing or fixing a reconciliation in QBO: Learn the reconcile workflow in QuickBooks.

Let me know if you have other banking and multicurrency concerns or questions about managing transactions in QBO. I'm always ready to help. Take care, and I wish you continued success, @Buck Tsai.

I've been having the same issue since I joined QB about 6 months ago.

It doesn't show all open invoices, only the ones that QB thinks should be a match. I can only assume that when when the amount you receive is too far away from the invoiced amount, due to currency changes or transfer charges, often the invoice you need is automatically excluded.

Please don't refer me to customer service team to share screen or have a look, they don't have the answer either (multiple calls, online conversations). The only solution is a work around. If I wanted a work around, I'd do it much quicker and for free on Excel thanks! The actual answer is the Quickbooks cannot fully handle different currency.

Please can this issue be escalated to the person accountable for providing a fully working product, or to your marketing and sales teams so they can water down what they are selling. If you are claiming compatibility with currency when you are selling to me, it needs to work end-to-end without a work around. If you are not willing to update the coding so that ALL open invoices are shown and can be selected, then please stop telling people QuickBooks manages currency. - It doesn't. You could tell prospective customers that QB can raise invoices in different currency, but when the money comes in it often stops managing.

I'll look forwards to a response, or hopefully an update that this will be improved before I go elsewhere.

What I would like:

- A response to say this is being developed and a date when I will see it working in my account.

or

- A response to say that end-to-end currency is beyond the current capability of QB, and a full explanation as to why I was miss-sold this product by your sales team.

Thanks,

Sam 

Hi there, @9130 3523 9912 4866.

I can see the importance of matching your foreign entries automatically. At this time, the system will only auto-match banking transactions using the home currency. I understand that toggling to the Foreign currency option can take extra time and effort while doing your task. Though the feature isn't available yet, I want you to know that our developers are working nonstop to enhance the product and deliver the best experiences for all QuickBooks users. That said, I'd recommend sending this idea to them. This way, they'll know how useful this feature is for your business and consider this in future updates.

Here's how:

1. Sign in to your QuickBooks Online (QBO) account.
2. Go to the Gear icon at the top, then Feedback.
3. Enter your comments or product suggestions.
4. Hit Next.

Once done, your valuable suggestion goes to our designated team to help improve your experience in QBO. You can track feature requests and see their status through the QuickBooks Online Feature Requests website.

To learn more about the multi-currency feature in QBO, you can open these links:

• Multi-currency tips and tricks
• Set up and use multicurrency in QuickBooks Online

On the other hand, you can get more hints while working with your banking entries from our self-help articles.

If you have follow-up questions about banking or multi-currency entries, let me know by adding a comment below. I'm always here to help. Have a good one!

Thank you but I think you have misunderstood the issue here.

I'm not asking for it to autodetect as it does for 'home' currency transactions. What I'm saying is hat the software actually doesn't allow you to manually select/match the correct invoice either.

I have say 7 open invoices, a non-home currency payment comes in, and when toggling to foreign currency, the invoice I need to select doesn't show up.

I'm not asking for a nice to have feature here, I'm saying the software is actually preventing me from accounting for incoming money.

I'm at a loss here. I don't think your software works, your support team (when screen sharing) agree that your software doesn't work, but every time this is escalated the problem is misunderstood.

Is there any way or resolving this? ... or do I need to look for a software that CAN actually manage currency?

Thanks,

Sam

Hi there, @9130 3523 9912 4866,

I wish you didn't have to go through all of these. I understand how important it is to match invoices with your foreign currency transactions. However, the option to match it is currently unavailable. 

As a workaround, you can consider re-creating your invoice and the customer profile. After that, you can now set up their home currency to the one you wish to match. Next, you have to receive the payment, and then match your invoices with your downloaded bank transactions on the Banking page.
Here's how to create and set a customer's currency:

1. Go to the Sales tab, and select Customers.
2. Click the New Customer.
3. Select the customer's home currency.
4. Enter the necessary details.
5. Click Save.

You can also enter home currency adjustments for your foreign balances.

For more information, you can visit: Receiving and making payment for a foreign invoice/ bill with a foreign currency.

I'll also add this article for future use if you wish to learn more about multi-currency in QBO: Multi-currency FAQ.

Don't hesitate to click the Reply button if you need further assistance with your QuickBooks account. Keep safe.

Thank you,

But I still don't think you understand the issue I and other users are faced with.

The customer is already set up with the correct currency. But when their money hits the bank it is impossible to match it to the invoice raised. For some reason, you cannot see all open invoices. QB decides selectively which ones to offer you to match to, and the ones you need don't appear.

Can we get on a call so i can show this to you?? This is getting ridiculous. You will see what I mean straight away. So far on this threat, I've been misunderstood on three occasions.

Please don't send me to the online chat or service call, I do this every month and I'm always sent here to find a solution. I believe the solution is in your coding/algorithms. You have not chance to fix this until someone who can make a change understands glitch in your software that your frustrated customers are experiencing.

Thanks

I hear all your sentiments, and I appreciate your efforts in dealing with this problem, @9130 3523 9912 4866. 

I completely understand your desire to display the appropriate invoices in the Banking window to match the right bank. Please be aware that the invoice will not appear if there is a multicurrency issue with the exchange rates or if the transaction does not pass through the home currency at some point.

For more information, check out this article: Categorize and match online bank transactions in QuickBooks. Directly go to the Match with an existing transaction section. 

I understand how valuable your time is, and I appreciate you taking the time to contact our customer service team. But the best thing to do in this situation is to send feedback to our product engineers. They have the tools to work on the coding, algorithms, and other tasks related to considering adding the feature. You can follow the steps outlined by Angelyn_T above. 

You might also want to check out the articles below to learn more about how to change an assigned currency for a customer or vendor, pay employees using a different currency, and other related topics:

• Manage customer's currency in QuickBooks
• Frequently Asked Questions about Home Currency Adjustments

You can always go back to this thread if you have other questions. I'll be around if you need any help. Keep safe.