Don't see your plan? Click HERE | To learn more about Subscription Plans, click HERE
Manual Calculation Instructions
The Commission Earnings Report provides both a summary and detailed transactions report of how much each professional made in service sales, product sales, and other sales. You can calculate commission manually by using the rows highlighted in yellow, or you can use the "Commission Earned" columns that automatically calculates commission based off your commission settings.
Run this Report:
In the bottom right of the app tab bar, tap "More" > "Reports" and then select the Commission Earnings Report. Select your Date Range, tap Send, and the report will be sent to the email linked with your GlossGenius account.
Note: Changes to the commission percentages will not reflect in this report until the following business day. For example, if the service commission was originally set to 30%, and then later changed to 35%, you will need to wait one business day until the report will reflect the calculations based on the new percentage.
That being said, the rates will be tracked historically! So if you update the rate annually, you may go back to previous years to review the report with the rate that was previously set for that time period!
Manual Calculation Instructions:
Total price will be the total price of service or product offered excluding tips:
- To calculate service commission off of total service price, go to the summary report, and for each service provider, do: (total service price) MULTIPLIED BY (% commission you set)
- To calculate product commission off of total product price, go to the summary report, and for each service provider, do: (total product price) MULTIPLIED BY (% commission you set)
Net sales will include cancelation fees, and exclude discounts and business payment processing fees:
- To calculate service commission off of net sales:, go to the “service” section of the summary report and for each service provider: (net service sales MINUS tips) MULTIPLIED BY (% commission you set)
- To calculate product commission off of net sales: go to the “product” section of the summary report and for each service provider: (net product sales MINUS tips) MULTIPLIED BY (% commission you set)
- Note that tips should not ever be included in commission calculations. For reference of total tips collected by each team member, please see the “tip earned” row.
Summary Level Report:
Broken out by service provider and at the salon level - A summary of the total price, gross sales, and net sales for:
- Services
- Products
- Other
| Description | Calculation | How to use for Manual Commission Calculation | |
| Name | Name of the service professional | - | - |
| Services | |||
| Number of Services Offered | Number of services offered by the professional in this period |
Total number of services offered in this period |
- |
| Number of Clients Seen | Number of clients seen by the professional in this period | Unique clients seen by the professional in this period | - |
| Total Service Price | Total price of service that the professional offered (does not include tips) | Total sum of sold services | Some members may calculate commission off of this as the “Fully Loaded Amount”. You can multiply this by % commission |
| Gross Payment Amount |
Total amount paid by the client. Accounting for: Future Sale Deposits, Past Deposits, Payment Processing Fees (paid for by the client), Cancelation Fees, Sales Tax, Gratuity, and Discounts |
Gross Sales (sum of all prices of services provided) + Future Sale Deposits (payments received for future appointments) - Past Deposits (payments from older dates than the reporting period belonging to current service appointments) + Client Payment Processing Fee + Cancellation Fees: Fees Charged to the Client by Cancellation + Sales Tax: Taxes for Services or Products + Gratuity: Tips Earned Given by the Customer + Deduct Discounts: Discounts at the Item Level or Charge Level |
- |
| Payment Processing Fees Paid By Business |
Total payment processing fee paid by team member. This type of payment is specified only for wire transfer. Includes fees from prepayments as well. Note: If transaction includes multiple line-items, the fee will be applied to the first line item on the charge |
Total collected from client x (2.6% or 1%) | - |
| Service Discount |
Total sum of the discount specified for service charge and item discounts Note: For discounts which are applied at the charge level - If the charge includes both products AND services, the discount will be applied to the first line item on the charge |
Sum of all charge line items with the type discount, and all discounts on charge line items that are services over this period. | - |
| Net Sales |
Gross Sales + Cancelation Fees - Discounts - Business Payment Processing Fees
Note: Deposits paid for appointments in a future period are not included in net sales, as they will be included when the appointment is completed. |
Gross Sales - Payment Processing Paid for by you, service discount, tax (includes tips) |
Some members calculate commission off of this as the “cost accounted for amount”. To calculate commission: (Net Sales - Tips) * % commission |
| Sales Tax | Sales tax collected based on the % input by the professional in settings | Sales Tax | - |
| Tip |
Total tip collected over the period by the professional. Note: Tip is usually separately paid out 100% to the professional. No commission can legally be taken by the business owner from the professional for tips. |
How much tip was earned by the team member (not counted in commission) | Can deposit directly into team member's account without commission. |
| Commission Earned from Total Price |
Commission earned for services from Total Price over the period by the professional
|
Calculated from your service commission percentages settings | - |
| Commission Earned from Net Sales |
Commission earned for services from Total Price over the period by the professional
|
Calculated from your service commission percentages settings | - |
| Product | |||
| Number of Products Sold | Number of products sold by the professional in this period | Unique number of clients purchasing products in this period | - |
| Number of Clients Seen | Number of clients who purchased a product from this professional in this period | Unique number of clients purchasing products in this period | - |
| Total Product Price | Total price of product that the professional offered (does not include tips or discounts) | Total sum of products original prices sold | Some members may calculate their product commission off of this as the “fully loaded amount”. To calculate, multiply this by % commission. |
| Gross Payment Amount | Total amount paid for by the client. Accounting for: payment processing fees, sales tax, gratuity, discounts |
In this period: Gross Sales (sum of all prices of services provided) + Client Payment Processing Fee + Sales Tax: taxes for services or products + Gratuity: tips earned given by the customer + Deduct discounts: discounts at the item level or charge level |
- |
| Payment Processing Fees Paid By Business |
Total payment processing fees paid by team member. This type of payment is specified only for wire transfer. Includes fees from prepayments as well Note: If transaction includes multiple line-items, the fee will be applied to the first line item on the charge |
Total collected from client x (2.6% or 1%) | - |
| Service Discount |
Total sum of the discount specified for service charge and item discounts. Note: For discounts (which are applied at the charge level), if the charge includes both products AND services, the discount will be applied to the first line item on the charge |
Sum of all charge line items with the type discount, and all discounts on charge line items that are services over this period. | - |
| Net Sales |
Gross Sales - Discounts - Business Payment Processing Fees |
Gross Sales - Payment Processing - Service Discount - Tax (includes tips) |
Some members calculate commission off of this by: (Net Sales - Tips) * % commission |
| Net Sales Minus Cost | Net Sales - Cost | - | Some members can choose whether or not they want to calculate product commission as the “cost accounted for amount.” With automatic calculations, you can toggle this on or off. To calculate commission:(Net Sales Minus Cost - Tips) * % commission |
| Sales Tax | Sales tax collected based on the % input by the professional in settings | Sales Tax | - |
| Tip Earned |
Total tip collected over the period by the professional Note: Tip is usually separately paid out 100% to the user. No commission can legally be taken by the business owner from the professional for tips |
How much tip was earned by the team member (not counted in commission) | - |
| Commission Earned from Total Price |
Commission earned for products from Total Price over the period by the professional
|
Calculated from your product commission percentages settings | - |
| Commission Earned from Net Sales |
Commission earned for products from Net Sales over the period by the professional
|
Calculated from your product commission percentages settings | - |
| Other | |||
| Number of Products Sold | Number of other items sold by the professional in this period | Unique number of clients purchasing products in this period | - |
| Number of Clients Seen | Clients who purchased an other item from this professional in this period | Unique number of clients purchasing products in this period | - |
| Other columns should essentially be the same as for services, as there is no direct product cost attributed to “other” items. | - | ||
Detailed Level Report:
Broken out by service provider, an ITEMIZED BREAKOUT of the total price, gross sales, and net sales for:
- Services
- Products
- Other
| Description | Calculation | |
| Name | Name of the team member | - |
| Date | Date and time of payment Note: This will be the date from when the service was provided | - |
| Provider | Professional who provided the service or sold the product / “other” item – according to checkout | - |
| Charge ID | Charge unique identifier (may be used to find more details on charge by matching this ID from other reports) | - |
| Client | Client name as it is saved in the professionals client list | - |
| Descriptor | The name of paid item, ex, service name, product name, discount, etc. | - |
| Price |
The value of item. -If it is displayed as a positive dollar amount, it is added in the total sum. -If the value is displayed as a negative dollar amount, it should be reduced from the total amount |
- |
| Total Payment Amount | Amount charged for that transaction | - |
| Payment Method |
“Payment Card on File” = Used card on file “Payment Card Manual Entry” = Used scan/enter new card “Payment Card Terminal” = Used CMM “No Show Charged” = Used Mark as No Show (Collect Fee) “Cash” = Used cash |
- |
| Payment Processing Fee Paid By Business | Processing fee amount paid by business for that charge |
If the transaction includes multiple line-items (Service, Product, Other), the fee will be applied to the first line item on the charge (Preferred Order: Service, Product, Other) |
| Discount |
Item level: If customized discount was added for specified service or product, the sum of the provided discount is displayed in this column General level: If discount applied to the overall charge, the discounts the discount will be applied to the first line item on the charge |
- |
| Net Sale |
Gross Sales - Discounts - Business Payment Processing Fees |
Gross Sales minus payment processing, service discount, tax (includes tips) |
| Sales Tax | Sales tax paid by the client |
For sales tax if the charge includes both products AND services, the tax will be applied to the first service or first product |
| Tip earned | Tip collected by the professional from the client | For check-outs which contain a charge with service, product, and tax line items, we assign all tips to services if service and product was checked out in one charge |
| Commission Earned from Total Price |
Commission earned for services or products from Total Price over the period by the professional
|
Calculated from your service or product commission percentages settings |
| Commission Earned from Net Sale | Commission earned for services or products from Net Sales over the period by the professional | Calculated from your service or product commission percentages settings |
Comments
0 comments
Article is closed for comments.