QBO wont match credit card transactions (that were uploaded from a csv file that I created) to open bills

TDInc · ‎February 26, 2022

QBO successfully matches credit card transactions to open bills when these transactions are automatically uploaded from my online banking platform. I created and uploaded a csv file for the credit card transactions that cannot be accessed from my bank's online platform. However, QBO cannot match these specific transactions to open bills.

I cannot find a thread that addresses my issue and two different QBO support employees were not able to solve this issue. Each credit card transaction's date, category, amount, etc. are identical to the corresponding open bill. The transaction is not reconciled or cleared. I cleared my cookies and cache. I cannot move forward until I resolve this issue. Any technical advice is greatly appreciated.

SarahannC · ‎February 26, 2022

Welcome to QuickBooks Community, @TDInc!

Aside from having the same details from credit card transactions and the ones manually entered in QuickBooks, there are other several reasons why QuickBooks may not recognize a match.

The transaction is older than 180 days.
The transaction that you've manually uploaded is a payment/ deposit of two or more open transactions in QuickBooks.
The transaction was recorded in a different bank account.

You can use bank rules to automatically process transactions you've manually imported from bank feeds. It saves you time by setting up automatic categorization.

From the Banking menu, choose Rules.
In the upper-right corner, click on New Rule.
Fill in the required fields of the form.
At the bottom, ensure that Automatically confirm transactions this rule applies to is turned on.
Click Save.

You can check this article to learn more about the Bank rule feature: Setup bank rules to categorize online banking transactions in QuickBooks Online.

Just to add, still, you can match by utilizing the Find Match option to find the correct transaction or see see options that might match. Here's how:

Go to the Banking menu.
Select the account where you receive the deposit.
Click the transaction to expand the options, then tap the Find Match radio button.

To keep your bank transactions organized, you can check these articles:

Let me know if you have other questions or need more help handling transactions in QBO. The Community is always around to help. Take care and stay safe.

View solution in original post

SarahannC · ‎February 26, 2022

Welcome to QuickBooks Community, @TDInc!

Aside from having the same details from credit card transactions and the ones manually entered in QuickBooks, there are other several reasons why QuickBooks may not recognize a match.

The transaction is older than 180 days.
The transaction that you've manually uploaded is a payment/ deposit of two or more open transactions in QuickBooks.
The transaction was recorded in a different bank account.

You can use bank rules to automatically process transactions you've manually imported from bank feeds. It saves you time by setting up automatic categorization.

From the Banking menu, choose Rules.
In the upper-right corner, click on New Rule.
Fill in the required fields of the form.
At the bottom, ensure that Automatically confirm transactions this rule applies to is turned on.
Click Save.

You can check this article to learn more about the Bank rule feature: Setup bank rules to categorize online banking transactions in QuickBooks Online.

Just to add, still, you can match by utilizing the Find Match option to find the correct transaction or see see options that might match. Here's how:

Go to the Banking menu.
Select the account where you receive the deposit.
Click the transaction to expand the options, then tap the Find Match radio button.

To keep your bank transactions organized, you can check these articles:

Let me know if you have other questions or need more help handling transactions in QBO. The Community is always around to help. Take care and stay safe.

TDInc · ‎February 26, 2022

The function related to the 'Find Match' radio button is not working as confirmed by the two members of the QBO support team. No matches are found regardless of the category or date timeframe.

> The transaction is older than 180 days.

> YES: The transactions that I am having issues with are dated January-July 2021

> How do I deal with this?

> The transaction that you've manually uploaded is a payment/ deposit of two or more open transactions in QuickBooks.

> NO

> The transaction was recorded in a different bank account.

> NO

Angelyn_T · ‎February 26, 2022

Hi, @TDInc. Let me give you some additional insights about matching bank or credit card transactions in QuickBooks Online (QBO).

Usually, once the downloaded transactions are more than 6 months (180 days) old, the system won't automatically look for a match. You have to find a match manually by clicking on the Find match button.

Sign in to QuickBooks.
Click on Banking at the left pane.
Go to the Banking page, then select your bank.
Tap on the transactions from the For Review section, then select the Find match button.
Select the available match from the result.

If you don't see any transactions from the Select transaction to match window, make sure that the transactions:

don't have a different number, amount, date, or payee from the downloaded expenses
haven't been previously matched to another downloaded transaction
weren't reconciled

Once the transactions are reconciled and matched to other entries, or if it has different information from the downloaded or uploaded ones, they will never show up when you find a match.

If they were reconciled, you can undo the reconciliation. Once you've

successfully matched your entries, redo the reconciliation to avoid issues with your balances. You may also connect with your accountant for further assistance to keep your book in place.

For more tips while handling your banking transactions in QuickBooks, you can check out the resources from this link: Find help with bank feeds and reconciling accounts.

Let me know if you have any other follow-up questions while matching your bank entries. I'm more than happy to provide help. Have a great weekend!

TDInc · ‎February 26, 2022

Thank you for your continued support!

None of the following apply:

transactions don't have a different number, amount, date, or payee from the downloaded expenses
transactions haven't been previously matched to another downloaded transaction
transactions weren't reconciled

MarsStephanieL · ‎February 26, 2022

Hi there, @TDInc. I appreciate your time to get back to us. I can see here that you need live assistance and do a screen share session to review your bank transactions and successfully match them.

I'd recommend contacting our QuickBooks Online (QBO) Care Team to verify and check the transactions further. They have the proper tools to perform a screen share session and guide you through the step-by-step process. There might be a flaw with the setup of the bank transactions or missing transactions in QBO that affects the process of matching them in the Banking page.

Here's how to contact them:

On the header part of the QBO page, select the ? Help button.
Choose how you want to be assisted, either getting a callback or chat.
Enter your concern and your info.

You can take note of the support hours to get assisted right away.

Moreover, I've added an article that you can check out for more details as to why you're not able to see possible matched transactions. See Find out why there are transactions that don’t have a match section in this article: Categorize and match online bank transactions in QuickBooks Online. This contains other workarounds on how to resolve the issue such as if the transaction you're trying to match has a multi-currency issue.

You're always free to share some updates on how it goes after speaking with our support team. Or let me know if you have other concerns. I'll do my best to help you. Take care.

TDInc · ‎February 27, 2022

Hi all, I found the issue. I had reversed the credit and debit columns in the csv file. My mistake!

Thank you for your continued assistance.

Topics

Training

Community

Resources

QBO wont match credit card transactions (that were uploaded from a csv file that I created) to open bills