Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

QuickBooks Pro Limitations Explained

May 30, 2016 by Wayne Schulz

QuickBooks

 

Are you thinking about purchasing QuickBooks but unsure whether you can fit within the product’s limits? Not sure what those limits are?

Are you a QuickBooks users wondering when your company will hit the limitations build into the Intuit accounting system?

Luckily Intuit publishes the limitations of QuickBooks Pro on their website so that you can review them ahead of time to decide whether your company will fit into the capabilities of QuickBooks Pro.

First, consider that overall QuickBooks is designed for companies with under 20 employees and less than 2 million dollars of annual revenues. That doesn’t mean it won’t work for larger companies. It only means that the typical QuickBooks users are within these parameters. Companies that are expecting to grow beyond these capabilities might consider starting with a more robust accounting system to avoid a migration as the company grows.

Intuit provides some guidance for determining if your company will fit within their product limitations:

QuickBooks is designed for small businesses with 20 or fewer employees and annual revenue of less than two million dollars. The ideal use of QuickBooks is to keep at least two years of detailed transactions in a company data file so that you can run comparative reports and have prior-year project information.

The rate of growth of QuickBooks company data files varies significantly from company to company. There is no “average” or “typical” data file size, since businesses track different information. How quickly a file grows depends on the number of transactions, the amount of information entered per transaction, and the number of “links” per transaction.

For example, someone who enters 500 1-line invoices per month might find that their data file is smaller than another person who enters 100 5-line invoices per month, while someone who usually receives five separate payments per invoice would have a larger file than someone who typically receives only one payment per invoice.

To estimate if QuickBooks is right for your small business, take the average number of monthly transactions (remember, an invoice, payment, and deposit would be three separate transactions, and a bill and bill payment would count as two), and multiply by 2 KB to determine how much the data file will grow each month.

For example, if your company enters an average of 300 transactions per month, your data file could grow 600 KB per month (300 x 2 KB = 600 KB), or 7200 KB per year (600 KB x 12 = 7200 KB). If the annual data file size is less than 15,000 KB, then QuickBooks should be more than sufficient for your company. (Present QuickBooks users can check the size of their QuickBooks file by choosing Help > Product Information.)

One reason that Intuit talks about file size limitations is that many existing QuickBooks users could find reporting and speed of data entry gets much slower as the data files grow.

Here is a list of the limitations of field sizes within QuickBooks. The main issue with these limits could be the account number size which is restricted to only 7 characters.

Character Limitations for QuickBooks Fields

 

Here is another Intuit QuickBooks chart showing the limits on numbers of records. Note that while you may have up to 10,500 employees, vendors and customers individually, combined they cannot exceed 14,500 or you’ll be forced to migrate. Inventory limits may seem robust however growing companies – especially wholesale distributors – often carry a broad catalog of items from multiple suppliers. These items can easily grow to exceed 14,500.

Inventory limits may seem robust however growing companies – especially wholesale distributors – often carry a broad catalog of items from multiple suppliers. These items can easily grow to exceed 14,500.

Unfortunately, too many companies don’t consider these hard limitations before investing hours of labor into using QuickBooks for their statup.

 

 

Our recommendation:

  1. If your company can fit within QuickBooks and you do not expect to grow within the next 5 years then you’re probably on the right path if you are investigating QuickBooks as an option.
  2. If your company expects to grow past $2 million in revenues or will deal with more significant inventory capabilities and pricing then consider skipping the entry-level QuickBooks Pro and looking at alternatives. Your goal should be to avoid a migration in the future just as your company is growing rapidly and can least afford to interrupt their business processes.

To speak with us here at Schulz Consulting and discuss ways in which Sage 100 might be a better fit for your company, please use our contact form. Someone will call or email within 2 hours to discuss any questions.

Share this:

Filed Under: Quickbooks, Sage 100 ERP Tagged With: Quickbooks

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Sage 100 Updated TLS 1.2 Licensing Requirements ( February 2023 )
  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in