Thursday, October 29, 2020

Maximum number of list entries In QuickBooks Desktop

 QuickBooks Maximum wide range of list entries


Maximum number of list entries (list limits and custom fields)


Find out about the most quantity of list entries you are able to in QuickBooks Desktop.


That will help you manage your organization data, listed here sections supply the maximum number of list entries (list limits and custom fields) it's possible to have in QuickBooks Desktop.


List limits for QuickBooks Desktop for Windows

Review listed here table to find the maximum amount of entries for specific lists.



A number of the lists were not available in earlier versions of QuickBooks Desktop for Windows.


List name Max wide range of entries (Pro, Premier) Max number of entries (Enterprise)

Chart of Accounts 10,000 100,000

Total names: Employees, Customers, Vendors, and Other Names combined 14 500 (individual limits of each list is 10 500 >100,000

Items, including inventory items (group items can contain only 20 singular items) 14,500 >100,000

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 10,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 complete 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 15 30

QuickBooks Desktop Enterprise 17.0 and later versions enable you to total up to one million names (customers, vendors, employees) or more to a single million items (for example, inventory, non-inventory, and service items). Some performance degradation is likely as your lists approach these size thresholds.


To test list size in QuickBooks Desktop, press the F2 key or Ctrl+1 and review the List Information section or the File Size within the File Information part of the window.


For custom fields, the table provides totals which can be a mixture of the allowable custom fields for customers, vendors, and employees:


Pro/Premier: There is an overall total of 15 custom fields, but you cannot have more than 7 per category (as an example, 7 custom fields for customers, 7 for vendors, and 1 for employee)

Enterprise Solutions: There is a total of 30 custom fields,  you cannot have more than 12 per category (for example, 12 custom fields for customers, 12 for vendors, and 6 for employee)

List limit for QuickBooks Desktop for Mac

Review the following table to get the maximum quantity of entries for specific lists.


A number of the items into the list are not for sale in earlier incarnations of QuickBooks Desktop for Mac.


List name Max wide range of entries

Chart of Accounts 10,000

Items, including inventory items(Group items can simply contain 20 individual things) 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 Do List 10,000

Names added together (Employees, Customers, Vendors, along with other Names) 14,500

Names added together: Any one of these simple lists can contain as much as 10,000 names nonetheless they cannot exceed 14,500 combined.


Practical limitations

QuickBooks Desktop is made for smaller businesses with 20 or fewer employees and annual revenue of lower than two million dollars. The ideal utilization 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 have prior-year project information.


The rate of growth of QuickBooks Desktop company data files varies significantly from company to company. There's no “average” or “typical” data file size since businesses track different information.


How quickly a file grows varies according to the number of transactions, the quantity of information entered per transaction, as well as the quantity of links per transaction.


For example, if you enter 500 1-line invoices every month, your organization file may be smaller compared to that of somebody who enters 100 5-line invoices every month. A person who usually receives five separate payments per invoice will have a larger file than someone who typically receives only 1 payment per invoice.


To estimate if QuickBooks is suitable for your online business, make the average quantity of monthly transactions (remember, an invoice, payment, and deposit are three separate transactions and a bill and bill payment count as two), and multiply by 2 KB to ascertain approximately just how much your company file will grow every month.


For instance, if your business enters an average of 300 transactions each month, the data 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). If the annual data file dimensions are significantly less than 15,000 KB, then QuickBooks Desktop should really be significantly more than sufficient for the company.


The two KB multiplier does not include list information (that also grows as new names are included with the file) and it is only an approximation that may not be a suitable estimate for many QuickBooks company data files.


If performance becomes an issue, or you decide you do not want to keep detailed transactions for prior years, it is possible to condense a QuickBooks company file. For information on condensing a company file, see utilize the condense data utility. If you are unable to create Maximum Number Of List Entries In QuickBooks please contact our experts.


Before you condense your business file, it is smart to read about Condensing data when you look at the QuickBooks User’s Guide chapter preserving your data, or review the QuickBooks Help topics beneath the keyword condense. Both are available from the QuickBooks Desktop Help menu.

No comments:

Post a Comment