Reports

123Pet management software includes over 200 built-in reports and the ability to create custom reports. The built-in reports are easy-to-use and, in most cases, require a selection of a few options before running the reports. Below is a list of some of the built-in reports:

Built-In Reports

Category	Report Title
Totals	Profit and Loss Sales by Range of Days Sales by Day of the Week Sales by Day Sales by Month Sales by Year Sales by Employee for Range of Days
Pets	All Pets Totals by Breed and Type Pet Info on Open Tickets
Clients	Referral Type for New Clients vs. Employee Survey of New Clients Items Sold and Client Names Clients Referrals - All Clients Referrals - Not Credited General Report / Mailing / Mail Merge Top Spending Clients Employee vs. Client Gender Clients with a Default Discount City vs. Spending Referral Type for New Clients vs. Employee Clients by First Visit Date Clients by Last Visit Date Clients by Number of Visits New Client List Clients by First Name Clients by Last Name
Products	Product Sales Statistics Quantity of All Products Sold vs. Employees Profit of All Products Sold vs. Employees Quantity of a Single Product Sold vs. Employee Profit for a Single Product Sold vs. Employee All Tickets Containing a Specific Product or Service
Services	Service Sales Statistics Quantity of All Services Sold vs. Employee Profit of All Services Sold vs. Employee Quantity of a Single Service Sold vs. Employee Profit of a Specific Service sold vs. Employee Tickets Containing a Specific Product or Service
Tickets	Ticket Averages per Employee Tips Claimed by Ticket Tickets with Discounts Tickets with Returns Tickets vs. Client Referral Types Ticket Payment Types All Open Tickets Unconfirmed Open Tickets
Employees	Employee vs. Client Count Employee's Clients Tips Claimed by Employee (Summary) Tips Claimed by Employee (Details) Sales Percentage of Products and Services Maintained Summary Hours Worked Based on Time Clock Entries Hours Worked Based on Time Clock Entries per Day Percent of Clients Retained by Employee Employee vs. Client Spending Employee vs. Sales
Gift Certificates	Gift Certificate Statistics Gift Certificate Statistics by Month Tickets Using Gift Certificates
Coupons	Percentage of Coupons Returned Tickets Using Coupons
General Ledger	Products Received Ordered by Date Products Received Ordered by Product Products Received Grouped by Product (Simple) Products Received Grouped by Product (Detailed) Products Received Grouped by Date Products Received Grouped by Category Products Received Grouped by Vendor Non- Products Grouped by Description Non- Products Grouped by Category Non- Products Grouped by Vendor Non- Products Grouped by Description (Checks only) Non- Products Grouped by Category (Checks only) Non- Products Grouped by Vendor (Checks only) Search by Product ID Search by Category Search by Vendor Checks Ordered by Check Number Checks Grouped by Category Checks Grouped by Vendor
Miscellaneous	Gum Label List

Creating Custom Reports

123Pet management software allows you to create your own custom reports. There is no limit to the number of reports that you can create.

You can create your custom reports by basing them on the built-in reports that come with 123Pet management software. You can do this by pressing the Import button while editing or adding a custom report. To create your own report, you need to understand Structured Query Language. The Structured Query Language, or SQL, is a series of commands you use to specify what information you want in your report.