Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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...
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:
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.
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.
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:
Once done, you can now start matching your transactions. Here's how:
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!
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?
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here