by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Tip – How To Rebuild Your QuickBooks Data File

Print Friendly, PDF & Email

This QuickBooks Tip provides instructions for how to rebuild your QuickBooks data file.  The rebuild function will help maintain the overall health of your file.

QuickBooks tipsIs your QuickBooks file very large?  Is it running slow?  Are you in a multi-user environment where 2 or more people are inputting a lot of information on a daily basis?  If you answered yes to any of these questions you would probably benefit from rebuilding your data file on a regular basis.

The QuickBooks Rebuild Data function is like a cleaning lady.  When you access the rebuild function it looks at all of the information in your file and makes sure that it has been filed correctly.  Think of your desk, covered in piles of papers that need to be filed.  Before you actually put all of the papers in the filing cabinet, you sort and separate the various piles into organized files.  The rebuild function performs the same task.

How to Rebuild Your Data File:

You’ll need to be logged into QuickBooks as the Administrator.  If you have a large file, this could take quite awhile – so plan to run this process at lunch time, or gear it up just before you leave for the day.

  • From the File menu
  • Choose Utilities
  • Rebuild Data

The first thing that the Rebuild will require you to do is to make a backup of your data file, go ahead and do that.

As soon as the backup has completed, the rebuild function will automatically start.  This tool will take two passes through your file, looking for problems, organizing your data, and trying to fix any problems with your data that it finds.  If you sit an watch the process, don’t be concerned if QuickBooks seems to stop responding or stop working at 99% on the first pass and 50% on the second.  This just means that it’s found things that are wrong, is attempting to fix them, and then going back to check that everything it found on the first pass has been fixed.

There are times when the Rebuild function will fail, this usually means that there is data damage within your file that the rebuild cannot fix (it does have limited abilities).  In a situation like this, you’ll need additional assistance to fix the issues. If you run into this situation, I would recommend that you investigate the services of Accounting Users, Inc., QB or Not QB, or The Bottom Line.

Our own QuickBooks file contains 11 years of data and I rebuild it on a monthly basis and have for many years.

If you found this article helpful, please leave a comment or share it with others.

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

Enter your email address:

Delivered by FeedBurner

We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!

QuickBooks Time Tracker