cancel
Showing results for 
Search instead for 
Did you mean: 
elingbookkeeping
Level 2

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

 
Solved
Best answer March 09, 2022

Best Answers
MirriamM
Moderator

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Hi there, @elingbookkeeping.

 

Allow me to join the thread and provide information about matching bank downloaded transactions in QuickBooks Online (QBO).

 

There are possible reasons why our system is unable to recognize the match in QuickBooks. These are due to the following:

  • The transaction is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • The transaction was recorded in a different bank account.
  • The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

 

To display all the possible matched transactions, let's use the Find Match option. You can follow the steps provided by my colleague above. 

 

 For more information about the process of matching bank transactions, check out this article: Categorize and match online bank transactions in QuickBooks Online.

 

For additional resources about managing your banking transactions, you can check out the topics from this link: Find help with bank feeds and reconciling accounts for QBO.

 

Drop me a comment below if you have any other questions about matching transactions in QuickBooks. I'll be more than happy to help. Have a great day.

View solution in original post

27 Comments 27
ChristieAnn
QuickBooks Team

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Welcome back to the QuickBooks Community, elingbookkeeping. I'll provide a piece of information about how QuickBooks Online matches your transactions. Then, ensure you'll be able to accomplish this matter.

 

When you connect your bank or credit card account to QuickBooks, it downloads your recent transactions. Then, QuickBooks will automatically match your transactions once it detects entries with a similar amount and details. 

 

However, if you already entered a transaction that should match, but QuickBooks can’t find it, you don't have to create a new transaction. Instead, I recommend using the find match option so you can look for the same entries to match the right one to avoid double entries.

 

Here's how:

 

1. Click the Banking menu at the left pane to get to the Banking page.

2. Locate the downloaded transaction and select Find other records/match to open the Match transactions window.

4. Choose the box to uncheck the recommended match.

5. Enter the correct date range in the From and To fields.

6. Choose the correct match and make sure the total matches the transaction downloaded from your bank.

7. Click Save.

 

For additional information, you can check this article: Fix mismatched or miscategorized bank transactions. This also provides details on how to create a new record if there isn’t a match.

 

Lastly, you may refer to this article to see the instructions on how you can reconcile your accounts so they always match your bank and credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Online.

 

Please know that you're always welcome to post if you have any other concerns about matching entries. I'm always here to help. Wishing you and your business continued success.

elingbookkeeping
Level 2

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Perhaps I didn't type my question clearly enough - the bank feeds are showing some transactions that already have a bill recorded in QBO.  It is not matching these two together.  I know how to "Find" and match a transaction manually.  I am concerned that QBO is not providing the "Match" in the bank feeds automatically, as it has for many of the other transactions.    It is not saving me any time if I have to manually find and match transactions

MirriamM
Moderator

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Hi there, @elingbookkeeping.

 

Allow me to join the thread and provide information about matching bank downloaded transactions in QuickBooks Online (QBO).

 

There are possible reasons why our system is unable to recognize the match in QuickBooks. These are due to the following:

  • The transaction is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • The transaction was recorded in a different bank account.
  • The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

 

To display all the possible matched transactions, let's use the Find Match option. You can follow the steps provided by my colleague above. 

 

 For more information about the process of matching bank transactions, check out this article: Categorize and match online bank transactions in QuickBooks Online.

 

For additional resources about managing your banking transactions, you can check out the topics from this link: Find help with bank feeds and reconciling accounts for QBO.

 

Drop me a comment below if you have any other questions about matching transactions in QuickBooks. I'll be more than happy to help. Have a great day.

djlw
Level 1

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Bottom line is this - Quickbooks Online has SEVERE bugs and this one is particularly annoying.  Quickbooks is blind to suggesting matches that are straightforward and simple to match.

 

This issue should be correctable by providing a script that optimizes the data files, then re-scans unmatched or freshly imported transactions to transactions already on file.  

 

Is there such a feature or are we paying loads of money for software that is much less efficient than the previous desktop versions?

KimN2
Level 2

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

When I download my transactions from the bank, QB used to automatically match my checks from the download to my register.  Since I got the QB for Macs 2022 desktop version, it no longer does this automatically. I have to manually find each check and then click the "match" button.

ReymondO
QuickBooks Team

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Thanks for joining the thread, @KimN2.

 

QuickBooks Online (QBO) and QuickBooks Desktop for Mac are two separate applications. However, both of these applications can use rules to automatically categorize downloaded transactions. 

 

In QBO, you can create rules to automatically categorize transactions for you. The more QuickBooks uses your bank rules, the better it gets at categorizing. After a while, it can even scan transactions and add details like payees.

 

In QB for Mac, you can set up renaming rules. This makes matching transactions easier if there's a payee from your downloaded transactions that has the same name as one of your vendors. Here’s how you can set this up.

 

  1. On the Downloaded Transactions window, click Renaming Rules.
  2. Select the + button to add a new rule.
  3. Set up your rules. Choose a condition and enter the text.
    • Begins with - this applies to any payee that begins with the text you enter.
    • Contains - this applies to any payee that has the text you enter.
    • Ends with - this applies to any payee that ends with the text you enter.
    • Exactly matches - this applies to any payee that exactly matches the text you enter.
  4. Select the action for the conditions you set.
    • Rename to - this renames the payee to a vendor name you select. If you want to add a new vendor, just enter the name and QuickBooks will prompt you to set up the vendor.
    • Don’t rename - the payee isn’t renamed. QuickBooks adds a default list of these “don’t rename” rules for checks, deposits, and withdrawals.
  5. Click OK when you’re done.

 

For additional info, you can check out this article: Manage renaming rules for payee names in QuickBooks Desktop for Mac.

 

You can also review out these articles as you get started with online banking in QB for Mac.

 

 

Should you have any follow-up questions or concerns, don't hesitate to post again here in the Community or leave a comment on this thread. Take care and have a good one.

TKruger86
Level 1

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

QB staff that assists you with problems are the worst...

All they do is copy and paste answers!

The question or problem provided was DEFINITELY not answered... 

Does not make them look competent to do their jobs.

 

Question says all the info are the same, yet they say the problem could be that it is not (facepalm)..

 

I am sitting with the same problem, Bank feeds are not matching OPEN BILLS 

(meaning they bills have not been paid, the transaction is not in another bank account and not older than 180 days or the wrong type of transaction)

Archie_B
QuickBooks Team

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Thank you for joining this thread, TKruger86.

 

I'm here to assist you in matching your bank transactions in QuickBooks Online.

 

Ideally, bank feeds transactions are matched with the same or close date, transaction type, details, and amount.

 

If QuickBooks is having trouble finding the possible match. You can follow the steps given by my colleague
ChristieAnn on how to use the Find match option. This will allow you to review the list of possible matches and avoid duplicate entries.

 

If no matching transactions are found, you can also add new ones to pay your open bills.

 

Like this:

 

  1. Find a downloaded transaction with the Add option in the Action column.
  2. Click the transaction to expand the view.
  3. Review the recommended Category. This is the account QuickBooks wants to categorize the transaction into. For example, for a gas expense, QuickBooks may suggest categorizing it under Travel Expenses. You can always change the category and put it in a different account.
  4. Change the vendor or customer as needed. Select the Find match option if you believe you have previously entered this transaction into QuickBooks. Review the list of possible matches and, if one is found, pick it.
  5. Review and add any other information that may be mandatory or missing.
  6. Once done, select Add.

 

I've included this article for more information: Categorize and match online bank transactions in QuickBooks Online.

 

You can also check out this link once you're ready to reconcile an account in QuickBooks Online.

 

For other banking concerns, just leave a comment below and I'll get back to you as soon as possible. Take care and have a great week!

 

TKruger86
Level 1

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Thank you for proving my point... 

Another copy and paste answer. 

I have read the whole thread, I know how QB works probably better than you do as I have found answers to problems that it seems you guys do not have.. 

 

I have allot of bills in my suppliers accounts, I have 2 tabs open and can see the bill in my supplier.. EVERYTHING MATCHES. 

In all the transactions.. date matches, amount matches, even the bank transaction description matches vendor. Stil none of the transactions are matching up. It is taking me longer because now I have to search or change filters when finding the match myself. 

When having 3 companies to run and capture, time means everything. 

 

It use to match, but then I had to create the transaction or categorize the transaction as i did not have the bill and since then it is not matching.

RCV
QuickBooks Team
QuickBooks Team

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

This is not the impression we want you to experience when matching transactions, @TKruger86

 

There are reasons why you're unable to match your transactions. These are due to the following:

  • Transactions have been previously matched to another downloaded transaction.
  • Transactions were not entered using the same bank account.
  • The transaction is entered manually in QuickBooks and could have a different number, amount, date, or payee from the downloaded expenses.
  • Transactions are already reconciled.

 

Thus, there are times that if the transactions aren’t the same as the downloaded, QuickBooks won’t find it. The only way to find this is to manually locate and match them, where you can use the Find Match option. Then, search for a possible match for that open bills. You can also use the Search field to locate transactions by amount, reference number, or memo. Here's how:

  1. Go to the Transaction menu and select Banking.
  2. Select the tile for the account you want to review.
  3. Select the For Review tab to start your review.
  4. Select the deposit to expand the view.
  5. Choose Find match.
  6. You can use filters/search to locate transactions. Remember to use a dollar sign or decimal point when searching for dollar amounts.

 

If you're still unable to find a match, let's perform basic troubleshooting steps. Issues like this are usually the result of outdated or corrupt cache files in your web browser. We can access your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

 

If it works, I recommend that you clear your browser's cache. By clearing them, you can remove that historical data and access QuickBooks with a clean slate. You can also switch to a different supported browser to see if it has something to do with your browser. I've got some articles here that will help you in managing your bank feeds:

Please come back and post about your results after the troubleshooting. It's my priority that you find the success you need. Have a great day ahead. 

KimN2
Level 2

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

I just need QB to match the amounts from my downloaded transactions to ones in my register.  Amounts, NOT the payee, I can add or change it as needed.  Having to hunt down every transaction to match it myself wastes a ton of time.  The old program used to do it this new 2022 doesn't.

Adrian_A
Moderator

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Hi, KimN2.

 

In QuickBooks Online (QBO), there are reasons why you're unable to match your transactions. These are due to the following:

 

  • Transactions have been previously matched to another downloaded transaction.
  • Transactions were not entered using the same bank account.
  • The transaction is entered manually in QuickBooks could have a different number, amount, date or payee from the downloaded expenses.
  • Transactions are already reconciled.

 

Thus, there are times that if the transactions aren’t the same as the downloaded, QuickBooks won’t find it. And it's you to manually locate and match them, where you can use the Find Match option and search for a possible match. For more information about the process, you can check out this article: Categorize and match online bank transactions in QuickBooks Online.

 

Please feel free to read these handy articles for your reference:

 

 

Let me know if you have further questions. Have a good one!

ortizp
Level 1

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Did you ever find a solution? My Quickbooks online just started doing this yesterday. All of the sudden it no longer matches even checks with the same check number and info. I have to now manually match even those. It's ridiculous!

RCV
QuickBooks Team
QuickBooks Team

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Let's perform some troubleshooting steps to get your banking transactions to match in QuickBooks Online (QBO), ortizp.

 

May I know your bank provider? so that I can check here on our records if there are reported cases about this one. There are a few possible reasons why you're unable to match your transactions. It could be the transactions have been previously matched to another downloaded transaction or they were not entered using the same bank account. It's also possible they are entered manually in QuickBooks and could have a different number, amount, date, or payee from the downloaded expenses. Lastly, maybe the transactions are already reconciled.

 

If the transactions aren’t the same as the downloaded, QuickBooks won’t find it. The only way to find this is to manually locate and match them. Just use the Find Match option and search for a possible match for the downloaded transactions. We can also use the Search field to locate transactions by amount, reference number, or memo. Let me show you how:

 

  1. Go to Banking on the left side menu and select Banking.
  2. Select the tile for the account you want to review.
  3. Tap the For Review tab to start your review.
  4. Select the transactions. 
  5. Choose Find match.
  6. You can use filters/search to locate transactions. Remember to use a dollar sign or decimal point when searching for dollar amounts.

 

If you're still unable to find a match, let's perform basic troubleshooting steps. Issues like this are usually the result of outdated or corrupt cache files in your web browser. We can log in to QBO through an incognito window to rule out the possibility of a webpage issue. Please refer to these shortcut keys to open an incognito window in all supported browsers:

 

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

 

If it works, I recommend that you clear your browser's cache. By clearing them, you can remove that historical data and access QuickBooks with a clean slate. You can also switch to a different supported browser to see if it has something to do with your browser. 

 

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

 

You can always come back and post about your results after the troubleshooting. It's my priority that you find the success you need. Take care always.

jmphoenix2000
Level 3

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

I've had a ton of problems with bank and Square integration with QB. Quickbooks automatically sorts stuff in the weirdest ways and totally freaks out when you want to correct anything. Some info from my bank gets completely twisted into nonsense and categorized in the least logical ways. I have gone as far as disconnecting my bank from it but then that defeats the purpose of having this "modern" tool to help keep things simple.

RCV
QuickBooks Team
QuickBooks Team

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

I can see how hard you tried here. No worries, I'll make it up to you to ensure you never have to deal with this again, jmphoenix2000.

 

When connecting your Square account, QuickBooks automatically categorizes and matches your bank records. All you need to do is review and approve the work. Also, QuickBooks downloads transactions based on the data provided by your Square app. Since the downloaded data are not matching in QBO, I'd suggest getting in touch with Square Support. They'd be able to check on how your account is set up and prevent this from happening in the future.

 

Once the issue is fixed and your Square transactions appear in QuickBooks, then you’re ready to review and add them to your books. Here's how: 

  1. Go to Bookkeeping, select Transactions, then 
  2. Choose App transactions, or go to Banking.
  3. Select App transactions.
  4. Tap For review. Your Square transactions appear in the list, with details like product description, quantity, purchase price, and fee breakdowns.
  5. For each transaction, choose an action, depending on the status. Select Add or Match (This transaction is ready to add to your books. If QuickBooks is connected to the bank account you use to deposit Square payments, you can match it to a specific transaction that’s already in your books). Tap Review (There are multiple transactions in the books that could be the same as the transaction from Square. Confirm which transaction it matches).
  6. Once you’ve added transactions, you can review them by going to the Reviewed tab, then select the sales receipt or deposit under the Added/Matched column.

 

To learn more about managing and connecting Square to QBO, consider checking out these articles:

 

 

Let me know in the comments below if you have other banking concerns or inquiries about managing your transactions in QBO. I'm just around to help. Take care always.

MichaelOD
Level 4

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

What box to uncheck recommended match!?!  I'd love to have that button!

MichaelOD
Level 4

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

How do we manually match when QB refuses?  How about I just select the invoice?  How do I turn off suggested matches?

JonpriL
Moderator

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Hello there, @MichaelOD.

 

I'm here to help share insights about categorizing and matching your online transactions in QuickBooks Online.

 

As of the moment, there isn't an integrated way to turn off the option where QuickBooks displays a suggestion of transactions to match. For now, let's consider clicking the Find other matches button to freely select the entry you wanted to match.

 

While I am unable to determine when such a feature like this is added to the program, I recommend getting in touch and letting our product developers know about this by sending a request via feedback. I'll show you how.

 

  1. Go to the Gear icon.
  2. Under Profile, select Feedback.
  3. Describe how the option to turn off suggestions upon matching transactions is helping your business in QuickBooks grow.
  4. Select Next.
  5. Click Skip and send message.

 

For now, I'm including our Customer Feedback for QuickBooks Online page to track the status of your request and get the latest updates from our developer team. Updates such as how the recent enhancement made to QBO helps our business owners, like you.

 

It'll always be my pleasure to help if you've got other questions aside from working with your bank accounts and online transactions in QuickBooks. Use the Reply button and leave your comment below so that I, @JonpriL, can assist you further. Take care always and stay safe!

KimN2
Level 2

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

I was able to match transactions with the old version. Why was this changed in 2022 version?

TGT75
Level 2

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

The solution doesn't address my ongoing problem-----I've downloaded the bank transactions and now have to march unrecognized payees.  Numerous payees aren't recognized because banks have codings, etc, after the payee name,  This should not matter.  QuickBooks should be programmed to pick up the first few letters of the transactions name and recognize it which I try to add multiple.  As a result my bookkeeping takes 4x's as long as it shpould.

Jovychris_A
Moderator

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Your idea is important to us, @TGT75.

 

Having the system pick up the first few letters is a beneficial way bank feed transactions can easily recognize the payee automatically. While this QuickBooks built-in functionality to familiarize transactions efficiently is unavailable, I suggest sending feedback.

 

This way, our product developers will know that this is crucial to your business. In addition, there's a chance that we can optimize your QuickBooks experience moving forward. You might want to track system feedback through this link.

 

In the meantime, you can also review this article about how to set bank feed conditions to automatically categorize transactions: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

I'm always delighted to assist you if you have other QuickBooks concerns. Keep well.

tap1001
Level 1

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

Is there a way to match a transaction that is older than 180 days?

MichelleBh
Moderator

Bank feeds are not matching transactions to accounts payables. Exactly the same amounts and dated within a couple of days. What else could it be?

I'll help you match your 180-day-old transactions in QuickBooks Online, @tap1001

 

Yes, there's a way to match 180-day-old transactions, but you can do it manually. Please know that the system is unable to recognize 180 days older transactions. Instead, you can use the Find Match option and search for a possible match for the downloaded transactions. Another option is to use the Search field to locate transactions by amount, reference number, or memo. 

 

You can follow the steps provided by RCV above or visit this article for more information: Categorize and match online bank transactions in QuickBooks.

 

Additionally, remember to reconcile your bank account. This way, the data always matches your bank and credit card statements. For complete steps, see this article: Reconcile an account in QuickBooks Online.

 

Moreover, check out these articles below on how to fix banking and reconciliation issues: 

 

 

I'll be around if you have other concerns about managing your transactions in QuickBooks. Post a reply, and I'll swing back into action. Keep safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us