cancel
Showing results for 
Search instead for 
Did you mean: 
daniel-busby-nwl
Level 3

Unable to Assign Bank Deposit to Correct Invoice Payment

I billed a client a unique amount through Quickbooks.  They promptly paid.  A few days later the money showed up in my bank account.  When I am trying to Assign the transaction and match it to the invoice payment, I don't see it in my list of transactions to match to.  What am I doing wrong?  Is there another way to search for the payments that I can't see?

What's frustrating about this is that the entire process is being handled by Quickbooks, from the invoicing to the collection of money from the client to the deposit into my bank account.  Yet somehow QB doesn't know where the money is coming from?  Is there a better way to do this?  This software should be making it easier to do the books, not harder.

7 Comments 7
AileneA
QuickBooks Team

Unable to Assign Bank Deposit to Correct Invoice Payment

Hello, daniel-busby-nwl. 

 

Thank you for reaching out to the Community. QuickBooks bank feeds has feature called "Find match" which you can use to locate your invoices to match with your deposit. Let me walk you through how.

 

  1. Go to Banking, then Banking at the top.
  2. Open the deposit and check the Find match radio button. It will open a Match transactions window were you can filter to Show all transactions, the Search field and From and To dates.
  3. Mark the boxes that corresponds to the deposit.
  4. Hit Save.

 

 

If you're unable to find the transaction, you'll want to Add it instead to create a transaction in QuickBooks. Please see this article for more information about: Match and categorize bank transactions in QuickBooks Online.

 

You can also check this article in case you want unmatch or move bank transactions after reviewing them

 

Let me know if you have any follow-ups or other questions. I'm always here to help. Wishing you a good one. Stay safe!

daniel-busby-nwl
Level 3

Unable to Assign Bank Deposit to Correct Invoice Payment

I tried using the Match Radio Button, as I normally do.  But, it does not list the right transaction.  It lists every other Invoice that hasn't been paid yet.  If I "Add New" transaction won't I be double counting this payment?  How do I prevent duplicate reporting of the same payment?  Is this the correct behavior of the software?


If I click on the invoice I see the Invoice and a Payment line. In the memo it says "Paid via Quickbooks Payment".  How do I link to transactions that have been "Paid via Quickbooks". 

 

The link you sent me has very confusing directions on how to Add a New Transaction.

 

The first step is: 

  1. Find a downloaded transaction with the Add option in the Action column.

 

What is the Action Column?  From where am I downloading a transaction?  What page is this step assuming I'm looking at?  Who writes your help guides?  They should be fired.

LeizylM
QuickBooks Team

Unable to Assign Bank Deposit to Correct Invoice Payment

This isn't the kind of experience we want you to experience, daniel-busby-nwl. 

 

I understand how frustrating it can be when you can't search the transactions. I want you to know that I'm here to provide some steps so you can successfully match it in QuickBooks Online. 

 

QuickBooks Online matches up transactions for you. If an invoice payment matches a downloaded income transaction, QuickBooks suggests it as payment for the invoice.

 

If you Add New it will duplicate the transactions if the payments are connected to QuickBooks Online.

 

 

In addition, here's an article you can read to learn more about managing your downloaded transactions: Download, match and categorize your bank transactions in QuickBooks Online.

 

Please don't hesitate to tag my name if you need further assistance. It would be my pleasure to help. Take care!

daniel-busby-nwl
Level 3

Unable to Assign Bank Deposit to Correct Invoice Payment

I understand that Quickbooks SHOULD match the transactions for me.  I'm trying to find out what to do if it doesn't.

 

The screenshot you have is totally different than what I see when I am looking at the Transactions For Review.

The columns I see are Date, Description, Amount, and Assign To.  There is also an unlabeled column with buttons that either say Review or Confirm.

 

Quickbooks-Transactions.png

 

Apparently I am using a different version of Quickbooks Online somehow.  This is not the first time that the Help Guides that I'm given do not work for me because I have different buttons and options.

I'm not sure how to tag your name.  But yes, I need further assistance.

MadelynC
Moderator

Unable to Assign Bank Deposit to Correct Invoice Payment

I’ll make sure this deposit will be linked successfully to the correct invoice payment, Daniel.


Since the options are totally different on your end, it would be best to contact our payments support team. They have tools like Screen Share that can verify the issue. Our representatives can also provide additional fixes to resolve it.


Here’s how:

 

  1. Go to the Help menu.
  2. Click/Type in “Talk to a human.”
  3. You can enter “Unable to assign bank deposit to correct invoice payment” in the field.
  4. Select I still need a human, then Get help from a human.
  5. Choose a way to connect with us:
    • Start a chat with a support expert.
    • Get a callback from the next available expert.


You can also use this contact information to get in touch with our payments team. It includes our business hours, so you can contact us at a time convenient to you.

This guide provides information on how to manage QuickBooks Online bank feeds: How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online. It has everything you need to know to ensure downloaded transactions are organized.


Don’t hesitate to add a comment below if you need further assistance with managing your transactions. We’re here to help. Always take care!

BAC Question
Level 1

Unable to Assign Bank Deposit to Correct Invoice Payment

Did you ever resolve this? I have the same issue. Any help would be appreciated.

Jovychris_A
Moderator

Unable to Assign Bank Deposit to Correct Invoice Payment

Allow me to share some reviews on this thread, @BAC Question.

 

Let me help you track the records in QuickBooks to match them with the payments received from your customer.

 

You want to make sure that the date (slightly related) and the transaction amount registered in QuickBooks should be the same as the bank feed entry. Please see the screenshot below:

 

On the other hand, if you recorded a sales receipt or payment, ensure that you deposited the amount into the Undeposited Funds account. This will help QuickBooks track the relevant dates and amounts easily before they get recorded in the bank register. Take a look at these screenshots for visual reference:

 

 

 

 

That said, if you have the same case with the main poster, I suggest editing the date or the transaction amount in QuickBooks to make sure this will auto-match bank feed entries.

 

To learn more about matching transactions in the For Review tabfeel free to read this article: Match and categorize transactions in QuickBooks Online.

 

I'll be adding this article as your future reference for reconciling your bank account: Reconcile an account in QuickBooks Online.

 

Let me know if you have other concerns with QuickBooks banking. I'll do my best to help you out. Keep safe!

 

Need to get in touch?

Contact us