Why your QuickBooks File is too Large and How to Fix it

You must be facing the issue of the slow processing of your QuickBooks application. This can be due to the QuickBooks file too large in size know how to reduce the size of QuickBooks File. Though, there is no defined limit for the size of your QuickBooks file.

But if you exceed the limit of 150MB in QuickBooks Pro and Premier and 1GB in QuickBooks enterprise, then you are treading in the slow processing, lag time zone. You can use the following options that you can use to reduce or manage the size of the QuickBooks file that are too large to handle.

If you are using QuickBooks Pro or the premier version, then you can upgrade it to the QuickBooks enterprise version. But if you have affordability or other issues you can try to first clean up your current version of QuickBooks Pro or premier. For this, you can look into the below details.

Tips to Reduce the Size of QuickBooks File

There are several options available that you can use to reduce the size of QuickBooks file before updating the QuickBooks version. So, if you want to first use the clean-up feature for your QuickBooks pro or premier version then you can do the same by choosing one of the below options.

Method I- Use QuickBooks Clean up Data Feature

By using the QuickBooks clean up company data feature, you can super condense the past years. This particular option will replace the number of transactions of past years with a smaller journal entry. Your past details will be gone, but the P&L and balance sheet will be there. Also, please ensure to create a backup data file that you can access at any point in time in the future for details of transactions.

Remove all Transactions

In this feature, you can use the same clean-up data feature and create a company file by removing all the transactions. All the vendor/ customer lists will be there and other items lists will also be there. You will have to then create opening balances for the accounts from a specific date, including invoices, bills, inventory, and bank accounts. But this will require QuickBooks as well as accounting knowledge and experience.

Method II- Condense QuickBooks Data

• First of all Create a back up copy of file.
• After that go to the File option then back up company, and then Create a Local Backup.
• Ensure that you are logged in as the QuickBooks admin.
• Then, click File, Utilities, and then Condense Data.
• Please select Yes when prompted.
• Select a date, then Next and choose a method to summarize transactions.
• Click Next, then click Condense.

Method III- Brand New Company File

You can also go for creating a brand-new company file as a last resort, but it will require you to create opening balances for all the accounts and recreate your item lists. Though this is not always the best option, it has its relevance in the following situations.

• The current data file is too old and too large to handle.
• The database is corrupted and is impossible to fix. For the repair of the data files, you can send them to our Consultant team as well before going for this option.

Frequently Asked Questions