Menu

ACCOUNTING PRIDE

Maximum number of list entries In QuickBooks Desktop

QuickBooks Maximum wide range of list entries
 
Maximum amount of list entries (list limits and custom fields)
 
Read about the maximum amount of list entries you are able to in QuickBooks Desktop.
 
That will help you manage your business data, the next sections offer the maximum number of list entries (list limits and custom fields) you can have in QuickBooks Desktop.
 
List limits for QuickBooks Desktop for Windows
Review the following table to get the maximum quantity of entries for specific lists.
 
A number of the lists are not obtainable in earlier versions of QuickBooks Desktop for Windows.
 
List name Max amount of entries (Pro, Premier) Max amount 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 every list is 10 500 >100,000
Items, including inventory items (group items can contain only 20 singular items) 14,500 >100,000
Items in an inventory 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 add up to one million names (customers, vendors, employees) and up to one million items (for example, inventory, non-inventory, and service items). Some performance degradation is probably as the lists approach these size thresholds.
 
To check on list size in QuickBooks Desktop, press the F2 key or Ctrl+1 and review the List Information section or perhaps the File Size in the File Information section of the window.
 
For custom fields, the table provides totals that are 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 was an overall total of 30 custom fields, but you cannot do have more than 12 per category (as an 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.
 
Some of the items within the list were not for sale in earlier versions 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 singular 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,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 perfect for small businesses with 20 or fewer employees and annual revenue of lower than two million dollars. The best utilization of QuickBooks Desktop is always to keep at the least two years of detailed transactions in a company data file in order to run comparative reports and have prior-year project information.
 
The rate of growth of QuickBooks Desktop company data files varies significantly from company to company. There isn't any “average” or “typical” data file size since businesses track different information.
 
How quickly a file grows is based on the number of transactions, the amount of information entered per transaction, therefore the amount of links per transaction.
 
For example, if you enter 500 1-line invoices each month, your organization file might be smaller compared to that of an individual who enters 100 5-line invoices every month. Somebody who usually receives five separate payments per invoice might have a larger file than someone who typically receives only one payment per invoice.
 
To estimate if QuickBooks is suitable for your small business, take the average wide range 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 determine approximately simply how much your company file will grow each month.
 
For instance, if your organization enters an average of 300 transactions each 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 significantly less than 15,000 KB, then QuickBooks Desktop ought to be a lot more than sufficient for the company.
 
The 2 KB multiplier does not include list information (which also grows as new names are included with the file) and is only an approximation that could never be a suitable estimate for several QuickBooks company data files.
 
If performance becomes a concern, or if you decide you do not want to keep detailed transactions for prior years, you can condense a QuickBooks company file. For information regarding condensing a company file, see Use the condense data utility.
 
Before you condense your organization file, it is smart to find out about Condensing data within the QuickBooks User’s Guide chapter Maintaining your data, or review the QuickBooks Help topics underneath the keyword condense. Both can be found from the QuickBooks Desktop Help menu.

Go Back

Comment

Blog Search

Comments

There are currently no blog comments.