Skip to main content
The Best QuickBooks Prices & Service, Since 2001

Call Today 352.742.0800

11313 Davison Lane Tavares, FL 32778
Home

Speak to An Expert

  • Home
  • Bookkeeping
  • About Us
      1. News
      2. Our Team
      3. Enix & Associates, LLC
      4. Enix/Mendelson
      5. Industries Served
  • Tips & Articles
  • Contact Us

This Week's Question: When Check Register Balance Does Not Equal the Chart of Accounts Balance

  • April 2014
  • QuickBooks
Checking Account Balance

Q - Why does the balance for my checking account in the chart of accounts listing not equal the correct balance on my bank register and Balance Sheet?

A - This is a common question we get and the source of the problem can be related to several factors.  The first thing you want to do is run the Balance Sheet with a date range of "All" to ensure we are getting all transactions that make up the balance.  Many times post dated transactions are in your data file that will cause this scenario.

Balance sheet  date range of All

Assuming the error is still present I would recommend you run a data verification to see if there is data corruption.  The result we are looking for is "QuickBooks detected no problems with your data."  You run this utility as follows:

File > Utilities > Verify Data

QuickBooks Data Verification


Even if the verification comes back with this message it is still a good idea to run the Rebuild anyway since not all errors are detected with this verification. You run the Rebuild as follows:

File > Utilities > Rebuild Data

QuickBooks data rebuild


If the error still exists try re-sorting the Chart of Accounts.  Display the Chart of Accounts and click on the "Account" button on the bottom left.  Then choose the "Re-sort List" option.

Re-sorting the QuickBooks chart of accounts.


Finally, if the error remains then I would recommend creating a new Bank Account with the same name but put an additional character at the end such as an "a."  Once this is complete edit the original bank account to the new name and merge the two accounts.  When the merge is complete you can edit the new named account and remove the extra letter we placed on the end earlier.

Creating a new bank account in QuickBooks

Merge bank accounts in QuickBooks.


In the vast majority of cases this will solve the problem.  Corruption of some sort has invaded the original bank account and by merging with a new bank account the corruption (or broken links) is corrected.  I hope this has been helpful.

Categories

  • Agiliron (1)
  • Enterprise (16)
  • Inventory (8)
  • Payroll (2)
  • PCI Compliance (2)
  • Point of Sale (21)
  • QuickBooks (38)
  • QuickBooks Online (15)
  • Reporting (7)
  • Taxes (8)

Recent Posts

  • Accounting for contractors
    Utilizing QuickBooks Online Advanced for the Construction Industry
  • accounting software for law firms
    The Best Accounting Software for Law Firms
  • streamlined processes
    Streamline Business Operations with QuickBooks Enterprise Platinum with The Diamond Package
  • QuickBooks 2020
    New and Enhanced Features in QuickBooks Enterprise 2020

Footer Logo

A multi-national award winning Intuit Premier Reseller and 3-time named Top 100 ProAdvisor serving Tampa & Orlando, Florida. Specializing in QuickBooks Point of Sale, QuickBooks Pro & Premier, Enterprise Solutions and QuickBooks Online.

Services

  • QuickBooks Support
  • QuickBooks Consulting
  • QuickBooks Data Conversion
  • QuickBooks File Review
  • QuickBooks Reporting
  • Software Needs Assessment
Intuit Premier Reseller - Advisory Council Member
Intuit Quickbooks Certified ProAdvisor - Online
Intuit Quickbooks Certified ProAdvisor - Point of Sale
Intuit Quickbooks Certified ProAdvisor - Desktop
Intuit Quickbooks Certified ProAdvisor - Advanced Desktop
Intuit Quickbooks Certified ProAdvisor - Enterpriser
Top 100 ConsultantCertified Consultant500K Club

© 2021 Enix & Associates, LLC   |   Website: Precision Pages Inc.