cancel
Showing results for 
Search instead for 
Did you mean: 
kathy5
Level 1

How to correct undeposited funds?

I have reconciled my bank account through December 2016.  I show a balance in undeposited funds amount for September - December. How do I fix this since I have reconciled?

Solved
Best answer October 15, 2018

Best Answers
lyndaartesani
Level 6

How to correct undeposited funds?

Go to plus sign>bank deposit. You have a customer payment entered to that acct. but not deposited.  You need to find the deposit (it is in there already somehow because you reconciled already) and update the deposit with the customer payment and remove the line item that is in there and was reconciled.

View solution in original post

32 Comments 32
lyndaartesani
Level 6

How to correct undeposited funds?

Go to plus sign>bank deposit. You have a customer payment entered to that acct. but not deposited.  You need to find the deposit (it is in there already somehow because you reconciled already) and update the deposit with the customer payment and remove the line item that is in there and was reconciled.
Malama
Level 1

How to correct undeposited funds?

For majority of my clients, I personally process (ACH) payments once a month.

I have processed a payment through online bookkeeping account and cleared the invoice.

A week later funds was transferred to my bank account as a batch (multiple invoice payments),  some invoices in my bookkeeping account reflected as "Deposited" as should be and some did not, It is showing as "Undeposited". How do I change Undeposit to Deposit. 

 

Note: I did receive the correct amount of payment per client, the total payment amount as a batch was deposited to the bank, I was able to reconcile the month in my QB. 

 

I have tried several methods mentioned here on your site to trouble shoot the situation. Unfortunately, I was not able to successfully make the proper changes.  Perhaps there is another method to resolve this issue? 

 

Mona

Kristine Mae
Moderator

How to correct undeposited funds?

It seems like there are double tracking of payments, Mona.

 

If you've created a payment for the invoice already, you'll have to match the deposit to the payment instead of adding it.

 

Here's how:

  1. Click Banking, then choose Banking.
  2. Go to the For Review tab.
  3. Choose the downloaded transaction/deposit, then click to open.
  4. Choose Find match.
  5. Choose the payment, then click Save.

I've got you an article for future reference: How to add and match downloaded banking transactions.

 

You can always get back to this thread if you need more help. Have a great one! 

Rohit
Level 2

How to correct undeposited funds?

Hello, Thank you for such a great guidance. It was very helpful for me as well. Apart from that I have a question, my accountant have messed up something like we have received payments in my check bank account through QuickBooks payment or by cash in my bank account but yet there are lots payments showing in undeposited fund. So could you please guide a little bit how I can clean up my undeposited balances? Other things are that some payments of undeposited fund is real means the payments are not added yet in my check bank account so should I add them in the bank. Overall I just wanted to know what would be procedure to clean up undeposited fund. Thanks in advance Regards Rohit
HoneyLynn_G
QuickBooks Team

How to correct undeposited funds?

I can help you clear the amounts on the undeposited funds in QBO, @Rohit.

 

Undeposited Funds is created to hold funds until you are ready to deposit them. It serves as the default Deposit To account when you receive payments, use a payment item on an invoice, or enter a sales receipt.

 

To clear the amounts, you have to create a deposit transaction:

  1. On the top menu, click the Create (Plus) icon and choose Bank Deposit.
  2. Select the correct account, date, Currency, transactions and more.
  3. Click Save and close.

To learn more about this, you can refer to this article: Record and Manage Bank Deposits in QuickBooks Online.

 

You can also refer to this link for future reference: https://quickbooks.intuit.com/learn-support/en-us/undeposited-funds/understand-how-the-undeposited-f....

Let me know if there's anything else you need or you have follow-up concerns. I'm still here to help you more.

Rohit
Level 2

How to correct undeposited funds?

Dear HoneyLynn_G

Thank you for your prompt reply.

It was very useful information for me and I understood. Is there any other way to clean up undeposited fund apart from?

Thanks

Rohit

 

HoneyLynn_G
QuickBooks Team

How to correct undeposited funds?

It's nice to hear back from you, @Rohit.

 

You are very much welcome with the steps. I'm happy I came across your post and was able to address your concern. 

 

As a confirmation, the only way to clear the undeposited fund is by depositing the amounts to your desired accounts. Meanwhile, I'm adding some more references about QBO. It provides the current updates and tutorials.

Should you have any other questions that I can help you with, feel free to mention me on your posts. It's my pleasure to help you get back on your working track anytime. Cheering you a great weekend!

dgarcia611
Level 1

How to correct undeposited funds?

I accidentally clicked add instead of match.  How can I fix this?

dgarcia611
Level 1

How to correct undeposited funds?

I already clicked add instead of match.  How can I fix this?

JonpriL
Moderator

How to correct undeposited funds?

Hi there, @dgarcia611!

 

You can undo your transactions accidentally added into your register so you can match them to your existing transactions instead. I'm here to help you accomplish this.

  1. Go to Banking.
  2. Under Bank and Credit Cards, select you bank or credit card account.
  3. Select the Reviewed tab.
  4. Find your transactions accidentally added into your register.
  5. On the ACTION column, select Undo.

Once completed, you can go back to the For Review tab and match your transactions to your existing records from there.

 

Lastly, I've also added this helpful article in case you want to review your transactions after matching them: Find, Review, and Edit Transactions in your Account Register.

 

If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.

joslinjoice
Level 1

How to correct undeposited funds?

Hi, I receive all payments directly in bank while making the received payment it accidently went to undeposited funds how can I clear that?

GlinetteC
Moderator

How to correct undeposited funds?

Not to worry, joslinjoice. I'm here to help you clear that from your Undeposited Funds account.

 

In QuickBooks Online, the Undeposited Funds serves as a temporary account that QBO uses to hold payments received from invoice before you deposit them into your real bank account. We can create a Bank Deposit to clear the amounts. Here's how:

 

  1. Click on the + New button.
  2. Select Bank Deposit.
  3. From the Account ▼ dropdown, choose the account you want to put the money into.
  4. Put a checkmark on the boxes for each transaction.
  5. Click on Save and close.

That's it! If you have any additional concerns, please add them below. I'll be glad to help.

AJ45
Level 2

How to correct undeposited funds?

RATHER THAN HAVING TO DEPOSIT FROM UNDEPOSITED FUNDS ACCOUNT FOR EACH TRANSACTION, CAN I CHANGE THE DEFAULT SETTING SO THAT ALL INCOME TRANSACTIONS GO DIRECTLY TO MY BANK ACCOUNT IN QBO AND NOT THROUGH UF?

MaryLurleenM
Moderator

How to correct undeposited funds?

Hello there, AJ45,

 

QuickBooks offers two ways when receiving payments. You can use your bank account or the undeposited funds account.

 

The Undeposited Funds account holds everything before you record a deposit. If you're using QB Payments, we automatically process and moves transactions into your accounts. You don't need to use the Undeposited Funds account.

 

If you don't want to use the Undeposited Funds account, you can select the bank account in the Deposit to field when creating a transaction. This will directly affect your bank register. Thus, you don't need to create a bank deposit.

 

Here's an article for more information about recording bank deposits: Record and make bank deposits in QuickBooks Online.

 

Let me know if you have more questions. I'll be happy to answer them for you. 

AJ45
Level 2

How to correct undeposited funds?

Thanks,

 

I have many small transactions, so is there a way to make the bank the default in the" deposit to" box so that I do not have to edit all the transactions individually. This would save so much time and essentially wasted effort because all my income is paid directly into the bank and I do not have any real life undeposited funds.

AlexV
QuickBooks Team

How to correct undeposited funds?

Good day, AJ45!

 

I'm joining this thread so I can share more info about bank deposits.

 

QuickBooks Online doesn't have an option to set a default deposit account. However, we can turn on the pre-fill feature. This will automatically fill fields, like the Deposit to, based on the last saved transaction so you don't have to reenter it.

  1. Go to the Gear icon and select Account and settings.
  2. From the Advanced tab, select the Automation section.
  3. Toggle the Pre-fill forms with previously entered content. Click Save, then Done.

 

If you need help in reconciling your account, you might want to check this link: Reconcile an account in QuickBooks Online.

 

Don't hesitate to post again if you have other questions. We'll be here to help.

AJ45
Level 2

How to correct undeposited funds?

Thanks, that should save me a lot of work.

kd0716
Level 1

How to correct undeposited funds?

I utilize QB Payment. I show both the payment and the deposit in the undeposited funds account. I just don't know how to clear it. Everything I have found tells you to find the deposit, but mine is already there. So I am kind of lost.

JoesemM
Moderator

How to correct undeposited funds?

I’m here to help clear those transactions, @kd0716.

 

It seems that you recorded your transactions twice and manually created a bank deposit. This is why its shows both payment and deposit in the Undeposited Funds.

 

If so, you'll have to delete the manually created bank deposit. Then process deposits for the received payments that are in the Undeposited Funds to clear the transactions.

 

Here’s how to delete a deposit:

 

  1. Click on the Gear icon.
  2. Select Chart of Accounts.
  3. Choose Undeposited Funds and click View register.
  4. Under the Ref No. and Type column, select the deposit.
  5. Click Delete.
  6. Select Yes.

 

Once done, you can now make a bank deposit to clear the transactions. For further guidance, see this article: Record and make bank deposits in QuickBooks Online. You can also read this article to learn more about the Undeposited Funds (UF) account: What’s the Undeposited Funds account?

 

I'm leaving you some articles to learn more about searching and deleting a transaction in QuickBooks:

 

 

In addition, here are some articles that you can read to help manage your other bank transactions in QuickBooks Online:

 

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always, @kd0716.

kd0716
Level 1

How to correct undeposited funds?

@JoesemM   Apparently I have been doing this all year and have been reconciling each month at $0. Will doing what you indicated above affect my reconciles for each month to this point?

MadelynC
Moderator

How to correct undeposited funds?

I’ve got some information to share with you, @kd0716

 

As long as the transactions aren’t included from your reconciled ones, the instructions indicated above won’t affect your records.

 

You can contact your accountant to assist you personally. They can help ensure books are accurate.

 

If you don’t have one yet, you can visit our ProAdvisor website. Our ProAdvisors can guide you further from technical and accounting perspectives. They also have access to training materials, software tools, and dedicated support resources to ensure they can provide you with hands-on support when you need it. Just simply enter your city or ZIP code.

 

Here’s a complete reconciliation guide to help you optimize your reconciliation processes: Learn the reconcile workflow in QuickBooks. It contains troubleshooting instructions and ways to modify completed reconciliations.

 

Don’t hesitate to reach out back if you have any other concerns or questions besides clearing your transactions. We’re always here to help you out. Take care and have a good day!

dca_1
Level 1

How to correct undeposited funds?

Hello, when reconciling payments made via "Quickbooks payments" it always shows 1 match and I always have matched these transactions clicking "match". But, unfortunately I just noticed that these reconciled matches are showing in the bank register under the account of "Undeposited funds".

 

Can I use a journal entry with the total of the undeposited funds to fix this issue and correct the totals on the Balance sheet? I already reconciled multiple banking statements.

 

How can I prevent this from happening for future transactions? Why is QB showing a match but it goes to the "undeposited funds"?

 

 

QB Capture.JPG

Carneil_C
QuickBooks Team

How to correct undeposited funds?

Thanks for joining the thread, @dca_1. I'd be glad to provide information and assist you with each of the details you need concerning undeposited funds in QuickBooks Online. 

 

As provided by my colleague above, the Undeposited Funds account holds everything before you record a deposit. We process and move transactions into your accounts automatically if you are using QB Payments.

 

Yes, you can also create a Journal entry and offset the value of a negative deposit. Here’s how: 

 

  1. Select + New.
  2. Under Other, select Journal Entry.
  3. Enter the transaction date in the Journal date field.
  4. On the first line, in the Account column, select the Undeposited Funds account.
  5. In the Debit column, enter the single line deposit amount.
  6. On the second line, in the Account column, select the bank account.
  7. In the Credit column, re-enter the single line deposit amount (if it does not already appear).
  8. Select Save and close.

 

From there, you can now offset the negative value. Let me guide you on how:

 

  1. Select + New.
  2. Under Other, select Bank Deposit.
  3. Select the payment and the Journal Entry you created.
    The total should be zero.
  4. Select Save and close.

 

However, I’d also suggest consulting your accountant. They can give you the best advice on handling these transactions. 

 

To avoid the issue from happening in your future transactions, you can choose the bank account in the Deposit to field if you don't want to use the Undeposited Funds account. This will directly affect your bank register. 

 

For more details about undeposited funds in QBO, check out this guide here: Deposit payments into the Undeposited Funds account in QuickBooks Online.

Moreover, feel free to visit these helpful resources that can help you along the way in managing payments and other transactions in QBO: 

 

 

If you have any other questions about managing your bank transactions in QBO, please feel free to leave a comment below. I'll get back here as soon as I can to help you again. Thanks for dropping by, wishing you a good one!

Micki V
Level 2

How to correct undeposited funds?

qbo i do not see any undeposited funds in my books, i deleted them thinking that they were not real, since i had sales receipts and deposited those by entering that info on the sales receipts in the paypal sales and paypal bank. And now my account is massively negative, my total income is around 14,000.00 and i now negative by around 13,000.00. There are some that are still in the undeposited account. how do i fix this now. there is nothing to match or deposit. Please help me

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

Need to get in touch?

Contact us