Skip to main content
February 5, 2024
Question

How can I clear up a Quickbooks Online-Bank payment that automatically put the invoice payment through, showing up as Deposited-Undeposited Funds?

  • February 5, 2024
  • 1 reply
  • 0 views
There are five invoices for the same amount of $275.  When three of these have been paid through the Quickbooks Online-Bank payments system, the entry is incorrectly recorded as Undeposited Funds.  When I attempt to pull up the outstanding invoice under the customer name, there is no outstanding invoice.  When I attempted to fix the undeposited funds entry for 1-16, it is now an open item, wanting me to match it to the invoice that was sent out today to another customer.  How do I get the invoices to match the correct deposited payments and the undeposited funds to be notated as a credit to Accounts Receivable?  

1 reply

February 5, 2024

Let me share some information about matching your downloaded deposit transaction, mark-theduelinga.

 

Here are the factors that may have been the reason why you're unable to match your transactions:

 

  • Hasn't been reconciled.
  • Was entered using the same bank account.
  • Wasn't matched to another downloaded transaction.

 

To resolve this, we can generate the Transactions List by Customer report to locate the invoices and their payments. Here are the steps:

 

  1. Go to the Reports menu.
  2. In the search bar, type in Transaction and select Transaction List by Customer.
  3. Choose a date range.
  4. Click Customize.
  5. Go to Filter.
  6. Put a checkmark beside Transaction Type.
  7. Select Invoice and Payment.
  8. Click Run report.

 

Then, open the invoice from the report to check the payment and the bank account used and ensure that your invoice payments are properly recorded. Also, the Deposit to the account used in the Receive Payment transaction is Undeposited Funds (UF). This is the reason why the payment is not showing when you're trying to match it. To learn more about recording invoice payments in QuickBooks Online through this article: Record invoice payments in QuickBooks Online.

 

Once done, make sure the deposit payment will go to the correct bank instead of going to the UF account. To do this, just open the Receive Payment transaction and change the Deposit to account. Then, go back to the Banking page and match the payment from there. Let me show you the steps below:

 

  1. Go to the Banking menu.
  2. In the For Review tab, locate and click the transaction to match.
  3. Click the Match radio button or hit Find other records.
  4. Select Match.
  5.  

You might find this article helpful when matching and managing your downloaded transactions: Categorize and match online bank transactions in QuickBooks Online. Now, you can start matching your deposits and payments again. You can read through this article for more detailed information: Deposit payments into the Undeposited Funds account in QuickBooks Online.

 

For your next step, you'll want to visit these links about reconciliation in QBO for reference:

 

 

Let me know if I can help you with bank feeds by leaving a comment below or posting again. I'll be here to help. You have a good one.