Limits for Customers and Vendors

HAM9 · ‎August 14, 2020

In QBO Plus is there a limit as to the number of Customers and Vendors?

I am looking at a scenario where we want to track Customers and Payees/Vendors where Customers are Beneficiaries and Vendors are Schools/Colleges/Hospitals etc. As a Charitable Society there could be tens of thousands of Beneficiaries and Schools/Colleges/Medical facilities that need to be tracked as far as expenditure towards Donation/Charity Expenses go.

So I ask: In QBO Plus is there a limit as to the number of Customers and Vendors? Can it accommodate hundreds of thousands of Customers and Vendors.

If answer is no or no way near I better not start to create and track by Customers & Vendors all sorts of charitable expenditure.

JenoP · ‎August 15, 2020

There's no actual limit with regards to how many customers you can add in QuickBooks Onine, HAM9.

The same for for the number of projects you can attach to a customer.

However, it may affect the software's performance if you have tens of thousands of customers and projects. The more data you have in QBO, the longer it may take for the program to open pages. Check out these articles for more details: Why is my QuickBooks Online slow?

Let me also share these guides about managing customer list:

Let me know if you have other questions.

View solution in original post

HAM9 · ‎August 14, 2020

Further to the question above is there a limit under Projects. Can we create tens of thousands of Projects for a client?

We can have a generic client called Applicant/Beneficiary. That way we can keep Beneficiaries clubbed under one Customer so that rest of the Customers can be used for Billing rent paying Tenants which rent is a source of income for funding charities.

JenoP · ‎August 15, 2020

There's no actual limit with regards to how many customers you can add in QuickBooks Onine, HAM9.

The same for for the number of projects you can attach to a customer.

However, it may affect the software's performance if you have tens of thousands of customers and projects. The more data you have in QBO, the longer it may take for the program to open pages. Check out these articles for more details: Why is my QuickBooks Online slow?

Let me also share these guides about managing customer list:

Let me know if you have other questions.

HAM9 · ‎August 16, 2020

@JenoP : Okay suppose we say that tens of thousands or beyond is going overboard, what is the acceptable limit of transactions (I want some concrete numbers - Suppliers, Customers, Invoices, Bills, Expenses, etc etc) that QBO Plus can handle without performance issues and without it slowing down?

I tested as follows -

In one set of books with little data (about a dozen customers, 2-3 Vendors, with about dozen invoices and about 30 other transactions) it behaved normally.

In another set with about 20-30 Customers with open balances and 5-6 adjusting Journal entries including Opening balances, the system was noticeably slow than the former.

And this is after ruling out Chrome and other issues. I am wondering what would happen to QBO database of the latter if real day to day transaction would start kicking in after opening balances / data migration? I read in some QBO post that acceptable performance is 10 seconds for every click to load a page. IF THIS IS THE CASE IT IS AN IMPENDING NIGHTMARE

Kindly reply with honest answers.

Topics

Training

Community

Resources

Limits for Customers and Vendors