A

Anonymous

Solved

Banking Not Matching Transactions

Forum|Forum|8 years ago
November 14, 2017
3 replies
0 views

I am going through Banking, and there are a number of Mobile Deposits that are not matching automatically to invoices. The amounts are the same, and I have manually changed the mobile deposit info to reflect the same info as on the invoice, but for some reason they arent matching automatically. When I try the manual "find match," it says "we could not find matching QBO transactions for the date and search criteria above."

I've double and triple cheked the deposit dates, and the serach criteria dates, and they all are correct and matching. Yet, it wont match my mobile deposit to the invoice. Should I just exclude this deposit, or is there a way to match it from my Banking to my Invoice?

Best answer by AliciaRoy

Here is the Screenshot of the Payment :-)

Thanks again for sending this my way.

I'd also like to check for the following criteria that could prevent the program from matching the deposit to the payment:

Verify that the transaction has not been reconciled.
Verify the transaction was entered using the same bank account.
Make sure the Quickbooks Online transaction has not been previously matched to another bank downloaded transaction.
If it is a deposit or payment received, make sure it is not on the Bank Deposit page (undeposited).

If you're still unable to find the match, you have the option to Exclude the transactions instead of matching them. This will simply move the transactions out of the For Review tab, and won't impact your books since you've already recorded the payment.

Here's how:

Go to Banking on the left navigation panel.
Use the boxes on the left to select the deposits.
Go to Batch Actions, and choose Exclude Selected.

Please reach back out if there's anything else I can do to help.

AliciaRoy

Hi Cpattison1,

I'd love to help you get this bank deposit matched.

QuickBooks looks for various types of transactions to match bank deposits to, one being payments received against invoices, not the invoices themselves. The following article will show you the other types it looks for: https://community.intuit.com/articles/1164872. It sounds like the payments against these invoices have yet to be entered, so the program doesn't have anything to match the deposits to. You can either create the payments manually and then match the deposits to those payments, or you can create the payments manually and exclude the deposits.

If you have any questions along the way, I'd be happy to lend a hand.

A

Anonymous

The payents have already been entered. I entered them on the invoice after clicking "recieve payment" and used the check number as the reference number. Any way to get the system to match the deposit listed in Banking to the invoice?

AliciaRoy

I appreciate you providing these additional details.

I see in your original post that you changed the information of the deposits to match the information on the invoices. I recommend matching the information to the payments instead, since this is the type of transaction QuickBooks Online matches deposits to.

R

rrichtx77386

I have the same or similar issue... QBO automatically records deposits and applies payments to invoices. When I go to the banking screen to add/match transactions downloaded from my bank, the matching invoice doesn't show on the list. I have to delete the deposit (created by QBO), then the invoice will show up on the list to match with deposits... So it appears the solution to my issue to stop QBO from creating deposits. HELP! HOW DO I DO THIS! Any other suggestions are greatly appreciated.

R

RCV

Let's perform some troubleshooting steps to get this sorted out, rrichtx77386.

If you have QuickBooks Payments, QucikBooks Online (QBO) automatically applies payments to invoices the moment customers pay them. You'll have to create a bank deposit and choose the invoice payments under the Undeposited Funds account. For more details about this one, see the Record and make bank deposits in QuickBooks Online article.

If you don't have the QuickBooks Payments feature, we can check if you created a bank rule. This may be the reason why QBO automatically records deposits. Just refer to the Setup bank rules to categorize online banking transactions in the QuickBooks Online article to learn more about this one. Then, check if the Automatically apply credits option is turned on where it automatically applies payments to invoices. Here's how:

Click the Gear icon on the top menu.
Choose Account and settings.
Tick the Advanced tab.
Tap Automation.
See if the Automatically apply credits option is turn on. You can turn it off if you’re a property manager that requires security deposits.
Hit Save.
Press Done.

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. Take care always.

R

rrichtx77386

I did that. Doesn't fix the issue.

M

mariahlily

This is driving me absolutely insane as well. I am going to review the comments here and see what I can figure out tomorrow. I have spent DAYS on the phone with support and nobody is able to help me figure out why o can’t match transaction. I even just got an email back about my case that there was nothing they could figure out. I even had one support person witness the issue occur when he asked me to unmatch one of the only ones in was able to get and then we were unable to get it back. All of my cash and cash app items are displaying to match my deposits but not any of my card payment deposits and there is nothing different about the way they are set up. My payroll checks that were run though QuickBooks with the check numbers recorded are even not showing up for me to match.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded