cancel
Showing results for 
Search instead for 
Did you mean: 
jeffbean
Level 5

QBO No longer matching banking transactions to received payments

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?

5 Comments 5
Carneil_C
QuickBooks Team

QBO No longer matching banking transactions to received payments

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:

 

  1. Go to Help (?), then click Search.
  2. Select Contact Us.
  3. Please enter your question and tap Continue.
  4. Choose a way to connect with a live support agent: Ask the communityHave us call you, or Chat with us.

 

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.

jeffbean
Level 5

QBO No longer matching banking transactions to received payments

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

jeffbean
Level 5

QBO No longer matching banking transactions to received payments

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.

 

jeffbean
Level 5

QBO No longer matching banking transactions to received payments

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.

Dave226
Level 3

QBO No longer matching banking transactions to received payments

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

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

Need to get in touch?

Contact us