cancel
Showing results for 
Search instead for 
Did you mean: 
Operations_Monkey
Level 3

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

I'm here to see if anyone else is having this problem.

 

We started receiving duplicate payments in our system, with the extra payment going to "Quickbooks Customer." This started on 7/5/2023, and was caught at the end of July when my accountant was reconciling the bank account. Some of the payments made it into the deposit and numbers were off. Additionally, payments were missing because, on the same date, Quickbooks created a new account, "*Undeposited Funds" (with an asterisk at the beginning to avoid a duplicate name). Nothing in our process was changed on that day, but Quickbooks explains in another Intuit created post that it can create this account on its own and it is not able to be merged. I'm apparently not allowed to link to that here.

 

The Quickbooks Customer payments are from CC payments only, exclusively ones used in store. The transactions going into the new *Undeposited Funds account include checks, wire, and credit cards run on site, but NOT the e-invoices or anything coming through our e-commerce store.

 

So far we have done the following:

 

-Confirmed that the payments were duplicates and deleted those (which required deleting the automatically created deposits prior to deleting the payments). Some of those have come back. None of them were actually charged twice (Only in Merchant Services and our bank account once per transaction), but the payment with the same last 4 digits of a CC for the same amount on the same date is showing up in the Quickbooks Customer account, making it appear as though we owe money to a made up customer.

 

-Turned off automatic matching in Merchant Services. Additional payments have been posted to Quickbooks Customer since then.

 

-Changed the company settings in single user mode: We tried unchecking the box in Preferences-Payments to use Undeposited Funds as the default account, saving, and then rechecking it. Payments have still been posting to the newly created undeposited funds account since then.

 

-Deposited everything from *Undeposited Funds and then making the account inactive. Transactions continued to post to the account even when it was inactive.

 

The only solution tech support has been able to offer thus far is to manually delete the extra payments (which we have been doing, but they re-appear) and to manually move the transactions to the correct account so that we can record deposits. No one has presented any solutions as far as preventing this from happening, and there are dozens of transactions weekly, so this is dramatically adding to our workload each day it goes unsolved.

 

Has anyone else encountered this? Any work arounds to solve it?

 

9 Comments 9
RoseJillB
QuickBooks Team

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

I acknowledge your efforts in outlining and expressing your concerns, @Operations_Monkey. I also certainly understand the convenience of rectifying this concern to keep you from deleting the duplicate payments reflected in your QuickBooks Desktop (QBDT) Company.

 

Since the Community is a public forum, we’re unable to proceed in accessing your account to determine an appropriate resolution. Moreover, our phone support has the tools to trigger an investigation concerning the aforementioned concerns.

 

In this manner, I’d recommend contacting our Technical Support Team to double-check what causing your payments to be duplicated and the unspecified reason for creating another Undeposited Funds account. 

 

I understand that you have already contacted them to get everything sorted out. However, the best option we have here is to contact them to initiate a thorough examination of your account.

 

Here’s how:

 

  1. From your QuickBooks Desktop account, click the Help menu at the top.
  2. Click the QuickBooks Desktop Help menu and select Contact Us.
  3. Provide some information about this concern in the search box, then select Continue.
  4. Sign in to your Intuit account and tap Continue. Afterward, select Continue with my account.
  5. Please enter the code that will be sent to you via email and select Continue.
  6. From there, select how you want to connect with us. It’s either to chat with us or Have us call you.

 

Here’s an article you can check out for other ways of contacting them. Support hours and schedules are also outlined in this resource: Contact QuickBooks Desktop support.

 

I’ll be around the corner if you need an extra pair of hands in any QuickBooks-related matters. Stay safe!

Operations_Monkey
Level 3

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

Thanks, but I'm looking for community feedback as I stated in my post.

JW42
Level 1

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

Did you ever get this fixed?  Our QB desktop just started doing this after having some file corruption.

JW42
Level 1

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

Did you ever get this fixed as we have a customer that is experiencing the same thing with desktop v 2024 after some file corruption that was "fixed" by QB tools.

Operations_Monkey
Level 3

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

We've had to start using the new account as our undeposited funds account, and we had to manually move every transaction to the new account until the old one had a balance of $0 since we couldn't choose it as an option. It's not just titled "Old Undeposited Funds" and contains a history of everything that moved in and out of there prior to this issue starting.

 

It was a huge mess, but that was our only resolution. Let me know if you have further issues that need resolution. It's all a nightmare in the past at this point, but I may be able to help you fix some of the other details that are related to this if you are more specific.

 

On another note, we're moving to Odoo instead of Quickbooks. The program has had several major failures since this happened and we're over it. It's taking way too much time away from our business being non-functional during business hours while someone (usually me) works with quickbooks support trying to solve the issues in single user mode and everyone else has to awkwardly explain to every customer that we aren't a functional business for an unknown length of time while we try to fix everything. Hopefully Odoo solves some of that, and some other limitations we're running into in Quickbooks. It looks to be very promising, so fingers crossed it's smooth sailing after the pain of the transition!

KimberlyS
QuickBooks Team

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

Hello there, JW42.

 

Let me add some troubleshooting steps to help you fix data damage within your company file.

 

QuickBooks Desktop has a built-in Rebuild Data Tool that automatically fixes company file data issues. Let me guide you on how.

 

  1. Head to the File menu, then Utilities.
  2. Select Rebuild Data and click OK on the QuickBooks Information window.
  3. Follow the onscreen steps to save a backup of your data and let the tool repair your file, which usually takes some time.
  4. Once done, click OK.
  5. Go back to the File menu, then choose Verify Data under Utilities.
  6. Allow the tool to check data issues within your file.

 

You can keep using the file if QuickBooks doesn't find any problems or rebuild your data again if there are any.

 

On the other hand, you can also repair your company file using QuickBooks File Doctor. You can refer to this article for more information: Fix data damage on your QuickBooks Desktop company file.

 

Moreover, you might want to scan this material to ensure your accounts match your real-life bank and credit card statements: Reconcile an account in QuickBooks Desktop.

 

Inform us immediately if you have additional questions on dealing with data damage or other related concerns in QuickBooks Desktop. We'll be around to offer further assistance.

Operations_Monkey
Level 3

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

Note that rebuilding the file won't solve the issue and is completely unrelated to the problem. It's a known issue and there is no solution.

 

When I finally got to a useful person in tech support, they didn't attempt to have me rebuild the file because, and I quote, "What would you that do? This has nothing to do with a corrupt company file."

 

Using the new Undeposited Funds account is the only way to move forward once the program makes this decision for you. The sooner you make it your default account and get your old account back to $0, the sooner you can just do business as usual, albeit with a randomly created new account.

JW42
Level 1

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

Thank you Operations_Monkey - yeah - we did the rebuild several times - no joy there.  The duplicate undeposited funds account still exists and seems to be the new home for SOME newly received checks and credit card income.  I do believe that the file corruption and subsequent repair caused the new account to appear as maybe QB deemed the old Undeposited Funds "invalid" or non-existent which caused QB to create a new account.

There is an option under Edit>Preferences>Payments>Company Preferences to NOT use Undeposited Funds as the default account.

Operations_Monkey
Level 3

Quickbooks Customer duplicate payments and *Undeposited Funds extra account

We attempted to NOT use the new account, but to no avail. Definitely switch the newly created one to be your default account, since you can't move anything back to the old account, but you CAN move everything that hasn't already cleared to your new account. It's the only solution they could offer me, and it's definitely what I would advise so you can just put this mess behind you and move forward. The struggle is real. Sorry you're dealing with this, and I hope your week gets better from here!

Need to get in touch?

Contact us