NavBar - Reports

Commissions

The commissions report allows you to do an overview of:

• Sales
• Average Order
• Closing Percentage
• Dollars per lead

If you are not using the Daily_Management_Report, this will provide quick feedback.

 

Orders

The Orders Report allows you to Search and Filter down Orders to get data from multiple criteria on any order. 

Item Filter: Allows you to search for specific items sold in your catalog.

Primary Job Type : allows you to choose a primary job type and run a report based off of it. </label>

Lead Source: How did you hear about us?: Allows a report to be ran based off of Marketing Sources

Lead Source: How did you get our num?: Allows a report to be ran based off of Marketing Sources

Order Status: Allows you to search by the current state of the Invoice / Estimate / Order

Payment Status: Allows you to search by the current state of payment on an Invoice / Order

Costing Complete: Allows you to search by the current state of Job Costing done on the Order

Start Date: Set a Date Range

End Date: Set a Date Range

Date Type:There can be multiple type of dates in  ThermoGrid, such as the Date an Order was Created or the Date it was Costed.  This allows you to choose between those options. 

Created By:Give you the option to filter based on User

 

Example of Report:

 

 

Payroll

In ThermoGrid the Payroll report is used as a reference point for doing payroll and not as a direct connection into your Users bank account. 

What you can see here:

Orders:

All Orders with Date earned on Job Costing will show up on the Orders in Payroll.  In the Image below you can see an explanation from the Job Costing page on how Date earned ties into Payroll. 

Any Orders in the List can Easily be reviewed by clicking on the Order Number.   

Commission & Task-based Labor

Commission = If the rep is paid commission their commission will show up here.

• Check mark on the left = This will default checked and if you are going to pay the rep for the job leave it checked and click "Mark Orders As Paid". If you are not paying on a job or two just uncheck and the order will show up in the next payroll.
  

Labor = If the rep is on task pay they will have a labor amount show up here. 

• Checkmark on the left = This will default checked and if you are going to pay the rep for the job leave it checked and click "Mark Orders As Paid". If you are not paying on a job or two just uncheck and the order will show up in the next payroll.
  

If they are not showing up for commission or labor they should receive check 2 things:

1. User Setting is set to task or both.  Manage Users

 

2. Click order number to the left and make sure they are selected as "Technician who performed the labor" for labor or "Sales Technician" for sales commission or "Technician who generated lead" for lead generation fee.

 

 

Time Keeping:

Regular Hours = These are all the hours that are not overtime or PTO in the date range you selected and the time clocked on the Timesheets.

Overtime Hours = These are all hours marked as overtime based on Payroll Settings and the time clocked on the Timesheets.

Total Hours = This is the total Hourly, PTO, UPTO, & Total.

Job Hours = Time clocked in to jobs, if you click the number it will show you the hours by the Job Type so you can departmentalize your labor.

Efficiency = This shows you the percentage of time clocked into jobs vs total time clocked in to the day. If they are at 50% this means they are only on jobs half of the time they are clocked in at work.

Revenue Per Hour = This is all the revenue they bring in divided by all hours they clocked in. 

Minimum Wage = If someone is on task pay this will track minimum wage for you to keep you legal.

User Wages = This is how much they will get paid based on their hourly rate... Manage Users

optional if user is requesting time off in pay period:

Paid Time Off = This is hours they get paid on based on the PTO they have in their account... Manage Users

Unpaid Time Off = This will be the total time they took off that was not covered under PTO.

 

Compensation Requests:

 this will show all compensation request from the user the date of the request the amount the number of requests and if they are paid or unpaid.    you are able to Click on the Comp request button te review any compensation requests that are pending or need to be edited.

 

Memberships

 

 

 

Go to:

• Reports
• Memberships

If you want to see all memberships due right now.

• On the right side change Show Due to only.

If you want to see all memberships due and over due.

• On the right side change Show Due and Show Overdue to only.

If you want to message all clients in a report.

• Click Contact Clients and choose the template you wish to send. To create a new template go to  Manage Communications.

Sort by zip code = Run a report of memberships you want to see, click "Export to Excel" then you can sort by zip code column.

Filter Plans = Here you can choose one or more plans to report on, this will default to all plans.

Show Expired = You can choose to see expired memberships as well as active. Yes, No, Only

Show Canceled = You can choose to see canceled memberships as well as active. Yes, No, Only

Show Fulfilled = You can choose to see fulfilled memberships as well as active. Yes, No, Only

Joined Date = You can select a date range to see all that joined in a particular date range.

Expired Date = You can select a date range to see all that Expired in a particular date range.

Canceled Date = You can select a date range to see all that canceled in a particular date range.

Last Contacted Date = You can select a date range to see all that were contacted in a particular date range.

Visit Date = You can select a date range to see all that have visits in a particular date range.

 

 

To export a list of all memberships with addresses.

 

Memberships need to have equipment (M#, S#) to pull addresses in the report.. Here's why.

A client could have multiple locations and one membership... To keep things consistent we know we have 3 things...

 

Client

Locations (Addresses)

Units (Equipment)

• Memberships are tied to the Units
• Units are tied to the Location
• Address is tied to the Client

 

 

 

Timesheets

Timesheets

Payments Report

From here you can see a lot of areas including:

• Payments Taken
• Payments Coming Up
• Revenue From Agreements
• Revenue From Invoices

Search By:

• Orders (Order Number)
• Memberships (Types)
• Date
• Client Name
• Company Name
• Payment Type
• Credit Card Transactions (And Status)

How to use the report.

First get familiar with the page.

Click Refine results

This will drop down 4 sections for filtering down a search.

1. General

• Records = Choose Orders or Invoices
• Client = Search By Client name or Company Name
• Date Range = Select date range for payments you wish to see
• Type = Payment Type (Cash, Check, Credit Card. Financing)

2. Transaction (Credit Card Processing)

• Authorization (Approved, Retry, Declined)
• Captured (Accepted, Queued for Capture, Authorized, Rejected Etc.)
• Charge (Amount charged to the client by credit card)
• Amount (This is the Amount area on Order Estimate. This could be other payment types other than Credit Cards)

3. Refine Orders 

• Use date ( Created, submitted, Job Costed, Installation) What ever date type you select is what it will search by.
• Order Number (This will search  for or include the order number in your results, if you just want to see the one order that matches make sure you select Orders under Records in the General Section)
• Option (Payment Method from the Order Estimate) 

4. Refine Memberships

• Use Date - (Charge Date)
• Membership Plan - ( Type of membership yu want to search for)
• Options - (Reoccurring Payment)

* Example Reports

Example 1:

Want to see all revenue that came in month to date by credit cards.

1. Click Refine results
2. Under the section General put in the first of this month in "From" and current date in "To"
3. Change "Type" to Credit Card
4. Apply Filters

This will be all payment Methods setup as credit card. To setup payment types to the proper type go to:

• Payment Transfer to QuickBooks Options
• Payment Transfer to QuickBooks Option

Example 2:

Want to make sure your techs Authorized payments for credit cards so you get the payment?

• Click Refine results
• Under the section Transactions change Authorization to "Approved" and Capture to "Queued for Capture"
• Apply Filters

This will show you payments that are just waiting for you to click Capture to make the payment go through.

Example 3:

You want to see all subscription/scheduled payments that will go from now til the end of the month?

• Click Refine results
• Under the section General change Records to "Memberships"
• Under the section General put in todays date in "From" and the last day of the month in "To"
• Apply Filters

</youtube>

</div> </div></div>