[QODBC-Desktop] QuickBooks Specifications for Maximum number of records or transactions
Posted by Jack - QODBC Support on 03 November 2017 07:05 AM
QuickBooks Specifications for Maximum number of records or transactions
As of Date: 2007-07-25
QuickBooks can handle a maximum of 2 billion transactions. The maximum number of transactions is limited more by your computer's disk space and memory than by QuickBooks.
Each list in QuickBooks has a maximum number of items it can contain, as shown in the following table:
You can see the total number of customers, items, and names in your company data file by pressing Ctrl+1 in QuickBooks to open the Product Information screen.
QuickBooks is typically designed for small businesses with 20 or fewer employees and annual revenue of fewer than two million dollars. The ideal use of QuickBooks is to keep at least two years of complex transactions in a company data file so that you can run comparative reports and have prior-year project information.
The rate of growth of QuickBooks company data files varies significantly from company to company. How quickly a file grows depends on the number of transactions, the amount of information entered per transaction, and the number of "links" per transaction. Since businesses track different information, there is no "average" or "typical" data file size.
For example, someone who enters 500 1-line invoices per month might find their data file smaller than another person who enters 100 5-line invoices per month. In comparison, someone who usually receives five separate payments per invoice would have a larger file than someone who receives only one payment per invoice.
To estimate if QuickBooks is right for your small business, take the average number of monthly transactions (remember, an invoice, payment, and deposit would be three separate transactions, and a bill and bill payment would count as two) and multiply by 2 KB to determine how much the data file will grow each month.
For example, if your company enters an average of 300 transactions per 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 size is less than 15,000 KB, then QuickBooks should be more than sufficient for the company. (Present QuickBooks users can check the size of their QuickBooks file by pressing Command+1 on the keyboard.)
Note: The 2 KB multiplier does not include list information (which will grow as new names are added to the file) and is only an approximation that may not be a suitable estimate for all QuickBooks company data files.
If the performance of QuickBooks slows down, or you decide that you do not want to keep detailed transactions for prior years, you can condense a QuickBooks company data file. For QuickBooks 2007 - 2006 users, condensing the company data files is known as "Cleaning up data." For more information on cleaning up the company data file, refer to the article Cleaning up data. For QuickBooks 2005 users, condensing the company file is known as "archiving and condensing data." For more information on archiving and condensing the company file, refer to the article Archiving and condensing data.
Each list in QuickBooks Enterprise Solutions has a maximum number of items it can contain, as shown in the following table: