User Tools

Site Tools


view_franchise_reports

View Franchise Reports

You can access the franchise reports by clicking “Franchise Reports” from the program's opening page. Then choose Choose “Summary of Studio Business Report”, “Weekly Royalty Report”, or “Staff Performance Report” from the report list, then choose the Week Ending date for the report. Press the View button to view the report in .pdf format. Print the report by clicking the print button in the .pdf viewer.

Summary of Studio Business Report

The studio business report shows totals for cash receipts, inquiries, lessons taught, active students, and sales. All values, to the best of our knowledge, are according to Arthur Murray specifications.

Cash Receipts

Lists the amount of money actually received by the studio this week.

  • Cash: Cash, checks and credit card payments to the studio for enrollments
  • Budget: Nothing in the program fills this in, but you can edit it manually
  • Misc: Money received that was not for enrollments (such as competition entry money)
  • Total Gross: Cash + Budget + Misc
Inquiries
  • Contact: The number of inquiries entered for the week
  • Booked: The number of students who came from an inquiry, and had their first lesson scheduled this week
  • Showed: The number of students who came from an inquiry, and had their first lesson scheduled and verified this week
Lessons Taught
  • Pvt Intv: Lessons taken during a student's first 12 units, and not using a department 4 enrollment
  • Pvt Ren: All other lessons
  • # In Class: The combined attendance of group lessons from this week
Active Students

This section lists the number of students who took lessons this week. A student is listed as renewal if they have at least one Back Department (Renewal) enrollment. Otherwise, they are listed as interview. If party tracking is enabled in your configuration an additional field, “Supplementary Practice”, will give the combined attendance of all parties.

Unit Sales Tracking

This portion gives information about the unit enrollments tried and sold this week, divided by the section chosen for the enrollment. The top row lists number of enrollments tried or proposed (T) and sold (S). The second row gives the total number of units sold for that section, and the third row gives the dollar amount of the sales. The adjust column lists the units and dollar amounts of cancellations and refinanced lessons.

Non-Unit Sales

These values come from enrollments this week where the “Enrollment for” field was changed to “Non-Unit Private/Coach” or “Non-Unit Class”.

Misc Sales

The dollar value of miscellaneous payments which were due this week.

These are the default values that are generated. You can manually edit the values that will be displayed on the Summary of Studio Business Report. See Edit Summary of Studio Business Report for more information on this.

This franchise report is unique in that its weekly values are not automatically generated every time the report is viewed. The first time the report is viewed, the values will be calculated and saved. Subsequently, those stored values will be used when the report is viewed, unless the “Generate” button is used. The “Generate” button will recalculate the weekly values and display the report. The “Generate” button should never be used after the Summary of Studio Business Report has been printed and submitted (see Generate or View).

Year to Date and Previous Year to Date values can be automatically calculated, if you turn on the appropriate options in the configuration. They will be calculated from the saved values of previous reports. If those reports have not been generated, the values can be manually entered.

Weekly Royalty Report

The royalty report lists every payment received during that week.

  • Date: The Date the Payment was made
  • Student's Name in Full: The first name and lastname from the student's information
  • Closer/Staff Member: The initials of the instructor and staff member given credit for the sale on the enrollment this payment is paying for
  • Enter − Orig. Ext. Ren or A/C: Comes from the section chosen for the enrollment this payment is paying for
  • Lessons & Amount Program or Service: The number of units and dollar value of the enrollment this payment is paying for, or the notes entered on a miscellaneous payment
  • Studio Receipts: The amount of the payment, not including taxes or loan fees
  • Total Subject to R/S Fees: This will be the same as the studio receipts total
  • Sundry: This is always 0
  • Studio Grand Total: This will be the same as the studio receipts total

The refund section must be completed manually for any refunds. The royalty percentages should also be entered and the total calculated.

Staff Performance Report

The staff performance report lists each instructor and executive who taught or sold a lesson in that week. For each instructor, the report lists the following:

  • Number of Guests: this number is gathers from the number of inquiries from this week where a current student was selected for the “Guest of” field. A student's guests are credited to the student's primary instructor.
  • Lessons Taught: list the number of private lessons taught and the cumulative attendance of group classes taught by the instructor.
  • Value Misc Sales: these are not automatically filled, and must be manually written in
  • Value Lesson Sales: The net dollar value and unit amount of enrollments where the instructor was listed as responsible for the sale. Whether an enrollment is listed as interview or renewal depends on whether Front Department (Interview) or Back Department (Renewal) was chosen when making the enrollment.
view_franchise_reports.txt · Last modified: 2018/11/01 13:34 (external edit)