reconcile OOB pulling my hair out

[mgdachs]

I have made a mess for myself!!!! I just started using Quick Books in December 2011 and I am a self taught Quick Books user and it is SO apparent!! I went to reconcile our payroll bank account and my opening balance did not match my opening balance on the bank statement. So after trying to figure out why and using Quick Books help I decided to undo the last reconcilation. I did that and again it did not match, although I did reconcile it last month with no problem and it balanced. Well to make a long story short (and I am kicking myself for doing this) I unreconciled too far back and my opening balances are still not matching. (my logic for this was that I knew that I had balaced previously so I figured I would go back to where the bank balance matched Quick Books) Now it is off by $100. I am back to March (I know, stupid, stupid, stupid) I ran a reconcilation report and it displays a $100 funds transfer from Dec 14, 2011 that was deleted on July 11, 2012. I do not remember doing this and it may have been the owner that did this but he does not remember. Originally for July 2012 my opening balances were $46.10 on bank statement and $689.90 in Quick Books. With all the reconciles undone I am back to March 31 statement and Bank says $865.28 and Quick Books is $765.28. Interesting note is that before this month ALL of the reconcilations did balance. I AM SO CONFUSED.

[Joe Williams]

First make a backup! Now enter a Deposit or journal entry to the bank account for 100.00 dated March 20 and enter To correct bank account in the memo/description field. Now Reconcile and set the Statement Date to 3/31/2012 and check the new transaction and nothing else then complete reconcile. This should set the bank register to the correct reconciled balance as of March 31.
NOTE: The reconcile inserts the reconcile statement date in a non-displayed field and uses that field for the Reconcile Beginning Balance.

[mgdachs]

Hello Joe, Thank you so much for your reply. I went in and made the $100 deposit for March 20th as you said and then went to reconcile for 3/31/12 and my opening balance is still off by $100, does this mean I need to go further back.

[Deidre56]

clear the deposit you entered and your reconcile difference should now be zero and you can move on.