"Banking" Make Deposits

Hi Grace,

I appreciate you reaching out to the Community. I'll assist you with your Deposits. 

To remove those old payments, you'd need to search for them using the magnifying glass at the top right of your account. You can search for those payment transaction by date, name or amount. Once you've located the transactions, make sure to delete them from the account. You shouldn't see those old payments the next time you click on Make Deposits. If you get stuck along the way, don't hesitate to reach out and I'll assist you. Let me know if I'm missing something. 

Thank you for your quick response.

In what account do I find this Magnifying glass.

Bank account?

Drop down window of making deposits?

I have 2019 version

Lew

No worries. I want to make sure I'm on the same page as you. Could you send me a screenshot of the page where you're seeing the old Payments? Feel free to close off any sensitive info. I'll be here. 

Here you go.

These deposits were entered by not using "Making Deposits"

If I select them they appear in check register and Bank Rec a second time. When I try to delete they go back to this file.

Thanks

lew

What happens when you click on the payment and try to delete the payment? 

The is no magnifying glass in QB Desktop.

That being said, there is no easy way to delete duplicate deposits.If there are only a few and are all in the current fiscal year you can:

1) find the original deposit in your Bank Account (hopefully the amount was not included in a lumpsum deposit). With the deposit open on your screen, select the Payments tab at the top of the window. Select the payment from the list that opens and add it to the Deposit. Now, Delete the line for the same amount. If the original deposit was a lumpsum, reduce the line by the amount you are now depositing.This does not change the deposit amount, but will appear on the Bank Rec (I think) - go ahead and clear it.

If there are too many deposits and they are very old, I would create a Bank type account in the COA called deposits clearing (or something that makes sense to you) and Deposit all the old, previously deposited funds to this account. At yearend, let your accountant know what it is and ask him for the correct JE to clear it.

When I do what you suggest it does not remove from the sheet I sent you.

So I still have all these deposits that were recorded at the time manually and can't remove from the deposit screen.

Thanks

Hi:

Tried both ideas and neither works.

I have determined that the offset to these deposits that have already been recorded into the check register and customers account is Undeposited Account.

In order to remove from this account it transfer to check register. So now I have duplicate deposits in check register.

This is my dilemma.

Thanks

Hi @GraceKWElls ,

I'm not sure if you're trying to delete these deposits while you are in your reconciliation window, but that's what it looks like from your screen shot.  You can do it from there by double clicking on the 'wrong' deposit' which opens the 'make deposit' window.  Delete the deposit (Ctrl-D).  Repeat for all offending deposits that you want to get rid of.

Then with a blank open deposit window, click on 'Payments' at the top of the window.  All of the payments you have received through the Customer Payment window will be there in a list.  Deposit them all separately, to match the original deposits, or in a lump sum, whatever your preference is.

Keep in mind that if this exercise spans deposits going back a ways, then all your reconciliations will be royally screwed up.  You can reconcile them all at once in your current reconciliation and make a note on your printed reconciliation of what took place, or you can undo all your previous reconciliations and start fresh and re-do them.  If you need screen shots, let me know and I'll post some for you.

Thank you for your response.

Currently what you see is the list of all duplicate deposits that have already been previously recorded in the check register and reconciled. These are currently residing in Undeposited Funds.

If I select them they go to the check register and then when I reconcile they are deposits that if select will cause unreconciled amounts. Now we have an Unreconciled amount. How do I remove them? It's like a dangling participle.

I hope I made myself clear.

Thanks

The list you see in the 'Payments' screen of the Make Deposit window are what you want to deposit.  Yes, they are currently sitting in Undeposited Funds as when you receive a customer payment, A/R is Credited and Undeposited Funds is Debited.  Then when you select payments to include in a deposit, Undeposited funds is Credited and the Bank is Debited.

What you want to do is go into your cheque register, and delete ALL of the deposits that were made incorrectly.  Then go back to your deposit window, and begin selecting the 'payments' you received through the 'Receive Payment' module.  If you want the deposits to match exactly what went into the bank for each original deposit, then only select the necessary payments, enter the correct date, and click 'Save & New'.  The list will continue to come up until all your payments have been deposited.  If you are not fussy about that level of detail, you could select ALL outstanding payment items in the deposit window and you will have one huge deposit.

As I mentioned before, any previous bank recs will be screwed up, but your most recent one should bring you to your current state.  If your external accounting firm is fussy about having correct reconciliations, then you would have to deposit the payments to match the original deposits on the correct dates, then undo previous reconciliations back to when this all started, and re-do the reconciliations.  If they are not fussy about past reconciliations and just want to know that you are balanced to the current period, click on all past deposits in the reconciliation to create the one huge deposit.  Either way, as long as you delete the old original deposits and replace them with the deposits from 'received payments', then your final reconciliation should balance just fine.