1. Home
  2. QuickBooks Discussions
  3. Reconciliation Module Opening Balance Cannot Be Corrected /Why This Happens?

Reconciliation Module Opening Balance Cannot Be Corrected /Why This Happens?

Hello,

We are using QuickBooks 2007 Premiere with about six (6) account registers within file DB .

We are having is an issue where when we open up the Reconciliation Module for one specific Register, the Opening Balance though it was previously Balanced, is now reflecting an Incorrect Opening Balance, apparently as a result of a unknown deletion of a Cleared Deposit.

The main problem here is when the deletion is put back with the correct amount and then re-cleared, the opening balance does not update to reflect correct balance.

Look Forward To Hearing Any Thoughts On This.....Thank You JimB

PS--> Does any one know of any good (do it yourself,) corruption correction programs just in case I do have this possibility?

--> And why this might happen?

Reply to
JimBAgde
Loading thread data ...

Deleting a transaction & reentering it will cause it to show up on the current reconciliation (even if you mark it as cleared in the register). If you want to have a clean current recon, enter the prior period's ending date & bank balance, clear the one transaction & reconcile.

Reply to
Scott

Business

formatting link
> Hide quoted text ->

Yes Hi Michelle, Thank You!

Had "Verified" / "Rebuilt" and have the same results. Should not the Opening Reconciliation Balance change when a deposit or payment is cleared or un-cleared? What exactly (if you might know,) would cause this?

Jim B

As I've already stated, once you delete it, it will ALWAYS show up on the next reconciliation when re-entered, EVEN if you mark it as CLEARED in the register first. The opening recon balance will reflect the balance for all previously cleared items, but not for any items marked cleared AFTER the recon was run. You must re-enter the prior closing date & balance, clear the re-entered deposit or check, then reconcile. This will give you the correct opening balance.

The opening recon balance is adjusted when you delete a transaction. In older versions of QB you could do as you did & the next recon would calculate the opening balance including the re-entered transaction. Newer versions of QB force you to account for ALL transactions entered after the prior recon including the re-entry as QB can't tell the entry you did was exactly like one you deleted.

Reply to
Scott

Business

formatting link
quoted text -

There is a button "find discrepancy" That is where it is hiding. You will have to re-reconcile it to remove it from a discrepancy and make it cleared.

What happens is when it was deleted QB also changed the closing balance of the last reconcile. That is what comes up as the opening balance. Putting a transaction in and marking it cleared won't change the closing balance, nor should it.

You have two choices. Get out the previous months statement and reconcile it again. OR If you know what single transaction it was, just reconcile the current month and the single transaction.

Reply to
Golden California Girls

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.