52 Week Tracking Report

Updated 5 months ago by Kory Lamme

Location: Reports > Sales > 52 Week Tracking Report

Detailed summary of weekly sales data for 52 weeks or less to compare from the date you set the report to.

Report shows 52 weeks after the date you choose for a start date, it won't include any previous weeks.

Use Cases by Role

  • Salon Owner: Salon owners can find a lot of value in this report due to the fact that it shows such a large amount of time, and several metrics in a small area.
  • Salon Manager: Salon managers can reference this report to compare performance of the current year to the previous one.
  • Salon Employee: Stylists and other salon staff can use this report to see how well their salon is performing in sales for the given year.

Data Filters

  • Select a Store: Clicking or tapping here will open the interface that allows the user to select the store(s) that will be be used for the report.
  • Enter Start Date: Clicking or tapping into this field will generate a calendar interface for the user to select the day that will be used as the beginning for the purposes of the report.
  • Select Number of Weeks: This drop down menu will give users the opportunity to choose from several different amounts of weeks for the report, with a default value being 52.
  • Select Base Haircut at Salon: For the purposes of pricing and other financial calculations, this drop down is where the user selects the "base" haircut for their location.
  • Generate Report: Clicking or tapping on this button will generate the report based on the other filter criteria.

Generate CSV: Clicking or tapping on this button will open a save dialog that will allow the user to save the report as a comma separated value formatted spreadsheet.

Microsoft Excel or other spreadsheet program will be needed to read the output.

Metrics Tracked

  • Week #: This column will display the week number being examined in the associated row.
  • Week Ending Date: The date when the week is considered finished, as set up by the payroll features.
  • #Of Stylists: The total number of stylists working during the given week.
  • Haircut Price This Week: The price of the "base" haircut during the week associated with this row.
  • #Of Days Open This Week: This column will display the number of days the salon was open for the given week.
  • Haircut Net $: The net amount of revenue generated by haircuts during this given week.
    • %: The percentage of net haircut revenue, compared with all revenue generated for the week.
  • Perm and Color Net $: The net dollar revenue generated by all Perm and color services during the given week.
    • %: The percentage value of net Perm and color revenue, compared with all revenue for the week.
  • Other Services Net $: The net dollar revenue generated by all other services for the week being examined.
    • %: The percentage value of other service revenue, compared with all revenue generated during this week.
  • Net Services $: The net dollar value of all Services performed by the location for the given week.
  • Net Retail $: The net revenue of all retail product sales completed by the salon, for the given week.
  • Retail to Total %: The percentage of retail revenue compared with all revenue generated by the salon for the given week.
  • Net Total Sales $: The total dollar revenue value of both Service and Product sales for the given week.
  • Total Discount $: The total dollar value of all discounts that were applied to sales in the week.
  • Total Client Count: The total number of customers who visited the salon in the week being displayed by the row.
  • New Client Count: The number of clients who visited the salon for the first time in the given week.
    • New %: The percentage of new clients to repeat ones in the week being examined.
  • Repeat Client Count: The total number of clients who visited the salon for the week who were therefore at least the second time.
    • Return %: The percentage value of return customers, compared to all customers who visited the salon for the week.
  • #Men: The total number of salon visitors who were of the established male gender.
    • %: The percentage of visitors to the location who were classified demographically as men.
  • #Women: The total number of salon visitors who were demographically classified as women during the given week.
    • %: The percentage value of salon visitors for the given week who were demographically classified as women.
  • #Kids: The total number of salon visitors for the week who were demographically classified as kids.
    • %: The percentage of total salon visitors for the week who were classified as kids.
  • #Quick Sales: The total number of Quick Sale tickets that were processed during the given week.
    • %: The percentage value of Quick Sale tickets to standard ones, for the given week.
  • Average Ticket: The average dollar value of all tickets processed by SuperSalon, for the given week.
  • Comments Column: Any notes or comments can be added to this column for future reference.
  • Totals and Averages: The bottom row of the report will display average and total values of each column listed.

Report Calculations

  • Haircut Net %: Haircut Net $ divided by Net Service $ then multiply that result by 100.
  • Perm and Color Net %: Perm and Color Net $ divided by Net Service $ then multiply that result by 100.
  • Other Services Net %: Other Net $ divided by Net Service $ then multiply that result by 100.
  • Retail to Total %: Net Retail $ divided by Net Total Sales $ then multiply that result by 100.
  • Net Total Sales $: Net Service $ plus Net Retail $
  • New %: New Client Count divided by Total Client Count then multiply that result by 100.
  • Return %: Repeat Client Count divided by Total Client Count then multiply that result by 100.
  • Men %: # Men divided by Total Client Count then multiply that result by 100.
  • Women %: # Women divided by Total Client Count then multiply that result by 100.
  • Kid %: # Kids divided by Total Client Count then multiply that result by 100.
  • Quick Sale%: # Quick Sales divided by Total Client Count then multiply that result by 100.
  • Average Ticket: Net Total Sales $ divided by Total Client Count then multiply that result by 100.


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)