When I import my local currency bank transactions, there's an option to 'find match', however this isn't there for my USD bank transactions. How do I add this?

Thanks for reaching out to the Community forum, finance109.

May I ask what is the local currency your referring specifically? I want to ensure this gets resolved for you. 

Right now, when importing bank transactions, if your bank account is US, then the currency that will be imported is only US. The option to import or sync other currencies different from your bank isn't an option. As a workaround, you can convert the amount to be the same on your local bank. 

Moreover, there are also format's that you need to consider. You can check these articles for guidance:

• Import bank transactions using Excel CSV files
• Common errors for importing bank transactions using CSV

If you have further questions, let me know by commenting below. I'm here for you. Have a great day!

Hi, 

Yes, the foreign currency I am referring to is USD. The bank account is set up as USD and the bills have been added to the USD payables account, which is why I'm a little confused why the 'find match' button is not available. I've added a photo for reference. 

Is this something to do with the set up? 

Thanks,

It looks like it's set up correctly, Finance109.

As my colleague shared, if it's set up as a US bank, then you can match it with US downloaded transactions. We'll need to take a better look at this. I'd suggest reaching out to our customer care support so an agent can investigate further. Here's how:

1. Click Help inside QuickBooks Online.
2. Select Contact Us.
3. Enter "No find match option" in the description field, then click Let's talk.
4. Select Start an email. 

Once transactions are downloaded or imported, you can already categorise and match them.

Get in touch with us if you have other banking concerns. Keep safe!

Hi, 

I'm not sure if/how this has been resolved, but I have the same issue. Maybe there is a workaround, but I cannot match my bank transactions with my bills for one of my bank accounts (USD). My other account in my standard currency is fine. This is quite annoying right now, because either I have to book bills as expenses or I need to exclude bank transactions and record everything automatically. 

Thanks for checking in with us, Bart57.

It seems that QuickBooks Online (QBO) will not allow you to use the Find Match process in foreign currency bank accounts, Even though the Bill currency is the same as the Bank currency. However, we pay bills by following the steps below:

1. Go to Expenses on the left menu. 
2. Select your Supplier and Transactions List.
3. You will get a list of outstanding Bills. QBO will probably have selected the first in the list. You can untick this.
4. You also have at the right a window headed up "Add to Bill Payment" with tiles showing the outstanding Bills. The info shown in each tile will be Bill number, Date, Amount and an "Add" and "Open" button.
5. Just add all the bills in this window that you want to pay.
6. The Amount Paid value in the main window will increase until it matches the amount of the payment you made (and are trying to match to).
7. Once it agrees, press Save and close.

Go back to your Bank Feed. You'll see the payment you were trying to match will have a green "1 record found" notification. Then, it will match the choice both to the right and if you open the transaction line. If you agree with the match, select it and your bank feed will move to Reviewed.

Also, other suggestions for using the Make Payment choice in the Expenses/Supplier/Transaction List screen and then Exclude the payment in the Bank Feed will work. Once you add them manually using the Make Payment option (if you can't match in Bank Feeds) you may Exclude them from Bank Feeds, otherwise, it results to duplicate transactions.

Feel free to visit our Banking page for more insights about managing your bank feeds transactions.

I'd like to know how things going after performing the steps provided, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

Hi, 

Thanks for the quick reply. I don't see however what you're referring too. I'm using QB Version 4.2.1-79 (4.2.1-79.79)

See screenshot below (unless I'm missing something?). If I click on make a payment, and fill in the details + match the date of the bank transactions, it still doesn't find a match. The other choices in the right dropdown are create bill and create expense.

Best,

B

Thank you for the screenshot you've provided, Bart57. This helps me identify the issue in locating the match of your transaction.   

We need to ensure you've created a bill to your supplier for us to find the match of the transaction. Once you click the make payment, it will automatically pop up the Outstanding Transactions.  

However, if you haven't created a bill for your supplier, you can create a bill and make sure the original amount and open amount are the same and also the date of the transaction.  

You can also follow my colleague's steps above to add and find a match in QuickBooks Online.  

Here's more information about adding and matching transactions in QuickBooks Online: Categorise and match online bank transactions in QuickBooks Online. 

Please don't hesitate to post any questions you may have concerning QuickBooks. I'll make sure your taken care of. Take care!

Hi,

It still hasn't worked for me. What's interesting though is that if I have a recent bill (last month) it does match with my bank transactions of this USD account.

If its old (beginning of 2020) it doesn't seem to match, even though everything else is the same. I'm guessing its because the timeframe that its looking for a match is not long enough. This can also happen when I'm doing it with my other bank account, but in this case I can look for a match and expand the time frame. With my USD account, I cannot click on the match option (as per the screenshot I've sent).

Best,

Bart

Let me join this thread and share more info about matching bank transactions, Bart57.

You can match foreign transactions regardless of how old or new they were. However, the Find match button only appears if QuickBooks Online recognizes and suggested a matching entry. We just need to make sure that the details are correct and the same.

If you are still unable to match them, what I can suggest to exclude the downloaded transactions and manually clear the entry in QuickBooks Online.

Follow these steps to clear them:

1. Go to the Accounting menu and select Chart of Accounts.
2. Find the bank account and click Account history.
3. Locate the transaction you recorded and select it to expand. 
4. Click the box under the Check column until you see the letter C, then Save it.

I've added these articles for more details on how to review downloaded bank and credit card transactions.

• Categorise and match online bank transactions in QuickBooks Online
• Reconcile an account in QuickBooks Online

The Community is always here to help you if you have other concerns. Have a great day!

Ok, I figured out this problem. I decided to write it down here in case others have similar issues.

The problem is that if you create a bill, let's say for 100 USD. You bank transactions might also show 100 USD, but still there is no match to be found.

The issue is that the "match" function is using the default currency (e.g. SGD) to search for matches. The way to solve this is by looking at which currency rate your transaction was made and ensure that this matches the currency rate of the bill. I don't know if this is the right way, but it worked for me.

Best,

B