cancel
Showing results for 
Search instead for 
Did you mean: 
Janetccc
Level 3

Large Company File Size. Upgrading to Premier vs Enterprise

We have been using Quickbooks desktop for over 20 years, and are faced with the decision to upgrade from Pro 2019 to either Premier or Enterprise. We are increasing from 3 users (multi-user mode) to 5, and do not anticipate adding any more users in the foreseeable future. We are also deciding between keeping our LAN setup versus moving to a cloud hosted environment, with Ace Cloud Hosting being front-runner at this point. Our company data file is over 740MB, and from what I have been told, the recommended maximum is 500MB. I also understand that condensing the file would likely result in +/- 40% reduction in file size, which would get it down to approximately 450MB, still very close to the limit. I have heard not-so-good reviews of Enterprise, and wonder if it might be overkill due to our company size (less than 500 customers, less than 100 employees), but I also understand that the data file structure is different and virtually has no maximum size recommendations. That being said, my questions are:

1) if you are a mid-sized company that upgraded from a desktop Pro to Enterprise, what was your experience overall with Enterprise? Premier?

2) to upgrade to Premier, what other measures can be taken in addition to condensing the file in order to manage the size? I believe our accountant has condensed files annually.

3) has anyone found a workable way for simultaneous cloud and local data file storage in order to retain physical possession of the company data file?

4) we are also upgrading our hardware at this time, currently have 3 users on 3 separate workstations with the company file residing on one of those workstations. Will moving the data file to a new, separate, dedicated computer (e.g. RAID) help avoid issues that may otherwise arise from having a large data file? 

7 Comments 7
Fiat Lux - ASIA
Level 15

Large Company File Size. Upgrading to Premier vs Enterprise


@Janetccc wrote:

Our company data file is over 740MB, and from what I have been told, the recommended maximum is 500MB. I also understand that condensing the file would likely result in +/- 40% reduction in file size, which would get it down to approximately 450MB, still very close to the limit. I have heard not-so-good reviews of Enterprise, and wonder if it might be overkill due to our company size (less than 500 customers, less than 100 employees), but I also understand that the data file structure is different and virtually has no maximum size recommendations. That being said, my questions are:

1) if you are a mid-sized company that upgraded from a desktop Pro to Enterprise, what was your experience overall with Enterprise? Premier?

2) to upgrade to Premier, what other measures can be taken in addition to condensing the file in order to manage the size? I believe our accountant has condensed files annually.

3) has anyone found a workable way for simultaneous cloud and local data file storage in order to retain physical possession of the company data file?

4) we are also upgrading our hardware at this time, currently have 3 users on 3 separate workstations with the company file residing on one of those workstations. Will moving the data file to a new, separate, dedicated computer (e.g. RAID) help avoid issues that may otherwise arise from having a large data file? 


 

1. We have a different opinion about the file size. You should maintain your file size on 150-200 MB to run on Pro/Premier. You can still purchase the one time license for QBD 2021 US Premier to lower your expense. 

 

2. Consider to split the file to manage the file size. If you have to manage one file for one or two or three fiscal years, consider using QBD Premier Accountant edition. You can open two company files at the same time on the same screen.

 

3. Yes. We may recommend a private cloud solution to combine LAN and remote users working at the same time. Check your PM for details.

 

4. The performance issue mostly is not on the hardware requirement but in the data file structure itself. QuickBooks data files larger than 500MB need to be optimized every 6-12 months to ensure they run at top performance. There is no internal functionality in QuickBooks to optimize the data file other than running a condense. We offer a 3rd party service to copy all data into a new data file, remove unwanted temporary data, and audit trail data to bring down file size by 25-40%. This will improve the performance and stability of the data file.

Janetccc
Level 3

Large Company File Size. Upgrading to Premier vs Enterprise

In your point #2, are you saying we would split the file so that the current data plus the prior couple of years is on one company, then all the older data would be another company? Using the Accountant edition would allow us to have current/recent transactions open as well as the old data? What else is different about the Accountant version? And can we do this with a "company" that is our payroll data? I believe that file has grown hugely over the years as well. Thanks again for your input and your patience. There are plenty of nuances in QB, learning as I go!


@Fiat Lux - ASIA wrote:

@Janetccc wrote:

Our company data file is over 740MB, and from what I have been told, the recommended maximum is 500MB. I also understand that condensing the file would likely result in +/- 40% reduction in file size, which would get it down to approximately 450MB, still very close to the limit. I have heard not-so-good reviews of Enterprise, and wonder if it might be overkill due to our company size (less than 500 customers, less than 100 employees), but I also understand that the data file structure is different and virtually has no maximum size recommendations. That being said, my questions are:

1) if you are a mid-sized company that upgraded from a desktop Pro to Enterprise, what was your experience overall with Enterprise? Premier?

2) to upgrade to Premier, what other measures can be taken in addition to condensing the file in order to manage the size? I believe our accountant has condensed files annually.

3) has anyone found a workable way for simultaneous cloud and local data file storage in order to retain physical possession of the company data file?

4) we are also upgrading our hardware at this time, currently have 3 users on 3 separate workstations with the company file residing on one of those workstations. Will moving the data file to a new, separate, dedicated computer (e.g. RAID) help avoid issues that may otherwise arise from having a large data file? 


 

1. We have a different opinion about the file size. You should maintain your file size on 150-200 MB to run on Pro/Premier. You can still purchase the one time license for QBD 2021 US Premier to lower your expense. 

 

2. Consider to split the file to manage the file size. If you have to manage one file for one or two or three fiscal years, consider using QBD Premier Accountant edition. You can open two company files at the same time on the same screen.

 

3. Yes. We may recommend a private cloud solution to combine LAN and remote users working at the same time. Check your PM for details.

 

4. The performance issue mostly is not on the hardware requirement but in the data file structure itself. QuickBooks data files larger than 500MB need to be optimized every 6-12 months to ensure they run at top performance. There is no internal functionality in QuickBooks to optimize the data file other than running a condense. We offer a 3rd party service to copy all data into a new data file, remove unwanted temporary data, and audit trail data to bring down file size by 25-40%. This will improve the performance and stability of the data file.


 

Fiat Lux - ASIA
Level 15

Large Company File Size. Upgrading to Premier vs Enterprise

QBD Premier Accountant = QBD Premier + Accountant Tool

We don't see you can utilize the Accountant Tool at the moment. If you are lucky, you can still purchase QBD 2021 Premier Accountant with the one time license from several partners.

Janetccc
Level 3

Large Company File Size. Upgrading to Premier vs Enterprise

I am sorry, I don't understand what you are saying here. 

Fiat Lux - ASIA
Level 15

Large Company File Size. Upgrading to Premier vs Enterprise

All the feature available in QB Desktop Premier, you can also find in QB Desktop Accountant. The different is you will have the Accountant Tool to manage QB Desktop files created on Pro and Premier.

Janetccc
Level 3

Large Company File Size. Upgrading to Premier vs Enterprise

This is what I didn't understand:

 

"We don't see you can utilize the Accountant Tool at the moment."

Fiat Lux - ASIA
Level 15

Large Company File Size. Upgrading to Premier vs Enterprise

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up