Is there a limit to the amount of data I can have in QuickBooks Online?
There really isn’t a file size limit in QuickBooks Online. QuickBooks Online uses an “as needed” approach to loading your data which means the overall size of the data file is not a major factor regarding performance. In addition, QuickBooks Online uses a processing method where some of the processing is performed online and some is done locally using your device processor & memory. Lastly, the speed of your internet connection plays a big part. Meeting or exceeding the System Requirements for QuickBooks Online impacts QuickBooks Online performance more than data size. We know your time is valuable to you and we continuously work to drive improved performance.
Are there limits on Lists, such as Accounts, Customers or Items/Inventory?
Using the same “as needed” approach listed above, large lists do not cause performance issues. You don't have to be concerned about entering too many customers, accounts, or items.
Are there limits on the number of transactions?
There are no transaction limits. There are millions of QuickBooks Online customers world-wide, many with large data sets. Some have well over 1 million transactions and many thousands of customers! Transaction complexity would play more of a role with regards to performance than an overall number. For instance, an invoice with a single item and no sales tax is not the same as one with multiple items and with sales tax applied. That said, there isn’t a hard limit on the number of transactions you can enter, nor is there a known ‘complex transaction’ limit.
While QuickBooks Online doesn't have file size, list or transaction limits, there are a few practical limitations to be aware of.
Character limits in fields
There’s a maximum number of characters you can enter in each field. Below are some of the most commonly used fields in QuickBooks:
|Amount (on all forms)||11|
|Customer, Vendor/Supplier, and Other Names||100|
|Custom field display name (on all forms)||15|
|Custom field (on all forms)||30|
|Description on Single Time Activity||4000|
|Item description (on all forms)||4000|
|Message displayed on invoice||1000|
|Message displayed on statement||4000|
|Notes in customer information||4000|
|Report company name||100|
|Transaction number (on all forms)||21|
Size limit when exporting a report to Excel
- Maximum of 1024 columns displayed
- Maximum 400k cells with data
- Maximum 10MB worth of data
Is your QuickBooks Online running slow?
Here are some tips to improve the performance of your QuickBooks: