Skip to main content

Booking Reports

Explore comprehensive booking insights with Appointment, Customer, Audit Trail, Loyalty, Open Slots, Exception, Analytics, Statistics, and Appointment Sheets Reports.

Written by Sabrina Herrera
Updated this week

Click the Report you're investigating within the Table of Contents on the right.

⚠️ Please note: Terms for Appointment, Service, Staff Member, etc. may be different within your account's configuration.

πŸ“… Appointment Report

Click here to learn more

πŸ“ Overview

The Appointment Report allows Headquarters and Location Administrators to retrieve Appointment and Customer details based on selected criteria. Users can select specific items or groups of items to organize data in a way that best meets their reporting needs.

πŸ“Š Appointment Report Uses

The Appointment Report allows users to view, export, print, and analyze appointment and customer details, track appointment activity, identify availability, and save report settings for future use.

πŸ› οΈ Running the Appointment Report

Below are the steps to generate the Appointment Report.

Click here to learn more about Running the Appointment Report

⚠️ Please note: Running reports with large data sets may cause a connection timeout and display an Internal Server Error. If this occurs, reduce the selected date range and run the report again.

  1. Click the Reports tab.

  2. Select Appointment Report on the left.

  3. View Appointment details based on a specific Location or all Locations. (Optional)

  4. Report on up to one year of Appointment data based on either Appointment Date or Created Date.

  5. Select Appointment Types you'd like included in the Appointment Report. (Optional)

  6. Select a specific Staff Member or Service from drop-down lists to limit results. (Optional)

  7. Select Staff Member Types you'd like included in the Appointment Report. (Optional)

  8. Select specific Customers to limit results. (Optional)

  9. Select one or more Appointment Status types. (Optional)

  10. Select Created By to filter Appointments on created by a certain Staff Member or via Customer View. (Optional)

  11. Customer details can also be included, with the exception of Customer credit card information. If your Terms for these specific fields have been altered, that name will appear within this section of the Appointment Report.

  12. Select the Total number of Appointments, Cost or Duration to show in the Appointment Report for additional information. (Optional)

  13. Select your View Option.

    • HTML

      • The HTML view opens the report in a new browser tab.

    • Excel View

      • The Excel view downloads an XLS file containing the same raw data as the HTML report, excluding View and Print options. Giving you options to perform deeper data analysis, create charts and graphs, track trends by Staff Member, Service, or other criteria.

  14. Click Run Report.

βš™οΈ Setting for Selecting Fields

Users can enable additional field options by updating Settings > General Preference #7 to Yes.

Click here to learn more about Setting for Selecting Fields

When enabled:

  • Checkboxes in the Include in Report section are replaced with drop-down lists.

  • Additional fields become available for selection.

  • Certain fields, such as Status, will only appear when using the drop-down option.

πŸ–¨οΈ Printing Appointments

You may print confirmation pages for one or multiple Appointments:

Click here to learn more about Printing Appointments

Once the Appointment Report has been ran, click the Print All button the top left.

πŸ’‘ Pro Tip: You have the option to select individual Appointments using the checkboxes if the entire report doesn't need to be printed.

πŸ’Ύ Saved Report Templates

Saved Report Templates allow users to quickly rerun customized reports without reselecting fields each time.

Click here to learn more about Saved Report Templates

  1. Once you've configured the Appointment Report fields to show in report, enter a Report Name at the bottom the report.

  2. Click Save and Run Report.

Running a Saved Report

  1. Select a saved report from the dropdown at the top of the page.

  2. Adjust the date range as needed.

  3. Click Run Report.

⚠️ Please note: Clicking Save and Run Report again will create a duplicate template. To overwrite an existing template, use Update & Run Report instead.

⏰ Scheduled Reports

Scheduled Reports allow reports to be automatically emailed on a recurring basis.

Click here to learn more about Scheduled Reports

  1. Select an existing Saved Report or create a new one.

  2. Check the Schedule box at the bottom of the page.

  3. Choose Daily or Weekly delivery.

  4. Select the delivery time and day.

  5. Enter the recipient’s email address.

  6. Click Save and Schedule Report.


πŸ‘₯ Customer Report

Click here to learn more

πŸ“ Overview

The Customer Report allows you to access and export Customer data based on criteria you define. Similar to the Appointment Report, this report can be used to export Customer data; however, Appointment information cannot be exported from the Customer Report.

πŸ’‘ Please Note: This report is only available to the following user roles:

  • Headquarters Administrators

  • Location Administrators

  • Location Users (if enabled in Settings)

  • Call Center Users (if enabled in Settings)

πŸ“Š Customer Report Uses

You can use the Customer Report to export your Customer data, create lists of specific types of Customers, merge your Customer database with a Microsoft Word document to create mailing labels.

πŸ› οΈ Running the Customer Report

Below are the steps to access the Customer Report.

Click here to learn more about Running the Customer Report

  1. Click Reports tab.

  2. Click Customer Reports on the left.

  3. In the Filter section, customize the Location(s), Customer Type, Customer Statuses, Genders, Cities, Heard Via, and Birthdates to be included in the report. (Optional)

  4. Customize the Customers Sign up Dates and contact permissions to be included in the report.

  5. In the Include in Report section, select the Customer fields you want displayed in the Report. If these options are left blank, the report will be blank.

  6. Use Total By to display a total count of Customers at the bottom of the report. (Optional)

  7. Select an option from the Sort By dropdown to control how results are ordered. (Optional)

  8. At the bottom of the report, select one of the following View Options.

    • HTML

      • View the report as a web page in your internet browser.

    • Excel

      • View and export the report as a spreadsheet in Microsoft Excel.

    • Telemarketing

      • Select this option to run the Customer Report via the third party telemarketing interface you have enabled.

  9. Click Run Report.

❓ Frequently Asked Questions (FAQs)

Find answers to common questions or additional details that may not be covered in the main instructions.

Click the arrow to view frequently asked questions

Why don’t I see Appointment data in the Customer Report?

Click the arrow to see the answer

The Customer Report is designed only to display and export Customer-related data. Appointment information must be accessed through the Appointment Report.

Why is my report blank after running it?

Click the arrow to see the answer

If no fields are selected in the Include in Report section, the report will return blank results. Ensure at least one field is selected before running the report.

Can I create mailing labels?

Click the arrow to see the answer

You can't create mailing labels in DaySmart Appointments, but you can export your Customer data to Excel (via the Customer Report). Once the data is in Excel and saved on your hard drive, you can use Microsoft Word's mailing label merge feature to create mailing labels.


🧾 Appointment Audit Trail Report

Click here to learn more

πŸ“ Overview

The Appointment Audit Trail report allows Headquarters and Location Administrators to view every change made to an appointment made via Site Administration or Customer View, including who made the change and when it occurred. This report is designed to support auditing and troubleshooting.

⛔️ Please note: In order to have the Appointment Audit Trail feature and Report enabled, please contact our Support team.

πŸ› οΈ Running the Appointment Audit Trail Report

Below are the steps to Access the Appointment Audit Report.

Click here to learn more about Running the Appointment Audit Trail Report

  1. Click Reports tab.

  2. Click Appointment Audit Trail Report on the left.

  3. Select the Location(s) to include. (Optional)

  4. Set the Date Range: Appointment scheduled date or Appointment creation date.

  5. Select specific Customers to include. (Optional)

  6. At the bottom of the report, select one of the following Format Options.

    • HTML

      • View the report as a web page in your internet browser.

    • Excel

      • Opens a spreadsheet alternative where each row represents a record and commas separate data fields.

  7. Click Run Report.

πŸ“… Captured Appointment Changes

The report captures all changes to an appointment, including:

Click here to learn more about Captured Appointment Changes

  • Staff member assigned to the appointment.

  • User who executed the action (create or update).

  • Primary service only (add-ons are not included).

  • Appointment date.

  • Start time.

    • End time and duration are not recorded

  • Appointment status.

  • Appointment-level field information.


πŸŽ–οΈ Customer Loyalty Report

Click here to learn more

πŸ“ Overview

The Customer Loyalty report allows Headquarters and Location Administrators to view a list of your most frequent and loyal Customers based on their history. However, the Customer Loyalty report is specifically designed to generate a list or group of Customers based on the number of Appointments they have previously scheduled.

πŸ› οΈ Running the Customer Loyalty Report

Follow these steps to navigate to and open the Customer Loyalty report within the Reports section.

Click here to learn more about Running the Customer Loyalty Report

  1. Click on the Reports tab.

  2. Select the Customer Loyalty Reports on the left.

  3. Select the Location(s) to be included in the Report. (Optional)

  4. Enter a date range (up to 1 calendar year) for the Appointments.

  5. You may specify the Service, Staff Member, and Customer Type to be included in the Report. (Optional)

  6. Select specific Appointment Statuses to be included in the Report. (Optional)

  7. Enter a number in the Customers With Appointments or More field.

    • For example: Enter 3 to generate a list of Customers with at least 3 Appointments during the selected date range.

      πŸ’‘ Pro tip: A unique feature of the Customer Loyalty report is the ability to include only Customers who have scheduled a specific number of Appointments.

  8. Select from several fields to be included in Report. From Location, Customer Name, Address, Phone Number, Email, Appointment Status and the Number of Appointments booked. If these options are left blank, the report will be blank.

  9. You have the option to sort the report by Location, Name, City, State and Zip Code. (Optional)

  10. At the bottom of the report, select the View Option.

    • HTML

      • The HTML view opens the report in a new browser tab.

    • Excel

      • View and export the report as a spreadsheet in Microsoft Excel.

  11. Click Run Report.
    ​

πŸ“‹ Report on Customers with No Appointments

The Customer Loyalty report supports entering zero (β€œ0”) in the Customers with field.

Click here to learn more about Reporting on Customers with No Appointments

When 0 is entered, the report will generate a list of Customers who have no past or future Appointments in the scheduling system.

This can be useful for identifying inactive Customers.

❓ Frequently Asked Questions (FAQs)

Find answers to common questions or additional details that may not be covered in the main instructions.

Click the arrow to view frequently asked questions

Who can access the Customer Loyalty report?

Click the arrow to see the answer

Only Headquarters Administrators and Location Administrators have access to this report.

What is the maximum date range I can select?

Click the arrow to see the answer

The date range is limited to one calendar year.

Can I generate a list of Customers with no Appointments?

Click the arrow to see the answer

Yes. Enter 0 in the Customers with field to generate a list of Customers who have no past or future Appointments scheduled.


πŸ•³οΈ Open Slots Report

Click here to learn more

πŸ“ Overview

The Open Slots Report creates a list of all time slots for each active schedule and displays both how many slots are available and how many slots have been taken.

Staff Members can print individual schedules or groups of schedules using this report.

β›” Please note: The Open Slots Report will only appear when using the Multiple Appointments Per Time Slot version. If using the Single Appointment version, we recommend using the Appointment Sheets Report instead.

πŸ”‘ Authorizations

Below are the following Access Types for Staff Members this report is available to.

Click here to learn more about Authorizations

  • Headquarters Administrators

  • Location Administrators

  • Location Users (if enabled in Settings)

  • Call Center Users (if enabled in Settings)

πŸ“Š Running the Open Slots Report

Follow the steps to generate this report.

Click here to learn more about Running the Open Slots Report

  1. Click on the Reports tab.

  2. Select the Open Slots Report on the left.

  3. Select the Location(s) you would like to view appointments for. (Optional)

  4. Select the Appointment Dates you would like to view. The date range defaults to the current date.

  5. Select a specific Staff Member (Schedule). (Optional)

  6. Check the option to Include Staff Members Without Slots if you need to see schedules that do not have time slots created.

  7. Select an Appointment Status to filter the report by a specific status. (Optional)

  8. Choose a View Option.

    HTML

    • Allows you to view the report as a web page within your internet browser.

    Excel

    • Allows you to view the report as a spreadsheet in Microsoft Excel.

  9. Click Run Report.



🚨 Appointment Exception Report

Click here to learn more

πŸ“ Overview

The Appointment Exception Report allows Headquarters and Location Administrators to view all appointments, within a selected date range, that were scheduled at a location other than a customer’s original location (also known as their Home Location). This report is useful for identifying where customer records are being created, gaining visibility into potential scheduling inefficiencies, and reviewing appointment activity across different locations.

⛔️ Please note: The Appointment Exception Report is only available for accounts with multiple locations.

πŸ—‚οΈ Terms

Review key definitions used in this report, Cancelled Appointments and Appointments marked as No Show, are not included in the results.

Click here to learn more about Terms

Home Location

The location a customer is assigned to. In most cases, customer records are automatically assigned to the location where their first appointment was created.

🧠 Example: If a customer registers and creates their first appointment at Location A, their Home Location will be Location A.

Serving Location

The location where the appointment was actually scheduled. The report results display the Serving Location for each appointment.

First of Period

This column indicates whether the customer had previously scheduled an appointment at the selected Serving Location before the chosen reporting period.

πŸ› οΈ Running the Appointment Exception Report

Below we will learn how to navigate to and open the Appointment Exception Report.

Click here to learn more about Running the Appointment Exception Report

  1. Click the Reports tab.

  2. Select Appointment Exception Report on the left.

  3. Select a location from the Select Location drop-down. (Optional)

  4. Choose the Appointment Dates.

  5. Click Run Report. The report will automatically open in a new browser window.



πŸ“Š Appointment Analytics

Click here to learn more

πŸ“ Overview

The Appointment Analytics report allows Headquarter Administrators to compile appointment data created within your scheduling system to review key scheduling metrics for a specific date range for evaluating scheduling performance, service utilization, and booking behavior.

πŸ› οΈ Running the Appointment Analytics Report

Below we will review the steps to run and view the Appointment Analytics Report.

Click here to learn more about Running the Appointment Analytics Report

  1. Click on the Reports tab.

  2. Select the Appointment Analytics Report on the left.

  3. Select the Statistic type you would like to view.

  4. Select a Location from the drop-down list. (Optional)

  5. Choose an option from the Services to Include drop-down. (Optional)

  6. Select a Start Date.

  7. Choose an option from the Start Week On drop-down.

  8. Select a Period (Day, Week, or Month).

  9. Enter the number of Periods to Show.

  10. Select the Statuses to Include.

  11. Use the checkboxes to adjust what options to Include Stats On.

  12. Click Show Statistics.

πŸ“ˆ Statistic Options

Below we will review each Statistic option provides a different breakdown of appointment data.

Click here to learn more about Statistic Options

If Customer View scheduling is enabled, this report provides statistical insights into the number of appointments scheduled and the percentage of appointments booked through the Customer View (Front End) and Site Administration.

Total Appointments

Lists appointment totals and provides a link to view appointment details for each day.

Customer View VS Site Administration

Lists appointments created through:

  • Customer View (Front)

  • Site Administration (Admin)

Each appears on separate rows for comparison.

Appointments by Staff Member

Lists appointment totals for each Staff Member.

Appointments by Service

Lists appointment totals for each Service.

Appointments by Status

Lists appointment totals for each Appointment Status.

πŸ’‘ Pro tip: Click the blue underlined number to be linked to the appointment details page

βš™οΈ Filter & Display Options Explained

Customize how your appointment data is organized and displayed by selecting specific filters, date ranges, statuses, and reporting periods.

Click here to learn more about Statistic Options

Location

Select a specific location to view statistical information for that site.

Services To Include

Determines which types of appointments are included in the report.

Start Date

Choose the date from which the report will begin pulling statistical data.

Start Week On

Modifies which day of the week appears first in the report.

Period

Organize report data by:

  • Day

  • Week

  • Month

Periods To Show

Represents how many days, weeks, or months will be displayed starting from the selected Start Date.

Statuses To Include

Primarily used to remove Cancelled appointments from the report.

Include Stats On

Use the available checkboxes to adjust what data points are included in the statistics.



πŸ“ˆ Statistics Report

Click here to learn more

πŸ“ Overview

The Statistics Reports allows Headquarters and Location Administrators to compile data created within your account to review basic scheduling metrics for a specific date range. These reports provide insight into appointment activity and customer signups.

πŸ’‘ Pro tip: Signups are created when a customer record is added to the system. This applies when a customer record is added through the Customer View or Administrative View.

πŸ› οΈ Running the Statistics Report

Below are the steps to access the Statistics Report.

Click here to learn more about Running the Statistics Report

  1. Click on the Reports tab.

  2. Select the Statistics Reports on the left.

  3. Start with the Select Location dropdown to view data for a specific location or all locations. (Optional)

  4. Use the Appointment Dates or Signup Dates section to select a date range. This will default to the current date.

  5. Choose one of the predefined report types from the Include in Report section.

  6. Click the Run Report.

πŸ“ˆ Statistic Report Types

There are multiple predefined Statistics Report types available. Each report provides a different breakdown of appointment and customer data.

Appointment Statistic Reports

Click here to learn more about Appointment Statistic Reports Types

Appointments by Staff Member

Shows the number of appointments and the average appointments per day for each Staff Member profile.

Appointments by Service

Shows the number of appointments and the average appointments per day for each Service.

Appointments by Add-on Service

Shows the number of appointments and the average appointments per day for each Add-on Service.

Appointments by Customer Type

Shows the number of appointments and the average appointments per day for each Customer Type.

Appointments by Status

Shows the number of appointments and the average appointments per day for each Appointment Status.

Customer Statistic Reports

Click here to learn more about Appointment Statistic Reports Types

Signups by Lead Type (Heard Via Type)

Shows the number of customer records by Lead Type.

Signups by Customer Type

Shows the number of customer records by Customer Type.

Signups by Customer Name and Service

Shows the following details for each appointment:

  • Customer Name

  • Date

  • Service

  • Staff Member

  • Appointment Status


πŸ“‹ Appointment Sheets Report

Click here to learn more

πŸ“ Overview

The Appointment Sheets report allows Headquarters and Location Administrators to view a list of appointments for a specific date range. This report can be used to print individual schedules or groups of schedules for easy reference.

⛔️ Please note: The Appointment Sheets report will not display when using the Multiple Appointments Per Time Slot version. In this case, use the Open Slots Report instead.

πŸ› οΈ Running the Appointment Sheets Report

Follow these steps to navigate to and open the Appointment Sheets report from the Reports tab.

πŸ’‘ Pro tip: The Appointment Sheets report will not display when Appointments Preference #29 is set to Yes. Appointment Sheets can only show one appointment per time slot.

Click here to learn more about Running the Appointment Sheets Report

  1. Click the Reports tab.

  2. Select the Appointment Sheets Report on the left.

  3. Select the Location you would like to view appointments for. The Location drop-down will default to the location you were in when you first clicked the Reports tab. (Optional)

  4. Select the Appointment Dates you would like to view. The date range will always default to the current date.

  5. Choose the Additional Information fields you would like to include in the report. You may include:

    β€’ Company (Employer)

    β€’ Phone Numbers (Daytime, Evening, & Cell)

    β€’ Birth Date

    β€’ Service

    β€’ Account Number (Account)

    β€’ Notes from Customer (Special Instructions from/for Customer)

  6. (Optional) Add up to 4 Additional Blank Columns by entering:

    • A Field Title

    • A Field Width value

    • These blank columns can be used by staff to manually fill in additional information when viewing a printed report. For example: Add a column so staff can check off completed appointments.

  7. Choose a Row Height to determine the size of the rows in your report. Selecting Expanded Height will double the size of each row.

  8. Select Yes or No for Display Name in Header. Selecting Yes adds your Company Name (found in: Settings > Location Information) to the header section of the report.

  9. Add a Sheet Title, if applicable. The Sheet Title will appear in the header section of the report.

  10. Add Sheet Header Notes, if applicable. These notes will appear below the Date(s) in the header section.

  11. Check the box next to Page Breaking to list schedules vertically instead of horizontally. (Optional)

  12. Check the Include on Report box for each schedule you would like included.

  13. Select your View Option.

    • Standard View

      • Schedules are listed horizontally.

      • A single header is shown for all schedules.

    • Page Breaking Enabled

      • Schedules are listed vertically.

      • Each schedule includes a separate header section.

  14. Click Run Report.

Did this answer your question?