Call Now 866.456.9326 or Sign Up for a free 14-day trial! Terms of Use   Privacy Policy   Site Map

Enter Your Hours Logo

Complete Billing Software

Quickbooks Integration McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Online Payments
Online Time Sheet Billing Software

Filtering/Search/Sorting Clients

Table of Contents  > Managing Clients > Filtering/Search/Sorting Clients

Truly one of the most powerful features throughout the EnterYourHours.com System is the ability to filter, search and sort. Filtering, searching, and sorting clients is similar to filtering, searching, and sorting on any other part of the system.

Sorting Clients

To sort, click on the header for any of the following fields: Client Code, Company Name, Contact, Hourly Rate, Cost, Revenue, Gross Profit, and Gross Profit %. The first time you click on a header, the list will be sorted in ascending alphabetical order (A->Z) based on the column you clicked, and the second time you click the same column, the list will sort in descending order. Every time thereafter, will toggle between the two.

If you are changing sorts between multiple columns, keep in mind that clicking on another column will reset all other columns to sort ascending the next time they are clicked.
Filtering and Searching Clients

Filtering and searching is really the same thing, but it might help to think of each separately. Both are accomplished via the Filter form by clicking the Filter button on the Clients toolbar:

Filter Button on the Client Toolbar:
EnterYourHours.com Filter Button
Filter

Filter Form:
EnterYourHours.com Client Filter Form

If you need to find a particular record, you might want to use the Key Word option, or you can input more extensive criteria by using other options in the Filter Form.

Below is a detailed list of all the filter options:

Client Code: The Client Code option allows you to do a wildcard search on the client code.

Key Word: The Key Word option allows you to do a wildcard search on the contact names, company name, and contact emails of the clients. If the word or phrase you enter is found anywhere in these three fields, that record will be included with the results.

Hourly Rate: The Hourly Rate option allows you to enter a minimum hourly rate, a maximum hourly rate, or both a minimum and maximum hourly rate. If you only enter a minimum hourly rate, it will show clients whose hourly rate is at or above the minimum hourly rate. If you only put in a maximum hourly rate, it will show those clients whose hourly rates are at or below the maximum hours rate.

Lifetime Cost: The Lifetime Cost option allows you to filter based on the total dollars you have paid to workers for a client. You can enter a minimum lifetime cost, a maximum lifetime cost, or both a minimum and maximum lifetime cost. If you only enter a minimum lifetime cost, it will show clients whose lifetime cost is at or above the minimum lifetime cost. If you only put in a maximum lifetime cost, it will show those clients whose lifetime costs are at or below the lifetime costs.

Lifetime Revenue: The Lifetime Revenue option allows you to filter based on the total dollars you have collected for a client. You can enter a minimum lifetime cost, a maximum lifetime cost, or both a minimum and maximum lifetime cost. If you only enter a minimum lifetime cost, it will show clients whose lifetime cost is at or above the minimum lifetime cost. If you only put in a maximum lifetime cost, it will show those clients whose lifetime revenue are at or below the lifetime revenue.

Lifetime Gross Profit: The Lifetime Gross Profit option allows you to filter based on the total earnings you have made from a client. You can enter a minimum lifetime cost, a maximum lifetime cost, or both a minimum and maximum lifetime cost. If you only enter a minimum lifetime cost, it will show clients whose lifetime cost is at or above the minimum lifetime cost. If you only put in a maximum lifetime cost, it will show those clients whose lifetime gross profit are at or below the lifetime gross profit.

Active: Please refer to the Deactivating and Reactivating Clients topic for more information about this option.


Related Topics:
Managing Clients: Quick How To
Working with the Client List
Client Detail Page: Explanation of Fields
Adding/Editing a Client
Deactivating and Reactivating Clients
Project Presets
Client / Worker Rate Overrides
Blocking/Unblocking Clients from Workers
Printing the Client List
Exporting the Client List


Home |  Free Trial |  Features |  Software Reference |  Tours & Tutorials |  Pricing |  FAQ |  Quickbooks Integration |  Terms of Use |  Privacy Policy |  Site Map |  Blog

Enter Your Hours, LLC © 2008 - 2009. All Rights Reserved.
7/1/2025 5:53:08 AM