discrepancy

[Alex Moreau]

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

 

[TObject]

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.

 

[Paul Danaher]

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

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.

 

[Alex Moreau]

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.

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

 

[Alex Moreau]

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.

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

 

[TObject]

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.

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.

 

[Alex Moreau]

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.

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

 

[Paul Danaher]

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?

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?)

 

[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?)

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

 

[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.

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