Skip to main content
E
elingbookkeeping
March 9, 2022
Solved

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?

  • March 9, 2022
  • 2 replies
  • 0 views
Original commenter did not share additional details
Best answer by MirriamM

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.

2 replies

C
ChristieAnn 11
March 10, 2022

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.

E
elingbookkeepingAuthor
March 10, 2022

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

    M
    MirriamMAnswer
    March 10, 2022

    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.

    K
    KimN2
    May 27, 2022

    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.

      R
      ReymondO
      May 27, 2022

      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.

      Terms & ConditionsAccessibility statement