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?
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Yes that is the problem essentially as any input or deletion (when cleared) do not change the most current reconciliation beginning balance? And it should? (There seems to be a data file corruption of some sort?)
And yes indeed I know performing a one time ending (adding deposit or payment,) adjustment to registry will also help balance the ending total; (Creative Book Keeping!)
I know also that QK's will automatically allow for the adjustment of the difference once completed.
Was hoping to nail down any possible DB corruptions and see if there might be a program to help correct any of these concerns? Thank YOu Again....Jim B @ A.g.d.e.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

If you're concerened about DB corruptions, within QB select File, Verify Data. You can also run File, Rebuild Data.
Michelle L. Long, CPA, MBA Author of: Successful QuickBooks Consulting: The Complete Guide to Starting and Growing a QuickBooks Consulting Business http://www.SuccessfulQuickBooksConsulting.com (Amazon.com product link shortened)
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

..
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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Business(Amazon.com product link shortened)

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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
JimBAgde wrote:

Business(Amazon.com product link shortened)-...- Hide 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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.