Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Pro Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-08-2007, 05:30 PM
smonjar smonjar is offline
Registered User
 
Join Date: Jan 2007
Posts: 5
Incorrect balances in Chart of Accounts

Pro 6 version 6.0.1 R2.

Somehow, I accidentally double-clicked a $4000 “Customer Payment” in the “Receive” window. The program dutifully registered an extra $4000 payment that now shows up in some balances, but not others. “Receive/Previous” shows only the correct payments - no “extra” payments show up there.

Balances are INCORRECT in:
Chart of Accounts: Accounts Receivable ($4000 low)
Checking Account ($4000 high)
Write Checks Window: Ending Balance ($4000 high)

Balances are CORRECT in:
Checking Account Register
Accounts Receivable Register
Customer Balance Detail
Open Invoices
Reconcile
General Ledger (I think)

Tried reinstalling the program, but same problem showed up, suggesting that the error is contained in data file. Is this fixable? How? Or do I just have to live with it? Would greatly appreciate any help.
Reply With Quote
  #2  
Old 01-08-2007, 07:22 PM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,953
If you know the date you entered the payment, use Find and click the Advanced tab. In the Filter: click Transaction type and choose Payment. Scroll down and click entered/modified and for the From and To dates use the date you entered the payment.
Click on the payment and delete it.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #3  
Old 01-09-2007, 10:57 AM
smonjar smonjar is offline
Registered User
 
Join Date: Jan 2007
Posts: 5
Incorrect balances in Chart of Accounts - part II

Joe,

Thanks for responding! Perhaps I should have added "for OSX" in with "Pro 6," since you and I seem to have different programs. My "Find" (on the "Edit" pull-down) has no "Advanced" tab, and my Find Filter seems to have no provision for finding payments.

Is your QB better appointed than mine, or have I gone astray in trying to follow your instructions?

Again, thanks for your response.

SM
Reply With Quote
  #4  
Old 01-10-2007, 08:55 AM
lisa_mn's Avatar
lisa_mn lisa_mn is offline
Moderator
 
Join Date: Nov 2003
Location: Minneapolis
Posts: 3,870
if you know what customer it's for, you can do a quickreport to find it.
__________________
Lisa Peterson
Streamline Consulting, Inc.
Making Accounting Work For You
Minneapolis, MN

QuickBooks Advanced Certified ProAdvisor
Sleeter Group Certified QuickBooks Consultant
Peachtree Certified Consultant
Timeslips Certified Consultant
Fishbowl Inventory Authorized Reseller

Ask me about MiSys Manufacturing add-on for Quickbooks and Peachtree
Reply With Quote
  #5  
Old 01-10-2007, 09:10 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,953
You can use the Custom Transaction Detail report and click Modify and set the date range then click the Filter tab and in Filters click Transaction type and choose Payment.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #6  
Old 01-11-2007, 12:03 PM
smonjar smonjar is offline
Registered User
 
Join Date: Jan 2007
Posts: 5
Thank you, folks!

To Joe and Lisa,

Thanks for your suggestions. I have followed them, but am still unable to find my "phantom payment." I even installed QB 2007, which I was planning to do, anyway. But that hasn't helped, either.

I'm forced to the conclusion that my problem is deeply embedded in my data file, in some obscure register where it will likely remain forever. I'm not enough of a geek to do anything about that!

Still, I'm most grateful for your willingness to help.

Steve
Reply With Quote
  #7  
Old 01-11-2007, 12:29 PM
suzannemead suzannemead is offline
Moderator
 
Join Date: Nov 2003
Location: Woodbine, MD
Posts: 5,374
If this is a "false" payment then it won't have cleared the bank. Go to the register for that bank account and click on the sort button at the bottom. Change it to "sort by - Cleared Status". I hope you have these features. The list you provided as to what shows a correct or an incorrect balance doen's really make sense. For instance, you said the checking account balance is wrong but the check register is correct. Have you run the "verify" utility to see if the data is somehow corrupt?
__________________
Suzanne M. - "Better Books"
Certified Quickbooks ProAdvisor in Pro.,Prem. & Enterprise
suzannemead@msn.com / suzannemead@comcast.net

Last edited by suzannemead; 01-11-2007 at 12:32 PM.
Reply With Quote
  #8  
Old 01-12-2007, 10:39 AM
smonjar smonjar is offline
Registered User
 
Join Date: Jan 2007
Posts: 5
Success!

SuzanneMead: BINGO!

Your advice to use "Utilities" did the trick! As I suspected, my data file turned out to be corrupted. "Verify Data" found the problem, and "Rebuild Data" fixed it! Took all of about 90 seconds.

All balances are now correct, and order and tranquility reign.

Thank you very much, Suzanne. And thanks to Joe and Lisa, as well. I do appreciate your help.

Sincerely,

Steve
Reply With Quote
  #9  
Old 01-12-2007, 11:42 AM
suzannemead suzannemead is offline
Moderator
 
Join Date: Nov 2003
Location: Woodbine, MD
Posts: 5,374
Glad you got it fixed. I know how frustrating these things can be. Happens to me too.
__________________
Suzanne M. - "Better Books"
Certified Quickbooks ProAdvisor in Pro.,Prem. & Enterprise
suzannemead@msn.com / suzannemead@comcast.net
Reply With Quote
  #10  
Old 01-14-2007, 08:22 PM
smonjar smonjar is offline
Registered User
 
Join Date: Jan 2007
Posts: 5
Ain't technology wonderful? Thanks again, Suzanne.

Steve
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 06:51 PM.


 

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