Why are my incoming bank transactions no longer matching transactions that I have entered - it seems to just not match on automatically created transactions in quickbooks

Hi there, PMCDude.

Let's get to the bottom of this together to determine why the system stopped matching your bank transactions.

QuickBooks Online automatically matches your bank deposits that correspond to QuickBooks Payments transactions. This option can be turned off. It's the reason why it stopped matching your entries. 

I'm here to help you switch it back on:

1. Go to Transactions, then Bank transactions.
2. Select the Categorized or Reviewed tab.
3. Click the Settings (⚙) icon at the top of the transaction list.
4. Turn the Automatic matching switch On.

If it's already on, I recommend accessing QBO via a private window. It'll help us determine whether this is a browser cache-related issue. The search engine you regularly use when working on your books utilizes cached data to load web pages faster. However, excessive cache can lead to problems that cause QuickBooks performance to degrade and affect the account's functionality.

When using incognito mode, it'll assist us in determining its exact cause since this doesn't save your browsing history and doesn't accumulate cache. Here are the keyboard shortcuts: 

• Safari: Command + Shift + N 
• Google Chrome: CTRL + Shift + N
• Mozilla Firefox or Microsoft Edge: CTRL + Shift + N

Once logged in, verify if the transactions match. If so,  clear the browser's cache. Doing so mitigates the issue and ensures optimal performance in QBO. Using other supported browsers also helps us verify if this is a browser-specific problem. 

Additionally, it's recommended to review and reconcile your accounts periodically. Doing so ensures that your records are up-to-date and free of errors.

Do you require additional assistance with managing your invoices and online payments? Please do not hesitate to include them in your response. I'll be right there to help you whenever you need it!

It is only doing this on some transactions, not all. I have other transactions that are matching just fine. Also, these transactions that aren't working, worked last month. They are automatically created transactions in QB and in my bank’s online banking. They have been matching for months (maybe years) and now just started not matching this month.

Thank you for reaching out QuickBooks Community. You in the right path, @PMCDude.

I can surely help you with your concern that matching transactions is not working. 

For each associated payment needs a unique ID for each payment transaction. Your bank may have not provide a unique ID with your last payment transaction. That's why it's not matching for a month. If this happens, I suggest manually manually matching your bank entries and making sure to check if your automatic matching is not off. 

Here's how to manage automatic matching:

1. First, go to Transactions, then Bank Transactions.
2. Choose Categorized or Reviewed.
3. Click Settings ⚙ at the top of the transaction list.
4. Turn On or Off the Automatic matching switch.

For more information on how automatically matches your QuickBooks Online Payments transaction, check on the link.

Moreover, try to check these articles to run payroll and customize reports:

• How to run and customize reports in QuickBooks Online
• Run payroll reports

If you have more questions about matching bank transactions, please 

leave a comment below. I will keep an eye and will answer you.

Before I made any changes, some more transactions were matched but still not all of them.

I don't have an option for automatic transaction matching on that gear. I do have "Grouping" or "Add new vendors" under automation. I tried turning add new vendors on/off.

Also, manual matching doesn't work. I had already tried that. It doesn't find the transactions. (see attached)

Hello there, @PMCDude.

I understand the importance of getting your transaction match in QuickBooks Online (QBO). Let me help you fix it.

Let's check for the following criteria that could prevent the program from matching the deposit to the payment:
 

• Verify that the transaction has not been reconciled.
• Verify the transaction was entered using the same bank account.
• Make sure the QuickBooks Online transaction has not been previously matched to another bank downloaded transaction.
• If it is a deposit or payment received, make sure it is not on the Bank Deposit page (undeposited)
   

If everything is verified and you're still unable to match the transactions, you can Exclude them instead.  This will move them out of the For Review tab, and won't impact your books since you've already recorded the payment. Should there be mistakenly excluded transactions, click on Undo to retrieve them.

If you still want to match it and further investigate the issue, I encourage you to talk with our phone or chat support. They have the necessary tools to securely check your account via screen-sharing sessions.

Here's how:
 

1. On your company file, go to the Help menu.
2. Select Contact Us.
3. Enter your concern, then select Let's Talk.
4. Choose a way to connect with us:

• Start a chat with a support expert.
• Get a callback from the next available expert.
   

Here's an article for more details about the support schedule: QuickBooks Online Support.

Once, everything good and you're able to connect your bank to QBO, you can check out the following articles that you may find helpful in the future:
 

• Categorize online bank transactions in QuickBooks Online
• Reconcile an account in QuickBooks Online
   

Tag me in the comment section if you have follow-up question in managing your bank in QuickBooks. I'll be around to help you.

Dude,

I am having the same problem.  Yes, you can always exclude them as mentioned above, but kinda defeats the purpose.

Frustrating!

Anne

Thanks for that feedback. I never got it resolved by QuickBooks. 

Hello there, @Anne911.

Allow me to chime in and provide insight about the transactions no longer matching in QuickBooks Online (QBO).

To begin with, please note that each paymet transactions requires a unique ID. If your bank didn't provide a unique ID with your last payment transactions, they may not match for a month. In this case, I recommend manually matching your bank entries and making sure that your automatic matching is turned on.

Here's how to manage automatic matching:

1. First, go to Transactions, then Bank Transactions.
2. Choose Categorized or Reviewed.
3. Click Settings ⚙ at the top of the transaction list.
4. Turn On the Automatic matching switch.

For more information on managing automatic matching, refer to this article: Automatically match QBO product transactions

Additionally, some transactions may not find their match from existing records due to the following reasons:

• The amounts or dates don't match.
• The transactions are older than 6 months.
• The bank account on the payment isn't the same as the bank where the match is located.
• The payment has been reconciled.
• The record is already matched to another transaction. 
• There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

For reference, check this article: Match online bank transactions

If you have ruled out all these possibilities and still can't find a match, I suggest contacting our support team for further assistance.

On the other hand, I appreciate you for getting back to the thread and providing an update about your concern, @PMCDude.

I understand the importance of matching your transactions to manage your business effectively. While I'd love to help you with this, we're unable to check your account here in the Community for security reasons. I recommend contacting our support team for help in following up on your case about the transactions not matching.

I'll also add these articles to help you review your transactions and reconcile your accounts so they always match your bank and credit card statements:

• Categorize online bank transactions
• Reconcile an account

Please let me know if you have any follow-up questions about transactions no longer matching or anything else related to QuickBooks, @Anne911. I'll be more than happy to answer them.

I also noted that manually matching the transactions doesn’t work. Why would that be? Maybe a QBO change/problem?

Let me join in this conversation and provide you with further help, @PMCDude.

There are possible reasons why some transactions can’t find their match from your existing records. Here are the possibilities as to why you have transactions without a match:
 

• There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.
• The record is already matched to another transaction.
• The amounts or dates don’t match.
• The transaction is older than 6 months.
• The bank account on the payment isn't the same as the bank where the match is located.
• The payment has been reconciled.

As a workaround, use the Find other matches option to review your downloaded transactions. Let me show you how:
 

1. From the For review tab, click the transaction.
2. Select the Match button and click Find other matches.
3. Filter the date range and transaction type. You can also search for the reference number, payee, or amount.
4. Check the box for the transaction you want to match.
5. Select Match.

For additional reference, check the article about Matching online bank transactions in QuickBooks Online. 

If the issue persists, I recommend contacting our QuickBooks Online Support Team. They can review your account and provide you with further help to fix it.

After successfully categorizing your transactions, you can now reconcile your accounts to ensure they match your bank and credit card statements.

Please let me know if you have additional questions about matching downloaded transactions in QuickBooks. I'm always around to help. Have a good one.

We are having the same issue and like the previous comment we do not have the option to turn Automatic matching on or off. Can you address this as you seem to have ignored it previuously.

I didn't make any changes and it is now working. Interesting. No changes, Quickbooks, right? Ha.

In particular Payroll is not showing up for matching, but wants to "confirm" which isn't the same thing. Why are the payroll items not just matching up. Oh, I checked to be sure that the matching feature is turned on.

I'll be sure to assist you in resolving the issue of the payroll item not showing up, sntfchf.

There could be a few reasons why some transactions may not be able to be matched with the existing records:

• The amounts or dates don't match.
• The transactions are older than 6 months.
• The bank account on the payment isn't the same as the bank where the match is located.
• The payment has been reconciled.
• The record is already matched to another transaction. 
• There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

You can find other matches and confirm the correct date range on the Find other matches page.

Also, toggle the Automatic matching feature off and then back on again. This can sometimes trigger the system to re-scan for potential matches. If the problem continues, you'll have to match manually any new transactions.

In addition, I'm sharing an article that outlines the benefits of accurate record-keeping for businesses and employees.: Run payroll reports.

Feel free to reach out if you have any other questions about matching downloaded transactions in QuickBooks. I'm happy to provide further assistance whenever you need it.

Everything seems to be working better. I just wish that quickbooks could admit that they had a problem.

Hello,

I am having the same recurring problem. And I called QB Support many times and nobody can figure out where the problem is. But it only happend in the following circumstances.

• I have a few credit cards charges processed by Stripe and deposited in my bank account as a lump sum at the end of the day.
• All credit card transactions are entered manually in QB as Customer Deposits and Payments
• When the Stripe payment reaches my bank account, it appears in my bank transactions the next morning
• Then I match my manually entered transactions with the bank deposit.

Here's when the problem occurs:

• There a just a few payments received in the bank deposit, AND there are some refunds made to customers.
• The refund amount is significant compared to the payments. i.e. $1000 in payments, and $900 in refunds. For a net deposit of $100.

The following have been checked:

• The amounts or dates match.
• The transactions are NOT older than 6 months.
• The bank account on the payment IS the same as the bank where the match is located.
• The payment has been NOT been reconciled.
• The record has NOT been matched to another transaction. 

Also:

The proper Date, Amount, and Transaction Type do appear in the Bank Registry.

• There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

If anyone can help I will be very grateful.

Thank you

This is not the experience we want you to have when matching your bank transactions in QuickBooks Online (QBO), SSI3. Let me provide you with details about matching transactions.

When using the matching feature in QBO, it's important to remember that two different types of transactions cannot be matched. For instance, a deposit transaction cannot be matched with a refund transaction. Matching transactions should involve similar types of transactions to ensure accurate accounting and proper reconciliation.

For the accuracy of your financial records, I suggest referring to your accountant so they can help you out. If you don't have an accountant, we can help you find one. Feel free to visit this page to find an accountant for your business: Find a QuickBooks ProAdvisor.

If you encounter any difficulties managing online bank transactions, please don't hesitate to let me know by leaving a comment below. The Community is available and prepared to help you whenever you need it.

Good day, and thank you for taking the time to respond to my message.

When you say "a deposit transaction cannot be matched with a refund transaction", are you saying that as soon as both types of transactions are in the same bank deposit, the accounting will not be accurate?

In my situation, if the refund amount is relatively low compared to the sum of deposite and payment, the bank matching will work very well. For example, in a Stripe deposit of $1,000, if in there I have refunds for $200, and the rest is composed of deposite and payments, the bank match will work very well.

However, if the refund amount is relatively high compared to the sum of deposite and payment, the bank matching will not work, in a way that some transactions will not appear when I enter the dates and do a search in QBO. For example, in a Stripe deposit of $1,000, if in there I have refunds for $800, and the rest is composed of deposite and payments, the bank match will not work.

Thank you, and hopefully you can put me on the right path to a solution.

Kind regards,

Thanks for the reply on the thread, SSI3.

I know how crucial it is to match transactions in QuickBooks Online. However, it's essential to note that you can't match a bank deposit with a refund transaction, since a deposit increases the bank balance while the refund decreases the bank's balance.

On the other hand, all you can do is exclude the downloaded transaction in QuickBooks and then manually mark the refund and sales transaction as cleared in the bank register. I can guide you through the steps to clear the transactions manually.

Here's How:

1. Log in to your QBO account.
2. Go to the Gear icon settings, then select  Chart of Accounts.
3. Open the transactions, then make the checkmark status C

Additionally, refer to this article for more information on managing and learning to categorize online bank transactions in QuickBooks Online.

If there is anything else that I can help you with, please let me know in the comment section below. I'll always be around ready to help. Take care!

Good morning and thank you,

I will exclude the transaction and mark as cleared.

Kind regards.

Quickbooks is a joke. Every upgrade you morons do screws everything up. Nobody

seems to know why intuit credit card deposits no longer match. Literally been years. WTF

would I use intuit to process credit card transactions if it can't recognize it's own deposit.

If I wasn't so invested in this garbage software I would have left years ago. Clowns.