Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 04-18-2012, 02:00 PM
Bummie Bummie is offline
Registered User
 
Join Date: Jun 2004
Posts: 11
Clearing reconcile list???

I would like to do some housekeeping and can't find any way to delete entries from the reconcile list that are years old!!

Any ideas would be welcomed!!

Thanks... Bummie
Reply With Quote
  #2  
Old 04-18-2012, 08:32 PM
qbqcca qbqcca is offline
Registered User
 
Join Date: Apr 2010
Location: Montreal, Canada
Posts: 814
If you are talking about outstanding items on your bank reconciliation which are years old, then the only way to remove them is to enter a journal entry in the current year off-setting the entry to the original g/l account which was charged.

Note:-
A part of doing a bank reconciliation is to question any uncleared item each time you preform a bank rec. And removing in a timely manner any item which should not be there.
__________________
Bookkeepers are well balanced!
Reply With Quote
  #3  
Old 04-19-2012, 01:43 AM
Reesedonald10 Reesedonald10 is offline
Registered User
 
Join Date: Feb 2012
Location: 958 Willison Street Maple Grove, MN 55369
Posts: 1
Newbie here :)

Hi i am one the newbie here

My name is Donald Reese

Hoping to hear a lot from you guys!

Thank you!
__________________
[url=http://www.printplace.com/local/charlotte-envelopes.aspx]Envelopes Printing[/url]
Professional Online Printing Company. Save on Custom Printing Services. 1-Day Turnarounds. Free samples. Business cards, brochures, postcards and catalogs available.
Reply With Quote
  #4  
Old 04-19-2012, 03:22 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,894
Question: Have the transactions cleared the bank (is the balance of the register correct)?
The answer to the question makes BIG difference on "how to clear" the transactions in reconcile.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #5  
Old 04-19-2012, 10:05 AM
Bummie Bummie is offline
Registered User
 
Join Date: Jun 2004
Posts: 11
Thanks for the replies.

Yes the entries have cleared the bank. Some of these are years old and I have just been ignoring them..... but they are starting to pile up!!!

I know the reconciliation should be done in a timely matter ..... but bookeeping is my fifth or sixth job so it kinda takes the back burner. Really I only do it when forced to.... taxes, etc!! I must try to be more diligent!!
Reply With Quote
  #6  
Old 04-19-2012, 08:47 PM
cojhl2 cojhl2 is offline
Registered User
 
Join Date: Jan 2010
Location: Colorado, SE Washington
Posts: 1,223
Quote:
Originally Posted by Bummie View Post
Thanks for the replies.

Yes the entries have cleared the bank. Some of these are years old and I have just been ignoring them..... but they are starting to pile up!!!

I know the reconciliation should be done in a timely matter ..... but bookeeping is my fifth or sixth job so it kinda takes the back burner. Really I only do it when forced to.... taxes, etc!! I must try to be more diligent!!
If these have cleared the bank, how are they on the recon list, or are you saying you have not been going thru reconcile?
__________________
Colorado Springs and Waitsburg, Washington
QB Pro 2014 used for two farms and personal
Reply With Quote
  #7  
Old 04-19-2012, 10:28 PM
Bummie Bummie is offline
Registered User
 
Join Date: Jun 2004
Posts: 11
Quote:
Originally Posted by cojhl2 View Post
If these have cleared the bank, how are they on the recon list, or are you saying you have not been going thru reconcile?
Yes you are correct. Some I used reconcile.... some I did not. But they have all cleared the bank and I would like to get them off my list. Some are 6 or 7 years old. I don't know how I missed them at the time... all I know is they are still there on the list.
Reply With Quote
  #8  
Old 04-19-2012, 11:29 PM
cojhl2 cojhl2 is offline
Registered User
 
Join Date: Jan 2010
Location: Colorado, SE Washington
Posts: 1,223
OK, something must be wrong with how you are reconciling. If they cleared the bank and you did not mark them as cleared how could the balances have been correct.

Joe will be on later and he has a way to get get you started again as he has posted this solution before.

This statement is inconsistent.
Yes you are correct. Some I used reconcile.... some I did not. But they have all cleared the bank and I would like to get them off my list. Some are 6 or 7 years old. I don't know how I missed them at the time... all I know is they are still there on the list.
__________________
Colorado Springs and Waitsburg, Washington
QB Pro 2014 used for two farms and personal
Reply With Quote
  #9  
Old 04-20-2012, 03:10 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,894
To reconcile the old transactions that have cleared the bank, set the Statement Date to 4/1/2010 and leave the Ending Balance 0.00. Click Next and check all of the old checks and deposits.
Note the Cleared Balance and then click Leave to go to the first screen.
Enter the Cleared Balance in the Ending Balance and click Next then finish reconcile.
This will mark all of those transactions as reconciled and the Beginning Balance on the next reconcile will be correct but you MUST set the Statement Date to the correct date.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #10  
Old 04-20-2012, 10:13 AM
Bummie Bummie is offline
Registered User
 
Join Date: Jun 2004
Posts: 11
Thanks Joe. Things are back now to where they should be. I must be more diligent!!
Reply With Quote
  #11  
Old 07-05-2012, 06:40 PM
smelsco smelsco is offline
Registered User
 
Join Date: Jul 2012
Posts: 1
Hi Joe Williams,

I must not understand your instructions to clear old transactions. When I follow your steps, the old transactions do reconcile out with a $0 difference but then when I try to do my monthly reconcilation, my Beginning Balance is the 'Cleared Balance' from the old transactions rather than the beginning balance on my bank statement. What am I missing?
Reply With Quote
  #12  
Old 07-06-2012, 04:25 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,894
QuickBooks reconcile uses the transactions that have been reconciled through the QuickBooks reconcile. These transactions have a check-nark or X in the Clr column in the bank register.
To reconcile OLD transactions, in the first screen of reconcile, enter the date before the date on the current statement and leave the Ending Balance 0.00. Click Next and check ALL of the old transactions that have cleared the bank.
Note the Cleared Balance and backup to the first screen and enter that balance in the Ending Balance. Click Next and Complete reconcile.

This will mark all of the check/selected transactions as reconciles and on the next reconcile the Beginning Balance will match the bank statement.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #13  
Old 07-06-2012, 10:48 AM
Deidre56 Deidre56 is offline
Registered User
 
Join Date: Aug 2005
Posts: 896
i dont understand how your begining balance the next month is corrent by using this procedure. i would suggest that you enter a deposit for the total of the checks outstanding and code it to miscellaneous income. clear all the checks and this deposit to reconcile. my assumption is that you have entered them twice in previous years. This is the only way you could have cleared them and still reconciled. Or, you were out of balance and told the system to reconcile now. Either way you ended up doubling your expenses in the year in question. the proper way to correct is to pick them up as income in the current year. i wouldnt try to figure out exactly what expense account each was posted to over 7 years ago. just put the deposit to misc income and be done with it. This way your current margins are still correct.
__________________
~Deidre~

Senior Accountant
Quickbooks Proadvisor
Reply With Quote
  #14  
Old 07-07-2012, 03:38 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,894
My assumption is that the checks and deposits are entered and the register balance is correct, but the reconcile was done incorrectly. Then by reconciling all of the OLD transactions the reconciled balance will then match the bank's cleared balance.
If there is a difference the correcting amount could be assigned to an Other Income or Other Expense account named "Correcting Account" since the income for the old accounts have been accounted for in the old tax returns.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #15  
Old 07-11-2012, 04:19 PM
ronblack ronblack is offline
Registered User
 
Join Date: Jul 2012
Location: Canada
Posts: 4
Hi Joe,

was just reading through the forum and used some of the advice that you posted.
Just wanted to say thanks and keep up the good work.

I'm new to this forum and will hopefully be posting more as I become more knowledgeable with quickbooks.

Cheers,

Ron
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 11:42 AM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.
You Rated this Thread: