Skip to main content
C
CLM-Optimist
June 4, 2021
Question

Bank Feed Matching -- Checks Recorded to Pay Recurring Bill, Deposits

  • June 4, 2021
  • 1 reply
  • 0 views

I'm working with the first month of "live" (not historical) data feeding into QBO in real time, and bank feed matching is...weird.

 

Director wrote and recorded a manual check to pay the June iteration of a recurring bill. Check was then issued, deposited and has cleared per the bank feed. Even though the check number was recorded as the method for paying the bill, and the check number is RIGHT THERE on the bank feed, it refuses to offer to let me match those as the same transaction, either automatically nor when I attempt to search for it manually in the window that opens for matching.

 

Similarly, checks recorded in QBO as received, then as part of a deposit, are now showing on the Bank Feed as having been received -- matched two of the eight-or-so checks, but refuses to do the others. 

 

Why?

What am I supposed to do with those transactions in the bank's For Review feed? If I categorize them, are they going to be counted twice? Do I exclude them? That doesn't seem to make sense. 

WHAT IS GOING ON W/THIS?!

 

Thanks...

1 reply

M
Mark_R
June 4, 2021

I've got you covered, @CLM-Optimist.

 

Let me fill you in on everything you need to know about matching bank transactions in QuickBooks Online (QBO).

 

The main reason why you can't find a match is that the bank transaction has a different amount and date from the created checks in QuickBooks. You'll want to make sure that they had the same amount and date so you can match them from your banking feeds. Here's how:

 

  1. Click Banking from the left menu.
  2. Select the appropriate bank account.
  3. In the For Review tab, select the transaction you want to match to the check you created in QuickBooks.
  4. Then, click the Find Match option.
  5. In the Match transactions window, find and select the created check.
  6. Click Save. 

 

On the other hand, you don't have to categorize and add your bank transactions once you already created them in QuickBooks. Thus, it may cause duplicate transactions and affect your balances. Matching them is the best way to do it.

 

If you need to learn more about categorizing and matching transactions in QBO, you can check out this article for more information: Categorize and match online bank transactions in QuickBooks Online.

 

Once you're set with your bank transactions, you can proceed with reconciling the account in QBO. Here's an article you can read for more guidance: Reconcile an account.

 

Keep in touch if you need more assistance matching your bank transactions. I'll be sure to get back to you.

C
CLM-OptimistAuthor
June 4, 2021

This same boilerplate response is in numerous other threads, but DOESN'T SOLVE MY PROBLEM!!

 

The date and amount are the same -- THE CHECK NUMBER IS THE SAME. But QBO isn't letting me match them as the SAME transaction despite everything being the same. Do you even read what people post all the way through?

 

This is absurd.

M
Mich_S
June 4, 2021

Hello, @CLM-Optimist.

 

We'll go ahead and sort things out by doing some basic troubleshooting steps. The stored cache can sometimes cause unusual browser behavior. 

 

Let's log in to your QuickBooks Online company using a private window. Here are the keyboard shortcuts in opening a private/incognito window:

  • Google Chrome: Ctrl + Shift + N
  • Internet Explorer: Ctrl + Shift + P
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P

Once done, you can now start matching your transactions. Here's how:

 

  1. From the left pane, select Banking.
  2. Select the tile for the account you want to review.
  3. Select the For Review tab to start your review.
  4. In the Action Column, find a downloaded transaction by clicking the Find Match option.
  5. Select Match.

If you can match the transactions completely, you'll have to clear your regular browser cache.

 

Please reply on the thread if you have additional concerns. Have a great weeked and stay safe!

Terms & ConditionsAccessibility statement