Home Page link  

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

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Reconciliation Module Opening Balance Cannot Be Corrected /Why This Happens? JimBAgde 02-17-2008
Posted by Scott on February 21, 2008, 9:48 am
Please log in for more thread options
>
>
>
>
>
>
>
>
> > > > 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?
>
> > > 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.- Hide quoted
> > > text -
>
> > > - Show quoted text -
>
> > 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.- Hide quoted text -
>
> > - Show quoted text -
>
> 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
>
Businesshttp://www.SuccessfulQuickBooksConsulting.comhttp://www.amazon.com/Successful-QuickBooks-Consulting-Comprehensive-...-
> Hide quoted text -
>
> - Show 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.



Posted by Golden California Girls on February 21, 2008, 10:05 pm
Please log in for more thread options
JimBAgde wrote:
>>
>>
>>
>>
>>
>>>>> 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?
>>>> 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.- Hide quoted text -
>>>> - Show quoted text -
>>> 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.- Hide quoted text -
>>> - Show quoted text -
>> 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
Businesshttp://www.SuccessfulQuickBooksConsulting.comhttp://www.amazon.com/Successful-QuickBooks-Consulting-Comprehensive-...-
Hide quoted text -

>>
>> - Show 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
>
>

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.

Similar ThreadsPosted
opening balance on reconcile screen does not match balance in QB and statement January 15, 2008, 3:42 pm
Opening Balance November 3, 2008, 12:27 pm
A/P Opening Balance - QB 2008 August 4, 2008, 9:31 pm
QB 2005 Pro Very Slow Opening September 10, 2006, 9:45 pm
getting rid of file choices at opening December 27, 2006, 3:12 pm
Opening up in muliti user February 19, 2007, 10:34 pm
deleting file choices at the opening screen December 27, 2006, 3:21 pm
Reconciliation August 10, 2007, 5:12 pm
Reconciliation May 9, 2008, 10:27 am
Reconciliation problem May 31, 2007, 3:09 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap