Evan Carmichael Top Header about About About facebook Twitter YouTube Google+

How Many Customers and Inventory Items Can I Have in QuickBooks?



Free PDF Download
QuickBooks 2011: Improvement to Closing Date Functionality - By Scott Gregory

Name: Email:


It is critical to know that QuickBooks has limits to the number of customers, vendors, inventory items and related information it can store. While many businesses will never approach these limits, others need to monitor their QuickBooks usage carefully and plan an upgrade path. Here is a quick recap of selected list limits:

Pro and Premier versions:

* Customers, Vendors, Employees and Other Names: Limit = 14,500. This is a combined limit - the total of ALL of these lists cannot exceed 14,500.

* Items in the item list: Limit = 14,500. This is all types of items - inventory items, non-inventory items, inventory assemblies, etc.

* Price levels: Limit = 100

* Chart of accounts: Limit = 10,000

Enterprise version:

* Customers, Vendors, Employees and Other Names: Limit = > 100,000*. This is a combined limit as mentioned above.

* Items in the item list: Limit = > 100,000*. This is all types of items - inventory items, non-inventory items, inventory assemblies, etc.

* Price levels: Limit = 100

* Chart of accounts: Limit = 10,000

* According to the QuickBooks Enterprise web site, they indicate that you could add up to 1 million listings in these areas. In addition, they note that some performance degradation is likely as you approach this upper limit. In reality, I would plan on capping out your customers and item lists in the Enterprise version at 100,000 based on my observations of clients using extremely large lists like these. (I am quite skeptical that they have any clients running QuickBooks files with list sizes anywhere near 1 million).

Avoid the Surprise

There are no advance warnings provided within QuickBooks (that I know of) to indicate you are approaching the list limits above. One day, you'll simply try to add another customer (or inventory item) and QuickBooks will say "sorry, can't help you". That is not the way you want your day to go!

Options If You Hit the Limit

If you max out a list, what are your options?

* Delete - if you have items, customers, etc. with NO activity associated with them, you can delete them from your list and free up some capacity. BUT, if there is activity tied in, you cannot delete the item. Making it inactive does NOT free up any space in your list to add new entries.

* Clean Up Company Data - this QuickBooks utility may buy you some extra space in your lists. Found under the File > Utilities menu, you can run this tool to see how much extra list capacity it buys you. Keep in mind that there are other potentially negative issues around the use of this tool (you are taking some of your accounting history out of your main QuickBooks data file and archiving it), so plan carefully.

* Move up to QuickBooks Enterprise - if you are currently using QuickBooks Pro or Premier, the natural (and seamless) upgrade path to increase your list capacity is to move to Enterprise. In fact, that is one of the reasons why Enterprise was created - to give those businesses that are growing an easy and budget-friendly solution.

* Move to a QuickBooks add-on -if you are already using QuickBooks Enterprise and still need more capacity, there is good news. You can use a QuickBooks add-on such as Acctivate or FishBowl Inventory to address the list limits, and still keep QuickBooks for your core accounting activities.

How Close Are You?

It is very easy to know just where you stand with your list totals in QuickBooks. Just tap the F2 key and you'll get an instant view.

Need help determining your best plan of action if you are bumping up against your list limits? Contact me for additional insight.


Related Articles

  Streamline Your Accounting: Automate Your Purchase Orders in QuickBooks
  Track Inventory in QuickBooks?
  QuickBooks 2011: It's Here!
  Can I Move from QuickBooks Pro to Premier or into QuickBooks Enterprise?
  Understanding the Differences Between QuickBooks Upgrades and QuickBooks Updates
  Tip on Better QuickBooks Performance
  The
  Key Differences Between QuickBooks Enterprise and QuickBooks Pro/Premier Accounting Software
  QuickBooks 2011: Improvement to Closing Date Functionality
  QuickBooks 2010 - Download This Product Update (R5) for Less Intrusive Marketing
  QuickBooks 2010: Will I Lose My Data if I Upgrade?
  5 QuickBooks Myths - The Real Story
  QuickBooks Scenario For A Real Client of Mine
  Why It is Critical to Verify Your Data in QuickBooks
  What is a "QuickBooks Add-On"?
  QuickBooks Registration: More Hassle Than it Should Be?
  Inventory Profitability
  Efficient Inventory
  Report presentations to provide clarification of your financial position
  The Cost of Lost Sales

Home > Accounting > Scott Gregory > How Many Customers and Inventory Items Can I Have in QuickBooks >

Free PDF Download
QuickBooks 2011: Improvement to Closing Date Functionality - By Scott Gregory

Name: Email:

About the Author: Scott Gregory

RSS for Scott's articles - Visit Scott's website
Scott provides a wide variety of QuickBooks solutions and profit improvement techniques to his clients in a relaxed yet very informative manner. No “accountant-speak” here - just a desire to help you create extremely efficient accounting systems and get the most out of your QuickBooks investment! He is a: > Certified QuickBooks ProAdvisor > Certified QuickBooks Enterprise ProAdvisor > He has taught hundreds of students a variety of QuickBooks courses for over five years in the Community Learning Division of Lakeland Community College. > Certified in Integrated Resource Management (CIRM) from APICS. Prior to forming Bottom Line Accounting Solutions, Scott served as the chief financial officer (CFO) for a $15 million manufacturing firm. In that position, he was in charge of the accounting, banking, IT, purchasing, inventory control and human resource departments. Scott was recently recognized as the Distinguished Business Leader/CEO of the Year for 2009 by The Willoughby Area Chamber of Commerce. Download a free copy of Scott's menu of services to learn more about improving the accounting within YOUR business - http://www.betterbottomline.com/docs/BLASProducts.pdf
Click here to visit Scott's website.
Dashed Line

More from Scott Gregory
Using QuickBooks Sales Orders
Tips for QuickBooks Backup
QuickBooks Self Quiz
QuickBooks Danger Ahead?
4 QuickBooks Blunders

Related Forum Posts

Re: Two Useful Books To Help You Focus On The CLIENT Re: Two Useful Books To Help You Focus On The CLIENT
Managing the Paperwork Managing the Paperwork
Re: What customers actually wants? Re: What customers actually wants?
Seek Venture Capital & Funding Seek Venture Capital & Funding
How to Do Great Marketing with (Amost) No Money How to Do Great Marketing with (Amost) No Money

Share this article. Fund someone's dream.

Share this post and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.
Share for a Cause
Featured Article



Worksheets
By: Evan Carmichael

Do you have what it takes to be an entrepreneur?

8 Powerful Steps to Finding Your Passion

Does your pitch suck?

Create a plan of attach to launch your new business.

8-Cover

Like this page? PLEASE +1 it! Evan Signature
Bottom Footer



Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!
Name:
Email:
Popular Articles

SEXUAL HARASSMENT – THE CAREER KILLER

The Biggest Domain Name Myth

A Practical View of Mission and Vision Statements

Suggestions

Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.