make deposits glitch?

Oct 01, 2008 12 Replies

hello,



i recieve many cheques, that get deposited at the bank together. when these cheques come in, I apply the cheques to be deposited later. these funds go into an account called "prepaid expenses". i know it sounds weird, but that's what it's called. when i make the deposit, i select the cheques to deposit from the deposit window, and apply it to the proper bank account. all that works great.



here's the problem:



sometimes, if i make a mistake, i have to delete the deposit, and do it again, which I do. however, on future deposits, the old cheques that were removed and redeposited still show up in the deposit window, even tho they have already been deposited. i have a long list now, dating back to 2006 of cheques that have already been deposited! it makes if very confusing, and difficult to sort out. The balance on the "prepaid expenses" account is always $0.00, so it doesn't make any sense. there are NO cheques to deposit. This only happens with deposits that I have had to correct.



i hope you understand what I am referring to, it sounds like a glitch. anyone have a solution? I have tried to deposit them again, but it makes the "prepaid expenses" account go into the negative, and makes another deposit to the bank, which shouldn't exist.



dave.



First you really should read the help file on using the Undeposited Funds account. That's what it was designed for.

Now, back to your issue. I have found that if I delete part of a deposit QB goes nuts and causes file corruption. Delete the bad deposit , make a backup file then do a file verify followed by 3 rebuilds. Hopefully this will cure the file corruption present in your file.

thanks laura,

i did the verify and rebuild process to no avail. they are still showing up in the deposit window. any other suggestions? thanks again. Dave.

First off, it sounds like your "prepaid expenses" account is actually Quickbooks' standard Undeposited Funds account renamed - I believe that's the only account that would send checks to the Payments to Deposit window.

It sounds like you may be duplicating something along the way when you delete your deposit & reenter, leaving an additional payment to undeposited funds. Exactly what is the procedure you use to do this? You said you delete the deposit - do you also delete any incorrect checks in Receive Payments or Enter Sales Receipts? Deleting the deposit does NOT delete the original payments listed on that deposit, so they would continue to show up in the Payments to Deposit window.

If you're using Enter Sales Receipts to record your checks, my guess is you're duplicating these by deleting the deposit & reentering the Sales Receipts but not deleting the original Sales Receipts.

Scott out.

Hello,

Yes, it would appear that that account has been incorrectly renamed.

In any event, in the make deposit window, if it entered the deposit in error, i hit cntrl+d to delete that deposit. the funds re-enter the undeposited funds account. then i re-enter the deposit properly. the balance in the undeposited funds account goes back to $0.00, and the payments are applied properly, the customer balances reflect properly.

however, on following deposits, the previously deleted and re-entered paymets show up again in the selection window. if i were to select them again, and re-enter the depsot, the undeposted funds account goes into the negative, and customer's enjoy additional payments not made, so i can't do this either.

it would appear all is balanced, with the exception that old previously deleted payments still show up for some reason, even tho the balance on the undeposited funds account is $0.00, as it should be.

Hmmmm.

After you delete the original incorrect deposit, when you re-enter the deposit properly do you click on the Payments button at the top of the Make Deposits window? Or do you manually type in the deposit using "prepaid expenses" / Undeposited Funds as the From Account? If so, that's the problem - by manually typing in the information instead of selecting the checks from the Payments to Deposit window, you're not linking the check payment to the deposit, just creating a generic deposit posted to "prepaid expenses" / Undeposited Funds, which would offset the check payments posted there but still leave them in the Payments to Deposit window as they were not linked to any specific deposit.

Hello,

I do select the payments button, as always. when i have new deposits to make, i see new payments, as well as the old ones previously deleted. i select the new payments to deposit, and make the deposit properly. the balance on the undeposited account becomes $0.00. If i were to go back to the payments window again, the new payments are gone, but the previously deleted and re-deposited payments still show up.

This happens any time I have deleted and re-entered a deposit, which over 5 years has only been a few times, but I recieve 20 payments per day, so in the list, there are usually up to 80 old payments there, from varying dates. very frustrating to have to ingore them each time.

It must be some sort of internal glitch. i have upgraded QB each year, and the problem continues to transfer over.

I understand using the payments button for new deposits, my question was after you used ctrl+d to delete an incorrect deposit, how did you re-enter the corrected deposit?

As a possible solution, you could make a dummy deposit selecting all the old payments. Then make a General Journal entry debiting "prepaid expenses"/Undeposited Funds and crediting the same cash account used in the dummy deposit with the same date. When you do the reconciliaton for the month these 2 entries will offset each other in the cash account.

oh, i see. i would redo the deposit the same way, but i think it would either have 2 entries for each payment, or they would simply not dissapear. I can't recall.

In either event, your solution worked. that was easy.

thank you so much!

Dave.

ok, now there is 1 entry in the make deposits window, for the total amount of the adjustment journey entry now tho. can i get rid of that somehow?

Hmm, didn't think the j/e would cause that since its a negative amount. Is it showing up in the make deposits window as a positive or negative amount?

When you redid the deposit, did you also reenter the customer payment either in receive payments or enter sales receipts?

I would try to find out where the double entry is coming from by doing a Find on one of the payment amounts that was duplicated, making sure the detail level is All rather than Summary. Or do a Quickreport on one of the customers that has a duplicate payment, again setting the detail level to All. See if multiple payments show up & try to see if they're linked to any deposits - you'd probably want to delete the mass deposit you just did to unlink the duplicates.

replying to Laura, kiki wrote: IF, and only if your help file does not continuously crash when you try to use it.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required