Skip to main content
T
TDInc
February 26, 2022
Solved

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

  • February 26, 2022
  • 1 reply
  • 0 views

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.

Best answer by SarahannC

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. 

 

  1. From the Banking menu, choose Rules. 
  2. In the upper-right corner, click on New Rule. 
  3. Fill in the required fields of the form. 
  4. At the bottom, ensure that Automatically confirm transactions this rule applies to is turned on. 
  5. 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:

  1. Go to the Banking menu.
  2. Select the account where you receive the deposit.
  3. 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.

1 reply

S
SarahannCAnswer
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. 

 

  1. From the Banking menu, choose Rules. 
  2. In the upper-right corner, click on New Rule. 
  3. Fill in the required fields of the form. 
  4. At the bottom, ensure that Automatically confirm transactions this rule applies to is turned on. 
  5. 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:

  1. Go to the Banking menu.
  2. Select the account where you receive the deposit.
  3. 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.

T
TDIncAuthor
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
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.

 

  1. Sign in to QuickBooks.
  2. Click on Banking at the left pane.
  3. Go to the Banking page, then select your bank.
  4. Tap on the transactions from the For Review section, then select the Find match button.
  5. 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!

Terms & ConditionsAccessibility statement