Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
P
Petiezee
November 10, 2022
Solved

Why won't downloaded bank transactions match entries in QuickBooks Desktop?

  • November 10, 2022
  • 7 replies
  • 67 views

This began only after I just had to "re-connect" Bank of America maybe 3 weeks ago to the "new" way they (or intuit) required me to.

 

For instance:  I enter a payment from a customer: 5.81 from Joe into Received payments.  Into my correct bank account.

2 days later Bank of America downloads the same Transaction for $5.81, but does not match the two, as AUTO matched (BLUE TAB) as it had in the past.

 

Same goes for my imported payroll files from QB.  I have the imported transaction in my QB, and B of A downloads the same transaction, but fails to match them.

 

Same goes for Payments.


I paid $121.96 to home depot and entered the "check": Allocated it to a customer, and job.

2 days later i download transactions through B of A express connect.  It sees a 121.96 from b of a, but fails to auto match the 2.


In my register, it shows a lightning bolt next to the transactioon.  If i DELETE the lighning bolt, and save it, then go back into my downloaded transactions, it magically now appears in "Matched" waiting for me to confirm it's a good match.

Here's the rub...  SOMETIMES the matches work.  I cannot explain how or why....  BUt many are missed.  Dozens..

I keep waiting for a software patch download, but it's been about 3 weeks and going.

 

Trying to call tech support on the subject takes a minimum of 1.5 hours to get to anyone who isn't level one, and then to tell them the problem to a point that they understand.  I do have a case # [removed] open though. 

HELP!!!!!????

Best answer by Emma_P

QuickBooks matches downloaded bank transactions to what's already in your books by comparing the check number, amount, date, and payee name. If even one of those details is a little different, the QuickBooks entry has already been reconciled, or the download is flagged as a duplicate, the match won't happen automatically.

Reasons a transaction won't auto-match

  • The details don't line up exactly. A different date, amount, check number, or payee name than what's already entered will stop the match from happening.
  • The entry's already reconciled. Once a transaction is reconciled, it won't match again, even if a matching download comes in later. You'll see a checkmark in the CLR (cleared) column on those entries.
  • It's flagged as a duplicate. A lightning bolt in the CLR column means QuickBooks has flagged the download as a duplicate, and it won't try to match it again.

How to fix it

  1. Check the details first. Open the entered transaction and compare it to the downloaded one. If the date, amount, or name is off, update the QuickBooks entry to match your bank record, and it'll move to Matched. Only do this once you've confirmed it's the same transaction.
  2. Skip the edits and match manually instead. If updating every transaction sounds like a lot of extra work, you don't have to. From the Bank Feeds Center, you can select the downloaded transaction and match it directly to the one already in your books, without changing any of the entered details. This is usually the faster path when the two are close but not identical.
  3. Check for reconciled entries. If the matching QuickBooks entry already shows reconciled, that's why the download isn't matching. It's expected behavior and doesn't need a fix.

 

For step-by-step instructions on matching in your specific Bank Feeds mode (Express, Classic, or Advanced), see Add and match Bank Feed transactions in QuickBooks Desktop.

 

Got more questions about your bank feed? Drop them below and we'll help you sort it out.

 

7 replies

MichelleBh
MichelleBh
Level 8
November 10, 2022

I'll explain to you, @Petiezee, the possible reason why transactions from the new Bank of America that doesn't automatically match in QuickBooks. This way, I can guide you accordingly in managing your bank data.

 

I appreciate you providing complete details of your concern and all your efforts. There are times when QuickBooks can't match a transaction because of the following:

 

  1. The transaction number, amount, date, and name could all be different. Find the transaction in QuickBooks and make any necessary changes based on your bank records. Doing this will change the downloaded transaction's status to Matched.
  2. If a downloaded transaction matches an already reconciled transaction, QuickBooks won't match them. 
  3. Although rare, QuickBooks might download duplicate statements or transactions. If transactions have a lightning bolt ⚡ in the CLR column, they won't match again, even if all the info is the same. Deleting the bolt is a great alternative solution to match the transactions.

 

For more details, see this link: Add and match Bank Feed transactions in QuickBooks Desktop.

 

If the issue persists, you can contact our team again via phone or chat. They can review your account in a safe place. If needed, they can send tickets to our engineer about the issue and open an investigation. 

 

Here's how:

 

  1. Go to this QBDT help link.
  2. Select your product and click Continue.
  3. Enter your concern in the box and tap Continue.
  4. Choose either Chat with us or Have us call you. 
  5. Follow the on-screen instructions.

 

Make sure to contact them within business hours to ensure a swift response.

 

Additionally, the current release numbers for each version of QuickBooks Desktop:

 

  • QuickBooks 2023 R3_119
  • QuickBooks 2022 R5_158
  • QuickBooks 2021 R10_55
  • QuickBooks 2020 R15_54

 

For more details, see this link: Update QuickBooks Desktop to the latest release.

 

Moreover, check out these articles below on how to troubleshoot banking issues and reconcile bank accounts: 

 

 

Let me know how everything goes and if you have any other concerns by updating this thread. I'm here to keep helping. Have a good one!

P
PetiezeeAuthor
November 11, 2022

So, youre telling me that if:

I have entered a Payment on 11/1, after the transaction downloads and says the payment cleared on 11/3, in order for the item to match up, I have to go and edit the payment date so they're the same?  That's ridiculous to think I'm going to go back in and edit each transaction that now doesn't match up, to get them to match. 

 

The software has a glitch, since the newest update with B of A web connect, and surely I'm not the only one to be seeing this.

    T
    TCBlack
    December 15, 2022

    I've been having the same problem for the same amount of time - still waiting for a fix and still don't have time for a 2 hour call to support.

    Have you had any luck?

    Emma_P
    Emma_PCommunity ManagerAnswer
    Community Manager
    August 20, 2026

    QuickBooks matches downloaded bank transactions to what's already in your books by comparing the check number, amount, date, and payee name. If even one of those details is a little different, the QuickBooks entry has already been reconciled, or the download is flagged as a duplicate, the match won't happen automatically.

    Reasons a transaction won't auto-match

    • The details don't line up exactly. A different date, amount, check number, or payee name than what's already entered will stop the match from happening.
    • The entry's already reconciled. Once a transaction is reconciled, it won't match again, even if a matching download comes in later. You'll see a checkmark in the CLR (cleared) column on those entries.
    • It's flagged as a duplicate. A lightning bolt in the CLR column means QuickBooks has flagged the download as a duplicate, and it won't try to match it again.

    How to fix it

    1. Check the details first. Open the entered transaction and compare it to the downloaded one. If the date, amount, or name is off, update the QuickBooks entry to match your bank record, and it'll move to Matched. Only do this once you've confirmed it's the same transaction.
    2. Skip the edits and match manually instead. If updating every transaction sounds like a lot of extra work, you don't have to. From the Bank Feeds Center, you can select the downloaded transaction and match it directly to the one already in your books, without changing any of the entered details. This is usually the faster path when the two are close but not identical.
    3. Check for reconciled entries. If the matching QuickBooks entry already shows reconciled, that's why the download isn't matching. It's expected behavior and doesn't need a fix.

     

    For step-by-step instructions on matching in your specific Bank Feeds mode (Express, Classic, or Advanced), see Add and match Bank Feed transactions in QuickBooks Desktop.

     

    Got more questions about your bank feed? Drop them below and we'll help you sort it out.

     

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement