discrepancy

Using QB Pro 2006. Last year, I made one large deposit but entered it as 3 separate deposits. The only issue has been a $21,180.00 unmatched deposit, which I ignored for several months. A few weeks ago, I decided to "merge" the separate deposits back into a single deposit in order to get rid of the unmatched deposit.

To do so, I deleted the three separate deposits and entered a new deposit for the total amount, using the same date as the deleted deposits. All seemed fine until I tried to reconcile, when my beginning balance didn't match my statement. In fact, my beginning balance was a negative balance. The discrepancy report lists the deleted deposits.

After seeing that the problem existed, I ceased all entries. Can this be corrected by restoring the original deposit amouunts, deleting the total deposit, or will that just cause more problems?

Any advice appreciated!

Alex Moreau

Reply to
Alex Moreau
Loading thread data ...

I would just account for the difference at the next reconciliation cycle: your beginning balance will be off by the mount of the deposit, but your ending balance should be right. Next time after that your beginning balance will match.

Let me know if you find a better way.

Reply to
TObject

I've just had a whole batch of these on one bank account - I went through and manually uncleared items, then reconciled again, using "Mark All". As the only thing that had changed was the origin of the deposits, and not the amounts, the reconciliation worked fine.

Reply to
Paul Danaher

Hi TObject,

Thanks for the response. I still haven't made a decision as to how to handle this as of yet, and so have not made any changes or entries. I do have one other choice, which is to restore a back up pre-dating the change to the deposit entries, prior to which I could print out reports displaying changes made since the back up in order to "catch up" without too many headaches. But then, of course, I'd have that unmatched $21,180.00 deposit always in my face.

I have to wonder why, given that I just combined the deposits (same dollar amount, marked as cleared) there would be any discrepency at all. If I were to restore the old backup, is there a way that this could be handled that would avoid the discrepency?

Thanks, Alex Moreau

Reply to
Alex Moreau

I may try this on a copy of my file. Would the fact that the the original deposits were from about a year ago make any difference? Also, given that I could restore a back up pre-dating the change, is there a way that the change could be handled which would avoid the issues I'm experiencing now?

Thanks, Alex

Reply to
Alex Moreau

amount, marked as cleared) there would be any

Do not manually mark anything as cleared . If you did, go back and unmark; after that you'll be able to reconcile. As long as the math is correct, do not worry about the beginning balance. Once you have correct ending balance, you are back on track.

Reply to
TObject

You nailed it! Unmarking the deposit as cleared and doing a reconcile resulted in the unmarked deposit showing up in the reconcile window, where I could then mark it as cleared, which, after completing the reconcile, left me with a 0.00 difference. Thanks for saving me from what could have been much more cumbersome.

Alex Moreau

Reply to
Alex Moreau

...

I went back over two years for some of the entries - it was tedious, but that's all. If you have a backup which has ALL THE OTHER DATA and predates the last reconciliation before the items you're changing, you might be able to use the built-in function to undo the last reconciliation. (Which version are you using?)

Reply to
Paul Danaher

Hi Paul,

You were on the right track when you suggested manually unclearing transactions. When I changed the deposit, I assumed that I had to mark it as cleared, given that the original deposits had cleared. But, as TObject suggested, That was my mistake. Unmarking it allowed me to reconcile to a

0.00 difference.

Thanks again, Alex Moreau

Reply to
Alex Moreau

...

Glad you sorted it out - TObject zeroed in on the crucial point, I assumed you had more than one deposit involved.

Reply to
Paul Danaher

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.