Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 14, 2019
Question

Need a QB Expert to help shrink company file

  • March 14, 2019
  • 3 replies
  • 23 views

I'm working with a client who uses QB Enterprise for the last 10+ years. He has a lot of transactions and when his file size gets too big (it's currently at 4GB) we've used a company who peels off a few years of data and help us shrink the file.  We've done this a couple times over the past 6 years and the company we used in the past is not available.  

 

Can anybody recommend a person or company who has the expertise and experience to take on this project.

 

Thank-you

Brian

3 replies

MaryLandT
Level 10
March 14, 2019

I'm delighted to have you here in the Intuit Community, @Bbach.

 

In QuickBooks Desktop, you can reduce your file size by using the Condense Data utility. This process still keeps your data and minimize the risk of data damage.

 

Please keep in mind condensing data in your account is irreversible.

 

Here are the steps you can follow:

 

  1. In your account, go to the File menu, select Utilities, then Condense Data.
  2. Select the best option on how you want to condense your file, then click Next.
  3. Choose what transactions you want to remove, then click Next.
  4. Click Begin Condense.

To learn more about this process, feel free to read through this article: Use the Condense Data utility.

 

You can now shrink your company file.

 

Let me know how this goes by leaving a comment below. You're welcome here any time you need further assistance with the solution above.

September 14, 2020

THIS is the feature I need, but where is it in QBD 2020?

I need to convert a very large client file to QBO. The condense data command is nowhere to be found. I've searched every comparable term I can think of.

Fiat Lux - ASIA
Level 14
September 14, 2020

@Young Associates 

The Condense Data utility is available only in QBD US version. Go to menu File > Utility > Condense Data. Make sure your client is not using QBD UK or CA version. Otherwise you need to purchase a 3rd party condense service. 

AdrianG001
May 3, 2019

Condense or Cleanup Quickbooks. Quickbooks has a built-in utility that will reduce the file size of your Quickbooks data file. The Quickbooks condense operation condenses closed transactions into summary journal entries. If any list items are not used, they are deleted from QuickBooks.

 

 Here is the full intuit article :

https://quickbooks.intuit.com/community/Account-management/Use-the-Condense-Data-utility/m-p/203359

 

Hope so this will help you

 

Regards,

Adrian

QuickBooks Hosting expert - Apps4Rent

June 4, 2021

You should try this article in-order to understand about condensing QuickBooks company file