I have a client that uses the bank deposit feature.  They have it set up so that when they record a receipt, it goes to the chequing bank and then when they make the deposit, it again goes to the chequing bank.  I've explained to them that this is pointless but it's how they do it, so I grin and bear it.  The problem I've been having is with them recording a receipt in one month and then using it in a subsequent month deposit.  This results in not being able to reconcile the bank unless I go back in and change the receipt date to the month I am trying to reconcile.  We've gone over this and they have been very careful not to let this happen, until July.  

I had several July receipts that were recorded in August deposits.  I went in and edited the receipts - one would not let me change the date.   In retrospect, I should have just reconciled July and August bank together and it would have been a non-issue.   After I reversed the receipts, they all showed up in my bank deposit screen, as "to be deposited".  This made sense to me since I had reversed them all so I went ahead and re-deposited them.

Now, my reconciliation doesn't balance at all.  I have no idea what is wrong or even where to look.  When you reverse a receipt, what happens?  To my mind is should credit your bank, and debit your deposit holding account.  In this case, it should be a non-issue since the account is the same in both cases.  It almost appears my bank is short the amount of the receipts in question, x 3 (original, reversal, re-deposit???).   I have printed out the G/L for the bank and will look at it tonight but I'm hoping for some insight from someone with experience with the deposit feature as well.  I have already printed off the "Reversing a Deposit Slip" answer from the How To section, that was what I followed for reversing the receipts.

I took a backup of the clients file so I could bring it home and try different things.  I tried deleting all the receipts for the deposits in question (thinking it might remove all transactions associate with the original receipts/deposits and I could re-enter the receipts and re-deposit the money with the correct dates) but that did not help. 

I can provide screen caps of the deposit slips in question or the bank account if that would help.  I have never had a client (in 14 years) that used the bank deposit feature before and I have very little experience with it.  The inflexibility of it is maddening.   The worst realization in this saga has been that I thought I would just restore from a backup from the day before I started the reconciliation - yup, someone had turned off the automatic backup feature, no back ups.  I called the client to see if he had backups stored in a different place, he thought they were on auto also.  So, going back a month is not an option.

I am beyond frustrated - any help would be most appreciated.