cancel
Showing results for 
Search instead for 
Did you mean: 
scacct
Level 2

Quickbooks Premier database size limits

Out QB vendor sent us the following about DB size limits. 

 

  • Limits for QuickBooks PRO & PREMIER – 150,000kb – 250,000kb.
  • 200,000kb is the time to start thinking about QuickBooks Enterprise
  • 250,000kb is technically the MAX recommended size. (This is the point where corruption and unrecoverable data damage start to appear.)
  • Any File over 250,000kb is HIGHLY recommended to be moved into QuickBooks Enterprise.

 

Does anyone have any experience or insight on this?   

Our QBW file is currently well over 250,000kb.  We haven't tried the condense feature yet.

5 Comments 5
Fiat Lux - ASIA
Level 15

Quickbooks Premier database size limits

There is no actual size to limit a QB Desktop file. But you should run the Condense Data utility to lower the size on QBD Pro/Premier or purchase a 3rd party service to split the file. Our experience is that Pro and Premier data files start to take a long time to run reports at the 150-200 MB size. In addition, Pro and Premier
become more susceptible to data corruption and other funky issues if they get to be too large.

LieraMarie_A
QuickBooks Team

Quickbooks Premier database size limits

Thank you for reaching out to the QuickBooks Community, @scacct.

 

I agree. When the company file size gets close to 250 MB, it will slow down the program. There are two approaches you can take for this. You may condense your company file. However, there are limitations as well when doing this. Another will be, as mentioned, to upgrade to Enterprise. For more info about its features, this link is an excellent resource of information: QuickBooks Enterprise.

 

Additionally, the following article displays a side-by-side comparison of the maximum number of entries, both Pro/Premier and Enterprise. From here, you can decide if you'd like to proceed to upgrade: Maximum Number of List Entries

 

If you wish to condense your file, make sure to create a backup copy of your company file. If there are changes that occur, having a backup copy allows you to restore it to undo the changes.

 

Here's how to run the Condense Data utility:
 

  1. Go to the File menu, then select Utilities and then Condense Data.
    Capture.PNG
  2. Go through the wizard and choose the options you need. Click Help if assistance is required.
  3. Select Begin Condense. Before it starts, QuickBooks will create a backup and an archive copy.

 

I hope you find this useful. Please let us know in the comments if you have additional questions. We're always here to answer them for you, @scacct.

resourcewest
Level 1

Quickbooks Premier database size limits

Where do i find these 3rd party services to split the data?

What is the max file size for Enterprise desktop?

CharleneMaeF
QuickBooks Team

Quickbooks Premier database size limits

I've got you covered, resourcewest.

 

There are no actual limits on your file size. However, the system's performance decreases as the size of your company file increases. 

 

To find a third-party application that can split the data, I'd recommend visiting our QuickBooks Apps Store. There you can look for an app that suits your business needs.

 

I've also added this article that'll help you learn about the maximum number of list entries you can make in QuickBooks Desktop: List Limits and Custom Fields.

 

If you need assistance managing your data in QuickBooks, please don't hesitate to let us know. We're always here to help you.

Fiat Lux - ASIA
Level 15

Quickbooks Premier database size limits

@resourcewest 

Contact me in private for assistance.

Need to get in touch?

Contact us