Sales Reports (CLIPxe Only)
AR Report:
Summary
The AR report will give you the Credits/Debits/Over 30s/Over 60s/Over 90s of your customers since the last billing period.
What can you do with this report?
Used as a quick financial reference to see how much in debits is left to be received from billing as well as totals.
Where can you find this report?
This report can be found at Reports>Sales Reports>AR Report
What does the report show?
Date Printed: Date the report was printed.
Account Number: Customer’s account number.
Name: Name of the property.
Billing Name: Billing name on the account.
Amount: This amount corresponds to the amount of that customer depending on which area of the report is being looked at. There are six totals. These totals are current, current as of last billing, over 30 as of last billing, over 60 as of last billing, over 90 as of last billing, and the total not yet received as of the last billing.
Phone Numbers: The phone numbers of the customers.
This report sorts by:
Customer Name: Lists customers alphabetically by property name.
Customer Number: Lists by the customer’s account number.
Other options:
This report has the options to:
Include Negative Balances: Shows the date that the report was printed.
Include Current Debits: Includes current charges for the customers.
Include Phone Numbers: This option allows you to include the customer’s phone numbers on the report.
Company Status Report
Summary
The company status report generates a current standing of your company's finances. This report represents balance forward customers only. We recommend qCLIPxe users refer to their accounts receivable reports in QuickBooks. If you are not showing customers contract amounts and you think that you should be, click the button below:
What can you do with this report?
This report summarizes billing, credit, debits, and new balances for the aging of all accounts receivable from current through 90 days. It compares amounts not yet received to amounts received but not applied from the last billing. It breaks down data on total customers to total jobs, residential versus commercial customers, contract customers, how many are on hold, and what is the value of your contract work.
Where can you find this report?
This report can be found at Reports>Sales Reports>Company Status Report.
What does the report show?
Amounts for Over 30, Over 60 and Over 90: This amount corresponds to the amount of that customer depending on which area of the report is being looked at. There are six totals. These totals are Current, Current as of last Billing, Over 30 as of last Billing, Over 60 as of Last Billing, Over 90 as of last Billing, and the Total Not Yet Received as of the last billing.
Billing: This column shows what your receivables were as of the last billing.
Applied Credits: This column shows which credits have been received since the last billing and how these have been applied to the accounts receivable.
Current Credits (Un-Applied Credits): These are payments that have been received but have not been billed to the customer. This would happen if you have received payment before closing the period. After closing, this amount is moved over to the applied credits.
Debits: This column shows all actual debits made to your customer's accounts since last billing. Usually, this is how much additional work that has been done to date.
New Balance: This shows your current balance of receivables at the moment.
Current Balance from Last Billing: These are customers that had a credit balance on their account.
Customers with Credit Balance: Customers with a credit balance. Gives at a glance the number of customers with a credit balance. The detailed report shows the exact same one as credit balances from last billing.
Amount Not Yet Received From Last Billing: This is the total that you can expect from the last statements you sent out.
Contract Work 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. It will meet the following criteria: (1) the customer is a contract customer, (2) the job is part of the contract, and (3) Done to Date does not exceed Max. Jobs per Year.
What information can I filter?
No particular filter options are setup. It depends on which option you choose to print.
This report sorts by:
There are no sort options.
Sales by Job Type
Summary
The sales by job type report will show you the total sales by the tax district/job description/job type.
What can you do with this report?
This report allows you to quickly see jobs that are bringing in sales for a given time period.
Where can you find this report?
This report can be found at Reports>Sales Reports>Sales by Job Type.
What does the report show?
Date Printed: Date the report was printed.
Report Options: Lists the report options used for the specific report.
Customer Number: Shows the customer’s account number.
Name: Shows the customer’s name.
Date: Shows the date that the job/service was performed.
Description: Shows a description of the job that was performed.
Totals: Totals will break down into Finance Charges/Non Taxable Sales/Taxable Sales/Total Sales. Depending on how the report is sorted, you will get totals for Tax Districts (Report by Tax District), Descriptions (Report by Description), and totals for Job Type (Report by Job Type).
What information can I filter?
Include Credits: Whether the report will show credits (customer payments) or not.
Date Range: Date range. Leave blank to see information for all dates.
Customer Number: 0 for all customers. Enter a specific customer to see the sales by job type for that customer.
Description: Report will check a specific job name.
Job Type: Report will show only a specific job type.
Taxing Country/State: Filter by the tax code.
This report sorts by:
Tax district: Tax district that was setup in the customer’s account.
Description: Job description that was setup in the customer’s job tab.
Job type: Job type from the customer’s job tab under job details.
Other Options:
Show Sub Totals: Will show subtotals depending on how the report is sorted.
Summary Only: Report will show only totals and no specific line items.
Daily Grosses
Summary
Daily grosses will break down totals by day and crew. If you are not showing customer's contract amounts and you think that you should be, click the button below.
What can you do with this report?
See totals for crews and days at a glance.
See efficiencies for a specific day.
Where can you find this report?
This report can be found at Reports>Sales Reports>Daily Grosses
What does the report show?
Start Date: The date that you want to start seeing information on this report.
Stop Date: The date when you want to stop seeing information on this report.
Date Printed: Date the report was printed.
Crew Range: Crew range that was chosen for the report.
Date: Date for the totals of the specific crew.
Crew: Crew that did the information on that line.
GL Amount: GL amount (value for contract or non-contract jobs) of work done.
Material Cost: Material cost associated with that line item.
Budgeted Man Hours: Total budgeted man hours for the crew.
Actual Man Hours: Total actual man hours for the crew.
Travel Time: Travel time for the crew.
$ per Man Hour: Dollar per man hour (amount of the job divided by number of hours it took to do the job) that includes travel time specific for the crews.
Totals: Totals of the Amount, Material Cost, Man Hours Budgeted, Man Hours Actual, Travel Time, dollars per man hour broken down by crew, day, and report totals.
What information can I filter?
Crew: Filter by a specific crew range
Date Range: Filter by a specific date
Include Project Work: Include work from projects module (separate module).
This report sorts by:
Daily Recorded Work Log: This will list the daily grosses for a crew by date.
By Date: This will list out Crew, Amount, Material Cost, Budgeted Man Hours, Actual Man Hours, Travel Time, and $ per Man Hour along with totals. Dates will be grouped together.
By Crew: This will list out Crew, Amount, Material Cost, Budgeted Man Hours, Actual Man Hours, Travel Time, and $ per Man Hour along with totals. Dates will be replaced and totals for the date range will be sorted by crew in ascending order.
Invoice Work Completed and Paid: This will list out work by crew and date depending on whether the information has been invoiced and paid (requires special invoices module).
Other options:
Print Summary: Totals only that are listed depending on report type.
Print Detail: Individual crew statistics based on report type.
All Credits and Debits
Summary
Shows all the credits and debits entered for the time period entered.
What can you do with this report?
Quickly see the credits and debits that have been entered.
Where can you find this report?
This report can be found at Reports>Sales Reports>All Credits And Debits Report
What does the report show?
Date Printed: Date the report was printed.
Date Range: Date range of the report.
Billing Name: Billing name on the account.
Property Name: Property name on the account.
Account #: Customer’s account number inside of CLIP.
Date: Date the transaction was entered.
Credit: The amount of the credit.
Debit: The amount of the debit.
Totals: The total amount of credits and debits.
What information can I filter?
Include Debits Type “D”: Debits with a tax type D will be included on the report.
Include Debits Type “L”: Debits with a tax type L will be included on the report.
Include Debits Type “M”: Debits with a tax type M will be included on the report.
Include Service Charges: Service charges for the date range.
Include Credits: Credits on the customer’s account for the date range.
This report sorts by:
Debit Type: Sorts by the type of debit (see above options under include debit types for more information).
Customer Number: Lists customers alphabetically.
Customer Name: Lists customers by property name.
Date: Lists transactions by the date of the transaction.
Total Debits: Lists by the date the job was done.
Total Credits: Lists by the date the job was done
Other options:
Detail: Shows a line item view which displays each transaction on a separate line.
Summary: Lists just the totals for the report (doesn’t show specific transactions).
Data to Excel: Sends the report to an excel sheet where it shows specific transactions.
Reprint Final List From ET
Summary
Reprints the final list of transactions report that prints out when posting transactions from Files>Enter Transactions or click Receive Payment icon on main screen.
What can you do with this report?
Quickly see the posted transactions, credits, or debits that were entered and posted for a given date range.
Where can you find this report?
This report can be found at Reports>Sales Reports>Reprint Final List from ET
What does the report show?
Date Printed: Date the report was printed.
Property Name: Property name on the account.
Cust Num: Customer’s account number inside of CLIP.
Date: Date the transaction was entered.
Amount: The amount of the transaction.
Code: The code is for the transaction code. Whether it was Cash/Credit, CC Refund, No Tax Dbt, Taxed Labor, Taxed Mtrls, or Write Note.
Description: The description that was entered at the time the transaction was posted.
What information can I filter?
Date Range: Date range of the report.
Serial Number: The serial number associated with the transaction. This typically shows up on the final list when posting a batch of transactions.
This report sorts by:
Sort Name: Lists customers by property name.
Other options:
Print to PDF: Saves the report as a PDF file after clicking the print button.
Sales Summary Graphs
Summary
The sales summary graph helps track your company's financial health. This report summarizes profits that are made from jobs that are generated from the annual sales.
What can you do with this report?
See a summarized graph of each annual sales the company has made.
Where can you find this report?
This report can be found at Reports>Sales Reports>Sales Summary Graph.
What does the report show?
Date Range: Date range of the report.
Dollars: The total amount of debits or annual sales for the period chosen.
What information can I filter?
Date Range: Date range for the sales period.
Crew Range: This option allows you to select a specific crew range for the report.
Job Number: This option allows you to select a specific job range for the report.
Customer Number: This option allows you to select a specific customer range for the report.
Include Inactive Customers: With this option checked, customers that have the on hold status will show.
Include Projects: With this option checked, projects that have been entered for customers will show. Include projects is for a special projects module -- please call sales for more information on projects at (800) 635-8485 ext 1 or email [email protected].
Summarize Sales: This will break down the graph based on Daily, Weekly, Monthly, or Annual sales.
Chart Type: This allows you to select what type of graph you want: Column, Bar, or Pie chart.
Other options:
Detail: Shows a line item view which displays each transaction on a separate line.
Summary: Lists just the totals for the report (doesn’t show specific transactions).
Data to Excel: Sends the report to an excel sheet where it shows specific transactions.