This article will give you information about each report, what it does, and how to use it. Reports are important because you have to know that you are being successful in achieving your goal. If you aren’t measuring it, then you will never know how close or far you are from accomplishing your goal.  Jump to different sections of the manual by utilizing your "Find..." in your browser.
​
Reports are accessed via the "Reports" tab at the top of your screen.
​
​

The customer list report gives you a list of customers, including information regarding their monthly installments (payments) to you.

Provides a list of all of your customers in CLIPitc along with phone numbers you can call through your customer list for marketing purposes.

Gives you an idea of expected income from your installment customers.

Allows you to see how many customers you have on a street (if you sort by street name).
​

This report can be found under Reports, Customer Reports, Customer List.
​

Name: Displays the customer's Property Name
​Num: Displays the customer's Account Number Property
​Address: Displays the customer's Property AddressHome: Displays the customer's Home Telephone Number
​Phone: Displays the customer's Work/Secondary Phone Number
​Fax: Displays the customer's Fax Number
​Cell Phone: Displays the customer's Cell Phone Number
​

Customer Name: Sorts the customers in alphabetic order
​Customer #: Sorts the customers in numerical order
​Property Street: Sorts the customers by street name in alphabetic order
​Orientation:Portrait: Prints the report vertically
​Landscape: Prints the report horizontally
​Filter Option:Include Pattern Customers: This option allows you to include your pattern customers from the "Pattern Customers" screen
​Include On Hold Customers: This option allows you to include customers that you have put On Hold. Usually, these are customers that no longer do business with you.
​Show City/State/Zip: Check this box to show the customer's City, State, and Zip Code on the report

The history report gives you a list of work recorded, notes recorded, checks entered, installments processed, and skipped jobs.What can you do with this report?
​

You can see what transactions were entered for the customer based on the date range you enter.

Shows the customer’s balance for the date range that you choose.

You can find this report under Reports>Customer Reports>History.

Line #: The sequence number for when the line item was enteredDate: The date entered when posting the line item Amount: The amount that was chargedCode: Every line item has a code (see below)

Description: The name of the transaction recorded
​Begin Bal: This column shows what your receivables were as of the last billing.Debit: This column shows all actual debits made to your customers' accounts since the last billing. Usually, this is how much additional work that has been done to date.
​Sales Tax: This column shows the figure for all sales tax that will be paid to the state.
​Srv. Charge: This column shows the fee for service charges that will be applied.
​Credits: This column shows which credits have been received since the last billing and how these have been applied to the accounts receivable.

Customer #: Set this to the range of customers you are pulling the report for. (For all customers, select 1 to 9999)
​From/To Date: The date range you want for the report
​Show Job Value: This value represents the sum of the amounts from the Charge per field in Job Records that were posted as done in Record Work, and which meet the following criteria: 

The customer is a contract customer
The job is part of the contract
"Done to Date" does not exceed max jobs per year

Show Man Hours: This value represents the sum of the labor hours that the job was estimated and budgeted to take.
​Only Credits and Debits: With the filter selected, the report will only show credits and debits.
​Include Contract Jobs: With this filter selected, the report will include all contracted installments jobs.
​Include Skipped Jobs: With this filter selected, the report will include any jobs that have been skipped.
​Sort by Date: Allows you to sort the report by ascending or descending dates.

The Source Report lists total revenue prices given for customers by date range including customers on hold & project totals. If a specific source is not selected before running the report (leaving the pull-down menu blank), it will by default select all options for the source. The prices are then totaled together on the last page for all the sources selected. This report outputs the information to your screen first and then allows you to print.

View total revenue by source to see which marketing method is most effective.

You can find this report under Reports>Customer Reports>Source Report.

Source: The source that you got the customer from (referral, website, etc.)Customer #: The customer number assigned to that customerName: The name of the customerJob Charge: Total prices for customers listed in each Source category

Start/End Date: Displays the date range for the report Source: The source that you got the customer from (referral, website, etc.)
​

Include Customers On Hold: Check this to include customers that have been placed on holdPrint Option: A Detailed Source Report or a Summary of the Source Report with a smaller condensed summary of the detailed version

Note: This report only shows for those that bill out of CLIPitc without using QuickBooks. For those billing using QuickBooks, you will want to use the Accounts Receivable report inside QuickBooks. 

The Accounts Receivable Report shows any money owed to you by your customers for goods or services that have been delivered or used but not yet paid for. Accounts Receivables are created when a customer purchases your goods or services but does not pay for them at that time.

Businesses with accounts receivable typically issue invoices for their products or services at a later date. Accounts receivable is recorded in a business's accounting data as an asset. If a business has too many accounts receivable, it may not have the cash it needs to pay its bills. It's important to manage accounts receivable in order to maintain strong financial business health.
​

Find out where the company's money is going!

This report can be found under Reports, Customer Reports, Accounts Receivable.

Account No: Displays the customer's Account Number.Customer Name: Displays the customer's Property Name.Days Overdue: Amount of days the customer has not payed off the balance in full. This figure represents a past due amount for the customer.Amount: The amount of money the customer has that is considered overdue.

There are currently no filter options for this report!

This report will give the company a report so you can see what Sales Tax was processed from billing. Based on the sales tax areas or items setup, this will give the company a sales tax report showing how much sales tax was processed.

Note: This is a report for companies that are using CLIPitc for billing without QuickBooks.

See what sales tax was processed for the billing period.

This report can be found under Reports>Customer Reports>Sales Tax Report

Num: Customer numberName: Customer name who is being charged for sales tax.Date: Date that sales was applied on.Description: Description applied to sales tax.Taxes: Amount that was charged to the customer for sales tax.St: State for applying sales tax.

From Date/To Date: Displays the date range for the report. Filters by the Tax List that is setup under Customize tab, Tax List section.

The Sales Report shows you a list of sales that have been made during the course of time you set in the filters when building the report. 

This report shows new jobs that have recently been added to customers. This report will give information for jobs that have recently been sold to a customer. 

Use this report if you have a sales person on staff helping the company sell your services and to keep track of recent sales for the company.

This report can be found under Reports>Customer Reports>Sales Report

Crew #: Number of the crew or crew members that were on the job.Cust #: Number of the Customer's account.Cust Name: Property name of the Customer.Property Name: Name of the Customer's Property.Property Address: Address for the Customer's Property.Date Serviced: Date that the job was done on.Job #: Number of the job.Job Material/Description: Description for the Job Material that was applied to the job.Item: The QuickBooks item that is assigned to this job.Quantity: The Quantity is how much of the material is being applied to the job.Rate: The Rate is at what rate of the material is being applied to the job.Subtotal: This subtotal represents the total of jobs in this particular filter or range of jobs.Total: This total represents the entire total or amount of the particular jobs for the entire report.

There are no additional filters available for the Customer Sales Report.

That does it for Customer Reports. If you've not found the data you need in this series of reports please check out the Custom Reports tab and create your own custom report!

The Crew/Route Report is specified by a crew range to give details on when, where, & other info outlining the work that the crew has performed.

View details about a which crew is scheduled to do a specific job

Change information having to do with the crews or jobs. 

This report can be found under Reports>Job Reports>Crew/Route

Number: The crew's number
​Name: The customer that the crew worked for
​Job name: The name of the job that the crew performed
​Property Address: The address of the property where the job was done
​Route: The routing sequence number
​Next: The next scheduled visit date
​Freq: This is the number of days between jobs

Filters: Crew
​Range: The crew range you are pulling for the report
​Only Active Customers: Check this box to include only active customers
​Include Jobs On Hold: Check this to include jobs that are on hold
(You can sort the report by Route Number, Crew and Route, Street Name, Crew and Street, or Crew and Zip)
You can order the report either in ascending or descending order.

The Job Costing Report helps you find out which customers are the most profitable. It shows you how much money you made on each customer/job based on how much you charged the customer and how much time it took to do the job for the customer.

You can use this report for adjusting customer pricing for next season, and this is the key to finding out if your customers are profitable.

See which customers are most profitable per dollar per hour.
See which jobs are most profitable per dollar per hour
See which areas are most profitable per dollar per hour
See how much your travel time is costing you
Know which customers need to have their prices adjusted
Know which areas to expand into as a business (pull the report by job)
Know which customers to treat well, based on their profitability

This report can be found under Reports>Job Reports>Job Costing Report

Date: Date that the job was done
​Done #: The time that the job was done (1 would be the first time, 2 would be the second, and so on)
​Budget Time: Time that the job was budgeted to be done. This number comes from the Man Hour Rating under the Jobs tab under the select customer
​Actual Time: The actual amount of time that it took to do the job. This is based on the Start/Stop time that you entered when you marked the job as done
​Diff: The difference between the budgeted time and the actual amount of time that the job took
​Charge: How much you charged the customer for the job
​Job Value: Amount or value of the job.
​Material Cost: Material cost that is associated to the job.
​Travel: Travel time that was configured while recording the job as done.
​Average: $/hour: Average $'s per hour of the job.
​Avg. Hrs: Average hours that the job took.

Crew # Range: Narrow by crew
​Customer # Range: Narrow by Customer
​Job #: You are able to select any number of jobs in any configuration you'd like.
​Start Date: Filter by job start date

This report shows a call ahead.

Track which customers you have sent or would like to send a pre-service notification to.

This report can be found under Reports>Job Reports>Pre-Service Notifications Report

Date Printed: Date this report was printed on.Customer: This shows the customers who is setup for the notification.Property Name: This shows the property name of the customer who is setup for the notification.Job Name: This shows the job name of the customer who is setup for the notification.Start Time: This shows the start time of the job.Job #: This shows the job number.Man Hours: This shows the man hours setup on the job that is setup for the notification.

Crew Range: This allows you to select a specific crew range for this report
​Job Numbers: This allows you to select certain jobs for this report
​Date Range: This allows you to select a specific date range for this report

The Materials Report shows a list of jobs that have Materials/Chemicals that have been posted for the given date range.

See how much chemical/material has been used (does not include active quantity to print out on the report. For Chemicals see the chemicals report, or programs and rounds section).

See which customers have specific materials/chemicals and when they were applied

This report can be found under Reports>Job Reports>Material Reports

Part #: The part number assigned to the material/chemical
​Part Name: Name of the material/chemical
​Qty: Total quantity of the material/chemical
​Qty Type: Shows the measurement unit for the quantity (e.g. CubicYd, SquareFt)
​Date Used: Date the material/chemical was used for the job (posting date of job)
​Customer #: Customer number where the material/chemical was applied
​Customer: Name of customer where the material/chemical was applied
​Property address: Address where the material/chemical was applied
​City: City of the customer's property
​Zip: ZIP Code of the customer's property
​Crew #: Number of the crew that applied the material/chemical
​Job #: Number of the job that the material/chemical was used for

Target Organism: Name of the organism the material is treating, if any.

Method of Application: How the Material is applied (sprayed, set, poured, etc).

Material Type: Defines what kind of material it is, such as liquid, solid, gas, etc.

In the header of each column is a search bar that you can use to filter content.
You can also click the header of each column to sort the columns by that category.

That does it for Job Reports. If you've not found the data you need in this series of reports please check out the Custom Reports tab and create your own custom report!

The Employee Efficiency Report gives you efficiency information by employee. The Efficiency Rating at the bottom of each employee is broken down by efficiency during payroll hours and efficiency based on man hours.

Show the efficiency of the production crews and the members of each crew

Get an idea of how much money each employee is bringing in for each hour they are on your payroll

Allows you to see the jobs worked by each employee (depending on date range)

This report can be found under Reports>Employee>Efficiency Report

Crew Section-
​Name: Displays the customer's name
​Date: Displays the date that the job was done
​Job Name: Displays the name of the job that was done
​GL Amount Less Material: Amount paid for the job (for contract jobs, it is the job value minus material cost)
​Budgeted Crew Man Hours: Amount of man-hours budgeted for the crew for that day
​Actual Crew Man Hours: Amount of Man Hours the crew actually took to do the job
​Average Dollar Per Employee: Average dollars per employee (GL Amount divided by # of crew members)
​Total For: Totals for GL Amount, Budgeted Crew Man Hours, and Actual Crew Man Hours based on a specific date

Employee Section-

Employee Name: Name of the employee
​Budgeted Personal Man Hours: Man hours for one employee specifically (not calculating for entire crew)
​Actual Personal Man Hour: Actual man-hours for specific employees
​Payroll Hours: Hours clocked in for payroll
​Total: Totals for actual man hours, payroll hours, and revenue
​Efficiency Rating (Actual/Payroll): Efficiency percentage of actual personal man hours divided by payroll hours
​Efficiency Rating (Budget/Actual): Efficiency percentage of budgeted personal man hours divided by actual personal man hours
​Revenue/Payroll Hour Rating: Dollar amount of Total Revenue divided by personal payroll hours
​Revenue/Budgeted Hour Rating: Dollar amount of Total Revenue divided by personal budgeted hours
​Revenue/Actual Hour Rating: Dollar amount of Total Revenue divided by actual personal man hours

Summary Section-

Job Period: Displays job period information (start date/stop date)
​GL Amount Less Materials: Total amount (or value for contract jobs) of the jobs minus material cost (GL)
​Budgeted Crew Man Hours: Total amount of man-hours budgeted for the jobs based on the number of people on the crew that day
​Actual Crew Man Hours: Total amount of man hours the job actually took
​Average Dollar Per Employee: Average dollars per employee (GL Amount divided by # of crew members)
​Efficiency Rating (Actual/Payroll): Efficiency percentage of actual total man hours divided by total payroll hours
​Efficiency Rating (Budget/Actual): Efficiency percentage of budgeted total man hours divided by actual total man hours
​Revenue/Payroll Hour Rating: Dollar amount of Total Revenue divided by total payroll hours
​Revenue/Budgeted Hour Rating: Dollar amount of Total Revenue divided by total budgeted hours
​Revenue/Actual Hour Rating: Dollar amount of Total Revenue divided by actual total man hours

Start/End Date: This option allows you to set the start and end date of the report and can be sorted as such.
​Crew Range: This option allows you to select a specific crew range for the report
​Show Inactive Employees: This option allows you to show any employees that may have been deactivated during the time period
​Employee #: This option allows you to select a specific employee for the time period (leave this blank to include all active employees)
​Detail/Summary: If Detail is selected, each day will print out with each specific job that had been done. If Summary is selected, no history will be displayed on the report, only totals

The Employee Hourly Efficiency Report gives efficiency ratings (percentages) by date range/employee

This report can be found under Reports>Employee>Efficiency Report Hourly

Date Range: This will show the start date and end date of the options on the previous screen
​Crew Range: Displays the crew range selected on the previous screen
​Employee Name: Displays the employee's name
​Date: Displays the date of the time entries
​Budgeted Man Hours: Amount of man-hours budgeted for the day based on the man hour rating of the jobs
​Actual Man Hours: Amount of man hours that were recorded for this employee for the specific day
​Paid Hours: Hours the employee was on the clock
​Actual vs Budgeted: Efficiency percentage of budgeted personal man hours divided by actual personal man hours
​Actual vs Paid: Efficiency percentage of actual personal man hours divided by payroll hours
​Budgeted vs Paid: Efficiency percentage of budgeted personal man hours divided by payroll hours

Start/End Date: This option allows you to set the start and end date of the report
​Crew Range: This option allows you to select a specific crew range for the report
​Employee ID: This option allows you to select a specific employee for the time period (leave this blank to include all active employees)

You may also sort by-

Date: The first date that has recorded jobs in the crew range will display first, then the next date, etc..
​Sort On Actual vs Paid: Sort the reports out in order of actual time that the employee was working on a job versus the amount of time that you paid the employee to work.
​Detail/Summary: If "Detail" is selected, each day will print out with each specific day that has hours recorded. If "Summary" is selected, no history will be displayed on the report, only totals.

The payroll report will give you the pay hours for your employees. The total pay hours will appear at the bottom of the Pay Hours Screen

Allows you to quickly look over pay hours to find discrepancies.

This can be printed for data entry into your payroll program or sent to a payroll company.

Employee Name: Display employee name.Emp Type: Employee type fields identifies the employee ( labor, production, worker, etc ) to a specific duty or job that they perform for the company.Pay Freq: How often does the employee get paid.Rate/Sal: What is the pay rate.Hours/Credits: Labor hours/credit hours the employee has worked.OT Hours: Overtime hours the employee has worked.Comments: This is a section for comments or notes to leave for the office/payroll company regarding this employee.

Start Date/Stop Date: This option allows you to set the start date and stop date of the report.
​Pay Based on time clock: This option gives the pay based on the stop/start time entered.
​Pay based on budgeted man hours: This option gives the pay based on the budgeted man hours.

A Route Sheet is a printable preview of the work that a crew or crew members need to get done. This sheet can also be called a Work Order.

Route Sheet can be found in two different places: from Reports>Route Sheet or from Daily>Print Route Sheet

Depending on which layout chosen during the filter options, route sheets in CLIPitc show a header at the top and the job information below.

Phone Number: Phone number of the customer
​Next Visit: Next scheduled visit date of the customer's job
​Route Number: Route Number assigned to the customer's job

You may also sort by-

Crew and route: Sorts by crew number first then route number
​Customer Name: Sorts the jobs by Customer name

SummaryThis report will allow you to reprint any statements you've generated for your customers.

Note: This option is only for companies that bill out of CLIPitc without using QuickBooks and want to reprint statements from the billing process.

Route Sheet can be found in two different places: from Reports>Reprint Statements

The Crew Route Map report shows the crew specified on a google map inspired route. This way companies will be able to view where the crew is going on a map.

This report can be found under Reports>Employee>Crew Route Map

Date: Specified date to show the scheduled jobs for.
​Crew #: Specified crew number to show the route map for.

That does it for Employee Reports. If you've not found the data you need in this series of reports please check out the Custom Reports tab and create your own custom report!

If you have any questions please visit our Help Center or log into chat at the bottom of the page at CLIPitc.com. We are more than happy to answer any questions you may have.