Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
For years now Quickbooks Online has successfully matched imported banking deposit transactions to existing Received Payment transactions. Often it will match them automatically or, if not, I have been able to match them manually. (Once I learned that I Quickbooks required me to change my workflow -- to process payments before importing banking records -- I've had no problem with it.)
It is no longer working.
I have two deposit transactions for the same client/project. I processed the two payments on the two invoices and have Received Payment transactions. Quickbooks did not automatically match them.
When I try to manually match them, Quickbooks forces a search for the wrong client/project. (For some unknown reason, it is searching for the right client, but it is not searching for any project.) Of course, searching only for the client without a project, it cannot find the existing payment transactions.
There is no way I can see for me to change the search that Quickboooks is using to look for payment transactions. The search parameters it is using on the Match Transactions screen cannot be changed.
(In the Categorize window I can change the Vendor/Customer to show the correct client/project pair, but as soon as I click the Find Match radio button and go to the Match Transactions screen, my choice is lost, and it goes back to showing the client with no project.)
How do I get Quickbooks to allow me to match the banking transaction to these existing payment transactions?
Thanks for bringing this to our attention, @jeffbean.
Getting this fixed is our top priority. Rest assured, I'll route you in the right direction for support to ensure your query with your banking transactions will be taken care of.
As I've checked here on my end, we've found an ongoing investigation into this issue. I suggest contacting our Customer Care Support. They can add you to the list of affected users and notify you once we have a potential solution.
Here's how you can reach out to them:
We're researching this issue and hope to have new information for you soon.
While waiting for a fix, we can go to the Categorized tab from the Banking menu and open the created transaction after categorizing the deposit. Then, on the created Bank Deposit, edit the Project.
Also, you'll want to check out these articles for guidance. These can guide you further on how to organize your transactions and reconcile your account flawlessly:
We thank you for your patience and time in posting your concern about your QBO here in the Community. We're always here if you need anything else. Take care always.
@Carneil_C, thank you for your reply.
First, I'm not inclined to go to the time and effort to put myself on the notification list waiting for a fix. I've done that before, at least twice, and never once have I ever received a notification of any resolution. Both those times I was given an issue/ticket number as a reference to use in my request; you didn't provide one to me here. It hasn't worked before and there's less reason for me to believe it will work this time.
Second, you suggested a work-around while waiting for the fix. The problem is it doesn't work. As I made clear, the problem is matching the imported banking deposit transaction with the existing received-payment transaction I manually entered. Your method doesn't do that. All it does is enter a new banking deposit transaction. Following your directions to edit it, there is now way I can see for matching that deposit with the existing payment. Yes, I can choose the correct client/project, but that doesn't solve the problem. I still need to match the deposit to the payment transaction that I already entered. There is no way I see to do that and you haven't suggested any.
I am hopeful that you or someone here can provide a method that works for matching these deposits with their payment transactions.
Because it appears this may be a bug known to Quickbooks, I checked again to see if they might have tried to fix it. They may have tried, but if so, they just made the problem worse.
When I posted this originally, Quickbooks' Match Transactions function was searching for received payment transactions using the wrong client/project pair. So of course it didn't find the right transactions. It's still doing that.
But now that same incorrect search returns an even more incorrect result. It's wrong in two different ways. The search result returns transactions for completely different clients! But that's not all it's now doing wrong. What are the transactions to which it's trying to match the imported banking deposits? Get this -- wait for it -- two unpaid invoices!
It's searching for the wrong type of transaction, for the wrong clients. Whatever you're doing, Quickbooks, you're now breaking it more.
Now maybe in my dreams I wish I could magically turn unpaid invoices into bank deposits. But that's not what we need of our accounting systems.
We're now at month's end. I need to close my books somehow.
Anyone have a workaround jury-rig? Being cash basis, I don't tend to deal with the accrual-basis accounts, so I'm going to have to dive in on how to do a journal entry to reconcile the accounts receivable QBO uses to manage my invoice payments with my bank account.
Solution found (no thanks to Quickbooks): Quickbooks no longer matches deposits to payments, but to invoices. Do not book the payment transaction before importing the bank's deposit transaction. When the deposit transaction is imported, it should match to the invoice and then create a new payment transaction.
I learned this when a third deposit transaction was imported, one for which I had not yet processed the payment transaction. I saw that Quickbooks matched it to its invoice. I then deleted the other two payment transactions, the ones that were the subject of my original post; then Quickbooks did match the imported deposit transactions to their matching invoices and created new payment transactions for each.
This is actually preferable. It matches my workflow from three years ago, before we switched to Quickbooks.
But Quickbooks didn't provide any information that it was changing matching of deposit transactions from payments to invoices. No one from Quickbooks came here to explain that there had been a change. The one response from a Quickbooks employee said nothing about it.
This is just another one of those frustrating experiences that goes in the "find a replacement for Quickbooks" category.
100% And I don't even USE the Invoice / Payment system...
But the treatment and advice you've been given by Intuit representatives is par for the course. First, they answer a question you DIDN'T ask. Then, when you object, they tell you to hit the Gear icon and report it. Then you figure it out and post the solution. And it turns out to be that Intuit broke their software in the first place. And they never notify ANYONE that they are making changes to the way the software operates. No revision discipline, apparently no effective QC before rolling out MAJOR changes. And if it breaks, they go into full-on CYA mode. Welcome to the brave new world of Software-As-A-Service. It sounded good (to the C-Suite anyway).
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