cancel
Showing results for 
Search instead for 
Did you mean: 
CLM-Optimist
Level 2

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

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...

5 Comments 5
Mark_R
Moderator

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

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.

CLM-Optimist
Level 2

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

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.

Mich_S
QuickBooks Team

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

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!

CLM-Optimist
Level 2

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

Nope -- doesn't help.

 

Let's take the example of one item (check) on a deposit.

It was received on 5/28/21 into Undeposited Funds using a Sales Receipt. It's for an odd number, so it's easy to pick out from other things and KNOW FOR SURE I'm looking at the same piece of money: $178.76.

On 6/1/21 a deposit was created *to the checking account* (I've verified that it wasn't accidentally set to some other cash/equiv account) that included that payment.

QBO shows all of that just fine. Journal report for Undeposited shows money in and money out just fine as it was received, held, then deposited.

On the bank feed that came through yesterday, it shows the mobile deposited items (so, not one bulk deposit...I can SEE the line for 178.76) dated 6/1/21, so dates absolutely the same.

It WILL NOT let me match that deposit line to the transaction already in QBO. It offers me some nonsense open invoices that are totally different dates and amounts and are unconnected in ANY WAY, but won't give me the right thing, no matter what I do.

As an experiment, I tried changing the date on the sales receipt from 5/28 to 6/1, just so that ALL date occurrences associated with the transaction were the same, but that didn't help, so I changed it back.

 

So...how do I deal with this?

MorganB
Content Leader

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

Thanks for following up after trying those troubleshooting steps, CLM-Optimist. I want to make sure you're able to successfully match your transactions in QuickBooks Online.

 

Since the steps provided by my colleagues above didn't do the trick, I recommend reaching out to a member of the QuickBooks Support Team. Agents have specialized tools, such as screen-sharing, that would be particularly helpful in this situation. Here's how to get in touch with the team:

 

1. Click the Help button in the top right corner.
2. Select Contact Us.
3. Enter Support in the field and choose Let's talk.
4. From here you can select to receive a callback at a time that's convenient for you.

 

The following linked article provides these steps if you ever need them again in the future: QuickBooks Online Support. I'll be here to help in any way that I can if you have other questions. Take care!

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

Need to get in touch?

Contact us