Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 14, 2017
Solved

Why won't a downloaded bank deposit match an invoice in QuickBooks Online, and how do I fix it?

  • November 14, 2017
  • 69 replies
  • 202 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 Emma_P

    QuickBooks Online doesn't match a downloaded deposit straight to an invoice. It matches it to the payment record you've already entered against that invoice, like a Receive payment entry or a sales receipt. If you're trying to match a deposit directly to the invoice itself, that's why nothing shows up, even when the amount and date look identical.

    Step 1: Match the deposit to the payment, not the invoice

    1. Go to Bank transactions, then select the account the deposit came in on.
    2. Find the downloaded deposit and select it to expand the details.
    3. Check Suggested matches. If you've already recorded a payment against the invoice, it should show up here.
    4. If you don't see it, select Find other matches and widen the date range to be sure.

     

    If a payment hasn't been recorded against the invoice yet, record it first using Receive payment, then come back and match the deposit to that.

    Step 2: Already recorded the payment? Check these first

    If you've already used Receive payment, added the check number as the reference, and the deposit still won't match, a few common culprits get in the way:

    • The payment has already been reconciled.
    • The payment was entered under a different bank account than the one the deposit landed in.
    • The payment is still sitting in Undeposited Funds (the holding account for payments that haven't been grouped into a deposit yet) instead of being matched directly.
    • The payment has already been matched to a different downloaded transaction.
    • The deposit is more than 6 months old, or its transaction type in QuickBooks doesn't line up with the type the bank sent over.

    Step 3: If QuickBooks already created the deposit for you

    If you take payments through QuickBooks Payments, QuickBooks automatically applies the customer's payment to the invoice and creates the deposit for you the moment they pay. That means when you get to the bank feed, there's no separate invoice or payment left to match against, since it's already been posted. In that case, look for the deposit QuickBooks already recorded and match your downloaded bank transaction to that instead of hunting for the original invoice.

     

    If you're combining payments taken outside QuickBooks Payments (cash, check, and so on), put each one into Undeposited Funds first, then use the bank deposit feature to group them into a single deposit that matches your actual bank total.

     

    Step 4: Still no match? You can exclude it

    If you've confirmed the payment is recorded correctly and QuickBooks genuinely can't find a match, you don't need to force one. Select the deposit, use the batch actions menu, and choose Exclude. This moves the deposit out of the For review tab without creating a duplicate or affecting your books, since the payment's already recorded elsewhere in QuickBooks.

     

    A specific deposit still giving you trouble? Tell us what you're seeing and we'll help you track it down.

     

    Resources:

    Categorize online bank transactions in QuickBooks Online

    Match online bank transactions in QuickBooks Online

    Record and make bank deposits in QuickBooks Online

    Set up bank rules to categorize online banking transactions in QuickBooks Online

    Fix mismatched or miscategorized bank transactions

     

    69 replies

    AliciaRoy
    Level 1
    November 14, 2017

    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. 

    November 14, 2017

    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
    Level 1
    November 15, 2017

    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. 

    February 9, 2021

    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.

    QuickBooks Team
    February 10, 2021

    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:

    1. Click the Gear icon on the top menu.
    2. Choose Account and settings.
    3. Tick the Advanced tab.
    4. Tap Automation.
    5. 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.
    6. Hit Save.
    7. 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.

    March 24, 2022

    I did that.  Doesn't fix the issue.

    April 1, 2021

    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.  

    Emma_P
    Emma_PCommunity ManagerAnswer
    Community Manager
    August 20, 2026

    QuickBooks Online doesn't match a downloaded deposit straight to an invoice. It matches it to the payment record you've already entered against that invoice, like a Receive payment entry or a sales receipt. If you're trying to match a deposit directly to the invoice itself, that's why nothing shows up, even when the amount and date look identical.

    Step 1: Match the deposit to the payment, not the invoice

    1. Go to Bank transactions, then select the account the deposit came in on.
    2. Find the downloaded deposit and select it to expand the details.
    3. Check Suggested matches. If you've already recorded a payment against the invoice, it should show up here.
    4. If you don't see it, select Find other matches and widen the date range to be sure.

     

    If a payment hasn't been recorded against the invoice yet, record it first using Receive payment, then come back and match the deposit to that.

    Step 2: Already recorded the payment? Check these first

    If you've already used Receive payment, added the check number as the reference, and the deposit still won't match, a few common culprits get in the way:

    • The payment has already been reconciled.
    • The payment was entered under a different bank account than the one the deposit landed in.
    • The payment is still sitting in Undeposited Funds (the holding account for payments that haven't been grouped into a deposit yet) instead of being matched directly.
    • The payment has already been matched to a different downloaded transaction.
    • The deposit is more than 6 months old, or its transaction type in QuickBooks doesn't line up with the type the bank sent over.

    Step 3: If QuickBooks already created the deposit for you

    If you take payments through QuickBooks Payments, QuickBooks automatically applies the customer's payment to the invoice and creates the deposit for you the moment they pay. That means when you get to the bank feed, there's no separate invoice or payment left to match against, since it's already been posted. In that case, look for the deposit QuickBooks already recorded and match your downloaded bank transaction to that instead of hunting for the original invoice.

     

    If you're combining payments taken outside QuickBooks Payments (cash, check, and so on), put each one into Undeposited Funds first, then use the bank deposit feature to group them into a single deposit that matches your actual bank total.

     

    Step 4: Still no match? You can exclude it

    If you've confirmed the payment is recorded correctly and QuickBooks genuinely can't find a match, you don't need to force one. Select the deposit, use the batch actions menu, and choose Exclude. This moves the deposit out of the For review tab without creating a duplicate or affecting your books, since the payment's already recorded elsewhere in QuickBooks.

     

    A specific deposit still giving you trouble? Tell us what you're seeing and we'll help you track it down.

     

    Resources:

    Categorize online bank transactions in QuickBooks Online

    Match online bank transactions in QuickBooks Online

    Record and make bank deposits in QuickBooks Online

    Set up bank rules to categorize online banking transactions in QuickBooks Online

    Fix mismatched or miscategorized bank transactions