cancel
Showing results for 
Search instead for 
Did you mean: 
Emily M
QuickBooks Team

Undeposited Funds account

Thank you for reaching back out, @pccsing.

 

I want to ensure you get the support you need with the undeposited funds. You’ll need to check the bank register to see if you have the transactions already in there that are also still showing in the Undeposited Funds. If you find matches, then you’ll need to check and see if you linked the deposit in the bank account to the ones that are still in Undeposited Funds. If you didn’t, you’ll need to create the link between them so it will move the money. This can be done with the steps posted above by @JamesDuanT.

 

Then you’d want to make one bank deposit and select all 25 of the payments still in Undeposited Funds so you’ll be able to have only one deposit to move the money from that account over to the bank.

 

If you have any other questions or concerns, don’t hesitate to let me know.

pccsing
Level 3

Undeposited Funds account

Thank you for responding. Would it be possible for me to call someone briefly about this for final clarification?
Many thanks.

 

On a completely different note, is there a way I can return a bad magstripe card reader?

Michelle_b
QuickBooks Team

Undeposited Funds account

You're always welcome, @pccsing.

 

You can use our Callback feature to reach our Customer Care Team. Let me guide you how:

 

  1. Click the Help (?), select Contact Us.
  2. Write your concern in the Description field then hit Let's talk.
  3. Choose either Start messaging or Get a Callback.
  4. Complete the information needed and tap Confirm my call or Send a message

 

 

Check out our support hours and contact us at a time convenient to you: Support hours and types.

 

In regards to the magstripe card reader, I suggest contacting the support team. They have the power to tell you if you can return card reader. 

 

Let me know if you have other concerns in your account. I'm glad to help. Take good care!

malikden
Level 2

Undeposited Funds account

Hi, did you find a solution to this? I have been trying to get to the bottom of this but no one can give me a clear answer on how to zero out the undeposited funds account. I  am using QB online payments to generate Sales Receipts and invoices. I use the Match feature once the money clears the bank.  My bank name is selected as the deposit entity when I save but the entry still remains in Undeposited Account. Match feature also greys out the drop-down to change the account in the Register because its a "System recorded Deposit"that its a so no manual way to force it either. 

Mark_R
Moderator

Undeposited Funds account

Hello there, @malikden.

 

You'll want to create a bank deposit to offset the Undeposited Funds account's balance as zero. Let me guide you through the steps.

 

As mentioned by my colleague JonpriL, the Undeposited Funds account holds invoice payments and sales receipts. Also, the generated sales receipts and invoices from Online Payments will be associated to the Undeposited Funds account.

 

Here's how:

 

  1. In your QuickBooks Online, click the + New button, then select Bank deposit.1.PNG
  2. Select the appropriate bank account in the Account drop-down.
  3. In the Select the payments included in this deposit section. put a checkmark to the payments.
  4. Click Save and close.2.PNG

Here are some articles you can read for more details: 
 

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

Keep in touch if you need further assistance with this, or if there's anything else I can do for you. I've got your back. Have a good day.

kirkesonoma
Level 1

Undeposited Funds account

in QBO I can see the items that are undeposited by opening the balance sheet and clicking undeposited funds.

In the chart of account report of Undeposited Funds I can see the Payments and the Deposits that offset them but there is no check mark in the CLR column. If I use the report filter to select on the uncleared items- all records show because none of them are cleared.

Should the matching payments and deposits show cleared (I would think so?) Shouldn't I able to run the report from chart of accounts using the filter not-cleared and see the Payments that do not show as deposited?

 

Thanks

AlexV
QuickBooks Team

Undeposited Funds account

Let me explain how the report works, kirkesonoma.

 

The reports will show all transactions from the Undeposited Funds regardless if it's cleared or not. Though, there's a different way to review and check the uncleared/undeposited transactions. We can export them into an Excel file and filter it from there.

  1. Go to your Chart of Accounts. Locate the Undeposited Funds and click View register.
  2. Set the correct reporting date by clicking the funnel icon.
  3. Make sure that the status column is there. If not, click on the small gear icon and check the Reconcile and Banking Status box.
  4. Click the Export icon. Open the downloaded Excel file.UF.PNG

On the file, all transactions that has no data on the Reconciliation Status column means it's uncleared.

 

Comment again if you need more help. I'm always here to assist you.

REW1
Level 1

Undeposited Funds account

My issue is I just picked up a new client which hadn't reconciled their books ever. So, I had to artificially enter a starting balance other than zero and reconcile from a date they selected to save them money. The issue is with the undeposited funds account, because there are literally hundreds of unmatched payments which have not been moved to the bank deposit function. Since I am only looking for a few more months of payments to match to the bank deposits, is there a way I can search for a time period and create a list in QuickBooks for the undeposited funds? It will take too long to read through 500  undeposited fund accounts for every month I have to reconcile. Need a short cut.

IamjuViel
QuickBooks Team

Undeposited Funds account

Hello, @REW1.

 

You can generate a report for the payments you've receive that weren't deposited  yet into your bank account.

 

Here's how:

  1. Go to the Accounting menu.
  2. Choose the Chart of Accounts tab.
  3. Look for the Undeposited Funds account.
  4. From the Actions column, click the View Register drop-down. 
  5. Select Run Report. 

You have the option to customize this report to show only the list of Undeposited Funds for a certain date range and only the uncleared ones.

 

Let us know if you have other questions. I'm always here to help.

Alyssa08
Level 1

Undeposited Funds account

I already reconciled the whole year...but some transactions are from undeposited funds. Can a make a lump deposit into checking to make it accurate? Or do u have to re reconcile everything and make the deposit first?

MarsStephanieL
QuickBooks Team

Undeposited Funds account

I'm here to help share information so you'll be able to track/handle your transactions correctly, Alyssa08.

 

You can lump sum the deposit and then reconcile it in QuickBooks Online. Also, If the payments are showing as a lump sum on your bank, you need to record the same way in QuickBooks so that it will be easier to reconcile.

 

Here's how:

 

  1. Go to the Hamburger icon and click the + New button in the upper-left corner.
  2. Below the Other column, select Bank deposit.
  3. Under Select the payments included in this deposit, put a check mark on the payments. 
  4. Hit Save and close.

 

However, it would be best to consult your accountant for the category or account to use.

 

To know more about how QuickBooks handles deposits, you can check out: Record and make Bank Deposits in QuickBooks Online.

 

Also, I can see this will be handy for future use in reconciling.

 

Please let me know if there is anything else I can do to help by clicking the Reply button below. Take care.

Thomastd
Level 1

Undeposited Funds account

idk what QB software team doing, you guy cant even do a simple task to clear off the transaction under undeposited fund once it is matched up with a deposit under bank feed. i speak it out for many many accountants. If there is another choice beside QB, i will recommend my clients to change. Too many craps in QB.

Tom Jurasinski
Level 1

Undeposited Funds account

I want to zero out my undeposited account. In my Chart of accounts in the undeposited funds account it shows a balance of $3847.23. But my deposit account is empty.

Charies_M
Moderator

Undeposited Funds account

Good to see your post today, Tom Jurasinski.

 

There may be some adjustments made causing a balance in your undeposited account and leaving your deposit account empty. To sort this out, you'll want to review the transactions under the Undeposited account and to see the details of the amount.

 

To do that:

 

  1. Go to Accounting and choose Chart of Accounts.
  2. Select the Undeposited Funds account and click View register.
  3. Review the transactions from there.

If you're not sure how to handle the transactions that are causing the balance, you can consult your accountant for more expert tips regarding the matter. You can also find an on here: Find an accountant.

 

You might want to visit this article for more information about Undeposited Funds in QBO: What’s the Undeposited Funds account?

 

All you need to know about managing Chart of Accounts in QuickBooks can be found in this article: Learn about the chart of accounts in QuickBooks

 

If there's anything I can help you with, feel free to drop me a reply below. Hope you have a good one.

Dismukes
Level 1

Undeposited Funds account

Yep, it’s a QBO problem that show up in 2020 for us.  Never changed the way we process things but now have huge undeposited funds balances on the cash basis income and balance sheets, but not on the accural basis reports.

AlcaeusF
Moderator

Undeposited Funds account

Hello @Dismukes,

 

Welcome to the Community. Let me help you figure out why there's a large difference in the balance when on a cash basis.

 

The Undeposited Funds (UF) account balance will only show if payments aren't deposited yet. I recommend you run your cash basis income and balance sheet report again, then take note of the transactions showing under UF.

 

Try to compare them with the data showing when in accrual. It may be possible that the payments aren't linked. Also, please consider checking the dates to ensure they match.

 

For additional reference, you can use the following articles to learn how to find missing payments, as well as creating a report for UF:

 

 

Drop me a comment below if you have any other questions regarding the balances in QuickBooks. I'll be happy to help you some more.

doorstoreellen
Level 1

Undeposited Funds account

I too have this same problem with undeposited items staying in the bank deposit screen. How do I clear them out? I have called the phone center multiple times but they are ignorant even with what would seem a simple question or procedure. I have been more successful in answers from the community rather than the phone center. Any solution to being able to talk to smarter people in the phone center. Im continually disappointed in them.   Ellen

IamjuViel
QuickBooks Team

Undeposited Funds account

This is not the service we want you to experience, @ellen.

 

Let me walk you through in clearing out the balance in your Undeposited Funds account.

 

First, let's generate a report to see the transactions that weren't deposited yet into your bank account. Here's how:

  1. Go to the Accounting menu.
  2. Choose the Chart of Accounts tab.
  3. Look for the Undeposited Funds account.
  4. From the Actions column, click the View Register drop-down. 
  5. Select Run Report. 

You have the option to customize this report to show only the list of Undeposited Funds for a certain date range and only the uncleared ones.

 

Once completed, you can now create a bank deposit to post the payments to the correct bank register. Here's how:

 

  1. Go to the + New icon.
  2. Select Bank deposit.1.PNG
  3. Choose the appropriate bank account in the Account drop-down.
  4. In the Select the payments included in this deposit section, mark the payments you want to deposit together.
  5. Click Save and close.2.PNG

On the other hand, you can open each transactions recorded in the Undeposited Funds. Then, change the account from the Deposit To field. This removes the transaction that shows up in the bank deposit section.

When you go back to the Bank Deposit page, you will no longer see the payment. You can read through these articles to learn more about the process:

Keep in touch with us here if there's anything else I can do to help you succeed with QuickBooks Online. I've got your back!

JWLeeFinancial
Level 1

Undeposited Funds account

This is happening in the desktop version as well. I have contact support but was told they have never seen this issue before and had no solution.

I have selected batch items to be deposited from undeposited funds. Those deposits have been reconciled. Now in March of 2021, I have May 2020 and August 2020 showing back up in my undeposited funds and the deposits are no longer posted in my bank register. All as if it was never batch deposited. 

Jovychris_A
Moderator

Undeposited Funds account

Hello there, @JWLeeFinancial.

 

The other way to check it is to confirm if you're using the correct file. It may be a different file that's why we see it still on the Undeposited Funds when you've already deposited it in the bank account's register.

 

You can go to the File menu and then select Close Company to choose the right company file on the No Company Open window.

 

You can also utilize the verify and rebuild tool to fix unexpected behavior in your company file's bank register. It can help you see the errors in the system and rebuilding it will self-resolve errors.

 

When you have reviewed and ensure that you're using the exact file, it would be best reporting this to our Care Support team. From there, they can create a case and submit a ticket to our Product Development team. They will be the ones to investigate this hurdle and look for the reasons behind this and send you notifications via email once they resolve the issue.

 

Feel free to tag me in this thread if you have other questions about managing QuickBooks banking records. I'll be there to help anytime. Take care and have a nice day!

Teresa59
Level 1

Undeposited Funds account

How do you clear out negative balances in the undeposited funds on desktop QuickBooks that so it does not affect your banking register

CharleneMaeF
QuickBooks Team

Undeposited Funds account

I'll gladly show you the way to clear the negative balance in the Undeposited Funds account, Teresa59.

 

QuickBooks Desktop automatically holds the payment in the Undeposited Funds account. To clear the negative amount, let's create a journal entry. Then, we'll have to make deposits to zero out the balance.

 

Here's how to create a journal entry:

 

  1. Go to the Company menu and select Make General Journal Entries.
  2. Fill out the fields to create your journal entry. Make sure your debits equal your credits when you’re done.
  3. Select Save or Save & Close.

For more details, please this article: Create a Journal Entry in QuickBooks Desktop.

 

Once done, we can now deposit the payment.

  1. Go to the Banking menu and then select Make Deposits.
  2. Select the payment in the Payments to Deposit window.
  3. Choose the bank where you want to deposit the funds.
  4. Click Save and Close.

 

Additionally, I've added these articles that'll help you learn more about how the Undeposited Funds account works in QuickBooks:

 

 

I'm only a few clicks away if you need assistance with your other QuickBooks tasks, Teresa59. It's always my pleasure to help you out again.

plapp431-
Level 1

Undeposited Funds account

Why when you make a journal entry for the negative amounts in undeposited fund, it impacts the bank register and takes the negative amount away from balance register?

MirriamM
Moderator

Undeposited Funds account

Good to see you in this thread, @plapp431-.

 

If the bank register is part of the Journal entry created, then it'll be affected. To ensure it will not be impacted, you'll need to use a different account from the bank register when correcting the Undeposited funds account. 

 

You may consider reaching out to your accountant for further assistance. If you don't have an accountant yet, you can have one. You can find an accountant near your place through this link: https://quickbooks.intuit.com/find-an-accountant/.

 

If you have further questions about QuickBooks, feel free to reach out to me again. I'll be here to help you out. Have a great day.

plapp431-
Level 1

Undeposited Funds account

So now that account shows negative, how do I fix that?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us