Skip to main content
Managing Reports

Create new, filter, share, schedule and save your reports from your dashboard.

J
Written by James N
Updated over 4 months ago

Creating a New Report

For quantitative data, our reporting suite allows you to view the most important metrics that run your business. Whether you need to see incoming revenue or your techs' reviews, we have a report to help. You can find up to 40 separate out-of-the-box reports you can use instantly. Start by figuring out which data set you want to look through (customers, estimates, jobs, etc) and then determine which metric is most important in the report (revenue, average ticket size, conversion), or the best way to view your data (by date, lead source, etc).

Open up your 'Reporting' tab located at the top of your navigation bar.

From here, start by figuring out which data set you want to look through (estimates, jobs, etc). These options will be located on the left side under 'REPORTS'.

You can determine which metric is most important in the report (revenue, average ticket size, conversion), or the best way to view your data (by date, lead source, etc). All of these options will be located to the right under 'Jobs'

Each of our reports allows you to update date ranges, date type, table columns, and graph type while filtering out the information that's not relevant. Once you have the report you want, you can save it and go back using your Custom folder.

Using Filters in Reporting

The first step in analysis is making sure we are looking at the right data when we pull up a report. If I want to know which jobs made less than $100 last week, I probably do not want to look at 3 years’ worth of jobs. Changing our report parameters and filters makes data more digestible, and analysis more efficient.

Filters can also help us hone in on a specific job characteristic. If we want to see how much we made on water heater replacements I can filter by job type to weed out jobs I don’t want to see. If I want to see how many incomplete jobs are in the system, I could change the filter to avoid completed jobs.. I could take it a step further to see which of those jobs are assigned to me by also filtering which employee I’m looking at.

What are report filters?

Filters in reporting answer the question what data do I want to look at? Each filter acts like a removal service, taking out any jobs or estimates that don’t fit the criteria we set.

Start by navigating to any report, and selecting the blue 'FILTER' button. This will open up your filter menu. Each time you apply any of the filters, you are eliminating a subset of your data from your report.

Filter Example

  • I want to see if any of my completed jobs last week are unpaid

  • First I set my date range to last week

  • Then I make sure my action date is set to completed since I am checking on completed jobs only

  • I use the due amount filter to see if any jobs have a due amount greater than $1

Changing report output

You can also customize the metrics that are included in the report's table. To add or remove metrics from a report, click on the 'EDIT COLUMNS' button under the report graph. From there, select or un-select the metrics that you wish to show in your table. Click the blue 'SAVE REPORT' option in the bottom right of the pop-up to apply the changes to your report.

You can change how the data is displayed in the table. You can sort data by date (day, week, month, quarter), employee, business unit, job type, job tag or lead source. To change how data is displayed, click on the drop-down next to 'Displaying jobs' at the top of the report graph.

You can now display jobs by selecting the date type from the drop-down options:

  • Created

  • Scheduled

  • Completed

  • Paid in Full

Changing metrics on the report display

You can display any of the metrics included in your report on the graph. To change the metric displayed, click on the drop-down menu on the top right of the graph.

Drilling into job details

To view any individual job corresponding to a row in the table, click on that row. To view all jobs that meet your report filters, click on the total row in the table.

In our reporting table, our top line is always a summation of the data represented in a total line, with our grouped components underneath. In order to see what data makes up either the total or any of the individual groups, we can click to dive deeper.

Let’s say we are looking at monthly jobs report that is grouped by business unit:

  • You can click on any row in the reporting table or the report graph to drill into jobs that correspond to a certain business unit

  • Click on the total row to see all jobs in the report

  • Once in the drill down table, you can change the columns that you see, export the data, or click into the job details

  • Coming soon: search and filter in the drill down table

Drill down example:

  • Let’s say I want to compare my HVAC vs. Plumbing departments

  • I opened a business unit report, but the margin seems off for Plumbing. I want to see the jobs driving this so I click into Plumbing

On your main Reporting tab, select Jobs under the all reports section. Select 'Business Unit' under the type of job report. Click on 'Edit Columns' located to the bottom right of the report graph to filter by your desired results. For example, you can select average job size, job cunt, job revenue and profit margin. Select 'Save'. Click into the row of your desired business type. For example, Plumbing, HVAC, etc.

The next screen provides a table that includes information about the job such as:

  • Invoice Number

  • Customer

  • Address

  • Billed to

  • Additional Segments

  • Job completion Date

  • Total Travel Time by Employee

  • Paid Amount

  • Job Lead Source

  • Job Type

  • Labor cost and Labor Cost Percentage of Revenue

  • Material Cost and Matrial Cost Percentage of Revenue

  • Profit Margin

  • Job Revenue

  • Job Tags

Note: If you want to add/edit or remove any piece of data from the report, click the 'Edit Columns' option in the upper right hand of the screen and select 'Done'.

You have the option to export your report by clicking the 'Export' option in the upper right hand of the screen next to edit columns. You can also click the job from the report and you will be directed to the jobs detail page to review the line item details further.

Saving a custom report

If you've customized your report, you can save your changes and return to the same report later. Once you've filtered, sorted, or changed metrics on the table or display, you can save this version to your reporting tab. After a report is saved, it will be added to your reporting tab on the "Custom" page.

To save the report, click on the blue 'SAVE REPORT' button at the top right of the screen. Name the report and then select the blue 'SAVE' option to officially save the customer report.

Reporting Date Ranges

How to focus your data using action date and date ranges.

In Housecall Pro, you have the ability to look at your jobs, revenue, performance, and more over any date range. This means you can look at last quarter’s revenue, how many upsells your technicians made this month, or even how many jobs were performed last year. Understanding how dates are assigned and how to update your report parameters makes finding the data you want easy.

Understanding Date Range

Whether you are looking at a default or saved report, or any reporting dashboard, you will be able to adjust a date range to focus your data.

Check the top left corner of your report above the report graph, to see the current date range being reported on. Use the drop-down to select a pre-set date range, or set your own using the custom range option.

Note: Date ranges are all dynamic and will update based on your current week, month or year (ex. Year to date will always be January 1st of this year through today)

Date Ranges:

Today = any data that is marked with today’s date (ex. Revenue for today’s jobs)

Week to date = all data from the most recent Monday through today

YTD = data from Jan 1 to today

MTD = data from first of this month to today

QTD = Quarters are defined as:

  • Jan - Mar

  • Apr - Jun

  • July - Sep

  • Oct - Dec

Last week = most current full week (Monday - Sunday)

Last month = most current full month (1st - last day of last month)

Setting custom ranges:

By choosing custom range you can set whichever date range you want. You can look at the last several days, forecast using anything already scheduled in the future using next x amount of days, or just set to and from range using the calendar.

Action Date

Right beside the date range in most reports, is a drop-down for action date. In Housecall Pro, some data will have a different date depending on the action you are referring to. When was the job scheduled for? When was the estimate created? When was the service ultimately completed?

  • Every job or estimate has three dates attached to it - when it was created, which date it appears on the schedule, and when the job was completed

  • Action date allows you to define how you want to see your data

    • Created = jobs created during the date range

    • Scheduled = jobs scheduled during the date range

    • Completed = jobs created during the date range

  • Jobs will not show in your report if the action did not happen during the range you selected

Action Date Example

  • I created a job today. My report will use the date of today if I set my action date to Created

  • I schedule the job for next Tuesday. If I run a report with the date range today and set my action date to Scheduled it will not show. I will need to update my date range to include Tuesday for the job to appear on the report. The report will use Tuesday as its date

  • If I run a report with completed it won’t show in the report regardless of the date range because the job has no completed date (Completed date = empty)

  • I want to see the revenue attached to jobs on the schedule for next week

    • I go to the reporting tab and open the jobs tab

    • I open the weekly report as I want to see data by week

  • I change the date range to see the next week

  • My report is empty! So what’s wrong?

  • I need to update my action date from Completed to Scheduled since I want to see the jobs scheduled for next week

How to Share and Schedule Reports

Schedule reports to run and send whenever it is convenient for you! Share with any of your report-using teammates.

With our new schedule and share functionality in reporting, digging into your data with scheduled reminders and informing others of progress is easier than ever. In reporting you will now be able to schedule your reports to automatically send to your email and/or another peer in your organization when they are truly needed, getting you access to your numbers without having to log into Housecall Pro, or recreate/update reports. Upon the scheduled or sent date, a PDF version of the report will be available, with a quick link to jump back into HCP to see the data first-hand.

Accessing the Share and Schedule Menu

First, hover over to your Reporting tab in the main navigation menu on your Housecall Pro home page. Click into any report through your report menu, or by clicking into a report on any dashboard.

From your report, click into the blue 'SHARE AND SCHEDULE' option to open up the menu.

Note: before a report can be scheduled or shared it must be saved. To save the report, click on the blue 'SAVE' button at the top right of the screen and follow the prompt.

Once the report has been saved you can either share or schedule the report.

If your reports look back at dynamic date ranges like this month or last week, you now have the option to get an alert and a copy of the report as soon as the data is complete for that given range. Scheduling reports allows you to set your own schedule on running reports, and Housecall Pro will automatically send a replication of the report at the designated time. Just like with sharing reports, you will get an email notification with a hyperlink to jump back into Housecall Pro to check your newly generated report.

You will be able to schedule their reports to recur daily, weekly, monthly or a one-time send. If dynamic date ranges are being used, the report will adjust to at the time of send. I.e. if we look at month to date, the report will run from the beginning of the current month through the day the report is scheduled.

How to schedule a report in HCP


To schedule a report in Housecall Pro, follow these steps:

Navigate to the Reporting tab: Select the reporting tab, located at the top of your HCP in your navigation bar.


Select a Report: Choose the specific report you want to schedule. Housecall Pro offers various reports related to jobs, finances, customers, etc. Click on the report title to open it.


Schedule or Share the Report: Look for the blue "SHARE AND SCHEDULE" drop down in the top right corner of your screen activate the drop down. The drop down will allow you to either "Share" or "Schedule" the report. Select "Schedule"


Set Recipients and Frequency:

  • Enter the names of recipients who should receive the report by selecting share in the dropdown menu.

Select the blue 'SHARE' button at the bottom right to save changes.

  • Specify how often you want the report to be sent out by selecting schedule in the dropdown menu. (e.g., daily, weekly, monthly).

Select the blue 'SCHEDULE' button at the bottom right to save changes.


Save and Confirm: After entering all necessary details (employee names, frequency, etc.), save your settings. Review the information to ensure everything is correct.


By following these steps, you can effectively schedule reports in Housecall Pro, ensuring that you and your team receive important business insights automatically and on a regular basis.

You will be able to send any report that has been generated to employees that have report access. This will add the report to their account followed by a message with a static version of the report to the email listed in Housecall Pro. The employee will be able to view a replicated PDF version of the report right from their email. They will also be able to jump over to Housecall Pro to see the report in real time.

All scheduled and shared reports will appear in your Custom Report menu.

Fore more information on updating your report table, check out our help article here:

We also have a dictionary of each metric and what they measure here.

Did this answer your question?