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:
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.
How Many Customers and Inventory Items Can I Have in QuickBooks - To learn more about this author, visit Scott Gregory's Website.
Like this article? Share it with your friends
![]() | |
| |
No article feedback found. |
| |
Leave Your Feedback |
|
| |
| |||
Jay Kubassek(Jay's Full Bio: EvanCarmichael.com/jaykubassek) In five years, Canadian-born entrepreneur Jay Kubassek went from selling mufflers at a Midas franchise to revolutionizing Internet marketing with the 2004 launch of CarbonCopyPRO, a online marketing education company, now worth over $20 million with customers in over 160 countries.
As an independent film producer, his upstart film fund Aliquot Films is currently producing a films with Spike Lee and Abel Fererra (starring Ethan Hawke and Dennis Hopper.)
Jay's entrepreneurial spirit is irrepressible. He’s the owner of five companies, a professional speaker and trainer, international real estate developer/investor, extreme sport enthusiast and emerging philanthropist. Jay resides in NYC with his wife Jamie, son Milo and dog Cooper. Visit Jay's official website: www.JayKubassek.com - Visit Jay Kubassek's Website |
|||
|
To learn more about the Evan Elite Author Program please contact us. | |||
![]() | |
![]()
| |
![]() | |
|
| |
![]() | |
|
| |
![]() | ||
|
| ||
![]() |
| Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details. |
|
|
![]() |
| Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media |
|
|
![]() |
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"
Click Here To Learn More |
|
|
|
|
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
|
![]() |
|
|
![]() | ||
|
Top 50 Productivity Blogs
Top Blogs To Watch In 2008 | ||
|
The Top 10 GTD Times Posts
Best Posts for Productivity | ||
![]() | ||
![]() | ||||
| ||||
| ||||
| ||||
|
|
|
|
|
||||||||||||
|
|
|
|
|
| ||||||||||||
| ||||||||||||






Subscribe to Scott's articles











