The Count function can be used to count the number of entities with specific values.


  • Entity type: Type of entity to count (select from a list that includes Account, Customer, Invoice, Payment, etc)
  • WHERE: Filter entities to count based on the value of their properties. For example, to return the number of accounts that are of type Bank, type AccountType='Bank'.

Also see

QuickBooks Documentation