Quickbooks

QuickBooks Online file size and feature limits in 2021

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

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:

Field Character limit
Account name 100
Account number 7
Amount (on all forms) 11
Customer, Vendor/Vendor, and Other Names 100
Custom field display name (on all forms) 15
Custom field (on all forms) 30
Description on Single Time Activity 4000
Employee name 25
Item description (on all forms) 4000
Item names 100
Memo 4000
Message displayed on invoice 1000
Message displayed on statement 4000
Notes in customer information 4000
Project name 80
Project notes 1500
Report company name 100
Report title 192
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.
Share
QuickBook Experts

Recent Posts

How to Record transactions for a property management company in Quickbooks

Learn how to record transactions for rental properties you manage and for your own management… Read More

3 years ago

Create a non-taxable reimbursement payroll item in QuickBooks in 2021

Learn how a non-taxable reimbursement payroll item can be created in QuickBooks Desktop payroll. In… Read More

4 years ago

Change your email, user ID, or password for QuickBooks Online and QuickBooks Self-Employed

Learn how to change your email address, user ID, or password for QuickBooks Online or… Read More

4 years ago

Downgrade your QuickBooks Online Plan in 2021

Get help to downgrade your QuickBooks Online plan. in 2020. You can always choose what’s… Read More

4 years ago

Recover your account when you can’t sign in

Find out what to do if can't sign in to your account for QuickBooks, Payroll,… Read More

4 years ago
} } }

Hit the 'Yes' option to get the best experience.