cancel
Showing results for 
Search instead for 
Did you mean: 
athompsoncmc
Level 1

Company file size too big

We're on Quickbooks Desktop 2019 Pro Plus. We have a quickbooks company file with 10 years worth of info at 424000kb. The business team regularly experiences 6190, 816 errors. We do not want to start a completely new company file, because they will still have to go back in years frequently and will experience the same errors. Is there a way to get the past year or two isolated and start a new file from there? What are our options?

6 Comments 6
Angelyn_T
QuickBooks Team

Company file size too big

Hi, Thompson.

 

Ten years worth of information can be a lot of records, and I appreciate your loyalty to QuickBooks. I'm here to help you fix the error 6190, 816 and work with QuickBooks smoothly.

 

Error codes 6190 and 816 happens when another user is logged in to the company file in a single user mode. To isolate the issue, please make sure to update your QuickBooks to the latest release to fix common issues with your file. From there, disable multi-user access. Here's how:

 

  1. Access your QuickBooks company file as the Admin.
  2. Go to the File menu, then select Utilities.
  3. If Stop Hosting Multi-User Access is listed, choose to Stop Hosting Multi-User Access.

 

Once done, create a backup copy of your company file. Then, download and install QuickBooks Tools Hub, then run the Quick Fix my Program. This is a built-in tool that auto-detects and auto-fix data damage issues within QuickBooks.

 

  1. Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub.
  2. Locate the file you downloaded (QuickBooksToolHub.exe).
  3. Follow the on-screen steps to install and agree to the terms and conditions.
  4. From the tool hub, click Company File Issues.
  5. Choose Quick Fix my File.
  6. Click OK when it completes and launch your QuickBooks.

 

For additional troubleshooting steps, you can check out these links:

 

 

On the other hand, yes, you can get your past year/s data to start a new file. However, you need to prepare big storage that's capable of saving larger data. 

 

Another option is to reduce your file size but leaves all the detailed transactions. You can use this link as your guide: Use the Condense Data utility.

 

For additional resources, while working with QuickBooks in the future, you can review the topics from our help articles.

 

If you have any other questions, please let me know by adding a comment below. I'm more than happy to help. Keep safe!

 

 

athompsoncmc
Level 1

Company file size too big

"On the other hand, yes, you can get your past year/s data to start a new file. However, you need to prepare big storage that's capable of saving larger data. " How would I do this?

katherinejoyceO
QuickBooks Team

Company file size too big

Thanks for getting back to us, @athompsoncmc. Let me be your guide today. I understand that you don't want to start a completely new company file. You don't have to do that. 

 

The good thing is you can copy and use everything such as your accounts, lists (customers, vendors, items, etc.), templates, and preferences from an existing company file to get started.

 

All you have to do is to create a copy of your existing company file. Then, condense the file to remove all the transactions. Get more insights through this help article: limitations when condensing your data

 

First off, back up your company file, then follow the steps below to create a copy of an existing company file: 

 

  1. Open QuickBooks Desktop and the company file you want to copy.
  2. Press F2 to open the Product Information window.
  3. Look in the File Information section. This shows where your (backup) company file is saved on your computer.
  4. Use the backup to restore your company file. This will create a new company file with the same accounts, lists, templates, and preferences.
  5. Rename the file when you restore it to create a different copy of your original company file. Save the new file to a unique folder.

 

You can now start fresh by deleting the transactions QuickBooks also copied over. Here's how:

 

  1. Open and review your new company file.
  2. Go to the File menu and go to Utilities
  3. Select Condense Data. If you receive a message about removing budget data, select Yes.
  4. In the Condense Data window, select All Transactions and then Next.
  5. Follow the on-screen instructions to remove the copied transactions.

 

After that, all transactions should be removed. Now, check your accounts by running a Transaction List by Date report to check if your accounts are empty. Otherwise, edit and delete them. 

 

I'll be here to answer and help if you have more questions. Have a great day!

Fiat Lux - ASIA
Level 15

Company file size too big

@athompsoncmc 

Have you tried to run the Condense Data utility? If your condensed file is still larger than > 200 MB, you may have 2 options:

1. Purchase a 3rd party condense service.

2. Run the condense utilize to split the file.

FILEREPAIR
Level 3

Company file size too big

Another option is to SuperCondense your data file.

 

https://www.google.com/search?q=Quickbooks+supercondense

almeidad
Level 2

Company file size too big

You could look at using a 3rd party service provider who can do a condense of your file. Some of them offer a guaranteed service as well.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us