Search Our Blogs



Got a specific
QuickBooks question?

       Certified QuickBooks ProAdvisor

Didn't find the QuickBooks
tip you were looking for?
Email me so I can answer you directly and then write a blog about it.


Subscribe by Email

Your email:
cta-5-common-quickbooks-errors

Need some
Year End Help?

How to avoid Year End Bookkeeping Problems free eBook! Get it Today!
Read this case study and learn how end of year bookkeeping increased profits by 300%!
Got a question about Quickbooks or bookkeeping? Schedule a free call!
 

 

QuickBooks Tips Blog

Current Articles | RSS Feed RSS Feed

Video QuickBooks Tip: Editing And Deleting A QuickBooks Deposit

  
  
  

In QuickBooks you will sometimes find it necessary to edit or delete a deposit.  The steps to maintain accuracy are not difficult, but for many users it is not clear how to keep the books straight.  Watch this short QuickBooks Video tip on editing or deleting a deposit.  

Editing a QuickBooks Deposit

You can easily edit a QuickBooks deposit by finding it in the bank register, right clicking on it and selecting edit deposit.  If you recorded a deposit without using and invoice and the receive payments function then you can simply change the coding of the deposit.  In this situation you would have made a deposit and coded it appropriately, most likely to some sort of income account.  For example maybe you recorded a deposit to an income account called 'Sales' but you needed it in a more specific account such as 'Software Sales.'  To fix the coding you can simply right click on the deposit in the bank register, select edit deposit, change the coding and save the deposit.  Now you have your deposit coded correctly to where you intended. 

The Correct QuickBooks Invoicing, Payment and Deposit Procedures

When you use the invoicing function through QuickBooks it is important to follow the rest of the steps of receiving a payment or you may overstate your income.  The correct steps of QuickBooks invoicing are: create invoices/receive payments/record deposits.  One common mistake I see QuickBooks users make is to create an invoice, but then not receive a payment against that invoice through the receive payments function.  Instead they make a deposit in the bank and then record a bank deposit and code the deposit to sales, which overstates income.  Income is recorded through the invoice, so if you don't follow the correct procedures you will overstate income and pay more taxes.  

Editing an Undeposited Funds Deposit

The correct procedures of invoice, receive payment and record deposit will result in a deposit in the bank that is coded to undeposited funds.  The undeposited funds account is a confusing issue for many QuickBooks users.  If you try and change the coding from undeposited funds to an income account you will get this error message from QuickBooks:

You cannot edit payment information in a deposit transaction.  

1) Delete the payment from the deposit.  

2) Go to the original payment transaction to edit it.  

3) Redeposit the payment.

The most common way you will find yourself in this situation is if you received a customer payment against the wrong invoice or used the wrong customer.  The correct procedures are scary to unseasoned QuickBooks users because they don't understand what will happen.  Step one is to delete the deposit, which many users believe will delete the payment.  However, when you delete the deposit the entire deposit will be put back into the record deposits window.  You can now go to the customer's account that had the incorrect payment and make the necessary changes.  Then you simply go back to the record deposits window and record the deposit with the corrected changes.

When dealing with QuickBooks deposits it is important to understand how QuickBooks works or you may overstate your income.  Also, when you do find yourself with a deposit mistake (believe me it will happen) then it is important to know and understand the procedures to correct your mistake.

Follow us on Google+

Note: This blog does not claim credit for images posted on this site unless specified.  Images are copyright to their respectful owners.  If there is an image that appears on this blog that belongs to you and you do not wish for it to appear on this site please email matt@slcbookkeeping.com with a link to the image and it will be removed.

Comments

thanks for your helpful video on correcting a deposit. I had a user guide written by another author but no instructions on how to execute the software's instruction to "delete the payment from the deposit" or how to "delete the deposit"! Maddening!! 
Thanks for eliminating this frustration.
Posted @ Sunday, August 11, 2013 6:17 PM by Mack Bridges
My question is one I have not found addressed anywhere.  
 
For years I have been directly depositing to the register. I typically had 2-3 deposits a month so it worked just fine. When I entered the deposit I would assign it to an income account and when I run a P&L the deposit shows up under the income account I assigned it to and all was good.  
The nature of my biz has recently changed and I need a higher level of control over AR so I started doing it the "right" way as you describe. 
 
However, when the deposit shows up in the bank register instead of being assigned to an income account as my previous deposits were, it is still assigned to UF. Because it is not assigned to an income acct when I run a P&L it does not appear anywhere so the P&L is not accurate.  
 
When I try to change it in the make deposits window I get the error message telling to edit it on the "original transaction" (the invoice I assume??) but there is not place all all that I can find where assigning to an income account is possible  
 
I am quite baffled by this and assume there is some step or piece of information I am missing?
Posted @ Friday, October 24, 2014 2:56 AM by David Liguori
David, 
 
The income is recognized when you create the invoice based on the items on the invoice. When you create the invoice QB credits income and debits AR. When you receive the payment QB debits undeposited funds and credits AR. When you record deposits QB credits undeposited funds and debits the bank account. In the end everything is zeroed out except for income is credited and the bank account is debited which is what you want. Here is a link to a blog that has a video and explanation on undeposited funds. http://www.slcbookkeeping.com/quickbooks-tips-blog/bid/107755/Video-Blog-QuickBooks-Tip-QuickBooks-Undeposited-Funds-Explained. Let me know if that makes sense.
Posted @ Friday, October 24, 2014 10:07 AM by Matt Roberge
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

Allowed tags: <a> link, <b> bold, <i> italics