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

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 (full list here):

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 and we'll get a dialogue going.

_______________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise. Connect with Scott @ Bottom Line Accounting Solutions or on Twitter.

Comments

[Scott Gregory, QuickBooks Expert]

Janet:

The limit for Enterprise 7 is 100,000 items, so you have room to grow.

Keep in mind that version 7 is no longer supported. If you are in the market for an upgrade to QuickBooks Enterprise 2013, it is currently on sale at a great price - details here:
http://www.betterbottomline.com/quickbooks-enterprise-2013/

[Janet Barag]

Hi,
I am workinging on Enterprise 7. Approaching 10000 items, which I beleive is the limit. Is this true and can I delete items? Or what?

[Scott Gregory, QuickBooks Expert]

Kimbakat:

Unfortunately, there is no way to get the total vendor count that you are looking for.

I'm curious - how does knowing that information become helpful for your business? That is the first time I have heard of needing to know the actual vendor count, as opposed to the total $$ owed to those vendors.

Scott Gregory

[kimbakat]

How do I find out "Currently" the total amount of Vendors I have?
It would be nice for them to have a "total" count at the bottom after each filter is applied.

[Scott Gregory, QuickBooks Expert]

Charlie:

Is this something you learned by working with the QB SDK? The web site with all these references doesn't mention anything about the 10,000 limit that I could see. Curious how you came across that limitation...

Scott

[Charlie Russell]

Hey, Scott, one addendum. The limit of 14,500 for the combination of other names, customers, vendors and employees - there ALSO is a limit of 10,000 names of any particular type. So you can only have 10,000 customers in Pro/Premier. Or 10,000 vendors. The TOTAL is limited to 14,500.

____
Charlie Russell