Other QuestionsQuickbooksQuickbooks Online

QuickBooks Online file size and feature limits in 2020

Have questions about the limits of what your QuickBooks Online account can handle? Check out our Frequently Asked Questions regarding technical limits, file sizes, transaction volumes, and data entry. QuickBooks Online file size and feature limits in 2020

QuickBooks Online file size and feature limits in 2020

What are the file size and feature limits on QuickBooks Online?

Is there a limit to the amount of data I can have in QuickBooks Online?

No, there isn’t a file size limit in QuickBooks Online.

Does the amount of data I have on QuickBooks Online affect performance?

QuickBooks Online loads your data as needed, which means the overall size of the data file doesn’t substantially affect 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 and memory. Lastly, the speed of your internet connection plays a big part. Meeting or exceeding the System Requirements for QuickBooks Online improves QuickBooks Online performance more than file size.

Are there limits on lists, such as accounts, customers or items/inventory?

Using the same “as needed” approach listed above, large lists don’t cause performance issues. You don’t have to worry about entering too many customers, accounts, or items.

Are there limits on the number of transactions? Can transactions affect performance?

There are no transaction limits. As far as performance is concerned, transaction complexity has more impact on performance than transaction volume. For instance, an invoice with a single item and no sales tax is less complex than one with multiple items and with sales tax applied. But unless you are processing a large volume of transactions that are also very complex, the effect on performance should be minimal.

What are the technical limitations of QuickBooks Online?

While QuickBooks Online doesn’t have file size, list length, or transaction limits, there are a few practical limitations to be aware of such as character limits in fields, size limits when exporting a report to Excel, and technical issues that can slow your QuickBooks Online experience. QuickBooks Online file size and feature limits in 2020

What are the 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:

FieldCharacter limit
Account name100
Account number7
Amount (on all forms)11
Customer, Vendor/Vendor, and Other Names100
Custom field display name (on all forms)15
Custom field (on all forms)30
Description on Single Time Activity4000
Employee name25
Item description (on all forms)4000
Item names100
Memo4000
Message displayed on invoice1000
Message displayed on statement4000
Notes in customer information4000
Project name80
Project notes1500
Report company name100
Report title192
Transaction number (on all forms)21

What are the size limits when exporting a report to Excel?

  • Maximum of 1024 columns displayed
  • Maximum 400k cells with data
  • Total 10MB worth of data

What should I do if my QuickBooks is running slowly?

There are various things you can do to make sure your QuickBooks is running at peak performance.

  •   Ensure your web browser is up to date.
  •   Check to see if there are critical performance updates for your operating system.
  •  Run an internet speed test. We recommend using Google Speed Test for checking connection bandwidth.