MAXIMUM AMOUNT OF QUICKBOOKS DESKTOP LIST ENTRIES (LIST LIMITS AND CUSTOM FIELDS)
HOME
If you are currently on Pro or Premier, and need additional entries, consider upgrading to Desktop Enterprise. To see if Enterprise suits you, along side any active promotions, please contact our sales team
Here’s the menu of QuickBooks Desktop maximum quantity of list entries (list limits and custom fields) to help you manage your business data file.
List limit for QuickBooks Desktop for Windows
List name1 Max wide range of entries (Pro, Premier) Max number of entries (Enterprise)
Chart of Accounts 10,000 100,000
Total names: Employees, Customers, Vendors, along with other Names combined 14 500 (individual limits of each list is 10 500 >100,0002
Items, including inventory items (group items can contain only 20 individual things) 14,500 >100,0003
Items in a listing assembly or sub-assembly 100 500
Job types 10,000 10,000
Vendor types 10,000 100,000
Customer types 10,000 100,000
Payroll items 10,000 10,000
Price Levels 100 750
Classes 10,000 100,000
Terms for receivables and payables 10,000 29,000
Payment methods 10,000 10,000
Shipping methods 10,000 10,000
Customer messages 10,000 100,000
Ship To addresses 10,000 10,000
Memorized reports 10,000 29,000
Memorized transactions 10,000 50,000
To accomplish notes 10,000 100,000
Sales Reps 10,000 10,000
Sales Tax Codes 10,000 10,000
Group Items & Sales Tax Group Items 50 50
Advanced Inventory Sites N/A 1,000,000
Advanced Pricing Price Rules N/A 100,000
Contacts No limit No limit
Custom Fields 20 45
Item custom field
5 15
Customers/Vendors/Employees custom fields
154 304
1Some of this items into the list are not for sale in earlier incarnations of QuickBooks Desktop for Windows.
2QuickBooks Desktop Enterprise 14.0 and soon after versions permit you to soon add up to one million names (e.g. customers, vendors, employees) or over to one million items (e.g. inventory, non-inventory, and service items). Some performance degradation is probably as your lists approach these size thresholds.
3 Current QuickBooks Desktop users can look at the size and or lists of these QuickBooks Desktop company file by pressing the F2 key or Ctrl+1 and appearance for File Size when you look at the File Information section of the window or List Information section.
4Customers/Vendors/Employees – 15 and 30 totals are a mixture of custom fields for customers, vendors and employees.
In Pro/Premier, even though there is a total of 15 custom fields, you simply can't have more than 7 per category. For instance, you might only have 7 custom fields for customers, 7 for vendors and 1 for employee.
In Enterprise Solutions, though there is a total of 30 customer fields, you can't have more than 12 per category. For instance, you could have only 12 custom fields for customers, 12 for vendors and 6 for employee.
List limit for QuickBooks Mac Desktop
List name1 Max number of entries
Chart of Accounts 10,000
Items, including inventory items
(Group items can simply contain 20 individual items) 14,500
Job Types 10,000
Vendor Types 10,000
Customer Types 10,000
Purchase Orders 10,000
Classes 10,000
A/R Terms and A/P Terms added together 10,000
Payment methods 10,000
Shipping methods 10,000
Customer messages 10,000
Memorized reports 14,500
Memorized transactions 14,500
To Accomplish List 10,000
Names added together (Employees, Customers, Vendors, along with other Names) 14,5002
1Some associated with the items into the list are not obtainable in earlier incarnations of QuickBooks Mac Desktop.
2Any one of these brilliant lists can contain up to 10,000 names nevertheless they cannot exceed 14,500 combined.
Some practical limitations
QuickBooks Desktop is designed for smaller businesses with 20 or fewer employees and annual revenue of less than two million dollars. The ideal usage of QuickBooks Desktop would be to keep at least 2 yrs of detailed transactions in an organization data file to enable you to run comparative reports and also prior-year project information.
The rate of growth of QuickBooks Desktop 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 hinges on the sheer number of transactions, the actual quantity of information entered per transaction, additionally the amount of “links” per transaction.
Example
Somebody who enters 500 1-line invoices every month will dsicover that their data file is smaller compared to another individual who enters 100 5-line invoices each month, while an individual who usually receives five separate payments per invoice would have a larger file than an individual who typically receives only one payment per invoice.
To estimate if QuickBooks is right for your online business, take the average quantity of monthly transactions (remember, an invoice, payment, and deposit could be three separate transactions, and a bill and bill payment would count as two), and multiply by 2 KB to find out approximately simply how much the information file will grow every month.
If you are facing any issue Creating Limits In The QuickBooks Desktop please contact our experts.
Also read: https://penzu.com/p/9bf67475
Example
In case your company enters an average of 300 transactions per month, the information file would grow approximately 600 KB per month (300 x 2 KB = 600 KB) or 7200 KB per year (600 KB x 12 = 7200 KB). In the event that annual data file size is not as much as 15,000 KB, then QuickBooks must certanly be a lot more than sufficient when it comes to company. Remember that the two KB multiplier will not include list information (that will also grow as new names are put into the file), and it is only an approximation that may never be the right estimate for several QuickBooks company data files.
If performance becomes an issue or perhaps you decide you do not want to keep detailed transactions for prior years, you can condense a QuickBooks company data file. Before you condense, please read Condensing data within the QuickBooks User’s Guide (within the chapter preserving your data) or browse the QuickBooks Help topics underneath the keyword condense. (Both the User Guide and QuickBooks Help are found regarding the QuickBooks Help menu.)
